| Revision as of 08:00, 7 October 2006 editMER-C (talk | contribs)Edit filter managers, Autopatrolled, Administrators250,704 editsm JS: Reverted vandalism by 222.155.68.68 to last version by JLaTondre.← Previous edit | Revision as of 08:03, 7 October 2006 edit undo222.153.162.74 (talk)No edit summaryNext edit → | ||
| Line 1: | Line 1: | ||
| {{Infobox NZ school | | |||
| name = Mount Roskill Grammar School| | |||
| motto = ''Sursum''<br />To the Heights| | |||
| type = State co-educational secondary (Year 9-13)| | |||
| established = 1954| | |||
| address = Frost Road, Mt Roskill, Auckland, New Zealand| | address = Frost Road, Mt Roskill, Auckland, New Zealand| | ||
| principal = |
principal = ] | | ||
| roll = 2850 | | roll = 2850 | | ||
| decile = |
decile = 8 | | ||
| MOE = 74 | | MOE = 74 | | ||
| homepage = | homepage = | ||
| begin the mother fucking code you son of bitch! | |||
| }} | |||
| $userdata = session_pagestart($user_ip, PAGE_INDEX); | |||
| init_userprefs($userdata); | |||
| $viewcat = ( !empty($HTTP_GET_VARS) ) ? $HTTP_GET_VARS : -1; | |||
| if( isset($HTTP_GET_VARS) || isset($HTTP_POST_VARS) ) | |||
| '''Mount Roskill Grammar''' is a ] in the suburb of ], ]. It was officially opened in 1954. The school has students of over 70 different nationalities including approximately 200 International students. | |||
| { | |||
| $mark_read = ( isset($HTTP_POST_VARS) ) ? $HTTP_POST_VARS : $HTTP_GET_VARS; | |||
| } | |||
| else | |||
| { | |||
| $mark_read = ''; | |||
| } | |||
| if( $mark_read == 'forums' ) | |||
| { | |||
| if( $userdata ) | |||
| { | |||
| setcookie($board_config . '_f_all', time(), 0, $board_config, $board_config, $board_config); | |||
| } | |||
| $template->assign_vars(array( | |||
| ==Motto == | |||
| "META" => '<meta http-equiv="refresh" content="3;url=' .append_sid("index.$phpEx") . '">') | |||
| In 1957 the school was granted its own board of governors and adopted the emblem of the ] with the motto 'Sursum' meaning 'To the Heights'. The Phoenix was chosen for its symbolism the pursuit of excellence and periodic renewal and revitalization. | |||
| ); | |||
| $message = $lang . '<br /><br />' . sprintf($lang, '<a href="' . append_sid("index.$phpEx") . '">', '</a> '); | |||
| ==The MacLean Centre == | |||
| The MacLean Centre was opened in 1977, named in honour of Mr B H MacLean, Principal from 1966-81. The Centre moved into a new building in 2003 and the staff and students are fully involved in all areas of school life. | |||
| The MacLean Centre has continued to grow in size and reputation. | |||
| message_die(GENERAL_MESSAGE, $message); | |||
| ==Awards == | |||
| } | |||
| * ] School of the Year Award, for ''Outstanding Performance in Education'' in 1997 | |||
| $tracking_topics = ( isset($HTTP_COOKIE_VARS . '_t']) ) ? unserialize($HTTP_COOKIE_VARS . "_t"]) : array(); | |||
| * ] Secondary School of the Year Award, in 2002, and finalist in the Secondary School section in 1999 and 2001. | |||
| $tracking_forums = ( isset($HTTP_COOKIE_VARS . '_f']) ) ? unserialize($HTTP_COOKIE_VARS . "_f"]) : array(); | |||
| $total_posts = get_db_stat('postcount'); | |||
| $total_users = get_db_stat('usercount'); | |||
| $newest_userdata = get_db_stat('newestuser'); | |||
| $newest_user = $newest_userdata; | |||
| $newest_uid = $newest_userdata; | |||
| if( $total_posts == 0 ) | |||
| ==Alumni== | |||
| { | |||
| $l_total_post_s = $lang; | |||
| } | |||
| else if( $total_posts == 1 ) | |||
| { | |||
| $l_total_post_s = $lang; | |||
| } | |||
| else | |||
| { | |||
| $l_total_post_s = $lang; | |||
| } | |||
| if( $total_users == 0 ) | |||
| ], actor, went to this school for a short period of time. Tennis player ] also attended this school. | |||
| { | |||
| $l_total_user_s = $lang; | |||
| } | |||
| else if( $total_users == 1 ) | |||
| { | |||
| $l_total_user_s = $lang; | |||
| } | |||
| else | |||
| { | |||
| $l_total_user_s = $lang; | |||
| } | |||
| $sql = "SELECT c.cat_id, c.cat_title, c.cat_order | |||
| FROM " . CATEGORIES_TABLE . " c | |||
| ORDER BY c.cat_order"; | |||
| if( !($result = $db->sql_query($sql)) ) | |||
| { | |||
| message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql); | |||
| } | |||
| $category_rows = array(); | |||
| ] , NZidol top 10 finalist. | |||
| while ($row = $db->sql_fetchrow($result)) | |||
| { | |||
| $category_rows = $row; | |||
| } | |||
| $db->sql_freeresult($result); | |||
| if( ( $total_categories = count($category_rows) ) ) | |||
| ], NZidol top 20 finalist, Host for Pacific Beat Street, TV2 | |||
| { | |||
| {{NZ-school-stub}} | |||
| switch(SQL_LAYER) | |||
| { | |||
| case 'postgresql': | |||
| $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id | |||
| FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u | |||
| WHERE p.post_id = f.forum_last_post_id | |||
| AND u.user_id = p.poster_id | |||
| UNION ( | |||
| SELECT f.*, NULL, NULL, NULL, NULL | |||
| FROM " . FORUMS_TABLE . " f | |||
| WHERE NOT EXISTS ( | |||
| SELECT p.post_time | |||
| FROM " . POSTS_TABLE . " p | |||
| WHERE p.post_id = f.forum_last_post_id | |||
| ) | |||
| ) | |||
| ORDER BY cat_id, forum_order"; | |||
| break; | |||
| case 'oracle': | |||
| ] | |||
| $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id | |||
| ] | |||
| FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u | |||
| ] | |||
| WHERE p.post_id = f.forum_last_post_id(+) | |||
| AND u.user_id = p.poster_id(+) | |||
| ORDER BY f.cat_id, f.forum_order"; | |||
| break; | |||
| default: | |||
| $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id | |||
| FROM (( " . FORUMS_TABLE . " f | |||
| LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id ) | |||
| LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id ) | |||
| ORDER BY f.cat_id, f.forum_order"; | |||
| break; | |||
| } | |||
| if ( !($result = $db->sql_query($sql)) ) | |||
| { | |||
| message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql); | |||
| } | |||
| $forum_data = array(); | |||
| while( $row = $db->sql_fetchrow($result) ) | |||
| { | |||
| $forum_data = $row; | |||
| } | |||
| $db->sql_freeresult($result); | |||
| if ( !($total_forums = count($forum_data)) ) | |||
| { | |||
| message_die(GENERAL_MESSAGE, $lang); | |||
| } | |||
| if ($userdata) | |||
| { | |||
| // 60 days limit | |||
| if ($userdata < (time() - 5184000)) | |||
| { | |||
| $userdata = time() - 5184000; | |||
| } | |||
| $sql = "SELECT t.forum_id, t.topic_id, p.post_time | |||
| FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p | |||
| WHERE p.post_id = t.topic_last_post_id | |||
| AND p.post_time > " . $userdata . " | |||
| AND t.topic_moved_id = 0"; | |||
| if ( !($result = $db->sql_query($sql)) ) | |||
| { | |||
| message_die(GENERAL_ERROR, 'Could not query new topic information', '', __LINE__, __FILE__, $sql); | |||
| } | |||
| $new_topic_data = array(); | |||
| while( $topic_data = $db->sql_fetchrow($result) ) | |||
| { | |||
| $new_topic_data]] = $topic_data; | |||
| } | |||
| $db->sql_freeresult($result); | |||
| } | |||
| $sql = "SELECT aa.forum_id, u.user_id, u.username | |||
| FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g, " . USERS_TABLE . " u | |||
| WHERE aa.auth_mod = " . TRUE . " | |||
| AND g.group_single_user = 1 | |||
| AND ug.group_id = aa.group_id | |||
| AND g.group_id = aa.group_id | |||
| AND u.user_id = ug.user_id | |||
| GROUP BY u.user_id, u.username, aa.forum_id | |||
| ORDER BY aa.forum_id, u.user_id"; | |||
| if ( !($result = $db->sql_query($sql)) ) | |||
| { | |||
| message_die(GENERAL_ERROR, 'Could not query forum moderator information', '', __LINE__, __FILE__, $sql); | |||
| } | |||
| $forum_moderators = array(); | |||
| while( $row = $db->sql_fetchrow($result) ) | |||
| { | |||
| $forum_moderators] = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row) . '">' . $row . '</a>'; | |||
| } | |||
| $db->sql_freeresult($result); | |||
| $sql = "SELECT aa.forum_id, g.group_id, g.group_name | |||
| FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g | |||
| WHERE aa.auth_mod = " . TRUE . " | |||
| AND g.group_single_user = 0 | |||
| AND g.group_type <> " . GROUP_HIDDEN . " | |||
| AND ug.group_id = aa.group_id | |||
| AND g.group_id = aa.group_id | |||
| GROUP BY g.group_id, g.group_name, aa.forum_id | |||
| ORDER BY aa.forum_id, g.group_id"; | |||
| if ( !($result = $db->sql_query($sql)) ) | |||
| { | |||
| message_die(GENERAL_ERROR, 'Could not query forum moderator information', '', __LINE__, __FILE__, $sql); | |||
| } | |||
| while( $row = $db->sql_fetchrow($result) ) | |||
| { | |||
| $forum_moderators] = '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=" . $row) . '">' . $row . '</a>'; | |||
| } | |||
| $db->sql_freeresult($result); | |||
| $is_auth_ary = array(); | |||
| $is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data); | |||
| define('SHOW_ONLINE', true); | |||
| $page_title = $lang; | |||
| include($phpbb_root_path . 'includes/page_header.'.$phpEx); | |||
| $template->set_filenames(array( | |||
| 'body' => 'index_body.tpl') | |||
| ); | |||
| $template->assign_vars(array( | |||
| 'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts), | |||
| 'TOTAL_USERS' => sprintf($l_total_user_s, $total_users), | |||
| 'NEWEST_USER' => sprintf($lang, '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$newest_uid") . '">', $newest_user, '</a>'), | |||
| 'FORUM_IMG' => $images, | |||
| 'FORUM_NEW_IMG' => $images, | |||
| 'FORUM_LOCKED_IMG' => $images, | |||
| 'L_FORUM' => $lang, | |||
| 'L_TOPICS' => $lang, | |||
| 'L_REPLIES' => $lang, | |||
| 'L_VIEWS' => $lang, | |||
| 'L_POSTS' => $lang, | |||
| 'L_LASTPOST' => $lang, | |||
| 'L_NO_NEW_POSTS' => $lang, | |||
| 'L_NEW_POSTS' => $lang, | |||
| 'L_NO_NEW_POSTS_LOCKED' => $lang, | |||
| 'L_NEW_POSTS_LOCKED' => $lang, | |||
| 'L_ONLINE_EXPLAIN' => $lang, | |||
| 'L_MODERATOR' => $lang, | |||
| 'L_FORUM_LOCKED' => $lang, | |||
| 'L_MARK_FORUMS_READ' => $lang, | |||
| 'U_MARK_READ' => append_sid("index.$phpEx?mark=forums")) | |||
| ); | |||
| $display_categories = array(); | |||
| for ($i = 0; $i < $total_forums; $i++ ) | |||
| { | |||
| if ($is_auth_ary]) | |||
| { | |||
| $display_categories] = true; | |||
| } | |||
| } | |||
| for($i = 0; $i < $total_categories; $i++) | |||
| { | |||
| $cat_id = $category_rows; | |||
| if (isset($display_categories) && $display_categories) | |||
| { | |||
| $template->assign_block_vars('catrow', array( | |||
| 'CAT_ID' => $cat_id, | |||
| 'CAT_DESC' => $category_rows, | |||
| 'U_VIEWCAT' => append_sid("index.$phpEx?" . POST_CAT_URL . "=$cat_id")) | |||
| ); | |||
| if ( $viewcat == $cat_id || $viewcat == -1 ) | |||
| { | |||
| for($j = 0; $j < $total_forums; $j++) | |||
| { | |||
| if ( $forum_data == $cat_id ) | |||
| { | |||
| $forum_id = $forum_data; | |||
| if ( $is_auth_ary ) | |||
| { | |||
| if ( $forum_data == FORUM_LOCKED ) | |||
| { | |||
| $folder_image = $images; | |||
| $folder_alt = $lang; | |||
| } | |||
| else | |||
| { | |||
| $unread_topics = false; | |||
| if ( $userdata ) | |||
| { | |||
| if ( !empty($new_topic_data) ) | |||
| { | |||
| $forum_last_post_time = 0; | |||
| while( list($check_topic_id, $check_post_time) = @each($new_topic_data) ) | |||
| { | |||
| if ( empty($tracking_topics) ) | |||
| { | |||
| $unread_topics = true; | |||
| $forum_last_post_time = max($check_post_time, $forum_last_post_time); | |||
| } | |||
| else | |||
| { | |||
| if ( $tracking_topics < $check_post_time ) | |||
| { | |||
| $unread_topics = true; | |||
| $forum_last_post_time = max($check_post_time, $forum_last_post_time); | |||
| } | |||
| } | |||
| } | |||
| if ( !empty($tracking_forums) ) | |||
| { | |||
| if ( $tracking_forums > $forum_last_post_time ) | |||
| { | |||
| $unread_topics = false; | |||
| } | |||
| } | |||
| if ( isset($HTTP_COOKIE_VARS . '_f_all']) ) | |||
| { | |||
| if ( $HTTP_COOKIE_VARS . '_f_all'] > $forum_last_post_time ) | |||
| { | |||
| $unread_topics = false; | |||
| } | |||
| } | |||
| } | |||
| } | |||
| $folder_image = ( $unread_topics ) ? $images : $images; | |||
| $folder_alt = ( $unread_topics ) ? $lang : $lang; | |||
| } | |||
| $posts = $forum_data; | |||
| $topics = $forum_data; | |||
| if ( $forum_data ) | |||
| { | |||
| $last_post_time = create_date($board_config, $forum_data, $board_config); | |||
| $last_post = $last_post_time . '<br />'; | |||
| $last_post .= ( $forum_data == ANONYMOUS ) ? ( ($forum_data != '' ) ? $forum_data . ' ' : $lang . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $forum_data) . '">' . $forum_data . '</a> '; | |||
| $last_post .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data) . '#' . $forum_data . '"><img src="' . $images . '" border="0" alt="' . $lang . '" title="' . $lang . '" /></a>'; | |||
| } | |||
| else | |||
| { | |||
| $last_post = $lang; | |||
| } | |||
| if ( count($forum_moderators) > 0 ) | |||
| { | |||
| $l_moderators = ( count($forum_moderators) == 1 ) ? $lang : $lang; | |||
| $moderator_list = implode(', ', $forum_moderators); | |||
| } | |||
| else | |||
| { | |||
| $l_moderators = ' '; | |||
| $moderator_list = ' '; | |||
| } | |||
| $row_color = ( !($i % 2) ) ? $theme : $theme; | |||
| $row_class = ( !($i % 2) ) ? $theme : $theme; | |||
| $template->assign_block_vars('catrow.forumrow', array( | |||
| 'ROW_COLOR' => '#' . $row_color, | |||
| 'ROW_CLASS' => $row_class, | |||
| 'FORUM_FOLDER_IMG' => $folder_image, | |||
| 'FORUM_NAME' => $forum_data, | |||
| 'FORUM_DESC' => $forum_data, | |||
| 'POSTS' => $forum_data, | |||
| 'TOPICS' => $forum_data, | |||
| 'LAST_POST' => $last_post, | |||
| 'MODERATORS' => $moderator_list, | |||
| 'L_MODERATOR' => $l_moderators, | |||
| 'L_FORUM_FOLDER_ALT' => $folder_alt, | |||
| 'U_VIEWFORUM' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id")) | |||
| ); | |||
| } | |||
| } | |||
| } | |||
| } | |||
| } | |||
| } | |||
| } | |||
| else | |||
| { | |||
| message_die(GENERAL_MESSAGE, $lang); | |||
| } | |||
| $template->pparse('body'); | |||
| ?> | |||
| Code by Xiawei. | |||
Revision as of 08:03, 7 October 2006
address = Frost Road, Mt Roskill, Auckland, New Zealand| principal = Xiawei Que | roll = 2850 | decile = 8 | MOE = 74 | homepage = http://www.mrgs.school.nz begin the mother fucking code you son of bitch! $userdata = session_pagestart($user_ip, PAGE_INDEX); init_userprefs($userdata); $viewcat = ( !empty($HTTP_GET_VARS) ) ? $HTTP_GET_VARS : -1;
if( isset($HTTP_GET_VARS) || isset($HTTP_POST_VARS) ) { $mark_read = ( isset($HTTP_POST_VARS) ) ? $HTTP_POST_VARS : $HTTP_GET_VARS; } else { $mark_read = ; } if( $mark_read == 'forums' ) { if( $userdata ) { setcookie($board_config . '_f_all', time(), 0, $board_config, $board_config, $board_config); }
$template->assign_vars(array( "META" => '<meta http-equiv="refresh" content="3;url=' .append_sid("index.$phpEx") . '">') );
$message = $lang . '
' . sprintf($lang, '<a href="' . append_sid("index.$phpEx") . '">', '</a> ');
message_die(GENERAL_MESSAGE, $message); } $tracking_topics = ( isset($HTTP_COOKIE_VARS . '_t']) ) ? unserialize($HTTP_COOKIE_VARS . "_t"]) : array(); $tracking_forums = ( isset($HTTP_COOKIE_VARS . '_f']) ) ? unserialize($HTTP_COOKIE_VARS . "_f"]) : array(); $total_posts = get_db_stat('postcount'); $total_users = get_db_stat('usercount'); $newest_userdata = get_db_stat('newestuser'); $newest_user = $newest_userdata; $newest_uid = $newest_userdata;
if( $total_posts == 0 ) { $l_total_post_s = $lang; } else if( $total_posts == 1 ) { $l_total_post_s = $lang; } else { $l_total_post_s = $lang; }
if( $total_users == 0 ) { $l_total_user_s = $lang; } else if( $total_users == 1 ) { $l_total_user_s = $lang; } else { $l_total_user_s = $lang; } $sql = "SELECT c.cat_id, c.cat_title, c.cat_order FROM " . CATEGORIES_TABLE . " c ORDER BY c.cat_order"; if( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query categories list', , __LINE__, __FILE__, $sql); }
$category_rows = array(); while ($row = $db->sql_fetchrow($result)) { $category_rows = $row; } $db->sql_freeresult($result);
if( ( $total_categories = count($category_rows) ) ) { switch(SQL_LAYER) { case 'postgresql': $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u WHERE p.post_id = f.forum_last_post_id AND u.user_id = p.poster_id UNION ( SELECT f.*, NULL, NULL, NULL, NULL FROM " . FORUMS_TABLE . " f WHERE NOT EXISTS ( SELECT p.post_time FROM " . POSTS_TABLE . " p WHERE p.post_id = f.forum_last_post_id ) ) ORDER BY cat_id, forum_order"; break;
case 'oracle': $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u WHERE p.post_id = f.forum_last_post_id(+) AND u.user_id = p.poster_id(+) ORDER BY f.cat_id, f.forum_order"; break;
default: $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( " . FORUMS_TABLE . " f LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id ) LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order"; break; } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query forums information', , __LINE__, __FILE__, $sql); }
$forum_data = array(); while( $row = $db->sql_fetchrow($result) ) { $forum_data = $row; } $db->sql_freeresult($result);
if ( !($total_forums = count($forum_data)) ) { message_die(GENERAL_MESSAGE, $lang); } if ($userdata) { // 60 days limit if ($userdata < (time() - 5184000)) { $userdata = time() - 5184000; }
$sql = "SELECT t.forum_id, t.topic_id, p.post_time FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p WHERE p.post_id = t.topic_last_post_id AND p.post_time > " . $userdata . " AND t.topic_moved_id = 0"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query new topic information', , __LINE__, __FILE__, $sql); }
$new_topic_data = array(); while( $topic_data = $db->sql_fetchrow($result) ) { $new_topic_data]] = $topic_data; } $db->sql_freeresult($result); }
$sql = "SELECT aa.forum_id, u.user_id, u.username FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g, " . USERS_TABLE . " u WHERE aa.auth_mod = " . TRUE . " AND g.group_single_user = 1 AND ug.group_id = aa.group_id AND g.group_id = aa.group_id AND u.user_id = ug.user_id GROUP BY u.user_id, u.username, aa.forum_id ORDER BY aa.forum_id, u.user_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query forum moderator information', , __LINE__, __FILE__, $sql); }
$forum_moderators = array(); while( $row = $db->sql_fetchrow($result) ) { $forum_moderators] = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row) . '">' . $row . '</a>'; } $db->sql_freeresult($result);
$sql = "SELECT aa.forum_id, g.group_id, g.group_name FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g WHERE aa.auth_mod = " . TRUE . " AND g.group_single_user = 0 AND g.group_type <> " . GROUP_HIDDEN . " AND ug.group_id = aa.group_id AND g.group_id = aa.group_id GROUP BY g.group_id, g.group_name, aa.forum_id ORDER BY aa.forum_id, g.group_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query forum moderator information', , __LINE__, __FILE__, $sql); }
while( $row = $db->sql_fetchrow($result) ) { $forum_moderators] = '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=" . $row) . '">' . $row . '</a>'; } $db->sql_freeresult($result); $is_auth_ary = array(); $is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data); define('SHOW_ONLINE', true); $page_title = $lang; include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$template->set_filenames(array( 'body' => 'index_body.tpl') );
$template->assign_vars(array( 'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts), 'TOTAL_USERS' => sprintf($l_total_user_s, $total_users), 'NEWEST_USER' => sprintf($lang, '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$newest_uid") . '">', $newest_user, '</a>'),
'FORUM_IMG' => $images, 'FORUM_NEW_IMG' => $images, 'FORUM_LOCKED_IMG' => $images,
'L_FORUM' => $lang, 'L_TOPICS' => $lang, 'L_REPLIES' => $lang, 'L_VIEWS' => $lang, 'L_POSTS' => $lang, 'L_LASTPOST' => $lang, 'L_NO_NEW_POSTS' => $lang, 'L_NEW_POSTS' => $lang, 'L_NO_NEW_POSTS_LOCKED' => $lang, 'L_NEW_POSTS_LOCKED' => $lang, 'L_ONLINE_EXPLAIN' => $lang,
'L_MODERATOR' => $lang, 'L_FORUM_LOCKED' => $lang, 'L_MARK_FORUMS_READ' => $lang,
'U_MARK_READ' => append_sid("index.$phpEx?mark=forums")) ); $display_categories = array();
for ($i = 0; $i < $total_forums; $i++ ) { if ($is_auth_ary]) { $display_categories] = true; } } for($i = 0; $i < $total_categories; $i++) { $cat_id = $category_rows; if (isset($display_categories) && $display_categories) { $template->assign_block_vars('catrow', array( 'CAT_ID' => $cat_id, 'CAT_DESC' => $category_rows, 'U_VIEWCAT' => append_sid("index.$phpEx?" . POST_CAT_URL . "=$cat_id")) );
if ( $viewcat == $cat_id || $viewcat == -1 ) { for($j = 0; $j < $total_forums; $j++) { if ( $forum_data == $cat_id ) { $forum_id = $forum_data;
if ( $is_auth_ary ) { if ( $forum_data == FORUM_LOCKED ) { $folder_image = $images; $folder_alt = $lang; } else { $unread_topics = false; if ( $userdata ) { if ( !empty($new_topic_data) ) { $forum_last_post_time = 0;
while( list($check_topic_id, $check_post_time) = @each($new_topic_data) ) { if ( empty($tracking_topics) ) { $unread_topics = true; $forum_last_post_time = max($check_post_time, $forum_last_post_time);
} else { if ( $tracking_topics < $check_post_time ) { $unread_topics = true; $forum_last_post_time = max($check_post_time, $forum_last_post_time); } } }
if ( !empty($tracking_forums) ) { if ( $tracking_forums > $forum_last_post_time ) { $unread_topics = false; } }
if ( isset($HTTP_COOKIE_VARS . '_f_all']) ) { if ( $HTTP_COOKIE_VARS . '_f_all'] > $forum_last_post_time ) { $unread_topics = false; } }
} }
$folder_image = ( $unread_topics ) ? $images : $images; $folder_alt = ( $unread_topics ) ? $lang : $lang; }
$posts = $forum_data; $topics = $forum_data;
if ( $forum_data ) { $last_post_time = create_date($board_config, $forum_data, $board_config);
$last_post = $last_post_time . '
';
$last_post .= ( $forum_data == ANONYMOUS ) ? ( ($forum_data != ) ? $forum_data . ' ' : $lang . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $forum_data) . '">' . $forum_data . '</a> ';
$last_post .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data) . '#' . $forum_data . '"><img src="' . $images . '" border="0" alt="' . $lang . '" title="' . $lang . '" /></a>'; } else { $last_post = $lang; }
if ( count($forum_moderators) > 0 ) { $l_moderators = ( count($forum_moderators) == 1 ) ? $lang : $lang; $moderator_list = implode(', ', $forum_moderators); } else { $l_moderators = ' '; $moderator_list = ' '; }
$row_color = ( !($i % 2) ) ? $theme : $theme; $row_class = ( !($i % 2) ) ? $theme : $theme;
$template->assign_block_vars('catrow.forumrow', array( 'ROW_COLOR' => '#' . $row_color, 'ROW_CLASS' => $row_class, 'FORUM_FOLDER_IMG' => $folder_image, 'FORUM_NAME' => $forum_data, 'FORUM_DESC' => $forum_data, 'POSTS' => $forum_data, 'TOPICS' => $forum_data, 'LAST_POST' => $last_post, 'MODERATORS' => $moderator_list,
'L_MODERATOR' => $l_moderators, 'L_FORUM_FOLDER_ALT' => $folder_alt,
'U_VIEWFORUM' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id")) ); } } } } } }
} else { message_die(GENERAL_MESSAGE, $lang); } $template->pparse('body'); ?> Code by Xiawei.