예제 #1
0
파일: db.user.php 프로젝트: Bobsel/gn-tic
/**
 * @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;
}
예제 #2
0
function deffer_add($gala, $pos, $tgala, $tpos, $fleetnum, $returntime, $orbittime, $eta = null, $nick = null)
{
    if (!is_numeric($gala) || !is_numeric($pos) || !is_numeric($tgala) || !is_numeric($tpos) || !is_numeric($fleetnum)) {
        return false;
    }
    $insert = array();
    $insert['gala'] = $gala;
    $insert['pos'] = $pos;
    $insert['tgala'] = $tgala;
    $insert['tpos'] = $tpos;
    $insert['status'] = 2;
    $insert['orbittime'] = $orbittime;
    $insert['returntime'] = $returntime;
    if ($fleetnum) {
        $insert['fleetnum'] = $fleetnum;
        $user = user_fleet_get($gala, $pos, $fleetnum);
        if ($user['fid']) {
            $insert['fid'] = $user['fid'];
        }
    }
    if ($nick) {
        scan_update_nick($gala, $pos, $nick);
    }
    if (is_numeric($eta)) {
        $insert['arrival'] = gnarrival($eta);
    }
    return fleetstatus_add($insert);
}