[Share]Aion DB Manager

[Devangell™]

I Found one aion db manager and i tell to share to you if iam in wrong section one mod move it

---

---

Info :

I.- Account Manager

 

- Create Accounts

- Search Accounts

- Edit some account details (Access Level)

- Delete Accounts

- Navigate existing accounts in the database

- Existing players in current account

 

II.- Player Manager

 

- Players details: Name, ID, Gender, Race, Class, Cube Size, Warehouse Size, Level, Experience, Location, Bind Point, Inventory Items and Quantity (Displays Item ID, Name and Image).

- Search Players

- Edit Player Information and Status: Class, Cube Size, Warehouse Size, Level, Location (Move Players), Bind Point (Change Bind Point), Items Quantity.

- Add items to the Manager database from (Not to the game: Implementing)

- Item Details

- View Player Skills

 

III.- Item Database

 

- Navigate items in the Manager Database (Not in game database)

- Search Items

- See Item Details

 

IV.- Skill Database

 

- Navigate skills in the Manager Database (Not in game database)

- Search Skills

- See Skill Details

 

V.- Aion Mail Reader

 

- Read Players Mails

- Navigate Players Mailbox

 

VI.- Server Statistics

 

- Online Players (Names and Counter)

- Stats: Total Players, Accounts, Races, Genders, Classes

 

More to come...

 

This is it for now. I'm planning some other features. (I appreciate suggestions)

 

In queue: (Next features)

- Backup utilities for aion database and manager database

- Change account password

- Add items and skill directly to the game (Inventory Manager)

- Support for 64 bit OS

-------------------------------------------------------------------------------

 

Installation:

 

I'm using Windows XP (Works in 32bit Windows -Vista or Seven). I'm assuming you already have your Aion Server Installed including the databases with the default names (works with custom database names also) (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 (2000, XP, 2003, 2007) Test this.

- MySQL Connector (ODBC Driver for MySQL): http://www.mysql.com/downloads/connector/odbc/

- Microsoft XML Parser (MSXML) 3.0: http://www.microsoft.com/downloads/details.aspx?FamilyID=4a3ad088-a893-4f0b-a932-5e024e74519f&displaylang=en

- For those having the msxml.dll error: This goes into your system32 folder.

 

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 your 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!

 

DOWNLOAD

 

Ver 1.1 (Code Cleanup, Player Skill Viewer, Skills Database, Server Statistics, Mail Reader, Cosmetic Changes)

 

Feel free to add mirrors.

 

Test the application, I took care of many details, but I'm a human, so expect exceptions xD.

 

Have fun!

Download Here :

Press Here

Credits: Miku

[candem]

niceee