RZA-PT | KilroyPT
- Joined
- Aug 27, 2007
- Messages
- 936
- Reaction score
- 85
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:
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 -
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.
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:
You must be registered to see links
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 -
You must be registered to see links
- 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: