<?php
/**
 * Main class for WikiForum extension, contains all the logic to manage forums,
 * categories, individual topics, etc.
 *
 * @file
 * @ingroup Extensions
 */
class WikiForumClass {
	private $result = true; // boolean; if true, everything went well

	private $errorTitle = ''; // error page title
	private $errorIcon = ''; // error icon name
	private $errorMessage = ''; // error message

	/**
	 * Find a thread's ID number when you know the title.
	 *
	 * @param $titleText String: thread title
	 * @return Integer: thread ID number
	 */
	public static function findThreadIDByTitle( $titleText ) {
		// Titles are stored with spaces in the DB but the query will otherwise
		// use friggin' underscores...
		$titleText = str_replace( '_', ' ', $titleText );

		$dbr = wfGetDB( DB_SLAVE );
		$res = $dbr->selectRow(
			'wikiforum_threads',
			'wft_thread',
			// Database::makeList calls Database::addQuotes so that we don't
			// need to do it here yet this still is safe
			array( 'wft_thread_name' => $titleText ),
			__METHOD__
		);

		if ( $res ) {
			$threadId = $res->wft_thread;
		} else {
			// Something went wrong...
			$threadId = 0;
		}
		return $threadId;
	}

	/**
	 * Deletes the reply with ID = $replyId.
	 *
	 * @param $replyId Integer: ID number of the reply to delete
	 * @return Boolean: was reply deletion successful or not?
	 */
	function deleteReply( $replyId ) {
		global $wgUser;

		$dbr = wfGetDB( DB_SLAVE );

		$reply = $dbr->fetchObject( $dbr->select(
			'wikiforum_replies',
			array( 'wfr_reply_id', 'wfr_user' ),
			array( 'wfr_deleted' => 0, 'wfr_reply_id' => intval( $replyId ) ),
			__METHOD__
		) );

		if (
			$reply->wfr_reply_id > 0 && $wgUser->getId() > 0 &&
			(
				$wgUser->getId() == $reply->wfr_user ||
				$wgUser->isAllowed( 'wikiforum-moderator' )
			) &&
			!wfReadOnly()
		)
		{
			$dbw = wfGetDB( DB_MASTER );
			$result = $dbw->update(
				'wikiforum_replies',
				array(
					'wfr_deleted' => wfTimestampNow(),
					'wfr_deleted_user' => $wgUser->getId(),
				),
				array(
					'wfr_reply_id' => $reply->wfr_reply_id
				),
				__METHOD__
			);
		} else {
			$result = false;
		}

		if ( $result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-delete' );
			$this->errorMessage = wfMsg( 'wikiforum-error-general' );
		}
		return $result;
	}

	/**
	 * Deletes the thread with ID = $threadId.
	 *
	 * @param $threadId Integer: ID number of the thread to delete
	 * @return Boolean: was thread deletion successful or not?
	 */
	function deleteThread( $threadId ) {
		global $wgUser;

		$dbr = wfGetDB( DB_SLAVE );

		$thread = $dbr->fetchObject( $dbr->select(
			'wikiforum_threads',
			array( 'wft_thread', 'wft_user', 'wft_forum' ),
			array( 'wft_deleted' => 0, 'wft_thread' => intval( $threadId ) ),
			__METHOD__
		) );

		if (
			$thread->wft_thread > 0 && $wgUser->getId() > 0 &&
			( $wgUser->getId() == $thread->wft_user || $wgUser->isAllowed( 'wikiforum-moderator' ) ) &&
			!wfReadOnly()
		)
		{
			$dbw = wfGetDB( DB_MASTER );
			$result = $dbw->update(
				'wikiforum_threads',
				array(
					'wft_deleted' => wfTimestampNow(),
					'wft_deleted_user' => $wgUser->getId(),
				),
				array(
					'wft_thread' => $thread->wft_thread
				),
				__METHOD__
			);
			// Update threads/replies counters
			$replyCount = $dbw->selectField(
				'wikiforum_threads',
				'wft_reply_count',
				array( 'wft_thread' => intval( $thread->wft_thread ) ),
				__METHOD__
			);
			// When the thread we're about to delete is deleted, we also need
			// to update the information about the latest post & its author
			$new = $dbw->select(
				'wikiforum_threads',
				array(
					'wft_last_post_user', 'wft_last_post_timestamp',
				),
				array(
					'wft_forum' => intval( $thread->wft_forum ),
					'wft_deleted' => 0 // 0 means not deleted
				),
				__METHOD__,
				array( 'LIMIT' => 1 )
			);
			$row = $dbw->fetchRow( $new );
			// Update the forum table so that the data shown on
			// Special:WikiForum is up to date
			$dbw->update(
				'wikiforum_forums',
				array(
					"wff_reply_count = wff_reply_count - $replyCount",
					'wff_thread_count = wff_thread_count - 1',
					'wff_last_post_user' => intval( $row['wft_last_post_user'] ),
					'wff_last_post_timestamp' => intval( $row['wft_last_post_timestamp'] )
				),
				array(
					'wff_forum' => intval( $thread->wft_forum )
				),
				__METHOD__
			);
		} else {
			$result = false;
		}

		if ( $result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-delete' );
			$this->errorMessage = wfMsg( 'wikiforum-error-general' );
		}
		return $result;
	}

	/**
	 * Deletes the category with ID = $categoryId.
	 *
	 * @param $categoryId Integer: ID number of the category to delete
	 * @return Boolean: was category deletion successful or not?
	 */
	function deleteCategory( $categoryId ) {
		global $wgUser;

		if (
			$wgUser->isAllowed( 'wikiforum-admin' ) &&
			!wfReadOnly()
		)
		{
			$dbw = wfGetDB( DB_MASTER );
			$result = $dbw->update(
				'wikiforum_category',
				array(
					'wfc_deleted' => wfTimestampNow(),
					'wfc_deleted_user' => $wgUser->getId(),
				),
				array(
					'wfc_category' => intval( $categoryId )
				),
				__METHOD__
			);
		} else {
			$result = false;
		}

		if ( $result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-delete' );
			$this->errorMessage = wfMsg( 'wikiforum-error-general' );
		}
		return $result;
	}

	/**
	 * Deletes the forum with ID = $forumId.
	 *
	 * @param $forumId Integer: ID number of the forum to delete
	 * @return Boolean: was forum deletion successful or not?
	 */
	function deleteForum( $forumId ) {
		global $wgUser;

		if (
			$wgUser->isAllowed( 'wikiforum-admin' ) &&
			!wfReadOnly()
		)
		{
			$dbw = wfGetDB( DB_MASTER );
			$result = $dbw->update(
				'wikiforum_forums',
				array(
					'wff_deleted' => wfTimestampNow(),
					'wff_deleted_user' => $wgUser->getId(),
				),
				array(
					'wff_forum' => intval( $forumId )
				),
				__METHOD__
			);
		} else {
			$result = false;
		}

		if ( $result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-delete' );
			$this->errorMessage = wfMsg( 'wikiforum-error-general' );
		}
		return $result;
	}

