Somebody asked me to make a thing, so I made a thing.
You'll need to run this from the command line, but hopefully if you've managed to set up either the dedicated or the VM image personal server, it shouldn't be too difficult.
UsageAs always
back up your XML files before doing anything! This tool does not modify them, but it's strongly recommended to always have a good backup in case of accidental foot-shooting like switching the order of the input and output files.
xml2db [authid] [authname] [bin.pigg] [xmlfile] [txtfile]
authid: The ID number for the game account the character will go on. You can get this from the sql database. I think it's also possible to see it in-game by turning on self info with the GM commands.
authname: The name of the game account - same thing you type in on the login screen.
bin.pigg: Path to the
I24 bin.pigg file.
xmlfile: Sentinel+ XML file to be converted.
txtfile: Output file to create.
Example:
xml2db 150 myaccount C:\I24\piggs\bin.pigg CoolGuy.xml CoolGuy.txt
Once you have the output file, you can use mapserver in dbquery mode to import it.
bin\dbquery.exe -putcharacter CoolGuy.txt
Downloadhttps://www.dropbox.com/s/u5411ralpbnnjuu/xml2db.exe?dl=0Sourcehttps://github.com/cwtitan/xml2dbTo get this done quickly I reused my old libcoh library from back in the day. It was an experiment with C++/Boost (
never again) and can be a rather large pain to compile from source.
Notes & CaveatsSentinel+ only exported information that the client had access to, which means a lot of stuff is missing, especially state related to mission and contact completion. This tool attempt to correct some of the bigger issues related to accolade powers and inventory sizes, but it is far from comprehensive and there may be some slight irregularities, especially related to having badges for arcs that the game doesn't think you've completed yet.
All characters processed by this tool are granted the Passport badge.