Please Help.

Oreo Killa 225 · May 24, 2008

General Error
SQL ERROR [ mysql4 ]

Unknown column 'b.group_bypass_post_req' in 'field list' [1054]

SQL

SELECT b.group_bypass_post_req AS requirement FROM phpbb_user_group a, phpbb_groups b WHERE user_id = 2 AND a.group_id = b.group_id

BACKTRACE

FILE: includes/db/mysql.php

LINE: 158

CALL: dbal->sql_error()

FILE: viewforum.php

LINE: 76

CALL: dbal_mysql->sql_query()

<?php
/**
*
* @package dbal
* @version $Id: mysql.php,v 1.62 2007/10/05 14:36:32 acydburn Exp $
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
exit;
}

include_once($phpbb_root_path . 'includes/db/dbal.' . $phpEx);

/**
* MySQL4 Database Abstraction Layer
* Compatible with:
* MySQL 3.23+
* MySQL 4.0+
* MySQL 4.1+
* MySQL 5.0+
* @package dbal
*/
class dbal_mysql extends dbal
{
var $mysql_version;
var $multi_insert = true;

/**
* Connect to server
* @access public
*/
function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false)
{
	$this->persistency = $persistency;
	$this->user = $sqluser;
	$this->server = $sqlserver . (($port) ? ':' . $port : '');
	$this->dbname = $database;

	$this->sql_layer = 'mysql4';

	$this->db_connect_id = ($this->persistency) ? @mysql_pconnect($this->server, $this->user, $sqlpassword, $new_link) : @mysql_connect($this->server, $this->user, $sqlpassword, $new_link);

	if ($this->db_connect_id && $this->dbname != '')
	{
		if (@mysql_select_db($this->dbname, $this->db_connect_id))
		{
			// Determine what version we are using and if it natively supports UNICODE
			$this->mysql_version = mysql_get_server_info($this->db_connect_id);

			if (version_compare($this->mysql_version, '4.1.3', '>='))
			{
				@mysql_query("SET NAMES 'utf8'", $this->db_connect_id);
				// enforce strict mode on databases that support it
				if (version_compare($this->mysql_version, '5.0.2', '>='))
				{
					$result = @mysql_query('SELECT @@session.sql_mode AS sql_mode', $this->db_connect_id);
					$row = @mysql_fetch_assoc($result);
					@mysql_free_result($result);
					$modes = array_map('trim', explode(',', $row['sql_mode']));

					// TRADITIONAL includes STRICT_ALL_TABLES and STRICT_TRANS_TABLES
					if (!in_array('TRADITIONAL', $modes))
					{
						if (!in_array('STRICT_ALL_TABLES', $modes))
						{
							$modes[] = 'STRICT_ALL_TABLES';
						}

						if (!in_array('STRICT_TRANS_TABLES', $modes))
						{
							$modes[] = 'STRICT_TRANS_TABLES';
						}
					}

					$mode = implode(',', $modes);
					@mysql_query("SET SESSION sql_mode='{$mode}'", $this->db_connect_id);
				}
			}
			else if (version_compare($this->mysql_version, '4.0.0', '<'))
			{
				$this->sql_layer = 'mysql';
			}

			return $this->db_connect_id;
		}
	}

	return $this->sql_error('');
}

/**
* Version information about used database
*/
function sql_server_info()
{
	return 'MySQL ' . $this->mysql_version;
}

/**
* SQL Transaction
* @access private
*/
function _sql_transaction($status = 'begin')
{
	switch ($status)
	{
		case 'begin':
			return @mysql_query('BEGIN', $this->db_connect_id);
		break;

		case 'commit':
			return @mysql_query('COMMIT', $this->db_connect_id);
		break;

		case 'rollback':
			return @mysql_query('ROLLBACK', $this->db_connect_id);
		break;
	}

	return true;
}

/**
* Base query method
*
* @param	string	$query		Contains the SQL query which shall be executed
* @param	int		$cache_ttl	Either 0 to avoid caching or the time in seconds which the result shall be kept in cache
* @return	mixed				When casted to bool the returned value returns true on success and false on failure
*
* @access	public
*/
function sql_query($query = '', $cache_ttl = 0)
{
	if ($query != '')
	{
		global $cache;

		// EXPLAIN only in extra debug mode
		if (defined('DEBUG_EXTRA'))
		{
			$this->sql_report('start', $query);
		}

		$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;
		$this->sql_add_num_queries($this->query_result);

		if ($this->query_result === false)
		{
			if (($this->query_result = @mysql_query($query, $this->db_connect_id)) === false)
			{
				$this->sql_error($query);
			}

			if (defined('DEBUG_EXTRA'))
			{
				$this->sql_report('stop', $query);
			}

			if ($cache_ttl && method_exists($cache, 'sql_save'))
			{
				$this->open_queries[(int) $this->query_result] = $this->query_result;
				$cache->sql_save($query, $this->query_result, $cache_ttl);
			}
			else if (strpos($query, 'SELECT') === 0 && $this->query_result)
			{
				$this->open_queries[(int) $this->query_result] = $this->query_result;
			}
		}
		else if (defined('DEBUG_EXTRA'))
		{
			$this->sql_report('fromcache', $query);
		}
	}
	else
	{
		return false;
	}

	return ($this->query_result) ? $this->query_result : false;
}

/**
* Build LIMIT query
*/
function _sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)
{
	$this->query_result = false;

	// if $total is set to 0 we do not want to limit the number of rows
	if ($total == 0)
	{
		// Having a value of -1 was always a bug
		$total = '18446744073709551615';
	}

	$query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total);

	return $this->sql_query($query, $cache_ttl);
}

