예제 #1
0
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();
}
예제 #2
0
        $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>
예제 #3
0
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;
}