*/

/**

* Recalculate Binary Tree

function recalc_btree($sql_id, $sql_table, $module_class = '')

{

if ($substract > 0)

{

SET left_id = left_id - $substract, right_id = right_id - $substract

$sql_where";

$db->sql_query($sql);

}

FROM $sql_table

$sql_where

ORDER BY left_id ASC, parent_id ASC, $sql_id ASC";

$sql_and = (!$config['coppa_enable']) ? (($exclude_sql) ? ' AND ' : ' WHERE ') . "group_name <> 'REGISTERED_COPPA'" : '';

$sql_founder = ($manage_founder !== false) ? (($exclude_sql || $sql_and) ? ' AND ' : ' WHERE ') . 'group_founder_manage = ' . (int) $manage_founder : '';

FROM ' . GROUPS_TABLE . "

$exclude_sql

$sql_and

}

$db->sql_freeresult($result);

WHERE topic_id = ' . $topic_id;

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

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

foreach ($table_ary as $table)

{

WHERE " . $db->sql_in_set('topic_id', $topic_ids);

$db->sql_query($sql);

}

if (sizeof($moved_topic_ids))

{

WHERE ' . $db->sql_in_set('topic_id', $moved_topic_ids);

$db->sql_query($sql);

}

foreach ($table_ary as $table)

{

WHERE " . $db->sql_in_set('post_id', $post_ids);

$db->sql_query($sql);

}

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = 0

AND user_posts < ' . $substract;

$db->sql_query($sql);

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts - ' . $substract . '

AND user_posts >= ' . $substract;

$db->sql_query($sql);

}

{

if ($mode == 'post' || $mode == 'topic')

{

SET post_attachment = 0

WHERE ' . $db->sql_in_set('post_id', $post_ids);

$db->sql_query($sql);

$remaining = array();

$sql = 'SELECT post_msg_id

WHERE ' . $db->sql_in_set('post_msg_id', $post_ids) . '

AND in_message = 0';

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

if (sizeof($unset_ids))

{

SET post_attachment = 0

WHERE ' . $db->sql_in_set('post_id', $unset_ids);

$db->sql_query($sql);

$remaining = array();

$sql = 'SELECT post_msg_id

WHERE ' . $db->sql_in_set('post_msg_id', $post_ids) . '

AND in_message = 1';

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

if (sizeof($unset_ids))

{

SET message_attachment = 0

WHERE ' . $db->sql_in_set('msg_id', $unset_ids);

$db->sql_query($sql);

$remaining = array();

$sql = 'SELECT topic_id

WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

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

if (sizeof($unset_ids))

{

SET topic_attachment = 0

WHERE ' . $db->sql_in_set('topic_id', $unset_ids);

$db->sql_query($sql);

{

$topic_id = (int) $row['topic_id'];

// However, there's not much we can do about it.

if (!empty($shadow_topic_data[$topic_id]))

{

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_id) . "

$sql_and";

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

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_id) . "

$sql_and";

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

{

$topic_id_list = array_unique($topic_id_list);

// although it's also used to determine if the topic still exists in the database

$sql = 'SELECT topic_id, forum_id

FROM ' . TOPICS_TABLE . '

// update foes for some user

if (is_array($user_id) && sizeof($user_id))

{

WHERE ' . $db->sql_in_set('zebra_id', $user_id) . '

AND foe = 1';

$db->sql_query($sql);

// update foes for some group

if (is_array($group_id) && sizeof($group_id))

{

$sql = $db->sql_build_query('SELECT', array(

'SELECT' => 'a.group_id',

if (sizeof($users))

{

WHERE ' . $db->sql_in_set('zebra_id', $users) . '

AND foe = 1';

$db->sql_query($sql);

if (sizeof($perms))

{

WHERE ' . $db->sql_in_set('zebra_id', array_unique($perms)) . '

AND foe = 1';

$db->sql_query($sql);

global $db, $user;

$sql = 'SELECT user_id, username, user_regdate, user_lastvisit, user_inactive_time, user_inactive_reason

ORDER BY $sort_by";

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

$sql = 'SELECT COUNT(user_id) AS user_count

FROM ' . USERS_TABLE . '

(($limit_days) ? " AND user_inactive_time >= $limit_days" : '');

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

$user_count = (int) $db->sql_fetchfield('user_count');