ACP Site Announcement Centre

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Site Announcement Centre

Post by lefty74 » Sun Mar 02, 2008 9:30 am

you need to find this code in the index_body.tpl(it's there 2 times for the announcements, once for the guest announcements and once for the normal announcements):

Code: Select all

<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline"> 
If you take the class="forumline" of or edit it to a diff class or even change the table width, you should be to edit it to the desired effect :)
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

User avatar
2LadyDi
Registered User
Posts: 258
Joined: Fri Mar 15, 2002 6:01 am
Location: MD, USA
Contact:

Re: ACP Site Announcement Centre

Post by 2LadyDi » Sun Mar 02, 2008 1:07 pm

Looks marvelous Lefty. Ok, now It has a huge boxed area with nothing in it PRIOR to log-in. Where do I change that?
WebMistress of SHAGGY's Studio.com
http://www.shaggysstudio.com

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Site Announcement Centre

Post by lefty74 » Sun Mar 02, 2008 1:30 pm

2LadyDi wrote:Looks marvelous Lefty. Ok, now It has a huge boxed area with nothing in it PRIOR to log-in. Where do I change that?
??
What are your settings? Do you have it so that Guest users receive a separate announcement and that is empty?
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

User avatar
2LadyDi
Registered User
Posts: 258
Joined: Fri Mar 15, 2002 6:01 am
Location: MD, USA
Contact:

Re: ACP Site Announcement Centre

Post by 2LadyDi » Sun Mar 02, 2008 6:43 pm

lefty74 wrote: ??
What are your settings? Do you have it so that Guest users receive a separate announcement and that is empty?
I don't have guests. You're either IN or you're not IN, simple as that. AHAHAHAHAHA!! Seriously... I don't but it reads 'Hello Guest' in that field for now.
WebMistress of SHAGGY's Studio.com
http://www.shaggysstudio.com

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Site Announcement Centre

Post by lefty74 » Sun Mar 02, 2008 9:25 pm

ok, i am confused now ;) . could you pm post or me a link?
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

User avatar
2LadyDi
Registered User
Posts: 258
Joined: Fri Mar 15, 2002 6:01 am
Location: MD, USA
Contact:

Re: ACP Site Announcement Centre

Post by 2LadyDi » Thu Mar 06, 2008 9:48 am

Oh, I'm sorry Lefty. I never saw this post but check your PM in a second.
WebMistress of SHAGGY's Studio.com
http://www.shaggysstudio.com

o0kam1
Registered User
Posts: 2
Joined: Sun Mar 23, 2008 2:28 am

Re: ACP Site Announcement Centre

Post by o0kam1 » Sun Mar 23, 2008 3:39 am

Ok I am having a problem, I have checked everything three times now and have done everything three times to make sure I did not miss anything, but I am getting an error with this code:

Code: Select all

	//BEGIN ACP Site Announcement Centre by lefty74
 	'L_ANNOUNCEMENT_TITLE' => $announcement_title,
    'SITE_ANNOUNCEMENTS_LEFTY74' => $announcement_text, 
  	'L_ANNOUNCEMENT_GUEST_TITLE' => $announcement_guest_title,
   'GUEST_ANNOUNCEMENTS_LEFTY74' => $announcement_guest_text, 
	//END ACP Site Announcement Centre by lefty74
the error I am getting is this:
Parse error: syntax error, unexpected T_DOUBLE_ARROW in /homepages/29/d223817601/htdocs/forum/index.php on line 61

I have googled and googled and googled and googled, and I can not find out why I am getting this error and I also have read every single post on here and I can not find out why. This is with my index.php file here is a copy of the file if yall need it:

Code: Select all

<?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.7 2006/01/28 11:13:39 acydburn 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);
include($phpbb_root_path . 'includes/bbcode.'.$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") . '">')
	);
		//BEGIN ACP Site Announcement Centre by lefty74
 	'L_ANNOUNCEMENT_TITLE' => $announcement_title,
    'SITE_ANNOUNCEMENTS_LEFTY74' => $announcement_text,
  	'L_ANNOUNCEMENT_GUEST_TITLE' => $announcement_guest_title,
   'GUEST_ANNOUNCEMENTS_LEFTY74' => $announcement_guest_text,
	//END ACP Site Announcement Centre by lefty74
	

	$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'];
}

