EQ Profile Editor 1.0 Release

[cybernine186]

EQ Profile Editor 1.0
-----------------------------------------------------

This program was written and designed for the purpose of editing the user profile and account for the EQ Emulator Server Database.

This is a good work in progress and I have been testing it for quite some time now before my 1st release. This has also been testing on popular Emu Server database and I have been pleased with the results. Feel free to post any questions relating to the program and/or its functions. There are more updates to come in the future, if you have any good ideas please post them and I will see what I can do.

I have worked very hard with this script and I hope you enjoy it.

1. Program features includes editing & viewing all the following:
a. Account
b. Stats
c. Coin
d. Char Profile (Name, Last Name, Title, Gender, Race, Class, Level, Deity, etc.)
e. Current Zone & Zone Coordinates (Including ability to move to safespot)
f. Facial Features
g. Buffs (View Only)
h. Spell Book
i. Memorized Spells
j. Languages
k. Skills
l. Inventory (Including Popup Item Viewer, to see items stats)
m. Maintenance (This can be custom scripts).
The only script right now is the ability to do coin wipe on entire server.
Please be carefull with this tool, everyone on server must be logged out
inorder for this feature to work. It does not work on corpses, that is
the only downfall I can think of right now.


2. Prequisits - Tested Platforms
a. Linux (Fedora Core 3+) and Windows (XP) OS
b. Apache Web Server (Not tested on IIS)
c. PHP 5.2.6 /w the following extensions (Will work with lower PHP 5 versions)
a. timezonedb
b. MySQL
d. MySQL (Works with recomended MySQL Versions for EQEmu)

3. Install & Configuration php scripts.
a. Unzip into your web server direcory
b. Use Notepad or your favorite editor and open up
the configuration.php in the includes/lib/ folder.
c. Change the Login Username and Password to keep from unauthorized access.
d. Change the MySQL Username, Password, Hostname and Database.

4. Source the MySQL Data into database
Source the schema.sql located in the root directory of the php script folder
into the current working database of your EQEmulator Server.

This will not effect any of the preloaded tables in your database, this program
uses a prefix on all of its tables to prevent any kind of naming issues.

EQ Profile Editor 1.0

[cybernine186]

FYI: This only works with characters that is offline. If you do make changes to a character the changes are not permanent.

[ChaosSlayer]

Originally Posted by cybernine186

FYI: This only works with characters that is offline. If you do make changes to a character the changes are not permanent.

you mean changes NOT permanent to a char who is ONLINE, or they.. never permanent? =)

[cybernine186]

Changes only work with characters that is offline. (With the exception of Account Table Changes such as: GM, Account Status, Revoked, and Inventory.)


You can view any character at any time no matter if they are online or offline.

If you change anything on a character while they are playing the change is simply ignored by the client because this edits the database directly. Then when the client sends changes and saves the profile to the servers database the entire profile in the database is overwritten by what the client has.


Try it out for your self and post your results......

[nosfentora]

I've got it installed and edited the configuration.php file, but it continuously asks me for a username/password.

any thoughts?

[cybernine186]

That is the login username and password...

Default is.
Username: admin
password: admin

You can change it in the configuration.php file

[cybernine186]

I am holding off on fixing a few things on the item viewer but other than those bugs already mentioned is there anything else that doesn't work?

I want lots of feedback if everyone can please.

What you think about it?

What can make it better?

Whats wrong about it?

[cavedude]

Personally, I'd like to see an option to disable the lists of characters on the bottom of the screens. I have no use for it, and I feel it would make the pages look cleaner without. Though, I can understand the argument that it will benefit people with smaller servers so they can easily access their toons, which is why some sort of easy variable to disable it if need be would be nice.

Other than that, I'd like to see AA support, even if it is just for the remaining points the player has, and not the ones they have already spent. Manipulation of a player's bind point, and possibly a reset all bind points script similar to the clear all coin script. The ability to add an item to the player's inventory, with the script automatically determining the best place to put it. Player corpse manipulation would be nice as well, and it wouldn't even require fiddling with the blobs, just support for the regular columns like the zone/coords, rezzed, isburried, and wasatgraveyard. Timeofdeath can be a greyed out field similar to the character's birthdate. There is no need to alter a player_corpses' BLOB anyway I feel so that can be ignored. Lastly, the ability to restore characters and corpses from their backups.

Sorry for all the feedback. I do really love this program, it certainly is the best tool I have come across in a very long time. It has already saved me a ton of time, as I do most of my work on my test server, so I'm rarely on TGC. This tool allows me to help toons out without going in-game which completely rocks.

[trevius]

I have some accounts set to status 1 to allow them access to certain areas. But, your tool lists those accounts as "banned" for some reason. And, it would be nice if there was an option to set the status to an actual number instead of just "privileged", "Super Privileged", "Super Duper Privileged" :P I don't know what number all of those settings mean. It might be nice to at least have a status number next to the name in the drop down menu.

Very nice tool btw. You already have a ton done on it. I agree with CD about not needing the list of characters that automatically pops up at the bottom. I have over 6000 characters on my server and showing the first 10 isn't very useful lol.

[cavedude]

Originally Posted by trevius

I have some accounts set to status 1 to allow them access to certain areas. But, your tool lists those accounts as "banned" for some reason. And, it would be nice if there was an option to set the status to an actual number instead of just "privileged", "Super Privileged", "Super Duper Privileged" :P I don't know what number all of those settings mean. It might be nice to at least have a status number next to the name in the drop down menu.

That can be changed in the DB, my 255 account toon was showing as banned at first too, until I added a new entry for it in the DB. You can also see what all of the statuses mean as well. From what I saw, it was the standard EQEmu status names.

[cybernine186]

Originally Posted by trevius

I have some accounts set to status 1 to allow them access to certain areas. But, your tool lists those accounts as "banned" for some reason. And, it would be nice if there was an option to set the status to an actual number instead of just "privileged", "Super Privileged", "Super Duper Privileged" :P I don't know what number all of those settings mean. It might be nice to at least have a status number next to the name in the drop down menu.

Very nice tool btw. You already have a ton done on it. I agree with CD about not needing the list of characters that automatically pops up at the bottom. I have over 6000 characters on my server and showing the first 10 isn't very useful lol.

You can change these settings and what they display by editing the table `editor_account_status`. This script is completely controlled by the tables, this script uses a prefix of 'editor' in the database to determine all of the tables used by this program. Feel free to poke around and change what you need.

[cybernine186]

Also you can change the default rows to what ever you like in the configuration.php file

Change

$cfg['paging']['maxrows'] = 10;

to

$cfg['paging']['maxrows'] = 1000;

if you want 2, it doesn't matter the number but don't make it too large otherwise it might be a unwanted load on the server resources if your database is too large.