[Development] Simple Account View

[Akerius]

Hello RageZoners,

Im Developing Simple Account View, that can access Players Info w/o going to SQLSERVER..

As of now, im done with info view, so im thinking more info, that i can provide in the system...

Spoiler

And...

Editing Features will be put on the system >.<

Account Viewer 1.0

Spoiler

Features:
• Can View Account and Character Info
• Can Update Game Authorization

if you want to test it heres the link:

To view the content, you need to sign in or register

if .exe is not working (missing DLL), try the setup.exe

To view the content, you need to sign in or register

Delete char and account are disabled, im not doing it yet

 

[Resonance03]

Protip: Add inventory viewing/modifying features for the characters.

Also, are you setting this up so that it has to be run with the SQL server on localhost, or do you have it configured to support WAN connections?

 

[Akerius]

Protip: Add inventory viewing/modifying features for the characters.

Also, are you setting this up so that it has to be run with the SQL server on localhost, or do you have it configured to support WAN connections?

i doesnt work on WAN, only for owners view, and no need to configure sql to run this, i used existing odbc connection... my problem now is, not all users can run this, dll prob and etc... so ive decided to reprogram this on vb.net former vb6... but i need time for doing it, because my schooling (sponsored by the company) on .net starts on feb 20

and thanks for the tip

 

[Xakzi]

make it able to edit an account through (with?) the program, would be a neat thing to do ^^

 

[Joey]

Or make it open source?

 

[Gravious]

No need for that.

Get your favorite programming langauge, create an SQL connection, execute some queries and fetch the result, display the results in an UI and done you are.

Or code it on your website, even easier.

EDIT:
Hello Joey.

 

[spikensbror]

Wow, why are you using native Visual Basic?
Isn't it discontinued since first version of .NET came out?
Maybe it's just the icon that's misleading me though.

 

[Jomex]

I found a bug, where when my account has authority "Z" and my characters have another authority set it doesn't find them.

 

[Matt Clarke]

Nice little project you have here. I'd look forward to seeing it be completed. =)

 

[vamt02]

hope akerius can finish this with the
"delete" character

Nice Release for this

 

[שเ๒єtгเ๒є]

would it be neccessary? since when u must delete members characters. a ban account function would be interesting, though. its alot of easier too.

 

[vamt02]

would it be neccessary? since when u must delete members characters. a ban account function would be interesting, though. its alot of easier too.

delete account would be kewl

 

[Gravious]

delete account would be kewl

DELETE FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE account='accountName'
DELETE FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL_DETAIL] WHERE account='accountName'
DELETE FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE account='accountName'

that would leave pieces lying around in some tables, but I assume you don't mind.

 

[ShadowDragon]

DELETE FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE account='accountName'
DELETE FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL_DETAIL] WHERE account='accountName'
DELETE FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE account='accountName'

that would leave pieces lying around in some tables, but I assume you don't mind.

Lol, a comprehensive delete function which doesn't leave any leftover pieces, would be quite complex. At the very least, it would need to get the m_idPlayer values for each character on the account, and use those to delete all the information from the CHARACTER_01_DBF tables (and possibly other values would be needed to get everything).

 

[שเ๒єtгเ๒є]

its useless to delete any accounts as i said. not even cuz of the complexity ... what if u ever decide to recover an account, u arent able to do that anymore, so.

 

[ShadowDragon]

its useless to delete any accounts as i said. not even cuz of the complexity ... what if u ever decide to recover an account, u arent able to do that anymore, so.

The solution to that would be to create completely separate databases that have empty copies of ACCOUNT_DBF and CHARACTER_01_DBF. You copy the account info that's going to be deleted into those databases, and then delete it from the original ones.

 

[שเ๒єtгเ๒є]

The solution to that would be to create completely separate databases that have empty copies of ACCOUNT_DBF and CHARACTER_01_DBF. You copy the account info that's going to be deleted into those databases, and then delete it from the original ones.

not bad idea, but what if u delete account xxx, and somebody creates account xxx again, and u want to delete it the new one again too, u will have doubled entries, u will still need to keep the account entry to avoid people will create same name accounts, or it will rain of errors, whenever u recover an account that has been created again or whenever u delete an account that holds a name of an old account u deleted before.

 

[Quget]

Instead of delete make it ban the account.

 

[שเ๒єtгเ๒є]

Instead of delete make it ban the account.

my words lol. >.>

 

[ShadowDragon]

not bad idea, but what if u delete account xxx, and somebody creates account xxx again, and u want to delete it the new one again too, u will have doubled entries, u will still need to keep the account entry to avoid people will create same name accounts, or it will rain of errors, whenever u recover an account that has been created again or whenever u delete an account that holds a name of an old account u deleted before.

Lol, you can keep coming up with problems and I can keep coming up with solutions. I had a bit of experience with the eFlyff channel merging, when they combined pairs of channels into single ones. If there were duplicate character names, they added a 1 to the beginning of the name and the next time the character logged in, they got a free name change. If you're going to recover an account that has already been remade, just change the name lol same with char names.