コード例 #1
0
ファイル: nucommon.php プロジェクト: natanoj/nuBuilderPro
function nuNextNumber($t)
{
    $l = db_columns($t);
    //-- 2 columns (Primary Key, varchar(25))
    $u = nuID();
    $s = "INSERT INTO `{$t}` SET `{$l['1']}` = ? ";
    //-- insert to create next number
    $i = nuRunQuery($s, array($u), true);
    $s = "SELECT `{$l['0']}` FROM `{$t}` WHERE `{$l['1']}` = ? ";
    //-- get next number
    $t = nuRunQuery($s, array($u));
    $r = db_fetch_row($t);
    return $r[0];
    //-- return next number
}
コード例 #2
0
ファイル: nuapi.php プロジェクト: ktla/nuBuilderPro
function nuLogin($u, $p)
{
    $ip = $_SERVER['REMOTE_ADDR'];
    $i = nuID();
    $time = time();
    if ($u == 'globeadmin' and $p == $_SESSION['DBGlobeadminPassword']) {
        //-- globeadmin
        $s = "INSERT INTO zzzsys_session (zzzsys_session_id, sss_zzzsys_user_id, sss_timeout) VALUES ('{$i}','globeadmin', {$time})";
        nuRunQuery($s);
        nuV('nu_timeout', $time);
        nuCreateLog($i, 'globeadmin');
        if (nuErrorFound()) {
            return;
        }
        $sessionData = nuSessionArray($i);
        $A['index_id'] = 'nuindex';
        $A['session_id'] = $i;
        nuSet_SESSION($i, $u);
        //-- add accessible forms, php and reports
        return $A;
    }
    $s = "\n        SELECT *\n        FROM zzzsys_user \n        WHERE (sus_login_name = ? AND sus_login_password = md5(CONCAT(?, ?))) \n                                  AND zzzsys_user_id != 'globeadmin'\n    ";
    $t = nuRunQuery($s, array($u, $u, $p));
    if (nuErrorFound()) {
        return;
    }
    $r = db_fetch_object($t);
    if ($r->zzzsys_user_id == '') {
        //-- normal user
        $A['session_id'] = 'Login Failed';
        return $A;
    } else {
        $s = "INSERT INTO zzzsys_session (zzzsys_session_id, sss_zzzsys_user_id, sss_timeout) VALUES ('{$i}','{$r->zzzsys_user_id}', {$time})";
        nuRunQuery($s);
        nuV('nu_timeout', $time);
        nuCreateLog($i, $r->zzzsys_user_id);
        if (nuErrorFound()) {
            return;
        }
        $sessionData = nuSessionArray($i);
        $A['index_id'] = $sessionData['nu_index_id'];
        $A['session_id'] = $i;
        nuSet_SESSION($i, $u);
        //-- add accessible forms, php and reports
        return $A;
    }
}