Chuk
Member
- Gender
- Male
- Guildcard
- 42000001
Hello all, I think this might be a fairly handy tool for people that manage their own PSOBB server with a MySQL database.
Main features :
- Look up character information
- Read inventories, banks and common banks
- Look up linked accounts
- Save information to files (Plain txt, BBcode and PNG files) -> Gets saved in the DATA folder.
- Load local plyer_data file
In full version :
- Edit, remove and add items to inventories, banks and common banks
- Ban accounts (bulk)
- Rename characters
- Edit id-section characters
In the DATA folder you will see a properties.cfg file, fill in the details of your PSO database for the tool to allow to make a connection.
Any errors will be saved to the inventory_reader_error.log file in the data folder. So take a look if something is not working.
Maintenance
The item_data.xml file contains the item ID's and their readable name. If your server has uniqu items, jusst add the entry to the xml file.
I'll start by releasing the read only version and if the demand is high enough I might release the full tool.
Please report any bugs or extra features you'd like to see in this topic. (some are already known)
Read me
Enjoy.
Main features :
- Look up character information
- Read inventories, banks and common banks
- Look up linked accounts
- Save information to files (Plain txt, BBcode and PNG files) -> Gets saved in the DATA folder.
- Load local plyer_data file
In full version :
- Edit, remove and add items to inventories, banks and common banks
- Ban accounts (bulk)
- Rename characters
- Edit id-section characters
In the DATA folder you will see a properties.cfg file, fill in the details of your PSO database for the tool to allow to make a connection.
Code:
useproperties=yes (leave this to yes)
server=your_psoserver.com (or ip address)
user=your_db_username
password=your_db_user_password
database=pso
port=8888(unused atm)Maintenance
The item_data.xml file contains the item ID's and their readable name. If your server has uniqu items, jusst add the entry to the xml file.
I'll start by releasing the read only version and if the demand is high enough I might release the full tool.
Please report any bugs or extra features you'd like to see in this topic. (some are already known)
Read me
Code:
Requirements to run/use this tool :
- .NET framework 4.5 or higher (on windows Vista/7/8/10 or higher)
- Have the included data folder in the same directory as the .exe
(avoid spaces and special characters in the path)
- Do not rename the .exe to something else
- Windows 64-bit
Server settings:
--------------------------
inventory read/write :
--------------------------
username: yourusername
password: yourpassword
privileges :
read/update on account_data
read/update on character_data
read/update on bank_data
read/update on team_data
--------------------------
inventory read only :
--------------------------
username: yourusername
password: yourpassword
privileges :
read on account_data
read on character_data
read on bank_data
read on team_data
Make sure the DB port is accessible for the tool
if you find a bug that's not listed below, let me know.
=========
Todo
=========
Fix bug with reading out S-ranks
Read out MAG photon blasts
remove bug from add function (desyncs inventory count with counter)
allow for variable offset (might be neededo n other servers)
rename selected item option
=========
Changelog
=========
Stability :
When selecting an item after changing the radiobutton (inventory/bank/common) prevent the crash.
Check if save_list folder exists when clicking on the save to list button to prevent crash if it's not there.
Fix the edit character name option (length, weird character at the end and space in front of name).
Functionality :
Added ban button that can ban all linked accounts of a character
Added cancel button so that Soly doesn't accidentally ban all players xD
Added 'copy to clipboard' button on the banning panel so you can save a list of related accounts
Added save items to list (like save BBCode but without BBCode)
Implemented Screenshot feature (finally lol)
Added menu to open folder of saved files/screenshots
Added a feature to reload the previous looked up guildcard(s) (it saves your history since the tool has been open)
Added an 'about this reader' button
Added new ultima only items in the data list
Mags are read with correct stats
New stackable items get read with amount
ID of characters can be changed (not in read only)
///////////////////////
Made by Chuk for Ultima
///////////////////////Enjoy.
Thanks a lot for this!
