Plane of Valor database fixes

[gatorman]

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.

#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

[cavedude]

Thanks, once PEQ is back up, I'll merge this work in!

[gatorman]

Hmm, was this merged in? I just checked on PEQ and it looks like some of the changes were merged in, however the pathing on two of the mobs is not implemented and nor were there any see invis spawns up.

=/

I'm pretty sure everything I posted was all that is necessary...

Let me know if I forgot to add something that would make it functional.

-Blaz

[cavedude]

Yes, this is merged in. The see invis mobs are correct and will pop, I just checked. Perhaps you just got unlucky (or lucky if you're a player :P)

Edit: Fixed the pathing. You forgot the two grid table entries.

[chrsschb]

Getting errors trying to query these in:

#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);

[cavedude]

You have to change all the quotes to ticks. So, ' becomes `

[Scendera]

I tried to do that and got this:

/* SQL Error (1136): Column count doesn't match value count at row 1 */

I'm a newb, a rather dumb one at that...please help? I'd really love to get PoV working....PoJ would sure make my day too if anyone has the data.

[Scendera]

Feh, edit timer's up...I figured out the problem importing the NPCs, sorted it, also can't import the spawn2 stuff, furthermore in my version those IDs appear to be assigned to stuff in Harb Spire...

[steve]

This thread is almost two years old and the db schema doesn't match anymore. All of those changes should already be in the PEQ database.