+ global $db, $userdata, $acl, $lang;

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

+ if ( $acl->get_acl($row['forum_id'], 'forum', 'read') && $ignore_forum != $row['forum_id'] )

+ $forum_list = ( $forum_list == '' ) ? '<option value="-1">' . $lang['No_forums'] . '</option>' : '<select name="' . $box_name . '">' . $forum_list . '</select>';

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

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

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

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

+ $db->sql_query($sql);

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

+ $db->sql_query($sql);

+ case 'post':

+ break;

+

+function prune($forum_id, $prune_date)

+{

+ global $db, $lang, $phpEx, $phpbb_root_path;

+

+ require_once($phpbb_root_path . 'includes/functions_posting.'.$phpEx);

+

+ //

+ // Those without polls ...

+ //

+ $sql = "SELECT t.topic_id

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

+ WHERE t.forum_id = $forum_id

+ AND t.topic_vote = 0

+ AND t.topic_type <> " . POST_ANNOUNCE . "

+ AND ( p.post_id = t.topic_last_post_id

+ OR t.topic_last_post_id = 0 )";

+ if ( $prune_date != '' )

+ {

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

+ }

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

+

+ $sql_topics = '';

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

+ {

+ $sql_topics .= ( ( $sql_topics != '' ) ? ', ' : '' ) . $row['topic_id'];

+ }

+

+ if ( $sql_topics != '' )

+ {

+ $sql = "SELECT post_id

+ FROM " . POSTS_TABLE . "

+ WHERE forum_id = $forum_id

+ AND topic_id IN ($sql_topics)";

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

+

+ $sql_post = '';

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

+ {

+ $sql_post .= ( ( $sql_post != '' ) ? ', ' : '' ) . $row['post_id'];

+ }

+

+ if ( $sql_post != '' )

+ {

+ $db->sql_transaction();

+

+ $sql = "DELETE FROM " . TOPICS_TABLE . "

+ WHERE topic_id IN ($sql_topics)";

+ $db->sql_query($sql);

+

+ $pruned_topics = $db->sql_affectedrows();

+

+ $sql = "DELETE FROM " . POSTS_TABLE . "

+ WHERE post_id IN ($sql_post)";

+ $db->sql_query($sql);

+

+ $pruned_posts = $db->sql_affectedrows();

+

+ $sql = "DELETE FROM " . POSTS_TEXT_TABLE . "

+ WHERE post_id IN ($sql_post)";

+ $db->sql_query($sql);

+

+ $sql = "DELETE FROM " . SEARCH_MATCH_TABLE . "

+ WHERE post_id IN ($sql_post)";

+ $db->sql_query($sql);

+

+ remove_search_post($sql_post);

+

+ $db->sql_transaction('commit');

+

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

+ }

+ }

+

+ return array('topics' => 0, 'posts' => 0);

+}

+

+//

+// Function auto_prune(), this function will read the configuration data from

+// the auto_prune table and call the prune function with the necessary info.

+//

+function auto_prune($forum_id = 0)

+{

+ global $db, $lang;

+

+ $sql = "SELECT prune_freq, prune_days

+ FROM " . FORUMS_TABLE . "

+ WHERE forum_id = $forum_id";

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

+

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

+ {

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

+ {

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

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

+

+ prune($forum_id, $prune_date);

+ sync('forum', $forum_id);

+

+ $sql = "UPDATE " . FORUMS_TABLE . "

+ SET prune_next = $next_prune

+ WHERE forum_id = $forum_id";

+ $db->sql_query($sql);

+ }

+ }

+

+ return;

+}

+

+/***************************************************************************

+*

+* These functions are mainly for use in the db_utilities under the admin

+* however in order to make these functions available elsewhere, specifically

+* in the installation phase of phpBB I have seperated out a couple of

+* functions into this file. JLH

+*

+\***************************************************************************/

+

+//

+// remove_comments will strip the sql comment lines out of an uploaded sql file

+// specifically for mssql and postgres type files in the install....

+//

+function remove_comments(&$output)