/**
* Return number of affected rows
*/
function sql_affectedrows()
{
	return ($this->db_connect_id) ? @mysql_affected_rows($this->db_connect_id) : false;
}

/**
* Fetch current row
*/
function sql_fetchrow($query_id = false)
{
	global $cache;

	if ($query_id === false)
	{
		$query_id = $this->query_result;
	}

	if (isset($cache->sql_rowset[$query_id]))
	{
		return $cache->sql_fetchrow($query_id);
	}

	return ($query_id !== false) ? @mysql_fetch_assoc($query_id) : false;
}

/**
* Seek to given row number
* rownum is zero-based
*/
function sql_rowseek($rownum, &$query_id)
{
	global $cache;

	if ($query_id === false)
	{
		$query_id = $this->query_result;
	}

	if (isset($cache->sql_rowset[$query_id]))
	{
		return $cache->sql_rowseek($rownum, $query_id);
	}

	return ($query_id !== false) ? @mysql_data_seek($query_id, $rownum) : false;
}

/**
* Get last inserted id after insert statement
*/
function sql_nextid()
{
	return ($this->db_connect_id) ? @mysql_insert_id($this->db_connect_id) : false;
}

/**
* Free sql result
*/
function sql_freeresult($query_id = false)
{
	global $cache;

	if ($query_id === false)
	{
		$query_id = $this->query_result;
	}

	if (isset($cache->sql_rowset[$query_id]))
	{
		return $cache->sql_freeresult($query_id);
	}

	if (isset($this->open_queries[(int) $query_id]))
	{
		unset($this->open_queries[(int) $query_id]);
		return @mysql_free_result($query_id);
	}

	return false;
}

/**
* Escape string used in sql query
*/
function sql_escape($msg)
{
	if (!$this->db_connect_id)
	{
		return @mysql_real_escape_string($msg);
	}

	return @mysql_real_escape_string($msg, $this->db_connect_id);
}

/**
* Build LIKE expression
* @access private
*/
function _sql_like_expression($expression)
{
	return $expression;
}

/**
* Build db-specific query data
* @access private
*/
function _sql_custom_build($stage, $data)
{
	switch ($stage)
	{
		case 'FROM':
			$data = '(' . $data . ')';
		break;
	}

	return $data;
}

/**
* return sql error array
* @access private
*/
function _sql_error()
{
	if (!$this->db_connect_id)
	{
		return array(
			'message'	=> @mysql_error(),
			'code'		=> @mysql_errno()
		);
	}

	return array(
		'message'	=> @mysql_error($this->db_connect_id),
		'code'		=> @mysql_errno($this->db_connect_id)
	);
}

/**
* Close sql connection
* @access private
*/
function _sql_close()
{
	return @mysql_close($this->db_connect_id);
}

