EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Bugs (https://www.eqemulator.org/forums/forumdisplay.php?f=622)
-   -   5-1-04 Build seems to have broken mob pathing... (https://www.eqemulator.org/forums/showthread.php?t=13540)

paleequinox 05-01-2004 03:23 PM

5-1-04 Build seems to have broken mob pathing...
 
Just a heads up ... reverted back to the old build and all is working fine again...cepting had to revert to the old client also :(

wize_one 05-01-2004 05:30 PM

Error in GetWaypoints query 'SELECT type,type2,wp1,wp2,wp3,wp4,wp5,wp6,wp7,wp8,wp9,wp1 0,wp11,wp12,wp13,wp14,wp15,wp16,wp17,wp18,wp19,wp2 0,wp21,wp22,wp23,wp24,wp25,wp26,wp27,wp28,wp29,wp3 0,wp31,wp32,wp33,wp34,wp35,wp36,wp37,wp38,wp39,wp4 0,wp41,wp42,wp43,wp44,wp45,wp46,wp47,wp48,wp49,wp5 0 from grid where id = 1000 and zoneid = 0' #1054: Unknown column 'zoneid' in 'where clause'

there was an update, but i didnt get it copied.. maybe the devs will share again..8)

paleequinox 05-03-2004 01:27 PM

Fix for this is ...
 
You will need to add a column named zoneid to the grid table populate it with the zone ids from ids and all works great again and no more GetWaypoint errors.

Happy Happy!
Joy Joy!

sandy 05-05-2004 05:12 AM

I am working on new grid structures

Code:

#
# Structure de la table `grid`
#

CREATE TABLE `grid` (
  `id` int(10) NOT NULL default '0',
  `zoneid` int(10) NOT NULL default '0',
  `type` int(10) NOT NULL default '0',
  `type2` int(10) NOT NULL default '0',
  KEY `zoneid` (`zoneid`),
  KEY `id` (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Structure de la table `grid_entries`
#

CREATE TABLE `grid_entries` (
  `gridid` int(10) NOT NULL default '0',
  `zoneid` int(10) NOT NULL default '0',
  `number` int(10) NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  `heading` float NOT NULL default '0',
  `pause` int(10) NOT NULL default '0',
  KEY `number` (`number`),
  KEY `gridid` (`gridid`),
  KEY `zoneid` (`zoneid`)
) TYPE=MyISAM;

This will remove the 50 wp limit
And it will add a heading value so mobs will head this direction when they stop at a waypoint

paleequinox 05-05-2004 08:35 AM

Very nice! and I must say thanks for all your hard work! Thanks for the heads up on the new stuff coming also. Been playing with some of the stuff in the code and it looks rather promising was tinkering to see if I could do some major mob pathing through multiple zones and think this should help a lot. Trying to kick off events in multiple zones where mobs path through 2 or 3 zones before reaching a zone destination.

Anywho thanks to all you devs and DB folks for your work on this great project!


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

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