	/**
	 * Reopens the thread with ID = $threadId.
	 *
	 * @param $threadId Integer: ID number of the thread to reopen
	 * @return Boolean: was thread reopening successful or not?
	 */
	function reopenThread( $threadId ) {
		global $wgUser;

		$dbr = wfGetDB( DB_SLAVE );

		$thread = $dbr->selectRow(
			'wikiforum_threads',
			'wft_thread',
			array(
				'wft_closed > 0',
				'wft_deleted' => 0,
				'wft_thread' => intval( $threadId )
			),
			__METHOD__
		);

		if (
			$thread->wft_thread > 0 &&
			$wgUser->isAllowed( 'wikiforum-moderator' ) &&
			!wfReadOnly()
		)
		{
			$dbw = wfGetDB( DB_MASTER );
			$result = $dbw->update(
				'wikiforum_threads',
				array(
					'wft_closed' => 0,
					'wft_closed_user' => 0
				),
				array( 'wft_thread' => $thread->wft_thread ),
				__METHOD__
			);
		} else {
			$result = false;
		}

		if ( $result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-thread-reopen' );
			$this->errorMessage = wfMsg( 'wikiforum-error-general' );
		}
		return $result;
	}

	/**
	 * Closes the thread with ID = $threadId.
	 *
	 * @param $threadId Integer: ID number of the thread to close
	 * @return Boolean: was thread closed successfully or not?
	 */
	function closeThread( $threadId ) {
		global $wgUser;

		$dbr = wfGetDB( DB_SLAVE );

		$thread = $dbr->selectRow(
			'wikiforum_threads',
			'wft_thread',
			array(
				'wft_closed' => 0,
				'wft_deleted' => 0,
				'wft_thread' => intval( $threadId )
			),
			__METHOD__
		);

		if (
			$thread->wft_thread > 0 &&
			$wgUser->isAllowed( 'wikiforum-moderator' ) &&
			!wfReadOnly()
		)
		{
			$dbw = wfGetDB( DB_MASTER );
			$result = $dbw->update(
				'wikiforum_threads',
				array(
					'wft_closed' => wfTimestampNow(),
					'wft_closed_user' => $wgUser->getId()
				),
				array( 'wft_thread' => intval( $thread->wft_thread ) ),
				__METHOD__
			);
		} else {
			$result = false;
		}

		if ( $result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-thread-close' );
			$this->errorMessage = wfMsg( 'wikiforum-error-general' );
		}
		return $result;
	}

	/**
	 * Makes the thread with ID = $threadId sticky.
	 *
	 * @param $threadId Integer: ID number of the thread to mark as sticky
	 * @param $value
	 * @return Boolean: was thread deletion successful or not?
	 */
	function makeSticky( $threadId, $value ) {
		global $wgUser;

		$dbr = wfGetDB( DB_SLAVE );

		$thread = $dbr->fetchObject( $dbr->select(
			'wikiforum_threads',
			'wft_thread',
			array( 'wft_deleted' => 0, 'wft_thread' => $threadId ),
			__METHOD__
		) );

		if (
			$thread->wft_thread > 0 &&
			$wgUser->isAllowed( 'wikiforum-admin' ) &&
			!wfReadOnly()
		)
		{
			if ( $value == false ) {
				$value = 0;
			}
			$dbw = wfGetDB( DB_MASTER );
			$result = $dbw->update(
				'wikiforum_threads',
				array( 'wft_sticky' => $value ),
				array( 'wft_thread' => $thread->wft_thread ),
				__METHOD__
			);
		} else {
			$result = false;
		}

		if ( $result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-sticky' );
			$this->errorMessage = wfMsg( 'wikiforum-error-general' );
		}
		return $result;
	}

	function pasteThread( $threadId, $forumId ) {
		global $wgUser;

		$dbr = wfGetDB( DB_SLAVE );

		$thread = $dbr->select(
			'wikiforum_threads',
			'wft_thread',
			array( 'wft_deleted' => 0, 'wft_thread' => intval( $threadId ) ),
			__METHOD__
		);
		$forum = $dbr->select(
			'wikiforum_forums',
			'wff_forum',
			array( 'wff_deleted' => 0, 'wff_forum' => intval( $forumId ) ),
			__METHOD__
		);

		if ( $thread->wft_thread > 0 && $forum->wff_forum > 0 && $wgUser->isAllowed( 'wikiforum-moderator' ) ) {
			if ( $thread->wft_forum != $forum->wff_forum ) {
				$dbw = wfGetDB( DB_MASTER );
				$result = $dbw->update(
					'wikiforum_threads',
					array( 'wft_forum' => $forum->wff_forum ),
					array( 'wft_thread' => $thread->wft_thread ),
					__METHOD__
				);
			} else {
				$result = true;
			}
		} else {
			$result = false;
		}

		if ( $result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-move-thread' );
			$this->errorMessage = wfMsg( 'wikiforum-error-general' );
		}
		return $result;
	}

	function editThread( $threadId, $title, $text ) {
		global $wgUser;

		if (
			$text && $title && strlen( $text ) > 1 &&
			strlen( $title ) > 1
		)
		{
			$dbr = wfGetDB( DB_SLAVE );

			$thread = $dbr->fetchObject( $dbr->select(
				'wikiforum_threads',
				array( 'wft_thread', 'wft_thread_name', 'wft_text', 'wft_user' ),
				array( 'wft_deleted' => 0, 'wft_thread' => $threadId ),
				__METHOD__
			) );

			if ( $thread->wft_thread > 0 ) {
				if (
					$thread->wft_thread_name != $title ||
					$thread->wft_text != $text
				)
				{
					if (
						$wgUser->getId() > 0 &&
						(
							$wgUser->getId() == $thread->wft_user ||
							$wgUser->isAllowed( 'wikiforum-moderator' )
						) &&
						!wfReadOnly()
					)
					{
						$dbw = wfGetDB( DB_MASTER );
						$result = $dbw->update(
							'wikiforum_threads',
							array(
								'wft_thread_name' => $title,
								'wft_text' => $text,
								'wft_edit_timestamp' => wfTimestampNow(),
								'wft_edit_user' => $wgUser->getId()
							),
							array( 'wft_thread' => $thread->wft_thread ),
							__METHOD__
						);
					} else {
						$this->errorMessage = wfMsg( 'wikiforum-error-no-rights' );
						$result = false;
					}
				} else {
					$result = true; // no changes
				}
			} else {
				$this->errorMessage = wfMsg( 'wikiforum-error-not-found' );
				$result = false;
			}

			if ( $result == false ) {
				$this->errorTitle = wfMsg( 'wikiforum-error-edit' );
				if ( $this->errorMessage == '' ) {
					$this->errorMessage = wfMsg( 'wikiforum-error-general' );
				}
			}
		} else {
			if (
				!$text && !$title ||
				strlen( $text ) == 0 && strlen( $title ) == 0
			)
			{
				$result = false;
			} else {
				$this->result = false;
				$result = false;
			}
		}
		return $result;
	}

