maybe you guys can help
Posted: Thu Aug 09, 2007 2:01 pmIf I can get functions_topics_list.php to work, then I can add in whatever I did to this to the rest of the site. Give me a hand please??
[code] <?php /*************************************************************************** * functions_topics_list.php * ------------------------- * begin : 02/08/2003 * copyright : Ptirhiik * email : <a>admin@rpgnet-fr.com</a> * version : 1.1.9 - 04/11/2003 * ***************************************************************************/ /*************************************************************************** * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * ***************************************************************************/ if ( !defined('IN_PHPBB') ){ die("Hacking attempt");} // activate this line if you want to alternate the color of each row// define('TOPIC_ALTERNATE_ROW_CLASS', true); // different view for the topics the user replied toodefine('USER_REPLIED_ICON', true); // activate this line if you are using different folder icons for the topic the user replied too// define('USER_REPLIED_CLASS', 'quote'); // activate this line and set the class you prefer for the the topic the user replied too // various includesinclude_once($phpbb_root_path . './includes/functions_post.' . $phpEx);include_once($phpbb_root_path . './includes/bbcode.' . $phpEx);@include_once($phpbb_root_path . 'includes/functions_calendar.' . $phpEx);@include_once($phpbb_root_path . 'includes/functions_announces.' . $phpEx); //--------------------------------------------------// topic_list() : display a list of topic// ------------// $box : name of the tpl var for the box// $tpl : name of the template file used (blank: topics_list_box.tpl) : do not set .tpl at the end// $topic_rowset : list of the topics : note that topic_id is filled with the item type + id (ie t256)// $list_title : title of the box (blank: $lang['Topics'])// $split_type : if false, the topics won't be split whatever is the split topic per type setup// $display_nav_tree : if true, display the forum name where stands the topic// $footer : what to display at the bottom of the last box (sort by, order, etc.)// $inbox : if false, the topics won't be splitted in different boxes per type// $select_field : name of the select field// $select_type : 0: no select field, 1: checkbox field (multiple selection), 2: radio field (unique selection)// $select_formname : name of the form where the select field will appear// $select_values : selected values (array)// ---------------------------------// standard sql request in order to fill the topic_rowset array :// ---------------------------------// $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time// FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2// WHERE t.topic_poster = u.user_id// AND p.post_id = t.topic_first_post_id// AND p2.post_id = t.topic_last_post_id// AND u2.user_id = p2.poster_id// ORDER BY t.topic_type DESC, t.topic_last_post_id DESC// LIMIT $start, ".$board_config['topics_per_page'];// ---------------------------------// NB:// ---------------------------------// topic_id should have in first position the main data row type, meaning for topics :// $topic_rowset[]['topic_id'] = POST_TOPIC_URL . $row['topic_id'];//--------------------------------------------------function topic_list($box, $tpl='', $topic_rowset, $list_title='', $split_type=false, $display_nav_tree=true, $footer='', $inbox=true, $select_field='', $select_type=0, $select_formname='', $select_values=array(), $topic_rank_set=array()){ global $db, $template, $board_config, $theme, $userdata, $phpEx, $lang, $auth, $images, $HTTP_COOKIE_VARS; global $tree; static $box_id; $style_color = ''; if ( ($row['user_level'] == ADMIN) && ($row['user_id'] == 3) ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'foundercolor'; } if ( ($row['user_level'] == ADMIN) && ($row['user_id'] == 2) ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'cutecolor'; } if ( ($row['user_level'] == ADMIN) && ($row['user_id'] == 60) ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'larrycolor'; } if ($row['user_level'] == SA) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'sacolor'; } if ($row['user_level'] == WK) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'wkcolor'; } if ($row['user_level'] == FR) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'frcolor'; } else if ($row['user_level'] == ADMIN) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'admincolor'; } else if ($row['user_level'] == MOD) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'modcolor'; } else { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'usercolor'; } $current_time = time(); // MOD: Delayed Topics // save template state $sav_tpl = $template->_tpldata; // init if (empty($tpl)) { $tpl = 'topics_list_box'; } if (empty($list_title)) { $list_title = $lang['Topics']; } if (!empty($select_values) && !is_array($select_values) ) { $s_values = $select_values; $select_values = array(); $select_values[] = $s_values; } // selections $select_multi = false; $select_unique = false; if (!empty($select_field) && ($select_type > 0) && !empty($select_formname) ) { switch ($select_type) { case 1: $select_multi = true; break; case 2: $select_unique = true; break; } } // get split params $switch_split_global_announce = (isset($board_config['split_global_announce']) && isset($lang['Post_Global_Announcement'])) ? intval($board_config['split_global_announce']) : false; $switch_split_announce = isset($board_config['split_announce']) ? intval($board_config['split_announce']) : false; $switch_split_sticky = isset($board_config['split_sticky']) ? intval($board_config['split_sticky']) : false; // set in separate table $split_box = $inbox && (isset($board_config['split_topic_split']) ? intval($board_config['split_topic_split']) : false); // take care of the context if (!$split_type) { $split_box = false; $switch_split_global_announce = false; $switch_split_announce = false; $switch_split_sticky = false; } if (!$switch_split_global_announce && !$switch_split_announce && !$switch_split_sticky) { $split_type = false; $split_box = false; } // Define censored word matches $orig_word = array(); $replacement_word = array(); obtain_word_list($orig_word, $replacement_word); //-- mod : keep unread -----------------------------------------------------------------------------//-- delete// // read the user cookie// $tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . "_t"]) : array();// $tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . "_f"]) : array();// $tracking_all = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) ) ? intval($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) : NULL;//-- add // get last visit for guest if ( !$userdata['session_logged_in'] ) { $userdata['user_lastvisit'] = $board_config['guest_lastvisit']; }//-- fin mod : keep unread ------------------------------------------------------------------------- // categories hierarchy v 2 compliancy $cat_hierarchy = function_exists(get_auth_keys); if (!$cat_hierarchy) { // standard read $is_auth = array(); $is_auth = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata); } // topic icon present $icon_installed = function_exists(get_icon_title); // get a default title if (empty($list_title)) { $list_title = $lang['forum']; } // choose template $template->set_filenames(array( $tpl => $tpl . '.tpl') ); // check if user replied to the topics $user_topics = array(); if ($userdata['user_id'] != ANONYMOUS) { // get all the topic ids to display $topic_ids = array(); for ($i = 0; $i <count>sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain post information', '', __LINE__, __FILE__, $sql); } while ($row = $db->sql_fetchrow($result)) { $user_topics[POST_TOPIC_URL . $row['topic_id']] = true; } } } // initiate $template->assign_block_vars($tpl, array( 'FORMNAME' => $select_formname, 'FIELDNAME' => $select_field, ) ); // spanning of the first column (list name) $span_left = 1; if ( count($topic_rowset) > 0 ) { // add folder image $span_left++; } if ( $icon_installed ) { // add topic icon $span_left++; } if ( $select_unique ) { // selection in front is asked $span_left++; } // spanning of the whole line (bottom row and/or empty list) $span_all = $span_left + 4; if ( $select_multi && (count($topic_rowset) >0) ) { $span_all++; } // display topics $color = false; $prec_topic_type = ''; $header_sent = false; if (!isset($box_id)) $box_id = -1; for ($i=0; $i <count>= $board_config['hot_threshold']) { $folder = ($user_replied && defined('USER_REPLIED_ICON')) ? $images['folder_hot_own'] : $images['folder_hot']; $folder_new = ($user_replied && defined('USER_REPLIED_ICON')) ? $images['folder_hot_new_own'] : $images['folder_hot_new']; } else { $folder = ($user_replied && defined('USER_REPLIED_ICON')) ? $images['folder_own'] : $images['folder']; $folder_new = ($user_replied && defined('USER_REPLIED_ICON')) ? $images['folder_new_own'] : $images['folder_new']; } } $newest_post_img = '';//-- mod : keep unread -----------------------------------------------------------------------------//-- delete// if ( $userdata['session_logged_in'] && ($topic_item_type == POST_TOPIC_URL) )// {// if( $topic_rowset[$i]['post_time'] > $userdata['user_lastvisit'] )// {// if( !empty($tracking_topics) || !empty($tracking_forums) || !empty($tracking_all) )// {// $unread_topics = true;// if( !empty($tracking_topics[$topic_id]) )// {// if( $tracking_topics[$topic_id] >= $topic_rowset[$i]['post_time'] )// {// $unread_topics = false;// }// }// if( !empty($tracking_forums[$forum_id]) )// {// if( $tracking_forums[$forum_id] >= $topic_rowset[$i]['post_time'] )// {// $unread_topics = false;// }// }// if( !empty($tracking_all) )// {// if( $tracking_all >= $topic_rowset[$i]['post_time'] )// {// $unread_topics = false;// }// }//-- add if ( $topic_item_type == POST_TOPIC_URL ) { // have we got a last visit time for this topic $topic_last_read = intval($board_config['tracking_unreads'][$topic_id]); if ( !empty($board_config['tracking_all']) && ($board_config['tracking_all'] > $topic_last_read) ) { $topic_last_read = $board_config['tracking_all']; } if ( isset($board_config['tracking_forums'][$forum_id]) && ($board_config['tracking_forums'][$forum_id] > $topic_last_read) ) { $topic_last_read = $board_config['tracking_forums'][$forum_id]; } if ( isset($board_config['tracking_topics'][$topic_id]) && ($board_config['tracking_topics'][$topic_id] > $topic_last_read) ) { $topic_last_read = $board_config['tracking_topics'][$topic_id]; } if ( empty($topic_last_read) ) { $topic_last_read = $userdata['user_lastvisit']; } // unread status ? $unread_topics = ( $topic_rowset[$i]['post_time'] > $topic_last_read );//-- fin mod : keep unread ------------------------------------------------------------------------- if ( $unread_topics ) { $folder_image = $folder_new; $folder_alt = $lang['New_posts']; $newest_post_img = '<a><img></a> '; } else { $folder_image = $folder; $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; }//-- mod : keep unread -----------------------------------------------------------------------------//-- delete// }// else// {// $folder_image = $folder_new;// $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['New_posts'];// $newest_post_img = '<a><img></a> ';// }// }// else// {// $folder_image = $folder;// $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];// $newest_post_img = '';// }// }// else// {// $folder_image = $folder;// $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];// $newest_post_img = '';//-- fin mod : keep unread ------------------------------------------------------------------------- } } // generate list of page for the topic $goto_page = ''; if( ( $replies + 1 ) > $board_config['posts_per_page'] ) { $total_pages = ceil( ( $replies + 1 ) / $board_config['posts_per_page'] ); $goto_page = ' [ <img>' . $lang['Goto_page'] . ': '; $times = 1; for($j = 0; $j </a> 4 ) { $goto_page .= ' ... '; $times = $total_pages - 3; $j += ( $total_pages - 4 ) * $board_config['posts_per_page']; } else if ( $times </span> 0 ) ? '[ ' . $lang['News'] . ' ] ' : ''; break; } // categories hierarchy v 2 compliancy $nav_tree = ''; if ( $display_nav_tree && !empty($topic_rowset[$i]['forum_id']) ) { if ($cat_hierarchy) { if ($tree['auth'][POST_FORUM_URL . $topic_rowset[$i]['forum_id']]['tree.auth_view']) { $nav_tree = make_cat_nav_tree(POST_FORUM_URL . $topic_rowset[$i]['forum_id'], '', 'gensmall'); } } else { if ($is_auth[ $topic_rowset[$i]['forum_id'] ]['auth_view']) { $nav_tree = '<a>' . $topic_rowset[$i]['forum_name'] . '</a>'; } } } if (!empty($nav_tree)) { $nav_tree = '[ ' . $nav_tree . ' ]'; } // get the type for rupture $topic_real_type = $topic_rowset[$i]['topic_type']; // if no split between global and standard announcement, group them with standard announcement if ( !$switch_split_global_announce && ($topic_real_type == POST_GLOBAL_ANNOUNCE) ) $topic_real_type = POST_ANNOUNCE; // if no split between announce and sticky, group them with sticky if ( !$switch_split_announce && ($topic_real_type == POST_ANNOUNCE) ) $topic_real_type = POST_STICKY; // if no split between sticky and normal, group them with normal if ( !$switch_split_sticky && ($topic_real_type == POST_STICKY) ) $topic_real_type = POST_NORMAL; // check if rupture $rupt = false; // split if ( ($i == 0) || $split_type ) { if ($i == 0) { $rupt = true; } // check the rupt if ($prec_topic_type != $topic_real_type) { $rupt = true; } } $prec_topic_type = $topic_real_type; // get topic de.scription $topic_desc = ''; if (!empty($topic_rowset[$i]['topic_desc'])) { $topic_desc = '<br>'. smilies_pass($topic_rowset[$i]['topic_desc']); } // header if ($rupt) { // close the prec box if ($split_box && ($i != 0)) { // footer $template->assign_block_vars($tpl . '.row', array( 'COLSPAN' => $span_all, ) ); // table closure $template->assign_block_vars($tpl . '.row.footer_table', array()); // spacing $template->assign_block_vars($tpl . '.row', array()); $template->assign_block_vars($tpl . '.row.spacer', array()); // unset header $header_sent = false; } // get box title $main_title = $list_title; $sub_title = $list_title; switch ($topic_real_type) { case POST_BIRTHDAY: $sub_title = $lang['Birthday']; break; case POST_GLOBAL_ANNOUNCE: $sub_title = $lang['Post_Global_Announcement']; break; case POST_ANNOUNCE: $sub_title = $lang['Post_Announcement']; break; case POST_STICKY: $sub_title = $lang['Post_Sticky']; break; case POST_CALENDAR: $sub_title = $lang['Calendar_event']; break; case POST_NORMAL: $sub_title = $lang['Topics']; break; } $template->assign_block_vars($tpl . '.row', array( 'L_TITLE' => (!$split_box) ? $main_title : $sub_title, 'L_REPLIES' => $lang['Replies'], 'L_AUTHOR' => $lang['Author'], 'L_VIEWS' => $lang['Views'], 'L_LASTPOST' => $lang['Last_Post'], 'COLSPAN' => $span_all, ) ); // open a new box if ($split_box || ($i == 0)) { $box_id++; $template->assign_block_vars($tpl . '.row.header_table', array( 'COLSPAN' => $span_left, 'BOX_ID' => $box_id, ) ); // selection fields if ($select_multi) { $template->assign_block_vars($tpl . '.row.header_table.multi_selection', array()); } // set header $header_sent = true; } // not in box, send a row title if ($split_type && !$split_box) { $template->assign_block_vars($tpl . '.row', array( 'L_TITLE' => $sub_title, 'COLSPAN' => $span_all, ) ); $template->assign_block_vars($tpl . '.row.header_row', array()); } } // erase the type before the title if split if ( $split_type && ($topic_real_type == $topic_rowset[$i]['topic_type']) && !$force_type_display) { $topic_type = ''; } // get the announces dates $topic_announces_dates = ''; if (function_exists(get_announces_title) && in_array( $topic_rowset[$i]['topic_type'], array(POST_ANNOUNCE, POST_GLOBAL_ANNOUNCE))) { $topic_announces_dates = get_announces_title($topic_rowset[$i]['topic_time'], $topic_rowset[$i]['topic_announce_duration']); } // get the calendar dates $topic_calendar_dates = ''; if (function_exists(get_calendar_title)) { $topic_calendar_dates = get_calendar_title($topic_rowset[$i]['topic_calendar_time'], $topic_rowset[$i]['topic_calendar_duration']); } // get the topic icons $icon = ''; if ($icon_installed) { $type = $topic_rowset[$i]['topic_type']; if ($type == POST_NORMAL) { if ( defined('POST_CALENDAR') && !empty($topic_rowset[$i]['topic_calendar_time']) ) { $type = POST_CALENDAR; } if ( defined('POST_PICTURE') && !empty($topic_rowset[$i]['topic_pic_url']) ) { $type = POST_PICTURE; } } $icon = get_icon_title($topic_rowset[$i]['topic_icon'], 1, $type); }//// Begin Approve_Mod Block : 8// $approve_mod = array(); $approve_sql = "SELECT * FROM " . APPROVE_FORUMS_TABLE . " WHERE forum_id = " . intval($forum_id); if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } if ( $approve_row = $db->sql_fetchrow($approve_result) ) { if ( intval($approve_row['enabled']) == 1 ) { $approve_mod = $approve_row; $approve_mod['enabled'] = true; } }$approve_mod['moderators'] = explode('|', get_moderators_user_id_of_forum($forum_id));//// End Approve_Mod Block : 8// //// Begin Approve_Mod Block : 9// if ( $approve_mod['enabled'] ) { $approve_mod['topics_awaiting'] = false; $approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . " WHERE topic_id = " . intval($topic_id) . " AND is_topic = 1 LIMIT 0,1"; if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } if ( $approve_row = $db->sql_fetchrow($approve_result) ) { if ( intval($approve_row['is_topic']) == 1 ) { $approve_mod['topics_awaiting'] = true; } } if ( in_array($userdata['user_id'], $approve_mod['moderators']) || $is_auth['auth_mod'] ) { if ( $approve_mod['topics_awaiting'] ) { $topic_title .= "</a><br><a>[ " . $lang['approve_topic_is_awaiting'] . " ]"; } else { $approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . " WHERE topic_id = " . intval($topic_id) . " AND is_post = 1 ORDER BY post_id LIMIT 0,2"; if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } if ( $approve_row = $db->sql_fetchrow($approve_result) ) { if ( $db->sql_numrows($approve_result) >= 1 ) { $topic_title .= "</a><br><a>[ " . $lang['approve_topic_has_awaiting'] . " ]"; } } } } else { if ( $approve_mod['topics_awaiting'] ) { if ( $approve_mod['forum_hide_unapproved_topics'] ) { continue; } $topic_title = "</a><span>[ " . $lang['approve_topic_is_awaiting'] . " ]</span>"; $view_topic_url = append_sid("viewforum.php?f=" . $forum_id ); $last_post_url = $last_post_url = '<img>'; $goto_page = ''; $last_post_author = ( intval($topic_rowset[$i]['id2']) == intval(ANONYMOUS) ) ? $lang['Guest'] : $last_post_author; $topic_author = ( intval($topic_rowset[$i]['user_id']) == intval(ANONYMOUS) ) ? $lang['Guest'] : $topic_author; } else { $approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . " WHERE post_id = " . intval($topic_rowset[$i]['topic_last_post_id']) . " AND is_post = 1 LIMIT 0,1"; if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } $approve_row = $db->sql_fetchrow($approve_result); if ( intval($approve_row['post_id']) == intval($topic_rowset[$i]['topic_last_post_id']) ) { if ( $approve_mod['forum_hide_unapproved_posts'] ) { $approve_sql = "SELECT p.post_id, p.poster_id, p.post_time, p.post_username, u.username FROM " . POSTS_TABLE . " p, " . APPROVE_POSTS_TABLE . " a, " . USERS_TABLE . " u WHERE a.post_id = " . intval($topic_rowset[$i]['topic_last_post_id']) . " AND p.topic_id = a.topic_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC"; if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } while( $approve_row = $db->sql_fetchrow($approve_result) ) { $approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . " WHERE post_id = " . intval($approve_row['post_id']) . " LIMIT 0,1"; if ( !($approve_result2 = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } $approve_row2 = $db->sql_fetchrow($approve_result2); if ( !$approve_row2['post_id'] ) { $last_post_time = create_date($board_config['default_dateformat'], $approve_row['post_time'], $board_config['board_timezone']); $last_post_author = ( $approve_row['poster_id'] == ANONYMOUS ) ? ( ($approve_row['post_username'] != '' ) ? $approve_row['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a>' . $approve_row['username'] . '</a>'; $last_post_url = '<a><img></a>'; break; } } } else { $last_post_author = ( intval($topic_rowset[$i]['id2']) == intval(ANONYMOUS) ) ? $lang['Guest'] : $last_post_author; } } } } }//// End Approve_Mod Block : 9// //----------------------------------------------------------------------------- // MOD: Delayed Topics if ($topic_rowset[$i]['topic_time'] > $current_time) { $delay_text = sprintf($lang['Delayed_Post_Alt'], create_date($board_config['default_dateformat'], $topic_rowset[$i]['topic_time'],$board_config['board_timezone'])); $miniclock = '<img>'; } else $miniclock = ''; // MOD: Delayed Topics {end} //----------------------------------------------------------------------------- // send topic to template $selected = (!empty($select_values) && in_array($topic_rowset[$i]['topic_id'], $select_values)); $color = !$color; $topic_rating = ( count($topic_rank_set) > 0 && $topic_rowset[$i]['rating_rank_id'] > 0 ) ? $topic_rank_set[$topic_rowset[$i]['rating_rank_id']] : ''; $template->assign_block_vars( $tpl . '.row', array( 'RATING' => $topic_rating, 'ROW_CLASS' => ($color || !defined('TOPIC_ALTERNATE_ROW_CLASS')) ? 'row1' : 'row2', 'TOPIC_INFO' => ( $topic_rowset[$i]['topic_info'] ) ? '[ ' . $topic_rowset[$i]['topic_info'] . ' ] ' : '', 'ROW_FOLDER_CLASS' => ($user_replied && defined('USER_REPLIED_CLASS')) ? USER_REPLIED_CLASS : ( ($color || !defined('TOPIC_ALTERNATE_ROW_CLASS')) ? 'row1' : 'row2' ), 'FORUM_ID' => $forum_id, 'TOPIC_ID' => $topic_id, 'TOPIC_FOLDER_IMG' => $folder_image, 'TOPIC_AUTHOR' => $topic_author, 'GOTO_PAGE' => !empty($goto_page) ? '<br>' . $goto_page : '', 'TOPIC_NAV_TREE' => !empty($nav_tree) ? (empty($goto_page) ? '<br>' : '') . $nav_tree : '', 'REPLIES' => $replies, 'NEWEST_POST_IMG' => $newest_post_img, 'ICON' => $icon, 'TOPIC_ATTACHMENT_IMG' => topic_attachment_image($topic_rowset[$i]['topic_attachment']), 'TOPIC_TITLE' => $topic_title, 'TOPIC_ANNOUNCES_DATES' => $topic_announces_dates, 'TOPIC_CALENDAR_DATES' => $topic_calendar_dates, 'TOPIC_TYPE' => $topic_type, 'VIEWS' => $views, 'FIRST_POST_TIME' => $first_post_time, 'LAST_POST_TIME' => $last_post_time, 'LAST_POST_AUTHOR' => $last_post_author, 'LAST_POST_IMG' => $last_post_url, 'MINICLOCK' => $miniclock,// BEGIN cmx_mod 'L_NEWS' => $news_label,// END cmx_mod 'TOPIC_DESCRIPTION' => $topic_desc, 'L_TOPIC_FOLDER_ALT' => $folder_alt, 'U_POSTINGS_POPUP' => append_sid("postings_popup.$phpEx?t=$topic_id"), 'U_VIEW_TOPIC' => $view_topic_url, 'BOX_ID' => $box_id, 'FID' => $topic_rowset[$i]['topic_id'], 'L_SELECT' => ($selected && ($select_multi || $select_unique)) ? 'checked="checked"' : '', ) ); if ( !empty($topic_rowset[$i]['topic_desc'])) { $topic_desc = $topic_rowset[$i]['topic_desc']; $template->assign_block_vars($tpl . '.row.switch_topic_desc', array( ) ); } $template->assign_block_vars( $tpl . '.row.topic', array()); // selection fields if ($select_multi) { $template->assign_block_vars($tpl . '.row.topic.multi_selection', array()); } if ($select_unique) { $template->assign_block_vars($tpl . '.row.topic.single_selection', array()); } // icons if ($icon_installed) { $template->assign_block_vars( $tpl . '.row.topic.icon', array()); } // nav tree asked if ($display_nav_tree && !empty($nav_tree)) { $template->assign_block_vars( $tpl . '.row.topic.nav_tree', array()); } } // end for topic_rowset read // send an header if missing if (!$header_sent) { $template->assign_block_vars($tpl . '.row', array( 'L_TITLE'
[code] <?php /*************************************************************************** * functions_topics_list.php * ------------------------- * begin : 02/08/2003 * copyright : Ptirhiik * email : <a>admin@rpgnet-fr.com</a> * version : 1.1.9 - 04/11/2003 * ***************************************************************************/ /*************************************************************************** * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * ***************************************************************************/ if ( !defined('IN_PHPBB') ){ die("Hacking attempt");} // activate this line if you want to alternate the color of each row// define('TOPIC_ALTERNATE_ROW_CLASS', true); // different view for the topics the user replied toodefine('USER_REPLIED_ICON', true); // activate this line if you are using different folder icons for the topic the user replied too// define('USER_REPLIED_CLASS', 'quote'); // activate this line and set the class you prefer for the the topic the user replied too // various includesinclude_once($phpbb_root_path . './includes/functions_post.' . $phpEx);include_once($phpbb_root_path . './includes/bbcode.' . $phpEx);@include_once($phpbb_root_path . 'includes/functions_calendar.' . $phpEx);@include_once($phpbb_root_path . 'includes/functions_announces.' . $phpEx); //--------------------------------------------------// topic_list() : display a list of topic// ------------// $box : name of the tpl var for the box// $tpl : name of the template file used (blank: topics_list_box.tpl) : do not set .tpl at the end// $topic_rowset : list of the topics : note that topic_id is filled with the item type + id (ie t256)// $list_title : title of the box (blank: $lang['Topics'])// $split_type : if false, the topics won't be split whatever is the split topic per type setup// $display_nav_tree : if true, display the forum name where stands the topic// $footer : what to display at the bottom of the last box (sort by, order, etc.)// $inbox : if false, the topics won't be splitted in different boxes per type// $select_field : name of the select field// $select_type : 0: no select field, 1: checkbox field (multiple selection), 2: radio field (unique selection)// $select_formname : name of the form where the select field will appear// $select_values : selected values (array)// ---------------------------------// standard sql request in order to fill the topic_rowset array :// ---------------------------------// $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time// FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2// WHERE t.topic_poster = u.user_id// AND p.post_id = t.topic_first_post_id// AND p2.post_id = t.topic_last_post_id// AND u2.user_id = p2.poster_id// ORDER BY t.topic_type DESC, t.topic_last_post_id DESC// LIMIT $start, ".$board_config['topics_per_page'];// ---------------------------------// NB:// ---------------------------------// topic_id should have in first position the main data row type, meaning for topics :// $topic_rowset[]['topic_id'] = POST_TOPIC_URL . $row['topic_id'];//--------------------------------------------------function topic_list($box, $tpl='', $topic_rowset, $list_title='', $split_type=false, $display_nav_tree=true, $footer='', $inbox=true, $select_field='', $select_type=0, $select_formname='', $select_values=array(), $topic_rank_set=array()){ global $db, $template, $board_config, $theme, $userdata, $phpEx, $lang, $auth, $images, $HTTP_COOKIE_VARS; global $tree; static $box_id; $style_color = ''; if ( ($row['user_level'] == ADMIN) && ($row['user_id'] == 3) ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'foundercolor'; } if ( ($row['user_level'] == ADMIN) && ($row['user_id'] == 2) ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'cutecolor'; } if ( ($row['user_level'] == ADMIN) && ($row['user_id'] == 60) ) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'larrycolor'; } if ($row['user_level'] == SA) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'sacolor'; } if ($row['user_level'] == WK) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'wkcolor'; } if ($row['user_level'] == FR) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'frcolor'; } else if ($row['user_level'] == ADMIN) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'admincolor'; } else if ($row['user_level'] == MOD) { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'modcolor'; } else { $row['username'] = '<b>' . $row['username'] . '</b>'; $style_color = 'usercolor'; } $current_time = time(); // MOD: Delayed Topics // save template state $sav_tpl = $template->_tpldata; // init if (empty($tpl)) { $tpl = 'topics_list_box'; } if (empty($list_title)) { $list_title = $lang['Topics']; } if (!empty($select_values) && !is_array($select_values) ) { $s_values = $select_values; $select_values = array(); $select_values[] = $s_values; } // selections $select_multi = false; $select_unique = false; if (!empty($select_field) && ($select_type > 0) && !empty($select_formname) ) { switch ($select_type) { case 1: $select_multi = true; break; case 2: $select_unique = true; break; } } // get split params $switch_split_global_announce = (isset($board_config['split_global_announce']) && isset($lang['Post_Global_Announcement'])) ? intval($board_config['split_global_announce']) : false; $switch_split_announce = isset($board_config['split_announce']) ? intval($board_config['split_announce']) : false; $switch_split_sticky = isset($board_config['split_sticky']) ? intval($board_config['split_sticky']) : false; // set in separate table $split_box = $inbox && (isset($board_config['split_topic_split']) ? intval($board_config['split_topic_split']) : false); // take care of the context if (!$split_type) { $split_box = false; $switch_split_global_announce = false; $switch_split_announce = false; $switch_split_sticky = false; } if (!$switch_split_global_announce && !$switch_split_announce && !$switch_split_sticky) { $split_type = false; $split_box = false; } // Define censored word matches $orig_word = array(); $replacement_word = array(); obtain_word_list($orig_word, $replacement_word); //-- mod : keep unread -----------------------------------------------------------------------------//-- delete// // read the user cookie// $tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . "_t"]) : array();// $tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . "_f"]) : array();// $tracking_all = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) ) ? intval($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) : NULL;//-- add // get last visit for guest if ( !$userdata['session_logged_in'] ) { $userdata['user_lastvisit'] = $board_config['guest_lastvisit']; }//-- fin mod : keep unread ------------------------------------------------------------------------- // categories hierarchy v 2 compliancy $cat_hierarchy = function_exists(get_auth_keys); if (!$cat_hierarchy) { // standard read $is_auth = array(); $is_auth = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata); } // topic icon present $icon_installed = function_exists(get_icon_title); // get a default title if (empty($list_title)) { $list_title = $lang['forum']; } // choose template $template->set_filenames(array( $tpl => $tpl . '.tpl') ); // check if user replied to the topics $user_topics = array(); if ($userdata['user_id'] != ANONYMOUS) { // get all the topic ids to display $topic_ids = array(); for ($i = 0; $i <count>sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain post information', '', __LINE__, __FILE__, $sql); } while ($row = $db->sql_fetchrow($result)) { $user_topics[POST_TOPIC_URL . $row['topic_id']] = true; } } } // initiate $template->assign_block_vars($tpl, array( 'FORMNAME' => $select_formname, 'FIELDNAME' => $select_field, ) ); // spanning of the first column (list name) $span_left = 1; if ( count($topic_rowset) > 0 ) { // add folder image $span_left++; } if ( $icon_installed ) { // add topic icon $span_left++; } if ( $select_unique ) { // selection in front is asked $span_left++; } // spanning of the whole line (bottom row and/or empty list) $span_all = $span_left + 4; if ( $select_multi && (count($topic_rowset) >0) ) { $span_all++; } // display topics $color = false; $prec_topic_type = ''; $header_sent = false; if (!isset($box_id)) $box_id = -1; for ($i=0; $i <count>= $board_config['hot_threshold']) { $folder = ($user_replied && defined('USER_REPLIED_ICON')) ? $images['folder_hot_own'] : $images['folder_hot']; $folder_new = ($user_replied && defined('USER_REPLIED_ICON')) ? $images['folder_hot_new_own'] : $images['folder_hot_new']; } else { $folder = ($user_replied && defined('USER_REPLIED_ICON')) ? $images['folder_own'] : $images['folder']; $folder_new = ($user_replied && defined('USER_REPLIED_ICON')) ? $images['folder_new_own'] : $images['folder_new']; } } $newest_post_img = '';//-- mod : keep unread -----------------------------------------------------------------------------//-- delete// if ( $userdata['session_logged_in'] && ($topic_item_type == POST_TOPIC_URL) )// {// if( $topic_rowset[$i]['post_time'] > $userdata['user_lastvisit'] )// {// if( !empty($tracking_topics) || !empty($tracking_forums) || !empty($tracking_all) )// {// $unread_topics = true;// if( !empty($tracking_topics[$topic_id]) )// {// if( $tracking_topics[$topic_id] >= $topic_rowset[$i]['post_time'] )// {// $unread_topics = false;// }// }// if( !empty($tracking_forums[$forum_id]) )// {// if( $tracking_forums[$forum_id] >= $topic_rowset[$i]['post_time'] )// {// $unread_topics = false;// }// }// if( !empty($tracking_all) )// {// if( $tracking_all >= $topic_rowset[$i]['post_time'] )// {// $unread_topics = false;// }// }//-- add if ( $topic_item_type == POST_TOPIC_URL ) { // have we got a last visit time for this topic $topic_last_read = intval($board_config['tracking_unreads'][$topic_id]); if ( !empty($board_config['tracking_all']) && ($board_config['tracking_all'] > $topic_last_read) ) { $topic_last_read = $board_config['tracking_all']; } if ( isset($board_config['tracking_forums'][$forum_id]) && ($board_config['tracking_forums'][$forum_id] > $topic_last_read) ) { $topic_last_read = $board_config['tracking_forums'][$forum_id]; } if ( isset($board_config['tracking_topics'][$topic_id]) && ($board_config['tracking_topics'][$topic_id] > $topic_last_read) ) { $topic_last_read = $board_config['tracking_topics'][$topic_id]; } if ( empty($topic_last_read) ) { $topic_last_read = $userdata['user_lastvisit']; } // unread status ? $unread_topics = ( $topic_rowset[$i]['post_time'] > $topic_last_read );//-- fin mod : keep unread ------------------------------------------------------------------------- if ( $unread_topics ) { $folder_image = $folder_new; $folder_alt = $lang['New_posts']; $newest_post_img = '<a><img></a> '; } else { $folder_image = $folder; $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; }//-- mod : keep unread -----------------------------------------------------------------------------//-- delete// }// else// {// $folder_image = $folder_new;// $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['New_posts'];// $newest_post_img = '<a><img></a> ';// }// }// else// {// $folder_image = $folder;// $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];// $newest_post_img = '';// }// }// else// {// $folder_image = $folder;// $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];// $newest_post_img = '';//-- fin mod : keep unread ------------------------------------------------------------------------- } } // generate list of page for the topic $goto_page = ''; if( ( $replies + 1 ) > $board_config['posts_per_page'] ) { $total_pages = ceil( ( $replies + 1 ) / $board_config['posts_per_page'] ); $goto_page = ' [ <img>' . $lang['Goto_page'] . ': '; $times = 1; for($j = 0; $j </a> 4 ) { $goto_page .= ' ... '; $times = $total_pages - 3; $j += ( $total_pages - 4 ) * $board_config['posts_per_page']; } else if ( $times </span> 0 ) ? '[ ' . $lang['News'] . ' ] ' : ''; break; } // categories hierarchy v 2 compliancy $nav_tree = ''; if ( $display_nav_tree && !empty($topic_rowset[$i]['forum_id']) ) { if ($cat_hierarchy) { if ($tree['auth'][POST_FORUM_URL . $topic_rowset[$i]['forum_id']]['tree.auth_view']) { $nav_tree = make_cat_nav_tree(POST_FORUM_URL . $topic_rowset[$i]['forum_id'], '', 'gensmall'); } } else { if ($is_auth[ $topic_rowset[$i]['forum_id'] ]['auth_view']) { $nav_tree = '<a>' . $topic_rowset[$i]['forum_name'] . '</a>'; } } } if (!empty($nav_tree)) { $nav_tree = '[ ' . $nav_tree . ' ]'; } // get the type for rupture $topic_real_type = $topic_rowset[$i]['topic_type']; // if no split between global and standard announcement, group them with standard announcement if ( !$switch_split_global_announce && ($topic_real_type == POST_GLOBAL_ANNOUNCE) ) $topic_real_type = POST_ANNOUNCE; // if no split between announce and sticky, group them with sticky if ( !$switch_split_announce && ($topic_real_type == POST_ANNOUNCE) ) $topic_real_type = POST_STICKY; // if no split between sticky and normal, group them with normal if ( !$switch_split_sticky && ($topic_real_type == POST_STICKY) ) $topic_real_type = POST_NORMAL; // check if rupture $rupt = false; // split if ( ($i == 0) || $split_type ) { if ($i == 0) { $rupt = true; } // check the rupt if ($prec_topic_type != $topic_real_type) { $rupt = true; } } $prec_topic_type = $topic_real_type; // get topic de.scription $topic_desc = ''; if (!empty($topic_rowset[$i]['topic_desc'])) { $topic_desc = '<br>'. smilies_pass($topic_rowset[$i]['topic_desc']); } // header if ($rupt) { // close the prec box if ($split_box && ($i != 0)) { // footer $template->assign_block_vars($tpl . '.row', array( 'COLSPAN' => $span_all, ) ); // table closure $template->assign_block_vars($tpl . '.row.footer_table', array()); // spacing $template->assign_block_vars($tpl . '.row', array()); $template->assign_block_vars($tpl . '.row.spacer', array()); // unset header $header_sent = false; } // get box title $main_title = $list_title; $sub_title = $list_title; switch ($topic_real_type) { case POST_BIRTHDAY: $sub_title = $lang['Birthday']; break; case POST_GLOBAL_ANNOUNCE: $sub_title = $lang['Post_Global_Announcement']; break; case POST_ANNOUNCE: $sub_title = $lang['Post_Announcement']; break; case POST_STICKY: $sub_title = $lang['Post_Sticky']; break; case POST_CALENDAR: $sub_title = $lang['Calendar_event']; break; case POST_NORMAL: $sub_title = $lang['Topics']; break; } $template->assign_block_vars($tpl . '.row', array( 'L_TITLE' => (!$split_box) ? $main_title : $sub_title, 'L_REPLIES' => $lang['Replies'], 'L_AUTHOR' => $lang['Author'], 'L_VIEWS' => $lang['Views'], 'L_LASTPOST' => $lang['Last_Post'], 'COLSPAN' => $span_all, ) ); // open a new box if ($split_box || ($i == 0)) { $box_id++; $template->assign_block_vars($tpl . '.row.header_table', array( 'COLSPAN' => $span_left, 'BOX_ID' => $box_id, ) ); // selection fields if ($select_multi) { $template->assign_block_vars($tpl . '.row.header_table.multi_selection', array()); } // set header $header_sent = true; } // not in box, send a row title if ($split_type && !$split_box) { $template->assign_block_vars($tpl . '.row', array( 'L_TITLE' => $sub_title, 'COLSPAN' => $span_all, ) ); $template->assign_block_vars($tpl . '.row.header_row', array()); } } // erase the type before the title if split if ( $split_type && ($topic_real_type == $topic_rowset[$i]['topic_type']) && !$force_type_display) { $topic_type = ''; } // get the announces dates $topic_announces_dates = ''; if (function_exists(get_announces_title) && in_array( $topic_rowset[$i]['topic_type'], array(POST_ANNOUNCE, POST_GLOBAL_ANNOUNCE))) { $topic_announces_dates = get_announces_title($topic_rowset[$i]['topic_time'], $topic_rowset[$i]['topic_announce_duration']); } // get the calendar dates $topic_calendar_dates = ''; if (function_exists(get_calendar_title)) { $topic_calendar_dates = get_calendar_title($topic_rowset[$i]['topic_calendar_time'], $topic_rowset[$i]['topic_calendar_duration']); } // get the topic icons $icon = ''; if ($icon_installed) { $type = $topic_rowset[$i]['topic_type']; if ($type == POST_NORMAL) { if ( defined('POST_CALENDAR') && !empty($topic_rowset[$i]['topic_calendar_time']) ) { $type = POST_CALENDAR; } if ( defined('POST_PICTURE') && !empty($topic_rowset[$i]['topic_pic_url']) ) { $type = POST_PICTURE; } } $icon = get_icon_title($topic_rowset[$i]['topic_icon'], 1, $type); }//// Begin Approve_Mod Block : 8// $approve_mod = array(); $approve_sql = "SELECT * FROM " . APPROVE_FORUMS_TABLE . " WHERE forum_id = " . intval($forum_id); if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } if ( $approve_row = $db->sql_fetchrow($approve_result) ) { if ( intval($approve_row['enabled']) == 1 ) { $approve_mod = $approve_row; $approve_mod['enabled'] = true; } }$approve_mod['moderators'] = explode('|', get_moderators_user_id_of_forum($forum_id));//// End Approve_Mod Block : 8// //// Begin Approve_Mod Block : 9// if ( $approve_mod['enabled'] ) { $approve_mod['topics_awaiting'] = false; $approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . " WHERE topic_id = " . intval($topic_id) . " AND is_topic = 1 LIMIT 0,1"; if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } if ( $approve_row = $db->sql_fetchrow($approve_result) ) { if ( intval($approve_row['is_topic']) == 1 ) { $approve_mod['topics_awaiting'] = true; } } if ( in_array($userdata['user_id'], $approve_mod['moderators']) || $is_auth['auth_mod'] ) { if ( $approve_mod['topics_awaiting'] ) { $topic_title .= "</a><br><a>[ " . $lang['approve_topic_is_awaiting'] . " ]"; } else { $approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . " WHERE topic_id = " . intval($topic_id) . " AND is_post = 1 ORDER BY post_id LIMIT 0,2"; if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } if ( $approve_row = $db->sql_fetchrow($approve_result) ) { if ( $db->sql_numrows($approve_result) >= 1 ) { $topic_title .= "</a><br><a>[ " . $lang['approve_topic_has_awaiting'] . " ]"; } } } } else { if ( $approve_mod['topics_awaiting'] ) { if ( $approve_mod['forum_hide_unapproved_topics'] ) { continue; } $topic_title = "</a><span>[ " . $lang['approve_topic_is_awaiting'] . " ]</span>"; $view_topic_url = append_sid("viewforum.php?f=" . $forum_id ); $last_post_url = $last_post_url = '<img>'; $goto_page = ''; $last_post_author = ( intval($topic_rowset[$i]['id2']) == intval(ANONYMOUS) ) ? $lang['Guest'] : $last_post_author; $topic_author = ( intval($topic_rowset[$i]['user_id']) == intval(ANONYMOUS) ) ? $lang['Guest'] : $topic_author; } else { $approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . " WHERE post_id = " . intval($topic_rowset[$i]['topic_last_post_id']) . " AND is_post = 1 LIMIT 0,1"; if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } $approve_row = $db->sql_fetchrow($approve_result); if ( intval($approve_row['post_id']) == intval($topic_rowset[$i]['topic_last_post_id']) ) { if ( $approve_mod['forum_hide_unapproved_posts'] ) { $approve_sql = "SELECT p.post_id, p.poster_id, p.post_time, p.post_username, u.username FROM " . POSTS_TABLE . " p, " . APPROVE_POSTS_TABLE . " a, " . USERS_TABLE . " u WHERE a.post_id = " . intval($topic_rowset[$i]['topic_last_post_id']) . " AND p.topic_id = a.topic_id AND u.user_id = p.poster_id ORDER BY p.post_time DESC"; if ( !($approve_result = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } while( $approve_row = $db->sql_fetchrow($approve_result) ) { $approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . " WHERE post_id = " . intval($approve_row['post_id']) . " LIMIT 0,1"; if ( !($approve_result2 = $db->sql_query($approve_sql)) ) { message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql); } $approve_row2 = $db->sql_fetchrow($approve_result2); if ( !$approve_row2['post_id'] ) { $last_post_time = create_date($board_config['default_dateformat'], $approve_row['post_time'], $board_config['board_timezone']); $last_post_author = ( $approve_row['poster_id'] == ANONYMOUS ) ? ( ($approve_row['post_username'] != '' ) ? $approve_row['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a>' . $approve_row['username'] . '</a>'; $last_post_url = '<a><img></a>'; break; } } } else { $last_post_author = ( intval($topic_rowset[$i]['id2']) == intval(ANONYMOUS) ) ? $lang['Guest'] : $last_post_author; } } } } }//// End Approve_Mod Block : 9// //----------------------------------------------------------------------------- // MOD: Delayed Topics if ($topic_rowset[$i]['topic_time'] > $current_time) { $delay_text = sprintf($lang['Delayed_Post_Alt'], create_date($board_config['default_dateformat'], $topic_rowset[$i]['topic_time'],$board_config['board_timezone'])); $miniclock = '<img>'; } else $miniclock = ''; // MOD: Delayed Topics {end} //----------------------------------------------------------------------------- // send topic to template $selected = (!empty($select_values) && in_array($topic_rowset[$i]['topic_id'], $select_values)); $color = !$color; $topic_rating = ( count($topic_rank_set) > 0 && $topic_rowset[$i]['rating_rank_id'] > 0 ) ? $topic_rank_set[$topic_rowset[$i]['rating_rank_id']] : ''; $template->assign_block_vars( $tpl . '.row', array( 'RATING' => $topic_rating, 'ROW_CLASS' => ($color || !defined('TOPIC_ALTERNATE_ROW_CLASS')) ? 'row1' : 'row2', 'TOPIC_INFO' => ( $topic_rowset[$i]['topic_info'] ) ? '[ ' . $topic_rowset[$i]['topic_info'] . ' ] ' : '', 'ROW_FOLDER_CLASS' => ($user_replied && defined('USER_REPLIED_CLASS')) ? USER_REPLIED_CLASS : ( ($color || !defined('TOPIC_ALTERNATE_ROW_CLASS')) ? 'row1' : 'row2' ), 'FORUM_ID' => $forum_id, 'TOPIC_ID' => $topic_id, 'TOPIC_FOLDER_IMG' => $folder_image, 'TOPIC_AUTHOR' => $topic_author, 'GOTO_PAGE' => !empty($goto_page) ? '<br>' . $goto_page : '', 'TOPIC_NAV_TREE' => !empty($nav_tree) ? (empty($goto_page) ? '<br>' : '') . $nav_tree : '', 'REPLIES' => $replies, 'NEWEST_POST_IMG' => $newest_post_img, 'ICON' => $icon, 'TOPIC_ATTACHMENT_IMG' => topic_attachment_image($topic_rowset[$i]['topic_attachment']), 'TOPIC_TITLE' => $topic_title, 'TOPIC_ANNOUNCES_DATES' => $topic_announces_dates, 'TOPIC_CALENDAR_DATES' => $topic_calendar_dates, 'TOPIC_TYPE' => $topic_type, 'VIEWS' => $views, 'FIRST_POST_TIME' => $first_post_time, 'LAST_POST_TIME' => $last_post_time, 'LAST_POST_AUTHOR' => $last_post_author, 'LAST_POST_IMG' => $last_post_url, 'MINICLOCK' => $miniclock,// BEGIN cmx_mod 'L_NEWS' => $news_label,// END cmx_mod 'TOPIC_DESCRIPTION' => $topic_desc, 'L_TOPIC_FOLDER_ALT' => $folder_alt, 'U_POSTINGS_POPUP' => append_sid("postings_popup.$phpEx?t=$topic_id"), 'U_VIEW_TOPIC' => $view_topic_url, 'BOX_ID' => $box_id, 'FID' => $topic_rowset[$i]['topic_id'], 'L_SELECT' => ($selected && ($select_multi || $select_unique)) ? 'checked="checked"' : '', ) ); if ( !empty($topic_rowset[$i]['topic_desc'])) { $topic_desc = $topic_rowset[$i]['topic_desc']; $template->assign_block_vars($tpl . '.row.switch_topic_desc', array( ) ); } $template->assign_block_vars( $tpl . '.row.topic', array()); // selection fields if ($select_multi) { $template->assign_block_vars($tpl . '.row.topic.multi_selection', array()); } if ($select_unique) { $template->assign_block_vars($tpl . '.row.topic.single_selection', array()); } // icons if ($icon_installed) { $template->assign_block_vars( $tpl . '.row.topic.icon', array()); } // nav tree asked if ($display_nav_tree && !empty($nav_tree)) { $template->assign_block_vars( $tpl . '.row.topic.nav_tree', array()); } } // end for topic_rowset read // send an header if missing if (!$header_sent) { $template->assign_block_vars($tpl . '.row', array( 'L_TITLE'