//BEGIN ACP Site Announcement Centre by lefty74
// 
// ACP Site Announcement Centre Smilies Pass & BBCode
// 
$announcement_centre_config['announcement_text']	= smilies_pass($announcement_centre_config['announcement_text']);
$announcement_text_uid     							= make_bbcode_uid();
$announcement_centre_config['announcement_text']	= bbencode_first_pass( $announcement_centre_config['announcement_text'], $announcement_text_uid );
$announcement_centre_config['announcement_text']	= bbencode_second_pass ( $announcement_centre_config['announcement_text'], $announcement_text_uid );
$announcement_centre_config['announcement_text']	= str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_text']);

$announcement_centre_config['announcement_guest_text']	= smilies_pass($announcement_centre_config['announcement_guest_text']);
$announcement_guest_text_uid     						= make_bbcode_uid();
$announcement_centre_config['announcement_guest_text']	= bbencode_first_pass( $announcement_centre_config['announcement_guest_text'], $announcement_guest_text_uid );
$announcement_centre_config['announcement_guest_text']	= bbencode_second_pass ( $announcement_centre_config['announcement_guest_text'], $announcement_guest_text_uid );
$announcement_centre_config['announcement_guest_text']	= str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_guest_text']);

$announcement_guest_text = $announcement_centre_config['announcement_guest_text'];

$announcement_title			= empty($announcement_centre_config['announcement_title']) ? $lang['Site_announcement_block_title'] : str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_title']);
$announcement_guest_title	= empty($announcement_centre_config['announcement_guest_title']) ? $lang['Guest_announcement_block_title'] : str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_guest_title']);

// get the post information in case last topic or forum has been entered
 if ( !$announcement_centre_config['announcement_forum_id'] == '' ||  !$announcement_centre_config['announcement_topic_id'] == '')
{
	 if ( !$announcement_centre_config['announcement_forum_id'] == '')
	 {
	 $where = 'p.forum_id = ' . $announcement_centre_config['announcement_forum_id'];
	 }
	 elseif ( !$announcement_centre_config['announcement_topic_id'] == '')
	 {
	 $where = ('p.topic_id = ' . $announcement_centre_config['announcement_topic_id']);
	 }
	 
	 if ( $announcement_centre_config['announcement_forum_topic_first_latest'] == ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_FIRST )
	 {
	 $order = 'ASC';
	 }
	 elseif ( $announcement_centre_config['announcement_forum_topic_first_latest'] == ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_LATEST )
	 {
	 $order = 'DESC';
	 }
	 					
				$sql = "SELECT p.post_id, p.forum_id, p.topic_id, pt.*
				FROM " . POSTS_TABLE . ' as p, ' . POSTS_TEXT_TABLE . " as pt
				WHERE ". $where ."
				AND p.post_id = pt.post_id 
				ORDER BY p.post_id ". $order ." LIMIT 1";
				
			if (!($result = $db->sql_query($sql)))
			{
				message_die(GENERAL_ERROR, 'Error in getting announcement post', '', __LINE__, __FILE__, $sql);
			}

			if ($row = $db->sql_fetchrow($result))
			{
				
				$row['post_text']	= smilies_pass($row['post_text']);
				$row['post_text']	= bbencode_first_pass( $row['post_text'], $row['bbcode_uid'] );
				$row['post_text']	= bbencode_second_pass ( $row['post_text'], $row['bbcode_uid'] );
				$row['post_text']	= str_replace("\n", "\n<br />\n", $row['post_text']);
				$announcement_text = $row['post_text'];
			}
}
else
{
$announcement_text = $announcement_centre_config['announcement_text'];
}	

// who sees the announcements
if ( $announcement_centre_config['announcement_status'] == ANNOUNCEMENTS_LEFTY74_SHOW_YES )
{
if( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ADM && $userdata['user_level'] == ADMIN )
{
	$template->assign_block_vars('announcement_displayed', array());
}
else if ( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_MOD && ( $userdata['user_level'] == MOD || $userdata['user_level'] == ADMIN ) )
{
	$template->assign_block_vars('announcement_displayed', array());
}
else if ( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_REG && $userdata['session_logged_in'] )
{
	$template->assign_block_vars('announcement_displayed', array());
}
else if ( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ALL )
{
	$template->assign_block_vars('announcement_displayed', array());
}
else if (  $announcement_centre_config['announcement_guest_status'] == ANNOUNCEMENTS_LEFTY74_GUEST_YES && !$userdata['session_logged_in'] && !$announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ALL )
{
	$template->assign_block_vars('guest_announcement_displayed', array());
}
} 
else 
{
$template->assign_block_vars('announcement_not_displayed', array());
} 
		
