Plane of Valor database fixes

gatorman · #1 04-25-2009, 05:25 PM

I recently fired up my live account to check on some zones. I looked at Plane of Valor and wanted to fix the caves area up as close to live as possible. The following sql statements below should make it nearly the same as live.

Code:

#Create Grid entries for the pathing mobs within PoValor Caves
INSERT into `grid_entries` VALUES (61,208,1,2593,-1776,98,192,30);
INSERT into `grid_entries` VALUES (61,208,2,2533,-1708,99,230,0);
INSERT into `grid_entries` VALUES (61,208,3,2454,-1755,100,182,0);
INSERT into `grid_entries` VALUES (61,208,4,2407,-1768,102,182,0);
INSERT into `grid_entries` VALUES (61,208,5,2334,-1777,95,178,0);
INSERT into `grid_entries` VALUES (61,208,6,2232,-1786,65,188,0);
INSERT into `grid_entries` VALUES (61,208,7,1960,-1784,54,195,30);
INSERT into `grid_entries` VALUES (61,208,8,1889,-1678,54,228,0);
INSERT into `grid_entries` VALUES (61,208,9,1774,-1596,25,216,0);
INSERT into `grid_entries` VALUES (61,208,10,1711,-1567,19,206,30);

INSERT into `grid_entries` VALUES (62,208,1,1996,-1864,50,250,30);
INSERT into `grid_entries` VALUES (62,208,2,1994,-1789,50,1,0);
INSERT into `grid_entries` VALUES (62,208,3,1917,-1774,54,216,0);
INSERT into `grid_entries` VALUES (62,208,4,1890,-1678,56,244,0);
INSERT into `grid_entries` VALUES (62,208,5,1840,-1634,41,217,0);
INSERT into `grid_entries` VALUES (62,208,6,1890,-1678,56,92,0);
INSERT into `grid_entries` VALUES (62,208,7,1917,-1774,54,123,0);
INSERT into `grid_entries` VALUES (62,208,8,1994,-1789,50,73,0);
INSERT into `grid_entries` VALUES (62,208,9,1996,-1864,50,128,30);
INSERT into `grid_entries` VALUES (62,208,10,1994,-1789,50,1,0);
INSERT into `grid_entries` VALUES (62,208,11,2024,-1788,52,6,15);
INSERT into `grid_entries` VALUES (62,208,12,2161,-1783,55,66,0);
INSERT into `grid_entries` VALUES (62,208,13,2345,-1785,100,65,30);

#Create two new PoValor NPC's that can see invisibility (these will be inserted into some spawn groups w/in cave)
INSERT into 'npc_types' VALUES (208178,"A_Razorfiend_Subduer","",63,218,1,23,15120,2,0,0,10,11,0,6188,0,0,19472,151,441,"",70,0,1,1,1,1,1,0,0,0,1.85,83,83,83,83,83,1,1,0,1327,0,0,-20,0,344,344,264,344,189,264,189,0,0,1,0,1,0,0);
INSERT into 'npc_types' VALUES (208179,"A_Lumbering_Beast","",62,178,1,1,14880,2,0,0,10,10,0,6189,0,0,19472,149,434,"",70,0,1,1,1,1,1,0,0,0,1.85,82,82,82,82,82,1,1,0,1286,0,0,-20,0,328,328,248,328,173,248,173,0,0,1,0,1,0,0);

#Correct spawn locations x, y, z, heading, pathgrid
REPLACE into 'spawn2' VALUES (42555,37099,"povalor",1996.000000,-1864.000000,50.400002,250.000000,1320,0,62,0,1);
REPLACE into 'spawn2' VALUES (42396,36945,"povalor",2593.000000,-1776.000000,98.000000,192.000000,1320,0,61,0,1);
REPLACE into 'spawn2' VALUES (42584,37130,"povalor",1894.464233,-1678.860962,56.139935,224.250000,1320,0,0,0,1);
REPLACE into 'spawn2' VALUES (42581,37127,"povalor",1741.000000,-1578.000000,24.875000,200,1320,0,0,0,1);
REPLACE into 'spawn2' VALUES (42586,37132,"povalor",2053.000000,-1789.000000,52.750000,193,1320,0,0,0,1);
REPLACE into 'spawn2' VALUES (42585,37131,"povalor",1878.000000,-1841.000000,50.000000,13.5,1320,0,0,0,1);

#Fix Factions so that the mobs will assist each other if close enough.  Tested on live (All (3) near Sleepwalker should assist when pulled) 
REPLACE into 'npc_types' VALUES (208007,"A_Razorfiend_Subduer","",63,218,1,23,15120,2,0,0,10,11,0,6188,0,0,19472,151,441,"",70,0,0,0,0,0,0,1,0,0,1.85,83,83,83,83,83,0,1,0,1327,0,0,-20,0,344,344,264,344,189,264,189,0,0,1,0,1,0,0);
REPLACE into 'npc_types' VALUES (208009,"An_Ancient_Guardian","",62,178,1,1,14880,2,0,0,14,10,0,2697,0,0,19472,149,434,"",70,0,0,0,0,0,0,1,0,0,1.85,82,82,82,82,82,0,1,0,1286,0,0,-20,0,328,328,248,328,173,248,173,0,0,1,0,1,0,0);
REPLACE into 'npc_types' VALUES (208008,"A_Lumbering_Beast","",62,178,1,1,14880,2,0,0,10,10,0,6189,0,0,19472,149,434,"",70,0,0,0,0,0,0,1,0,0,1.85,82,82,82,82,82,0,1,0,1286,0,0,-20,0,328,328,248,328,173,248,173,0,0,1,0,1,0,0);
REPLACE into 'npc_types' VALUES (208000,"A_Razorfiend_Subduer","",62,218,1,23,14880,2,0,0,10,10,0,6188,0,0,19472,149,434,"",70,0,0,0,0,0,0,1,0,0,1.85,82,82,82,82,82,0,1,0,1286,0,0,-20,0,328,328,248,328,173,248,173,0,0,1,0,1,0,0);

#Update spawn groups within cave to have a chance to spawn see invis mobs we created earlier
REPLACE into 'spawnentry' VALUES (36974,208007,60);
REPLACE into 'spawnentry' VALUES (36974,208178,40);
REPLACE into 'spawnentry' VALUES (36975,208007,60);
REPLACE into 'spawnentry' VALUES (36975,208178,40);
REPLACE into 'spawnentry' VALUES (37129,208008,60);
REPLACE into 'spawnentry' VALUES (37129,208179,40);
REPLACE into 'spawnentry' VALUES (36972,208007,60);
REPLACE into 'spawnentry' VALUES (36972,208178,40);
REPLACE into 'spawnentry' VALUES (37131,208007,60);
REPLACE into 'spawnentry' VALUES (37131,208159,2);
REPLACE into 'spawnentry' VALUES (37131,208178,38);

Also, there should be a tree frog at (x,y,z, heading) 974.81, -1685, 157.96 , 12.8 -- sorry I didn't provide sql for this =/

-Blaz