[問題]誰能提供可以放置logo廣告的外掛??

[騎狼的林小毛]

新增什麼資料庫???
怎麼在瀏覽器執行???
我要先去上班了(不知不覺遲到了 = =)
晚上回來再跟您請教
謝謝囉^^"

[文]

執行就是連結這裡\r
http://www.wgcb.net/phpbb/links_install.php

[騎狼的林小毛]

恩.按下去出現這郭東東\r
This list is a result of the SQL queries needed for the Advanced Links MOD

[Added/Updated] line: 1 , CREATE TABLE phpbb_link_categories ( cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) NOT NULL default '', cat_order mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (cat_id), KEY cat_order (cat_order)) TYPE=MyISAM
[Added/Updated] line: 2 , CREATE TABLE phpbb_links ( link_id mediumint(8) unsigned NOT NULL auto_increment, link_title varchar(100) NOT NULL default '', link_desc varchar(255) default NULL, link_category mediumint(8) unsigned NOT NULL default '0', link_url varchar(100) NOT NULL default '', link_logo_src varchar(120) default NULL, link_joined int(11) NOT NULL default '0', link_active tinyint(1) NOT NULL default '0', link_hits int(10) unsigned NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', user_ip varchar(8) NOT NULL default '', last_user_ip varchar(8) NOT NULL default '', PRIMARY KEY (link_id)) TYPE=MyISAM
[Added/Updated] line: 3 , INSERT INTO phpbb_link_categories VALUES (1, 'Arts', 1)
[Added/Updated] line: 4 , INSERT INTO phpbb_link_categories VALUES (2, 'Business', 2)
[Added/Updated] line: 5 , INSERT INTO phpbb_link_categories VALUES (3, 'Children and Teens', 3)
[Added/Updated] line: 6 , INSERT INTO phpbb_link_categories VALUES (4, 'Computers', 4)
[Added/Updated] line: 7 , INSERT INTO phpbb_link_categories VALUES (5, 'Games', 5)
[Added/Updated] line: 8 , INSERT INTO phpbb_link_categories VALUES (6, 'Health', 6)
[Added/Updated] line: 9 , INSERT INTO phpbb_link_categories VALUES (7, 'Home', 7)
[Added/Updated] line: 10 , INSERT INTO phpbb_link_categories VALUES (8, 'News', 8)
[Added/Updated] line: 11 , INSERT INTO phpbb_links VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 4, 'http://www.phpbb.com/', 'images/links/phpBB_88a.gif', 1073343491, 1, 0, 2, '', '')
[Added/Updated] line: 12 , INSERT INTO phpbb_links VALUES (2, 'phpbb-tw.net', 'Unofficial phpBB Chinese Support Centre', 4, 'http://phpbb-tw.net', 'images/links/phpbb-tw_logo88a.gif', 1073343491, 1, 0, 2, '', '')
[Added/Updated] line: 13 , INSERT INTO phpbb_links VALUES (3, 'phpbb2.de', 'Your Source for phpBB2 Stuff', 4, 'http://www.phpbb2.de', 'images/links/phpbb2_de_logo.gif', 1073343491, 1, 0, 2, '', '')
[Added/Updated] line: 14 , INSERT INTO phpbb_links VALUES (4, 'Forumimages.com', 'Forumimages.com', 4, 'http://www.forumimages.com', 'images/links/forum_images_banner_88x31.gif', 1073343491, 1, 0, 2, '', '')
[Added/Updated] line: 15 , CREATE TABLE phpbb_link_config ( config_name varchar(255) NOT NULL default '', config_value varchar(255) NOT NULL default '' ) TYPE=MyISAM
[Added/Updated] line: 16 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_logo', 'http://www.wgcb.net/phpbbimages/links/web_logo88a.gif')
[Added/Updated] line: 17 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_url', 'http://www.wgcb.net/phpbb')
[Added/Updated] line: 18 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('width', '88')
[Added/Updated] line: 19 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('height', '31')
[Added/Updated] line: 20 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('linkspp', '10')
[Added/Updated] line: 21 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_interval', '6000')
[Added/Updated] line: 22 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_logo_num', '10')
[Added/Updated] line: 23 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_links_logo', '1')
[Added/Updated] line: 24 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('email_notify', '1')
[Added/Updated] line: 25 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('pm_notify ', '0')

這樣是正確的嗎???
那麼新增資料庫呢???
麻煩各位大大囉^^"

[騎狼的林小毛]

謝謝各位大大
我剛剛終於奇蹟似的進入link的頁面\r
不過是英文版的就是了= =
若有錯誤我再來請教大大
index還是沒解決阿~~
我先試試看能不能用~~感 恩 阿\r

[aiken]

這樣是正確的嗎???
那麼新增資料庫呢???
麻煩各位大大囉^^"

.....這就已經是新增資料庫了..............

謝謝各位大大
我剛剛終於奇蹟似的進入link的頁面
不過是英文版的就是了= =
若有錯誤我再來請教大大
index還是沒解決阿~~
我先試試看能不能用~~感 恩 阿

這不是奇蹟........因為你資料庫已經新增了當然就可以用了啊~~

[騎狼的林小毛]

各位大大....偶又回來了
以為ok了....想不到阿.....

當我以為一切都以就緒
高興的放上logo準備測試
想不到不幸的事發生了....
首頁沒有顯示出logo= =
這原因應該和我沒有改index有關
但是將index上傳後他又說有錯誤 = =
我又將剛剛那個開資料庫的檔案上傳\r
在開啟一次\r
結果出現這郭\r
This list is a result of the SQL queries needed for the Advanced Links MOD

[Error or Already added] line: 1 , CREATE TABLE phpbb_link_categories ( cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) NOT NULL default '', cat_order mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (cat_id), KEY cat_order (cat_order)) TYPE=MyISAM
[Error or Already added] line: 2 , CREATE TABLE phpbb_links ( link_id mediumint(8) unsigned NOT NULL auto_increment, link_title varchar(100) NOT NULL default '', link_desc varchar(255) default NULL, link_category mediumint(8) unsigned NOT NULL default '0', link_url varchar(100) NOT NULL default '', link_logo_src varchar(120) default NULL, link_joined int(11) NOT NULL default '0', link_active tinyint(1) NOT NULL default '0', link_hits int(10) unsigned NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', user_ip varchar(8) NOT NULL default '', last_user_ip varchar(8) NOT NULL default '', PRIMARY KEY (link_id)) TYPE=MyISAM
[Error or Already added] line: 3 , INSERT INTO phpbb_link_categories VALUES (1, 'Arts', 1)
[Error or Already added] line: 4 , INSERT INTO phpbb_link_categories VALUES (2, 'Business', 2)
[Error or Already added] line: 5 , INSERT INTO phpbb_link_categories VALUES (3, 'Children and Teens', 3)
[Error or Already added] line: 6 , INSERT INTO phpbb_link_categories VALUES (4, 'Computers', 4)
[Error or Already added] line: 7 , INSERT INTO phpbb_link_categories VALUES (5, 'Games', 5)
[Error or Already added] line: 8 , INSERT INTO phpbb_link_categories VALUES (6, 'Health', 6)
[Error or Already added] line: 9 , INSERT INTO phpbb_link_categories VALUES (7, 'Home', 7)
[Error or Already added] line: 10 , INSERT INTO phpbb_link_categories VALUES (8, 'News', 8)
[Error or Already added] line: 11 , INSERT INTO phpbb_links VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 4, 'http://www.phpbb.com/', 'images/links/phpBB_88a.gif', 1073345146, 1, 0, 2, '', '')
[Error or Already added] line: 12 , INSERT INTO phpbb_links VALUES (2, 'phpbb-tw.net', 'Unofficial phpBB Chinese Support Centre', 4, 'http://phpbb-tw.net', 'images/links/phpbb-tw_logo88a.gif', 1073345146, 1, 0, 2, '', '')
[Error or Already added] line: 13 , INSERT INTO phpbb_links VALUES (3, 'phpbb2.de', 'Your Source for phpBB2 Stuff', 4, 'http://www.phpbb2.de', 'images/links/phpbb2_de_logo.gif', 1073345146, 1, 0, 2, '', '')
[Error or Already added] line: 14 , INSERT INTO phpbb_links VALUES (4, 'Forumimages.com', 'Forumimages.com', 4, 'http://www.forumimages.com', 'images/links/forum_images_banner_88x31.gif', 1073345146, 1, 0, 2, '', '')
[Error or Already added] line: 15 , CREATE TABLE phpbb_link_config ( config_name varchar(255) NOT NULL default '', config_value varchar(255) NOT NULL default '' ) TYPE=MyISAM
[Added/Updated] line: 16 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_logo', 'http://www.wgcb.net/phpbbimages/links/web_logo88a.gif')
[Added/Updated] line: 17 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_url', 'http://www.wgcb.net/phpbb')
[Added/Updated] line: 18 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('width', '88')
[Added/Updated] line: 19 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('height', '31')
[Added/Updated] line: 20 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('linkspp', '10')
[Added/Updated] line: 21 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_interval', '6000')
[Added/Updated] line: 22 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_logo_num', '10')
[Added/Updated] line: 23 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_links_logo', '1')
[Added/Updated] line: 24 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('email_notify', '1')
[Added/Updated] line: 25 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('pm_notify ', '0')