	function addThread( $forumId, $title, $text ) {
		global $wgUser, $wgWikiForumAllowAnonymous;

		if ( $wgWikiForumAllowAnonymous || $wgUser->isLoggedIn() ) {
			if (
				$forumId > 0 && strlen( $text ) > 1 &&
				// @todo FIXME/CHECKME: use wfMsgForContent()?
				strlen( $title ) > 1 && $title != wfMsg( 'wikiforum-thread-title' )
			)
			{
				$dbr = wfGetDB( DB_SLAVE );

				$overview = $dbr->fetchObject( $dbr->select(
					array( 'wikiforum_forums', 'wikiforum_category' ),
					array( 'wff_forum', 'wff_announcement' ),
					array(
						'wfc_deleted' => 0,
						'wff_deleted' => 0,
						'wfc_category = wff_category',
						'wff_forum' => intval( $forumId )
					),
					__METHOD__
				) );

				if ( $overview->wff_forum > 0 && !wfReadOnly() ) {
					$dbw = wfGetDB( DB_MASTER );
					$timestamp = wfTimestampNow();
					if ( $overview->wff_announcement == false || $wgUser->isAllowed( 'wikiforum-moderator' ) ) {
						$doublepost = $dbr->selectRow(
							'wikiforum_threads',
							'wft_thread AS id',
							array(
								'wft_deleted' => 0,
								'wft_thread_name' => $title,
								'wft_text' => $text,
								'wft_user' => intval( $wgUser->getId() ),
								'wft_forum' => $forumId,
								'wft_posted_timestamp > ' . ( $timestamp - ( 24 * 3600 ) )
							),
							__METHOD__
						);

						if ( $doublepost === false ) {
							$result = $dbw->insert(
								'wikiforum_threads',
								array(
									'wft_thread_name' => $title,
									'wft_text' => $text,
									'wft_posted_timestamp' => $timestamp,
									'wft_user' => intval( $wgUser->getId() ),
									'wft_forum' => $forumId,
									'wft_last_post_timestamp' => $timestamp
								),
								__METHOD__
							);
							if ( $result == true ) {
								$dbw->update(
									'wikiforum_forums',
									array(
										'wff_thread_count = wff_thread_count + 1',
										'wff_last_post_timestamp' => $timestamp,
										'wff_last_post_user' => $wgUser->getId()
									),
									array( 'wff_forum' => $forumId ),
									__METHOD__
								);
								$this->result = true;
							} else {
								$this->result = false;
							}
						} else {
							$this->errorMessage = wfMsg( 'wikiforum-error-double-post' );
							$this->result = false;
						}
					} else {
						$this->errorMessage = wfMsg( 'wikiforum-error-no-rights' );
						$this->result = false;
					}
				} else {
					$this->result = false;
				}
			} else {
				$this->errorMessage = wfMsg( 'wikiforum-error-no-text-or-title' );
				$this->result = false;
			}
		} else {
			$this->errorMessage = wfMsg( 'wikiforum-error-no-rights' );
			$this->result = false;
		}

		if ( $this->result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-add' );
			if ( $this->errorMessage == '' ) {
				$this->errorMessage = wfMsg( 'wikiforum-error-general' );
			}
		}
		return $this->result;
	}

	/**
	 * Edit the reply with ID = $replyId.
	 *
	 * @param $replyId Integer: internal ID number of the reply
	 * @param $text String: new reply text
	 * @return Boolean: did everything go well (true) or not (false)?
	 */
	function editReply( $replyId, $text ) {
		global $wgUser, $wgRequest;

		if ( $text && strlen( $text ) > 1 ) {
			$dbr = wfGetDB( DB_SLAVE );

			$reply = $dbr->fetchObject( $dbr->select(
				'wikiforum_replies',
				array( 'wfr_thread', 'wfr_reply_id', 'wfr_reply_text', 'wfr_user' ),
				array( 'wfr_reply_id' => intval( $replyId ) ),
				__METHOD__
			) );
			$thread = $dbr->fetchObject( $dbr->select(
				'wikiforum_threads',
				array( 'wft_thread', 'wft_closed' ),
				array( 'wft_deleted' => 0, 'wft_thread' => $reply->wfr_thread ),
				__METHOD__
			) );

			if ( $reply->wfr_reply_id > 0 && $thread->wft_thread > 0 ) {
				if ( $reply->wfr_reply_text != $text ) {
					if (
						$wgUser->getId() > 0 &&
						( ( $wgUser->getId() == $reply->wfr_user &&
							$thread->wft_closed == 0 ) ||
							$wgUser->isAllowed( 'wikiforum-moderator' )
						) && !wfReadOnly()
					)
					{
						$dbw = wfGetDB( DB_MASTER );
						$result = $dbw->update(
							'wikiforum_replies',
							array(
								'wfr_reply_text' => $text,
								'wfr_edit_timestamp' => wfTimestampNow(),
								'wfr_edit_user' => $wgUser->getId()
							),
							array( 'wfr_reply_id' => $reply->wfr_reply_id ),
							__METHOD__
						);
					} else {
						$this->errorMessage = wfMsg( 'wikiforum-error-no-rights' );
						$result = false;
					}
				} else {
					$result = true;
				}
			} else {
				$this->errorMessage = wfMsg( 'wikiforum-error-not-found' );
				$result = false;
			}
		} else {
			$form = $wgRequest->getBool( 'form' );
			if ( isset( $form ) && $form == true ) {
				$this->errorMessage = wfMsg( 'wikiforum-error-no-reply' );
				$result = false;
			} else {
				$result = true;
			}
		}

		if ( $result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-edit' );
			if ( $this->errorMessage == '' ) {
				$this->errorMessage = wfMsg( 'wikiforum-error-general' );
			}
		}
		return $result;
	}

	/**
	 * Add a reply with the text $text to the thread with ID = $threadId.
	 *
	 * @param $threadId Integer: internal ID number of the thread to reply to
	 * @param $text String: reply text
	 */
	function addReply( $threadId, $text ) {
		global $wgUser, $wgWikiForumAllowAnonymous;

		$timestamp = wfTimestampNow();

		if ( $wgWikiForumAllowAnonymous || $wgUser->isLoggedIn() ) {
			if ( $threadId > 0 ) {
				if ( strlen( $text ) > 1 ) {
					$dbr = wfGetDB( DB_SLAVE );

					$thread = $dbr->selectRow(
						'wikiforum_threads',
						'wft_thread',
						array(
							'wft_deleted' => 0,
							'wft_closed' => 0,
							'wft_thread' => intval( $threadId )
						),
						__METHOD__
					);

					if ( $thread->wft_thread > 0 && !wfReadOnly() ) {
						$dbw = wfGetDB( DB_MASTER );
						$doublepost = $dbr->selectRow(
							'wikiforum_replies',
							'wfr_reply_id AS id',
							array(
								'wfr_deleted' => 0,
								'wfr_reply_text' => $text,
								'wfr_user' => $wgUser->getId(),
								'wfr_thread' => $thread->wft_thread,
								'wfr_posted_timestamp > ' . ( $timestamp - ( 24 * 3600 ) )
							),
							__METHOD__
						);

						if ( $doublepost === false ) {
							$result = $dbw->insert(
								'wikiforum_replies',
								array(
									'wfr_reply_text' => $text,
									'wfr_posted_timestamp' => $timestamp,
									'wfr_user' => $wgUser->getId(),
									'wfr_thread' => $thread->wft_thread
								),
								__METHOD__
							);

							if ( $result == true ) {
								$dbw->update(
									'wikiforum_threads',
									array(
										'wft_reply_count = wft_reply_count + 1',
										'wft_last_post_timestamp' => $timestamp,
										'wft_last_post_user' => $wgUser->getId()
									),
									array( 'wft_thread' => intval( $threadId ) ),
									__METHOD__
								);

								$pkForum = $dbr->selectRow(
									'wikiforum_threads',
									'wft_forum',
									array( 'wft_thread' => intval( $threadId ) ),
									__METHOD__
								);
								$dbw->update(
									'wikiforum_forums',
									array( 'wff_reply_count = wff_reply_count + 1' ),
									array( 'wff_forum' => intval( $pkForum->wft_forum ) ),
									__METHOD__
								);

								$this->result = true;
							} else {
								$this->result = false;
							}
						} else {
							$this->errorMessage = wfMsg( 'wikiforum-error-double-post' );
							$this->result = false;
						}
					} else {
						$this->errorMessage = wfMsg( 'wikiforum-error-thread-closed' );
						$this->result = false;
					}
				} else {
					$this->errorMessage = wfMsg( 'wikiforum-error-no-reply' );
					$this->result = false;
				}
			} else {
				$this->errorMessage = wfMsg( 'wikiforum-error-not-found' );
				$this->result = false;
			}
		} else {
			$this->errorMessage = wfMsg( 'wikiforum-error-no-rights' );
			$this->result = false;
		}

		if ( $this->result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-add' );
			if ( $this->errorMessage == '' ) {
				$this->errorMessage = wfMsg( 'wikiforum-error-general' );
			}
		}
		return $this->result;
	}

