EQEmulator Forums - #wp #grid problems..I have log file of it.

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - #wp #grid problems..I have log file of it. (https://www.eqemulator.org/forums/showthread.php?t=13565)

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

Here is my log file.

Quote:

[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?

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

That error is produced by this code:

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(

                                &amp;query,

                                "SELECT id,x,y FROM spawn2 WHERE zone='%s' AND "

                                "ABS( ABS(x) - ABS(%f) ) &lt; %f AND "

                                "ABS( ABS(y) - ABS(%f) ) &lt; %f",

                                zone->GetShortName(), x, _GASSIGN_TOLERANCE, y, _GASSIGN_TOLERANCE

                        ),

                        errbuf,

                        &amp;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.