Need help using arrays as coordinates

sledgeweb

Hello-

Let's say I have a game map and I'm storing player 1's X Y coordinates in a mysql database.

The game map goes from 1-10 in the X and Y direction. You can go off a side of the map, and appear on the opposite side (thus, you go from grid position 10 to 1).

Now, let's say there is a second player who's coordinates are also stored in mysql.

If I want to show player's 2 position on the map if he is within a given range of player 1, how can I go about doing this?

If the range is 4 units in the X or Y planes, and player 1 was at position x=2, y=4 it would need to search for player 2 x within (8,9,10, 1 and 3,4,5,6) and Y within (10, 1, 2, 3 and 5,6,7,8).

How can I accomplish this? Seems like an array would work, but I'm not exactly sure how to implement it.

Any suggestions?

Thanks,
Sledge

n00854180t

And do the same for the negative values. Then do a while loop and stick the results into an array maybe.

<?php

$sql = "SELECT * FROM player WHERE y <= y+4 AND x <= x+4 AND playername != $currentplayer";
$result = mysql_query($sql);


while ($posRow = mysql_fetch_array($result))
{

for ($i = 0; $i < 2; $i++)
{
    $player[$i] = $row['x'];
    $player[$i++] = $row['y'];
}
}

?>

Just thinking on paper here, I don't really know how viable this code is.

This should create an array named $player that will contain the coordinates of another player that is 4 points or below closer to the current player.

I dunno if it is any good. You would also need to figure out a way to select the negative coordinates (I mean, select x <= x-4). The only way I can think of is selecting from the DB twice and then checking the arrays to see if one or both are populated. Not very elegant though.