Public feed
#891384
/*-----------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------EVERY CUSTOM ID/ENTRY GOT SIX or seven 0------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------*/
/*-----------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------100% COMPLETE STUFF------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------*/
/*---------------------------------------------------------
-------------------------Quests----1000000-1000000---------
----------------------------------------------------------*/
Insert into `quests` values
('1000000','331','0','32','20','30','0','690','0','0','0','0','0','1','6383','0','16305','1','Sharptalon\'s Claw','The mighty hippogryph Sharptalon has been slain, with the claw of the felled beast serving as a testament to your victory. Senani Thunderheart at the Splintertree Post will no doubt be interested in seeing this trophy as proof of your deeds.','Bring Sharptalon\'s Claw to Senani Thunderheart at Splintertree Post, Ashenvale.','Most impressive, $N... the claw of Sharptalon could not have been easy to get! The Ashenvale Hunt goes well for you!$b$bSharptalon had long terrorized the peons from the lumber camps near its path as they tried to travel here to Splintertree Post. No doubt once the word gets out that it was you who put down the beast, many rousing songs of your bravery will be heard at campfires and lumber mills across Ashenvale!','Yes, mighty $C, I sensed your arrival. I trust you have more news to report to me about your hunt?','','','','','','16305','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0',0,0,0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','81','0',250,0,'0','0','2450','0','0','0','0','0','0','0','0','0','0','0','235','0','0','0','16305','0','0','0','1','0','0','0',0);
/*--------------------------
---Quest starter/finisher---
----------------------------*/
INSERT INTO `creature_quest_starter` (`id`, `quest`) VALUES ('1000004', '1000000');
INSERT INTO `creature_quest_finisher` (`id`, `quest`) VALUES ('1000000', '1000000');
/*---------------------------------------------------------
-------------Game Objects----------------------------------
----------------------------------------------------------*/
/*--------------------------------------------
-----------Names-----10000000-10000021--------
---------------------------------------------*/
insert into `gameobject_names` values
('1000000','14','467','House','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000001','14','368','Moonwell','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000002','14','476','Ship','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000003','14','628','Guard Tower','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000004','14','629','Orc Tower','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000005','14','649','Gold Mine','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000006','14','2170','Bamboo Holding pen','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000007','14','3031','Zeppelin','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000008','14','7019','Tank','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000009','14','7087','NE Ship','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000010','14','7129','Human Siege Tower','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000011','14','7165','Orc Barracks','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000012','14','7246','Gold Altar','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000013','14','7280','Terrorkar Trees','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000014','14','7402','WC2 Dark Portal','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000015','14','471','Stormwind','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000015','14','6556','Elves Dock start','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000015','14','6557','Elves Dock','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000016','14','5975','Westfall tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000017','14','7329','Emerald dream Tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000018','14','7328','Emerald dream Tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000019','14','7327','Emerald dream Tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000020','14','7321','Emerald dream Tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
insert into `gameobject_names` values
('1000021','14','6637','Naxxramas','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
/*--------------------------------------------
--------------Spawns---1000000-10000045-------
---------------------------------------------*/
insert into `gameobject_spawns` values
(1000000,1000002,30,352.004,-113.638,312.046,3.76762,0,0,0.95141,-0.307926,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000001,1000002,30,273.67,-120.131,314.003,6.15862,0,0,0.0622415,-0.998061,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000002,181075,30,314.409,-127.23,328.315,0.895898,0,0,0.433118,0.901337,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000003,181075,30,316.894,-129.332,328.355,0.895113,0,0,0.432764,0.901507,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000004,181075,30,318.561,-127.414,327.671,0.918418,0,0,0.443239,0.896403,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000005,181075,30,321.35,-123.889,326.132,0.900773,0,0,0.435313,0.900279,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000006,181075,30,319.87,-125.748,326.887,0.900773,0,0,0.435313,0.900279,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000007,181075,30,325.776,-118.571,323.815,0.844907,0,0,0.41,0.912086,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000008,181075,30,324.544,-119.92,324.78,0.844907,0,0,0.41,0.912086,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000009,181075,30,322.945,-121.714,325.606,0.805637,0,0,0.392013,0.91996,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000010,181075,30,326.988,-117.205,323.194,0.844907,0,0,0.41,0.912086,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000011,181075,30,328.667,-115.322,323.105,0.844907,0,0,0.41,0.912086,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000012,181075,30,313.488,-129.113,328.178,0.942304,0,0,0.453913,0.891046,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000013,181075,30,315.549,-130.998,328.324,0.889299,0,0,0.430141,0.902762,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000014,181075,30,312.285,-130.817,327.966,4.13849,0,0,0.878326,-0.478062,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000015,181075,30,310.898,-132.085,327.783,3.57817,0,0,0.97627,-0.216558,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000016,181075,30,308.764,-132.828,327.495,3.25792,0,0,0.998309,-0.0581291,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000017,181075,30,306.965,-133.039,327.286,3.25792,0,0,0.998309,-0.0581291,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000018,181075,30,305.236,-133.312,326.897,3.25792,0,0,0.998309,-0.0581291,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000019,181075,30,302.937,-133.581,326.522,3.25792,0,0,0.998309,-0.0581291,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000020,181075,30,300.956,-133.812,326.186,3.25792,0,0,0.998309,-0.0581291,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000021,181075,30,298.859,-134.073,325.717,3.26106,0,0,0.998217,-0.0596971,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000022,181075,30,296.538,-134.351,325.479,3.26106,0,0,0.998217,-0.0596971,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000023,181075,30,294.44,-134.603,325.632,3.26106,0,0,0.998217,-0.0596971,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000024,181075,30,292.133,-134.88,325.646,3.26106,0,0,0.998217,-0.0596971,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000025,181075,30,290.347,-134.624,325.639,6.21935,0,0,0.0319118,-0.999491,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000026,181075,30,316.385,-125.97,327.877,4.04222,0,0,0.900311,-0.435247,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000027,181075,30,318,-124.211,326.741,4.06971,0,0,0.894243,-0.447581,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000028,181075,30,314.64,-132.486,327.771,0.950897,0,0,0.457737,0.889088,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000029,181075,30,318.843,-122.34,325.94,0.892305,0,0,0.431498,0.902114,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000030,181075,30,313.143,-133.644,327.68,3.81756,0,0,0.943426,-0.331584,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000031,181075,30,311.628,-134.623,327.745,3.37303,0,0,0.993312,-0.115459,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000032,181075,30,309.195,-135.439,327.447,3.36125,0,0,0.993975,-0.109607,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000033,181075,30,306.733,-135.988,326.985,3.36125,0,0,0.993975,-0.109607,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000034,181075,30,304.158,-136.561,326.465,3.36125,0,0,0.993975,-0.109607,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000035,181075,30,301.604,-137.009,326.107,3.29842,0,0,0.996927,-0.078333,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000036,181075,30,299.214,-137.387,325.72,3.29842,0,0,0.996927,-0.0783333,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000037,181075,30,296.661,-137.676,325.403,3.2248,0,0,0.999135,-0.0415932,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000038,181075,30,294.934,-137.805,325.557,3.2248,0,0,0.999135,-0.0415932,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000039,181075,30,293.206,-137.94,325.536,3.2248,0,0,0.999135,-0.0415932,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000040,181075,30,290.779,-137.722,325.619,3.04416,0,0,0.998814,0.0486966,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000041,181075,30,320.648,-120.334,325.539,0.884082,0,0,0.427785,0.90388,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000042,181075,30,322.282,-118.341,324.717,0.884082,0,0,0.427785,0.90388,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000043,181075,30,323.617,-116.712,323.674,0.884082,0,0,0.427785,0.90388,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000044,181075,30,325.166,-114.946,322.943,0.903726,0,0,0.436642,0.899635,1,0,0,1,0);
insert into `gameobject_spawns` values
(1000045,181075,30,326.731,-113.642,322.909,0.957133,0,0,0.460507,0.887656,1,0,0,1,0);
/*-----------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------Alterac Valley-------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------*/
/*------------
------Map-----
-------------*/
UPDATE `worldmap_info` SET `type`='0' WHERE (`entry`='30');
UPDATE `worldmap_info` SET `minlevel`='1' WHERE (`entry`='30');
UPDATE `worldmap_info` SET `maxplayers`='0' WHERE (`entry`='30');
UPDATE `worldmap_info` SET `flags`='1' WHERE (`entry`='30');
UPDATE `worldmap_info` SET `viewingdistance`='1000' WHERE (`entry`='30');
/*----------------------------
---Graves---1000000-1000006---
-----------------------------*/
insert into `graveyards` values
('1000000', '-1497.339478', '-332.935272', '101.134880', '0.655021', '0', '', '30', '3', 'Alterac Valley');
insert into `graveyards` values
('1000001', '-532.786316', '-405.479645', '49.609371', '0.673109', '2597', '', '30', '3', 'Iceblood Graveyard');
insert into `graveyards` values
('1000002', '-1090.891113', '-246.886047', '57.715107', '4.864000', '2597', '', '30', '3', 'Frostwold Graveyard');
insert into `graveyards` values
('1000003', '-157.677124', '32.003998', '77.062721', '4.401968', '2597', '', '30', '3', 'Winterax Graveyard');
insert into `graveyards` values
('1000004', '73,493805', '-497.410980', '48.758640', '1.420599', '2597', '', '30', '3', 'Stonehearth Graveyard');
insert into `graveyards` values
('1000005', '674.368774', '-372.272888', '29.780754', '1.799166', '2597', '', '30', '3', 'Stormpike Graveyard');
insert into `graveyards` values
('1000006', '728.542419', '-82,038033', '51.550232', '3.816074', '2597', '', '30', '3', 'Alterac Valley');
/*---------------------------------------------------------------------------
----------------Player Create info-------------------------------------------
----------------------------------------------------------------------------*/
/*-------------------
--------items--------
--------------------*/
/*------------------
------Alliance------
-------------------*/
/*-----------
---Warrior---
------------*/
delete from `playercreateinfo_items` where `indexid` = '1';
delete from `playercreateinfo_items` where `indexid` = '3';
delete from `playercreateinfo_items` where `indexid` = '4';
delete from `playercreateinfo_items` where `indexid` = '7';
delete from `playercreateinfo_items` where `indexid` = '44';
insert into `playercreateinfo_items` values
('1', '12185', '16', '1');
insert into `playercreateinfo_items` values
('1', '12185', '0', '1');
insert into `playercreateinfo_items` values
('1', '18610', '15', '1');
insert into `playercreateinfo_items` values
('1', '2888', '23', '10');
insert into `playercreateinfo_items` values
('1', '22744', '7', '1');
insert into `playercreateinfo_items` values
('1', '22745', '6','1');
insert into `playercreateinfo_items` values
('1', '22742', '3', '1');
insert into `playercreateinfo_items` values
('9', '12185', '0', '1');
insert into `playercreateinfo_items` values
('3', '18610', '15', '1');
insert into `playercreateinfo_items` values
('3', '2888', '23', '10');
insert into `playercreateinfo_items` values
('3', '22744', '7', '1');
insert into `playercreateinfo_items` values
('3', '22745', '6','1');
insert into `playercreateinfo_items` values
('3', '22742', '3', '1');
insert into `playercreateinfo_items` values
('4', '12185', '0', '1');
insert into `playercreateinfo_items` values
('4', '18610', '15', '1');
insert into `playercreateinfo_items` values
('4', '2888', '23', '10');
insert into `playercreateinfo_items` values
('4', '22744', '7', '1');
insert into `playercreateinfo_items` values
('4', '22745', '6','1');
insert into `playercreateinfo_items` values
('4', '22742', '3', '1');
insert into `playercreateinfo_items` values
('7', '12185', '0', '1');
insert into `playercreateinfo_items` values
('7', '18610', '15', '1');
insert into `playercreateinfo_items` values
('7', '2888', '23', '10');
insert into `playercreateinfo_items` values
('7', '22744', '7', '1');
insert into `playercreateinfo_items` values
('7', '22745', '6','1');
insert into `playercreateinfo_items` values
('7', '22742', '3', '1');
insert into `playercreateinfo_items` values
('44', '12185', '0', '1');
insert into `playercreateinfo_items` values
('44', '18610', '15', '1');
insert into `playercreateinfo_items` values
('44', '2888', '23', '10');
insert into `playercreateinfo_items` values
('44', '22744', '7', '1');
insert into `playercreateinfo_items` values
('44', '22745', '6','1');
insert into `playercreateinfo_items` values
('44', '22742', '3', '1');
/*---------------
---Starter kit---
----------------*/
/*-------------
---All Races---
--------------*/
insert into `playercreateinfo_items` values
(1, 100000, 28, 1);
insert into `playercreateinfo_items` values
(9, 100000, 28, 1);
insert into `playercreateinfo_items` values
(18, 100000, 28, 1);
insert into `playercreateinfo_items` values
(25, 100000, 28, 1);
insert into `playercreateinfo_items` values
(34, 100000, 28, 1);
insert into `playercreateinfo_items` values
(38, 100000, 28, 1);
insert into `playercreateinfo_items` values
(1, 100001, 29, 1);
insert into `playercreateinfo_items` values
(9, 100001, 29, 1);
insert into `playercreateinfo_items` values
(18, 100001, 29, 1);
insert into `playercreateinfo_items` values
(25, 100001, 29, 1);
insert into `playercreateinfo_items` values
(34, 100001, 29, 1);
insert into `playercreateinfo_items` values
(38, 100001, 29, 1);
insert into `playercreateinfo_items` values
(1, 100002, 30, 1);
insert into `playercreateinfo_items` values
(9, 100002, 30, 1);
insert into `playercreateinfo_items` values
(18, 100002, 30, 1);
insert into `playercreateinfo_items` values
(25, 100002, 30, 1);
insert into `playercreateinfo_items` values
(34, 100002, 30, 1);
insert into `playercreateinfo_items` values
(38, 100002, 30, 1);
insert into `playercreateinfo_items` values
(1, 100003, 31, 1);
insert into `playercreateinfo_items` values
(9, 100003, 31, 1);
insert into `playercreateinfo_items` values
(18, 100003, 31, 1);
insert into `playercreateinfo_items` values
(25, 100003, 31, 1);
insert into `playercreateinfo_items` values
(34, 100003, 31, 1);
insert into `playercreateinfo_items` values
(38, 100003, 31, 1);
insert into `playercreateinfo_items` values
(2, 100000, 28, 1);
insert into `playercreateinfo_items` values
(11, 100000, 28, 1);
insert into `playercreateinfo_items` values
(19, 100000, 28, 1);
insert into `playercreateinfo_items` values
(30, 100000, 28, 1);
insert into `playercreateinfo_items` values
(39, 100000, 28, 1);
insert into `playercreateinfo_items` values
(2, 100001, 29, 1);
insert into `playercreateinfo_items` values
(11, 100001, 29, 1);
insert into `playercreateinfo_items` values
(19, 100001, 29, 1);
insert into `playercreateinfo_items` values
(30, 100001, 29, 1);
insert into `playercreateinfo_items` values
(39, 100001, 29, 1);
insert into `playercreateinfo_items` values
(2, 100002, 30, 1);
insert into `playercreateinfo_items` values
(11, 100002, 30, 1);
insert into `playercreateinfo_items` values
(19, 100002, 30, 1);
insert into `playercreateinfo_items` values
(30, 100002, 30, 1);
insert into `playercreateinfo_items` values
(39, 100002, 30, 1);
insert into `playercreateinfo_items` values
(2, 100003, 31, 1);
insert into `playercreateinfo_items` values
(11, 100003, 31, 1);
insert into `playercreateinfo_items` values
(19, 100003, 31, 1);
insert into `playercreateinfo_items` values
(30, 100003, 31, 1);
insert into `playercreateinfo_items` values
(39, 100003, 31, 1);
insert into `playercreateinfo_items` values
(3, 100000, 28, 1);
insert into `playercreateinfo_items` values
(10, 100000, 28, 1);
insert into `playercreateinfo_items` values
(12, 100000, 28, 1);
insert into `playercreateinfo_items` values
(20, 100000, 28, 1);
insert into `playercreateinfo_items` values
(26, 100000, 28, 1);
insert into `playercreateinfo_items` values
(3, 100001, 29, 1);
insert into `playercreateinfo_items` values
(10, 100001, 29, 1);
insert into `playercreateinfo_items` values
(12, 100001, 29, 1);
insert into `playercreateinfo_items` values
(20, 100001, 29, 1);
insert into `playercreateinfo_items` values
(26, 100001, 29, 1);
insert into `playercreateinfo_items` values
(3, 100002, 30, 1);
insert into `playercreateinfo_items` values
(10, 100002, 30, 1);
insert into `playercreateinfo_items` values
(12, 100002, 30, 1);
insert into `playercreateinfo_items` values
(20, 100002, 30, 1);
insert into `playercreateinfo_items` values
(26, 100002, 30, 1);
insert into `playercreateinfo_items` values
(3, 100003, 31, 1);
insert into `playercreateinfo_items` values
(10, 100003, 31, 1);
insert into `playercreateinfo_items` values
(12, 100003, 31, 1);
insert into `playercreateinfo_items` values
(20, 100003, 31, 1);
insert into `playercreateinfo_items` values
(26, 100003, 31, 1);
insert into `playercreateinfo_items` values
(4, 100000, 28, 1);
insert into `playercreateinfo_items` values
(15, 100000, 28, 1);
insert into `playercreateinfo_items` values
(21, 100000, 28, 1);
insert into `playercreateinfo_items` values
(27, 100000, 28, 1);
insert into `playercreateinfo_items` values
(42, 100000, 28, 1);
insert into `playercreateinfo_items` values
(4, 100001, 29, 1);
insert into `playercreateinfo_items` values
(15, 100001, 29, 1);
insert into `playercreateinfo_items` values
(21, 100001, 29, 1);
insert into `playercreateinfo_items` values
(27, 100001, 29, 1);
insert into `playercreateinfo_items` values
(42, 100001, 29, 1);
insert into `playercreateinfo_items` values
(4, 100002, 30, 1);
insert into `playercreateinfo_items` values
(15, 100002, 30, 1);
insert into `playercreateinfo_items` values
(21, 100002, 30, 1);
insert into `playercreateinfo_items` values
(27, 100002, 30, 1);
insert into `playercreateinfo_items` values
(42, 100002, 30, 1);
insert into `playercreateinfo_items` values
(4, 100003, 31, 1);
insert into `playercreateinfo_items` values
(15, 100003, 31, 1);
insert into `playercreateinfo_items` values
(21, 100003, 31, 1);
insert into `playercreateinfo_items` values
(27, 100003, 31, 1);
insert into `playercreateinfo_items` values
(42, 100003, 31, 1);
insert into `playercreateinfo_items` values
(5, 100000, 28, 1);
insert into `playercreateinfo_items` values
(22, 100000, 28, 1);
insert into `playercreateinfo_items` values
(28, 100000, 28, 1);
insert into `playercreateinfo_items` values
(35, 100000, 28, 1);
insert into `playercreateinfo_items` values
(40, 100000, 28, 1);
insert into `playercreateinfo_items` values
(5, 100001, 29, 1);
insert into `playercreateinfo_items` values
(22, 100001, 29, 1);
insert into `playercreateinfo_items` values
(28, 100001, 29, 1);
insert into `playercreateinfo_items` values
(35, 100001, 29, 1);
insert into `playercreateinfo_items` values
(40, 100001, 29, 1);
insert into `playercreateinfo_items` values
(5, 100002, 30, 1);
insert into `playercreateinfo_items` values
(22, 100002, 30, 1);
insert into `playercreateinfo_items` values
(28, 100002, 30, 1);
insert into `playercreateinfo_items` values
(35, 100002, 30, 1);
insert into `playercreateinfo_items` values
(40, 100002, 30, 1);
insert into `playercreateinfo_items` values
(5, 100003, 31, 1);
insert into `playercreateinfo_items` values
(22, 100003, 31, 1);
insert into `playercreateinfo_items` values
(28, 100003, 31, 1);
insert into `playercreateinfo_items` values
(35, 100003, 31, 1);
insert into `playercreateinfo_items` values
(40, 100003, 31, 1);
insert into `playercreateinfo_items` values
(6, 100000, 28, 1);
insert into `playercreateinfo_items` values
(16, 100000, 28, 1);
insert into `playercreateinfo_items` values
(31, 100000, 28, 1);
insert into `playercreateinfo_items` values
(43, 100000, 28, 1);
insert into `playercreateinfo_items` values
(6, 100001, 29, 1);
insert into `playercreateinfo_items` values
(16, 100001, 29, 1);
insert into `playercreateinfo_items` values
(31, 100001, 29, 1);
insert into `playercreateinfo_items` values
(43, 100001, 29, 1);
insert into `playercreateinfo_items` values
(6, 100002, 30, 1);
insert into `playercreateinfo_items` values
(16, 100002, 30, 1);
insert into `playercreateinfo_items` values
(31, 100002, 30, 1);
insert into `playercreateinfo_items` values
(43, 100002, 30, 1);
insert into `playercreateinfo_items` values
(6, 100003, 31, 1);
insert into `playercreateinfo_items` values
(16, 100003, 31, 1);
insert into `playercreateinfo_items` values
(31, 100003, 31, 1);
insert into `playercreateinfo_items` values
(43, 100003, 31, 1);
insert into `playercreateinfo_items` values
(7, 100000, 28, 1);
insert into `playercreateinfo_items` values
(23, 100000, 28, 1);
insert into `playercreateinfo_items` values
(36, 100000, 28, 1);
insert into `playercreateinfo_items` values
(41, 100000, 28, 1);
insert into `playercreateinfo_items` values
(7, 100001, 29, 1);
insert into `playercreateinfo_items` values
(23, 100001, 29, 1);
insert into `playercreateinfo_items` values
(36, 100001, 29, 1);
insert into `playercreateinfo_items` values
(41, 100001, 29, 1);
insert into `playercreateinfo_items` values
(7, 100002, 30, 1);
insert into `playercreateinfo_items` values
(23, 100002, 30, 1);
insert into `playercreateinfo_items` values
(36, 100002, 30, 1);
insert into `playercreateinfo_items` values
(41, 100002, 30, 1);
insert into `playercreateinfo_items` values
(7, 100003, 31, 1);
insert into `playercreateinfo_items` values
(23, 100003, 31, 1);
insert into `playercreateinfo_items` values
(36, 100003, 31, 1);
insert into `playercreateinfo_items` values
(41, 100003, 31, 1);
insert into `playercreateinfo_items` values
(8, 100000, 28, 1);
insert into `playercreateinfo_items` values
(17, 100000, 28, 1);
insert into `playercreateinfo_items` values
(24, 100000, 28, 1);
insert into `playercreateinfo_items` values
(29, 100000, 28, 1);
insert into `playercreateinfo_items` values
(32, 100000, 28, 1);
insert into `playercreateinfo_items` values
(37, 100000, 28, 1);
insert into `playercreateinfo_items` values
(8, 100001, 29, 1);
insert into `playercreateinfo_items` values
(17, 100001, 29, 1);
insert into `playercreateinfo_items` values
(24, 100001, 29, 1);
insert into `playercreateinfo_items` values
(29, 100001, 29, 1);
insert into `playercreateinfo_items` values
(32, 100001, 29, 1);
insert into `playercreateinfo_items` values
(37, 100001, 29, 1);
insert into `playercreateinfo_items` values
(8, 100002, 30, 1);
insert into `playercreateinfo_items` values
(17, 100002, 30, 1);
insert into `playercreateinfo_items` values
(24, 100002, 30, 1);
insert into `playercreateinfo_items` values
(29, 100002, 30, 1);
insert into `playercreateinfo_items` values
(32, 100002, 30, 1);
insert into `playercreateinfo_items` values
(37, 100002, 30, 1);
insert into `playercreateinfo_items` values
(8, 100003, 31, 1);
insert into `playercreateinfo_items` values
(17, 100003, 31, 1);
insert into `playercreateinfo_items` values
(24, 100003, 31, 1);
insert into `playercreateinfo_items` values
(29, 100003, 31, 1);
insert into `playercreateinfo_items` values
(32, 100003, 31, 1);
insert into `playercreateinfo_items` values
(37, 100003, 31, 1);
insert into `playercreateinfo_items` values
(50, 100000, 28, 1);
insert into `playercreateinfo_items` values
(51, 100000, 28, 1);
insert into `playercreateinfo_items` values
(52, 100000, 28, 1);
insert into `playercreateinfo_items` values
(53, 100000, 28, 1);
insert into `playercreateinfo_items` values
(54, 100000, 28, 1);
insert into `playercreateinfo_items` values
(55, 100000, 28, 1);
insert into `playercreateinfo_items` values
(56, 100000, 28, 1);
insert into `playercreateinfo_items` values
(50, 100001, 29, 1);
insert into `playercreateinfo_items` values
(51, 100001, 29, 1);
insert into `playercreateinfo_items` values
(52, 100001, 29, 1);
insert into `playercreateinfo_items` values
(53, 100001, 29, 1);
insert into `playercreateinfo_items` values
(54, 100001, 29, 1);
insert into `playercreateinfo_items` values
(55, 100001, 29, 1);
insert into `playercreateinfo_items` values
(56, 100001, 29, 1);
insert into `playercreateinfo_items` values
(50, 100002, 30, 1);
insert into `playercreateinfo_items` values
(51, 100002, 30, 1);
insert into `playercreateinfo_items` values
(52, 100002, 30, 1);
insert into `playercreateinfo_items` values
(53, 100002, 30, 1);
insert into `playercreateinfo_items` values
(54, 100002, 30, 1);
insert into `playercreateinfo_items` values
(55, 100002, 30, 1);
insert into `playercreateinfo_items` values
(56, 100002, 30, 1);
insert into `playercreateinfo_items` values
(50, 100003, 31, 1);
insert into `playercreateinfo_items` values
(51, 100003, 31, 1);
insert into `playercreateinfo_items` values
(52, 100003, 31, 1);
insert into `playercreateinfo_items` values
(53, 100003, 31, 1);
insert into `playercreateinfo_items` values
(54, 100003, 31, 1);
insert into `playercreateinfo_items` values
(55, 100003, 31, 1);
insert into `playercreateinfo_items` values
(56, 100003, 31, 1);
insert into `playercreateinfo_items` values
(44, 100000, 28, 1);
insert into `playercreateinfo_items` values
(45, 100000, 28, 1);
insert into `playercreateinfo_items` values
(46, 100000, 28, 1);
insert into `playercreateinfo_items` values
(47, 100000, 28, 1);
insert into `playercreateinfo_items` values
(48, 100000, 28, 1);
insert into `playercreateinfo_items` values
(49, 100000, 28, 1);
insert into `playercreateinfo_items` values
(44, 100001, 29, 1);
insert into `playercreateinfo_items` values
(45, 100001, 29, 1);
insert into `playercreateinfo_items` values
(46, 100001, 29, 1);
insert into `playercreateinfo_items` values
(47, 100001, 29, 1);
insert into `playercreateinfo_items` values
(48, 100001, 29, 1);
insert into `playercreateinfo_items` values
(49, 100001, 29, 1);
insert into `playercreateinfo_items` values
(44, 100002, 30, 1);
insert into `playercreateinfo_items` values
(45, 100002, 30, 1);
insert into `playercreateinfo_items` values
(46, 100002, 30, 1);
insert into `playercreateinfo_items` values
(47, 100002, 30, 1);
insert into `playercreateinfo_items` values
(48, 100002, 30, 1);
insert into `playercreateinfo_items` values
(49, 100002, 30, 1);
insert into `playercreateinfo_items` values
(44, 100003, 31, 1);
insert into `playercreateinfo_items` values
(45, 100003, 31, 1);
insert into `playercreateinfo_items` values
(46, 100003, 31, 1);
insert into `playercreateinfo_items` values
(47, 100003, 31, 1);
insert into `playercreateinfo_items` values
(48, 100003, 31, 1);
insert into `playercreateinfo_items` values
(49, 100003, 31, 1);
/*---------------
---Spawn point---
----------------*/
update `playercreateinfo` set `mapid` = '30', `zoneid` = '0', `positionx` = '319.614380', `positionY` = '-134.317139', `positionz` = '318.139160' where `race` = '1';
update `playercreateinfo` set `mapid` = '30', `zoneid` = '0', `positionx` = '319.614380', `positionY` = '-134.317139', `positionz` = '318.139160' where `race` = '3';
update `playercreateinfo` set `mapid` = '30', `zoneid` = '0', `positionx` = '319.614380', `positionY` = '-134.317139', `positionz` = '318.139160' where `race` = '4';
update `playercreateinfo` set `mapid` = '30', `zoneid` = '0', `positionx` = '319.614380', `positionY` = '-134.317139', `positionz` = '318.139160' where `race` = '7';
update `playercreateinfo` set `mapid` = '30', `zoneid` = '0', `positionx` = '319.614380', `positionY` = '-134.317139', `positionz` = '318.139160' where `race` = '44';
/*--------------------------------------------------------------------
---------------------Custom creatures------1000000-1000004------------
---------------------------------------------------------------------*/
/*---------
---Names---
----------*/
insert into `creature_names` values
('1000000', 'Captain Hecklebury','Captain','','0','7','0','0','0',NULL,797,0,0,0,'1','1','1',NULL);
insert into `creature_names` values
('1000001','WoWSurge supplier','WoWSurge official supplier','','0','7','0','0','0',NULL,21770,0,0,0,'1','1','1',NULL);
insert into `creature_names` values
('1000002', 'Kricker', 'Kricker the frog','','0','7','0','0','0',NULL,21950,0,0,0,'1','1','1',NULL);
insert into `creature_names` values
('1000003', 'O`neal', '','','0','7','0','0','0',NULL,4873,0,0,0,'1','1','1',NULL);
insert into `creature_names` values
('1000004', 'Jack Brady', 'Drunk','','0','7','0','0','0',NULL,2557,0,0,0,'1','1','1',NULL);
/*----------
---Pronto---
-----------*/
insert into `creature_proto` values
('1000000','100','100','11','10000','1000','10000','1','12289','1183','333','475','0','0','0','0','23465','50268674','512','0','0','0','0','0','0','360000','1369','66','40','40','0','0','0','1','1','0','0',989,'0','0','2.5','8','14',0);
insert into `creature_proto` values
('1000001', 100, 100, 35, 1000000, 1000000, 1000000, 1, 21770,'1183','333','475','0','0','0','0','23465','50268674','512','0','0','0','0','0','0','360000','1369','66','40','40','0','0','0','1','1','0','0',989,'0','0','2.5','8','14',0);
insert into `creature_proto` values
('1000002', 1, 1, 11, 1000, 1000, 1000, 1, 21950,'1183','333','475','0','0','0','0','23465','50268674','512','0','0','0','0','0','0','360000','1369','66','40','40','0','0','0','1','1','0','0',989,'0','0','2.5','8','14',0);
insert into `creature_proto` values
('1000003', 10, 20, 11, 10, 100, 1000, 2, 0,'1183','333','475','0','0','0','0','23465','50268674','512','0','0','0','0','0','0','360000','1369','66','40','40','0','0','0','1','1','0','0',989,'0','0','2.5','8','14',0);
insert into `creature_proto` values
('1000004', 40, 50, 11, 10, 100, 1000, 2, 0,'1183','333','475','0','0','0','0','23465','50268674','512','0','0','0','0','0','0','360000','1369','66','40','40','0','0','0','1','1','0','0',989,'0','0','2.5','8','14',0);
/*--------------
-----Spawns-----
---------------*/
insert into `creature_spawns`values
(100345,1000004,30,326.852,-132.073,323.196,5.7536,0,2557,11,0,0,0,0,0,0,0,0);
insert into `creature_spawns`values
(100344,1000000,30,308.102,-124.567,332.289,3.00178,0,797,1802,0,0,0,0,0,0,0,0);
insert into `creature_spawns`values
(100346,1000003,30,370.847,-99.8754,332.992,0.753452,0,4873,11,0,0,0,0,0,0,0,0);
insert into `creature_spawns`values
(100347,1000002,30,360.248,-99.7979,318.146,3.92567,0,21950,11,0,0,0,0,0,0,0,0);
/*----------------------------------------------------------------------
---------------WoWSurge ITEMS---ITEMS 100000-100007---------------------
-----------------------------------------------------------------------*/
INSERT INTO `items` VALUES
(100000, 15, 0, -1, "WoWSurge Rules", "WoWSurge Server Rules", "WoWSurge Server Rules", "WoWSurge Server Rules", 44544, 6, 0, 0, 0, 0, -1, -1, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 'Read carefully… The very important rules of this server.', 40624, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0);
INSERT INTO `items` VALUES
(100001, 15, 0, -1, "List of GM's", "List of GM's", "List of GM's", "List of GM's", 7630, 6, 0, 0, 0, 0, -1, -1, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 'A list of the people who you can contact if you have a problem.', 40625, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0);
INSERT INTO `items` VALUES
(100002, 15, 0, -1, "A piece of gold", "A piece of gold", "A piece of gold", "A piece of gold", 35848, 4, 0, 0, 150000, 0, -1, -1, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 'You can sell this to a vendor for 15 gold.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0);
INSERT INTO `items` VALUES
(100003, 1, 0, -1, "WoWSurge Sack", "WoWSurge Sack", "WoWSurge Sack", "WoWSurge Sack", 1282, 4, 0, 0, 0, 18, -1, -1, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4,"" , 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0);
INSERT INTO `items` VALUES
(100004, 15, 0, -1, "WoWSurge starter pack", "WoWSurge starter pack", "WoWSurge starter pack", "WoWSurge starter pack", 21202, 4, 4, 0, 0, 0, -1, -1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 'A pack to get you started on this great server', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0);
INSERT INTO `items` VALUES
('100005', '15', '0', '-1', 'WoWSurge News', 'WoWSurge News', 'WoWSurge News', 'WoWSurge News', 44544, 6, 0, 0, 0, 0, -1, -1, 60, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 'A news list from the WoWSurge staff.', 40624, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0);
INSERT INTO `items` VALUES
('100006',0,0,-1,'WoWSurge candy Cane','', '', '','29331',1,0,25,1,0,32767,-1,5,1,0,0,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',433,0,-1,0,11,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0);
INSERT INTO `items` VALUES
('100007',0,0,-1,'WoWSurge Brew','','','','18119',1,0,445,111,0,-1,-1,15,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',5257,0,-5,-1,59,1000,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0);
INSERT INTO `items` VALUES
('100008',0,0,-1,'EDIT','','','','18119',1,0,445,111,0,-1,-1,15,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',5257,0,-5,-1,59,1000,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0);
/*---------------------------------------------------------------------
------------------ITEM PAGES-------------------------------------------
----------------------------------------------------------------------*/
insert into `itempages` (`entry`, `text`, `next_page`) values
('100005','Welcome to the WoWSurge, $N. We hope you will enjoy your stay here.\r\n\r\ This is the WoWSurge news list and will be updated everytime something new happens, you can get this from the WoWSurge vendor in \r\n\r\ DA NEWS!\r\n\r\ As you can see there is a lot of new custom made stuff by us the staff being added to the server and its only more to come. This is nothing we found on the web, this is made by WoWSurge\r\n\r\ More will come later. You can post ideas for the custom area at the forum also.\r\n\r\ \r\n\r\ You could also check our the forum at (http://www.wowsurge.servegame.com)\r\n\r\n©WoWSurge staff 2008\r\n\r\n\r\n','0');
insert into `itempages` values
('100000','Welcome to the WoWSurge, $N. We hope you will enjoy your stay here. below are the rules we all follow. By entering the server or participating in the forum, you state that you have read, understand and will follow the rules.\r\n\r\n-SPEAK ENGLISH IN PUBLIC CHANNELS LIKE GENERAL\r\n\r\n-HORDE IS ALLOWED TO ATTACK ANY ALLIANCE (and vice versa)\r\n\r\n-NO BEGGING\r\n\r\n-NO BUG EXPLOITING\r\n\r\n-NO HACKING\r\n\r\n-BE NICE AND POLITE\r\n\r\n-BE ACTIVE AND HELPFULL\r\n\r\n-HAVE FUN\r\n\r\n*You can find a list with these rules and more info on our forum (http://www.wowsurge.servgame.com)\r\n\r\n**The WoWSurge staff reserve the right to ammend these rules at any given time without any written notice.\r\n\r\n©WoWSurge Staff 2007\r\n\r\n\r\n','0');
insert into `itempages` values
('100001','-List of GMs/Admins (and their chars)-\r\n\r\n<ADMIN>Zippoman: Zippoman\r\n\r\n <ADMIN> Jaasu: Jaasu\r\n\r\n\<ADMIN> Hellraiser: Hellraiser\r\n\r\n\<GM> Stealthedguy: Stealthedguy\r\n\r\n\ <GM> Kyle: Kyle/r/n/r/nThis list will be updated as much as possible..\r\n\r\ngreetz\r\n\r\nthe WoWSurge Staff\r\n\r\n\r\n','0');
/*----------------------------------------------------------------------
----------------------VENDORS-------------------------------------------
-----------------------------------------------------------------------*/
INSERT INTO `vendors` (entry, item, amount, max_amount, inctime) values
(1000002,1000000,0,0,0),
(1000002,1000001,0,0,0),
(1000002,1000005,0,0,0),
(1000002,1000006,0,0,0),
(1000002,1000007,0,0,0);
/*---------------------------------------------------------------------
-------------AUCTION HOUSE LIKNED--------------------------------------
----------------------------------------------------------------------*/
UPDATE `auctionhouse` SET `group` = 7;
/*---------------------------------------------------------------------
-----------------UPDATES-----------------------------------------------
----------------------------------------------------------------------*/
/*--------------
---Item Pages---
---------------*/
UPDATE `itempages` SET `text` = 'List of GMs/Admins $B$B<ADMIN>Zippoman$B$B<ADMIN> Jaasu$B$B<ADMIN> Hellraiser$B$B<ADMIN>Zaraki$B$B<GM> Stealthedguy$B$B<GM> Kyle$B$BThis list will be updated as much as possible..$B$Bgreetz$B$Bthe WoWSurge Staff$B$B$B', `next_page` = '0' WHERE `entry` = 100001 LIMIT 1;
UPDATE `itempages` SET `text` = 'Welcome to the WoWSurge, $N.$B$BWe hope you will enjoy your stay here. Below are the rules we all follow. By entering the server or participating in the forum, you state that you have read, understand and will follow the rules.$B$B-SPEAK ENGLISH IN PUBLIC CHANNELS LIKE GENERAL$B$B-HORDE IS ALLOWED TO ATTACK ANY ALLIANCE (and vice versa)$B$B-NO BEGGING$B$B-NO BUG EXPLOITING$B$B-NO HACKING$B$B-BE NICE AND POLITE$B$B-BE ACTIVE AND HELPFULL$B$B-HAVE FUN$B$B-DONT ASK FOR TELEPORTS, IF ITS NO TELEPORT TO WHERE YOU WANT, WALK THERE$B$B*You can find a list with these rules and more info on our forum (http://www.wowsurge.servgame.com)$B$B**The WoWSurge staff reserve the right to ammend these rules at any given time without any written notice.$B$B©WoWSurge Staff 2008$B$B$B', `next_page` = '0' WHERE `entry` = 100000 LIMIT 1;
UPDATE `itempages` SET `text` = 'Welcome to WoWSurge, $N. We hope you will enjoy your stay here.$B$BThis is the WoWSurge news list and will be updated everytime something new happens, you can get this from the WoWSurge vendor in.$B$BDA NEWS!$B$BAs you can see there is a lot of new custom made stuff by us the staff being added to the server and its only more to come. This is nothing we found on the web, this is made by WoWSurge$B$BMore will come later. You can post ideas for the custom stuff at the forum also.$B $BYou could also check our the forum at (http://www.wowsurge.servegame.com)$B$B©WoWSurge staff 2008$B$B$B', `next_page` = '0' WHERE `entry` = 100005 LIMIT 1;
/*-------------
------NPC------
--------------*/
/*---------
---Names---
----------*/
UPDATE `creature_names` SET `name` = 'Kricker', `subname` = 'Kricker the frog', `info_str` = '', `type` = '7', `family` = '0', `rank` = '0', `male_displayid` = '21950', `female_displayid` = '0', `civilian` = '1', `Leader` = NULL WHERE `entry` = 1000002 LIMIT 1;
UPDATE `creature_names` SET `name` = 'WoWSurge supplier', `subname` = 'WoWSurge official supplier', `info_str` = '', `type` = '7', `family` = '0', `rank` = '0', `male_displayid` = '21770', `female_displayid` = '0', `civilian` = '1', `Leader` = '1' WHERE `entry` = 1000001 LIMIT 1;
UPDATE `creature_names` SET `name` = 'O`neal', `subname` = '', `info_str` = '', `type` = '7', `family` = '0', `rank` = '0', `male_displayid` = '4873', `female_displayid` = '0', `civilian` = '1', `Leader` = NULL WHERE `entry` = 1000003 LIMIT 1;
UPDATE `creature_names` SET `name` = 'Captain Hecklebury', `subname` = 'Captain', `info_str` = '', `type` = '7', `family` = '0', `rank` = '3', `male_displayid` = '797', `female_displayid` = '0', `civilian` = '1', `Leader` = '1' WHERE `entry` = 1000000 LIMIT 1;
UPDATE `creature_names` SET `name` = 'Jack Brady', `subname` = 'Drunk', `info_str` = '', `type` = '7', `family` = '0', `rank` = '0', `male_displayid` = '2557', `female_displayid` = '0', `civilian` = '1', `Leader` = NULL WHERE `entry` = 1000004 LIMIT 1;
/*---------
---Porto---
----------*/
UPDATE `creature_proto` SET `minlevel` = '10', `maxlevel` = '20', `Faction` = '11', `minhealth` = '1000', `maxhealth` = '5000', `mana` = '1000', `Scale` = '1', `npcflags` = '2', `attacktime` = '1183', `mindamage` = '333', `maxdamage` = '475', `rangedattacktime` = '0', `rangedmindamage` = '0', `rangedmaxdamage` = '0', `combat_reach` = '1', `boss` = '0', `equipmodel1` = '23465', `equipmodel2` = '0', `equipmodel3` = '0', `respawntime` = '360000', `auras` = '0', `invisibility_type` = '0', `death_state` = '0' WHERE `entry` = 1000003 LIMIT 1;
UPDATE `creature_proto` SET `minlevel` = '100', `maxlevel` = '100', `Faction` = '35', `minhealth` = '1000000', `maxhealth` = '1000000', `mana` = '1000000', `Scale` = '1', `npcflags` = '4224', `attacktime` = '1183', `mindamage` = '333', `maxdamage` = '475', `rangedattacktime` = '0', `rangedmindamage` = '0', `rangedmaxdamage` = '0', `combat_reach` = '1', `boss` = '1', `equipmodel1` = '23465', `equipmodel2` = '0', `equipmodel3` = '0', `respawntime` = '360000', `auras` = '0', `invisibility_type` = '0', `death_state` = '0' WHERE `entry` = 1000001 LIMIT 1;
UPDATE `creature_proto` SET `minlevel` = '1', `maxlevel` = '1', `Faction` = '11', `minhealth` = '1000', `maxhealth` = '1000', `mana` = '1000', `Scale` = '1', `npcflags` = '2', `attacktime` = '1183', `mindamage` = '333', `maxdamage` = '475', `rangedattacktime` = '0', `rangedmindamage` = '0', `rangedmaxdamage` = '0', `combat_reach` = '1', `boss` = '0', `equipmodel1` = '23465', `equipmodel2` = '0', `equipmodel3` = '0', `respawntime` = '360000', `auras` = '0', `invisibility_type` = '0', `death_state` = '0' WHERE `entry` = 1000002 LIMIT 1;
UPDATE `creature_proto` SET `minlevel` = '40', `maxlevel` = '50', `Faction` = '11', `minhealth` = '10', `maxhealth` = '100', `mana` = '1000', `Scale` = '1', `npcflags` = '2', `attacktime` = '2000', `mindamage` = '333', `maxdamage` = '333', `rangedattacktime` = '0', `rangedmindamage` = '0', `rangedmaxdamage` = '0', `combat_reach` = '1', `boss` = '0', `equipmodel1` = '', `equipmodel2` = '', `equipmodel3` = '', `respawntime` = '360000', `auras` = '0', `invisibility_type` = '0', `death_state` = '0' WHERE `entry` = 1000004 LIMIT 1;
UPDATE `creature_proto` SET `minlevel` = '100', `maxlevel` = '100', `Faction` = '11', `minhealth` = '10000', `maxhealth` = '1000', `mana` = '10000', `Scale` = '1.5', `npcflags` = '2', `attacktime` = '1000', `mindamage` = '10000', `maxdamage` = '10000', `rangedattacktime` = '0', `rangedmindamage` = '0', `rangedmaxdamage` = '0', `combat_reach` = '1', `boss` = '1', `equipmodel1` = '23465', `equipmodel2` = '0', `equipmodel3` = '0', `respawntime` = '360000', `auras` = '0', `invisibility_type` = '0', `death_state` = '0' WHERE `entry` = 1000000 LIMIT 1;
/*-------------
-----Items-----
--------------*/
UPDATE `items` SET `entry` = '100008', `class` = '0', `subclass` = '0', `field4` = '-1', `name1` = 'update', `name2` = '', `name3` = '', `name4` = '', `displayid` = '18119', `quality` = '1', `flags` = '0', `buyprice` = '445', `sellprice` = '111', `inventorytype` = '0', `allowableclass` = '-1', `allowablerace` = '-1', `itemlevel` = '15', `requiredlevel` = '0', `RequiredSkill` = '0', `RequiredSkillRank` = '0', `RequiredSkillSubRank` = '0', `RequiredPlayerRank1` = '0', `RequiredPlayerRank2` = '0', `RequiredFaction` = '0', `RequiredFactionStanding` = '0', `Unique` = '0', `maxcount` = '1', `ContainerSlots` = '0', `stat_type1` = '0', `stat_value1` = '0', `stat_type2` = '0', `stat_value2` = '0', `stat_type3` = '0', `stat_value3` = '0', `stat_type4` = '0', `stat_value4` = '0', `stat_type5` = '0', `stat_value5` = '0', `stat_type6` = '0', `stat_value6` = '0', `stat_type7` = '0', `stat_value7` = '0', `stat_type8` = '0', `stat_value8` = '0', `stat_type9` = '0', `stat_value9` = '0', `stat_type10` = '0', `stat_value10` = '0', `dmg_min1` = '0', `dmg_max1` = '0', `dmg_type1` = '0', `dmg_min2` = '0', `dmg_max2` = '0', `dmg_type2` = '0', `dmg_min3` = '0', `dmg_max3` = '0', `dmg_type3` = '0', `dmg_min4` = '0', `dmg_max4` = '0', `dmg_type4` = '0', `dmg_min5` = '0', `dmg_max5` = '0', `dmg_type5` = '0', `armor` = '0', `holy_res` = '0', `fire_res` = '0', `nature_res` = '0', `frost_res` = '0', `shadow_res` = '0', `arcane_res` = '0', `delay` = '0', `ammo_type` = '0', `range` = '0', `spellid_1` = '5257', `spelltrigger_1` = '0', `spellcharges_1` = '-5', `spellcooldown_1` = '-1', `spellcategory_1` = '59', `spellcategorycooldown_1` = '1000', `spellid_2` = '0', `spelltrigger_2` = '0', `spellcharges_2` = '0', `spellcooldown_2` = '-1', `spellcategory_2` = '0', `spellcategorycooldown_2` = '-1', `spellid_3` = '0', `spelltrigger_3` = '0', `spellcharges_3` = '0', `spellcooldown_3` = '-1', `spellcategory_3` = '0', `spellcategorycooldown_3` = '-1', `spellid_4` = '0', `spelltrigger_4` = '0', `spellcharges_4` = '0', `spellcooldown_4` = '-1', `spellcategory_4` = '0', `spellcategorycooldown_4` = '-1', `spellid_5` = '0', `spelltrigger_5` = '0', `spellcharges_5` = '0', `spellcooldown_5` = '-1', `spellcategory_5` = '0', `spellcategorycooldown_5` = '-1', `bonding` = '1', `description` = '', `page_id` = '0', `page_language` = '0', `page_material` = '0', `quest_id` = '0', `lock_id` = '0', `lock_material` = '-1', `sheathID` = '0', `randomprop` = '0', `unk203_1` = '0', `block` = '0', `itemset` = '0', `MaxDurability` = '0', `ZoneNameID` = '0', `mapid` = '0', `bagfamily` = '0', `TotemCategory` = '0', `socket_color_1` = '0', `unk201_3` = '0', `socket_color_2` = '0', `unk201_5` = '0', `socket_color_3` = '0', `unk201_7` = '0', `socket_bonus` = '0', `GemProperties` = '0', `ItemExtendedCost` = '0', `ArenaRankRequirement` = '0', `ReqDisenchantSkill` = '-1', `unk2` = '0' WHERE `entry` = 1000008 LIMIT 1;
UPDATE `items` SET `class` = '12', `subclass` = '-1', `name1` = 'Map of Alterac Valley', `name2` = '', `name3` = '', `name4` = '', `displayid` = '7630', `quality` = '1', `buyprice` = '345', `sellprice` = '111', `itemlevel` = '1', `ContainerSlots` = '0', `unique` = '0', `maxcount` = '1', `bonding` = '1', `stat_type1` = '0', `stat_value1` = '0', `stat_type2` = '0', `stat_value2` = '0', `stat_type3` = '0', `stat_value3` = '0', `stat_type4` = '0', `stat_value4` = '0', `stat_type5` = '0', `stat_value5` = '0', `stat_type6` = '0', `stat_value6` = '0', `stat_type7` = '0', `stat_value7` = '0', `stat_type8` = '0', `stat_value8` = '0', `dmg_min1` = '0', `dmg_max1` = '0', `dmg_type1` = '0', `dmg_min2` = '0', `dmg_max2` = '0', `dmg_type2` = '0', `dmg_min3` = '0', `dmg_max3` = '0', `dmg_type3` = '0', `dmg_min4` = '0', `dmg_max4` = '0', `dmg_type4` = '0', `dmg_min5` = '0', `dmg_max5` = '0', `dmg_type5` = '0', `delay` = '0', `range` = '0', `holy_res` = '0', `fire_res` = '0', `nature_res` = '0', `frost_res` = '0', `shadow_res` = '0', `arcane_res` = '0', `armor` = '0', `block` = '0', `spellid_1` = '5257', `spelltrigger_1` = '0', `spellcharges_1` = '-5', `spellcooldown_1` = '-1', `spellcategory_1` = '59', `spellcategorycooldown_1` = '1000', `spellid_2` = '0', `spelltrigger_2` = '0', `spellcharges_2` = '0', `spellcooldown_2` = '-1', `spellcategory_2` = '0', `spellcategorycooldown_2` = '-1', `spellid_3` = '0', `spelltrigger_3` = '0', `spellcharges_3` = '0', `spellcooldown_3` = '-1', `spellcategory_3` = '0', `spellcategorycooldown_3` = '-1', `spellid_4` = '0', `spelltrigger_4` = '0', `spellcharges_4` = '0', `spellcooldown_4` = '-1', `spellcategory_4` = '0', `spellcategorycooldown_4` = '-1', `spellid_5` = '0', `spelltrigger_5` = '0', `spellcharges_5` = '0', `spellcooldown_5` = '-1', `spellcategory_5` = '0', `spellcategorycooldown_5` = '-1', `allowableclass` = '1503', `allowablerace` = '1101', `RequiredSkill` = '0', `RequiredSkillRank` = '0', `RequiredFaction` = '0', `RequiredFactionStanding` = '0', `requiredlevel` = '0', `inventorytype` = '0', `quest_id` = '0', `sheathID` = '0', `itemset` = '0', `MaxDurability` = '0', `Description` = '', `socket_color_1` = '0', `socket_color_2` = '0', `socket_color_3` = '0', `socket_bonus` = '0', `page_id` = '0' WHERE `entry` = 1000008 LIMIT 1;
UPDATE `items` SET `class` = '12', `subclass` = '-1', `name1` = 'List of GM\'s', `name2` = '', `name3` = '', `name4` = '', `displayid` = '7629', `quality` = '5', `buyprice` = '0', `sellprice` = '0', `itemlevel` = '60', `ContainerSlots` = '0', `unique` = '0', `maxcount` = '1', `bonding` = '0', `stat_type1` = '0', `stat_value1` = '0', `stat_type2` = '0', `stat_value2` = '0', `stat_type3` = '0', `stat_value3` = '0', `stat_type4` = '0', `stat_value4` = '0', `stat_type5` = '0', `stat_value5` = '0', `stat_type6` = '0', `stat_value6` = '0', `stat_type7` = '0', `stat_value7` = '0', `stat_type8` = '0', `stat_value8` = '0', `dmg_min1` = '0', `dmg_max1` = '0', `dmg_type1` = '0', `dmg_min2` = '0', `dmg_max2` = '0', `dmg_type2` = '0', `dmg_min3` = '0', `dmg_max3` = '0', `dmg_type3` = '0', `dmg_min4` = '0', `dmg_max4` = '0', `dmg_type4` = '0', `dmg_min5` = '0', `dmg_max5` = '0', `dmg_type5` = '0', `delay` = '0', `range` = '0', `holy_res` = '0', `fire_res` = '0', `nature_res` = '0', `frost_res` = '0', `shadow_res` = '0', `arcane_res` = '0', `armor` = '0', `block` = '0', `spellid_1` = '0', `spelltrigger_1` = '0', `spellcharges_1` = '0', `spellcooldown_1` = '0', `spellcategory_1` = '0', `spellcategorycooldown_1` = '0', `spellid_2` = '0', `spelltrigger_2` = '0', `spellcharges_2` = '0', `spellcooldown_2` = '0', `spellcategory_2` = '0', `spellcategorycooldown_2` = '0', `spellid_3` = '0', `spelltrigger_3` = '0', `spellcharges_3` = '0', `spellcooldown_3` = '0', `spellcategory_3` = '0', `spellcategorycooldown_3` = '0', `spellid_4` = '0', `spelltrigger_4` = '0', `spellcharges_4` = '0', `spellcooldown_4` = '0', `spellcategory_4` = '0', `spellcategorycooldown_4` = '0', `spellid_5` = '0', `spelltrigger_5` = '0', `spellcharges_5` = '0', `spellcooldown_5` = '0', `spellcategory_5` = '0', `spellcategorycooldown_5` = '0', `allowableclass` = '1503', `allowablerace` = '1791', `RequiredSkill` = '0', `RequiredSkillRank` = '0', `RequiredFaction` = '0', `RequiredFactionStanding` = '0', `requiredlevel` = '0', `inventorytype` = '0', `quest_id` = '0', `sheathID` = '0', `itemset` = '0', `MaxDurability` = '0', `Description` = 'A list of the people who you can contact if you have a problem.', `socket_color_1` = '0', `socket_color_2` = '0', `socket_color_3` = '0', `socket_bonus` = '0', `page_id` = '100001' WHERE `entry` = 100001 LIMIT 1;
UPDATE `items` SET `class` = '12', `subclass` = '-1', `name1` = 'WoWSurge Rules', `name2` = '', `name3` = '', `name4` = '', `displayid` = '7630', `quality` = '5', `buyprice` = '0', `sellprice` = '0', `itemlevel` = '60', `ContainerSlots` = '0', `unique` = '0', `maxcount` = '1', `bonding` = '0', `stat_type1` = '0', `stat_value1` = '0', `stat_type2` = '0', `stat_value2` = '0', `stat_type3` = '0', `stat_value3` = '0', `stat_type4` = '0', `stat_value4` = '0', `stat_type5` = '0', `stat_value5` = '0', `stat_type6` = '0', `stat_value6` = '0', `stat_type7` = '0', `stat_value7` = '0', `stat_type8` = '0', `stat_value8` = '0', `dmg_min1` = '0', `dmg_max1` = '0', `dmg_type1` = '0', `dmg_min2` = '0', `dmg_max2` = '0', `dmg_type2` = '0', `dmg_min3` = '0', `dmg_max3` = '0', `dmg_type3` = '0', `dmg_min4` = '0', `dmg_max4` = '0', `dmg_type4` = '0', `dmg_min5` = '0', `dmg_max5` = '0', `dmg_type5` = '0', `delay` = '0', `range` = '0', `holy_res` = '0', `fire_res` = '0', `nature_res` = '0', `frost_res` = '0', `shadow_res` = '0', `arcane_res` = '0', `armor` = '0', `block` = '0', `spellid_1` = '0', `spelltrigger_1` = '0', `spellcharges_1` = '0', `spellcooldown_1` = '0', `spellcategory_1` = '0', `spellcategorycooldown_1` = '0', `spellid_2` = '0', `spelltrigger_2` = '0', `spellcharges_2` = '0', `spellcooldown_2` = '0', `spellcategory_2` = '0', `spellcategorycooldown_2` = '0', `spellid_3` = '0', `spelltrigger_3` = '0', `spellcharges_3` = '0', `spellcooldown_3` = '0', `spellcategory_3` = '0', `spellcategorycooldown_3` = '0', `spellid_4` = '0', `spelltrigger_4` = '0', `spellcharges_4` = '0', `spellcooldown_4` = '0', `spellcategory_4` = '0', `spellcategorycooldown_4` = '0', `spellid_5` = '0', `spelltrigger_5` = '0', `spellcharges_5` = '0', `spellcooldown_5` = '0', `spellcategory_5` = '0', `spellcategorycooldown_5` = '0', `allowableclass` = '1503', `allowablerace` = '1791', `RequiredSkill` = '0', `RequiredSkillRank` = '0', `RequiredFaction` = '0', `RequiredFactionStanding` = '0', `requiredlevel` = '0', `inventorytype` = '0', `quest_id` = '0', `sheathID` = '0', `itemset` = '0', `MaxDurability` = '0', `Description` = 'Read carefully? The very important rules of this server.', `socket_color_1` = '0', `socket_color_2` = '0', `socket_color_3` = '0', `socket_bonus` = '0', `page_id` = '100000' WHERE `entry` = 100000 LIMIT 1;
UPDATE `items` SET `class` = '12', `subclass` = '-1', `name1` = 'WoWSurge News', `name2` = '', `name3` = '', `name4` = '', `displayid` = '44544', `quality` = '5', `buyprice` = '0', `sellprice` = '0', `itemlevel` = '60', `ContainerSlots` = '0', `unique` = '0', `maxcount` = '1', `bonding` = '0', `stat_type1` = '0', `stat_value1` = '0', `stat_type2` = '0', `stat_value2` = '0', `stat_type3` = '0', `stat_value3` = '0', `stat_type4` = '0', `stat_value4` = '0', `stat_type5` = '0', `stat_value5` = '0', `stat_type6` = '0', `stat_value6` = '0', `stat_type7` = '0', `stat_value7` = '0', `stat_type8` = '0', `stat_value8` = '0', `dmg_min1` = '0', `dmg_max1` = '0', `dmg_type1` = '0', `dmg_min2` = '0', `dmg_max2` = '0', `dmg_type2` = '0', `dmg_min3` = '0', `dmg_max3` = '0', `dmg_type3` = '0', `dmg_min4` = '0', `dmg_max4` = '0', `dmg_type4` = '0', `dmg_min5` = '0', `dmg_max5` = '0', `dmg_type5` = '0', `delay` = '0', `range` = '0', `holy_res` = '0', `fire_res` = '0', `nature_res` = '0', `frost_res` = '0', `shadow_res` = '0', `arcane_res` = '0', `armor` = '0', `block` = '0', `spellid_1` = '0', `spelltrigger_1` = '0', `spellcharges_1` = '0', `spellcooldown_1` = '0', `spellcategory_1` = '0', `spellcategorycooldown_1` = '0', `spellid_2` = '0', `spelltrigger_2` = '0', `spellcharges_2` = '0', `spellcooldown_2` = '0', `spellcategory_2` = '0', `spellcategorycooldown_2` = '0', `spellid_3` = '0', `spelltrigger_3` = '0', `spellcharges_3` = '0', `spellcooldown_3` = '0', `spellcategory_3` = '0', `spellcategorycooldown_3` = '0', `spellid_4` = '0', `spelltrigger_4` = '0', `spellcharges_4` = '0', `spellcooldown_4` = '0', `spellcategory_4` = '0', `spellcategorycooldown_4` = '0', `spellid_5` = '0', `spelltrigger_5` = '0', `spellcharges_5` = '0', `spellcooldown_5` = '0', `spellcategory_5` = '0', `spellcategorycooldown_5` = '0', `allowableclass` = '1503', `allowablerace` = '1791', `RequiredSkill` = '0', `RequiredSkillRank` = '0', `RequiredFaction` = '0', `RequiredFactionStanding` = '0', `requiredlevel` = '0', `inventorytype` = '0', `quest_id` = '0', `sheathID` = '0', `itemset` = '0', `MaxDurability` = '0', `Description` = 'A news list from the WoWSurge staff.', `socket_color_1` = '0', `socket_color_2` = '0', `socket_color_3` = '0', `socket_bonus` = '0', `page_id` = '100005' WHERE `entry` = 100005 LIMIT 1;
UPDATE `items` SET `quest_id` = 0 WHERE `quest_id` = '1000000';
/*------------
----Quests----
-------------*/
UPDATE `quests` SET `ZoneId` = '2597', `sort` = '0', `flags` = '1', `MinLevel` = '1', `questlevel` = '1', `Type` = '0', `RequiredRaces` = '1101', `RequiredClass` = '1503', `RequiredTradeskill` = '0', `RequiredRepFaction` = '0', `RequiredRepValue` = '0', `LimitTime` = '0', `SpecialFlags` = '1', `PrevQuestId` = '0', `NextQuestId` = '0', `srcItem` = '0', `SrcItemCount` = '0', `Title` = 'Lost', `Details` = 'Get the Alterac valley map over to Captain Hecklebury on the other ship!', `Objectives` = 'Yar, yar there Pirate!!!...$B$BAs you can see we are stranded up here, and we have been here for hundreds of years..$BBut recently O\'neil found us this map, but I\'ve been to drunk to cross the walkway to the other boat...$B$BDeliver this map to Captain Hecklebury for me... But be carefull, if you fall on your way over the walkway its no way to come back!!$B$B$BGood luck $N !!!!', `CompletionText` = 'You did it!!!, Thank god for that!$B$BHere\'s a reward for the trouble..$B', `IncompleteText` = 'Yar, yar there Pirate!!!...$B$BAs you can see we are stranded up here, and we have been here for hundreds of years..$BBut recently O\'neil found us this map, but I\'ve been to drunk to cross the walkway to the other boat...$B$BDeliver this map to Captain Hecklebury for me... But be carefull, if you fall on your way over the walkway its no way to come back!!$B$B$BGood luck $N !!!!', `EndText` = 'Yar, yar there Pirate!!!...$B$BAs you can see we are stranded up here, and we have been here for hundreds of years..$BBut recently O\'neil found us this map, but I\'ve been to drunk to cross the walkway to the other boat...$B$BDeliver this map to Captain Hecklebury for me... But be carefull, if you fall on your way over the walkway its no way to come back!!$B$B$BGood luck $N !!!!', `ObjectiveText1` = '', `ObjectiveText2` = '', `ObjectiveText3` = '', `ObjectiveText4` = '', `ReqItemId1` = '0', `ReqItemId2` = '0', `ReqItemId3` = '0', `ReqItemId4` = '0', `ReqItemCount1` = '0', `ReqItemCount2` = '0', `ReqItemCount3` = '0', `ReqItemCount4` = '0', `ReqKillMobOrGOId1` = '0', `ReqKillMobOrGOId2` = '0', `ReqKillMobOrGOId3` = '0', `ReqKillMobOrGOId4` = '0', `ReqKillMobOrGOCount1` = '0', `ReqKillMobOrGOCount2` = '0', `ReqKillMobOrGOCount3` = '0', `ReqKillMobOrGOCount4` = '0', `RewChoiceItemId1` = '0', `RewChoiceItemId2` = '0', `RewChoiceItemId3` = '0', `RewChoiceItemId4` = '0', `RewChoiceItemId5` = '0', `RewChoiceItemId6` = '0', `RewChoiceItemCount1` = '0', `RewChoiceItemCount2` = '0', `RewChoiceItemCount3` = '0', `RewChoiceItemCount4` = '0', `RewChoiceItemCount5` = '0', `RewChoiceItemCount6` = '0', `RewItemId1` = '0', `RewItemId2` = '0', `RewItemId3` = '0', `RewItemId4` = '0', `RewItemCount1` = '0', `RewItemCount2` = '0', `RewItemCount3` = '0', `RewItemCount4` = '0', `RewRepFaction1` = '0', `RewRepFaction2` = '0', `RewRepValue1` = '0', `RewRepValue2` = '0', `RewRepLimit` = '0', `RewMoney` = '500000', `RewXP` = '1000', `RewSpell` = '0', `CastSpell` = '0', `RequiredMoney` = '0', `ExploreTrigger1` = '0', `ExploreTrigger2` = '0', `ExploreTrigger3` = '0', `ExploreTrigger4` = '0', `RequiredQuest1` = '0', `RequiredQuest2` = '0', `RequiredQuest3` = '0', `RequiredQuest4` = '0', `ReceiveItemId1` = '1000008', `ReceiveItemId2` = '0', `ReceiveItemId3` = '0', `ReceiveItemId4` = '0', `ReceiveItemCount1` = '1', `ReceiveItemCount2` = '0', `ReceiveItemCount3` = '0', `ReceiveItemCount4` = '0', `IsRepeatable` = '0', `ReqCastSpellId1` = '0', `ReqCastSpellId2` = '0', `ReqCastSpellId3` = '0', `ReqCastSpellId4` = '0' WHERE `entry` = 1000000 LIMIT 1;
/*--------------------------------------------------------------------
-------------------Ideas/Info-----------------------------------------
----------------------------------------------------------------------
Arrr the pirate
Krick Wrenchnozzle (display 22879)
Hopper
squako
Armpit
Shreeder
Filp
Jack
Boat model 476
Bord 181075
-------------------------------------------------------------------
--------------------The End!!!-------------------------------------
------------------------------------------------------------------*/