/**
* Build db-specific report
* @access private
*/
function _sql_report($mode, $query = '')
{
	static $test_prof;

	// current detection method, might just switch to see the existance of INFORMATION_SCHEMA.PROFILING
	if ($test_prof === null)
	{
		$test_prof = false;
		if (strpos($this->mysql_version, 'community') !== false)
		{
			$ver = substr($this->mysql_version, 0, strpos($this->mysql_version, '-'));
			if (version_compare($ver, '5.0.37', '>=') && version_compare($ver, '5.1', '<'))
			{
				$test_prof = true;
			}
		}
	}

	switch ($mode)
	{
		case 'start':

			$explain_query = $query;
			if (preg_match('/UPDATE ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m))
			{
				$explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];
			}
			else if (preg_match('/DELETE FROM ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m))
			{
				$explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];
			}

			if (preg_match('/^SELECT/', $explain_query))
			{
				$html_table = false;

				// begin profiling
				if ($test_prof)
				{
					@mysql_query('SET profiling = 1;', $this->db_connect_id);
				}

				if ($result = @mysql_query("EXPLAIN $explain_query", $this->db_connect_id))
				{
					while ($row = @mysql_fetch_assoc($result))
					{
						$html_table = $this->sql_report('add_select_row', $query, $html_table, $row);
					}
				}
				@mysql_free_result($result);

				if ($html_table)
				{
					$this->html_hold .= '</table>';
				}

				if ($test_prof)
				{
					$html_table = false;

					// get the last profile
					if ($result = @mysql_query('SHOW PROFILE ALL;', $this->db_connect_id))
					{
						$this->html_hold .= '<br />';
						while ($row = @mysql_fetch_assoc($result))
						{
							// make <unknown> HTML safe
							if (!empty($row['Source_function']))
							{
								$row['Source_function'] = str_replace(array('<', '>'), array('<', '>'), $row['Source_function']);
							}

							// remove unsupported features
							foreach ($row as $key => $val)
							{
								if ($val === null)
								{
									unset($row[$key]);
								}
							}
							$html_table = $this->sql_report('add_select_row', $query, $html_table, $row);
						}
					}
					@mysql_free_result($result);

					if ($html_table)
					{
						$this->html_hold .= '</table>';
					}

					@mysql_query('SET profiling = 0;', $this->db_connect_id);
				}
			}

		break;

		case 'fromcache':
			$endtime = explode(' ', microtime());
			$endtime = $endtime[0] + $endtime[1];

			$result = @mysql_query($query, $this->db_connect_id);
			while ($void = @mysql_fetch_assoc($result))
			{
				// Take the time spent on parsing rows into account
			}
			@mysql_free_result($result);

			$splittime = explode(' ', microtime());
			$splittime = $splittime[0] + $splittime[1];

			$this->sql_report('record_fromcache', $query, $endtime, $splittime);

		break;

                              }

                }

	}

?>

Oreo Killa 225 · May 24, 2008

<?php
/**
*
* @package phpBB3
* @version $Id: viewforum.php,v 1.342 2007/11/17 20:03:32 acydburn Exp $
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

// Start session
$user->session_begin();
$auth->acl($user->data);

// Start initial var setup
$forum_id	= request_var('f', 0);
$mark_read	= request_var('mark', '');
$start		= request_var('start', 0);

$sort_days	= request_var('st', ((!empty($user->data['user_topic_show_days'])) ? $user->data['user_topic_show_days'] : 0));
$sort_key	= request_var('sk', ((!empty($user->data['user_topic_sortby_type'])) ? $user->data['user_topic_sortby_type'] : 't'));
$sort_dir	= request_var('sd', ((!empty($user->data['user_topic_sortby_dir'])) ? $user->data['user_topic_sortby_dir'] : 'd'));

// Check if the user has actually sent a forum ID with his/her request
// If not give them a nice error page.
if (!$forum_id)
{
trigger_error('NO_FORUM');
}

$sql_from = FORUMS_TABLE . ' f';
$lastread_select = '';

// Grab appropriate forum data
if ($config['load_db_lastread'] && $user->data['is_registered'])
{
$sql_from .= ' LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.user_id = ' . $user->data['user_id'] . '
	AND ft.forum_id = f.forum_id)';
$lastread_select .= ', ft.mark_time';
}

if ($user->data['is_registered'])
{
$sql_from .= ' LEFT JOIN ' . FORUMS_WATCH_TABLE . ' fw ON (fw.forum_id = f.forum_id AND fw.user_id = ' . $user->data['user_id'] . ')';
$lastread_select .= ', fw.notify_status';
}

$sql = "SELECT f.* $lastread_select
FROM $sql_from
WHERE f.forum_id = $forum_id";
$result = $db->sql_query($sql);
$forum_data = $db->sql_fetchrow($result);
$db->sql_freeresult($result);

if (!$forum_data)
{
trigger_error('NO_FORUM');
}


// Configure style, language, etc.
$user->setup('viewforum', $forum_data['forum_style']);

// Check if user is allowed to bypass the requirements
$postcount_bypass = FALSE;
$sql = "SELECT b.group_bypass_post_req AS requirement FROM " . USER_GROUP_TABLE . " a, " . GROUPS_TABLE . " b WHERE user_id = " . $user->data['user_id'] . " AND a.group_id = b.group_id";
$result = $db->sql_query($sql);
while ($membership = $db->sql_fetchrow($result))
{
if ($membership['requirement'] == 1)
{
	$postcount_bypass = TRUE;
	break;
}
}
$db->sql_freeresult($result);

// Check if the user has the required post count to view the forum
if (check_post_count_requirement($forum_id,'view') == FALSE && $postcount_bypass == FALSE)
{
$user->setup('common');
$post1 = ($forum_data['forum_postcount_view'] == 1) ? $user->lang['POSTREQ_POST'] : $user->lang['POSTREQ_POSTS'];
$remaining = ($forum_data['forum_postcount_view'] - $user->data['user_posts']);
$post2 = ($remaining == 1) ? $user->lang['POSTREQ_POST'] : $user->lang['POSTREQ_POSTS'];
$accesserror = sprintf($user->lang['POSTREQ_NOACCESS_VIEW'], $forum_data['forum_postcount_view'], $post1);
if ($user->data['user_id'] != ANONYMOUS)
{
	$neededposts = "<br /><br />" . sprintf($user->lang['POSTREQ_NOACCESS_MORE'], $remaining, $post2);
}
trigger_error($accesserror . $neededposts);
}

// Redirect to login upon emailed notification links
if (isset($_GET['e']) && !$user->data['is_registered'])
{
login_box('', $user->lang['LOGIN_NOTIFY_FORUM']);
}

// Permissions check
if (!$auth->acl_gets('f_list', 'f_read', $forum_id) || ($forum_data['forum_type'] == FORUM_LINK && $forum_data['forum_link'] && !$auth->acl_get('f_read', $forum_id)))
{
if ($user->data['user_id'] != ANONYMOUS)
{
	trigger_error('SORRY_AUTH_READ');
}

login_box('', $user->lang['LOGIN_VIEWFORUM']);
}

// Forum is passworded ... check whether access has been granted to this
// user this session, if not show login box
if ($forum_data['forum_password'])
{
login_forum_box($forum_data);
}

// Is this forum a link? ... User got here either because the
// number of clicks is being tracked or they guessed the id
if ($forum_data['forum_type'] == FORUM_LINK && $forum_data['forum_link'])
{
// Does it have click tracking enabled?
if ($forum_data['forum_flags'] & FORUM_FLAG_LINK_TRACK)
{
	$sql = 'UPDATE ' . FORUMS_TABLE . '
		SET forum_posts = forum_posts + 1
		WHERE forum_id = ' . $forum_id;
	$db->sql_query($sql);
}

redirect($forum_data['forum_link']);
}

// Build navigation links
generate_forum_nav($forum_data);

// Forum Rules
if ($auth->acl_get('f_read', $forum_id))
{
generate_forum_rules($forum_data);
}

// Do we have subforums?
$active_forum_ary = $moderators = array();

if ($forum_data['left_id'] != $forum_data['right_id'] - 1)
{
list($active_forum_ary, $moderators) = display_forums($forum_data, $config['load_moderators'], $config['load_moderators']);
}
else
{
$template->assign_var('S_HAS_SUBFORUM', false);
get_moderators($moderators, $forum_id);
}

// Dump out the page header and load viewforum template
page_header($user->lang['VIEW_FORUM'] . ' - ' . $forum_data['forum_name']);

$template->set_filenames(array(
'body' => 'viewforum_body.html')
);

make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"), $forum_id);

$template->assign_vars(array(
'U_VIEW_FORUM'			=> append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id&start=$start"),
));

// Not postable forum or showing active topics?
if (!($forum_data['forum_type'] == FORUM_POST || (($forum_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS) && $forum_data['forum_type'] == FORUM_CAT)))
{
page_footer();
}

// Ok, if someone has only list-access, we only display the forum list.
// We also make this circumstance available to the template in case we want to display a notice. 
if (!$auth->acl_get('f_read', $forum_id))
{
$template->assign_vars(array(
	'S_NO_READ_ACCESS'		=> true,
	'S_AUTOLOGIN_ENABLED'	=> ($config['allow_autologin']) ? true : false,
	'S_LOGIN_ACTION'		=> append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login') . '&redirect=' . urlencode(str_replace('&', '&', build_url(array('_f_')))),
));

page_footer();
}

// Handle marking posts
if ($mark_read == 'topics')
{
markread('topics', $forum_id);

$redirect_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);
meta_refresh(3, $redirect_url);

trigger_error($user->lang['TOPICS_MARKED'] . '<br /><br />' . sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect_url . '">', '</a>'));
}

// Is a forum specific topic count required?
if ($forum_data['forum_topics_per_page'])
{
$config['topics_per_page'] = $forum_data['forum_topics_per_page'];
}

// Do the forum Prune thang - cron type job ...
if ($forum_data['prune_next'] < time() && $forum_data['enable_prune'])
{
$template->assign_var('RUN_CRON_TASK', '<img src="' . append_sid($phpbb_root_path . 'cron.' . $phpEx, 'cron_type=prune_forum&f=' . $forum_id) . '" alt="cron" width="1" height="1" />');
}

// Forum rules and subscription info
$s_watching_forum = $s_watching_forum_img = array();
$s_watching_forum['link'] = $s_watching_forum['title'] = '';
$s_watching_forum['is_watching'] = false;

if (($config['email_enable'] || $config['jab_enable']) && $config['allow_forum_notify'] && $auth->acl_get('f_subscribe', $forum_id))
{
$notify_status = (isset($forum_data['notify_status'])) ? $forum_data['notify_status'] : NULL;
watch_topic_forum('forum', $s_watching_forum, $s_watching_forum_img, $user->data['user_id'], $forum_id, 0, $notify_status);
}

$s_forum_rules = '';
gen_forum_auth_level('forum', $forum_id, $forum_data['forum_status']);

// Topic ordering options
$limit_days = array(0 => $user->lang['ALL_TOPICS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 'r' => $user->lang['REPLIES'], 's' => $user->lang['SUBJECT'], 'v' => $user->lang['VIEWS']);
$sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_last_post_time', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');

$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';
gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

// Limit topics to certain time frame, obtain correct topic count
// global announcements must not be counted, normal announcements have to
// be counted, as forum_topics(_real) includes them
if ($sort_days)
{
$min_post_time = time() - ($sort_days * 86400);

$sql = 'SELECT COUNT(topic_id) AS num_topics
	FROM ' . TOPICS_TABLE . "
	WHERE forum_id = $forum_id
		AND ((topic_type <> " . POST_GLOBAL . " AND topic_last_post_time >= $min_post_time)
			OR topic_type = " . POST_ANNOUNCE . ")
	" . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND topic_approved = 1');
$result = $db->sql_query($sql);
$topics_count = (int) $db->sql_fetchfield('num_topics');
$db->sql_freeresult($result);

if (isset($_POST['sort']))
{
	$start = 0;
}
$sql_limit_time = "AND t.topic_last_post_time >= $min_post_time";

// Make sure we have information about day selection ready
$template->assign_var('S_SORT_DAYS', true);
}
else
{
$topics_count = ($auth->acl_get('m_approve', $forum_id)) ? $forum_data['forum_topics_real'] : $forum_data['forum_topics'];
$sql_limit_time = '';
}

// Make sure $start is set to the last page if it exceeds the amount
if ($start < 0 || $start > $topics_count)
{
$start = ($start < 0) ? 0 : floor(($topics_count - 1) / $config['topics_per_page']) * $config['topics_per_page'];
}

// Basic pagewide vars
$post_alt = ($forum_data['forum_status'] == ITEM_LOCKED) ? $user->lang['FORUM_LOCKED'] : $user->lang['POST_NEW_TOPIC'];

// Display active topics?
$s_display_active = ($forum_data['forum_type'] == FORUM_CAT && ($forum_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS)) ? true : false;

$template->assign_vars(array(
'MODERATORS'	=> (!empty($moderators[$forum_id])) ? implode(', ', $moderators[$forum_id]) : '',

'POST_IMG'					=> ($forum_data['forum_status'] == ITEM_LOCKED) ? $user->img('button_topic_locked', $post_alt) : $user->img('button_topic_new', $post_alt),
'NEWEST_POST_IMG'			=> $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),
'LAST_POST_IMG'				=> $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),
'FOLDER_IMG'				=> $user->img('topic_read', 'NO_NEW_POSTS'),
'FOLDER_NEW_IMG'			=> $user->img('topic_unread', 'NEW_POSTS'),
'FOLDER_HOT_IMG'			=> $user->img('topic_read_hot', 'NO_NEW_POSTS_HOT'),
'FOLDER_HOT_NEW_IMG'		=> $user->img('topic_unread_hot', 'NEW_POSTS_HOT'),
'FOLDER_LOCKED_IMG'			=> $user->img('topic_read_locked', 'NO_NEW_POSTS_LOCKED'),
'FOLDER_LOCKED_NEW_IMG'		=> $user->img('topic_unread_locked', 'NEW_POSTS_LOCKED'),
'FOLDER_STICKY_IMG'			=> $user->img('sticky_read', 'POST_STICKY'),
'FOLDER_STICKY_NEW_IMG'		=> $user->img('sticky_unread', 'POST_STICKY'),
'FOLDER_ANNOUNCE_IMG'		=> $user->img('announce_read', 'POST_ANNOUNCEMENT'),
'FOLDER_ANNOUNCE_NEW_IMG'	=> $user->img('announce_unread', 'POST_ANNOUNCEMENT'),
'FOLDER_MOVED_IMG'			=> $user->img('topic_moved', 'TOPIC_MOVED'),
'REPORTED_IMG'				=> $user->img('icon_topic_reported', 'TOPIC_REPORTED'),
'UNAPPROVED_IMG'			=> $user->img('icon_topic_unapproved', 'TOPIC_UNAPPROVED'),
'GOTO_PAGE_IMG'				=> $user->img('icon_post_target', 'GOTO_PAGE'),

'L_NO_TOPICS' 			=> ($forum_data['forum_status'] == ITEM_LOCKED) ? $user->lang['POST_FORUM_LOCKED'] : $user->lang['NO_TOPICS'],

'S_DISPLAY_POST_INFO'	=> ($forum_data['forum_type'] == FORUM_POST && ($auth->acl_get('f_post', $forum_id) || $user->data['user_id'] == ANONYMOUS)) ? true : false,

'S_IS_POSTABLE'			=> ($forum_data['forum_type'] == FORUM_POST) ? true : false,
'S_USER_CAN_POST'		=> ($auth->acl_get('f_post', $forum_id)) ? true : false,
'S_DISPLAY_ACTIVE'		=> $s_display_active,
'S_SELECT_SORT_DIR'		=> $s_sort_dir,
'S_SELECT_SORT_KEY'		=> $s_sort_key,
'S_SELECT_SORT_DAYS'	=> $s_limit_days,
'S_TOPIC_ICONS'			=> ($s_display_active && sizeof($active_forum_ary)) ? max($active_forum_ary['enable_icons']) : (($forum_data['enable_icons']) ? true : false),
'S_WATCH_FORUM_LINK'	=> $s_watching_forum['link'],
'S_WATCH_FORUM_TITLE'	=> $s_watching_forum['title'],
'S_WATCHING_FORUM'		=> $s_watching_forum['is_watching'],
'S_FORUM_ACTION'		=> append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id&start=$start"),
'S_DISPLAY_SEARCHBOX'	=> ($auth->acl_get('u_search') && $auth->acl_get('f_search', $forum_id) && $config['load_search']) ? true : false,
'S_SEARCHBOX_ACTION'	=> append_sid("{$phpbb_root_path}search.$phpEx", 'fid[]=' . $forum_id),
'S_SINGLE_MODERATOR'	=> (!empty($moderators[$forum_id]) && sizeof($moderators[$forum_id]) > 1) ? false : true,
'S_IS_LOCKED'			=> ($forum_data['forum_status'] == ITEM_LOCKED) ? true : false,
'S_VIEWFORUM'			=> true,

'U_MCP'				=> ($auth->acl_get('m_', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "f=$forum_id&i=main&mode=forum_view", true, $user->session_id) : '',
'U_POST_NEW_TOPIC'	=> ($auth->acl_get('f_post', $forum_id) || $user->data['user_id'] == ANONYMOUS) ? append_sid("{$phpbb_root_path}posting.$phpEx", 'mode=post&f=' . $forum_id) : '',
'U_VIEW_FORUM'		=> append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id&$u_sort_param&start=$start"),
'U_MARK_TOPICS'		=> ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id&mark=topics") : '',
));

// Grab icons
$icons = $cache->obtain_icons();

// Grab all topic data
$rowset = $announcement_list = $topic_list = $global_announce_list = array();

$sql_array = array(
'SELECT'	=> 't.*',
'FROM'		=> array(
	TOPICS_TABLE		=> 't'
),
'LEFT_JOIN'	=> array(),
);

$sql_approved = ($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND t.topic_approved = 1';

if ($user->data['is_registered'])
{
if ($config['load_db_track'])
{
	$sql_array['LEFT_JOIN'][] = array('FROM' => array(TOPICS_POSTED_TABLE => 'tp'), 'ON' => 'tp.topic_id = t.topic_id AND tp.user_id = ' . $user->data['user_id']);
	$sql_array['SELECT'] .= ', tp.topic_posted';
}

if ($config['load_db_lastread'])
{
	$sql_array['LEFT_JOIN'][] = array('FROM' => array(TOPICS_TRACK_TABLE => 'tt'), 'ON' => 'tt.topic_id = t.topic_id AND tt.user_id = ' . $user->data['user_id']);
	$sql_array['SELECT'] .= ', tt.mark_time';

	if ($s_display_active && sizeof($active_forum_ary))
	{
		$sql_array['LEFT_JOIN'][] = array('FROM' => array(FORUMS_TRACK_TABLE => 'ft'), 'ON' => 'ft.forum_id = t.forum_id AND ft.user_id = ' . $user->data['user_id']);
		$sql_array['SELECT'] .= ', ft.mark_time AS forum_mark_time';
	}
}
}

if ($forum_data['forum_type'] == FORUM_POST)
{
// Obtain announcements ... removed sort ordering, sort by time in all cases
$sql = $db->sql_build_query('SELECT', array(
	'SELECT'	=> $sql_array['SELECT'],
	'FROM'		=> $sql_array['FROM'],
	'LEFT_JOIN'	=> $sql_array['LEFT_JOIN'],

	'WHERE'		=> 't.forum_id IN (' . $forum_id . ', 0)
		AND t.topic_type IN (' . POST_ANNOUNCE . ', ' . POST_GLOBAL . ')',

	'ORDER_BY'	=> 't.topic_time DESC',
));
$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))
{
	$rowset[$row['topic_id']] = $row;
	$announcement_list[] = $row['topic_id'];

	if ($row['topic_type'] == POST_GLOBAL)
	{
		$global_announce_list[$row['topic_id']] = true;
	}
	else
	{
		$topics_count--;
	}
}
$db->sql_freeresult($result);
}

// If the user is trying to reach late pages, start searching from the end
$store_reverse = false;
$sql_limit = $config['topics_per_page'];
if ($start > $topics_count / 2)
{
$store_reverse = true;

if ($start + $config['topics_per_page'] > $topics_count)
{
	$sql_limit = min($config['topics_per_page'], max(1, $topics_count - $start));
}

// Select the sort order
$sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'ASC' : 'DESC');
$sql_start = max(0, $topics_count - $sql_limit - $start);
}
else
{
// Select the sort order
$sql_sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');
$sql_start = $start;
}

if ($forum_data['forum_type'] == FORUM_POST || !sizeof($active_forum_ary))
{
$sql_where = 't.forum_id = ' . $forum_id;
}
else if (empty($active_forum_ary['exclude_forum_id']))
{
$sql_where = $db->sql_in_set('t.forum_id', $active_forum_ary['forum_id']);
}
else
{
$get_forum_ids = array_diff($active_forum_ary['forum_id'], $active_forum_ary['exclude_forum_id']);
$sql_where = (sizeof($get_forum_ids)) ? $db->sql_in_set('t.forum_id', $get_forum_ids) : 't.forum_id = ' . $forum_id;
}

// SQL array for obtaining topics/stickies
$sql_array = array(
'SELECT'		=> $sql_array['SELECT'],
'FROM'			=> $sql_array['FROM'],
'LEFT_JOIN'		=> $sql_array['LEFT_JOIN'],

'WHERE'			=> $sql_where . '
	AND t.topic_type IN (' . POST_NORMAL . ', ' . POST_STICKY . ")
	$sql_approved
	$sql_limit_time",

'ORDER_BY'		=> 't.topic_type ' . ((!$store_reverse) ? 'DESC' : 'ASC') . ', ' . $sql_sort_order,
);

// If store_reverse, then first obtain topics, then stickies, else the other way around...
// Funnily enough you typically save one query if going from the last page to the middle (store_reverse) because
// the number of stickies are not known
$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query_limit($sql, $sql_limit, $sql_start);

$shadow_topic_list = array();
while ($row = $db->sql_fetchrow($result))
{
if ($row['topic_status'] == ITEM_MOVED)
{
	$shadow_topic_list[$row['topic_moved_id']] = $row['topic_id'];
}

$rowset[$row['topic_id']] = $row;
$topic_list[] = $row['topic_id'];
}
$db->sql_freeresult($result);

// If we have some shadow topics, update the rowset to reflect their topic information
if (sizeof($shadow_topic_list))
{
$sql = 'SELECT *
	FROM ' . TOPICS_TABLE . '
	WHERE ' . $db->sql_in_set('topic_id', array_keys($shadow_topic_list));
$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))
{
	$orig_topic_id = $shadow_topic_list[$row['topic_id']];

	// If the shadow topic is already listed within the rowset (happens for active topics for example), then do not include it...
	if (isset($rowset[$row['topic_id']]))
	{
		// We need to remove any trace regarding this topic. 
		unset($rowset[$orig_topic_id]);
		unset($topic_list[array_search($orig_topic_id, $topic_list)]);
		$topics_count--;

		continue;
	}

	// Do not include those topics the user has no permission to access
	if (!$auth->acl_get('f_read', $row['forum_id']))
	{
		// We need to remove any trace regarding this topic. 
		unset($rowset[$orig_topic_id]);
		unset($topic_list[array_search($orig_topic_id, $topic_list)]);
		$topics_count--;

		continue;
	}

	// We want to retain some values
	$row = array_merge($row, array(
		'topic_moved_id'	=> $rowset[$orig_topic_id]['topic_moved_id'],
		'topic_status'		=> $rowset[$orig_topic_id]['topic_status'])
	);

	$rowset[$orig_topic_id] = $row;
}
$db->sql_freeresult($result);
}
unset($shadow_topic_list);

// Ok, adjust topics count for active topics list
if ($s_display_active)
{
$topics_count = 1;
}

$template->assign_vars(array(
'PAGINATION'	=> generate_pagination(append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id&$u_sort_param"), $topics_count, $config['topics_per_page'], $start),
'PAGE_NUMBER'	=> on_page($topics_count, $config['topics_per_page'], $start),
'TOTAL_TOPICS'	=> ($s_display_active) ? false : (($topics_count == 1) ? $user->lang['VIEW_FORUM_TOPIC'] : sprintf($user->lang['VIEW_FORUM_TOPICS'], $topics_count)))
);

$topic_list = ($store_reverse) ? array_merge($announcement_list, array_reverse($topic_list)) : array_merge($announcement_list, $topic_list);
$topic_tracking_info = $tracking_topics = array();

// Okay, lets dump out the page ...
if (sizeof($topic_list))
{
$mark_forum_read = true;
$mark_time_forum = 0;

// Active topics?
if ($s_display_active && sizeof($active_forum_ary))
{
	// Generate topic forum list...
	$topic_forum_list = array();
	foreach ($rowset as $t_id => $row)
	{
		$topic_forum_list[$row['forum_id']]['forum_mark_time'] = ($config['load_db_lastread'] && $user->data['is_registered'] && isset($row['forum_mark_time'])) ? $row['forum_mark_time'] : 0;
		$topic_forum_list[$row['forum_id']]['topics'][] = $t_id;
	}

	if ($config['load_db_lastread'] && $user->data['is_registered'])
	{
		foreach ($topic_forum_list as $f_id => $topic_row)
		{
			$topic_tracking_info += get_topic_tracking($f_id, $topic_row['topics'], $rowset, array($f_id => $topic_row['forum_mark_time']), false);
		}
	}
	else if ($config['load_anon_lastread'] || $user->data['is_registered'])
	{
		foreach ($topic_forum_list as $f_id => $topic_row)
		{
			$topic_tracking_info += get_complete_topic_tracking($f_id, $topic_row['topics'], false);
		}
	}

	unset($topic_forum_list);
}
else
{
	if ($config['load_db_lastread'] && $user->data['is_registered'])
	{
		$topic_tracking_info = get_topic_tracking($forum_id, $topic_list, $rowset, array($forum_id => $forum_data['mark_time']), $global_announce_list);
		$mark_time_forum = (!empty($forum_data['mark_time'])) ? $forum_data['mark_time'] : $user->data['user_lastmark'];
	}
	else if ($config['load_anon_lastread'] || $user->data['is_registered'])
	{
		$topic_tracking_info = get_complete_topic_tracking($forum_id, $topic_list, $global_announce_list);

		if (!$user->data['is_registered'])
		{
			$user->data['user_lastmark'] = (isset($tracking_topics['l'])) ? (int) (base_convert($tracking_topics['l'], 36, 10) + $config['board_startdate']) : 0;
		}
		$mark_time_forum = (isset($tracking_topics['f'][$forum_id])) ? (int) (base_convert($tracking_topics['f'][$forum_id], 36, 10) + $config['board_startdate']) : $user->data['user_lastmark'];
	}
}

$s_type_switch = 0;
foreach ($topic_list as $topic_id)
{
	$row = &$rowset[$topic_id];

	// This will allow the style designer to output a different header
	// or even separate the list of announcements from sticky and normal topics
	$s_type_switch_test = ($row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL) ? 1 : 0;

	// Replies
	$replies = ($auth->acl_get('m_approve', $forum_id)) ? $row['topic_replies_real'] : $row['topic_replies'];

	if ($row['topic_status'] == ITEM_MOVED)
	{
		$topic_id = $row['topic_moved_id'];
		$unread_topic = false;
	}
	else
	{
		$unread_topic = (isset($topic_tracking_info[$topic_id]) && $row['topic_last_post_time'] > $topic_tracking_info[$topic_id]) ? true : false;
	}

	// Get folder img, topic status/type related information
	$folder_img = $folder_alt = $topic_type = '';
	topic_status($row, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type);

	// Generate all the URIs ...
	$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . (($row['forum_id']) ? $row['forum_id'] : $forum_id) . '&t=' . $topic_id);

	$topic_unapproved = (!$row['topic_approved'] && $auth->acl_get('m_approve', $forum_id)) ? true : false;
	$posts_unapproved = ($row['topic_approved'] && $row['topic_replies'] < $row['topic_replies_real'] && $auth->acl_get('m_approve', $forum_id)) ? true : false;
	$u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . "&t=$topic_id", true, $user->session_id) : '';

	// Send vars to template
	$template->assign_block_vars('topicrow', array(
		'FORUM_ID'					=> $forum_id,
		'TOPIC_ID'					=> $topic_id,
		'TOPIC_AUTHOR'				=> get_username_string('username', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
		'TOPIC_AUTHOR_COLOUR'		=> get_username_string('colour', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
		'TOPIC_AUTHOR_FULL'			=> get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
		'FIRST_POST_TIME'			=> $user->format_date($row['topic_time']),
		'LAST_POST_SUBJECT'			=> censor_text($row['topic_last_post_subject']),
		'LAST_POST_TIME'			=> $user->format_date($row['topic_last_post_time']),
		'LAST_VIEW_TIME'			=> $user->format_date($row['topic_last_view_time']),
		'LAST_POST_AUTHOR'			=> get_username_string('username', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
		'LAST_POST_AUTHOR_COLOUR'	=> get_username_string('colour', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
		'LAST_POST_AUTHOR_FULL'		=> get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),

		'PAGINATION'		=> topic_generate_pagination($replies, $view_topic_url),
		'REPLIES'			=> $replies,
		'VIEWS'				=> $row['topic_views'],
		'TOPIC_TITLE'		=> censor_text($row['topic_title']),
		'TOPIC_TYPE'		=> $topic_type,

		'TOPIC_FOLDER_IMG'		=> $user->img($folder_img, $folder_alt),
		'TOPIC_FOLDER_IMG_SRC'	=> $user->img($folder_img, $folder_alt, false, '', 'src'),
		'TOPIC_FOLDER_IMG_ALT'	=> $user->lang[$folder_alt],
		'TOPIC_ICON_IMG'		=> (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['img'] : '',
		'TOPIC_ICON_IMG_WIDTH'	=> (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['width'] : '',
		'TOPIC_ICON_IMG_HEIGHT'	=> (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['height'] : '',
		'ATTACH_ICON_IMG'		=> ($auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id) && $row['topic_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',
		'UNAPPROVED_IMG'		=> ($topic_unapproved || $posts_unapproved) ? $user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '',

		'S_TOPIC_TYPE'			=> $row['topic_type'],
		'S_USER_POSTED'			=> (isset($row['topic_posted']) && $row['topic_posted']) ? true : false,
		'S_UNREAD_TOPIC'		=> $unread_topic,
		'S_TOPIC_REPORTED'		=> (!empty($row['topic_reported']) && $auth->acl_get('m_report', $forum_id)) ? true : false,
		'S_TOPIC_UNAPPROVED'	=> $topic_unapproved,
		'S_POSTS_UNAPPROVED'	=> $posts_unapproved,
		'S_HAS_POLL'			=> ($row['poll_start']) ? true : false,
		'S_POST_ANNOUNCE'		=> ($row['topic_type'] == POST_ANNOUNCE) ? true : false,
		'S_POST_GLOBAL'			=> ($row['topic_type'] == POST_GLOBAL) ? true : false,
		'S_POST_STICKY'			=> ($row['topic_type'] == POST_STICKY) ? true : false,
		'S_TOPIC_LOCKED'		=> ($row['topic_status'] == ITEM_LOCKED) ? true : false,
		'S_TOPIC_MOVED'			=> ($row['topic_status'] == ITEM_MOVED) ? true : false,

		'U_NEWEST_POST'			=> $view_topic_url . '&view=unread#unread',
		'U_LAST_POST'			=> $view_topic_url . '&p=' . $row['topic_last_post_id'] . '#p' . $row['topic_last_post_id'],
		'U_LAST_POST_AUTHOR'	=> get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
		'U_TOPIC_AUTHOR'		=> get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
		'U_VIEW_TOPIC'			=> $view_topic_url,
		'U_MCP_REPORT'			=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&mode=reports&f=' . $forum_id . '&t=' . $topic_id, true, $user->session_id),
		'U_MCP_QUEUE'			=> $u_mcp_queue,

		'S_TOPIC_TYPE_SWITCH'	=> ($s_type_switch == $s_type_switch_test) ? -1 : $s_type_switch_test)
	);

	$s_type_switch = ($row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL) ? 1 : 0;

	if ($unread_topic)
	{
		$mark_forum_read = false;
	}

	unset($rowset[$topic_id]);
}
}

// This is rather a fudge but it's the best I can think of without requiring information
// on all topics (as we do in 2.0.x). It looks for unread or new topics, if it doesn't find
// any it updates the forum last read cookie. This requires that the user visit the forum
// after reading a topic
if ($forum_data['forum_type'] == FORUM_POST && sizeof($topic_list) && $mark_forum_read)
{
update_forum_tracking_info($forum_id, $forum_data['forum_last_post_time'], false, $mark_time_forum);
}

page_footer();

?>

runnerjp · May 24, 2008

Unknown column 'b.group_bypass_post_req' in 'field list' --- you dont have the column in your db

Oreo Killa 225 · May 24, 2008

I'm using c99memory v. 1.0 pre-release build #16.

Do you know how I can possibly add it?

EDIT: Would this have something to do with it?

ALTER TABLE phpbb_forums ADD forum_postcount_view INT NOT NULL DEFAULT '0',
ADD forum_postcount_post INT NOT NULL DEFAULT '0';

ALTER TABLE phpbb_groups ADD group_bypass_post_req TINYINT(1) NOT NULL DEFAULT '0';

UPDATE phpbb_groups SET group_bypass_post_req='1' WHERE group_id=4;

UPDATE phpbb_groups SET group_bypass_post_req='1' WHERE group_id=5;

I don't know where I'm supposed to put that code.

Oreo Killa 225 · May 24, 2008

Anyone?

BlueSkyIS · May 24, 2008

it looks like that SQL will add the field you're missing. you need to run that in phpMyAdmin, or manually via ssh if you know how.

Oreo Killa 225 · May 24, 2008

Isn't phpMyAdmin another db?

BlueSkyIS · May 24, 2008

no, it's a web interface used to manipulate databases. mysql, specifically. if you don't have any way to run queries against your database, you'll want to find phpmyadmin and install it.

Sign In

Please Help.

Recommended Posts

Oreo Killa 225

Link to comment

Share on other sites

Oreo Killa 225

Link to comment

Share on other sites

runnerjp

Link to comment

Share on other sites

Oreo Killa 225

Link to comment

Share on other sites

Oreo Killa 225

Link to comment

Share on other sites

BlueSkyIS

Link to comment

Share on other sites

Oreo Killa 225

Link to comment

Share on other sites

BlueSkyIS

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information