Community > City of Heroes

Sentinel+ Import Tool

(1/11) > >>

Codewalker:
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.

Usage

As 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

Download

https://www.dropbox.com/s/u5411ralpbnnjuu/xml2db.exe?dl=0

Source

https://github.com/cwtitan/xml2db

To 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 & Caveats

Sentinel+ 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.

USCI:
You, sir, are an Elite Boss!

However....is it possible that you could draw up some instructions for the idiots to follow?  Oh, not for me....asking for a friend.

Thanks!

The Fifth Horseman:

--- Quote from: USCI on May 04, 2019, 03:51:16 AM ---However....is it possible that you could draw up some instructions for the idiots to follow?
--- End quote ---
Those are the instructions he already posted. It cannot be simplified any further.

Gun-Nut:
Nice, unfortunately I don't have any dumps, I feel like I would have made them but only in recent years have I started storing more data "in the cloud" and old computers and hard drives are long gone so I doubt I'd find them.

I would be curious if Sentinel+ could be made to work on current "i25" servers / future servers, while we are still in unknown territory on what will happen it would be nice to know I could make a backup of any characters, sure it can be done on the server end but I can't imagine we'll see access to backing up features, though in theory it should just be a matter of allowing "/packageent" to be used on any access level, in other words 0, no clue if this takes a hit on the database or if your game instance is already holding all your data once you login.

Tivomaniac:

Navigation

[0] Message Index

[#] Next page