static function insert_topic($data)

{

// one transaction, we can now garuntee that atomicity of insertions

$user_id = (int) $data['user_id'];

$forum_id = (int) $data['forum_id'];

$sql = 'SELECT username

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

$sql = 'SELECT forum_topics, forum_unapproved_topics, forum_posts, forum_unapproved_posts

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . (int) $forum_id;

// throw our topic to the dogs

$topic_data = array(

'forum_id' => $forum_id

);

// I suppose it is time to make us a post, no?

$post_data = array(

'forum_id' => $forum_id

);

// time to fill in the blanks

// let's go update the forum table

$forum_data = array(

$forum_data['forum_unapproved_topics'] = ++$row['forum_unapproved_topics'];

}

foreach ($shadow_forums as $shadow_forum_id)

{

}

// we are consistant, victory is ours

}

// inserts a shadow topic into the database

static function insert_shadow_topic($data)

{

// one transaction, we can now garuntee that atomicity of insertions

$user_id = (int) $data['user_id'];

$forum_id = (int) $data['forum_id'];

$sql = 'SELECT username

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

$sql = 'SELECT forum_topics, forum_shadow_topics

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . (int) $forum_id;

// throw our topic to the dogs

$topic_data = array(

'topic_shadow_id' => $shadow_topic_id

);

// let's go update the forum table

$forum_data = array(

$forum_data['forum_unapproved_topics'] = ++$row['forum_unapproved_topics'];

}

// we are consistant, victory is ours

}

static function insert_post($data)

{

// one transaction, we can now garuntee that atomicity of insertions

$user_id = (int) $data['user_id'];

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

$sql = 'SELECT forum_id

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

}

$post_title = $data['title'];

$sql = 'SELECT username

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

// hand holding complete, lets write some posts

$sql = 'SELECT forum_topics, forum_unapproved_topics, forum_posts, forum_unapproved_posts

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . (int) $forum_id;

$post_status = (int) $data['post_status'];

$approved = ($post_status === self::NORMAL);

'post_status' => $post_status,

'forum_id' => $forum_id,

);

// what is the new post_id?

// iceberg ahead! we must only update the topic information if the post is approved ;)

if ($approved)

'topic_last_post_title' => $post_title,

'topic_last_post_time' => $time,

);

}

// let's go update the forum table

$forum_data['forum_unapproved_posts'] = ++$row['forum_unapproved_posts'];

}

// we are consistant, victory is ours

}

static function delete_topic($data)

static function delete_topics($data)

{

// lets get this party started

$topic_ids = array_map('intval', $data['topic_ids']);

// TODO: investigate how aggregate functions can speed this up/reduce the number of results returned/misc. other benefits

$sql = 'SELECT topic_posts, topic_shadow_posts, topic_deleted_posts, topic_unapproved_posts, topic_shadow_id, forum_id, topic_status

FROM ' . TOPICS_TABLE . '

// the following in an array, key'd by forum id that refers to topic rows

$forum_lookup = array();

{

$forum_id = (int) $topic_row['forum_id'];

$forum_lookup[$forum_id]['forum_deleted_topics'] += ($topic_status & self::DELETED);

$forum_lookup[$forum_id]['forum_unapproved_topics'] += ($topic_status & self::UNAPPROVED);

}

// goodnight, topics

// goodnight, posts

$forum_ids = array_keys($forum_lookup);

// what kind of topic is this? lets find out how much we must tamper with the forum table...

$sql = 'SELECT forum_posts, forum_shadow_posts, forum_deleted_posts, forum_unapproved_posts, forum_id

FROM ' . FORUMS_TABLE . '

$forum_rows = array();

{

$forum_id = (int) $forum_row['forum_id'];

$forum_rows[$forum_id] = $forum_row;

}

$shadow_topic_ids = array();

foreach ($forum_rows as $forum_id => $forum_row)

FROM ' . POSTS_TABLE . '

WHERE post_status = ' . self::NORMAL . '

AND forum_id = ' . $forum_id;

// anything left?

if ($row)

$sql = 'SELECT post_username, poster_id, post_subject, post_time

FROM '. POSTS_TABLE . '

WHERE post_id = ' . (int) $row['max_post_id'];

$forum_array['forum_last_user_id'] = (int) $last_post['poster_id'];

$forum_array['forum_last_poster_name'] = $last_post['post_username'];

$forum_array['forum_last_post_time'] = 0;

}

}

// let's not get too hasty, we can kill off the shadows later,

// instead we compose a list of all shadows and then efficiently kill them off :)

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

{

$shadow_topic_ids[] = $row['topic_id'];

}

// recursion, the other white meat.

if (sizeof($shadow_topic_ids))

}

