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 }
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; } }