var1ety
02-28-2003, 03:30 PM
Been messing with this for the last two days, and am finally happy with it, hope it helps some people out.
Basically this program lets you run through your character_ table and parses the profile of each character that matches your mysql query, removing items matching an item number from their inventory. It currently has the following functionality:
*Written in Python (requires MySQLdb module).
*Asks you to input an item number to purge from characters.
*Allows you to set a bag to replace disallowed bags, with some caveats.
*Clears items from bags, as well as the main inventory, and fixes charges on deleted items.
*If a bag is the item to be purged AND it has legal items in it, replace with a 10 slot bag, to ensure that legal items are left intact; otherwise, purge the disallowed bag, and don't replace.
*Fetches actual name of replacebag and purgeitem from database and asks for a confirmation before purging.
*Prints a total number of items purged.
*Rudimentary progress bar to tell you that the program is still alive and kicking
*Compression
Input is appreciated. Let me know if there is a problem with 0.4.3. Visual inspection of the profile in 0.4.3-cvs indicates there should be none.
get it from:
http://sourceforge.net/tracker/index.php?func=detail&aid=695432&group_id=41381&atid=430534
edit:
should work fine on Python 2.0+, but Python 1.5 may or may not have problems now that += is out of the program.
Basically this program lets you run through your character_ table and parses the profile of each character that matches your mysql query, removing items matching an item number from their inventory. It currently has the following functionality:
*Written in Python (requires MySQLdb module).
*Asks you to input an item number to purge from characters.
*Allows you to set a bag to replace disallowed bags, with some caveats.
*Clears items from bags, as well as the main inventory, and fixes charges on deleted items.
*If a bag is the item to be purged AND it has legal items in it, replace with a 10 slot bag, to ensure that legal items are left intact; otherwise, purge the disallowed bag, and don't replace.
*Fetches actual name of replacebag and purgeitem from database and asks for a confirmation before purging.
*Prints a total number of items purged.
*Rudimentary progress bar to tell you that the program is still alive and kicking
*Compression
Input is appreciated. Let me know if there is a problem with 0.4.3. Visual inspection of the profile in 0.4.3-cvs indicates there should be none.
get it from:
http://sourceforge.net/tracker/index.php?func=detail&aid=695432&group_id=41381&atid=430534
edit:
should work fine on Python 2.0+, but Python 1.5 may or may not have problems now that += is out of the program.