From 97f98e9bbdb1a4c64738306eaca300b937e3c97c Mon Sep 17 00:00:00 2001 From: Supabad Date: Thu, 26 Aug 2010 14:30:32 +0200 Subject: Add sql´s in fulls and replace .txt file to .sql in previous commit MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --HG-- branch : trunk --- sql/updates/9600_world_script_texts.sql | 8 +++--- sql/updates/9604_world_script_waypoint.sql | 42 ++++++++++++++++++++++++++++++ sql/updates/9604_world_script_waypoint.txt | 42 ------------------------------ sql/updates/9604_world_scriptname.sql | 1 + sql/updates/9604_world_scriptname.txt | 1 - 5 files changed, 47 insertions(+), 47 deletions(-) create mode 100644 sql/updates/9604_world_script_waypoint.sql delete mode 100644 sql/updates/9604_world_script_waypoint.txt create mode 100644 sql/updates/9604_world_scriptname.sql delete mode 100644 sql/updates/9604_world_scriptname.txt (limited to 'sql/updates') diff --git a/sql/updates/9600_world_script_texts.sql b/sql/updates/9600_world_script_texts.sql index 77a96b48ac9..2233b74de39 100644 --- a/sql/updates/9600_world_script_texts.sql +++ b/sql/updates/9600_world_script_texts.sql @@ -1,6 +1,6 @@ DELETE FROM script_texts WHERE entry BETWEEN -1000578 AND -1000575; INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES -(-1000575,'All systems on-line. Prepare yourself, we leave shortly.',0,0,0,0,'max_a_million SAY_START'), -(-1000576,'Be careful in there and come back in one piece!',0,0,0,0,'bot-specialist_alley SAY_ALLEY_FAREWELL'), -(-1000577,'Proceed.',0,0,0,0,'max_a_million SAY_CONTINUE'), -(-1000578,'You are back! Were you able to get all of the machines?',0,0,0,0,'bot-specialist_alley SAY_ALLEY_FINISH'); +(19589,-1000575,'All systems on-line. Prepare yourself, we leave shortly.',0,0,0,0,'max_a_million SAY_START'), +(19589,-1000576,'Be careful in there and come back in one piece!',0,0,0,0,'bot-specialist_alley SAY_ALLEY_FAREWELL'), +(19589,-1000577,'Proceed.',0,0,0,0,'max_a_million SAY_CONTINUE'), +(19589,-1000578,'You are back! Were you able to get all of the machines?',0,0,0,0,'bot-specialist_alley SAY_ALLEY_FINISH'); diff --git a/sql/updates/9604_world_script_waypoint.sql b/sql/updates/9604_world_script_waypoint.sql new file mode 100644 index 00000000000..c609929268a --- /dev/null +++ b/sql/updates/9604_world_script_waypoint.sql @@ -0,0 +1,42 @@ +DELETE FROM script_waypoint WHERE entry=4880; +INSERT INTO `script_waypoint` VALUES +(4880,0,-2646.429932,-3436.070068,35.373199,0, ''), +(4880,1,-2650.82617,-3440.15332,35.138092,0, ''), +(4880,2,-2662.3147,-3447.67285,35.10891,0, ''), +(4880,3,-2680.4834,-3454.59766,34.6538124,0, ''), +(4880,4,-2701.01855,-3457.43628,34.26906,0, ''), +(4880,5,-2724.063,-3458.63623,33.6734657,0, ''), +(4880,6,-2745.0127,-3459.28125,32.53458,0, ''), +(4880,7,-2759.419,-3464.78174,32.714283,3000, ''), +(4880,8,-2763.63,-3471.50732,33.53883,0, ''), +(4880,9,-2771.789,-3480.88721,33.2553253,0, ''), +(4880,10,-2780.66455,-3488.76343,31.8750439,0, ''), +(4880,11,-2796.144775,-3489.013184,30.858467,3000, ''), +(4880,12,-2792.117920,-3495.966797,30.732433,0, ''), +(4880,13,-2789.059814,-3502.372559,30.670414,0, ''), +(4880,14,-2787.715576,-3515.013428,31.117569,0, ''), +(4880,15,-2790.841309,-3523.311768,30.573286,0, ''), +(4880,16,-2796.58545,-3520.61963,29.9187489,0, ''), +(4880,17,-2798.563,-3518.91064,30.3887444,0, ''), +(4880,18,-2801.46875,-3516.745,30.1914845,0, ''), +(4880,19,-2804.356201,-3513.899170,29.550812,0, ''), +(4880,20,-2807.97559,-3517.99634,29.94883,0, ''), +(4880,21,-2815.680664,-3521.739014,29.772268,0, ''), +(4880,22,-2823.386230,-3526.234131,31.71944,0, ''), +(4880,23,-2836.109619,-3544.695557,32.493855,0, ''), +(4880,24,-2830.392578,-3568.862305,30.410404,0, ''), +(4880,25,-2824.842285,-3569.516846,31.281128,0, ''), +(4880,26,-2818.663818,-3567.801025,30.920368,6000, ''), +(4880,27,-2817.663818,-3568.935059,30.431194,6000, ''), +(4880,28,-2820.394043,-3592.223389,30.716301,6000, ''), +(4880,29,-2820.765625,-3592.497803,30.886147,0, ''), +(4880,30,-2829.909424,-3588.730713,30.683064,0, ''), +(4880,31,-2842.322021,-3577.498291,36.848869,0, ''), +(4880,32,-2851.180420,-3567.579346,38.515850,0, ''), +(4880,33,-2865.554932,-3551.582275,41.438988,0, ''), +(4880,34,-2871.234863,-3548.145020,40.761391,0, ''), +(4880,35,-2877.840332,-3544.147461,38.670235,0, ''), +(4880,36,-2890.394775,-3542.388672,34.314426,0, ''), +(4880,37,-2898.729980,-3543.635742,34.319958,6000, ''), +(4880,38,-2910.064453,-3568.957275,34.250011,0, ''), +(4880,39,-2932.509766,-3584.618652,37.238464,0, ''); diff --git a/sql/updates/9604_world_script_waypoint.txt b/sql/updates/9604_world_script_waypoint.txt deleted file mode 100644 index c609929268a..00000000000 --- a/sql/updates/9604_world_script_waypoint.txt +++ /dev/null @@ -1,42 +0,0 @@ -DELETE FROM script_waypoint WHERE entry=4880; -INSERT INTO `script_waypoint` VALUES -(4880,0,-2646.429932,-3436.070068,35.373199,0, ''), -(4880,1,-2650.82617,-3440.15332,35.138092,0, ''), -(4880,2,-2662.3147,-3447.67285,35.10891,0, ''), -(4880,3,-2680.4834,-3454.59766,34.6538124,0, ''), -(4880,4,-2701.01855,-3457.43628,34.26906,0, ''), -(4880,5,-2724.063,-3458.63623,33.6734657,0, ''), -(4880,6,-2745.0127,-3459.28125,32.53458,0, ''), -(4880,7,-2759.419,-3464.78174,32.714283,3000, ''), -(4880,8,-2763.63,-3471.50732,33.53883,0, ''), -(4880,9,-2771.789,-3480.88721,33.2553253,0, ''), -(4880,10,-2780.66455,-3488.76343,31.8750439,0, ''), -(4880,11,-2796.144775,-3489.013184,30.858467,3000, ''), -(4880,12,-2792.117920,-3495.966797,30.732433,0, ''), -(4880,13,-2789.059814,-3502.372559,30.670414,0, ''), -(4880,14,-2787.715576,-3515.013428,31.117569,0, ''), -(4880,15,-2790.841309,-3523.311768,30.573286,0, ''), -(4880,16,-2796.58545,-3520.61963,29.9187489,0, ''), -(4880,17,-2798.563,-3518.91064,30.3887444,0, ''), -(4880,18,-2801.46875,-3516.745,30.1914845,0, ''), -(4880,19,-2804.356201,-3513.899170,29.550812,0, ''), -(4880,20,-2807.97559,-3517.99634,29.94883,0, ''), -(4880,21,-2815.680664,-3521.739014,29.772268,0, ''), -(4880,22,-2823.386230,-3526.234131,31.71944,0, ''), -(4880,23,-2836.109619,-3544.695557,32.493855,0, ''), -(4880,24,-2830.392578,-3568.862305,30.410404,0, ''), -(4880,25,-2824.842285,-3569.516846,31.281128,0, ''), -(4880,26,-2818.663818,-3567.801025,30.920368,6000, ''), -(4880,27,-2817.663818,-3568.935059,30.431194,6000, ''), -(4880,28,-2820.394043,-3592.223389,30.716301,6000, ''), -(4880,29,-2820.765625,-3592.497803,30.886147,0, ''), -(4880,30,-2829.909424,-3588.730713,30.683064,0, ''), -(4880,31,-2842.322021,-3577.498291,36.848869,0, ''), -(4880,32,-2851.180420,-3567.579346,38.515850,0, ''), -(4880,33,-2865.554932,-3551.582275,41.438988,0, ''), -(4880,34,-2871.234863,-3548.145020,40.761391,0, ''), -(4880,35,-2877.840332,-3544.147461,38.670235,0, ''), -(4880,36,-2890.394775,-3542.388672,34.314426,0, ''), -(4880,37,-2898.729980,-3543.635742,34.319958,6000, ''), -(4880,38,-2910.064453,-3568.957275,34.250011,0, ''), -(4880,39,-2932.509766,-3584.618652,37.238464,0, ''); diff --git a/sql/updates/9604_world_scriptname.sql b/sql/updates/9604_world_scriptname.sql new file mode 100644 index 00000000000..c5c0580944a --- /dev/null +++ b/sql/updates/9604_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE creature_template SET ScriptName='npc_stinky' WHERE entry=4880; diff --git a/sql/updates/9604_world_scriptname.txt b/sql/updates/9604_world_scriptname.txt deleted file mode 100644 index c5c0580944a..00000000000 --- a/sql/updates/9604_world_scriptname.txt +++ /dev/null @@ -1 +0,0 @@ -UPDATE creature_template SET ScriptName='npc_stinky' WHERE entry=4880; -- cgit v1.2.3