EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Plane of Valor database fixes (https://www.eqemulator.org/forums/showthread.php?t=28011)

gatorman 04-25-2009 05:25 PM
Plane of Valor database fixes
 
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

cavedude 04-28-2009 09:15 AM
Thanks, once PEQ is back up, I'll merge this work in!

gatorman 05-03-2009 11:55 AM
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 05-03-2009 12:15 PM
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 05-03-2009 12:41 PM
Getting errors trying to query these in:

Code:
#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 05-03-2009 12:50 PM
You have to change all the quotes to ticks. So, ' becomes `

Scendera 02-13-2011 06:22 AM
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 02-13-2011 07:59 AM
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 02-13-2011 03:35 PM
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.


All times are GMT -4. The time now is 09:44 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.