上面都是紅字....很明顯就在嘲笑我 = =#
我現在該怎麼辦呢??
大頭真大大一整天都在電腦旁邊阿^^"
麻煩囉

[atthis]

它只是告訴你，你的資料庫內已經有這些欄位，不用再新增一次了
剩下的只要把程式的部分改好應該就可以用了

[aiken]

.................................
因為你之前已經新增過了...........
[Error or Already added] <= 這句的意思....錯誤或者已經增加....
所以這樣會有錯誤才是正常的...
你沒事幹麻跑第二次sql............

[騎狼的林小毛]

那就是說index的程式有錯誤囉??
只要將index改好就ok???
我去改一次好了...
謝謝回覆哩~~
越到後面越怕沒人回覆^^"
對了..為啥咪我的外掛是中英文都有阿@@!
超神的

[騎狼的林小毛]

容許小弟將index全部po出...因為我已經改了二次\r
還是出現錯誤....真的無計可施了....

我不會把他用小.很佔版面.抱歉唷\r

上面說是第26行錯誤(可連結到我的網站觀看錯誤訊息)
不知哪位大大可幫小弟找出錯誤
感激不盡> <

p.s我完全是依照外掛上面的教學所改\r

<?php
/***************************************************************************
*

index.php
* -------------------
* begin : Saturday, Feb 13, 2001
* copyright

: (C) 2001 The phpBB Group
* email : support@phpbb.com
*
* $Id: index.php,v 1.99.2.1

2002/12/19 17:17:40 psotfx Exp $
*
*
***************************************************************************/

