Merit Point Conversion Utility

Applications/Tools written to make running DarkStar easier for the rest of us.
User avatar
maxtherabbit
Developer
Posts: 57
Joined: Wed Jun 12, 2013 11:26 pm

Merit Point Conversion Utility

Post by maxtherabbit » Fri Aug 07, 2015 11:30 am

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
Attachments
meritconvert.zip
(68.17 KiB) Downloaded 140 times

User avatar
whasf
Site Admin
Posts: 1300
Joined: Thu Jul 19, 2012 9:11 pm

Re: Merit Point Conversion Utility

Post by whasf » Fri Aug 07, 2015 2:59 pm

Why is it asking for a credit card number?


jkjkjkjkjkjkjkjk
-- Whasf

User avatar
maxtherabbit
Developer
Posts: 57
Joined: Wed Jun 12, 2013 11:26 pm

Re: Merit Point Conversion Utility

Post by maxtherabbit » Fri Aug 07, 2015 8:25 pm

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

User avatar
maxtherabbit
Developer
Posts: 57
Joined: Wed Jun 12, 2013 11:26 pm

Re: Merit Point Conversion Utility

Post by maxtherabbit » Mon Aug 10, 2015 3:16 pm

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
Posts: 477
Joined: Sat Jun 14, 2014 8:58 am

Re: Merit Point Conversion Utility

Post by Delaide » Mon Aug 10, 2015 8:57 pm

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?

User avatar
maxtherabbit
Developer
Posts: 57
Joined: Wed Jun 12, 2013 11:26 pm

Re: Merit Point Conversion Utility

Post by maxtherabbit » Mon Aug 10, 2015 8:59 pm

Delaide wrote: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
Posts: 9
Joined: Fri Aug 22, 2014 10:38 am

Re: Merit Point Conversion Utility

Post by Cloudef » Tue Aug 11, 2015 7:23 am

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

User avatar
maxtherabbit
Developer
Posts: 57
Joined: Wed Jun 12, 2013 11:26 pm

Re: Merit Point Conversion Utility

Post by maxtherabbit » Tue Aug 11, 2015 11:43 pm

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
Posts: 477
Joined: Sat Jun 14, 2014 8:58 am

Re: Merit Point Conversion Utility

Post by Delaide » Wed Aug 12, 2015 3:31 am

maxtherabbit wrote:
Delaide wrote: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 -.-

User avatar
maxtherabbit
Developer
Posts: 57
Joined: Wed Jun 12, 2013 11:26 pm

Re: Merit Point Conversion Utility

Post by maxtherabbit » Wed Aug 12, 2015 9:22 am

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

Post Reply