$sql_forum_id = ($permission_scope == 'global') ? 'AND a.forum_id = 0' : ((sizeof($forum_id)) ? 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')' : 'AND a.forum_id <> 0');

$sql_permission_option = "AND o.auth_option LIKE '" . $db->sql_escape($permission_type) . "%'";

$result = $db->sql_query($sql);

$s_defined_user_options = '';

}

$db->sql_freeresult($result);

$result = $db->sql_query($sql);

$s_defined_group_options = '';

// First grab user settings ... each user has only one setting for each

// option ... so we shouldn't need any ACL_NO checks ... he says ...

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

$db->sql_freeresult($result);

// Now grab group settings ... ACL_NO overrides ACL_YES so act appropriatley

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

$hold_ary = array();

// Grab user settings...

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

$hold_ary = array();

// Grab group settings...

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

}

/**

* display sql error page

*/

function sql_error($sql = '')

switch ($status)

{

case 'begin':

$this->transaction = true;

break;

{

global $cache;

$this->last_query_text = $query;

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

}

/**

* return sql error array

* @private

*/

{

// Take the time spent on parsing rows into account

}

$splittime = explode(' ', microtime());

$splittime = $splittime[0] + $splittime[1];

{

global $cache;

// EXPLAIN only in extra debug mode

if (defined('DEBUG_EXTRA'))

}

/**

* Close sql connection

* @private

*/

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

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

}

/**

* return sql error array

* @private

*/

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

}

/**

* return sql error array

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

}

/**

* return sql error array

{

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

}

/**

* return sql error array

{

global $cache;

// EXPLAIN only in extra debug mode

if (defined('DEBUG_EXTRA'))

return str_replace("'", "''", str_replace('\\', '\\\\', $msg));

}

/**

* return sql error array

* @private

{

global $cache;

// EXPLAIN only in extra debug mode

if (defined('DEBUG_EXTRA'))

{

$this->num_queries++;

{

$this->sql_error($query);

}

}

/**

* Build LIMIT query

*/

function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

{

global $cache;

// EXPLAIN only in extra debug mode

if (defined('DEBUG_EXTRA'))

}

/**

* Close sql connection

* @private

*/

$ug_id_ary = array_keys($hold_ary);

// Remove users who have group memberships with DENY moderator permissions

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

if ($total)

{

$result = $db->sql_query_limit($sql, 5);

while ($row = $db->sql_fetchrow($result))

}

}

if ($config['load_db_lastread'])

{

}

else

{

$tracking_topics = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? unserialize(stripslashes($_COOKIE[$config['cookie_name'] . '_track'])) : array();

}

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

);

}

if ($config['load_db_lastread'])

{

}

$result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

$topic_list = $topic_forum_list = $global_announce_list = $rowset = array();

global $db, $auth;

$rowset = array();

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

}

$db->sql_freeresult($result);

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

// Output listing of friends online

$update_time = $config['load_online_time'] * 60;

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

$sql_ordering = ($view == 'next') ? 'ASC' : 'DESC';

$sql = 'SELECT t.topic_id, t.forum_id

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

ORDER BY t.topic_last_post_time $sql_ordering";

$result = $db->sql_query_limit($sql, 1);

$row = $db->sql_fetchrow($result);

// This rather complex gaggle of code handles querying for topics but

// also allows for direct linking to a post (and the calculation of which

// page the post is on and the correct display of viewtopic)

$select_sql = 't.topic_id, t.forum_id, t.topic_title, t.topic_attachment, t.topic_status, t.topic_approved, t.topic_replies_real, t.topic_replies, t.topic_first_post_id, t.topic_last_post_id, t.topic_last_poster_id, t.topic_last_post_time, t.topic_poster, t.topic_time, t.topic_time_limit, t.topic_type, t.topic_bumped, t.topic_bumper, t.poll_max_options, t.poll_start, t.poll_length, t.poll_title, t.poll_vote_change, f.forum_name, f.forum_desc, f.forum_desc_uid, f.forum_desc_bitfield, f.forum_parents, f.parent_id, f.left_id, f.right_id, f.forum_status, f.forum_type, f.forum_id, f.forum_style, f.forum_password, f.forum_rules, f.forum_rules_link, f.forum_rules_uid, f.forum_rules_bitfield';

if ($user->data['is_registered'])

{

if ($config['allow_bookmarks'])

{

}

if ($config['load_db_lastread'])

{

}

}

// Join to forum table on topic forum_id unless topic forum_id is zero

// whereupon we join on the forum_id passed as a parameter ... this

// is done so navigation, forum name, etc. remain consistent with where

// user clicked to view a global topic

$result = $db->sql_query($sql);

if (!($topic_data = $db->sql_fetchrow($result)))

// We need to grab it because we do reverse ordering sometimes

$max_post_time = 0;

$result = $db->sql_query($sql);

// Posts are stored in the $rowset array while $attach_list, $user_cache