	function addCategory( $categoryName ) {
		global $wgUser;

		if (
			$wgUser->isAllowed( 'wikiforum-admin' ) &&
			!wfReadOnly()
		)
		{
			if ( strlen( $categoryName ) > 0 ) {
				$dbr = wfGetDB( DB_SLAVE );
				$sortkey = $dbr->selectRow(
					'wikiforum_category',
					'MAX(wfc_sortkey) AS the_key',
					array( 'wfc_deleted' => 0 ),
					__METHOD__
				);

				$dbw = wfGetDB( DB_MASTER );
				$this->result = $dbw->insert(
					'wikiforum_category',
					array(
						'wfc_category_name' => $categoryName,
						'wfc_sortkey' => ( $sortkey->the_key + 1 ),
						'wfc_added_timestamp' => wfTimestampNow(),
						'wfc_added_user' => $wgUser->getId()
					),
					__METHOD__
				);
			} else {
				$this->errorMessage = wfMsg( 'wikiforum-no-text-or-title' );
				$this->result = false;
			}
		} else {
			$this->errorMessage = wfMsg( 'wikiforum-error-no-rights' );
			$this->result = false;
		}

		if ( $this->result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-add' );
			if ( $this->errorMessage == '' ) {
				$this->errorMessage = wfMsg( 'wikiforum-error-general' );
			}
		}
		return $this->result;
	}

	function editCategory( $id, $categoryName ) {
		global $wgUser;

		if ( $wgUser->isAllowed( 'wikiforum-admin' ) ) {
			if ( strlen( $categoryName ) > 0 ) {
				$dbr = wfGetDB( DB_SLAVE );

				$category = $dbr->fetchObject( $dbr->select(
					'wikiforum_category',
					array( 'wfc_category', 'wfc_category_name' ),
					array( 'wfc_deleted' => 0, 'wfc_category' => intval( $id ) ),
					__METHOD__
				) );

				if (
					$category->wfc_category > 0 &&
					$category->wfc_category_name != $categoryName &&
					!wfReadOnly()
				)
				{
					$dbw = wfGetDB( DB_MASTER );
					$this->result = $dbw->update(
						'wikiforum_category',
						array(
							'wfc_category_name' => $categoryName,
							'wfc_edited' => wfTimestampNow(),
							'wfc_edited_user' => $wgUser->getId()
						),
						array( 'wfc_category' => intval( $category->wfc_category ) ),
						__METHOD__
					);
				}
			} else {
				$this->errorMessage = wfMsg( 'wikiforum-no-text-or-title' );
				$this->result = false;
			}
		} else {
			$this->errorMessage = wfMsg( 'wikiforum-error-no-rights' );
			$this->result = false;
		}

		if ( $this->result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-edit' );
			if ( $this->errorMessage == '' ) {
				$this->errorMessage = wfMsg( 'wikiforum-error-general' );
			}
		}
		return $this->result;
	}

	function addForum( $categoryId, $forumName, $description, $announcement ) {
		global $wgUser;

		if ( $wgUser->isAllowed( 'wikiforum-admin' ) ) {
			if ( strlen( $forumName ) > 0 ) {
				$dbr = wfGetDB( DB_SLAVE );

				$sortkey = $dbr->selectRow(
					'wikiforum_forums',
					'MAX(wff_sortkey) AS the_key',
					array(
						'wff_deleted' => 0,
						'wff_category' => intval( $categoryId )
					),
					__METHOD__
				);

				$category = $dbr->selectRow(
					'wikiforum_category',
					'wfc_category',
					array(
						'wfc_deleted' => 0,
						'wfc_category' => intval( $categoryId )
					),
					__METHOD__
				);

				if ( $category->wfc_category > 0 && !wfReadOnly() ) {
					$dbw = wfGetDB( DB_MASTER );
					$this->result = $dbw->insert(
						'wikiforum_forums',
						array(
							'wff_forum_name' => $forumName,
							'wff_description' => $description,
							'wff_category' => $category->wfc_category,
							'wff_sortkey' => ( $sortkey->the_key + 1 ),
							'wff_added_timestamp' => wfTimestampNow(),
							'wff_added_user' => $wgUser->getId(),
							'wff_announcement' => $announcement
						),
						__METHOD__
					);
				} else {
					$this->errorMessage = wfMsg( 'wikiforum-error-not-found' );
					$this->result = false;
				}
			} else {
				$this->errorMessage = wfMsg( 'wikiforum-no-text-or-title' );
				$this->result = false;
			}
		} else {
			$this->errorMessage = wfMsg( 'wikiforum-error-no-rights' );
			$this->result = false;
		}

		if ( $this->result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-add' );
			if ( $this->errorMessage == '' ) {
				$this->errorMessage = wfMsg( 'wikiforum-error-general' );
			}
		}
		return $this->result;
	}

	/**
	 * Edit a forum.
	 *
	 * @param $id Integer: internal forum ID number
	 * @param $forumName String: forum name as supplied by the user
	 * @param $description String: forum description as supplied by the user
	 * @param $announcement
	 * @return Boolean: did everything go well (true) or not (false)?
	 */
	function editForum( $id, $forumName, $description, $announcement ) {
		global $wgUser;

		if ( $wgUser->isAllowed( 'wikiforum-admin' ) ) {
			if ( strlen( $forumName ) > 0 ) {
				$dbr = wfGetDB( DB_SLAVE );
				$forum = $dbr->fetchObject( $dbr->select(
					'wikiforum_forums',
					array(
						'wff_forum', 'wff_forum_name', 'wff_description',
						'wff_announcement'
					),
					array( 'wff_deleted' => 0, 'wff_forum' => intval( $id ) ),
					__METHOD__
				) );

				if (
					$forum->wff_forum > 0 &&
					(
						$forum->wff_forum_name != $forumName ||
						$forum->wff_description != $description ||
						$forum->wff_announcement != $announcement
					) && !wfReadOnly()
				)
				{
					$dbw = wfGetDB( DB_MASTER );
					$this->result = $dbw->update(
						'wikiforum_forums',
						array(
							'wff_forum_name' => $forumName,
							'wff_description' => $description,
							'wff_edited_timestamp' => wfTimestampNow(),
							'wff_edited_user' => $wgUser->getId(),
							'wff_announcement' => $announcement
						),
						array( 'wff_forum' => intval( $forum->wff_forum ) ),
						__METHOD__
					);
				}
			} else {
				$this->errorMessage = wfMsg( 'wikiforum-no-text-or-title' );
				$this->result = false;
			}
		} else {
			$this->errorMessage = wfMsg( 'wikiforum-error-no-rights' );
			$this->result = false;
		}

		if ( $this->result == false ) {
			$this->errorTitle = wfMsg( 'wikiforum-error-add' );
			if ( $this->errorMessage == '' ) {
				$this->errorMessage = wfMsg( 'wikiforum-error-general' );
			}
		}
		return $this->result;
	}

