Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 17:28

  • Please register to post and access all features, it's quick, easy and FREE!

 

[COMING] Dekaron Admin (MSSQL Manager)

Reply
 
Old   #1

 
elite*gold: 20
Join Date: Jan 2008
Posts: 688
Received Thanks: 412
[COMING] Dekaron Admin (MSSQL Manager)

Hello Epvp, ...

i have create a tool to Manage Easy Account / Characters. You can configure the Querie CommandText by yourself if you need to edit it.



data\Connectionstring.ini
Code:
Provider=SQLOLEDB.1;Password='%s';User ID='%s';Initial Catalog=account;Data Source='%s';Use Procedure for Prepare=1;Auto Translate=True;
data\queries\account.sql
Code:
SELECT user_no, user_id,user_pwd,login_flag FROM account.dbo.USER_PROFILE;
data\queries\character.sql
Code:
SELECT character_no,character_name, user_no, dwMoney, wStr, wDex, wCon, wSpr, wStatPoint, wSkillPoint, wLevel FROM character.dbo.user_character WHERE user_no='%s' ORDER by ipt_time ASC;
data\queries\cash.sql
Code:
SELECT id,user_no,group_id,amount,free_amount FROM cash.dbo.user_cash WHERE user_no='%s'
data\queries\bag.sql
Code:
SELECT character_no,wIndex FROM character.dbo.user_bag WHERE character_no='%s';
data\queries\suit.sql
Code:
SELECT character_no,wIndex FROM character.dbo.user_suit WHERE character_no='%s';
data\queries\store.sql
Code:
SELECT character_no,wIndex,dwPrice FROM character.dbo.USER_STORE WHERE character_no='%s';

data\queries\storage.sql

Code:
SELECT character_no,wIndex FROM character.dbo.user_storage WHERE character_no='%s';
data\queries\postbox.sql
Code:
SELECT character_no,from_char_nm,post_title,body_text,item_tag,wIndex,include_dil FROM character.dbo.USER_POSTBOX WHERE character_no='%s';
Merged Dekaron Items in

data\csv\itemetc.csv
Code:
3151,"Santa's Hat 2009",,,,,,,,,,,,,,,,,,,,,,
3152,"Santa's Hat 2009",,,,,,,,,,,,,,,,,,,,,,
3153,"Santa's Hat 2009",,,,,,,,,,,,,,,,,,,,,,
3154,"Santa's Hat 2009",,,,,,,,,,,,,,,,,,,,,,
3155,"Santa's Hat 2009",,,,,,,,,,,,,,,,,,,,,,
3156,"Santa's Hat 2009",,,,,,,,,,,,,,,,,,,,,,
3157,"Santa's Hat 2009",,,,,,,,,,,,,,,,,,,,,,
3158,"(E)Dice",,,,,,,,,,,,,,,,,,,,,,
3159,"Undefeated Beanie (Beige)",,,,,,,,,,,,,,,,,,,,,,
3160,"Undefeated Beanie (Brown)",,,,,,,,,,,,,,,,,,,,,,
3171,"Santa's Hat (AK)",,,,,,,,,,,,,,,,,,,,,,
3172,"Santa's Hat (Hunter)",,,,,,,,,,,,,,,,,,,,,,
3173,"Santa's Hat (Mage)",,,,,,,,,,,,,,,,,,,,,,
3174,"Santa's Hat (Summoner)",,,,,,,,,,,,,,,,,,,,,,
3175,"Santa's Hat (Seg)",,,,,,,,,,,,,,,,,,,,,,

... 26743 lines later ....



Nosferatu. is offline  
Thanks
4 Users
Old   #2
 
elite*gold: LOCKED
Join Date: Oct 2016
Posts: 302
Received Thanks: 78
I have done it, but nice to see another project
btw if you need to check something, check out my github and get the source code :


Underfisk is offline  
Thanks
1 User
Old   #3

 
elite*gold: 20
Join Date: Jan 2008
Posts: 688
Received Thanks: 412
Quote:
Originally Posted by Underfisk View Post
I have done it, but nice to see another project
btw if you need to check something, check out my github and get the source code :
My program works quite differently. With my program you click the one you want to edit and finished. No search. My Livemap shows only the selected character not the 900 Characters from Database.

