#wp #grid problems..I have log file of it.

[Gonkers]

Here is my log file.


[Mon May 03 12:01:25 2004] Logging to 'eqlog.txt' is now *ON*.
[Mon May 03 12:03:47 2004] You say, '#grid'
[Mon May 03 12:03:47 2004] Usage: #grid add/delete grid_num wandertype pausetype
[Mon May 03 12:03:56 2004] You say, '#grid add 13001 2 2'
[Mon May 03 12:04:05 2004] Your Location is 441.41, 101.72, -9.28
[Mon May 03 12:04:07 2004] You say, '#wp'
[Mon May 03 12:04:07 2004] Usage: #wp add/delete grid_num pause wp_num
[Mon May 03 12:04:16 2004] You say, '#wp add 13001 5 1'
[Mon May 03 12:04:22 2004] Your Location is 400.79, 71.74, -9.56
[Mon May 03 12:04:25 2004] You say, '#wp add 13001 5 2'
[Mon May 03 12:04:29 2004] You say, '#wp add 13001 5 3'
[Mon May 03 12:04:32 2004] You say, '#wp add 13001 5 4'
[Mon May 03 12:04:34 2004] You say, '#wp add 13001 5 5'
[Mon May 03 12:04:42 2004] You say, '#gassign 13001'
[Mon May 03 12:04:42 2004] ERROR: Unable to assign grid - multiple spawn2 rows match


Why is it giving me that Error?, I know it's obviously spawn2, but where do i find this and how do i correct it?

[Gonkers]

bah, still having this problem. Been messing with the mysql database but it keeps telling me this error. No one knows solution? :(

[Derision]

That error is produced by this code:

#define _GASSIGN_TOLERANCE 1.0
if(!(matches = mysql_num_rows(result))) // try a fuzzy match if that didn't find it
{
mysql_free_result(result);
RunQuery(
query,
MakeAnyLenString(
&query,
"SELECT id,x,y FROM spawn2 WHERE zone='%s' AND "
"ABS( ABS(x) - ABS(%f) ) < %f AND "
"ABS( ABS(y) - ABS(%f) ) < %f",
zone->GetShortName(), x, _GASSIGN_TOLERANCE, y, _GASSIGN_TOLERANCE
),
errbuf,
&result
);
safe_delete_array(query);
fuzzy = 1;
if(!(matches = mysql_num_rows(result)))
mysql_free_result(result);
}
if(matches)
{
if(matches > 1)
{
client->Message(0, "ERROR: Unable to assign grid - multiple spawn2 rows match");

So it would seem you have two or more spawn2 entries for that zone that spawn in the same place, +/- 1 unit in the x and y direction. Try altering the spawn2 entry for the mob you are assigning the grid to so that it is at least 2 units away from the other entries in both the x and y direction.