Account/Character Helper

[stephenxpimentel]

Heya, i started this last night, really its just a tool to navigate through accounts/characters on the account easier, it gives a little info on each thing, and u have some options

Search Options:

• Search By Account - Name (Doesn't need to be exact, it will guess) [% will return all accounts]
• Search By Character (This must be exact name)
• Search By Plvl (1,2,3, or u can type them in [player, gm, admin])

Once you've found the account your looking for you can select it from the list, and it will show you all characters to the account (in box next to it), You have 3 Account Options.

Account Options:

• Delete Account - This will also delete all characters, and their items!
• Delete All Characters - This deletes all characters on the account, and their items.
• Ban/Unban - If the account is banned, then it will un-ban, if its not banned then it will ban it.

Then if you select the Character from the account it will show their Level, Race, Class, RR, RP/BP, CL Level, ML Level, Stats, RvR History (keep captures etc.), their Kill History (player kills/solo/db). This gives u 2 options for the character

Character Options:

• Delete Player - Deletes the character and its inventory
• Clear Inventory - Simply deletes all of their items.

I'm not sure if anyone will use this, but i personally think its easier than looking through 4 tables in Navicat..

Here it is, any feedback is nice =].

EDIT: Sorry i haven't added credential saving yet, but i will if its something people want. I'll release the source too (it isn't pretty though i warn u!)

[stephenxpimentel]

Screenshot of the tool.

http://i43.tinypic.com/2njc29z.jpg

[Graveen]

nice you are using DOLDB ! good job.

[-Shawn-]

I like it, my suggestions are since what ever server is rebuilding and wipes alot for tests add an option to wipe all

- accounts
- ban table
- inventory item
- guilds

[-Shawn-]

Good job also

[stephenxpimentel]

nice you are using DOLDB ! good job.

Yupp, i'm not sure if i'm using it to its full capability though..

I like it, my suggestions are since what ever server is rebuilding and wipes alot for tests add an option to wipe all

- accounts
- characters
- ban table
- inventory item
- guilds

Will do! Will add a new form for this. Deletion Form!

[-Shawn-]

Ooo! also to wipe a players rps / rp skill points completely!

also bps

and if you could like add something that can wipe all items with a certain name from peoples inventory :p


just some ridic suggestions i know~~!

[Billy]

I do like the idea your going with... But one thing i did see was that there is no exception handlers which is causing the program to crash. For instance click delete account without logging into mysql

[geshi]

Best to make a Visual DOL Query Builder I think for all that..

gj

[stephenxpimentel]

http://i43.tinypic.com/14dlx5c.jpg

Most of the additions shawn asked for are added, My next addition is going to be viewing players Inventory, Sorted

• Equipped Items
• Bag Items
• Vault Items
• House Vault Items

Each item will show an icon, aswell as its bonuses, procs/charges

[Invictus Maneo]

Best to make a Visual DOL Query Builder I think for all that..

gj

Easy todo that; I may just do that as I learn C++/C#

[Dinberg]

Stephen, can I suggest an option to force respec a player? eg set their specs all to 1 and refund their respec points.

[Graveen]

Best to make a Visual DOL Query Builder I think for all that..

gj

it is called heidisql !

[Graveen]

This could be an helpful tool, Stephen, completing the set of *Creators.

I suggest you to make a "Character Creator": basically, all oriented to player management. This includes Account,

I also strongly suggest you to base you work on different tables:
a) account: password changing, plvl and single permissions
b) dolcharacters: specs, level/rps/bps, name
c) inventory: adding, deleting, viewing...
d) quests & tasks: removing

I have a deep look on it, be sure, and i'll be glad to officially set it as a tool for Dawn of Light if it reaches a certain point.

[geshi]

it is called heidisql !

Yes but for example you could do..

Delete Graveen from players; and that would delete anything to do with Graveen in all the DB's

or Modify Graveen from players RespecAll + 1;

Without having to use 200 lines to delete everything to do with a player in Heidi.. yes i know you can add a respec with one line but thats easier and if its visual then