necrotic — Tue, 05 Nov 2002 16:53:34 +0000

Mark, I tried yours. It's good, but I had to change something:

<?php
    if($result) {
      $row=$DB_site->fetch_array($result);
      if ($row[id]!=\"\") {
        $lid = $row[id];
        $location = $row[name];
      }
    } else {
      $lid = '0';
      $location = 'Wilderness';
    }
?>

the While() statement wasn't working

Mark Hensler — Mon, 04 Nov 2002 20:38:42 +0000

<?php
$query = \"SELECT *\"
        .\" FROM rpg_locations\"
        .\" WHERE ( xmax > ($x+5)\"
        .\"         OR xmin < ($x-5) )\"
        .\"     AND ( ymax > ($y+5)\"
        .\"         OR ymin < ($y-5) )\"
        .\" ORDER BY id DESC\";

$result=$DB_site->query($query);
while ($result && $row=$DB_site->fetch_array($result)) {
    if ($row[id]!=\"\") {
        $lid = $row[id];
        $location = $row[name];
    }
    else {
        $lid = '0';
        $location = 'Wilderness';
    }
    $DB_site->query(\"UPDATE user SET location='$lid'\");
    Location();
}
?>

That will change the location once for each record found. And all records in the `user` will be affected.

necrotic — Mon, 04 Nov 2002 20:16:42 +0000

Ok, this is the code I came up with:

<?php
$query = $DB_site->query(\"SELECT * FROM rpg_locations ORDER by id DESC\");
$maxr = $DB_site->num_rows($query);

for($coord[xmax]='1000'; $x+5 > $coord[xmax]; $coord[xmax]--) {
  for($coord[xmin]='0'; $x-5 > $coord[xmin]; $coord[xmin]++) {
    for($coord[ymax]='1000'; $y+5 > $coord[ymax]; $coord[ymax]--) {
      for($coord[ymin]='0'; $y-5 > $coord[ymin]; $coord[ymin]++) {
        $query=$DB_site->query(\"SELECT * FROM rpg_locations WHERE xmax='$coord[xmax]' AND xmin='$coord[xmin]' AND ymax='$coord[ymax]' AND ymin='$coord[ymin]'\");
        $result=$DB_site->fetch_array($query);
        if ($result) {
          $lid = $result[id];
          $location = $result[name];
        } else {
          $lid = '0';
          $location = 'Wilderness';
        }
        $DB_site->query(\"UPDATE user SET location='$lid'\");
        Location();
      }
    }
  }
}

function Location() {
....
}
?>

I'll be testing it out in a few minutes.

necrotic — Mon, 04 Nov 2002 04:11:16 +0000

I brainstormed for about 1.5 hours tonight on how to do this. I'll post it tomorrow because I'm going to bed tonight. But I think it will work.

Mark Hensler — Mon, 04 Nov 2002 01:49:00 +0000

Should be an OR, not an AND in the WHERE clause.
I don't know of any numbers that are both 5 above and 5 below a given constant.

zollet — Mon, 04 Nov 2002 00:00:36 +0000

necrotic, I'm not sure if I understand you correctly or not, but do you want to select MySQL rows that are 5 more or less than a given number? If so...

SELECT * FROM rpg_locations WHERE column <= $nr + 5 OR column >= $nr - 5 ORDER BY id DESC

necrotic — Sun, 03 Nov 2002 23:44:37 +0000

I think this is how I would do it:

<?php
$query = $DB_site->query(\"SELECT * FROM rpg_locations ORDER by id DESC\");
while($mapr = $DB_site->fetch_array($query)) {
  $mx = $mapr[x];
  $my = $mapr[y];
  while($x != (($mx - 5) || ($mx - 4) || ($mx - 3) || ($mx - 2) || ($mx - 1) || ($mx) || ($mx + 1) || ($mx + 2) || ($mx + 3) || ($mx + 4) || ($mx + 5))) {
    while($y != (($my - 5) || ($my - 4) || ($my - 3) || ($my - 2) || ($my - 1) || ($my) || ($my + 1) || ($my + 2) || ($my + 3) || ($my + 4) || ($my + 5))) {
      $y++;
    }
    $x++;
    }
  }
}
?>

But I was hoping I could condense it some way...

Mark Hensler — Sun, 03 Nov 2002 22:49:31 +0000

I'm corn-fuzed.

Do you want to always add 5 to the x,y coordinate? I'm guessing not, as that shouldn't require a 5MB file.

What does mySQL have to do with this problem?
(what do your tables look like)

How do you identify which 'location' to set 'you' to?
(are there any rules/formulas to follow)