global $db;

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

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

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

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

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

$db->sql_freeresult($result);

}

'topic_posts' => 1,

'topic_moved_posts' => 0,

'topic_deleted_posts' => 0,

'topic_first_poster_name' => $username,

'topic_poster' => $user_id,

'topic_last_username' => $username,

$db->sql_handle_data('UPDATE', FORUMS_TABLE, $forum_data, "forum_id = $forum_id");

// we are consistant, victory is ours

}

public function insert_post($data)

{

global $db;

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

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

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

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

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

$db->sql_freeresult($result);

}

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

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

$db->sql_freeresult($result);

}

$db->sql_handle_data('UPDATE', FORUMS_TABLE, $forum_data, "forum_id = $forum_id");

// we are consistant, victory is ours

}

function move_topic($data)

global $db;

// lets get this party started

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

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

WHERE topic_id = ' . $topic_id;

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

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

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

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

$topic_row['topic_deleted_posts'] = (int) $row['topic_deleted_posts'];

$topic_row['topic_unapproved_posts'] = (int) $row['topic_unapproved_posts'];

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

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

FROM ' . FORUMS_TABLE. '

// in hundreds of fewer lines of code, we have now moved a topic

// (this totally ignores the shadow topic thingy, I do not care for now)

}

}