	function sortKeys( $id, $type, $direction_up ) {
		global $wgUser;

		if ( $wgUser->isAllowed( 'wikiforum-admin' ) ) {
			$dbr = wfGetDB( DB_SLAVE );

			if ( $type == 'category' ) {
				// in the past, both tables had a SortKey column
				// nowadays the columns are prefixed with an abbreviation
				// of the table name, which is the standard MW convention
				// it also means that we need to figure out wtf the
				// abbreviation is later on in the code...this will make it
				// possible
				$columnPrefix = 'wfc_';

				$fieldname = 'wfc_category';
				$tablename = 'wikiforum_category';
				$sqlData = $dbr->select(
					$tablename,
					array( $fieldname, 'wfc_sortkey' ),
					array( 'wfc_deleted' => 0 ),
					__METHOD__,
					array( 'ORDER BY' => 'wfc_sortkey ASC' )
				);
			} else {
				$columnPrefix = 'wff_';

				$fieldname = 'wff_forum';
				$tablename = 'wikiforum_forums';
				$forum = $dbr->selectRow(
					$tablename,
					'wff_category',
					array( 'wff_deleted' => 0, 'wff_forum' => intval( $id ) ),
					__METHOD__
				);
				$sqlData = $dbr->select(
					$tablename,
					array( $fieldname, 'wff_sortkey' ),
					array(
						'wff_deleted' => 0,
						'wff_category' => $forum->wff_category
					),
					__METHOD__,
					array( 'ORDER BY' => 'wff_sortkey ASC' )
				);
			}

			$i = 0;
			$new_array = array();
			$name = $columnPrefix . 'sortkey';
			foreach ( $sqlData as $entry ) {
				$entry->$name = $i;
				array_push( $new_array, $entry );
				$i++;
			}
			for ( $i = 0; $i < sizeof( $new_array ); $i++ ) {
				if ( $new_array[$i]->$fieldname == $id ) {
					if ( $direction_up == true && $i > 0 ) {
						$new_array[$i]->$name--;
						$new_array[$i - 1]->$name++;
					} elseif ( $direction_up == false && $i + 1 < sizeof( $new_array ) ) {
						$new_array[$i]->$name++;
						$new_array[$i + 1]->$name--;
					}
					$i = sizeof( $new_array );
				}
			}
			$dbw = wfGetDB( DB_MASTER );
			if ( !wfReadOnly() ) {
				foreach ( $new_array as $entry ) {
					$result = $dbw->update(
						$tablename,
						array( $columnPrefix . 'sortkey' => $entry->$name ),
						array( $fieldname => $entry->$fieldname ),
						__METHOD__
					);
				}
			}
		}
	}

	/**
	 * Show an overview of all available categories and their forums.
	 * Used in the special page class.
	 *
	 * @return HTML
	 */
	function showOverview() {
		global $wgOut, $wgUser, $wgLang, $wgScriptPath;

		$output = $this->showFailure();

		$dbr = wfGetDB( DB_SLAVE );
		$sqlCategories = $dbr->select(
			'wikiforum_category',
			'*',
			array( 'wfc_deleted' => 0 ),
			__METHOD__,
			array( 'ORDER BY' => 'wfc_sortkey ASC, wfc_category ASC' )
		);

		// If there is nothing (i.e. this is a brand new installation),
		// display a message instead of an empty page to the users trying
		// to access Special:WikiForum
		// Otherwise give 'em a search box to search the forum because
		// Special:Search doesn't work for WikiForum
		if ( !$dbr->numRows( $sqlCategories ) ) {
			$output .= wfMsgExt( 'wikiforum-forum-is-empty', 'parse' );
		} else {
			$output .= WikiForumGui::getSearchbox();
		}

		$specialPage = SpecialPage::getTitleFor( 'WikiForum' );

		foreach ( $sqlCategories as $cat ) {
			$sqlForums = $dbr->select(
				array( 'wikiforum_forums', 'user' ),
				array( '*', 'user_name' ),
				array( 'wff_deleted' => 0, ' wff_category' => $cat->wfc_category ),
				__METHOD__,
				array( 'ORDER BY' => 'wff_sortkey ASC, wff_forum ASC' ),
				array( 'user' => array( 'LEFT JOIN', 'user_id = wff_last_post_user' ) )
			);

			$menuLink = '';
			$categoryLink = '';

			if ( $wgUser->isAllowed( 'wikiforum-admin' ) ) {
				$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/folder_add.png" title="' . wfMsg( 'wikiforum-add-forum' ) . '" /> ';
				$menuLink = $icon . '<a href="' . $specialPage->escapeFullURL( array( 'addforum' => $cat->wfc_category ) ) . '">' .
					wfMsg( 'wikiforum-add-forum' ) . '</a>';

				$categoryLink = $this->showAdminIcons(
					'category', $cat->wfc_category, true, true
				);
				$output .= WikiForumGui::getHeaderRow( 0, '', 0, '', $menuLink );
			}
			$output .= WikiForumGui::getMainHeader(
				$cat->wfc_category_name,
				wfMsg( 'wikiforum-threads' ),
				wfMsg( 'wikiforum-replies' ),
				wfMsg( 'wikiforum-latest-thread' ),
				$categoryLink
			);

			foreach ( $sqlForums as $forum ) {
				$forum_link = $this->showAdminIcons(
					'forum', $forum->wff_forum, true, true
				);
				$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/folder.png" title="' .
					wfMsg( 'wikiforum-forum-name', $forum->wff_forum_name ) . '" /> ';

				$last_post = '';
				if ( $forum->wff_last_post_timestamp > 0 ) {
					$last_post = wfMsg(
						'wikiforum-by',
						$wgLang->timeanddate( $forum->wff_last_post_timestamp ),
						WikiForumClass::getUserLink( $forum->user_name )
					);
				}

				$output .= WikiForumGui::getMainBody(
					'<p class="mw-wikiforum-issue">' . $icon .
						'<a href="' . $specialPage->escapeFullURL( array( 'forum' => $forum->wff_forum ) ) . '">' .
							$forum->wff_forum_name . '</a></p>' .
						'<p class="mw-wikiforum-descr">' . $forum->wff_description . '</p>',
					$forum->wff_thread_count,
					$forum->wff_reply_count,
					$last_post,
					$forum_link,
					false
				);
			}
			$output .= WikiForumGui::getMainFooter();
		}

		// Forum admins are allowed to add new categories
		if ( $wgUser->isAllowed( 'wikiforum-admin' ) ) {
			$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/database_add.png" title="' . wfMsg( 'wikiforum-add-category' ) . '" /> ';
			$menuLink = $icon . '<a href="' . $specialPage->escapeFullURL( array( 'addcategory' => true ) ) . '">' .
				wfMsg( 'wikiforum-add-category' ) . '</a>';
			$output .= WikiForumGui::getHeaderRow( 0, '', 0, '', $menuLink );
		}

		return $output;
	}