The source code I can not use, I work with Pascal

Try my Alpha version of Dekaron Admin

my livemap goes crazy idk... never have the exactly postion of a player -.-
Attached Files
File Type: rar dkadmin_neu_livemap_korr.rar (6.29 MB, 38 views)
Nosferatu. is offline  
Thanks
2 Users
Old   #4
 
elite*gold: 0
Join Date: Jul 2015
Posts: 407
Received Thanks: 115
nice job guys


[DEV]Dekaron is offline  
Old   #5
 
elite*gold: LOCKED
Join Date: Oct 2016
Posts: 302
Received Thanks: 78
Btw i do not show 900 chars online i just show per map whos there but ye my program workflow seems to be diff as far i see in your video, but when i have time i'll add the compatibility for A3 and then i can consider the basic stuff as done
Underfisk is offline  
Old   #6
 
elite*gold: 0
Join Date: Jun 2011
Posts: 413
Received Thanks: 136
Very nice. Don't forget to add the option to define the port for your sql server if you're not using port 1433. Same for MYSQL, not everyone uses 3306 for it.
freez00 is offline  
Thanks
1 User
Old   #7
 
elite*gold: LOCKED
Join Date: Oct 2016
Posts: 302
Received Thanks: 78
@Nosferatu making the Livemap via sql connection its quite hard to get the exactly position because it gets updated with high delay so you dont have 100% of detection where they are.
As guesswho mentioned to me before and yes its probably the best to get "live" people, its making client side send message to your app, getting the players packets.
Underfisk is offline  
Old   #8

 
elite*gold: 20
Join Date: Jan 2008
Posts: 688
Received Thanks: 412
Quote:
Originally Posted by Underfisk View Post
@Nosferatu making the Livemap via sql connection its quite hard to get the exactly position because it gets updated with high delay so you dont have 100% of detection where they are.
As guesswho mentioned to me before and yes its probably the best to get "live" people, its making client side send message to your app, getting the players packets.
I know. I mean Coordinates wPosX , wPosY Image is 512 x 512

Code:
Player.Top:=LiveImage.Top+wPosY;
Player.Left:=LiveImage.Left+wPosX;
Player is the green Circle (Dot) and Livemap is minimap (dds) converted to JPG
something is wrong ... idk..
Nosferatu. is offline  
Old   #9
 
elite*gold: LOCKED
Join Date: Oct 2016
Posts: 302
Received Thanks: 78
My max map is 512x512, and you dont need to increment top or left, atleast with Canvas. You just need to get the player position and draw it directly, but ofc make canvas max as 512x512 and in dekaron where you are querying, there is no way the player be out of 512 normally
Underfisk is offline  
Old   #10
 
elite*gold: 0
Join Date: Jun 2013
Posts: 373
Received Thanks: 170
Quote:
Originally Posted by freez00 View Post
Very nice. Don't forget to add the option to define the port for your sql server if you're not using port 1433. Same for MYSQL, not everyone uses 3306 for it.
this is right, please add this option
Farius~ is offline  
Old   #11

 
elite*gold: 20
Join Date: Jan 2008
Posts: 688
Received Thanks: 412
Quote:
Originally Posted by Farius~ View Post
this is right, please add this option
Yes i will do it :-)

or ...
  • go to data\connectionstring.ini and open it.
  • search for: Data Source='%s'; and ad difrent port like this: Data Source='%s,1433';
  • Restart DKAdmin or Reload Queries

Code:
Provider=SQLOLEDB.1;Password='%s';User ID='%s';Initial Catalog=account;Data Source='%s,1433';Use Procedure for Prepare=1;Auto Translate=True;
More about Mssql Connectionstring here:


Nosferatu. is offline  
Thanks
1 User
Reply



« Previous Thread | Next Thread »

Similar Threads
[Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files
First you need MSSQL Server + MSSQL Manager Serve + Server Filesr Download Link : -Mssql Manager + Mssql Server -Server Files - Downlaod...
662 Replies - SRO Coding Corner



All times are GMT +1. The time now is 17:28.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.