//END ACP Site Announcement Centre by lefty74


//
// 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);
}

$category_rows = array();
while ($row = $db->sql_fetchrow($result))
{
	$category_rows[] = $row;
}
$db->sql_freeresult($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;
	}
	$db->sql_freeresult($result);

	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'])
	{
		// 60 days limit
		if ($userdata['user_lastvisit'] < (time() - 5184000))
		{
			$userdata['user_lastvisit'] = 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['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'];
		}
		$db->sql_freeresult($result);
	}

	//
	// 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>';
	}
	$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[$row['forum_id']][] = '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=" . $row['group_id']) . '">' . $row['group_name'] . '</a>';
	}
	$db->sql_freeresult($result);

	//
	// Find which forums are visible for this user
	//
	$is_auth_ary = array();
	$is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);

	//
	// 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_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"))
	);

	//
	// Let's decide which categories we should display
	//
	$display_categories = array();

	for ($i = 0; $i < $total_forums; $i++ )
	{
		if ($is_auth_ary[$forum_data[$i]['forum_id']]['auth_view'])
		{
			$display_categories[$forum_data[$i]['cat_id']] = true;
		}
	}

	//
	// Okay, let's build the index
	//
	for($i = 0; $i < $total_categories; $i++)
	{
		$cat_id = $category_rows[$i]['cat_id'];

		//
		// Yes, we should, so first dump out the category
		// title, then, if appropriate the forum list
		//
		if (isset($display_categories[$cat_id]) && $display_categories[$cat_id])
		{
			$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 = '&nbsp;';
								$moderator_list = '&nbsp;';
							}

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

?>
can yall please help me? I have been going at if for over 2 hours now..

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Site Announcement Centre

Post by lefty74 » Sun Mar 23, 2008 11:15 am

Hi, wenn you follow installation instructions never go back to the first line after an edit. the instructions are written so that once you have made an edit and supposed to look for a code bit, that you need to look from the point where you made your last edit. if you went back to line 1 it could be that that line of code is available further up as well but the same line of code you actually need to find is further down. (hope that makes sense)

anyway, try this for your index

Code: Select all

<?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.7 2006/01/28 11:13:39 acydburn 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);
include($phpbb_root_path . 'includes/bbcode.'.$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'];
}

//BEGIN ACP Site Announcement Centre by lefty74
//
// ACP Site Announcement Centre Smilies Pass & BBCode
//
$announcement_centre_config['announcement_text']   = smilies_pass($announcement_centre_config['announcement_text']);
$announcement_text_uid                          = make_bbcode_uid();
$announcement_centre_config['announcement_text']   = bbencode_first_pass( $announcement_centre_config['announcement_text'], $announcement_text_uid );
$announcement_centre_config['announcement_text']   = bbencode_second_pass ( $announcement_centre_config['announcement_text'], $announcement_text_uid );
$announcement_centre_config['announcement_text']   = str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_text']);

$announcement_centre_config['announcement_guest_text']   = smilies_pass($announcement_centre_config['announcement_guest_text']);
$announcement_guest_text_uid                       = make_bbcode_uid();
$announcement_centre_config['announcement_guest_text']   = bbencode_first_pass( $announcement_centre_config['announcement_guest_text'], $announcement_guest_text_uid );
$announcement_centre_config['announcement_guest_text']   = bbencode_second_pass ( $announcement_centre_config['announcement_guest_text'], $announcement_guest_text_uid );
$announcement_centre_config['announcement_guest_text']   = str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_guest_text']);

$announcement_guest_text = $announcement_centre_config['announcement_guest_text'];

$announcement_title         = empty($announcement_centre_config['announcement_title']) ? $lang['Site_announcement_block_title'] : str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_title']);
$announcement_guest_title   = empty($announcement_centre_config['announcement_guest_title']) ? $lang['Guest_announcement_block_title'] : str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_guest_title']);

