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