// goodnight, moon

}

static function delete_post($data)

static function delete_posts($data)

{

// lets get this party started

$post_ids = array_map('intval', $data['post_ids']);

$sql = 'SELECT topic_id, post_status, post_id, post_shadow_id, forum_id

FROM ' . POSTS_TABLE . '

// the following arrays are designed to allow for much faster updates

$topic_lookup = array();

$forum_lookup = array();

{

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

$forum_id = (int) $post_row['forum_id'];

$forum_lookup[$topic_id]['forum_deleted_posts'] += ($post_status & self::DELETED);

$forum_lookup[$topic_id]['forum_unapproved_posts'] += ($post_status & self::UNAPPROVED);

}

$topic_ids = array_keys($forum_lookup);

// goodnight, posts

// mangle the forums table

$sql = 'SELECT forum_posts, forum_shadow_posts, forum_deleted_posts, forum_unapproved_posts, forum_id

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $forum_id;

$forum_rows = array();

{

$forum_id = (int) $forum_row['forum_id'];

$forum_rows[$forum_id] = $forum_row;

}

$shadow_topic_ids = array();

foreach ($forum_rows as $forum_id => $forum_row)

FROM ' . POSTS_TABLE . '

WHERE post_status = ' . self::NORMAL . '

AND forum_id = ' . $forum_id;

// anything left?

if ($row)

$sql = 'SELECT post_username, poster_id, post_subject, post_time

FROM '. POSTS_TABLE . '

WHERE post_id = ' . (int) $row['max_post_id'];

$forum_array['forum_last_user_id'] = (int) $last_post['poster_id'];

$forum_array['forum_last_poster_name'] = $last_post['post_username'];

$forum_array['forum_last_post_time'] = 0;

}

}

// mangle the topics table now :)

$sql = 'SELECT topic_posts, topic_shadow_posts, topic_deleted_posts, topic_unapproved_posts, topic_id

FROM ' . TOPICS_TABLE . '

WHERE forum_id = ' . $forum_id;

$topic_rows = array();

{

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

$topic_rows[$topic_id] = $topic_row;

}

$empty_topic_ids = array();

FROM ' . POSTS_TABLE . '

WHERE post_status = ' . self::NORMAL . '

AND topic_id = ' . $topic_id;

// anything left?

if ($row)

$sql = 'SELECT post_username, poster_id, post_subject, post_time

FROM '. POSTS_TABLE . '

WHERE post_id = ' . (int) $row['max_post_id'];

$topic_array['topic_last_user_id'] = (int) $last_post['poster_id'];

$topic_array['topic_last_poster_name'] = $last_post['post_username'];

$empty_topic_ids[] = $topic_id;

}

}

$shadow_post_ids = array();

// instead we compose a list of all shadows and then efficiently kill them off :)

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

{

$shadow_post_ids[] = $row['post_id'];

}

// recursion, the other white meat.

if (sizeof($shadow_topic_ids))

}

// goodnight, moon

}

static function move_topic($data)

static function move_topics($data)

{

// lets get this party started

// all of each are indexed by topic id

$to_forum_ids = $shadow_topic_ids = array();

// let us first determine how many items we are removing from the pool

$sql = 'SELECT topic_posts, topic_shadow_posts, topic_deleted_posts, topic_unapproved_posts, forum_id, topic_status, topic_type, topic_shadow_id, topic_id

FROM ' . TOPICS_TABLE . '

$forum_lookup = array();

{

$topic_id = $topic_row['topic_id'];

$from_forum_id = (int) $topic_row['forum_id'];

$forum_lookup[$to_forum_id][$column] += $topic_row['topic_posts'];

}

}

// determine the totals

$sql = 'SELECT forum_posts, forum_shadow_posts, forum_deleted_posts, forum_unapproved_posts, forum_id, forum_topics, forum_deleted_topics, forum_unapproved_topics

FROM ' . FORUMS_TABLE . '

{

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

foreach ($update_list as $forum_id => $topic_ids)

{

// update the topic itself

// update the posts now

}

// start building the needed arrays for updating the forum data

FROM ' . POSTS_TABLE . '

WHERE post_status = ' . self::NORMAL . '

AND forum_id = ' . $forum_id;

// anything left?

if ($row)

$sql = 'SELECT post_username, poster_id, post_subject, post_time

FROM '. POSTS_TABLE . '

WHERE post_id = ' . (int) $row['max_post_id'];

$forum_data['forum_last_user_id'] = (int) $last_post['poster_id'];

$forum_data['forum_last_poster_name'] = $last_post['post_username'];

}

// update the old forum

}

// hooray for code reuse!

self::insert_shadow_topic($data);

}

}

}