// get the post information in case last topic or forum has been entered
if ( !$announcement_centre_config['announcement_forum_id'] == '' ||  !$announcement_centre_config['announcement_topic_id'] == '')
{
	if ( !$announcement_centre_config['announcement_forum_id'] == '')
	{
	$where = 'p.forum_id = ' . $announcement_centre_config['announcement_forum_id'];
	}
	elseif ( !$announcement_centre_config['announcement_topic_id'] == '')
	{
	$where = ('p.topic_id = ' . $announcement_centre_config['announcement_topic_id']);
	}
   
	if ( $announcement_centre_config['announcement_forum_topic_first_latest'] == ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_FIRST )
	{
	$order = 'ASC';
	}
	elseif ( $announcement_centre_config['announcement_forum_topic_first_latest'] == ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_LATEST )
	{
	$order = 'DESC';
	}
				   
			$sql = "SELECT p.post_id, p.forum_id, p.topic_id, pt.*
			FROM " . POSTS_TABLE . ' as p, ' . POSTS_TEXT_TABLE . " as pt
			WHERE ". $where ."
			AND p.post_id = pt.post_id
			ORDER BY p.post_id ". $order ." LIMIT 1";
			
		 if (!($result = $db->sql_query($sql)))
		 {
			message_die(GENERAL_ERROR, 'Error in getting announcement post', '', __LINE__, __FILE__, $sql);
		 }

		 if ($row = $db->sql_fetchrow($result))
		 {
			
			$row['post_text']   = smilies_pass($row['post_text']);
			$row['post_text']   = bbencode_first_pass( $row['post_text'], $row['bbcode_uid'] );
			$row['post_text']   = bbencode_second_pass ( $row['post_text'], $row['bbcode_uid'] );
			$row['post_text']   = str_replace("\n", "\n<br />\n", $row['post_text']);
			$announcement_text = $row['post_text'];
		 }
}
else
{
$announcement_text = $announcement_centre_config['announcement_text'];
}   

// who sees the announcements
if ( $announcement_centre_config['announcement_status'] == ANNOUNCEMENTS_LEFTY74_SHOW_YES )
{
if( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ADM && $userdata['user_level'] == ADMIN )
{
   $template->assign_block_vars('announcement_displayed', array());
}
else if ( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_MOD && ( $userdata['user_level'] == MOD || $userdata['user_level'] == ADMIN ) )
{
   $template->assign_block_vars('announcement_displayed', array());
}
else if ( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_REG && $userdata['session_logged_in'] )
{
   $template->assign_block_vars('announcement_displayed', array());
}
else if ( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ALL )
{
   $template->assign_block_vars('announcement_displayed', array());
}
else if (  $announcement_centre_config['announcement_guest_status'] == ANNOUNCEMENTS_LEFTY74_GUEST_YES && !$userdata['session_logged_in'] && !$announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ALL )
{
   $template->assign_block_vars('guest_announcement_displayed', array());
}
}
else
{
$template->assign_block_vars('announcement_not_displayed', array());
}
	  
//END ACP Site Announcement Centre by lefty74


//
// 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);
}

$category_rows = array();
while ($row = $db->sql_fetchrow($result))
{
   $category_rows[] = $row;
}
$db->sql_freeresult($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;
   }
   $db->sql_freeresult($result);

   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'])
   {
	  // 60 days limit
	  if ($userdata['user_lastvisit'] < (time() - 5184000))
	  {
		 $userdata['user_lastvisit'] = 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['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'];
	  }
	  $db->sql_freeresult($result);
   }

   //
   // 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>';
   }
   $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[$row['forum_id']][] = '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=" . $row['group_id']) . '">' . $row['group_name'] . '</a>';
   }
   $db->sql_freeresult($result);

   //
   // Find which forums are visible for this user
   //
   $is_auth_ary = array();
   $is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);

   //
   // 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'],

	  //BEGIN ACP Site Announcement Centre by lefty74
	   'L_ANNOUNCEMENT_TITLE' => $announcement_title,
		'SITE_ANNOUNCEMENTS_LEFTY74' => $announcement_text,
		 'L_ANNOUNCEMENT_GUEST_TITLE' => $announcement_guest_title,
	   'GUEST_ANNOUNCEMENTS_LEFTY74' => $announcement_guest_text,
	   //END ACP Site Announcement Centre by lefty74
	  '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_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"))
   );

   //
   // Let's decide which categories we should display
   //
   $display_categories = array();

   for ($i = 0; $i < $total_forums; $i++ )
   {
	  if ($is_auth_ary[$forum_data[$i]['forum_id']]['auth_view'])
	  {
		 $display_categories[$forum_data[$i]['cat_id']] = true;
	  }
   }

   //
   // Okay, let's build the index
   //
   for($i = 0; $i < $total_categories; $i++)
   {
	  $cat_id = $category_rows[$i]['cat_id'];

	  //
	  // Yes, we should, so first dump out the category
	  // title, then, if appropriate the forum list
	  //
	  if (isset($display_categories[$cat_id]) && $display_categories[$cat_id])
	  {
		 $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 = '&nbsp;';
						$moderator_list = '&nbsp;';
					 }

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

?>
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

o0kam1
Registered User
Posts: 2
Joined: Sun Mar 23, 2008 2:28 am

Re: ACP Site Announcement Centre

Post by o0kam1 » Sun Mar 23, 2008 1:54 pm

Thank you. I put it in the right spot the first time but I dont know why it did not work that when i seen it in here put at line 60 and it worked for him thats why I tryed it. But thank you so much it finaly works. After about 3 hours of working not it lol. Its a great mod.

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Site Announcement Centre

Post by lefty74 » Sun Mar 23, 2008 9:13 pm

glad to hear you got it working :)
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