	function showCategory( $categoryId ) {
		global $wgOut, $wgLang, $wgUser, $wgScriptPath;

		$output = $this->showFailure();
		$dbr = wfGetDB( DB_SLAVE );

		$sqlData = $dbr->select(
			'wikiforum_category',
			array( 'wfc_category', 'wfc_category_name' ),
			array( 'wfc_deleted' => 0, 'wfc_category' => intval( $categoryId ) ),
			__METHOD__
		);
		$data_overview = $dbr->fetchObject( $sqlData );

		if ( $data_overview ) {
			$sqlForums = $dbr->select(
				array( 'wikiforum_forums', 'user' ),
				array( '*', 'user_name' ),
				array(
					'wff_deleted' => 0,
					'wff_category' => $data_overview->wfc_category
				),
				__METHOD__,
				array( 'ORDER BY' => 'wff_sortkey ASC, wff_forum ASC' ),
				array( 'user' => array( 'LEFT JOIN', 'user_id = wff_last_post_user' ) )
			);

			$menuLink = '';
			$categoryLink = '';
			$specialPage = SpecialPage::getTitleFor( 'WikiForum' );

			// Forum admins are allowed to add new forums
			if ( $wgUser->isAllowed( 'wikiforum-admin' ) ) {
				$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/folder_add.png" title="' . wfMsg( 'wikiforum-add-forum' ) . '" /> ';
				$menuLink = $icon . '<a href="' . $specialPage->escapeFullURL( array( 'addforum' => $data_overview->wfc_category ) ) . '">' .
					wfMsg( 'wikiforum-add-forum' ) . '</a>';
				$categoryLink = $this->showAdminIcons(
					'category', $data_overview->wfc_category, false, false
				);
			}

			$output .= WikiForumGui::getSearchbox();
			$output .= WikiForumGui::getHeaderRow(
				$data_overview->wfc_category,
				$data_overview->wfc_category_name,
				0,
				'',
				$menuLink
			);
			$output .= WikiForumGui::getMainHeader(
				$data_overview->wfc_category_name,
				wfMsg( 'wikiforum-threads' ),
				wfMsg( 'wikiforum-replies' ),
				wfMsg( 'wikiforum-latest-thread' ),
				$categoryLink
			);

			foreach ( $sqlForums as $forum ) {
				$forum_link = $this->showAdminIcons(
					'forum', $forum->wff_forum, true, true
				);

				$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/folder.png" title="' .
					wfMsg( 'wikiforum-forum-name', $forum->wff_forum_name ) . '" /> ';

				$last_post = '';
				// If there are replies, indicate that somehow...
				// This message will be shown only when there is one reply or
				// more
				if ( $forum->wff_last_post_timestamp > 0 ) {
					$last_post = wfMsg(
						'wikiforum-by',
						$wgLang->timeanddate( $forum->wff_last_post_timestamp ),
						WikiForumClass::getUserLink( $forum->user_name )
					);
				}

				$output .= WikiForumGui::getMainBody(
					'<p class="mw-wikiforum-issue">' . $icon .
						'<a href="' . $specialPage->escapeFullURL( array( 'forum' => $forum->wff_forum ) ) . '">' .
							$forum->wff_forum_name . '</a></p>' .
						'<p class="mw-wikiforum-descr">' . $forum->wff_description . '</p>',
					$forum->wff_thread_count,
					$forum->wff_reply_count,
					$last_post,
					$forum_link,
					false
				);
			}
			$output .= WikiForumGui::getMainFooter();
		} else {
			$this->errorTitle = wfMsg( 'wikiforum-cat-not-found' );
			$this->errorMessage = wfMsg(
				'wikiforum-cat-not-found-text',
				'<a href="' . $specialPage->escapeFullURL() . '">' .
					wfMsg( 'wikiforum-overview' ) . '</a>'
			);
		}
		// Jack: unnecessary duplication of the "Overview" link on the bottom
		// of the page, thus removed
		// $output .= WikiForumGui::getHeaderRow( 0, '', 0, '', '' );
		$output .= $this->showFailure();
		return $output;
	}

