An all-purpose PHP-based tool ("custom")

[AndMetal]

First and foremost, by no means in this "tool" complete. If anything, I would consider this to still be in the alpha/beta stages of development. However, I figure since it helps me a lot, I would share it with the community.

I have put together several different PHP-based tools to allow myself to view and edit information in the EQ Emu server database a lot easier than using a generic tool to directly access and modify it. It also allows me to make changes to my server wherever I am, and is platform independent (which can also mean accessing from mobile phones, at least to a certain extent )

Unfortunately, they are all fairly interconnected, so it isn't quite practical to release each as separate tools.

Completed functionality:
None yet :(

Beta functionality:
View a list of accounts
View a list of characters (also by account & sortable)
View characters, including a complete inventory, stats (sort of), skills, AA's, buffs, memorized spells, and the complete spell book (made to look relatively close to the in-game UI)
Edit items on a merchant (based on merchantid)
View petitions

Alpha functionality:
View, search for, and edit items (is missing several fields)
Restore a character from a backup (not very user friendly currently)
Add and edit NPC types (need to make more user friendly)
Create a table for spells (including creating all 202 columns & importing directly from spells_us.txt, no user input currently)

Future functionality:
Add more functionality to account list (add sorting, change status/password)
Create spawn points for NPCs
Edit characters
Modify/work petitions
And much more I'm sure

A direct link for what will be the "latest" download is here: http://www.andmetal.net/eqemu/custom/custom.zip

I will also keep a list of all versions here: http://www.andmetal.net/eqemu/custom/

I will also see if I can put some screenshots up of what some of the pages look like in action.

I will also try to add information to the Wiki to help anyone trying to create similar tools (my page in the Wiki)

[rojadruid]

This tool would be great if it was incorperated<sp?> into the existing http server tool.

[AndMetal]

I was thinking of doing that, although I'd have to do some learning (according to the Wiki, it uses Perl). A definite positive is that it would be able to interface with both the database data AND the dynamic data in the worldserver. In theory, it would work great for spells.

Although, if someone wants to take what I have already put together to create a better interface for the World HTTP Server, I won't be upset As of right now, I'm fairly comfortable with PHP (with what I would consider to be intermediate experience), so I might just stick with it for now.

[cubber]

This is a great utility! I am having a bit of an issue with anything that has to do with spells though. I did not see a readme in the file with installation instructions but I did find a file in the includes folder called constants.php that I put my database info into which allowed me to view the site but not spell data.

Did I need to do anything else to get the spell functionality working? I saw a file in the spells folder called add_spells.php, i copied my spells_* files from my client and put them in that folder then edited the add_spells.php file to point to "." to look for them. I then tried running add_spells.php in a browser but it failed. To me it looks like it is supposed to create a table in the eqem database called spells_new that the site is supposed to read from for its spell data?

Any information would be helpful, and thanks for your hard work on this very promising tool!

[cubber]

I looked over both of the files a bit more and noticed that they both contain the statement:

include "../includes/db_login.inc";

but there is not file called db_login.inc in the includes folder...

[cubber]

It looks like the add_spells file takes the info from the spells_* file and adds it to the table spells_new, but where is the file that creates the table spells_new in the eqemu database?