diff options
Diffstat (limited to 'protected')
| -rw-r--r-- | protected/backend.php | 35 |
1 files changed, 19 insertions, 16 deletions
diff --git a/protected/backend.php b/protected/backend.php index 74912ff..555a4fc 100644 --- a/protected/backend.php +++ b/protected/backend.php @@ -5,14 +5,14 @@ $msg = isset($_POST['msg']) ? $_POST['msg'] : ''; $room = isset($_POST['room']) ? $_POST['room'] : ''; $time = date("H:i:s", time() + 0 * 3600); $id = isset($_POST['id']) ? $_POST['id'] : ''; -$stamp=microtime(TRUE); +$stamp = microtime(TRUE); require_once "getsafe.php"; -$id= PAPI_GetSafeParam($id, "", XH_PARAM_TXT); -$room= PAPI_GetSafeParam($room, "", XH_PARAM_TXT); -//$msg= PAPI_GetSafeParam($msg, "", XH_PARAM_TXT); +$id = PAPI_GetSafeParam($id, "", XH_PARAM_TXT); +$room = PAPI_GetSafeParam($room, "", XH_PARAM_TXT); +//$msg = PAPI_GetSafeParam($msg, "", XH_PARAM_TXT); if ($msg != '') { - $sql="INSERT INTO record (room,user,time,content,timestamp) VALUES ('$room','$id','$time','$msg','$stamp')"; + $sql = "INSERT INTO record (room,user,time,content,timestamp) VALUES ('$room','$id','$time','$msg','$stamp')"; @mysql_query($sql); $response = array(); $response['msg'] = $msg; @@ -22,23 +22,26 @@ if ($msg != '') flush(); die(); } -$time= isset($_POST['time']) ? $_POST['time'] : ''; -$time= PAPI_GetSafeParam($time, "", XH_PARAM_TXT); -$stamp= isset($_POST['stamp']) ? $_POST['stamp'] : ''; -$stamp= PAPI_GetSafeParam($stamp, "", XH_PARAM_TXT); -$sql="select * from record where timestamp>'$stamp' and room='$room' order by timestamp ASC"; -$result=@mysql_query($sql); -$row=@mysql_num_rows($result); -while ($row==0) +$deletetime = $stamp-3600*24; +$sql = "delete from record where timestamp<'$deletetime'"; +@mysql_query($sql); +$time = isset($_POST['time']) ? $_POST['time'] : ''; +$time = PAPI_GetSafeParam($time, "", XH_PARAM_TXT); +$stamp = isset($_POST['stamp']) ? $_POST['stamp'] : ''; +$stamp = PAPI_GetSafeParam($stamp, "", XH_PARAM_TXT); +$sql = "select * from record where timestamp>'$stamp' and room='$room' order by timestamp ASC"; +$result = @mysql_query($sql); +$row = @mysql_num_rows($result); +while ($row == 0) { usleep(10000); // sleep 10ms to unload the CPU - $result=@mysql_query($sql); - $row=@mysql_num_rows($result); + $result = @mysql_query($sql); + $row = @mysql_num_rows($result); } // return a json array $response = array(); -$row=mysql_fetch_row($result); +$row = mysql_fetch_row($result); //{ $response['msg'] = $row[4]; $response['user'] = $row[2]; |