[g-force2k2]

Actually hellsatan the coding doesn't look right at all from my pov... replace your code ::

PHP Code:

    if ($exists=$DB_site->query_first("SELECT userid FROM user WHERE username=".addslashes(htmlspecialchars($ausername))." AND userid <> $userid")) {
        echo "There is already an ".makelinkcode('user',"user.php?do=edit&userid=$exists[userid]",1)." named <b>".htmlspecialchars($ausername)."</b>";
        exit;
    } 


with::

PHP Code:

$exists = $DB_site->query_first("SELECT username FROM user WHERE username='".addslashes(htmlspecialchars($ausername))."' AND userid != $userid");
  if($exists[username] == "$ausername") {
     echo "<p>[ error message here]</p>";
     exit;
  } 


regards... also you forgot the ' slashes around addslashes

g-force2k2