query(static::INIT_SYS_ADMINER_SQL); foreach ($status as $uid) { $memToSysAdminer[$uid['id']] = $uid['id']; } self::setSysAdminer($memToSysAdminer); //初始化房间所有者 $status = Db::instance('dbDefault')->query(static::INIT_ROOM_OWNMER_SQL); foreach ($status as $value) { if(!isset($memToRoomStatus[$value['num']])) { $memToRoomStatus[$value['num']] = array(); } $memToRoomStatus[$value['num']]['owner'] = $value['uid']; $memToRoomStatus[$value['num']]['adminer'] = array(); $memToRoomStatus[$value['num']]['disableMsg'] = array(); $memToRoomStatus[$value['num']]['kicked'] = array(); $memToRoomStatus[$value['num']]['maxonline'] = $value['maxonline']; } //初始化管理员 $status = array(); $status = Db::instance('dbDefault')->query(static::INIT_ROOM_ADMINER_SQL); foreach ($status as $value) { if (!isset($memToRoomStatus[$value['num']])) { continue; } $memToRoomStatus[$value['num']]['adminer'][$value['adminuid']] = $value['adminuid']; } Db::close('dbDefault'); foreach ($memToRoomStatus as $room_id => $roomStatus) { self::setRoomStatus($room_id, $roomStatus); } } // 获取房间在在线人数 public static function getClientNum($room_id) { return Mem::get(static::ROOM_ONLINE_NUM_PREFIX.$room_id); } // 获取房间在线列表 public static function getSortedClient($room_id) { return json_decode(Mem::get(static::ROOM_SORTED_CLIENTS_PREFIX.$room_id), true); } public static function updateAnchorOfflineToDb($user_id) { return ; // Db::instance('dbDefault')->update('ss_member')->set('broadcasting','n')->where(array('id'=>$user_id))->execute(); Db::instance('dbDefault')->query("update ss_member set broadcasting='n' where id={$user_id}"); } public static function updateAnchorOnLineToDb($user_id) { Db::instance('dbDefault')->query("update ss_member set broadcasting='y' where id={$user_id}"); } public static function getOnlineRoom() { return Db::instance('dbDefault')->query(static::GET_ONLINE_ANCHOR_LIST); } /** * 更新在线人数 * * @param int $num */ public static function updateOnlineNumToDb($room_id, $num = 0) { return Db::instance('dbDefault')->query("update ss_member set onlinenum={$num} where curroomnum={$room_id}"); } }