5-1-04 Build seems to have broken mob pathing...

[paleequinox]

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]

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..

[paleequinox]

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]

I am working on new grid structures

#
# 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]

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!