[COMING] Dekaron Admin (MSSQL Manager)

[Nosferatu.]

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

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

SELECT user_no, user_id,user_pwd,login_flag FROM account.dbo.USER_PROFILE;

data\queries\character.sql

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

SELECT id,user_no,group_id,amount,free_amount FROM cash.dbo.user_cash WHERE user_no='%s'

data\queries\bag.sql

SELECT character_no,wIndex FROM character.dbo.user_bag WHERE character_no='%s';

data\queries\suit.sql

SELECT character_no,wIndex FROM character.dbo.user_suit WHERE character_no='%s';

data\queries\store.sql

SELECT character_no,wIndex,dwPrice FROM character.dbo.USER_STORE WHERE character_no='%s';

data\queries\storage.sql

SELECT character_no,wIndex FROM character.dbo.user_storage WHERE character_no='%s';

data\queries\postbox.sql

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

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 ....

[Underfisk]

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 :

[Nosferatu.]

Originally Posted by Underfisk

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 -.-

[[DEV]Dekaron]

nice job guys

[Underfisk]

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

[freez00]

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.

[Underfisk]

@ 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.

[Nosferatu.]

Originally Posted by Underfisk

@ 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

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..

[Underfisk]

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

[Farius~]

Originally Posted by freez00

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

[Nosferatu.]

Originally Posted by Farius~

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

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: