[Phpbbkb-checkins] SF.net SVN: phpbbkb: [56] main/trunk

[<so...@us...>]

Revision: 56
          http://svn.sourceforge.net/phpbbkb/?rev=56&view=rev
Author:   softphp
Date:     2007-02-19 07:43:31 -0800 (Mon, 19 Feb 2007)

Log Message:
-----------
-Fixed bugs: #12, #13, #14
-Fixed all urls to be compitable with wiki style.
-Removed the old inclusion files to make room for the wiki style.

Modified Paths:
--------------
    main/trunk/admin/admin_kb.php
    main/trunk/includes/constants.php
    main/trunk/kb.php
    main/trunk/templates/subSilver/kb_viewcat.tpl

Added Paths:
-----------
    main/trunk/includes/auth_kb.php
    main/trunk/includes/functions_kb.php

Removed Paths:
-------------
    main/trunk/kb/auth.php
    main/trunk/kb/constants.php
    main/trunk/kb/functions.php

Modified: main/trunk/admin/admin_kb.php
===================================================================
--- main/trunk/admin/admin_kb.php	2007-02-18 21:43:28 UTC (rev 55)
+++ main/trunk/admin/admin_kb.php	2007-02-19 15:43:31 UTC (rev 56)
@@ -32,8 +32,7 @@
 require('./pagestart.' . $phpEx);
 
 // Get constants and functions
-include($phpbb_root_path . "kb/constants." . $phpEx);
-include($phpbb_root_path . "kb/functions." . $phpEx);
+include($phpbb_root_path . "includes/functions_kb." . $phpEx);
 
 // And language
 include($phpbb_root_path . "language/lang_" . $board_config['default_lang'] . "/lang_kb." . $phpEx);
@@ -200,7 +199,13 @@
 			if($cancel)
 			{
 				// Redirect back to cat page
+				$meta = '<meta http-equiv="refresh" content="0;url=' . append_sid('admin_kb.' . $phpEx . '?mode=cats') . '>"';
 				
+				$template->assign_vars(array(
+					'META' => $meta)
+				);
+						
+				message_die(GENERAL_MESSAGE, '');
 			}
 			elseif(!$confirm)
 			{

Added: main/trunk/includes/auth_kb.php
===================================================================
--- main/trunk/includes/auth_kb.php	                        (rev 0)
+++ main/trunk/includes/auth_kb.php	2007-02-19 15:43:31 UTC (rev 56)
@@ -0,0 +1,188 @@
+<?php
+/***************************************************************************
+ *                               auth.php
+ *                            -------------------
+ *
+ *   copyright: 		phpBB KB Group
+ *   site:			http://www.phpbbknowledgebase.com
+ *   SF Project Page:	http://www.sourceforge.net/projects/phpbbkb
+ *
+ ***************************************************************************/
+
+/***************************************************************************
+ *
+ *   This program is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ ***************************************************************************/
+ 
+// This file holds the kb auth functions, very similar to the phpBB auth functions, but differs certain places :)
+// As of now, the articles auth is handles out from which category it is selected through, therefore an article 
+// can have different kinds of auth, all depending on through which category it is viewed. This solution might seem
+// stupid, but it is the best I can come up with, and I think admins will just take that into consideration when creating
+// category permissions.
+
+//
+// This function returns info on whether the user is allowed to do the supplied argument(s) all dependant on the given category id
+//
+function kb_auth($type, $cat_id, $userdata)
+{
+	switch($type)
+	{
+		case "view":
+			$sql = "a.auth_view";
+			$auth_fields = array('auth_view');
+			break;
+			
+		case "add":
+			$sql = "a.auth_add";
+			$auth_fields = array('auth_add');
+			break;
+			
+		case "edit":
+			$sql = "a.auth_edit";
+			$auth_fields = array('auth_edit');
+			break;
+			
+		case "delete":
+			$sql = "a.auth_delete";
+			$auth_fields = array('auth_delete');
+			break;
+			
+		case "mod":
+			$sql = "a.auth_mod";
+			$auth_fields = array('auth_mod');
+			break;
+			
+		case "comment":
+			$sql = "a.auth_comment";
+			$auth_fields = array('auth_comment');
+			break;
+			
+		case "rate":
+			$sql = "a.auth_rate";
+			$auth_fields = array('auth_rate');
+			break;
+			
+		case "attach":
+			$sql = "a.auth_attach";
+			$auth_fields = array('auth_attach');
+			break;
+			
+		// Returns array containing everything above
+		case "all":
+			$sql = "a.auth_view, a.auth_add, a.auth_edit, a.auth_delete, a.auth_mod, a.auth_comment, a.auth_rate, a.auth_attach";
+			$auth_fields = array('auth_view', 'auth_add', 'auth_edit', 'auth_delete', 'auth_mod', 'auth_comment', 'auth_rate', 'auth_attach');
+			break;
+		
+		// Returns array containing article related auth	
+		case "article":
+			$sql = "a.auth_view, a.auth_edit, a.auth_delete, a.auth_mod, a.auth_comment, a.auth_rate";
+			$auth_fields = array('auth_view', 'auth_edit', 'auth_delete', 'auth_mod', 'auth_comment', 'auth_rate');
+			break;
+			
+		// Returns array containing category related auth
+		case "cat":
+			$sql = "a.auth_view, a.auth_add, a.auth_attach";
+			$auth_fields = array('auth_view', 'auth_add', 'auth_attach');
+			break;
+	}
+	
+	$sql = "SELECT a.cat_id, $sql
+			FROM " . KB_CATEGORIES_TABLE . " a
+			WHERE a.cat_id = '" . $cat_id . "'";
+	
+	if(!$result = $db->sql_query($sql))
+	{
+		message_die(GENERAL_MESSAGE, 'Could not retrieve categorys auth info.', '', __LINE__, __FILE__, $sql);
+	}
+	
+	$f_access = $db->sql_fetchrow($result);
+	
+	//
+	// If user is logged in we need to see if he is in any usergroups that changes his auth info, else just return it
+	//
+	if($userdata['session_logged_in'])
+	{
+		// Check if the user is present in a group that changes his permissions
+		$sql = "SELECT a.cat_id, $sql, a.auth_mod 
+			FROM " . KB_AUTH_ACCESS_TABLE . " a, " . USER_GROUP_TABLE . " ug 
+			WHERE ug.user_id = ".$userdata['user_id']. " 
+				AND ug.user_pending = 0 
+				AND a.group_id = ug.group_id
+				AND a.cat_id = '" . $cat_id . "'";
+		if ( !($result = $db->sql_query($sql)) )
+		{
+			message_die(GENERAL_ERROR, 'Failed obtaining category access control lists', '', __LINE__, __FILE__, $sql);
+		}
+
+		if ( $row = $db->sql_fetchrow($result) )
+		{
+			do
+			{
+				$u_access[] = $row;
+			}
+			while( $row = $db->sql_fetchrow($result) );
+		}
+		$db->sql_freeresult($result);
+	}
+	
+	$is_admin = ( $userdata['user_level'] == ADMIN && $userdata['session_logged_in'] ) ? TRUE : 0;
+	
+	$auth = array();
+	for($i = 0; $i < count($auth_fields); $i++)
+	{
+		$key = $auth_fields[$i];
+
+		//
+		// If the user is logged on and the forum type is either ALL or REG then the user has access
+		//
+		// If the type if ACL, MOD or ADMIN then we need to see if the user has specific permissions
+		// to do whatever it is they want to do ... to do this we pull relevant information for the
+		// user (and any groups they belong to)
+		//
+		// Now we compare the users access level against the forums. We assume here that a moderator
+		// and admin automatically have access to an ACL forum, similarly we assume admins meet an
+		// auth requirement of MOD
+		//
+		$value = $f_access[$key];
+
+		switch( $value )
+		{
+			case AUTH_ALL:
+				$auth[$key] = TRUE;
+				$auth[$key . '_type'] = $lang['Auth_Anonymous_Users'];
+				break;
+
+			case AUTH_REG:
+				$auth_user[$key] = ( $userdata['session_logged_in'] ) ? TRUE : 0;
+				$auth_user[$key . '_type'] = $lang['Auth_Registered_Users'];
+				break;
+
+			case AUTH_ACL:
+				$auth[$key] = ( $userdata['session_logged_in'] ) ? auth_check_user(AUTH_ACL, $key, $u_access, $is_admin) : 0;
+				$auth[$key . '_type'] = $lang['Auth_Users_granted_access'];
+				break;
+
+			case AUTH_MOD:
+				$auth[$key] = ( $userdata['session_logged_in'] ) ? auth_check_user(AUTH_MOD, 'auth_mod', $u_access, $is_admin) : 0;
+				$auth[$key . '_type'] = $lang['Auth_Moderators'];
+				break;
+
+			case AUTH_ADMIN:
+				$auth[$key] = $is_admin;
+				$auth[$key . '_type'] = $lang['Auth_Administrators'];
+				break;
+
+			default:
+				$auth[$key] = 0;
+				break;
+		}
+	}
+	
+	return $auth;	
+}
+
+?>

Modified: main/trunk/includes/constants.php
===================================================================
--- main/trunk/includes/constants.php	2007-02-18 21:43:28 UTC (rev 55)
+++ main/trunk/includes/constants.php	2007-02-19 15:43:31 UTC (rev 56)
@@ -1,186 +1,198 @@
-<?php
-/***************************************************************************
- *                               constants.php
- *                            -------------------
- *   begin                : Saturday', Feb 13', 2001
- *   copyright            : ('C) 2001 The phpBB Group
- *   email                : su...@ph...
- *
- *   $Id: constants.php,v 1.47.2.6 2005/10/30 15:17:14 acydburn Exp $
- *
- *
- ***************************************************************************/
-
-/***************************************************************************
- *
- *   This program is free software; you can redistribute it and/or modify
- *   it under the terms of the GNU General Public License as published by
- *   the Free Software Foundation; either version 2 of the License', or
- *   ('at your option) any later version.
- *
- ***************************************************************************/
-
-if ( !defined('IN_PHPBB') )
-{
-	die("Hacking attempt");
-}
-
-// Debug Level
-//define('DEBUG', 1); // Debugging on
-define('DEBUG', 1); // Debugging off
-
-
-// User Levels <- Do not change the values of USER or ADMIN
-define('DELETED', -1);
-define('ANONYMOUS', -1);
-
-define('USER', 0);
-define('ADMIN', 1);
-define('MOD', 2);
-
-
-// User related
-define('USER_ACTIVATION_NONE', 0);
-define('USER_ACTIVATION_SELF', 1);
-define('USER_ACTIVATION_ADMIN', 2);
-
-define('USER_AVATAR_NONE', 0);
-define('USER_AVATAR_UPLOAD', 1);
-define('USER_AVATAR_REMOTE', 2);
-define('USER_AVATAR_GALLERY', 3);
-
-
-// Group settings
-define('GROUP_OPEN', 0);
-define('GROUP_CLOSED', 1);
-define('GROUP_HIDDEN', 2);
-
-
-// Forum state
-define('FORUM_UNLOCKED', 0);
-define('FORUM_LOCKED', 1);
-
-
-// Topic status
-define('TOPIC_UNLOCKED', 0);
-define('TOPIC_LOCKED', 1);
-define('TOPIC_MOVED', 2);
-define('TOPIC_WATCH_NOTIFIED', 1);
-define('TOPIC_WATCH_UN_NOTIFIED', 0);
-
-
-// Topic types
-define('POST_NORMAL', 0);
-define('POST_STICKY', 1);
-define('POST_ANNOUNCE', 2);
-define('POST_GLOBAL_ANNOUNCE', 3);
-
-
-// SQL codes
-define('BEGIN_TRANSACTION', 1);
-define('END_TRANSACTION', 2);
-
-
-// Error codes
-define('GENERAL_MESSAGE', 200);
-define('GENERAL_ERROR', 202);
-define('CRITICAL_MESSAGE', 203);
-define('CRITICAL_ERROR', 204);
-
-
-// Private messaging
-define('PRIVMSGS_READ_MAIL', 0);
-define('PRIVMSGS_NEW_MAIL', 1);
-define('PRIVMSGS_SENT_MAIL', 2);
-define('PRIVMSGS_SAVED_IN_MAIL', 3);
-define('PRIVMSGS_SAVED_OUT_MAIL', 4);
-define('PRIVMSGS_UNREAD_MAIL', 5);
-
-
-// URL PARAMETERS
-define('POST_TOPIC_URL', 't');
-define('POST_CAT_URL', 'c');
-define('POST_FORUM_URL', 'f');
-define('POST_USERS_URL', 'u');
-define('POST_POST_URL', 'p');
-define('POST_GROUPS_URL', 'g');
-
-// Session parameters
-define('SESSION_METHOD_COOKIE', 100);
-define('SESSION_METHOD_GET', 101);
-
-
-// Page numbers for session handling
-define('PAGE_INDEX', 0);
-define('PAGE_LOGIN', -1);
-define('PAGE_SEARCH', -2);
-define('PAGE_REGISTER', -3);
-define('PAGE_PROFILE', -4);
-define('PAGE_VIEWONLINE', -6);
-define('PAGE_VIEWMEMBERS', -7);
-define('PAGE_FAQ', -8);
-define('PAGE_POSTING', -9);
-define('PAGE_PRIVMSGS', -10);
-define('PAGE_GROUPCP', -11);
-define('PAGE_TOPIC_OFFSET', 5000);
-define('PAGE_KB', -1345); // http://www.phpbb.com/kb/article.php?article_id=149
-
-
-// Auth settings
-define('AUTH_LIST_ALL', 0);
-define('AUTH_ALL', 0);
-
-define('AUTH_REG', 1);
-define('AUTH_ACL', 2);
-define('AUTH_MOD', 3);
-define('AUTH_ADMIN', 5);
-
-define('AUTH_VIEW', 1);
-define('AUTH_READ', 2);
-define('AUTH_POST', 3);
-define('AUTH_REPLY', 4);
-define('AUTH_EDIT', 5);
-define('AUTH_DELETE', 6);
-define('AUTH_ANNOUNCE', 7);
-define('AUTH_STICKY', 8);
-define('AUTH_POLLCREATE', 9);
-define('AUTH_VOTE', 10);
-define('AUTH_ATTACH', 11);
-
-
-// Table names
-define('CONFIRM_TABLE', $table_prefix.'confirm');
-define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access');
-define('BANLIST_TABLE', $table_prefix.'banlist');
-define('CATEGORIES_TABLE', $table_prefix.'categories');
-define('CONFIG_TABLE', $table_prefix.'config');
-define('DISALLOW_TABLE', $table_prefix.'disallow');
-define('FORUMS_TABLE', $table_prefix.'forums');
-define('GROUPS_TABLE', $table_prefix.'groups');
-define('POSTS_TABLE', $table_prefix.'posts');
-define('POSTS_TEXT_TABLE', $table_prefix.'posts_text');
-define('PRIVMSGS_TABLE', $table_prefix.'privmsgs');
-define('PRIVMSGS_TEXT_TABLE', $table_prefix.'privmsgs_text');
-define('PRIVMSGS_IGNORE_TABLE', $table_prefix.'privmsgs_ignore');
-define('PRUNE_TABLE', $table_prefix.'forum_prune');
-define('RANKS_TABLE', $table_prefix.'ranks');
-define('SEARCH_TABLE', $table_prefix.'search_results');
-define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist');
-define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');
-define('SESSIONS_TABLE', $table_prefix.'sessions');
-define('SESSIONS_KEYS_TABLE', $table_prefix.'sessions_keys');
-define('SMILIES_TABLE', $table_prefix.'smilies');
-define('THEMES_TABLE', $table_prefix.'themes');
-define('THEMES_NAME_TABLE', $table_prefix.'themes_name');
-define('TOPICS_TABLE', $table_prefix.'topics');
-define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');
-define('USER_GROUP_TABLE', $table_prefix.'user_group');
-define('USERS_TABLE', $table_prefix.'users');
-define('WORDS_TABLE', $table_prefix.'words');
-define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
-define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
-define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
-
-
-
+<?php
+/***************************************************************************
+ *                               constants.php
+ *                            -------------------
+ *   begin                : Saturday', Feb 13', 2001
+ *   copyright            : ('C) 2001 The phpBB Group
+ *   email                : su...@ph...
+ *
+ *   $Id: constants.php,v 1.47.2.6 2005/10/30 15:17:14 acydburn Exp $
+ *
+ *
+ ***************************************************************************/
+
+/***************************************************************************
+ *
+ *   This program is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License', or
+ *   ('at your option) any later version.
+ *
+ ***************************************************************************/
+
+if ( !defined('IN_PHPBB') )
+{
+	die("Hacking attempt");
+}
+
+// Debug Level
+//define('DEBUG', 1); // Debugging on
+define('DEBUG', 1); // Debugging off
+
+
+// User Levels <- Do not change the values of USER or ADMIN
+define('DELETED', -1);
+define('ANONYMOUS', -1);
+
+define('USER', 0);
+define('ADMIN', 1);
+define('MOD', 2);
+
+
+// User related
+define('USER_ACTIVATION_NONE', 0);
+define('USER_ACTIVATION_SELF', 1);
+define('USER_ACTIVATION_ADMIN', 2);
+
+define('USER_AVATAR_NONE', 0);
+define('USER_AVATAR_UPLOAD', 1);
+define('USER_AVATAR_REMOTE', 2);
+define('USER_AVATAR_GALLERY', 3);
+
+
+// Group settings
+define('GROUP_OPEN', 0);
+define('GROUP_CLOSED', 1);
+define('GROUP_HIDDEN', 2);
+
+
+// Forum state
+define('FORUM_UNLOCKED', 0);
+define('FORUM_LOCKED', 1);
+
+
+// Topic status
+define('TOPIC_UNLOCKED', 0);
+define('TOPIC_LOCKED', 1);
+define('TOPIC_MOVED', 2);
+define('TOPIC_WATCH_NOTIFIED', 1);
+define('TOPIC_WATCH_UN_NOTIFIED', 0);
+
+
+// Topic types
+define('POST_NORMAL', 0);
+define('POST_STICKY', 1);
+define('POST_ANNOUNCE', 2);
+define('POST_GLOBAL_ANNOUNCE', 3);
+
+
+// SQL codes
+define('BEGIN_TRANSACTION', 1);
+define('END_TRANSACTION', 2);
+
+
+// Error codes
+define('GENERAL_MESSAGE', 200);
+define('GENERAL_ERROR', 202);
+define('CRITICAL_MESSAGE', 203);
+define('CRITICAL_ERROR', 204);
+
+
+// Private messaging
+define('PRIVMSGS_READ_MAIL', 0);
+define('PRIVMSGS_NEW_MAIL', 1);
+define('PRIVMSGS_SENT_MAIL', 2);
+define('PRIVMSGS_SAVED_IN_MAIL', 3);
+define('PRIVMSGS_SAVED_OUT_MAIL', 4);
+define('PRIVMSGS_UNREAD_MAIL', 5);
+
+
+// URL PARAMETERS
+define('POST_TOPIC_URL', 't');
+define('POST_CAT_URL', 'c');
+define('POST_FORUM_URL', 'f');
+define('POST_USERS_URL', 'u');
+define('POST_POST_URL', 'p');
+define('POST_GROUPS_URL', 'g');
+
+// Session parameters
+define('SESSION_METHOD_COOKIE', 100);
+define('SESSION_METHOD_GET', 101);
+
+
+// Page numbers for session handling
+define('PAGE_INDEX', 0);
+define('PAGE_LOGIN', -1);
+define('PAGE_SEARCH', -2);
+define('PAGE_REGISTER', -3);
+define('PAGE_PROFILE', -4);
+define('PAGE_VIEWONLINE', -6);
+define('PAGE_VIEWMEMBERS', -7);
+define('PAGE_FAQ', -8);
+define('PAGE_POSTING', -9);
+define('PAGE_PRIVMSGS', -10);
+define('PAGE_GROUPCP', -11);
+define('PAGE_TOPIC_OFFSET', 5000);
+define('PAGE_KB', -1345); // http://www.phpbb.com/kb/article.php?article_id=149
+
+
+// Auth settings
+define('AUTH_LIST_ALL', 0);
+define('AUTH_ALL', 0);
+
+define('AUTH_REG', 1);
+define('AUTH_ACL', 2);
+define('AUTH_MOD', 3);
+define('AUTH_ADMIN', 5);
+
+define('AUTH_VIEW', 1);
+define('AUTH_READ', 2);
+define('AUTH_POST', 3);
+define('AUTH_REPLY', 4);
+define('AUTH_EDIT', 5);
+define('AUTH_DELETE', 6);
+define('AUTH_ANNOUNCE', 7);
+define('AUTH_STICKY', 8);
+define('AUTH_POLLCREATE', 9);
+define('AUTH_VOTE', 10);
+define('AUTH_ATTACH', 11);
+
+
+// Table names
+define('CONFIRM_TABLE', $table_prefix.'confirm');
+define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access');
+define('BANLIST_TABLE', $table_prefix.'banlist');
+define('CATEGORIES_TABLE', $table_prefix.'categories');
+define('CONFIG_TABLE', $table_prefix.'config');
+define('DISALLOW_TABLE', $table_prefix.'disallow');
+define('FORUMS_TABLE', $table_prefix.'forums');
+define('GROUPS_TABLE', $table_prefix.'groups');
+define('POSTS_TABLE', $table_prefix.'posts');
+define('POSTS_TEXT_TABLE', $table_prefix.'posts_text');
+define('PRIVMSGS_TABLE', $table_prefix.'privmsgs');
+define('PRIVMSGS_TEXT_TABLE', $table_prefix.'privmsgs_text');
+define('PRIVMSGS_IGNORE_TABLE', $table_prefix.'privmsgs_ignore');
+define('PRUNE_TABLE', $table_prefix.'forum_prune');
+define('RANKS_TABLE', $table_prefix.'ranks');
+define('SEARCH_TABLE', $table_prefix.'search_results');
+define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist');
+define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');
+define('SESSIONS_TABLE', $table_prefix.'sessions');
+define('SESSIONS_KEYS_TABLE', $table_prefix.'sessions_keys');
+define('SMILIES_TABLE', $table_prefix.'smilies');
+define('THEMES_TABLE', $table_prefix.'themes');
+define('THEMES_NAME_TABLE', $table_prefix.'themes_name');
+define('TOPICS_TABLE', $table_prefix.'topics');
+define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');
+define('USER_GROUP_TABLE', $table_prefix.'user_group');
+define('USERS_TABLE', $table_prefix.'users');
+define('WORDS_TABLE', $table_prefix.'words');
+define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
+define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
+define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
+
+// KB Constants
+// All constants here
+// DB Tables
+define('KB_CATEGORIES_TABLE', $table_prefix . "kb_categories");
+define('KB_ARTICLES_TABLE', $table_prefix . "kb_articles");
+define('KB_ARTICLECATS_TABLE', $table_prefix . "kb_articlecats"); // For Multiple cats
+define('KB_AUTH_ACCESS', $table_prefix . "kb_auth_access");
+
+// Article Status
+define('KB_STATUS_NOT_ASSIGNED', 0);
+define('KB_STATUS_ASSIGNED', 1);
+define('KB_STATUS_REVIEW_IN_PROGRESS', 3);
+define('KB_STATUS_ACCEPTED', 4);
+define('KB_STATUS_REJECTED', 5);
 ?>
\ No newline at end of file

Added: main/trunk/includes/functions_kb.php
===================================================================
--- main/trunk/includes/functions_kb.php	                        (rev 0)
+++ main/trunk/includes/functions_kb.php	2007-02-19 15:43:31 UTC (rev 56)
@@ -0,0 +1,1009 @@
+<?php
+/***************************************************************************
+ *                               functions.php
+ *                            -------------------
+ *
+ *   copyright: 	  phpBB KB Group
+ *   site:			  http://www.phpbbknowledgebase.com
+ *   SF Project Page: http://www.sourceforge.net/projects/phpbbkb
+ *
+ ***************************************************************************/
+
+/***************************************************************************
+ *
+ *   This program is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ ***************************************************************************/
+
+if (!defined('IN_PHPBB'))
+{
+	die('Hacking attempt');
+}
+
+// This function creates the navigation line based on a few parameters
+function create_navigation($type = "main", $id_ary = array())
+{
+	global $db, $template, $lang, $board_config, $phpEx;
+	
+	switch($type)
+	{
+		case "ucp":
+			// Different kind of subcategories
+			switch($id_ary)
+			{
+				case "post_article":
+					$navigation = '<span class="nav">&nbsp;&nbsp;&nbsp;<a href="' . append_sid('kb.' . $phpEx) . '" class="nav">' . $lang['kb_main'] . '</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx . '?ucp=post_article') . '">' . $lang['kb_ucp_articlepost'] .'</a></span>';
+					break;
+					
+				case "edit_article":
+					$navigation = '<span class="nav">&nbsp;&nbsp;&nbsp;<a href="' . append_sid('kb.' . $phpEx) . '" class="nav">' . $lang['kb_main'] . '</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx . '?ucp=edit_article') . '">' . $lang['kb_ucp_articleedit'] .'</a></span>';
+					break;
+					
+				default:
+					break;
+			}
+			break;
+			
+		case "viewcat":
+			// View category
+			// id = $cat_id::$cat_name
+			$navigation = '<span class="nav">&nbsp;&nbsp;&nbsp;<a href="' . append_sid('kb.' . $phpEx) . '" class="nav">' . $lang['kb_main'] . '</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx.'?pid=view_cat&amp;id='. $id_ary[0]) . '">' . $id_ary[1] .'</a></span>';
+			break;
+			
+		case "viewsubcat":
+			// View subcategory
+			// id = $cat_id::$cat_name::$maincat_id
+			$sql = "SELECT cat_title
+					FROM " . KB_CATEGORIES_TABLE . "
+					WHERE cat_id = '" . $id_ary[2] . "'";
+			if( !($result = $db->sql_query($sql)) )
+			{
+				message_die(GENERAL_ERROR, 'Could not query cat name.', '', __LINE__, __FILE__, $sql);
+			}
+			$maincat = $db->sql_fetchrow($result);
+			$navigation = '<span class="nav">&nbsp;&nbsp;&nbsp;<a href="' . append_sid('kb.' . $phpEx) . '" class="nav">' . $lang['kb_main'] . '</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx.'?cat_id=' . $id_ary[2]) . '">' . $maincat['cat_title'] .'</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx.'?cat_id=' . $id_ary[0]) . '">' . $id_ary[1] .'</a></span>';
+			break;
+			
+		case "viewarticle":
+			// Viewing an article
+			if($id_ary[2] == 0)
+			{
+				$navigation = '<span class="nav">&nbsp;&nbsp;&nbsp;<a href="' . append_sid('kb.' . $phpEx) . '" class="nav">' . $lang['kb_main'] . '</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx.'?cat_id=' . $id_ary[0]) . '">' . $id_ary[1] .'</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx.'?cat_id=' . $id_ary[0] . '&amp;article=' . wiki_article_title($id_ary[4])) . '">' . $id_ary[4] .'</a></span>';
+			}
+			else
+			{
+				$sql = "SELECT cat_title
+					FROM " . KB_CATEGORIES_TABLE . "
+					WHERE cat_id = '" . $id_ary[2] . "'";
+				if( !($result = $db->sql_query($sql)) )
+				{
+					message_die(GENERAL_ERROR, 'Could not query cat name.', '', __LINE__, __FILE__, $sql);
+				}
+				$maincat = $db->sql_fetchrow($result);
+				$navigation = '<span class="nav">&nbsp;&nbsp;&nbsp;<a href="' . append_sid('kb.' . $phpEx) . '" class="nav">' . $lang['kb_main'] . '</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx.'?pid=cat_id=' . $id_ary[2]) . '">' . $maincat['cat_title'] .'</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx.'?pid=cat_id=' . $id_ary[0]) . '">' . $id_ary[1] .'</a> -> <a class="nav" href="' . append_sid('kb.' . $phpEx.'?pid=cat_id=' . $id_ary[0] . '&amp;article=' . wiki_article_title($id_ary[4])) . '">' . $id_ary[4] .'</a></span>';
+			}
+			break;
+			
+		case "search":
+			// viewing search results or page
+			break;
+		
+		case "main":
+		default:
+			$navigation = '<span class="nav">&nbsp;&nbsp;&nbsp;<a href="' . append_sid('kb.' . $phpEx) . '" class="nav">' . $lang['kb_main'] . '</a></span>';
+			break;
+	}
+	
+	$template->assign_vars(array(
+		'NAVIGATION' => $navigation)
+	);
+	
+	return;
+}
+
+function get_cats_structure()
+{
+	global $db;
+	
+	$cats = array();
+	$sql = "SELECT *
+			FROM " . KB_CATEGORIES_TABLE . "
+			WHERE cat_main = '0'
+			ORDER BY cat_order ASC";
+	if( !($result = $db->sql_query($sql)) )
+	{
+		message_die(GENERAL_ERROR, 'Could not query cats.', '', __LINE__, __FILE__, $sql);
+	}
+	
+	$i = 0;
+	while($row = $db->sql_fetchrow($result))
+	{
+		$cats[$i] = $row;
+		
+		$sql = "SELECT *
+				FROM " . KB_CATEGORIES_TABLE . "
+				WHERE cat_main = '" . $row['cat_id'] . "'
+				ORDER BY cat_order ASC";
+		if( !($subcat_result = $db->sql_query($sql)) )
+		{
+			message_die(GENERAL_ERROR, 'Could not query subcats.', '', __LINE__, __FILE__, $sql);
+		}
+		
+		$cats[$i]['subcats'] = array();
+		while($row2 = $db->sql_fetchrow($subcat_result))
+		{
+			$cats[$i]['subcats'][] = $row2;
+		}
+		$i++;
+	}
+	
+	return $cats;
+}
+
+function get_kb_config()
+{
+	// Using normal db table with kb_prefix
+	global $db;
+	
+	$sql = "SELECT *
+		FROM " . CONFIG_TABLE;
+	if(!$result = $db->sql_query($sql))
+	{
+		message_die(CRITICAL_ERROR, "Could not query config information in admin_board", "", __LINE__, __FILE__, $sql);
+	}
+	
+	$config = array();
+	while($row = $db->fetchrow($result))
+	{
+		// Detect if it has a kb_ in it and strip it
+		if(strstr('kb_', $row['config_name']))
+		{
+			$name = str_replace("kb_", "", $row['config_name']);
+			$config[$name] = $row['config_value'];
+		}
+	}
+	
+	return $config;
+}
+
+////////////////////////////////////////
+///          UCP FUNCTIONS           ///
+////////////////////////////////////////
+function ucp_generate_page_title($action)
+{
+	global $lang;
+	
+	$title = $lang['kb_ucp'];
+	switch($action)
+	{
+		case "articles":
+			break;
+		
+		case "comments":
+			break;
+		
+		case "post_article":
+			$title .= ": " . $lang['kb_ucp_articlepost'];
+			break;
+		
+		case "edit_article":
+			$title .= ": " . $lang['kb_ucp_articleedit'];
+			break;
+		
+		case "delete_article":
+			$title .= ": " . $lang['kb_ucp_articledelete'];
+			break;
+		
+		case "post_comment": // Only input
+			break;
+		
+		case "edit_comment":
+			break;
+		
+		case "delete_comment":
+			break;
+		
+		default:
+			break;
+	}
+	
+	return $title;
+}
+
+// This is for posting articles, mostly cut out of the posting.php :)
+function ucp_article_form($mode, $id, $preview)
+{
+	global $template, $board_config, $db, $userdata, $lang, $phpbb_root_path, $phpEx, $HTTP_POST_VARS;
+	
+	$error_msg = '';
+	$user_sig = $userdata['user_sig'];
+	
+	// Simple auth for Alpha 1
+	if(!$userdata['session_logged_in'])
+	{
+		message_die(GENERAL_MESSAGE, 'Not authenticated!');
+	}
+	
+	if(!empty($HTTP_POST_VARS['post']))
+	{
+		if($mode == 'edit')
+		{
+			// Let's get the old article data
+			$article_id = isset($HTTP_POST_VARS['id']) ? $HTTP_POST_VARS['id'] : false;
+			if(!$article_id)
+			{
+				message_die(MESSAGE_DIE, 'No article id defined.');
+			}
+			
+			$sql = "SELECT *
+					FROM " . KB_ARTICLES_TABLE . "
+					WHERE article_id = '$article_id'";
+			if (!$result = $db->sql_query($sql))
+			{
+				message_die(GENERAL_ERROR, 'Error while retrieving old article data.', '', __LINE__, __FILE__, $sql);
+			}
+			
+			$article = $db->sql_fetchrow($result);
+			
+			// if user editing set status = 0, else set status = old status :)
+			if($userdata['user_id'] == $article['article_author'])
+			{
+				$article_status = "0";
+			}
+			else
+			{
+				$article_status = $article['article_status'];
+			}
+			
+			// Simple Auth for alpha 1
+			if(($userdata['user_level'] != ADMIN) && ($userdata['user_id'] != $article['article_author']))
+			{
+				message_die(GENERAL_MESSAGE, $lang['kb_edit_noauth']);
+			}
+		}			
+		
+		// Add the new article
+		// Make all the variables :)
+		if ( !$board_config['allow_html'] )
+		{
+			$html_on = 0;
+		}
+		else
+		{
+			$html_on = ( !empty($HTTP_POST_VARS['disable_html']) ) ? 0 : 1;
+		}
+		
+		if ( !$board_config['allow_bbcode'] )
+		{
+			$bbcode_on = 0;
+		}
+		else
+		{
+			$bbcode_on = ( !empty($HTTP_POST_VARS['disable_bbcode']) ) ? 0 : 1;
+		}
+		
+		if ( !$board_config['allow_smilies'] )
+		{
+			$smilies_on = 0;
+		}
+		else
+		{
+			$smilies_on = ( !empty($HTTP_POST_VARS['disable_smilies']) ) ? 0 : 1;
+		}
+		
+		$article_desc = ( !empty($HTTP_POST_VARS['desc']) ) ? trim($HTTP_POST_VARS['desc']) : '';
+		$article_title = ( !empty($HTTP_POST_VARS['title']) ) ? trim($HTTP_POST_VARS['title']) : '';
+		$message = ( !empty($HTTP_POST_VARS['message']) ) ? $HTTP_POST_VARS['message'] : '';
+		$article_author = ($mode == 'edit') ? $article['article_author'] : $userdata['user_id'];
+		$article_authorname = ( $mode == 'edit' ) ? ( ( empty($HTTP_POST_VARS['authorname']) ) ? $article['article_authorname'] : $HTTP_POST_VARS['authorname'] ) : ( ( empty($HTTP_POST_VARS['authorname']) ) ? $userdata['username'] : $HTTP_POST_VARS['authorname'] );
+		$bbcode_uid = ($mode == 'edit' ) ? $article['bbcode_uid'] : '';
+		$cat_id = $HTTP_POST_VARS['cats'];
+		$attach_sig = ( !empty($HTTP_POST_VARS['attach_sig']) ) ? 1 : 0;
+		
+		prepare_article($bbcode_on, $html_on, $smilies_on, $error_msg, $bbcode_uid, $article_title, $article_desc, $message, $cat_id);
+		
+		if ( $error_msg == '' )
+		{
+			$current_time = time();
+			
+			if($mode == 'post')
+			{
+				$sql = "INSERT INTO " . KB_ARTICLES_TABLE . " (article_id, article_title, article_desc, article_author, article_authorname, article_time, article_edittime, article_hits, article_editby, article_status, bbcode_uid, enable_sig, enable_html, enable_bbcode, enable_smilies, article_text) VALUES
+															  ('', '$article_title', '$article_desc', '$article_author', '$article_authorname', '$current_time', '$current_time', '0', '" . $userdata['user_id'] . "', '0', '$bbcode_uid', '$attach_sig', '$html_on', '$bbcode_on', '$smilies_on', '$message');";
+				if (!$db->sql_query($sql))
+				{
+					message_die(GENERAL_ERROR, 'Error in adding article', '', __LINE__, __FILE__, $sql);
+				}
+				
+				$article_id = $db->sql_nextid();
+				// Now make the categories
+				foreach($cat_id as $i => $cat)
+				{
+					$sql = "INSERT INTO " . KB_ARTICLECATS_TABLE . " VALUES ('$article_id', '$cat');\n";
+					$sql2 = "UPDATE " . KB_CATEGORIES_TABLE . " SET cat_articles = cat_articles + 1 WHERE cat_id = '$cat';\n";							
+					
+					if (!$db->sql_query($sql))
+					{
+						message_die(GENERAL_ERROR, 'Error in adding articles categories.', '', __LINE__, __FILE__, $sql);
+					}
+					
+					if (!$db->sql_query($sql2))
+					{
+						message_die(GENERAL_ERROR, 'Error in adding updating categories articles count.', '', __LINE__, __FILE__, $sql);
+					}
+				}
+
+				$meta = '<meta http-equiv="refresh" content="3;url=' . append_sid('kb.' . $phpEx . '?cat_id=' . $cat . '&amp;article=' . wiki_article_title($article_title)) . '>"';
+				$return_message = $lang['kb_added'] . '<br /><br />' . sprintf($lang['kb_click_view_article'], '<a href="' . append_sid('kb.' . $phpEx . '?cat_id=' . $cat . '&amp;article=' . wiki_article_title($article_title)) . '">', '</a>');
+			}
+			else
+			{
+				$article_id = isset($HTTP_POST_VARS['id']) ? $HTTP_POST_VARS['id'] : false;
+				if(!$article_id)
+				{
+					message_die(GENERAL_ERROR, 'No article to edit.');
+				}
+				
+				// First update the article table
+				$sql = "UPDATE " . KB_ARTICLES_TABLE . " 
+						SET article_title = '$article_title',
+							article_desc = '$article_desc',
+							article_author = '$article_author',
+							article_authorname = '$article_authorname',
+							article_edittime = '$current_time',
+							article_editby = '" . $userdata['user_id'] . "',
+							article_status = '$article_status',
+							bbcode_uid = '$bbcode_uid',
+							enable_sig = '$attach_sig',
+							enable_html = '$html_on',
+							enable_bbcode = '$bbcode_on',
+							enable_smilies = '$smilies_on',
+							article_text = '$message'
+						WHERE article_id = '$article_id'";
+				
+				if (!$db->sql_query($sql))
+				{
+					message_die(GENERAL_ERROR, 'Error in editing article', '', __LINE__, __FILE__, $sql);
+				}
+				
+				// Now delete all articlecats
+				$sql = "DELETE FROM " . KB_ARTICLECATS_TABLE . " WHERE article_id = '$article_id'";
+				
+				if (!$db->sql_query($sql))
+				{
+					message_die(GENERAL_ERROR, 'Error in deleting articlecat entries.', '', __LINE__, __FILE__, $sql);
+				}
+				
+				// Last add them again doing the loop
+				foreach($cat_id as $i => $cat)
+				{
+					$sql = "INSERT INTO " . KB_ARTICLECATS_TABLE . " VALUES ('$article_id', '$cat');\n";
+					$sql2 = "UPDATE " . KB_CATEGORIES_TABLE . " SET cat_articles = cat_articles + 1 WHERE cat_id = '$cat';\n";							
+					
+					if (!$db->sql_query($sql))
+					{
+						message_die(GENERAL_ERROR, 'Error in adding articles categories.', '', __LINE__, __FILE__, $sql);
+					}
+					
+					if (!$db->sql_query($sql2))
+					{
+						message_die(GENERAL_ERROR, 'Error in adding updating categories articles count.', '', __LINE__, __FILE__, $sql);
+					}
+				}
+				
+				// Message here somewhere
+				$meta = '<meta http-equiv="refresh" content="3;url=' . append_sid('kb.' . $phpEx . '?cat_id=' . $cat . 'article=' . $article_id) . '>"';
+				$return_message = $lang['kb_edited'] . '<br /><br />' . sprintf($lang['kb_click_view_article'], '<a href="' . append_sid('kb.' . $phpEx . '?cat_id=' . $cat . '&amp;article=' . wiki_article_title($article_title)) . '">', '</a>') . '<br /><br />' . sprintf($lang['kb_click_return_ucp'], '<a href="' . append_sid('kb.' . $phpEx . '?ucp=main') . '">', '</a>');
+			}
+			
+			$template->assign_vars(array(
+				'META' => $meta)
+			);
+			
+			message_die(GENERAL_MESSAGE, $return_message);
+		}
+	}
+
+	if($mode == "post" && !$preview && $error_msg == '')
+	{
+		$article_title = '';
+		$article_text = '';
+		$article_desc = '';
+		$authorname = $userdata['username'];
+		$form_action = append_sid('kb.' . $phpEx . '?ucp=post_article');
+		$hidden_form_fields = "";
+		$attach_sig = ( $userdata['user_id'] == ANONYMOUS ) ? 0 : $userdata['user_attachsig'];
+		
+		if ( !$board_config['allow_html'] )
+		{
+			$html_on = 0;
+		}
+		else
+		{
+			$html_on = ( ( $userdata['user_id'] == ANONYMOUS ) ? $board_config['allow_html'] : $userdata['user_allowhtml'] );
+		}
+		
+		if ( !$board_config['allow_bbcode'] )
+		{
+			$bbcode_on = 0;
+		}
+		else
+		{
+			$bbcode_on = ( ( $userdata['user_id'] == ANONYMOUS ) ? $board_config['allow_bbcode'] : $userdata['user_allowbbcode'] );
+		}
+		
+		if ( !$board_config['allow_smilies'] )
+		{
+			$smilies_on = 0;
+		}
+		else
+		{
+			$smilies_on = ( ( $userdata['user_id'] == ANONYMOUS ) ? $board_config['allow_smilies'] : $userdata['user_allowsmile'] );
+		}
+	}
+	elseif($preview || $error_msg != '')
+	{
+		$article_id = $HTTP_POST_VARS['id'];
+		$article_title = $HTTP_POST_VARS['title'];
+		$article_text = $HTTP_POST_VARS['message'];
+		$article_desc = $HTTP_POST_VARS['desc'];
+		$article_cats = $HTTP_POST_VARS['cats'];
+		$authorname = $HTTP_POST_VARS['authorname'];
+		
+		$attach_sig = ( $HTTP_POST_VARS['enable_sig'] ) ? TRUE : 0;
+
+		$html_on = ( $HTTP_POST_VARS['disable_html'] ) ? false : true;
+		$bbcode_on = ( $HTTP_POST_VARS['disable_bbcode'] ) ? false : true;
+		$smilies_on = ( $HTTP_POST_VARS['disable_smilies'] ) ? false : true;
+		
+		if($mode == 'edit')
+		{
+			$form_action = append_sid("kb.php?ucp=edit_article");
+			$hidden_form_fields = '<input type="hidden" name="id" value="' . $article_id . '" />';
+		}
+		else
+		{
+			$hidden_form_fields = "";
+			$form_action = append_sid("kb.php?ucp=post_article");
+		}
+					
+		if($error_msg != "")
+		{
+			$template->set_filenames(array(
+				'reg_header' => 'error_body.tpl')
+			);
+			$template->assign_vars(array(
+				'ERROR_MESSAGE' => $error_msg)
+			);
+			$template->assign_var_from_handle('ERROR_BOX', 'reg_header');
+		}
+		
+		if($preview)
+		{
+			// Create the preview box
+			$preview_article_desc = ( !empty($HTTP_POST_VARS['desc']) ) ? trim($HTTP_POST_VARS['desc']) : '';
+			$preview_article_title = ( !empty($HTTP_POST_VARS['title']) ) ? trim($HTTP_POST_VARS['title']) : '';
+			$preview_message = ( !empty($HTTP_POST_VARS['message']) ) ? $HTTP_POST_VARS['message'] : '';
+			$bbcode_uid = ( $bbcode_on ) ? make_bbcode_uid() : '';
+			
+			$preview_message = stripslashes(prepare_article_text(addslashes(unprepare_article_text(trim($preview_message))), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));
+			
+			// A lot of copy/paste from viewtopic.php, then shaped for this file ofc :)
+			//
+			// If the board has HTML off but the post has HTML
+			// on then we process it, else leave it alone
+			//
+			if ( !$html_on )
+			{
+				$preview_message = preg_replace('#(<)([\/]?.*?)(>)#is', "&lt;\\2&gt;", $preview_message);
+			}
+		
+			//
+			// Parse message and/or sig for BBCode if reqd
+			//
+			if ($bbcode_uid != '')
+			{
+				$preview_message = ($bbcode_on) ? bbencode_second_pass($preview_message, $bbcode_uid) : preg_replace("/\:$bbcode_uid/si", '', $preview_message);
+			}
+		
+			$preview_message = make_clickable($preview_message);
+		
+			//
+			// Parse smilies
+			//
+			if ( $smilies_on )
+			{
+				$preview_message = smilies_pass($preview_message);
+			}
+		
+			//
+			// Replace naughty words
+			//
+			$orig_word = array();
+			$replacement_word = array();
+			obtain_word_list($orig_word, $replacement_word);
+			if (count($orig_word))
+			{
+				$preview_article_title = preg_replace($orig_word, $replacement_word, $preview_article_title);
+				$preview_article_desc = preg_replace($orig_word, $replacement_word, $preview_article_desc);
+				$preview_message = str_replace('\"', '"', substr(@preg_replace('#(\>(((?>([^><]+|(?R)))*)\<))#se', "@preg_replace(\$orig_word, \$replacement_word, '\\0')", '>' . $preview_message . '<'), 1, -1));
+			}
+		
+			$preview_message = str_replace("\n", "\n<br />\n", $preview_message);
+			
+			
+			$template->set_filenames(array(
+				'preview_box' => 'kb_previewarticle.tpl')
+			);
+			
+			$template->assign_vars(array(
+				'L_ARTICLE_NAME' => $lang['kb_articlename'],
+				'L_ARTICLE_DESC' => $lang['kb_articledesc'],
+				'L_PREVIEW' => $lang['kb_articlepreview'],
+				'PREVIEW_ARTICLE_TITLE' => $preview_article_title,
+				'PREVIEW_ARTICLE_DESC' => $preview_article_desc,
+				'MESSAGE' => $preview_message)
+			);
+			
+			$template->assign_var_from_handle('ARTICLE_PREVIEW_BOX', 'preview_box');
+		}
+	}
+	else
+	{
+		if(empty($id))
+		{
+			message_die(GENERAL_ERROR, "No article defined.");
+		}
+		
+		$sql = "SELECT * 
+				FROM " . KB_ARTICLES_TABLE . "
+				WHERE article_id = '$id'";
+		if(!$result = $db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, 'Could not query article data.', '', __LINE__, __FILE__, $sql);
+		}
+		
+		if($db->sql_numrows($result) == 1)
+		{
+			$article = $db->sql_fetchrow($result);
+		}
+		else
+		{
+			message_die(GENERAL_ERROR, "Article does not exist.");
+		}
+		
+		// Now make an array over the cats
+		$sql = "SELECT cat_id 
+				FROM " . KB_ARTICLECATS_TABLE . "
+				WHERE article_id = '$id'";
+		if(!$result = $db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, 'Could not query articlecats data.', '', __LINE__, __FILE__, $sql);
+		}
+		
+		$article_cats = array();
+		while($row = $db->sql_fetchrow($result))
+		{
+			$article_cats[] = $row;
+		}
+		
+		$article_title = $article['article_title'];
+		$article_text = $article['article_text'];
+		$article_desc = $article['article_desc'];
+		$authorname = $article['article_authorname'];
+		
+		$attach_sig = ( $article['enable_sig'] ) ? TRUE : 0; 
+
+		$html_on = ( $article['enable_html'] ) ? true : false;
+		$bbcode_on = ( $article['enable_bbcode'] ) ? true : false;
+		$smilies_on = ( $article['enable_smilies'] ) ? true : false;
+		
+		$form_action = append_sid("kb.php?ucp=edit_article");
+		$hidden_form_fields = '<input type="hidden" name="id" value="' . $id . '" />';
+	}
+	
+	if ( $article['bbcode_uid'] != '' )
+	{
+		$article_text = preg_replace('/\:(([a-z0-9]:)?)' . $article['bbcode_uid'] . '/s', '', $article_text);
+	}
+	
+	$article_text = str_replace('<', '&lt;', $article_text);
+	$article_text = str_replace('>', '&gt;', $article_text);
+	$article_text = str_replace('<br />', "\n", $article_text);
+	
+	//
+	// Signature toggle selection
+	//
+	if( $user_sig != '' )
+	{
+		$template->assign_block_vars('switch_signature_checkbox', array());
+	}
+	
+	//
+	// HTML toggle selection
+	//
+	if ( $board_config['allow_html'] )
+	{
+		$html_status = $lang['HTML_is_ON'];
+		$template->assign_block_vars('switch_html_checkbox', array());
+	}
+	else
+	{
+		$html_status = $lang['HTML_is_OFF'];
+	}
+	
+	//
+	// BBCode toggle selection
+	//
+	if ( $board_config['allow_bbcode'] )
+	{
+		$bbcode_status = $lang['BBCode_is_ON'];
+		$template->assign_block_vars('switch_bbcode_checkbox', array());
+	}
+	else
+	{
+		$bbcode_status = $lang['BBCode_is_OFF'];
+	}
+	
+	// Obtain categories structure
+	$cats = get_cats_structure();
+	
+	// First lets sort main cats, yes i know there is a lot of loops, but i can't find a better way :S
+	$s_cats = '<option value="0">-' . $lang['kb_main'] . '</option>';
+	if($mode == "edit" || $preview)
+	{
+		for($i = 0; $i < count($cats); $i++)
+		{
+			$selected = '';
+			for($k = 0; $k < count($article_cats); $k++)
+			{
+				if($article_cats[$k]['cat_id'] == $cats[$i]['cat_id'])
+				{
+					$selected = ' selected="selected"';
+				}
+			}
+			$s_cats .= '<option' . $selected . ' value="' . $cats[$i]['cat_id'] . '">&nbsp;&nbsp;--' . $cats[$i]['cat_title'] . '</option>';
+			
+			// Sort subcats
+			for($j = 0; $j < count($cats[$i]['subcats']); $j++)
+			{
+				$selected = '';
+				for($k = 0; $k < count($article_cats); $k++)
+				{
+					if($article_cats[$k]['cat_id'] == $cats[$i]['subcats'][$j]['cat_id'])
+					{
+						$selected = ' selected="selected"';
+					}
+				}
+				$s_cats .= '<option' . $selected . ' value="' . $cats[$i]['subcats'][$j]['cat_id'] . '">&nbsp;&nbsp;&nbsp;&nbsp;--' . $cats[$i]['subcats'][$j]['cat_title'] . '</option>';
+			}
+		}
+	}
+	else
+	{
+		for($i = 0; $i < count($cats); $i++)
+		{
+			$s_cats .= '<option value="' . $cats[$i]['cat_id'] . '">--' . $cats[$i]['cat_title'] . '</option>';
+			
+			// Sort subcats
+			for($j = 0; $j < count($cats[$i]['subcats']); $j++)
+			{
+				$s_cats .= '<option value="' . $cats[$i]['subcats'][$j]['cat_id'] . '">--' . $cats[$i]['subcats'][$j]['cat_title'] . '</option>';
+			}
+		}
+	}
+	
+	//
+	// Smilies toggle selection
+	//
+	if ( $board_config['allow_smilies'] )
+	{
+		$smilies_status = $lang['Smilies_are_ON'];
+		$template->assign_block_vars('switch_smilies_checkbox', array());
+	}
+	else
+	{
+		$smilies_status = $lang['Smilies_are_OFF'];
+	}
+	
+	$template->set_filenames(array(
+		'body' => 'kb_article_posting.tpl')
+	);
+	
+	create_navigation("ucp", $action);
+	$post_article = ($mode == 'edit') ? $lang['kb_edit_article'] : $lang['kb_post_article'];
+	
+	// This is the template stuff we need no matter what
+	$template->assign_vars(array(
+		'AUTHORNAME' => $authorname,
+		'ARTICLE_TITLE' => $article_title,
+		'ARTICLE' => $article_text,
+		'DESC' => $article_desc,
+		'HTML_STATUS' => $html_status,
+		'BBCODE_STATUS' => sprintf($bbcode_status, '<a href="' . append_sid("faq." . $phpEx . "?mode=bbcode") . '" target="_phpbbcode">', '</a>'), 
+		'SMILIES_STATUS' => $smilies_status, 
+	
+		'L_POST_ARTICLE' => $post_article,
+		'L_AUTHORNAME' => $lang['kb_authorname'],
+		'L_ARTICLE_NAME' => $lang['kb_articlename'],
+		'L_ARTICLE_DESC' => $lang['kb_articledesc'],
+		'L_ARTICLE_CATS' => $lang['kb_articlecats'],
+		'L_ARTICLE_BODY' => $lang['kb_articletext'],
+		'L_AUTHORNAME_DESC' => $lang['kb_authorname_desc'],
+		'L_ARTICLEDESC_DESC' => $lang['kb_articledesc_desc'], // Funny one eh?
+		'L_ARTICLECATS_DESC' => $lang['kb_articlecats_desc'],
+
+		'L_OPTIONS' => $lang['Options'],
+		'L_PREVIEW' => $lang['Preview'],
+		'L_SUBMIT' => $lang['Submit'],
+		'L_DISABLE_HTML' => $lang['Disable_HTML_post'], 
+		'L_DISABLE_BBCODE' => $lang['Disable_BBCode_post'], 
+		'L_DISABLE_SMILIES' => $lang['Disable_Smilies_post'], 
+		'L_ATTACH_SIGNATURE' => $lang['Attach_signature'],
+	
+		'L_BBCODE_B_HELP' => $lang['bbcode_b_help'], 
+		'L_BBCODE_I_HELP' => $lang['bbcode_i_help'], 
+		'L_BBCODE_U_HELP' => $lang['bbcode_u_help'], 
+		'L_BBCODE_Q_HELP' => $lang['bbcode_q_help'], 
+		'L_BBCODE_C_HELP' => $lang['bbcode_c_help'], 
+		'L_BBCODE_L_HELP' => $lang['bbcode_l_help'], 
+		'L_BBCODE_O_HELP' => $lang['bbcode_o_help'], 
+		'L_BBCODE_P_HELP' => $lang['bbcode_p_help'], 
+		'L_BBCODE_W_HELP' => $lang['bbcode_w_help'], 
+		'L_BBCODE_A_HELP' => $lang['bbcode_a_help'], 
+		'L_BBCODE_S_HELP' => $lang['bbcode_s_help'], 
+		'L_BBCODE_F_HELP' => $lang['bbcode_f_help'], 
+		'L_EMPTY_MESSAGE' => $lang['Empty_message'],
+	
+		'L_FONT_COLOR' => $lang['Font_color'], 
+		'L_COLOR_DEFAULT' => $lang['color_default'], 
+		'L_COLOR_DARK_RED' => $lang['color_dark_red'], 
+		'L_COLOR_RED' => $lang['color_red'], 
+		'L_COLOR_ORANGE' => $lang['color_orange'], 
+		'L_COLOR_BROWN' => $lang['color_brown'], 
+		'L_COLOR_YELLOW' => $lang['color_yellow'], 
+		'L_COLOR_GREEN' => $lang['color_green'], 
+		'L_COLOR_OLIVE' => $lang['color_olive'], 
+		'L_COLOR_CYAN' => $lang['color_cyan'], 
+		'L_COLOR_BLUE' => $lang['color_blue'], 
+		'L_COLOR_DARK_BLUE' => $lang['color_dark_blue'], 
+		'L_COLOR_INDIGO' => $lang['color_indigo'], 
+		'L_COLOR_VIOLET' => $lang['color_violet'], 
+		'L_COLOR_WHITE' => $lang['color_white'], 
+		'L_COLOR_BLACK' => $lang['color_black'], 
+	
+		'L_FONT_SIZE' => $lang['Font_size'], 
+		'L_FONT_TINY' => $lang['font_tiny'], 
+		'L_FONT_SMALL' => $lang['font_small'], 
+		'L_FONT_NORMAL' => $lang['font_normal'], 
+		'L_FONT_LARGE' => $lang['font_large'], 
+		'L_FONT_HUGE' => $lang['font_huge'], 
+	
+		'L_BBCODE_CLOSE_TAGS' => $lang['Close_Tags'], 
+		'L_STYLES_TIP' => $lang['Styles_tip'], 
+	
+		'S_HTML_CHECKED' => ( !$html_on ) ? 'checked="checked"' : '', 
+		'S_BBCODE_CHECKED' => ( !$bbcode_on ) ? 'checked="checked"' : '', 
+		'S_SMILIES_CHECKED' => ( !$smilies_on ) ? 'checked="checked"' : '', 
+		'S_SIGNATURE_CHECKED' => ( $attach_sig ) ? 'checked="checked"' : '', 
+		'S_POST_ACTION' => $form_action,
+		'CATS_HTML' => $s_cats,
+		'S_HIDDEN_FORM_FIELDS' => $hidden_form_fields)
+	);
+}
+
+// Delete an article
+function ucp_article_delete($id, $confirm)
+{
+	global $lang, $db, $phpEx, $template, $HTTP_POST_VARS;
+	
+	// Simple auth for alpha 1
+	if(($userdata['user_level'] != ADMIN) && ($userdata['user_id'] != $article['article_author']))
+	{
+		message_die(GENERAL_MESSAGE, $lang['kb_delete_noauth']);
+	}
+	
+	$cancel = isset($HTTP_POST_VARS['cancel']) ? true : false;
+	
+	if($cancel)
+	{
+		$meta = '<meta http-equiv="refresh" content="0;url=' . append_sid('kb.' . $phpEx) . '>"';
+				
+		$template->assign_vars(array(
+			'META' => $meta)
+		);
+				
+		message_die(GENERAL_MESSAGE, '');
+	}
+	elseif(!$confirm)
+	{
+		$s_hidden_fields = '<input type="hidden" name="article_id" value="' . $id . '" />';
+		$l_confirm = $lang['kb_confirm_deletearticle'];
+	
+		//
+		// Output confirmation page
+		//
+		$template->set_filenames(array(
+			'confirm_body' => 'confirm_body.tpl')
+		);
+	
+		$template->assign_vars(array(
+			'MESSAGE_TITLE' => $lang['Information'],
+			'MESSAGE_TEXT' => $l_confirm,
+	
+			'L_YES' => $lang['Yes'],
+			'L_NO' => $lang['No'],
+	
+			'S_CONFIRM_ACTION' => append_sid("kb." . $phpEx . "?ucp=delete_article"),
+			'S_HIDDEN_FIELDS' => $s_hidden_fields)
+		);
+	
+		$template->pparse('confirm_body');
+	}
+	else
+	{
+		$article_id = $HTTP_POST_VARS['article_id'];
+		// Need lang vars for the error messages?
+		$sql = "DELETE FROM " . KB_ARTICLES_TABLE . " WHERE article_id = '" . $article_id . "'";
+		if(!$db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't delete article from articles table.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		// Obtain categories then delete
+		$sql = "SELECT c.cat_id, ca.cat_id
+				FROM " . KB_ARTICLECATS_TABLE . " c, " . KB_CATEGORIES_TABLE . " ca
+				WHERE c.article_id = '$id'
+				AND ca.cat_id = c.cat_id";
+		if( !($result = $db->sql_query($sql)) )
+		{
+			message_die(GENERAL_ERROR, 'Could not query article categories.', '', __LINE__, __FILE__, $sql);
+		}
+		
+		while($row = $db->sql_fetchrow($result))
+		{
+			$sql = "UPDATE " . KB_CATEGORIES_TABLE . " SET cat_articles = cat_articles - 1 WHERE cat_id = '" . $row['cat_id'] . "'";
+			
+			if( !($result = $db->sql_query($sql)) )
+			{
+				message_die(GENERAL_ERROR, 'Could not decrease article count for cat with id ' . $row['cat_id'] . '.', '', __LINE__, __FILE__, $sql);
+			}
+		}
+		
+		$sql = "DELETE FROM " . KB_ARTICLECATS_TABLE . " WHERE article_id = '" . $article_id . "'";
+		if(!$db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't delete article from articlecats table.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		// Message
+		$return_message = $lang['kb_deleted'] . '<br /><br />' . sprintf($lang['kb_click_return_ucp'], '<a href="' . append_sid('kb.' . $phpEx . '?ucp=main') . '">', '</a>');	
+		
+		message_die(GENERAL_MESSAGE, $return_message);
+	}
+}
+
+//
+// Prepare an article for the database
+// 
+function prepare_article(&$bbcode_on, &$html_on, &$smilies_on, &$error_msg, &$bbcode_uid, &$article_title, &$article_desc, &$message, &$cat_id)
+{
+	global $board_config, $userdata, $lang, $phpEx, $phpbb_root_path;
+	
+	// Check title
+	if (!empty($article_title))
+	{
+		$article_title = htmlspecialchars(trim($article_title));
+	}
+	else
+	{
+		$error_msg .= (!empty($error_msg)) ? '<br />' . $lang['kb_empty_article_title'] : $lang['kb_empty_article_title'];
+	}
+
+	// Check message
+	if(!empty($message))
+	{
+		$bbcode_uid = ($bbcode_on) ? make_bbcode_uid() : '';
+		$message = prepare_article_text(trim($message), $html_on, $bbcode_on, $smilies_on, $bbcode_uid);
+	}
+	else
+	{
+		$error_msg .= (!empty($error_msg)) ? '<br />' . $lang['kb_empty_article'] : $lang['kb_empty_article'];
+	}
+	
+	// Check Desc
+	if (!empty($article_desc))
+	{
+		$article_desc = htmlspecialchars(trim($article_desc));
+	}
+	else
+	{
+		$error_msg .= (!empty($error_msg)) ? '<br />' . $lang['kb_empty_article_desc'] : $lang['kb_empty_article_desc'];
+	}
+	
+	// Check categories
+	if(!is_array($cat_id))
+	{
+		$error_msg .= (!empty($error_msg)) ? '<br />' . $lang['kb_empty_cats'] : $lang['kb_empty_cats'];
+	}
+	return;
+}
+
+function prepare_article_text($message, $html_on, $bbcode_on, $smile_on, $bbcode_uid = 0)
+{
+	global $board_config, $phpEx;
+
+	//
+	// Clean up the message
+	//
+	$message = trim($message);
+	$html_entities_match = array('#&(?!(\#[0-9]+;))#', '#<#', '#>#', '#"#');
+	$html_entities_replace = array('&amp;', '&lt;', '&gt;', '&quot;');
+
+	if ($html_on)
+	{
+		// If HTML is on, we try to make it safe
+		// This approach is quite agressive and anything that does not look like a valid tag
+		// is going to get converted to HTML entities
+		$message = stripslashes($message);
+		$html_match = '#<[^\w<]*(\w+)((?:"[^"]*"|\'[^\']*\'|[^<>\'"])+)?>#';
+		$matches = array();
+
+		$message_split = preg_split($html_match, $message);
+		preg_match_all($html_match, $message, $matches);
+
+		$message = '';
+
+		// Include functions_post for clean_html
+		include($phpbb_root_path . "includes/functions_post." . $phpEx);
+		
+		foreach ($message_split as $part)
+		{
+			$tag = array(array_shift($matches[0]), array_shift($matches[1]), array_shift($matches[2]));
+			$message .= preg_replace($html_entities_match, $html_entities_replace, $part) . clean_html($tag);
+		}
+
+		$message = addslashes($message);
+		$message = str_replace('&quot;', '\&quot;', $message);
+	}
+	else
+	{
+		$message = preg_replace($html_entities_match, $html_entities_replace, $message);
+	}
+
+	if($bbcode_on && $bbcode_uid != '')
+	{
+		$message = bbencode_first_pass($message, $bbcode_uid);
+	}
+
+	return $message;
+}
+
+function unprepare_article_text($message)
+{
+	$unhtml_specialchars_match = array('#&gt;#', '#&lt;#', '#&quot;#', '#&amp;#');
+	$unhtml_specialchars_replace = array('>', '<', '"', '&');
+	
+	return preg_replace($unhtml_specialchars_match, $unhtml_specialchars_replace, $message);
+}
+
+function wiki_article_title($article_title)
+{
+	$chars = array("&amp;", "&quot;", "&lt;", "&gt;", "'", ":", ",", ".", ";", "!", "*", "^", "\xA8", "~", "|", "`", "\xB4", "?", "-", "_", "=");
+	$article_title = str_replace($chars, "", $article_title);
+	$article_title = str_replace(" ", "-", $article_title);
+	
+	return $article_title;
+}
+
+function unwiki_article_title($article_title)
+{
+	// Very simple, just remove - and replace them with spaces.
+	$article_title = str_replace("-", " ", $article_title);
+	
+	return $article_title;
+}
+?>
\ No newline at end of file

Deleted: main/trunk/kb/auth.php
===================================================================
--- main/trunk/kb/auth.php	2007-02-18 21:43:28 UTC (rev 55)
+++ main/trunk/kb/auth.php	2007-02-19 15:43:31 UTC (rev 56)
@@ -1,188 +0,0 @@
-<?php
-/***************************************************************************
- *                               auth.php
- *                            -------------------
- *
- *   copyright: 		phpBB KB Group
- *   site:			http://www.phpbbknowledgebase.com
- *   SF Project Page:	http://www.sourceforge.net/projects/phpbbkb
- *
- ***************************************************************************/
-
-/***************************************************************************
- *
- *   This program is free software; you can redistribute it and/or modify
- *   it under the terms of the GNU General Public License as published by
- *   the Free Software Foundation; either version 2 of the License, or
- *   (at your option) any later version.
- *
- ***************************************************************************/
- 
-// This file holds the kb auth functions, very similar to the phpBB auth functions, but differs certain places :)
-// As of now, the articles auth is handles out from which category it is selected through, therefore an article 
-// can have different kinds of auth, all depending on through which category it is viewed. This solution might seem
-// stupid, but it is the best I can come up with, and I think admins will just take that into consideration when creating
-// category permissions.
-
-//
-// This function returns info on whether the user is allowed to do the supplied argument(s) all dependant on the given category id
-//
-function kb_auth($type, $cat_id, $userdata)
-{
-	switch($type)
-	{
-		case "view":
-			$sql = "a.auth_view";
-			$auth_fields = array('auth_view');
-			break;
-			
-		case "add":
-			$sql = "a.auth_add";
-			$auth_fields = array('auth_add');
-			break;
-			
-		case "edit":
-			$sql = "a.auth_edit";
-			$auth_fields = array('auth_edit');
-			break;
-			
-		case "delete":
-			$sql = "a.auth_delete";
-			$auth_fields = array('auth_delete');
-			break;
-			
-		case "mod":
-			$sql = "a.auth_mod";
-			$auth_fields = array('auth_mod');
-			break;
-			
-		case "comment":
-			$sql = "a.auth_comment";
-			$auth_fields = array('auth_comment');
-			break;
-			
-		case "rate":
-			$sql = "a.auth_rate";
-			$auth_fields = array('auth_rate');
-			break;
-			
-		case "attach":
-			$sql = "a.auth_attach";
-			$auth_fields = array('auth_attach');
-			break;
-			
-		// Returns array containing everything above
-		case "all":
-			$sql = "a.auth_view, a.auth_add, a.auth_edit, a.auth_delete, a.auth_mod, a.auth_comment, a.auth_rate, a.auth_attach";
-			$auth_fields = array('auth_view', 'auth_add', 'auth_edit', 'auth_delete', 'auth_mod', 'auth_comment', 'auth_rate', 'auth_attach');
-			break;
-		
-		// Returns array containing article related auth	
-		case "article":
-			$sql = "a.auth_view, a.auth_edit, a.auth_delete, a.auth_mod, a.auth_comment, a.auth_rate";
-			$auth_fields = array('auth_view', 'auth_edit', 'auth_delete', 'auth_mod', 'auth_comment', 'auth_rate');
-			break;
-			
-		// Returns array containing category related auth
-		case "cat":
-			$sql = "a.auth_view, a.auth_add, a.auth_attach";
-			$auth_fields = array('auth_view', 'auth_add', 'auth_attach');
-			break;
-	}
-	
-	$sql = "SELECT a.cat_id, $sql
-			FROM " . KB_CATEGORIES_TABLE . " a
-			WHERE a.cat_id = '" . $cat_id . "'";
-	
-	if(!$result = $db->sql_query($sql))
-	{
-		message_die(GENERAL_MESSAGE, 'Could not retrieve categorys auth info.', '', __LINE__, __FILE__, $sql);
-	}
-	
-	$f_access = $db->sql_fetchrow($result);
-	
-	//
-	// If user is logged in we need to see if he is in any usergroups that changes his auth info, else just return it
-	//
-	if($userdata['session_logged_in'])
-	{
-		// Check if the user is present in a group that changes his permissions
-		$sql = "SELECT a.cat_id, $sql, a.auth_mod 
-			FROM " . KB_AUTH_ACCESS_TABLE . " a, " . USER_GROUP_TABLE . " ug 
-			WHERE ug.user_id = ".$userdata['user_id']. " 
-				AND ug.user_pending = 0 
-				AND a.group_id = ug.group_id
-				AND a.cat_id = '" . $cat_id . "'";
-		if ( !($result = $db->sql_query($sql)) )
-		{
-			message_die(GENERAL_ERROR, 'Failed obtaining category access control lists', '', __LINE__, __FILE__, $sql);
-		}
-
-		if ( $row = $db->sql_fetchrow($result) )
-		{
-			do
-			{
-				$u_access[] = $row;
-			}
-			while( $row = $db->sql_fetchrow($result) );
-		}
-		$db->sql_freeresult($result);
-	}
-	
-	$is_admin = ( $userdata['user_level'] == ADMIN && $userdata['session_logged_in'] ) ? TRUE : 0;
-	
-	$auth = array();
-	for($i = 0; $i < count($auth_fields); $i++)
-	{
-		$key = $auth_fields[$i];
-
-		//
-		// If the user is logged on and the forum type is either ALL or REG then the user has access
-		//
-		// If the type if ACL, MOD or ADMIN then we need to see if the user has specific permissions
-		// to do whatever it is they want to do ... to do this we pull relevant information for the
-		// user (and any groups they belong to)
-		//
-		// Now we compare the users access level against the forums. We assume here that a moderator
-		// and admin automatically have access to an ACL forum, similarly we assume admins meet an
-		// auth requirement of MOD
-		//
-		$value = $f_access[$key];
-
-		switch( $value )
-		{
-			case AUTH_ALL:
-				$auth[$key] = TRUE;
-				$auth[$key . '_type'] = $lang['Auth_Anonymous_Users'];
-				break;
-
-			case AUTH_REG:
-				$auth_user[$key] = ( $userdata['session_logged_in'] ) ? TRUE : 0;
-				$auth_user[$key . '_type'] = $lang['Auth_Registered_Users'];
-				break;
-
-			case AUTH_ACL:
-				$auth[$key] = ( $userdata['session_logged_in'] ) ? auth_check_user(AUTH_ACL, $key, $u_access, $is_admin) : 0;
-				$auth[$key . '_type'] = $lang['Auth_Users_granted_access'];
-				break;
-
-			case AUTH_MOD:
-				$auth[$key] = ( $userdata['session_logged_in'] ) ? auth_check_user(AUTH_MOD, 'auth_mod', $u_access, $is_admin) : 0;
-				$auth[$key . '_type'] = $lang['Auth_Moderators'];
-				break;
-
-			case AUTH_ADMIN:
-				$auth[$key] = $is_admin;
-				$auth[$key . '_type'] = $lang['Auth_Administrators'];
-				break;
-
-			default:
-				$auth[$key] = 0;
-				break;
-		}
-	}
-	
-	return $auth;	
-}
-
-?>

Deleted: main/trunk/kb/constants.php
===================================================================
--- main/trunk/kb/constants.php	2007-02-18 21:43:28 UTC (rev 55)
+++ main/trunk/kb/constants.php	2007-02-19 15:43:31 UTC (rev 56)
@@ -1,40 +0,0 @@
-<?php
-/***************************************************************************
- *                               constants.php
- *                            -------------------
- *
- *   copyright: 		phpBB KB Group
- *   site:			http://www.phpbbknowledgebase.com
- *   SF Project Page:	http://www.sourceforge.net/projects/phpbbkb
- *
- *******************************************************************...
 
[truncated message content]