function nuHashData() { $form_data = nuV('form_data'); $h['TABLE_ID'] = nuTT(); $h['RECORD_ID'] = nuV('record_id'); $h['FORM_ID'] = nuV('form_id'); $h['nu_browse_filter'] = nuV('filter'); $h['nu_edited_record'] = nuV('edited'); $h['nu_cloned_record'] = nuV('cloned'); $h['nu_new_record'] = nuV('record_id') == '-1' ? '1' : '0'; for ($f = 0; $f < count($form_data['data']); $f++) { if (array_key_exists('records', $form_data['data'][$f])) { for ($r = 0; $r < count($form_data['data'][$f]['records']); $r++) { if (isset($form_data['data'][$f]['records'][$r]['fields'])) { for ($i = 0; $i < count($form_data['data'][$f]['records'][$r]['fields']); $i++) { $fd = $form_data['data'][$f]['records'][$r]['fields'][$i]; if ($form_data['data'][$f]['subform'] == '') { $prefix = ''; } else { $prefix = $form_data['data'][$f]['subform'] . substr('000' . $r, -4); } $h[$prefix . $fd['field']] = $fd['value']; } if ($form_data['data'][$f]['subform'] != '') { $h[$form_data['data'][$f]['subform']][] = $prefix; if ($form_data['data'][$f]['records'][$r]['delete_record'] == 'no') { $h[$form_data['data'][$f]['subform'] . '_save'][] = $prefix; } } } } } } $v = nuV(); foreach ($v as $key => $value) { //-- add nuV() to form_data $used = false; if (isset($_POST['nuWindow']['form_data'])) { for ($i = 0; $i < count($_POST['nuWindow']['form_data']['data'][0]['records'][0]['fields']); $i++) { //-- reapply hash variables from calling edit page (incase over written by $_POST['nuWindow']) if ($_POST['nuWindow']['form_data']['data'][0]['records'][0]['fields'][$i]['field'] == $key) { $used = true; break; } } } if (!$used) { $add['field'] = $key; $add['value'] = $value; $add['save'] = '0'; $_POST['nuWindow']['form_data']['data'][0]['records'][0]['fields'][] = $add; } } $setup = $GLOBALS['nuSetup']; //-- Read SMTP AUTH Settings from zzsys_setup table $h['nu_denied'] = $setup->set_denied; //-- hide ids like .. eg. nu% $h['nu_smtp_username'] = $setup->set_smtp_username; $h['nu_smtp_password'] = $setup->set_smtp_password; $h['nu_smtp_host'] = $setup->set_smtp_host; $h['nu_smtp_from_address'] = $setup->set_smtp_from_address; $h['nu_smtp_port'] = $setup->set_smtp_port; $h['nu_smtp_use_ssl'] = $setup->set_smtp_use_ssl; $h['nu_smtp_from_name'] = $setup->set_smtp_from_name; $sessionData = nuSessionArray(nuV('session_id')); //-- user and access info $recordData = nuRecordArray(array_merge($sessionData, $h)); //-- record data foreach ($_POST['nuWindow'] as $key => $value) { //-- add current hash variables $h[$key] = $value; } if (isset($form_data['data'][0]['records'][0]['fields'])) { for ($i = 0; $i < count($form_data['data'][0]['records'][0]['fields']); $i++) { //-- reapply hash variables from calling edit page (incase over written by $_POST['nuWindow']) $fd = $form_data['data'][0]['records'][0]['fields'][$i]; $h[$fd['field']] = $fd['value']; } } return array_merge($recordData, $sessionData, $h); }
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; } }