Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Character List Updater

RZA-PT | KilroyPT
Joined
Aug 27, 2007
Messages
936
Reaction score
84
Hi All

Have built a new charlist updater.
It's written in java but compiled into a standalone EXE with excelsior.

Tool will execute as often as specified.
on first run, the tool with build the table in the specified database.
ensure that the sql credentials specified has adequate permissions to create tables.

Table is populated with:
Account
CharName
CharClass
CharLevel
Exp
Gold
JobCode
Field
Stats (str,tal,spr,agi,hea)
Skills (t1_1,t1_2,t2_1. etc) and skill training values (t1_1t,t1_2t, etc...)
All settings are in "charlist_settings.ini"
Can edit the settings file by clicking file -> edit settings.

ini settings and defaults:
Code:
[Database]
// SQL server path
hostname = PT-SERVER\SQLEXPRESS
// Database in which the table will be kept
database = SoDDB
// table name
table = LevelList
// sql logon credentials
username = PTSQL
password = Admin123
[Parser]
//Path to userdata folder
folderPath = C:\PT-Server\DataServer\userdata
// timeout between cycles (in minutes). Will accept decimal values. 
timeout = 5
// logging, true/false to enable/disable
log = true
// path and name of logging file
logPath = charlist.log

the tool automatically starts when opened.
you can start/stop and reload the settings from the file menu.
there is also an "about" which will show the table structure.
GUI will display settings (except for uid and password) and will display entries etc.

Ver 1.0.1.0
Streamlined app a bit to save memory, and added warning box for sql error.
Added Fields table and expanded character information to include field location and stat point distribution.
Link:

Ver 1.0.1.2

Added UI to display information when connecting to DB and creating tables.
Extended character information to include skill levels and training values (t1_1, t1_2 etc...)

Didn't realise the compiler I was using would put a time limit on the exe so have updated as just the JAR and libraries - - click on CharList Updater to download.

You will need to install the Java Runtime environment (I use JDK and works fine)




I hope this is of use to you guys.
Enjoy.

Credits to me for building it etc.
 
Last edited:
RZA-PT | KilroyPT
Joined
Aug 27, 2007
Messages
936
Reaction score
84
Updated version v1.0.1.0
Now has field, creates two tables (full list of fields by name)

char info has been extended to include stats (str/agi/spr/hea/tal) and field location
also works for newer and older servers for details (account position had moved)
 
RZA-PT | KilroyPT
Joined
Aug 27, 2007
Messages
936
Reaction score
84
updated version now includes skill levels and training values.

Also, uploaded as JAR file so that has no limitation on EXE life.
 
Initiate Mage
Joined
Oct 14, 2021
Messages
6
Reaction score
0
Nice tool !
Could you share the load or modify address in user.dat?
I am very interested in this part, such as the format of user.dat.
I want make one by myself
 
Back
Top