/** * @return unknown * @param $nick unknown * @param $password unknown * @param $email unknown * @param $phone unknown * @param $koords unknown * @desc Enter description here... */ function addUser($nick, $login, $password, $gid, $gala, $pos, $ircauth) { Assert::isNumeric($gid); Assert::isId($gala); Assert::isId($pos); $nick = mysql_real_escape_string($nick); $login = mysql_real_escape_string($login); $ircauth = mysql_real_escape_string($ircauth); $user = insertsql("insert into user (nick,login,password,gid,gala,pos,changepw,ircauth) values ('{$nick}','{$login}','" . md5($password) . "',{$gid},{$gala},{$pos},1,'{$ircauth}')"); for ($i = 0; $i < 3; $i++) { if ($i > 0) { $status = fleetstatus_get_bykoords($gala, $pos, $i); } if ($status['fid']) { $fid = $status['fid']; } else { $fid = fleet_add(); } insertsql("insert into user_fleet (gala,pos,fid,fleetnum) values ({$gala},{$pos},{$fid},{$i})"); } $position = getScan(array("gala" => $gala, "pos" => $pos)); if ($position) { scan_update_nick($gala, $pos, $nick); } else { scan_add($gala, $pos, array("nick" => $nick)); } return $user; }
function scan_update_nick($gala, $pos, $nick) { if (!$nick || !is_numeric($pos) || !is_numeric($gala)) { return false; } $scan = scan_get_bynick($nick); if ($scan) { if ($scan['gala'] != $gala || $scan['pos'] != $pos) { query("update scans set nick = null where gala = " . $scan['gala'] . " and pos = " . $scan['pos']); } return query("update scans set nick = '" . mysql_escape_string(trim($nick)) . "' where gala = " . $gala . " and pos = " . $pos); } else { $scan = getScan(array("gala" => $gala, "pos" => $pos)); if ($scan) { return query("update scans set nick = '" . mysql_escape_string(trim($nick)) . "' where gala = " . $gala . " and pos = " . $pos); } else { return scan_add($gala, $pos, array("nick" => $nick)); } } }