/***************************************************************************
*
* 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.
*


***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path =

'./';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);require($phpbb_root_path .

'language/lang_' . $board_config['default_lang'] . '/lang_main_link.' . $phpEx);

//
// Start session management
//
$userdata

= session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//

$viewcat = ( !empty

($HTTP_GET_VARS[POST_CAT_URL]) ) ? $HTTP_GET_VARS[POST_CAT_URL] : -1;

if( isset($HTTP_GET_VARS['mark']) || isset

($HTTP_POST_VARS['mark']) )
{
$mark_read = ( isset($HTTP_POST_VARS['mark']) ) ? $HTTP_POST_VARS['mark'] : $HTTP_GET_VARS

['mark'];
}
else
{
$mark_read = '';
}

//
// Handle marking posts
//
if( $mark_read == 'forums' )
{
if(

$userdata['session_logged_in'] )
{
setcookie($board_config['cookie_name'] . '_f_all', time(), 0,

$board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']);
}

$template-

>assign_vars(array(
"META" => '<meta http-equiv="refresh" content="3;url=' .append_sid("index.$phpEx") . '">')


);

$message = $lang['Forums_marked_read'] . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' .

append_sid("index.$phpEx") . '">', '</a> ');

message_die(GENERAL_MESSAGE, $message);
}
//
// End handle marking posts
//

$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();

//
// If you don't use these stats

on your index you may want to consider
// removing them
//
$total_posts = get_db_stat('postcount');
$total_users =

get_db_stat('usercount');
$newest_userdata = get_db_stat('newestuser');
$newest_user = $newest_userdata['username'];
$newest_uid = $newest_userdata['user_id'];

if( $total_posts == 0 )
{
$l_total_post_s = $lang

['Posted_articles_zero_total'];
}
else if( $total_posts == 1 )
{
$l_total_post_s = $lang['Posted_article_total'];
}
else
{
$l_total_post_s = $lang['Posted_articles_total'];
}

if( $total_users == 0 )
{
$l_total_user_s = $lang

['Registered_users_zero_total'];
}
else if( $total_users == 1 )
{
$l_total_user_s = $lang['Registered_user_total'];
}
else
{
$l_total_user_s = $lang['Registered_users_total'];
}


//
// Start page proper
//
$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);\r
}

while( $category_rows[] = $db->sql_fetchrow($result) );

if( ( $total_categories = count($category_rows) ) )
{
//
//

Define appropriate SQL
//
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;
}

if ( !($total_forums = count($forum_data)) )


{
message_die(GENERAL_MESSAGE, $lang['No_forums']);
}

//
// Obtain a list of topic ids which

contain
// posts made since user last visited
//
if ( $userdata['session_logged_in'] )
{
$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

['user_lastvisit'] . "
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['forum_id']][$topic_data

['topic_id']] = $topic_data['post_time'];
}
}

//
// Obtain list of moderators of each forum


// First users, then groups ... broken into two queries
//
$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[$row['forum_id']][] = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL .

"=" . $row['user_id']) . '">' . $row['username'] . '</a>';
}

$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

[$row['forum_id']][] = '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=" . $row['group_id']) . '">' . $row

['group_name'] . '</a>';
}

//
// Find which forums are visible for this user
//
$is_auth_ary = array

();
$is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);$sql = "SELECT *
FROM ". LINK_CONFIG_TABLE;
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, "Could not query Link config information", "", __LINE__, __FILE__, $sql);
}

while( $row = $db->sql_fetchrow($result) )
{
$link_config_name = $row['config_name'];
$link_config_value = $row['config_value'];
$link_config[$link_config_name] = $link_config_value;
$link_self_img = $link_config['site_logo'];
$site_logo_height = $link_config['height'];
$site_logo_width = $link_config['width'];
}

//
// Start output of page
//
define('SHOW_ONLINE', true);
$page_title = $lang

['Index'];
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['Newest_user'], '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$newest_uid") .

'">', $newest_user, '</a>'),

'FORUM_IMG' => $images['forum'],
'FORUM_NEW_IMG' => $images

['forum_new'],
'FORUM_LOCKED_IMG' => $images['forum_locked'],

'L_FORUM' => $lang['Forum'],


'L_TOPICS' => $lang['Topics'],
'L_REPLIES' => $lang['Replies'],
'L_VIEWS' => $lang['Views'],


'L_POSTS' => $lang['Posts'],
'L_LASTPOST' => $lang['Last_Post'],
'L_NO_NEW_POSTS' => $lang

['No_new_posts'],
'L_NEW_POSTS' => $lang['New_posts'],
'L_NO_NEW_POSTS_LOCKED' => $lang

['No_new_posts_locked'],
'L_NEW_POSTS_LOCKED' => $lang['New_posts_locked'],
'L_ONLINE_EXPLAIN' =>

$lang['Online_explain'],'L_LINKS' => $lang['Site_links'],
'U_LINKS' => append_sid("links.$phpEx"),
'U_LINKS_JS' => "links.js.$phpEx",
'U_SITE_LOGO' => $link_self_img,
'SITE_LOGO_WIDTH' => $site_logo_width,
'SITE_LOGO_HEIGHT' => $site_logo_height,

'L_MODERATOR' => $lang['Moderators'],


'L_FORUM_LOCKED' => $lang['Forum_is_locked'],
'L_MARK_FORUMS_READ' => $lang['Mark_all_forums'],



'U_MARK_READ' => append_sid("index.$phpEx?mark=forums"))
);

//
// Okay, let's build the index
//
for

($i = 0; $i < $total_categories; $i++)
{
$cat_id = $category_rows[$i]['cat_id'];

//


// Should we display this category/forum set?
//
$display_forums = false;
for($j = 0;

$j < $total_forums; $j++)
{
if ( $is_auth_ary[$forum_data[$j]['forum_id']]['auth_view']

&& $forum_data[$j]['cat_id'] == $cat_id )
{
$display_forums = true;


}
}

//
// Yes, we should, so first dump out the category


// title, then, if appropriate the forum list
//
if ( $display_forums )
{


$template->assign_block_vars('catrow', array(
'CAT_ID' => $cat_id,


'CAT_DESC' => $category_rows[$i]['cat_title'],
'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[$j]['cat_id'] == $cat_id )
{


$forum_id = $forum_data[$j]['forum_id'];

if ( $is_auth_ary

[$forum_id]['auth_view'] )
{


if ( $forum_data[$j]['forum_status'] == FORUM_LOCKED )
{


$folder_image = $images['forum_locked'];


$folder_alt = $lang['Forum_locked'];
}


else
{


$unread_topics = false;
if (

$userdata['session_logged_in'] )
{


if ( !empty($new_topic_data[$forum_id]) )


{
$forum_last_post_time

= 0;

while( list($check_topic_id,

$check_post_time) = @each($new_topic_data[$forum_id]) )


{
if ( empty($tracking_topics

[$check_topic_id]) )
{


$unread_topics = true;


$forum_last_post_time = max($check_post_time,

$forum_last_post_time);

}


else


{


if ( $tracking_topics[$check_topic_id] < $check_post_time )


{


$unread_topics = true;


$forum_last_post_time = max($check_post_time, $forum_last_post_time);


}
}


}



if ( !empty($tracking_forums[$forum_id]) )


{
if (

$tracking_forums[$forum_id] > $forum_last_post_time )


{
$unread_topics =

false;
}


}

if (

isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) )


{
if (

$HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all'] > $forum_last_post_time )


{


$unread_topics = false;
}


}



}
}



$folder_image = ( $unread_topics ) ? $images['forum_new'] : $images['forum'];


$folder_alt = ( $unread_topics ) ? $lang['New_posts'] : $lang['No_new_posts'];


}

$posts = $forum_data[$j]

['forum_posts'];
$topics = $forum_data[$j]['forum_topics'];



if ( $forum_data[$j]['forum_last_post_id'] )


{
$last_post_time = create_date($board_config

['default_dateformat'], $forum_data[$j]['post_time'], $board_config['board_timezone']);



$last_post = $last_post_time . '<br />';



$last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? $forum_data[$j]

['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" .

POST_USERS_URL . '=' . $forum_data[$j]['user_id']) . '">' . $forum_data[$j]['username'] . '</a> ';



$last_post .= '<a href="' .

append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data[$j]['forum_last_post_id']) . '#' . $forum_data[$j]

['forum_last_post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] .

'" title="' . $lang['View_latest_post'] . '" /></a>';
}


else
{


$last_post = $lang['No_Posts'];
}



if ( count($forum_moderators[$forum_id]) > 0 )


{
$l_moderators = ( count($forum_moderators[$forum_id])

== 1 ) ? $lang['Moderator'] : $lang['Moderators'];


$moderator_list = implode(', ', $forum_moderators[$forum_id]);
}


else
{


$l_moderators = ' ';


$moderator_list = ' ';
}



$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];


$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];



$template->assign_block_vars('catrow.forumrow', array(


'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,


'FORUM_FOLDER_IMG' => $folder_image,


'FORUM_NAME' => $forum_data[$j]['forum_name'],


'FORUM_DESC' => $forum_data[$j]['forum_desc'],
'POSTS' =>

$forum_data[$j]['forum_posts'],
'TOPICS' => $forum_data[$j]

['forum_topics'],
'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"))
);


}
}
}
}


}
} // for ... categories

}// if ... total_categories
else
{
message_die(GENERAL_MESSAGE, $lang

['No_forums']);
}

//
// Generate the page
//
$template->pparse('body');

include($phpbb_root_path .

'includes/page_tail.'.$phpEx);

?>