PHP reset_forwardの例

コード例 #1

ファイル: kill_user.php プロジェクト: brianhuang1019/brianhuang1019.github.io

 }
 $logintime = strtotime($result[0]);
 $curtime = time();
 if ($curtime - $logintime <= 180) {
     continue;
 } else {
     // if time is up
     $sql = "SELECT * FROM `ip_flow` WHERE `user` LIKE '{$user}'";
     $data = mysql_query($sql, $link);
     $result = mysql_fetch_row($data);
     $history = $result[2] + $result[1];
     $sql = "UPDATE `INFO`.`ip_flow` SET `cur_flow` = '0' , `his_flow` = '{$history}' WHERE `user` LIKE '{$user}'";
     $data = mysql_query($sql, $link);
     $sql = "DELETE FROM `login_table` WHERE `ID` LIKE '" . $user . "'";
     $data = mysql_query($sql, $link);
     reset_forward($ip);
     $sql = "SELECT * FROM `time` WHERE `ID` LIKE '" . $user . "'";
     $data = mysql_query($sql, $link);
     $result = mysql_fetch_row($data);
     $his_time = $result[2];
     $sql = "SELECT TIMEDIFF( NOW() , '" . $result[1] . "' )";
     $data = mysql_query($sql, $link);
     $result = mysql_fetch_row($data);
     $interval = $result[0];
     $sql = "SELECT ADDTIME( '" . $his_time . "' , '" . $interval . "' )";
     $data = mysql_query($sql, $link);
     $result = mysql_fetch_row($data);
     $his_time = $result[0];
     $sql = "UPDATE `INFO`.`time` SET `history` = '" . $his_time . "' WHERE `ID` = '" . $user . "'";
     $data = mysql_query($sql, $link);
 }

コード例 #2

ファイル: root_act.php プロジェクト: brianhuang1019/brianhuang1019.github.io

if ($_POST['Lsubmit']) {
    $user = $_POST['Lsubmit'];
    $sql = "SELECT * FROM `login_table` WHERE `ID` LIKE '" . $user . "'";
    $data = mysql_query($sql, $DB);
    $result = mysql_fetch_row($data);
    if ($result[0]) {
        $client = $result[2];
        $sql = "SELECT * FROM `ip_flow` WHERE `user` LIKE '{$user}'";
        $data = mysql_query($sql, $DB);
        $result = mysql_fetch_row($data);
        $history = $result[2] + $result[1];
        $sql = "UPDATE `INFO`.`ip_flow` SET `cur_flow` = '0' , `his_flow` = '{$history}' WHERE `user` LIKE '{$user}'";
        $data = mysql_query($sql, $DB);
        $sql = "DELETE FROM `login_table` WHERE `ID` LIKE '" . $user . "'";
        $data = mysql_query($sql, $DB);
        reset_forward($client);
    }
}
if ($_POST['Fsubmit']) {
    $user = $_POST['Fsubmit'];
    $sql = "UPDATE `INFO`.`ip_flow` SET `cur_flow` = '0' , `his_flow` = '0' WHERE `ID` LIKE '" . $user . "'";
    $data = mysql_query($sql, $DB);
}
if ($_POST['Tsubmit']) {
    $user = $_POST['Tsubmit'];
    $sql = "UPDATE `INFO`.`time` SET `login_time` = '' , `history` = '' WHERE `ID` LIKE '" . $user . "'";
    $data = mysql_query($sql, $DB);
}
if ($_POST['newuser']) {
    $sql = "INSERT INTO user_id VALUES('" . $_POST['newuser'] . "','" . $_POST['newpasswd'] . "')";
    $data = mysql_query($sql, $DB);

コード例 #3

ファイル: logout_action.php プロジェクト: brianhuang1019/brianhuang1019.github.io

    echo $sql . "<br>";
    $data = mysql_query($sql, $DB);
    $result = mysql_fetch_row($data);
    $history = $result[2] + $result[1];
    echo $history . "<br>";
    $sql = "UPDATE `INFO`.`ip_flow` SET `cur_flow` = '0' , `his_flow` = '{$history}' WHERE `user` LIKE '{$user}'";
    $data = mysql_query($sql, $DB);
    $sql = "SELECT * FROM `login_table` WHERE `ID` LIKE '{$user}'";
    $data = mysql_query($sql, $DB);
    $result = mysql_fetch_row($data);
    $client_old = $result[2];
    $client_mac_old = $result[1];
    $sql = "UPDATE `INFO`.`login_table` SET `MAC` = '{$client_mac}' , `IP` = '" . $_SERVER['REMOTE_ADDR'] . "' WHERE `ID` LIKE '{$user}'";
    $data = mysql_query($sql, $DB);
    //	reset_forward_mac($client_mac_old);
    reset_forward($client_old);
    //	set_forward_mac($client_mac);
    set_forward($client);
}
$sql = "SELECT * FROM `time` WHERE `ID` LIKE '" . $user . "'";
$data = mysql_query($sql, $DB);
$result = mysql_fetch_row($data);
$his_time = $result[2];
echo "<br>" . $sql . "<br>" . $his_time . "<br>";
$sql = "SELECT TIMEDIFF( NOW() , '" . $result[1] . "' )";
$data = mysql_query($sql, $DB);
$result = mysql_fetch_row($data);
$interval = $result[0];
echo $sql . "<br>" . $internal . "<br>";
$sql = "SELECT ADDTIME( '" . $his_time . "' , '" . $interval . "' )";
$data = mysql_query($sql, $DB);