function getUser($prevRoom, $roomID) { $loginError = '0'; // include files include getDocPath() . "includes/config.php"; // check username is in database $tmp = mysql_query("\n\t\t\tSELECT id, userid, avatar, kick, ban, blocked, room, guest, userGroup \n\t\t\tFROM prochatrooms_users \n\t\t\tWHERE username = '******'username']) . "' \n\t\t\tLIMIT 1\n\t\t\t") or die(mysql_error()); while ($i = mysql_fetch_array($tmp)) { $id = $i['id']; $avatar = $i['avatar']; $kick = $i['kick']; $ban = $i['ban']; $blockedList = $i['blocked']; $guest = $i['guest']; $_SESSION['userGroup'] = $i['userGroup']; $_SESSION['myProfileID'] = $id; $_SESSION['myStreamID'] = streamID(); } if (!$id) { $loginError = C_LANG17; } if ($kick > date("U")) { $loginError = C_LANG18 . ' ' . $CONFIG['kickTime'] . ' ' . C_LANG19; } if ($ban) { $loginError = C_LANG20; } if ($CONFIG['banIP'] && getIPBanList(getIP())) { $loginError = C_LANG20; } if (!$loginError) { // update user in database updateUser(); // update room details $sql = "UPDATE prochatrooms_rooms \n\t\t\t\tSET roomusers = roomusers + 1\n\t\t\t\tWHERE id = '" . makeSafe($roomID) . "'"; mysql_query($sql) or die(mysql_error()); // update room details $sql = "UPDATE prochatrooms_rooms \n\t\t\t\tSET roomusers = roomusers - 1 \n\t\t\t\tWHERE id = '" . makeSafe($prevRoom) . "'\n\t\t\t\tAND roomusers > '0'"; mysql_query($sql) or die(mysql_error()); // update watching, webcam, avatar, lastactive $sql = "UPDATE prochatrooms_users \n\t\t\t\tSET watching = '', webcam = '0', lastActive = '" . getTime() . "' \n\t\t\t\tWHERE username = '******'username']) . "'"; mysql_query($sql) or die(mysql_error()); } // return details return array($id, $avatar, $loginError, $blockedList, $guest); }
<?php include "../../includes/ini.php"; include "../../includes/session.php"; include "../../includes/db.php"; include "../../includes/functions.php"; if (!validStreamID($_SESSION['myStreamID'])) { die("invalid streamID"); } // update streamID $_SESSION['myStreamID'] = streamID(); // update user updateUser(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <!-- saved from url=(0014)about:internet --> <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en"> <head> <title></title> <style type="text/css" media="screen"> html, body { height:100%; } body { margin:0; padding:0; overflow:auto; text-align:center; background-color: #ffffff; } object:focus { outline:none; } #flashContent { display:none; } </style> <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/swfobject/2.2/swfobject.js"></script> <!--script type="text/javascript" src="js/swfobject.js"></script-->