/**
* @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));
}
}
}
