MySQL DSPFFXI UpDater

[miketran2009]

Dear DSPFFXI DEV.

First off I personally want to THX to ALL the DSP DEV for keeping up the awesome work and keeping DSPFFXI alive ^^/ KUDOS ^^/..

I want to know is there a (APP/TOOL) that we can update our SQLDB instead of doing it manually or can some1 make an (app/tool) thx in adv.

crap just notice wrong section sorry

[ex0r]

haha yes, this is the wrong section for this, but there is already a tool that does this, a couple IIRC. Check the 'Custom Applications and Tools' section of the forums.

[nasomi]

Put this in a batch file. It will delete the ones that will clear character data.

cd c:\dsp\sql
del auction_house.sql
del chars.sql
del accounts.sql
del char_effects.sql
del char_equip.sql
del char_exp.sql
del char_inventory.sql
del char_jobs.sql
del char_look.sql
del char_pet.sql
del char_pet_name.sql
del char_points.sql
del char_profile.sql
del char_skills.sql
del char_stats.sql
del char_storage.sql
del char_vars.sql
del char_weapon_skill_points.sql
del conquest_system.sql
del delivery_box.sql
del linkshells.sql
FOR %%X IN (*.sql) DO ECHO Importing %%X & "c:\program files\mysql\mysql server 5.6\bin\mysql" dspdb -h localhost -u user -ppass < %%X

[whasf]

great but when those tables are updated you just skip over them, then you get errors and maybe corrupted data.

Someone needs to create a program that examines the updated .sql files, if it's a file that contains character data then show the user what is changing and ask for confirmation. Then update the schema.

[ex0r]

once dspweb is stable enough and I feel others can use it without much issue, i'll make a web-driven system that will do it, and will actually take any current char data and instead of overwritting it, populate the new structure