function user_info($mid, $pw) { benfund_connect(); $query = "select * from merchant where id = '{$mid}' && password = '******'"; $results = mysql_query($query) or die(mysql_error()); global $row; $row = mysql_fetch_array($results); mysql_close(); }
$msg_id = $msg_row[0]; $msg_from = $msg_row[1]; benfund_connect(); $from_result = mysql_query("SELECT name FROM merchant WHERE id='{$msg_from}'"); $from_row = mysql_fetch_array($from_result) or die(mysql_error()); $msg_from_name = $from_row['name']; $msg_to = $msg_row[2]; $msg_subject = $msg_row[3]; $msg_content = $msg_row[4]; $msg_date = $msg_row[5]; $msg_read = $msg_row[6]; $msg_reply = $msg_row[7]; $msg_deleted = $msg_row[8]; $msg_content_encoded = htmlspecialchars($msg_content); $msg_content_enc_slash = addslashes($msg_content_encoded); benfund_connect(); mysql_query("UPDATE messages SET new='1' WHERE id='{$msg_id}' AND to_mid='{$mid}'"); ?> <table width="100%"> <tr><td><span class="emphasis">From:</span></td><td><span class="emphasis"><?php echo $msg_from_name; ?> </span></td></tr> <tr><td><span class="emphasis">Date:</span></td><td><span class="emphasis"><?php echo $msg_date; ?> </span></td></tr> <tr><td colspan="2"><span class="subtitle"><?php echo $msg_subject; ?> </span></td></tr>
function future_past($func, $var) { //first get users time benfund_connect(); if ($m_type = 1 or $m_type = 2) { $chrono_query = "SELECT settings FROM merchant WHERE id = '{$mid}' LIMIT 1"; } elseif ($m_type = 3) { $chrono_query = "SELECT settings FROM client WHERE cid = '{$cid}' AND mid = '{$mid}' LIMIT 1"; } $chrono_result = mysql_query($chrono_query) or die(mysql_error()); $chrono_row = mysql_fetch_row($chrono_result); $settings = $chrono_row[0]; $settings_segment = explode("~", $settings); $chronology = $settings_segment[0]; //make current server time $time_now = date("ymdHis"); $time_seg = str_split($time_now, 2); //$time_seg = explode("-", $time_now); $m = $time_seg[0]; //month $d = $time_seg[1]; //day $y = $time_seg[2]; //year $H = $time_seg[3]; //hour $i = $time_seg[4]; //minute $s = $time_seg[5]; //second //get user time offset switch ($chronology) { case 0: //pacific standard $subtract = 20; break; case 1: //mountain $subtract = 19; break; case 2: //central $subtract = 18; break; case 3: //eastern $subtract = 17; break; case 4: //hawaii $subtract = 22; break; case 5: //alaska $subtract = 21; break; default: $subtract = 20; } //apply user time offest and time variable switch ($func) { case '-': //Subtract Var $nHi = $H - $subtract; $nH = $nHi - $var; break; case '+': //Add Var $nHi = $H - $subtract; $nH = $nHi + $var; break; } //$nH = $H -$subtract ; //$timestamp = mktime($nH , $i, $s, $m, $d, $y); $timestamp = $nH . ', ' . $i . ', ' . $s . ', ' . $m . ', ' . $d . ', ' . $y; $future_past = date("ymdHis", mktime($timestamp)); return $future_past; }