[Archades]

What do you mean by sourcing, I do have the doorupdate-03-15-04.sql script in my bin folder.

ALTER TABLE doors ADD COLUMN invert_state int DEFAULT 0;
ALTER TABLE doors ADD COLUMN incline int DEFAULT 0;
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='107';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='107';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='106';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='106';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='105';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='105';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='104';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='104';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='103';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='103';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='102';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='102';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='101';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='101';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='100';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='100';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='99';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='99';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='98';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='98';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='97';
UPDATE doors SET incline='127' WHERE zone='gfaydark' AND doorid='97';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='96';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='96';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='95';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='95';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='94';
UPDATE doors SET incline='5' WHERE zone='gfaydark' AND doorid='94';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='93';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='93';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='92';
UPDATE doors SET incline='139' WHERE zone='gfaydark' AND doorid='92';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='91';
UPDATE doors SET incline='147' WHERE zone='gfaydark' AND doorid='91';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='90';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='90';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='89';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='89';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='88';
UPDATE doors SET incline='131' WHERE zone='gfaydark' AND doorid='88';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='87';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='87';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='86';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='86';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='85';
UPDATE doors SET incline='128' WHERE zone='gfaydark' AND doorid='85';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='82';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='82';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='82';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='81';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='81';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='81';
UPDATE doors SET liftheight='69' WHERE zone='gfaydark' AND doorid='80';
UPDATE doors SET invert_state='1' WHERE zone='gfaydark' AND doorid='80';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='80';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='79';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='79';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='79';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='78';
UPDATE doors SET invert_state='1' WHERE zone='gfaydark' AND doorid='78';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='78';
UPDATE doors SET liftheight='98' WHERE zone='gfaydark' AND doorid='77';
UPDATE doors SET invert_state='1' WHERE zone='gfaydark' AND doorid='77';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='77';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='75';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='75';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='74';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='74';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='74';
UPDATE doors SET liftheight='1' WHERE zone='gfaydark' AND doorid='73';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='73';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='73';
UPDATE doors SET liftheight='68' WHERE zone='gfaydark' AND doorid='69';
UPDATE doors SET invert_state='1' WHERE zone='gfaydark' AND doorid='69';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='69';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='68';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='68';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='67';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='67';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='66';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='66';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='65';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='65';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='64';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='64';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='63';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='63';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='62';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='62';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='61';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='61';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='60';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='60';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='59';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='59';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='58';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='58';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='57';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='57';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='56';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='56';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='55';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='55';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='54';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='54';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='53';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='53';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='52';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='52';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='51';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='51';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='50';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='50';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='49';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='49';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='48';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='48';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='47';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='47';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='46';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='46';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='45';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='45';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='44';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='44';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='43';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='43';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='42';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='42';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='41';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='41';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='40';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='40';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='39';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='39';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='38';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='38';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='37';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='37';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='36';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='36';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='35';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='35';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='34';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='34';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='33';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='33';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='32';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='32';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='31';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='31';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='30';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='30';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='29';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='29';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='28';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='28';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='27';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='27';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='26';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='26';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='25';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='25';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='24';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='24';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='23';
UPDATE doors SET incline='1' WHERE zone='gfaydark' AND doorid='23';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='22';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='22';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='21';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='21';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='20';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='20';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='18';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='18';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='17';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='17';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='16';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='16';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='15';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='15';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='14';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='14';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='13';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='13';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='12';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='12';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='11';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='11';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='10';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='10';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='9';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='9';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='8';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='8';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='7';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='7';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='6';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='6';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='5';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='5';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='3';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='3';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='2';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='2';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='1';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='1';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='0';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='0';
UPDATE doors SET liftheight='177' WHERE zone='gfaydark' AND doorid='177';
UPDATE doors SET invert_state='0' WHERE zone='gfaydark' AND doorid='177';
UPDATE doors SET incline='0' WHERE zone='gfaydark' AND doorid='177';

When I try to run it though I can't get it to work, is it needed for the server to work?