[Release] Aion DB Manager V1.0

[Hikaru_K]

Sorry guys, I don't have much time to update this post ( I'll do it as soon as possible. I ran out of vacations. Alternatively you can check an updated post (ver 1.1) in the Aion Unique Forums http://www.aion-unique.org/viewtopic.php?f=10&t=2656

Thanks

[foxfirediego]

Ok I did some research. The odbc connections of this tool are not compatible with a 64 bit OS by default.

There's a workaround involving the redirection of the 32bit odbc driver in your Data Sources Administrator.

Read here:

http://support.microsoft.com/kb/942976

or here:

http://social.msdn.microsoft.com/For...b-7fc454012f91

I don't have a 64 OS right now, I'm afraid I can't test this. If you can solve this issue, let me know.

This did it.

[cypher]

Installation:

I'm using Windows XP, and assuming you already have your Aion Server Installed including the databases with the

default names (au_server_gs and au_server_ls)

You need to install this software first in order to use this Editor: (All mandatory) (Skip this if you

already have them)

- Microsoft Access (The version I'm using to work on this is Access 2003, I haven't tested the functionality

with other versions, but it should work with Access 2000, 2003 or 2007) Test it.
- MySQL Connector (ODBC Driver for MySQL): http://www.mysql.com/downloads/connector/odbc/
- Microsoft XML Parser (MSXML) 3.0:

http://www.microsoft.com/downloads/d...displaylang=en

After you install all this, you need to create 2 System DSN entries to link MS Access with the Aion Databases

(au_server_gs and au_server_ls)

You have to create them with this names.

AionGS
AionLS

Go to you windows Control Panel -->> Administrative Tools -->> Data Sources (ODBC)

Follow the images for a HOW TO:








Once you got all the software installed and created the system DSN, you can proceed to Install Aion DB

Manager. Use the installer provided (test it!) Report any issues please!
In the installation process it will ask you to install DBpix (Install it with the default values) and will ask you

to import a value into the registry for DBpix (Import it). Finish the installation.
DBpix is an utility for MS Access to interact with the images in the database. (To add images into the items

database)

That's it

Open the Aion Database Manager, and test it!

Why do you use ADO when you can have the .NET connector. Also on the account manager you could have at leas to decrypt the password an on save to encrypt it again. I like your graphics on the app but you went a bit too complicated with it. Did you remember to compress your app to make sure nobody steals your code?

[Hikaru_K]

This did it.

Nice!!! Maybe you can explain how did you do it and help people here with the same issue :)

Thanks.

Why do you use ADO when you can have the .NET connector. Also on the account manager you could have at leas to decrypt the password an on save to encrypt it again. I like your graphics on the app but you went a bit too complicated with it. Did you remember to compress your app to make sure nobody steals your code?

Thank you, and thanks for the advices, I can take care of some.

About the password, I understand SHA-1 hashes cannot be reversed unlike base64, so I think I can't decrypt any password, just encrypt them. If you have any information that differs from this, it would be helpful.

What does exactly this means?: "I like your graphics on the app but you went a bit too complicated with it"

[cypher]

Nice!!! Maybe you can explain how did you do it and help people here with the same issue :)

Thanks.



Thank you, and thanks for the advices, I can take care of some.

About the password, I understand SHA-1 hashes cannot be reversed unlike base64, so I think I can't decrypt any password, just encrypt them. If you have any information that differs from this, it would be helpful.

What does exactly this means?: "I like your graphics on the app but you went a bit too complicated with it"

Your right i never actually looked over the login methods. I thought it only uses Base64. As for the complicated way is the number of lines you wrote on this app. It would've been a lot easier if you were using a .NET platform.

[bogdan1991]

hello do not know DC does not go to all the programs I have installed and you try to start "Aion Database Manager" appears that

[Ikhoc]

hello do not know DC does not go to all the programs I have installed and you try to start "Aion Database Manager" appears that

Setup Microsoft Acces or Office

[oncars]

good man

[WesleyE]

Nice work, thanks.

[amarin075]

thank you verry much..

[haxbox1711]

Working on 64 bit OS, with Microsoft Office 2010 trial. After the mxml file in sys 32 was replaced. Good work and thank you...

The only question i have, is the item list is very small compared to an actual list of ingame items... is there a way to upgrade/import items from the GS DB?

[ranep6]

i can did all right things
then it works , i thought T_T
when i click accoutn manager button or all buttons
nothing happens
not pop ups screen T_T
please help
i am using microsoft access 2010



buttons are not working

[Warrior15]

i can did all right things
then it works , i thought T_T
when i click accoutn manager button or all buttons
nothing happens
not pop ups screen T_T
please help
i am using microsoft access 2010



buttons are not working

same here