+{

+ $lines = explode("\n", $output);

+ $output = '';

+

+ // try to keep mem. use down

+ $linecount = count($lines);

+

+ $in_comment = false;

+ for($i = 0; $i < $linecount; $i++)

+ {

+ if ( preg_match('/^\/\*/', preg_quote($lines[$i])) )

+ {

+ $in_comment = true;

+ }

+

+ if ( !$in_comment )

+ {

+ $output .= $lines[$i] . "\n";

+ }

+

+ if ( preg_match('/\*\/$/', preg_quote($lines[$i])) )

+ {

+ $in_comment = false;

+ }

+ }

+

+ unset($lines);

+ return $output;

+}

+

+//

+// remove_remarks will strip the sql comment lines out of an uploaded sql file

+//

+function remove_remarks($sql)

+{

+ $lines = explode("\n", $sql);

+

+ // try to keep mem. use down

+ $sql = '';

+

+ $linecount = count($lines);

+ $output = '';

+

+ for ($i = 0; $i < $linecount; $i++)

+ {

+ if ( $i != $linecount - 1 || strlen($lines[$i]) > 0 )

+ {

+ $output .= ( $lines[$i][0] != '#' ) ? $lines[$i] . "\n" : "\n";

+ // Trading a bit of speed for lower mem. use here.

+ $lines[$i] = '';

+ }

+ }

+

+ return $output;

+

+}

+

+//

+// split_sql_file will split an uploaded sql file into single sql statements.

+// Note: expects trim() to have already been run on $sql.

+//

+function split_sql_file($sql, $delimiter)

+{

+ // Split up our string into "possible" SQL statements.

+ $tokens = explode($delimiter, $sql);

+

+ // try to save mem.

+ $sql = '';

+ $output = array();

+

+ // we don't actually care about the matches preg gives us.

+ $matches = array();

+

+ // this is faster than calling count($oktens) every time thru the loop.

+ $token_count = count($tokens);

+ for ($i = 0; $i < $token_count; $i++)

+ {

+ // Don't wanna add an empty string as the last thing in the array.

+ if ( $i != $token_count - 1 || strlen($tokens[$i] > 0) )

+ {

+ // This is the total number of single quotes in the token.

+ $total_quotes = preg_match_all("/'/", $tokens[$i], $matches);

+ // Counts single quotes that are preceded by an odd number of backslashes,

+ // which means they're escaped quotes.

+ $escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$i], $matches);

+

+ $unescaped_quotes = $total_quotes - $escaped_quotes;

+

+ // If the number of unescaped quotes is even, then the delimiter did NOT occur inside a string literal.

+ if ( !($unescaped_quotes % 2) )

+ {

+ // It's a complete sql statement.

+ $output[] = $tokens[$i];

+ // save memory.

+ $tokens[$i] = '';

+ }

+ else

+ {

+ // incomplete sql statement. keep adding tokens until we have a complete one.

+ // $temp will hold what we have so far.

+ $temp = $tokens[$i] . $delimiter;

+ // save memory..

+ $tokens[$i] = '';

+

+ // Do we have a complete statement yet?

+ $complete_stmt = false;

+

+ for ($j = $i + 1; (!$complete_stmt && ($j < $token_count)); $j++)

+ {

+ // This is the total number of single quotes in the token.

+ $total_quotes = preg_match_all("/'/", $tokens[$j], $matches);

+ // Counts single quotes that are preceded by an odd number of backslashes,

+ // which means they're escaped quotes.

+ $escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$j], $matches);

+

+ $unescaped_quotes = $total_quotes - $escaped_quotes;

+

+ if ( ($unescaped_quotes % 2) == 1 )

+ {

+ // odd number of unescaped quotes. In combination with the previous incomplete

+ // statement(s), we now have a complete statement. (2 odds always make an even)

+ $output[] = $temp . $tokens[$j];

+

+ // save memory.

+ $tokens[$j] = '';

+ $temp = '';

+

+ // exit the loop.

+ $complete_stmt = true;

+ // make sure the outer loop continues at the right point.

+ $i = $j;

+ }

+ else

+ {

+ // even number of unescaped quotes. We still don't have a complete statement.

+ // (1 odd and 1 even always make an odd)

+ $temp .= $tokens[$j] . $delimiter;

+ // save memory.

+ $tokens[$j] = '';

+ }

+

+ } // for..

+ } // else

+ }

+ }

+

+ return $output;

+}

+