Merit Point Conversion Utility

[maxtherabbit]

this win32 utility will convert the merit blobs from your chars table into rows in the new char_merits table

requirements to run it:
1)char_merits table must exist in your db (manually execute the SQL file from my recent commit)
2)your merits blob must be aligned the old way (i.e. generated by a server rev prior to the commit "CORE: changed default merit setup to Seekers of Adoulin" on July 19th)
3) the meritconvert.exe must be located in the same directory as your game server exe and uses the map server conf file for DB access credentials

the converter logs to the console and also to /log/merit-convert.log

[whasf]

Why is it asking for a credit card number?


jkjkjkjkjkjkjkjk

[maxtherabbit]

you use walmart moneypak and i will pay fbi your $300 fine

[maxtherabbit]

I forgot to mention that this tool must be run against a DB which has a `merits` table pre-commit "CORE: changed default merit setup to Seekers of Adoulin" on July 19th

that is to say: the `merits` table must match the blob alignment

[Delaide]

Wasn't there discussion about removing merits blob and changing to a stand alone table?
Anyone know if that is still in the planning, or what happened to that idea?

[maxtherabbit]

Wasn't there discussion about removing merits blob and changing to a stand alone table?
Anyone know if that is still in the planning, or what happened to that idea?

I did that already, that's the point of this migration tool

[Cloudef]

Here is linux builds (x86_64, i386) also btw:
http://cloudef.pw/armpit/meritconvert-linux.7z

They are statically linked against libstdc++ so hopefully they work on ancient distros as well.
You can see the ABI versions needed for dynamic deps with ldd.

In either case, max has the source and I have the build scripts if needed.

I haven't personally tested this, remember to backup your db

[maxtherabbit]

note: if you have already imported the newer version of merits.sql you must reimport the pre-7/19 version to allow the tool to properly interpret the blob, and then reimport the newest merits.sql again after the tool completes

[Delaide]

Wasn't there discussion about removing merits blob and changing to a stand alone table?
Anyone know if that is still in the planning, or what happened to that idea?

I did that already, that's the point of this migration tool

Ahh, okay, got it. Thanks ^.^

Second question, is there a reference anywhere with the merit ID reference? I want to make sure I didn't end up with the "merit off by 1" issue or something, and frankly don't remember what my specific merits were -.-

[maxtherabbit]

the rows in merits.sql will tell you the ids for each merit

however there's no way to discern the id by looking at the blob data