	function showForum( $forumId ) {
		global $wgOut, $wgLang, $wgUser, $wgRequest, $wgScriptPath;

		$output = $this->showFailure();
		$dbr = wfGetDB( DB_SLAVE );

		$f_movethread = $wgRequest->getInt( 'movethread' );

		// sorting
		if ( $wgRequest->getVal( 'sd' ) == 'up' ) {
			$sort_direction = 'ASC';
		} else {
			$sort_direction = 'DESC';
		}

		if ( $wgRequest->getVal( 'st' ) == 'answers' ) {
			$sort_type = 'wft_reply_count';
		} elseif ( $wgRequest->getVal( 'st' ) == 'calls' ) {
			$sort_type = 'wft_view_count';
		} elseif ( $wgRequest->getVal( 'st' ) == 'thread' ) {
			$sort_type = 'wft_thread_name';
		} else {
			$sort_type = 'wft_last_post_timestamp';
		}
		// end sorting

		$maxThreadsPerPage = intval( wfMsgForContent( 'wikiforum-max-threads-per-page' ) );

		// limiting
		if ( $maxThreadsPerPage && $wgRequest->getVal( 'lc' ) > 0 ) {
			$limit_count = $wgRequest->getVal( 'lc' );
		} elseif ( $maxThreadsPerPage > 0 ) {
			$limit_count = $maxThreadsPerPage;
		}

		if ( is_numeric( $wgRequest->getVal( 'lp' ) ) ) {
			$limit_page = $wgRequest->getVal( 'lp' ) - 1;
		} else {
			$limit_page = 0;
		}
		// end limiting

		$sqlData = $dbr->select(
			array( 'wikiforum_forums', 'wikiforum_category' ),
			array(
				'wff_forum', 'wff_forum_name', 'wfc_category',
				'wfc_category_name', 'wff_announcement'
			),
			array(
				'wff_deleted' => 0,
				'wfc_deleted' => 0,
				'wff_category = wfc_category',
				'wff_forum' => intval( $forumId )
			),
			__METHOD__
		);
		$data_overview = $dbr->fetchObject( $sqlData );

		$specialPage = SpecialPage::getTitleFor( 'WikiForum' );

		if ( $data_overview ) {
			$options['ORDER BY'] = 'wft_sticky DESC, ' . $sort_type . ' ' . $sort_direction;
			if ( $limit_count > 0 ) {
				$options['LIMIT'] = $limit_count;
				$options['OFFSET'] = $limit_page * $limit_count;
			}
			$forumIdNumber = $data_overview->wff_forum;
			$sqlThreads = $dbr->select(
				array( 'wikiforum_threads', 'user' ),
				array( '*', 'user_name' ),
				array( 'wft_deleted' => 0, 'wft_forum' => $forumIdNumber ),
				__METHOD__,
				$options,
				array( 'user' => array( 'LEFT JOIN', 'user_id = wft_user' ) )
			);

			$button['up'] = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/bullet_arrow_up.png" alt="" />';
			$button['down'] = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/bullet_arrow_down.png" alt="" />';

			// Non-moderators cannot post in an announcement-only forum
			if ( $data_overview->wff_announcement == true && !$wgUser->isAllowed( 'wikiforum-moderator' ) ) {
				$write_thread = '';
			} else {
				$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/note_add.png" title="' . wfMsg( 'wikiforum-write-thread' ) . '" /> ';
				$write_thread = $icon . '<a href="' . $specialPage->escapeFullURL( array( 'writethread' => $forumIdNumber ) ) . '">' .
					wfMsg( 'wikiforum-write-thread' ) . '</a>';
			}

			$output .= WikiForumGui::getSearchbox();
			$output .= WikiForumGui::getHeaderRow(
				$data_overview->wfc_category,
				$data_overview->wfc_category_name,
				$forumIdNumber,
				$data_overview->wff_forum_name,
				$write_thread
			);

			// @todo FIXME: the logic here seems wonky from the end-users point
			// of view and this code is horrible...
			$output .= WikiForumGui::getMainHeader(
				$data_overview->wff_forum_name . ' <a href="' .
					$specialPage->escapeFullURL( array( 'st' => 'thread', 'sd' => 'up', 'forum' => $forumIdNumber ) ) . '">' . $button['up'] .
					'</a><a href="' .
					$specialPage->escapeFullURL( array( 'st' => 'thread', 'sd' => 'down', 'forum' => $forumIdNumber ) ) . '">' . $button['down'] . '</a>',
				wfMsg( 'wikiforum-replies' ) . ' <a href="' .
				$specialPage->escapeFullURL( array( 'st' => 'answers', 'sd' => 'up', 'forum' => $forumIdNumber ) ) . '">' . $button['up'] .
				'</a><a href="' . $specialPage->escapeFullURL( array( 'st' => 'answers', 'sd' => 'down', 'forum' => $forumIdNumber ) ) . '">' . $button['down'] . '</a>',
				wfMsg( 'wikiforum-views' ) . ' <a href="' .
					$specialPage->escapeFullURL( array( 'st' => 'calls', 'sd' => 'up', 'forum' => $forumIdNumber ) ) . '">' . $button['up'] . '</a><a href="' .
					$specialPage->escapeFullURL( array( 'st' => 'calls', 'sd' => 'down', 'forum' => $forumIdNumber ) ) . '">' . $button['down'] . '</a>',
				wfMsg( 'wikiforum-latest-reply' ) . ' <a href="' .
					$specialPage->escapeFullURL( array( 'st' => 'last', 'sd' => 'up', 'forum' => $forumIdNumber ) ) . '">' . $button['up'] .
					'</a><a href="' . $specialPage->escapeFullURL( array( 'st' => 'last', 'sd' => 'up', 'forum' => $forumIdNumber ) ) . '">' . $button['down'] . '</a>',
				false
			);

			$threads_exist = false;
			foreach ( $sqlThreads as $thread ) {
				$threads_exist = true;
				$icon = $this->getThreadIcon(
					$thread->wft_posted_timestamp,
					$thread->wft_closed,
					$thread->wft_sticky
				);

				$last_post = '';
				if ( $thread->wft_reply_count > 0 ) {
					$last_post = wfMsg(
						'wikiforum-by',
						$wgLang->timeanddate( $thread->wft_last_post_timestamp ),
						WikiForumClass::getUserLinkById( $thread->wft_last_post_user )
					);
				}

				if ( $thread->wft_sticky == true ) {
					$sticky = 'sticky';
				} else {
					$sticky = false;
				}

				$output .= WikiForumGui::getMainBody(
					'<p class="mw-wikiforum-thread">' . $icon .
						'<a href="' . $specialPage->escapeFullURL( array( 'thread' => $thread->wft_thread ) ) . '">' .
							htmlspecialchars( $thread->wft_thread_name ) . '</a>
					<p class="mw-wikiforum-descr">' .
						wfMsg(
							'wikiforum-posted',
							$wgLang->timeanddate( $thread->wft_posted_timestamp ),
							WikiForumClass::getUserLink( $thread->user_name )
						) . '</p></p>',
					$thread->wft_reply_count,
					$thread->wft_view_count,
					$last_post,
					false,
					$sticky
				);

			}
			if ( $threads_exist == false ) {
				$output .= WikiForumGui::getSingleLine( wfMsg( 'wikiforum-no-threads' ), 4 );
			}
			$output .= WikiForumGui::getMainFooter();

			$countReplies = '';

			if ( $limit_count > 0 ) {
				$countReplies = $dbr->selectRow(
					'wikiforum_threads',
					array( 'COUNT(*) AS count' ),
					array(
						'wft_deleted' => 0,
						'wft_forum' => intval( $data_overview->wff_forum )
					),
					__METHOD__
				);
				$output .= WikiForumGui::getFooterRow(
					$limit_page,
					( isset( $countReplies->count ) ? $countReplies->count : 0 ),
					$limit_count,
					$data_overview->wff_forum
				);
			}
		} else {
			$this->errorTitle = wfMsg( 'wikiforum-forum-not-found' );
			$this->errorMessage = wfMsg(
				'wikiforum-forum-not-found-text',
				'<a href="' . $specialPage->escapeFullURL() . '">' .
					wfMsg( 'wikiforum-overview' ) . '</a>'
			);
		}

		$pastethread_link = '';
		if ( $f_movethread > 0 ) {
			$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/paste_plain.png" title="' . wfMsg( 'wikiforum-paste-thread' ) . '" /> ';
			$pastethread_link = $icon . '<a href="' . $specialPage->escapeFullURL( array( 'pastethread' => $f_movethread ) ) . '">' . wfMsg( 'wikiforum-paste-thread' ) . '</a> ';
			$output .= WikiForumGui::getHeaderRow( 0, '', 0, '', $pastethread_link );
		}

		$output .= $this->showFailure();
		return $output;
	}

