# #-----[ SQL ЗАПРОС ]------------------------------------------ # CREATE TABLE IF NOT EXISTS `bb_shout` ( `shout_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `shout_user_id` mediumint(8) NOT NULL DEFAULT '0', `shout_session_time` int(11) NOT NULL DEFAULT '0', `shout_text` varchar(1000) CHARACTER SET utf8 NOT NULL, KEY `shout_id` (`shout_id`) ); # #-----[ ОТКРЫТЬ ]------------------------------------------ # index.php # #-----[ НАЙТИ ]------------------------------------------ # $page_cfg['load_tpl_vars'] = array( 'post_icons', ); # #-----[ ПОСЛЕ ДОБАВИТЬ ]------------------------------------------ # $page_cfg['include_bbcode_js'] = true; # #-----[ ОТКРЫТЬ ]------------------------------------------ # ajax.php # #-----[ НАЙТИ ]------------------------------------------ # require(INC_DIR . 'functions_group.php'); break; # #-----[ ПОСЛЕ ДОБАВИТЬ ]------------------------------------------ # case 'chat_message': require(INC_DIR .'functions_post.php'); require(INC_DIR .'bbcode.php'); break; # #-----[ НАЙТИ ]------------------------------------------ # 'manage_group' => array('user'), # #-----[ ПОСЛЕ ДОБАВИТЬ ]------------------------------------------ # 'chat_message' => array('user'), # #-----[ НАЙТИ ]------------------------------------------ # function index_data() { require(AJAX_DIR .'index_data.php'); } # #-----[ ПОСЛЕ ДОБАВИТЬ ]------------------------------------------ # function chat_message() { global $userdata, $bb_cfg, $lang; $mode = (int) $this->request['mode']; $message = (string) $this->request['message']; $message = htmlspecialchars(addslashes($message)); if($mode==1) { if(!$message) $this->ajax_die($lang['SHOUTBOX_ERR']); if (!empty($message)) { DB()->query('INSERT INTO bb_shout (shout_text, shout_session_time, shout_user_id) VALUES ("'.DB()->escape($message).'", '.TIMENOW.', '.$userdata['user_id'].')'); CACHE('bb_cache')->rm('shout_data', 60); } } if(!$shout_data = CACHE('bb_cache')->get('shout_data', 60)) { $shout_rows = DB()->fetch_rowset("SELECT s.*, u.username, u.avatar_ext_id, u.user_opt, u.user_id FROM bb_shout s, ".BB_USERS." u WHERE s.shout_user_id=u.user_id AND u.user_id = u.user_id ORDER BY s.shout_session_time DESC LIMIT 50"); $shout_data = ''; foreach ($shout_rows AS $shout_row) { $username = ''.$shout_row['username'].''; $avatar = get_avatar($shout_row['user_id'], $shout_row['avatar_ext_id'], !bf($shout_row['user_opt'], 'user_opt', 'dis_avatar'), 16, 16); $shout = $shout_row['shout_text']; $tm = bb_date($shout_row['shout_session_time'],'H:i', false); $shout_data .= '