+ // Sync all topics/forums.

+ if($mode == 'topic')

+ {

+ //This can bomb out on a large forum so we're going to split this up.

+ $batch_size = 500;

+

+ //TODO: Fit this into the layout.

+ print "Syncing topics, going to do this in batches (batch size = $batch_size):<br />";

+ $sql = "SELECT

+ MIN(topic_id) AS topic_min,

+ MAX(topic_id) AS topic_max

+ FROM " . TOPICS_TABLE;

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

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

+ $topic_min = $row['topic_min'];

+ $topic_max = $row['topic_max'];

+

+ // Run the batches

+ $batch_start = $topic_min;

+ while($batch_start <= $topic_max)

+ {

+ if (defined('DEBUG_EXTRA'))

+ {

+ print "Syncing topic_id $batch_start to ". ($batch_start+$batch_size) . ". ";

+ print ceil(memory_get_usage()/1024) . " KB<br />\n";

+ flush();

+ }

+ sync('topic', 'range', "topic_id BETWEEN $batch_start AND " . ($batch_start+$batch_size-1));

+

+ $batch_start += $batch_size;

+ }

+ }

+ else

+ {

+ $where_sql = '';

+ $where_sql_and = 'WHERE';

+ }

+ // Only check a range of topics/forums. For instance: 'topic_id BETWEEN 1 AND 60'

+ // Empty array with IDs. This means that we don't have any work to do. Just return.

+ // Limit the topics/forums we are syncing, use specific topic/forum IDs.

+ // $where_type contains the field for the where clause (forum_id, topic_id)

+ // $where_type contains the field for the where clause (forum_id, topic_id)

+ // 1: Get the list of all forums

+ // 2: Get topic counts for each forum

+ // 3: Get post count and last_post_id for each forum

+ // 4: Retrieve last_post infos

+ // 5: Now do that thing

+ // NOTE: 't.post_approved' in the GROUP BY is causing a major slowdown.

+ // These are fields that will be synchronised

+ if (!is_array($rowset))

+ // If false, then $this->message won't be altered, the text will be returned instead.

+ static $match;

+ static $replace;

+

+ if(!is_array($match))

+ {

+ // Be sure to not let the matches cross over. ;)

+

+ // relative urls for this board

+ $match[] = '#(^|[\n ]|\()(' . preg_quote($server_protocol . trim($server_name) . $server_port . preg_replace('/^\/?(.*?)(\/)?$/', '$1', trim($script_path)), '#') . ')/(.*?([^ \t\n\r<"\'\)]*)?)#i';

+ $replace[] = '$1<!-- l --><a href="$2/$3" target="_blank">$3</a><!-- l -->';

+

+ // matches a xxxx://aaaaa.bbb.cccc. ...

+ $match[] = '#(^|[\n ]|\()([\w]+?://.*?([^ \t\n\r<"\'\)]*)?)#ie';

+ $replace[] = "'\$1<!-- m --><a href=\"\$2\" target=\"_blank\">' . ((strlen('\$2') > 55) ? substr('\$2', 0, 39) . ' ... ' . substr('\$2', -10) : '\$2') . '</a><!-- m -->'";

+

+ // matches a "www.xxxx.yyyy[/zzzz]" kinda lazy URL thing

+ $match[] = '#(^|[\n ]|\()(www\.[\w\-]+\.[\w\-.\~]+(?:/[^ \t\n\r<"\'\)]*)?)#ie';

+ $replace[] = "'\$1<!-- w --><a href=\"http://\$2\" target=\"_blank\">' . ((strlen('\$2') > 55) ? substr(str_replace(' ', '%20', '\$2'), 0, 39) . ' ... ' . substr('\$2', -10) : '\$2') . '</a><!-- w -->'";

+

+ // matches an email@domain type address at the start of a line, or after a space.

+ $match[] = '#(^|[\n ]|\()([a-z0-9&\-_.]+?@[\w\-]+\.([\w\-\.]+\.)?[\w]+)#ie';

+ $replace[] = "'\$1<!-- e --><a href=\"mailto:\$2\">' . ((strlen('\$2') > 55) ? substr('\$2', 0, 39) . ' ... ' . substr('\$2', -10) : '\$2') . '</a><!-- e -->'";

+ }

+ static $match;

+ static $replace;

+ // NOTE: There is a memory leak in this block somewhere :\

+ // See if the static arrays have already been filled on an earlier invocation

+ if(!is_array($match))

+ // NOTE: obtain_* function? chaching the table contents?

+

+ // For now setting the ttl to 10 minutes

+ switch (SQL_LAYER)

+ case 'mssql':

+ case 'mssql-odbc':

+ $sql = 'SELECT *

+ FROM ' . SMILIES_TABLE . '

+ ORDER BY LEN(code) DESC';

+ break;

+

+ // LENGTH supported by MySQL, IBM DB2, Oracle and Access for sure...

+ default:

+ $sql = 'SELECT *

+ FROM ' . SMILIES_TABLE . '

+ ORDER BY LENGTH(code) DESC';

+ break;

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

+

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

+ {

+ $match = $replace = array();

+

+ do

+ {

+ // (assertion)

+ $match[] = '#(?<=^|[\n ]|\.)' . preg_quote($row['code'], '#') . '#';

+ $replace[] = '<!-- s' . $row['code'] . ' --><img src="{SMILE_PATH}/' . $row['smile_url'] . '" border="0" alt="' . $row['emoticon'] . '" title="' . $row['emoticon'] . '" /><!-- s' . $row['code'] . ' -->';

+ }

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

+ }

+ else

+ {

+ $match = $replace = array();

+ }

+ $db->sql_freeresult($result);

+ }

+

+ if(count($match))

+ {

+ if (!is_array($drop_char_match))