	function showThread( $threadId ) {
		global $wgOut, $wgRequest, $wgUser, $wgLang, $wgScriptPath;

		$output = $this->showFailure();
		$dbr = wfGetDB( DB_SLAVE );

		$sqlData = $dbr->select(
			array( 'wikiforum_forums', 'wikiforum_category', 'wikiforum_threads', 'user' ),
			array(
				'wft_thread', 'wft_thread_name', 'wft_text', 'wff_forum',
				'wff_forum_name', 'wfc_category', 'wfc_category_name',
				'user_name', 'user_id', 'wft_sticky', 'wft_edit_timestamp',
				'wft_edit_user', 'wft_posted_timestamp', 'wft_user',
				'wft_closed', 'wft_closed_user',
			),
			array(
				'wff_deleted' => 0,
				'wfc_deleted' => 0,
				'wft_deleted' => 0,
				'wff_category = wfc_category',
				'wff_forum = wft_forum',
				'wft_thread' => intval( $threadId )
			),
			__METHOD__,
			array(),
			array( 'user' => array( 'LEFT JOIN', 'user_id = wft_user' ) )
		);

		$data_overview = $dbr->fetchObject( $sqlData );

		$maxRepliesPerPage = intval( wfMsgForContent( 'wikiforum-max-replies-per-page' ) );

		// limiting
		if ( $maxRepliesPerPage && $wgRequest->getVal( 'lc' ) > 0 ) {
			$limit_count = $wgRequest->getVal( 'lc' );
		} elseif ( $maxRepliesPerPage > 0 ) {
			$limit_count = $maxRepliesPerPage;
		}

		if ( is_numeric( $wgRequest->getVal( 'lp' ) ) ) {
			$limit_page = $wgRequest->getVal( 'lp' ) - 1;
		} else {
			$limit_page = 0;
		}
		// end limiting

		$specialPage = SpecialPage::getTitleFor( 'WikiForum' );

		if ( $data_overview ) {
			$queryOptions['ORDER BY'] = 'wfr_posted_timestamp ASC';
			if ( $limit_count > 0 ) {
				$queryOptions['LIMIT'] = $limit_count;
				$queryOptions['OFFSET'] = $limit_page * $limit_count;
			}
			$replies = $dbr->select(
				array( 'wikiforum_replies', 'user' ),
				array( '*', 'user_name', 'user_id' ),
				array(
					'wfr_deleted' => 0,
					'wfr_thread' => $data_overview->wft_thread
				),
				__METHOD__,
				$queryOptions,
				array( 'user' => array( 'LEFT JOIN', 'user_id = wfr_user' ) )
			);

			if ( !wfReadOnly() ) {
				$dbw = wfGetDB( DB_MASTER );
				$dbw->update(
					'wikiforum_threads',
					array( 'wft_view_count = wft_view_count + 1' ),
					array( 'wft_thread' => intval( $data_overview->wft_thread ) ),
					__METHOD__
				);
			}

			$editButtons = $this->showThreadButtons(
				$data_overview->wft_user,
				$data_overview->wft_closed,
				$data_overview->wft_thread,
				$data_overview->wff_forum
			);

			$menuLink = '';

			if ( $wgUser->isAllowed( 'wikiforum-admin' ) ) {
				if ( $data_overview->wft_sticky == 1 ) {
					$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/tag_blue_delete.png" title="' . wfMsg( 'wikiforum-remove-sticky' ) . '" /> ';
					$menuLink = $icon . '<a href="' . $specialPage->escapeFullURL( array( 'removesticky' => $data_overview->wft_thread ) ) . '">' .
						wfMsg( 'wikiforum-remove-sticky' ) . '</a> ';
				} else {
					$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/tag_blue_add.png" title="' . wfMsg( 'wikiforum-make-sticky' ) . '" /> ';
					$menuLink = $icon . '<a href="' . $specialPage->escapeFullURL( array( 'makesticky' => $data_overview->wft_thread ) ) . '">' .
							wfMsg( 'wikiforum-make-sticky' ) . '</a> ';
				}
			}

			$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/comment_add.png" title="' . wfMsg( 'wikiforum-write-reply' ) . '" /> ';
			// Replying is only possible to open threads
			if ( $data_overview->wft_closed == 0 ) {
				$menuLink .= $icon . '<a href="#writereply">' .
					wfMsg( 'wikiforum-write-reply' ) . '</a>';
			}

			$posted = wfMsg(
				'wikiforum-posted',
				$wgLang->timeanddate( $data_overview->wft_posted_timestamp ),
				WikiForumClass::getUserLink( $data_overview->user_name )
			);
			if ( $data_overview->wft_edit_timestamp > 0 ) {
				$posted .= '<br /><i>' .
					wfMsg(
						'wikiforum-edited',
						$wgLang->timeanddate( $data_overview->wft_edit_timestamp ),
						WikiForumClass::getUserLinkById( $data_overview->wft_edit_user )
					) . '</i>';
			}

			$output .= WikiForumGui::getSearchbox();
			$output .= WikiForumGui::getHeaderRow(
				$data_overview->wfc_category,
				$data_overview->wfc_category_name,
				$data_overview->wff_forum,
				$data_overview->wff_forum_name,
				$menuLink
			);

			// Add topic name to the title
			// @todo FIXME: this is lame and doesn't apply to the <title> attribute
			$wgOut->setPageTitle( wfMsg( 'wikiforum-topic-name', $data_overview->wft_thread_name ) );

			$output .= WikiForumGui::getThreadHeader(
				htmlspecialchars( $data_overview->wft_thread_name ),
				$this->parseIt( $data_overview->wft_text ),// $wgOut->parse( $data_overview->wft_text ),
				$posted,
				$editButtons,
				$data_overview->wft_thread,
				$data_overview->user_id
			);

			foreach ( $replies as $reply ) {
				$editButtons = $this->showReplyButtons(
					$reply->wfr_user,
					$reply->wfr_reply_id,
					$data_overview->wft_thread,
					$data_overview->wft_closed
				);

				$posted = wfMsg(
					'wikiforum-posted',
					$wgLang->timeanddate( $reply->wfr_posted_timestamp ),
					WikiForumClass::getUserLink( $reply->user_name )
				);
				if ( $reply->wfr_edit_timestamp > 0 ) {
					$posted .= '<br /><i>' .
						wfMsg(
							'wikiforum-edited',
							$wgLang->timeanddate( $reply->wfr_edit_timestamp ),
							WikiForumClass::getUserLinkById( $reply->wfr_edit_user )
						) . '</i>';
				}

				$output .= WikiForumGui::getReply(
					$this->parseIt( $reply->wfr_reply_text ),// $wgOut->parse( $reply->wfr_reply_text ),
					$posted,
					$editButtons,
					$reply->wfr_reply_id,
					$reply->user_id
				);
			}

			$output .= WikiForumGui::getThreadFooter();

			if ( $limit_count > 0 ) {
				$countReplies = $dbr->selectRow(
					'wikiforum_replies',
					'COUNT(*) AS count',
					array(
						'wfr_deleted' => 0,
						'wfr_thread' => $data_overview->wft_thread
					),
					__METHOD__
				);
				$output .= WikiForumGui::getFooterRow(
					$limit_page,
					$countReplies->count,
					$limit_count,
					$data_overview->wff_forum,
					intval( $threadId )
				);
			}

			$mod_editcomment = $wgRequest->getInt( 'editcomment' );
			$mod_form = $wgRequest->getBool( 'form' );
			if (
				$data_overview->wft_closed == 0 ||
				( isset( $mod_editcomment ) && $mod_editcomment > 0 &&
					$mod_form != true &&
					$wgUser->isAllowed( 'wikiforum-moderator' )
				)
			)
			{
				$output .= $this->showEditor( $data_overview->wft_thread, 'addcomment' );
			} else {
				$this->errorTitle = wfMsg( 'wikiforum-thread-closed' );
				$this->errorMessage = wfMsg( 'wikiforum-error-thread-closed' );
				$this->errorIcon = 'lock.png';// 'icon_thread_closed';
			}
		} else {
			$this->errorTitle = wfMsg( 'wikiforum-thread-not-found' );
			$this->errorMessage = wfMsg(
				'wikiforum-thread-not-found-text',
				'<a href="' . $specialPage->escapeFullURL() . '">' .
					wfMsg( 'wikiforum-overview' ) . '</a>'
			);
		}

		$movethread_link = '';
		if ( $wgUser->isAllowed( 'wikiforum-moderator' ) ) {
			$icon = '<img src="' . $wgScriptPath . '/extensions/WikiForum/icons/note_go.png" title="' . wfMsg( 'wikiforum-move-thread' ) . '" /> ';
			$movethread_link = $icon . '<a href="' . $specialPage->escapeFullURL( array( 'movethread' => $data_overview->wft_thread ) ) . '">' . wfMsg( 'wikiforum-move-thread' ) . '</a> ';