sapcanin
Registered User
Posts: 62
Joined: Tue Feb 27, 2007 8:13 pm

Re: ACP Site Announcement Centre

Post by sapcanin » Thu Apr 03, 2008 1:11 pm

Have this mod for phpbb 3.0 ?

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Site Announcement Centre

Post by lefty74 » Thu Apr 03, 2008 1:24 pm

yes, it is here
http://www.phpbb.com/community/viewtopi ... 0&t=566557

was it you that sent me a pm on my testboard?
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

sapcanin
Registered User
Posts: 62
Joined: Tue Feb 27, 2007 8:13 pm

Re: ACP Site Announcement Centre

Post by sapcanin » Sat Apr 05, 2008 1:02 am

yes I am, I don`t know for a main forum, I was gone direclty from one site on your test forum,that is reason because I contact you with PM on test board...

Thanks, I`ve found on your forum this mod.

Works great, only guests announcement don`t work at my forum, if announcement for useres is set to off ...

Tip: When I be you, I will add to this mod "Announcement Expire Day", that will allow administrators to set day when Showing of site announcement will be automaticly set to off.

Anyway best regards...

Nice work...

scuba8085
Registered User
Posts: 10
Joined: Fri Nov 23, 2007 6:16 am

Re: ACP Site Announcement Centre

Post by scuba8085 » Tue Apr 15, 2008 8:18 am

Hi,

I tried to install the Announcement mod...
I have the following error...
Error in getting announcement post

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p.post_id = pt.post_id ORDER BY p.post_id ASC LIMIT 1' at line 4

SELECT p.post_id, p.forum_id, p.topic_id, pt.* FROM phpbb_posts as p, phpbb_posts_text as pt WHERE p.forum_id = AND p.post_id = pt.post_id ORDER BY p.post_id ASC LIMIT 1

Line : 160
File : index.php
I realized that after inserting the following code...
The error message starts to pop up...

Code: Select all

#-----[ OPEN ]------------------------------------------
#
index.php
#
#-----[ FIND ]------------------------------------------
#
include($phpbb_root_path . 'common.'.$phpEx);

#
#-----[ AFTER, ADD ]------------------------------------------
#
include($phpbb_root_path . 'includes/bbcode.'.$phpEx);

#
#-----[ FIND ]------------------------------------------
#
// 
// 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); 
}

#
#-----[ BEFORE, ADD ]------------------------------------------
#
//BEGIN ACP Site Announcement Centre by lefty74
// 
// ACP Site Announcement Centre Smilies Pass & BBCode
// 
$announcement_centre_config['announcement_text']	= smilies_pass($announcement_centre_config['announcement_text']);
$announcement_text_uid     							= make_bbcode_uid();
$announcement_centre_config['announcement_text']	= bbencode_first_pass( $announcement_centre_config['announcement_text'], $announcement_text_uid );
$announcement_centre_config['announcement_text']	= bbencode_second_pass ( $announcement_centre_config['announcement_text'], $announcement_text_uid );
$announcement_centre_config['announcement_text']	= str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_text']);

$announcement_centre_config['announcement_guest_text']	= smilies_pass($announcement_centre_config['announcement_guest_text']);
$announcement_guest_text_uid     						= make_bbcode_uid();
$announcement_centre_config['announcement_guest_text']	= bbencode_first_pass( $announcement_centre_config['announcement_guest_text'], $announcement_guest_text_uid );
$announcement_centre_config['announcement_guest_text']	= bbencode_second_pass ( $announcement_centre_config['announcement_guest_text'], $announcement_guest_text_uid );
$announcement_centre_config['announcement_guest_text']	= str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_guest_text']);

$announcement_guest_text = $announcement_centre_config['announcement_guest_text'];

$announcement_title			= empty($announcement_centre_config['announcement_title']) ? $lang['Site_announcement_block_title'] : str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_title']);
$announcement_guest_title	= empty($announcement_centre_config['announcement_guest_title']) ? $lang['Guest_announcement_block_title'] : str_replace("\n", "\n<br />\n", $announcement_centre_config['announcement_guest_title']);

// get the post information in case last topic or forum has been entered
 if ( !$announcement_centre_config['announcement_forum_id'] == '' ||  !$announcement_centre_config['announcement_topic_id'] == '')
{
	 if ( !$announcement_centre_config['announcement_forum_id'] == '')
	 {
	 $where = 'p.forum_id = ' . $announcement_centre_config['announcement_forum_id'];
	 }
	 elseif ( !$announcement_centre_config['announcement_topic_id'] == '')
	 {
	 $where = ('p.topic_id = ' . $announcement_centre_config['announcement_topic_id']);
	 }
	 
	 if ( $announcement_centre_config['announcement_forum_topic_first_latest'] == ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_FIRST )
	 {
	 $order = 'ASC';
	 }
	 elseif ( $announcement_centre_config['announcement_forum_topic_first_latest'] == ANNOUNCEMENTS_LEFTY74_FORUM_TOPIC_LATEST )
	 {
	 $order = 'DESC';
	 }
	 					
				$sql = "SELECT p.post_id, p.forum_id, p.topic_id, pt.*
				FROM " . POSTS_TABLE . ' as p, ' . POSTS_TEXT_TABLE . " as pt
				WHERE ". $where ."
				AND p.post_id = pt.post_id 
				ORDER BY p.post_id ". $order ." LIMIT 1";
				
			if (!($result = $db->sql_query($sql)))
			{
				message_die(GENERAL_ERROR, 'Error in getting announcement post', '', __LINE__, __FILE__, $sql);
			}

			if ($row = $db->sql_fetchrow($result))
			{
				
				$row['post_text']	= smilies_pass($row['post_text']);
				$row['post_text']	= bbencode_first_pass( $row['post_text'], $row['bbcode_uid'] );
				$row['post_text']	= bbencode_second_pass ( $row['post_text'], $row['bbcode_uid'] );
				$row['post_text']	= str_replace("\n", "\n<br />\n", $row['post_text']);
				$announcement_text = $row['post_text'];
			}
}
else
{
$announcement_text = $announcement_centre_config['announcement_text'];
}	

// who sees the announcements
if ( $announcement_centre_config['announcement_status'] == ANNOUNCEMENTS_LEFTY74_SHOW_YES )
{
if( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ADM && $userdata['user_level'] == ADMIN )
{
	$template->assign_block_vars('announcement_displayed', array());
}
else if ( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_MOD && ( $userdata['user_level'] == MOD || $userdata['user_level'] == ADMIN ) )
{
	$template->assign_block_vars('announcement_displayed', array());
}
else if ( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_REG && $userdata['session_logged_in'] )
{
	$template->assign_block_vars('announcement_displayed', array());
}
else if ( $announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ALL )
{
	$template->assign_block_vars('announcement_displayed', array());
}
else if (  $announcement_centre_config['announcement_guest_status'] == ANNOUNCEMENTS_LEFTY74_GUEST_YES && !$userdata['session_logged_in'] && !$announcement_centre_config['announcement_access'] == ANNOUNCEMENTS_LEFTY74_SHOW_ALL )
{
	$template->assign_block_vars('guest_announcement_displayed', array());
}
} 
else 
{
$template->assign_block_vars('announcement_not_displayed', array());
} 
		
//END ACP Site Announcement Centre by lefty74
Any idea?

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Site Announcement Centre

Post by lefty74 » Tue Apr 15, 2008 11:13 am

not out of the top of my head, sorry to ask the obvious but you doubleckecked your edits ... and the SQL entries are there as well?
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

Post Reply

Return to “[2.0.x] MOD Database Releases”

Who is online

Users browsing this forum: No registered users and 11 guests