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