$db_version = '3.2.1';
$db_server = 'localhost';
$db_user='';
$db_name='';
$db_passwort='';
$db = @ mysqli_connect ( $db_server, $db_user, $db_passwort )
or die ( 'Konnte keine Verbindung zur Datenbank herstellen' );
$db_check = @ mysqli_select_db ($db, $db_name );
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>
if (isset($_GET['sql'])){
$in_sql = $_GET['sql'];
$result = mysqli_query( $db, $in_sql );
echo("num rows:" . mysqli_num_rows ( $result ) . "\n");
for ($i = 0; $i <= mysqli_num_rows ( $result ); $i++) {
$row = mysqli_fetch_array ( $result );
print_r ($row);
}
}
if (isset($_GET['r'])){
$in_room = $_GET['r'];
if (isset($_GET['n'])){
$in_index = $_GET['g'];
$in_user = $_GET['n'];
$in_msg = $_GET['m'];
$in_data = $_POST['msg'];
if (isset($_POST['user'])){
$in_user = $_POST['user'];
}
if (strtolower($in_msg)=="data"){
$in_msg = $in_data;
}
$cmd = strstr($in_msg, ' ', true);
if (strlen($cmd)!=0 ){
$param = strstr($in_msg, ' ');
$param = substr($param, 1);
if (isset($_POST['pw'])){
$param = $_POST['pw'];
}
if ($in_room!="chatroom_" && $in_room!="NICK" && $in_room!="" && $in_room!="0" && $in_room!="chat_user"){
$sql = "SELECT `MESSAGE` FROM `" . $in_room . "` WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
if ($result) {
$row = mysqli_fetch_row ( $result );
$users=$row[0];
}
}else{
$users="";
}
if (strtolower($cmd)=="loginneu"){
$cmd="fertig";
$sql = "SELECT `ID`,`PASSWORT`,`STATUS` FROM `chat_user` WHERE `USERNAME`=\"" . $in_user . "\"";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
if (empty($row[0])) {
echo("NOTEXIST!");
}else{
if ($row[1] == hash('sha256', $param)){
if (strpos($users, $in_user)===false){
echo("OK!" . $row[2]);
}else{
echo("USERALLREADYLOGIN!" . $row[2]);
}
}else{
echo("WRONGPW!");
}
}
}
}
if (strtolower($cmd)=="registerneu"){
$cmd="fertig";
$sql = "SELECT `ID` FROM `chat_user` WHERE `USERNAME`=\"" . $in_user . "\"";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
if (empty($row[0])) {
$hash = hash('sha256', $param);
$sql = "INSERT INTO `chat_user`(`USERNAME`, `PASSWORT`, `STATUS`) VALUES ('$in_user','$hash','NEW' )";
$result = mysqli_query( $db, $sql );
$sql = "SELECT `ID`,`PASSWORT` FROM `chat_user` WHERE `USERNAME`=\"" . $in_user . "\"";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
echo($row[0]);
}
}
}
}
if (strtolower($cmd)=="getpassword"){
$cmd="fertig";
$sql="SELECT `MESSAGE` FROM `" . $in_room . "` WHERE `ID`=96;";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
echo($row[0]);
}
}
if (strtolower($cmd)=="setpassword"){
$cmd="fertig";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$param' WHERE `ID`=96";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="clearpassword"){
$cmd="fertig";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='' WHERE `ID`=96";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="deleteroom"){
$cmd="fertig";
$sql="DROP TABLE IF EXISTS `" . $param . "`;";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="createroom"){
$cmd="fertig";
$sql="DROP TABLE IF EXISTS `" . $param . "`;";
$result = mysqli_query( $db, $sql );
$sql="CREATE TABLE `" . $param . "` ( `ID` int(11) NOT NULL,`USER` text NOT NULL,`MESSAGE` longtext NOT NULL,`TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
$result = mysqli_query( $db, $sql );
$sql="INSERT INTO `" . $param . "` (`ID`, `USER`, `MESSAGE`, `TIMESTAMP`) VALUES (0, '1', '', '2000-02-02 23:00:00');";
$result = mysqli_query( $db, $sql );
for ($i = 1; $i <= 100; $i++) {
$sql="INSERT INTO `" . $param . "` (`ID`, `USER`, `MESSAGE`, `TIMESTAMP`) VALUES(" . $i . ", '" . $in_user . "', '', '2000-02-02 23:00:00');";
$result = mysqli_query( $db, $sql );
}
$sql="ALTER TABLE `" . $param . "` ADD PRIMARY KEY (`ID`);";
$result = mysqli_query( $db, $sql );
$result = mysqli_query( $db, "COMMIT;" );
$info="Neuer Raum " . $param . " wurde erstellt";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="registeradmin"){
$cmd="fertig";
$sql = "SELECT `ID` FROM `chat_user` WHERE `USERNAME`=\"" . $in_user . "\"";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
if (empty($row[0])) {
$hash = hash('sha256', $param);
$sql = "INSERT INTO `chat_user`(`USERNAME`, `PASSWORT`, `STATUS`) VALUES ('$in_user','$hash','ADMIN' )";
$result = mysqli_query( $db, $sql );
$sql = "SELECT `ID`,`PASSWORT` FROM `chat_user` WHERE `USERNAME`=\"" . $in_user . "\"";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
echo($row[0]);
}
}
}
}
if (strtolower($cmd)=="setuserstatus"){
$cmd="fertig";
$sql = "UPDATE `chat_user` SET `STATUS`='$param' WHERE `USERNAME`='$in_user';";
$result = mysqli_query( $db, $sql );
$info=$in_user . " is now " . $param;
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98;";
$result = mysqli_query( $db, $sql );
//echo($sql);
echo("Set User: " . $in_user . " Status: " . $param);
}
if (strtolower($cmd)=="getuserstatus"){
$cmd="fertig";
$sql = "SELECT `STATUS` FROM `chat_user` WHERE `USERNAME`='$param'";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
echo($row[0]);
}
}
if (strtolower($cmd)=="deleteuser"){
$cmd="fertig";
$sql = "DELETE FROM `chat_user` WHERE `USERNAME`='$param'";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="getrooms"){
$cmd="fertig";
$sql = "SHOW TABLES";
$result = mysqli_query( $db, $sql );
if ($result){
for ($i = 0; $i <= mysqli_num_rows ( $result ); $i++) {
$row = mysqli_fetch_array ( $result );
echo($row[0] . ";" );
}
}
}
if (strtolower($cmd)=="privatmsg"){
$cmd="fertig";
$sql = "SELECT `USER` FROM `" . $in_room . "` WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
if ($result) {
$row = mysqli_fetch_row ( $result );
$lastindex=$row[0];
$lastindex++;
if ($lastindex>90) {
$lastindex=1;
}
$date = new DateTime();
$db_date = $date->format('Y-m-d H:i:s');
$sql = "UPDATE `" . $in_room . "` SET `USER`='$in_user', `MESSAGE`='$param', `TIMESTAMP`='$db_date' WHERE `ID`=$lastindex";
$result = mysqli_query( $db, $sql );
if (!$result) {
die('Invalid query: ' . mysqli_error());
}
$sql = "UPDATE `" . $in_room . "` SET `USER`='$lastindex' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
echo($param);
}
}
if (strtolower($cmd)=="user"){
$cmd="fertig";
echo($users . "%");
}
if (strtolower($cmd)=="userinfo"){
$cmd="fertig";
echo($users . "%");
}
if (strtolower($cmd)=="admins"){
$cmd="fertig";
$sql="SELECT `USER` FROM `" . $in_room . "` WHERE `ID`=97;";
$result = mysqli_query( $db, $sql );
$row = mysqli_fetch_row($result);
echo($row[0] . ";");
$sql="SELECT `MESSAGE` FROM `" . $in_room . "` WHERE `ID`=97;";
$result = mysqli_query( $db, $sql );
$row = mysqli_fetch_row($result);
echo($row[0]);
}
if (strtolower($cmd)=="setadmins"){
$cmd="fertig";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$param' WHERE `ID`=97";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="clearadmins"){
$cmd="fertig";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='' WHERE `ID`=97";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="alluser"){
$cmd="fertig";
$sql="SELECT `USERNAME` FROM `chat_user`;";
$result = mysqli_query( $db, $sql );
while($row = mysqli_fetch_row($result)){
echo($row[0] . ";");
}
}
if (strtolower($cmd)=="alluserstatus"){
$cmd="fertig";
$sql="SELECT `USERNAME`,`STATUS` FROM `chat_user`;";
$result = mysqli_query( $db, $sql );
while($row = mysqli_fetch_row($result)){
echo($row[0] . " (" . $row[1] . ");");
}
}
if (strtolower($cmd)=="info"){
$cmd="fertig";
if ($in_room!=""){
$sql = "SELECT `MESSAGE` FROM `" . $in_room . "` WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
if ($result) {
$row = mysqli_fetch_row ( $result );
$lastindex=$row[0];
echo($lastindex . "%");
}
}
}
if (strtolower($cmd)=="setstatus"){
$cmd="fertig";
echo($in_msg . ":" . $param);
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$in_data' WHERE `ID`=99";
$result = mysqli_query( $db, $sql );
$info = "greeting text has been reset";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="setinfo"){
$cmd="fertig";
$d = new DateTime($row[3]);
$out_date = $d->format('Y-m-d H:i:s');
$msg=$in_user . ": " . $param . " < " . $out_date . " >";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$msg' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="idle"){
$cmd="fertig";
$msg=$in_user . $param;
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$msg' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="killall"){
$cmd="fertig";
echo($in_msg . ":" . $param);
$users="";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$users' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
$info = "userlist has been deleted";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
if (strtolower($cmd)=="nick"){
$cmd="fertig";
echo($in_msg . ":" . $param);
if (strpos($users, $in_user)){
$in_user = ";" . $in_user;
$param = ";" . $param;
$users = str_replace($in_user, $param, $users);
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$users' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
}
}
if (strtolower($cmd)=="login"){
$cmd="fertig";
echo($in_msg . ":" . $param);
$date = new DateTime();
$db_date = $date->format('Y-m-d H:i:s');
if (strpos($users, $in_user)===false){
$users = $users . ";" . $in_user;
$users = str_replace(";;" , ";" , $users);
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$users' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
$info = $in_user . " has entered the room " . $in_room . " < " . $db_date . " >";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}else{
$in_user = ";" . $in_user;
$users = str_replace($in_user . ";", ";", $users . ";");
if ($users==";") $users="";
$users = str_replace(";;" , ";" , $users);
$users = $users . $in_user;
$users = str_replace(";;" , ";" , $users);
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$users' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
$info = $in_user . " has entered the room " . $in_room . " < " . $db_date . " >";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
}
if (strtolower($cmd)=="logout"){
$cmd="fertig";
echo($in_msg . ":" . $param);
$date = new DateTime();
$db_date = $date->format('Y-m-d H:i:s');
if (strpos($users, $in_user)){
$in_user = ";" . $in_user;
$users = str_replace($in_user . ";", ";", $users . ";");
if ($users==";") $users="";
$users = str_replace(";;" , ";" , $users);
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$users' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
$info = $in_user . " has left the room " . $in_room . " < " . $db_date . " >";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
}
if (strtolower($cmd)=="room"){
$cmd="fertig";
echo($in_msg . ":" . $param);
$date = new DateTime();
$db_date = $date->format('Y-m-d H:i:s');
if (strpos($users, $in_user)){
$in_user = ";" . $in_user;
$users = str_replace($in_user, "", $users);
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$users' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
$info = $in_user . " has changed the room" . " < " . $db_date . " >";
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
}
if (strtolower($cmd)=="kick"){
$cmd="fertig";
$sql = "SELECT `STATUS` FROM `chat_user` WHERE `USERNAME`='$param'";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$status=$row[0];
}
if (strpos($users, $param)){
$param = ";" . $param;
if (strtolower($status)!="vip"){
$users = str_replace($param . ";", ";", $users . ";");
if ($users==";") $users="";
$users = str_replace(";;" , ";" , $users);
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$users' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
$info = $param . " was kicked by " . $in_user;
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}else{
$info = $in_user . " user tried to kick " . $param;
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='$info' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
}
}
if (strtolower($cmd)=="delete"){
$cmd="fertig";
if (strtolower($param)=="msg"){
for ($i = 1; $i <= 90; $i++) {
$sql="UPDATE `" . $in_room . "` SET `MESSAGE`='' WHERE `ID`=" . $i . ";";
$result = mysqli_query( $db, $sql );
}
$sql = "UPDATE `" . $in_room . "` SET `MESSAGE`='chat history has been deleted' WHERE `ID`=98";
$result = mysqli_query( $db, $sql );
}
}
if (strtolower($cmd)=="editwitz"){
$cmd="fertig";
$sql = "UPDATE `chat_witze` SET `WITZ`='$in_data' WHERE `ID`=" . $in_user . ";";
$result = mysqli_query( $db, $sql );
echo($result);
}
if (strtolower($cmd)=="witz"){
$cmd="fertig";
$sql = "SELECT `ID` FROM `chat_witze`;";
if (!$result=mysqli_query($db,$sql)){
$sql="CREATE TABLE `chat_witze` (`ID` int(11) NOT NULL,`USERNAME` text NOT NULL,`WITZ` text NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
if (!mysqli_query( $db, $sql )){
echo("Fehler");
}
$sql="ALTER TABLE `chat_witze` ADD PRIMARY KEY (`ID`);";
mysqli_query( $db, $sql );
$sql="ALTER TABLE `chat_witze` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;";
mysqli_query( $db, $sql );
}
if (is_numeric($param)){
if ($param==0){
$sql="SELECT `ID` FROM `chat_witze` ORDER BY id DESC LIMIT 1";
if ($result=mysqli_query($db,$sql)){
$row = mysqli_fetch_row ( $result );
if ($row!=NULL){
echo($row[0]);
}else{
echo($param);
}
}
}else{
$sql = "SELECT `WITZ` FROM `chat_witze` WHERE `ID`=" . $param . ";";
if ($result=mysqli_query($db,$sql)){
$row = mysqli_fetch_row ( $result );
if ($row!=NULL){
echo($row[0]);
}else{
echo("joke not found (ID=" . $param . ")");
}
}
}
}else{
$sql = "INSERT INTO `chat_witze`(`USERNAME`, `WITZ`) VALUES ('$in_user','$in_data' )";
$result = mysqli_query( $db, $sql );
$sql="SELECT `ID` FROM `chat_witze` ORDER BY id DESC LIMIT 1";
if ($result=mysqli_query($db,$sql)){
$row = mysqli_fetch_row ( $result );
if ($row!=NULL){
echo($row[0]);
}
}
}
}
if (strtolower($cmd)=="webmsg"){
$cmd="fertig";
$date = new DateTime();
$db_date = $date->format('Y-m-d H:i:s');
$sql = "INSERT INTO `webchat_lines`(`author`, `gravatar`, `text`, `ts`) VALUES ('$in_user','e17bf7e576babb102cb995b7879b7afa','$param','$db_date' )";
$result = mysqli_query( $db, $sql );
if ($result) {
echo("Send WebChat Success");
}else{
echo("Send WebChat Failed");
}
}
if (strtolower($cmd)=="webnotify"){
$cmd="fertig";
$date = new DateTime();
$db_date = $date->format('Y-m-d H:i:s');
$sql = "INSERT INTO `webchat_lines`(`author`, `gravatar`, `text`, `ts`) VALUES ('$in_user','48a5933dc2420a81ae19d8769837cb0d','$param','$db_date' )";
$result = mysqli_query( $db, $sql );
if ($result) {
echo("Send WebChat Success");
}else{
echo("Send WebChat Failed");
}
}
if (strtolower($cmd)=="version"){
$cmd="fertig";
$new = "OK";
$sql = "SELECT `ID` FROM `chat_user`;";
if ($result=mysqli_query($db,$sql)){
$row = mysqli_fetch_row ( $result );
}else{
$sql="CREATE TABLE `chat_user` (`ID` int(11) NOT NULL,`USERNAME` text NOT NULL,`PASSWORT` text NOT NULL,`STATUS` text NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
if (!mysqli_query( $db, $sql )){
echo("Warum nit");
}
$sql="ALTER TABLE `chat_user` ADD PRIMARY KEY (`ID`);";
mysqli_query( $db, $sql );
$sql="ALTER TABLE `chat_user` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;";
mysqli_query( $db, $sql );
$new="NEW";
}
echo($db_version . "|" . $new);
}
if ($cmd!="fertig"){
$sql = "SELECT `USER` FROM `" . $in_room . "` WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$lastindex=$row[0];
$lastindex++;
if ($lastindex>90) {
$lastindex=1;
}
$date = new DateTime();
$db_date = $date->format('Y-m-d H:i:s');
$sql = "UPDATE `" . $in_room . "` SET `USER`='$in_user', `MESSAGE`='$in_msg', `TIMESTAMP`='$db_date' WHERE `ID`=$lastindex";
$result = mysqli_query( $db, $sql );
if (!$result) {
die('Invalid query: ' . mysqli_error());
}
$sql = "UPDATE `" . $in_room . "` SET `USER`='$lastindex' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
}
}
echo( "%" . $in_msg);
}else{
$sql = "SELECT `USER` FROM `" . $in_room . "` WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$lastindex=$row[0];
$lastindex++;
if ($lastindex>90) {
$lastindex=1;
}
$date = new DateTime();
$db_date = $date->format('Y-m-d H:i:s');
$sql = "UPDATE `" . $in_room . "` SET `USER`='$in_user', `MESSAGE`='$in_msg', `TIMESTAMP`='$db_date' WHERE `ID`=$lastindex";
$result = mysqli_query( $db, $sql );
if (!$result) {
die('Invalid query: ' . mysqli_error());
}
$sql = "UPDATE `" . $in_room . "` SET `USER`='$lastindex' WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
if ($in_index<$lastindex){
for ($i = $in_index + 1; $i <= $lastindex; $i++) {
$sql = "SELECT * FROM `" . $in_room . "` WHERE `ID`=$i";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$d = new DateTime($row[3]);
$out_date = $d->format('Y-m-d H:i:s');
echo($row[0] . ";" . $row[1] . ";" . $out_date . ";" . $row[2] . "|");
}
}
}else{
if ($in_index<90){
for ($i = $in_index + 1; $i <= 10; $i++) {
$sql = "SELECT * FROM `" . $in_room . "` WHERE `ID`=$i";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$d = new DateTime($row[3]);
$out_date = $d->format('Y-m-d H:i:s');
echo($row[0] . ";" . $row[1] . ";" . $out_date . ";" . $row[2] . "|");
}
}
}
for ($i = 1; $i <= $lastindex; $i++) {
$sql = "SELECT * FROM `" . $in_room . "` WHERE `ID`=$i";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$d = new DateTime($row[3]);
$out_date = $d->format('Y-m-d H:i:s');
echo($row[0] . ";" . $row[1] . ";" . $out_date . ";" . $row[2] . "|");
}
}
}
}
}
}else{
$in_index = $_GET['g'];
$sql = "SELECT `USER` FROM `" . $in_room . "` WHERE `ID`=0";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$lastindex=$row[0];
if ($in_index==0){
for ($i = $lastindex + 1; $i <= 90; $i++) {
$sql = "SELECT * FROM `" . $in_room . "` WHERE `ID`=$i";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$d = new DateTime($row[3]);
$out_date = $d->format('Y-m-d H:i:s');
echo($row[0] . ";" . $row[1] . ";" . $out_date . ";" . $row[2] . "|");
}
}
for ($i = 1; $i <= $lastindex; $i++) {
$sql = "SELECT * FROM `" . $in_room . "` WHERE `ID`=$i";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$d = new DateTime($row[3]);
$out_date = $d->format('Y-m-d H:i:s');
echo($row[0] . ";" . $row[1] . ";" . $out_date . ";" . $row[2] . "|");
}
}
}else{
if ($in_index==$lastindex){
echo($lastindex);
}else{
if ($in_index<$lastindex){
for ($i = $in_index + 1; $i <= $lastindex; $i++) {
$sql = "SELECT * FROM `" . $in_room . "` WHERE `ID`=$i";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$d = new DateTime($row[3]);
$out_date = $d->format('Y-m-d H:i:s');
echo($row[0] . ";" . $row[1] . ";" . $out_date . ";" . $row[2] . "|");
}
}
}else{
if($in_index==100){
$date = new DateTime();
$server_date = $date->format('Y-m-d H:i:s');
$sql = "SELECT * FROM `" . $in_room . "` WHERE `ID`=99";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
echo($lastindex . ";". $row[2] .";" . "" . ";|");
}
}
else{
if ($in_index<90){
for ($i = $in_index + 1; $i <= 90; $i++) {
$sql = "SELECT * FROM `" . $in_room . "` WHERE `ID`=$i";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$d = new DateTime($row[3]);
$out_date = $d->format('Y-m-d H:i:s');
echo($row[0] . ";" . $row[1] . ";" . $out_date . ";" . $row[2] . "|");
}
}
}
for ($i = 1; $i <= $lastindex; $i++) {
$sql = "SELECT * FROM `" . $in_room . "` WHERE `ID`=$i";
$result = mysqli_query( $db, $sql );
if ($result){
$row = mysqli_fetch_row ( $result );
$d = new DateTime($row[3]);
$out_date = $d->format('Y-m-d H:i:s');
echo($row[0] . ";" . $row[1] . ";" . $out_date . ";" . $row[2] . "|");
}
}
}
}
}
}
}
}
}
?>