*

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

if ( !empty($setmodules) )

{

//

// Load default header

//

require($phpbb_root_path . 'extension.inc');

require('pagestart.' . $phpEx);

require($phpbb_root_path . 'includes/prune.'.$phpEx);

if( $forum_id == -1 )

{

}

else

{

}

else

{

}

//

// Get a list of forum's or the data for the forum that we are pruning.

$prunedate = time() - ( $prunedays * 86400 );

$template->set_filenames(array(

);

for($i = 0; $i < count($forum_rows); $i++)

{

$p_result = prune($forum_rows[$i]['forum_id'], $prunedate);

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

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

$board_config['board_timezone'] = $userdata['user_timezone'];

}

}

if ( !file_exists($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.'.$phpEx) )

{

function decode_ip($int_ip)

{

}

//

if ( $total_pages == 1 )

{

}

$on_page = floor($start_item / $per_page) + 1;

function phpbb_preg_quote($str, $delimiter)

{

$text = preg_quote($str);

return $text;

}

{

do

{

$replacement_word[] = $row['replacement'];

}

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

break;

case 'forum':

if ( !$result = $db->sql_query($sql) )

{

message_die(GENERAL_ERROR, 'Could not get post ID', '', __LINE__, __FILE__, $sql);

message_die(GENERAL_ERROR, 'Could not get topic count', '', __LINE__, __FILE__, $sql);

}

$sql = "UPDATE " . FORUMS_TABLE . "

SET forum_last_post_id = $last_post, forum_posts = $total_posts, forum_topics = $total_topics

WHERE forum_id = $id";

{

}

break;

WHERE topic_id = $id";

if ( !$result = $db->sql_query($sql) )

{

}

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

$sql = "UPDATE " . TOPICS_TABLE . "

SET topic_replies = " . ( $row['total_posts'] - 1 ) . ", topic_first_post_id = " . $row['first_post'] . ", topic_last_post_id = " . $row['last_post'] . "

WHERE topic_id = $id";

{

}

}

if ( $post_data['first_post'] )

{

$sql = "DELETE FROM " . TOPICS_TABLE . "

if ( !($db->sql_query($sql)) )

{

message_die(GENERAL_ERROR, 'Error in deleting post', '', __LINE__, __FILE__, $sql);

default:

$sql = "INSERT INTO " . SEARCH_WORD_TABLE . " (word_text)

VALUES ('" . $word[$i] . "')";

{

message_die(GENERAL_ERROR, 'Could not insert new word', '', __LINE__, __FILE__, $sql);

}

break;

}

{

message_die(GENERAL_ERROR, 'Could not insert new word', '', __LINE__, __FILE__, $sql);

}

SELECT $post_id, word_id, $title_match

FROM " . SEARCH_WORD_TABLE . "

WHERE word_text IN ($match_sql)";

{

message_die(GENERAL_ERROR, 'Could not insert new word matches', '', __LINE__, __FILE__, $sql);

}

{

$common_word_id .= ( ( $common_word_id != '' ) ? ', ' : '' ) . $row['word_id'];

}

$db->sql_freeresult($result);

if ( $common_word_id != '' )

$sql = "UPDATE " . SEARCH_WORD_TABLE . "

SET word_common = " . TRUE . "

WHERE word_id IN ($common_word_id)";

{

message_die(GENERAL_ERROR, 'Could not delete word list entry', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE FROM " . SEARCH_MATCH_TABLE . "

WHERE word_id IN ($common_word_id)";

{

message_die(GENERAL_ERROR, 'Could not delete word match entry', '', __LINE__, __FILE__, $sql);

}

{

$sql = "DELETE FROM " . SEARCH_WORD_TABLE . "

WHERE word_id IN ($word_id_sql)";

{

message_die(GENERAL_ERROR, 'Could not delete word list entry', '', __LINE__, __FILE__, $sql);

}

GROUP BY word_id

HAVING COUNT(word_id) = 1

)";

{

message_die(GENERAL_ERROR, 'Could not delete old words from word table', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE FROM " . SEARCH_MATCH_TABLE . "

WHERE post_id IN ($post_id_sql)";

{

message_die(GENERAL_ERROR, 'Error in deleting post', '', __LINE__, __FILE__, $sql);

}

{

$username_list .= '<option>' . $lang['No_match']. '</option>';

}

}

$gen_simple_header = TRUE;

}

require($phpbb_root_path . 'includes/functions_search.'.$phpEx);

function prune($forum_id, $prune_date)

{

FROM " . POSTS_TABLE . " p, " . TOPICS_TABLE . " t

WHERE t.forum_id = $forum_id

AND t.topic_vote = 0

AND p.post_id = t.topic_last_post_id";

if ( $prune_date != '' )

{

$sql .= " AND p.post_time < $prune_date";

}

if ( !($result = $db->sql_query($sql)) )

{

message_die(GENERAL_ERROR, 'Could not obtain lists of topics to prune', '', __LINE__, __FILE__, $sql);

{

$sql = "DELETE FROM " . TOPICS_TABLE . "

WHERE topic_id IN ($sql_topics)";

{

message_die(GENERAL_ERROR, 'Could not delete topics during prune', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE FROM " . POSTS_TABLE . "

WHERE post_id IN ($sql_post)";

{

message_die(GENERAL_ERROR, 'Could not delete post_text during prune', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE FROM " . POSTS_TEXT_TABLE . "

WHERE post_id IN ($sql_post)";

{

message_die(GENERAL_ERROR, 'Could not delete post during prune', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE FROM " . SEARCH_MATCH_TABLE . "

WHERE post_id IN ($sql_post)";

{

message_die(GENERAL_ERROR, 'Could not delete search matches', '', __LINE__, __FILE__, $sql);

}

remove_search_post($sql_post);

return array ('topics' => $pruned_topics, 'posts' => $pruned_posts);

}

if ( $row['prune_freq'] && $row['prune_days'] )

{

$prune_date = time() - ( $row['prune_days'] * 86400 );

$next_prune = time() + ( $row['prune_freq'] * 86400 );

$sql = "UPDATE " . FORUMS_TABLE . "

WHERE forum_id = $forum_id";

if ( !$db->sql_query($sql) )

{

if ( !defined('IN_PHPBB') )

{

exit;

}

{

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

{

$sql = "UPDATE " . USERS_TABLE . "

SET user_active = 1, user_actkey = ''" . $sql_update_pass . "

include($phpbb_root_path . 'includes/emailer.'.$phpEx);

$emailer = new emailer($board_config['smtp_delivery']);

$emailer->email_address($row['user_email']);

$emailer->set_subject();//$lang['Account_activated_subject']

$emailer->extra_headers($email_headers);

$emailer->assign_vars(array(

);

$emailer->send();

$emailer->reset();

$template->assign_vars(array(

);

message_die(GENERAL_MESSAGE, $lang['Account_active_admin']);

else

{

$template->assign_vars(array(

);

message_die(GENERAL_MESSAGE, $message);

}

}

else

{

}

}

else

}

else

{

}

//

// Do major work ...

//

{

case 'delete':

$page_title = $lang['Mod_CP'];

{

message_die(GENERAL_ERROR, 'Could not get post id information', '', __LINE__, __FILE__, $sql);

}

$post_id_sql = '';

{

}

$sql = "SELECT vote_id

FROM " . VOTE_DESC_TABLE . "

{

message_die(GENERAL_ERROR, 'Could not get vote id information', '', __LINE__, __FILE__, $sql);

}

$vote_id_sql = '';

{

}

//

// Got all required info so go ahead and start deleting everything

FROM " . TOPICS_TABLE . "

WHERE topic_id IN ($topic_id_sql)

OR topic_moved_id IN ($topic_id_sql)";

{

message_die(GENERAL_ERROR, 'Could not delete topics', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE

FROM " . POSTS_TABLE . "

WHERE post_id IN ($post_id_sql)";

{

message_die(GENERAL_ERROR, 'Could not delete posts', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE

FROM " . POSTS_TEXT_TABLE . "

WHERE post_id IN ($post_id_sql)";

{

message_die(GENERAL_ERROR, 'Could not delete posts text', '', __LINE__, __FILE__, $sql);

}

remove_search_post($post_id_sql);

}

$sql = "DELETE

FROM " . VOTE_DESC_TABLE . "

WHERE vote_id IN ($vote_id_sql)";

{

message_die(GENERAL_ERROR, 'Could not delete vote descriptions', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE

FROM " . VOTE_RESULTS_TABLE . "

WHERE vote_id IN ($vote_id_sql)";

{

message_die(GENERAL_ERROR, 'Could not delete vote results', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE

FROM " . VOTE_USERS_TABLE . "

WHERE vote_id IN ($vote_id_sql)";

{

message_die(GENERAL_ERROR, 'Could not delete vote users', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE

FROM " . TOPICS_WATCH_TABLE . "

WHERE topic_id IN ($topic_id_sql)";

{

message_die(GENERAL_ERROR, 'Could not delete watched post list', '', __LINE__, __FILE__, $sql);

}

$sql = "SELECT *

FROM " . TOPICS_TABLE . "

WHERE topic_id IN ($topic_list)

if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )

{

message_die(GENERAL_ERROR, 'Could not select from topic table', '', __LINE__, __FILE__, $sql);

// Insert topic in the old forum that indicates that the forum has moved.

$sql = "INSERT INTO " . TOPICS_TABLE . " (forum_id, topic_title, topic_poster, topic_time, topic_status, topic_type, topic_vote, topic_views, topic_replies, topic_first_post_id, topic_last_post_id, topic_moved_id)

VALUES ($old_forum_id, '" . addslashes(str_replace("\'", "''", $row[$i]['topic_title'])) . "', '" . str_replace("\'", "''", $row[$i]['topic_poster']) . "', " . $row[$i]['topic_time'] . ", " . TOPIC_MOVED . ", " . POST_NORMAL . ", " . $row[$i]['topic_vote'] . ", " . $row[$i]['topic_views'] . ", " . $row[$i]['topic_replies'] . ", " . $row[$i]['topic_first_post_id'] . ", " . $row[$i]['topic_last_post_id'] . ", $topic_id)";

{

message_die(GENERAL_ERROR, 'Could not insert shadow topic', '', __LINE__, __FILE__, $sql);

}

$sql = "UPDATE " . TOPICS_TABLE . "

SET forum_id = $new_forum_id

WHERE topic_id = $topic_id";

{

message_die(GENERAL_ERROR, 'Could not update old topic', '', __LINE__, __FILE__, $sql);

}

$sql = "UPDATE " . POSTS_TABLE . "

SET forum_id = $new_forum_id

WHERE topic_id = $topic_id";

{

message_die(GENERAL_ERROR, 'Could not update post topic ids', '', __LINE__, __FILE__, $sql);

}

$topic_id = $post_rowset['topic_id'];

$post_time = $post_rowset['post_time'];

if ( empty($post_subject) )

{

message_die(GENERAL_MESSAGE, $lang['Empty_subject']);

AND topic_id = $topic_id";

}

{

message_die(GENERAL_ERROR, 'Could not update posts table', '', __LINE__, __FILE__, $sql);

}

break;

default:

$page_title = $lang['Mod_CP'];

include($phpbb_root_path . 'includes/page_header.'.$phpEx);

}

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

$limit_topics_time = "AND p.post_time >= $min_topic_time";

if ( !empty($HTTP_POST_VARS['topicdays']) )

}

else

{

$limit_topics_time = '';

$topic_days = 0;