Here's my update script

Post Reply
nasomi
Posts: 141
Joined: Wed Feb 13, 2013 8:51 am

Here's my update script

Post by nasomi » Tue Jan 14, 2014 12:34 pm

Your directories may vary. Paste this into a bat file pretty much anywhere and after you do an svn update, shut down your server applcations and run it. It will preserve account information, but you'll need to update your zoneip at the end.

cd c:\program files (x86)\msbuild\12.0\bin
msbuild "c:\dsp\win32\dssearch-server\dssearch-server.sln" /t:clean
msbuild "c:\dsp\win32\dssearch-server\dssearch-server.sln" /t:build
msbuild "c:\dsp\win32\dsconnect-server\dsconnect-server.sln" /t:clean
msbuild "c:\dsp\win32\dsconnect-server\dsconnect-server.sln" /t:build
msbuild "c:\dsp\win32\dsgame-server\dsgame-server.sln" /t:clean
msbuild "c:\dsp\win32\dsgame-server\dsgame-server.sln" /t:build
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

Post Reply