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

[<mar...@us...>]

Revision: 42
          http://svn.sourceforge.net/phpbbkb/?rev=42&view=rev
Author:   markthedaemon
Date:     2007-01-26 10:02:51 -0800 (Fri, 26 Jan 2007)

Log Message:
-----------
Adding the KB files as well as commiting a updated lang_kb.php file which includes some initial changes for the language side of things.

Added Paths:
-----------
    main/trunk/admin/admin_kb.php
    main/trunk/install/kb_install.php
    main/trunk/kb.php
    main/trunk/language/lang_english/lang_kb.php
    main/trunk/templates/subSilver/admin/kb_cats.tpl
    main/trunk/templates/subSilver/admin/kb_editcat.tpl
    main/trunk/templates/subSilver/images/Thumbs.db
    main/trunk/templates/subSilver/images/new-article.gif
    main/trunk/templates/subSilver/kb_article_posting.tpl
    main/trunk/templates/subSilver/kb_main.tpl
    main/trunk/templates/subSilver/kb_previewarticle.tpl
    main/trunk/templates/subSilver/kb_viewarticle.tpl
    main/trunk/templates/subSilver/kb_viewcat.tpl

Added: main/trunk/admin/admin_kb.php
===================================================================
--- main/trunk/admin/admin_kb.php	                        (rev 0)
+++ main/trunk/admin/admin_kb.php	2007-01-26 18:02:51 UTC (rev 42)
@@ -0,0 +1,727 @@
+<?php
+/***************************************************************************
+ *                               admin_kb.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.
+ *
+ ***************************************************************************/
+ 
+define('IN_PHPBB', 1);
+
+if( !empty($setmodules) )
+{
+	$file = basename(__FILE__);
+	$module['KB']['Categories'] = "$file?mode=cats";
+	return;
+}
+
+$phpbb_root_path = "./../";
+require($phpbb_root_path . 'extension.inc');
+require('./pagestart.' . $phpEx);
+
+// Get constants and functions
+include($phpbb_root_path . "kb/constants." . $phpEx);
+include($phpbb_root_path . "kb/functions." . $phpEx);
+
+// And language
+include($phpbb_root_path . "language/lang_" . $board_config['default_lang'] . "/lang_kb." . $phpEx);
+$mode = $HTTP_GET_VARS['mode'];
+
+switch($mode)
+{
+	/*
+	NOTE: All article editing, deleting, approving and so on will be featured in the ucp for the admin as well, 
+	might integrate it here later but i like it better in ucp.
+	case "articles":
+		break;
+	*/
+		
+	case "cats":
+		$edit = isset($HTTP_GET_VARS['edit']) ? $HTTP_GET_VARS['edit'] : false;
+		$delete = isset($HTTP_GET_VARS['delete']) ? $HTTP_GET_VARS['delete'] : false;
+		$add = isset($HTTP_POST_VARS['add']) ? true : false;
+		if(!$add) 
+		{
+			$add = isset($HTTP_GET_VARS['add']) ? true : false;
+		}
+		$sort = isset($HTTP_GET_VARS['s']) ? $HTTP_GET_VARS['s'] : false;
+		
+		if($edit != false)
+		{
+			if(!isset($HTTP_POST_VARS['submit']))
+			{
+				$sql = "SELECT * 
+						FROM " . KB_CATEGORIES_TABLE . " 
+						WHERE cat_id = '" . $edit . "'";
+				if(!$result = $db->sql_query($sql))
+				{
+					message_die(GENERAL_ERROR, "Couldn't get category from categories table", "", __LINE__, __FILE__, $sql);
+				}
+				$cat = $db->sql_fetchrow($result);
+				
+				$template->set_filenames(array(
+					'body' => 'admin/kb_editcat.tpl')
+				);
+				
+				$parent = generate_cat_parents($cat['cat_main']);
+				$s_hidden_fields = "<input type=\"hidden\" name=\"oldparent\" value=\"" . $cat['cat_main'] . "\">";
+				
+				$template->assign_vars(array(
+					'L_HEADER' => $lang['kbadm_header_editcat'],
+					'L_EXPLAIN' => $lang['kbadm_explain_editcat'],
+					'L_CAT_SETTINGS' => $lang['kbadm_cat_settings'],
+					'L_CAT_TITLE' => $lang['kbadm_cat_title'],
+					'L_CAT_DESCRIPTION' => $lang['kbadm_cat_desc'],
+					'L_CAT_PARENT' => $lang['kbadm_cat_parent'],
+					
+					'CAT_TITLE' => $cat['cat_title'],
+					'DESCRIPTION' => $cat['cat_desc'],
+					
+					'S_SUBMIT_VALUE' => $lang['kbadm_editcat'],
+					'S_PARENT' => $parent,
+					'S_HIDDEN_FIELDS' => $s_hidden_fields,
+					'S_FORUM_ACTION' => append_sid("admin_kb." . $phpEx . "?mode=cats&amp;edit=" . $edit))
+				);
+				
+				$template->pparse('body');
+				
+				include('./page_footer_admin.'.$phpEx);
+				exit;
+			}
+			else
+			{
+				$error_msg = '';
+				
+				if(!isset($HTTP_POST_VARS['title']) || $HTTP_POST_VARS['title'] == "")
+				{
+					$error_msg .= (!empty($error_msg)) ? '<br />' . $lang['kbadm_empty_cat_title'] : $lang['admkb_empty_cat_title'];
+				}
+				
+				if(!isset($HTTP_POST_VARS['desc']) || $HTTP_POST_VARS['desc'] == "")
+				{
+					$error_msg .= (!empty($error_msg)) ? '<br />' . $lang['kbadm_empty_cat_desc'] : $lang['admkb_empty_cat_title'];
+				}
+				
+				if($error_msg != '')
+				{
+					$sql = "SELECT * 
+						FROM " . KB_CATEGORIES_TABLE . " 
+						WHERE cat_id = '" . $edit . "'";
+					if(!$result = $db->sql_query($sql))
+					{
+						message_die(GENERAL_ERROR, "Couldn't get category from categories table", "", __LINE__, __FILE__, $sql);
+					}
+					$cat = $db->sql_fetchrow($result);
+					
+					$template->set_filenames(array(
+						'body' => 'admin/kb_editcat.tpl')
+					);
+					
+					$parent = generate_cat_parents($cat['cat_main']);
+					$s_hidden_fields = "<input type=\"hidden\" name=\"oldparent\" value=\"" . $cat['cat_main'] . "\">";
+					
+					$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');
+					
+					$template->assign_vars(array(
+						'L_HEADER' => $lang['kbadm_header_editcat'],
+						'L_EXPLAIN' => $lang['kbadm_explain_editcat'],
+						'L_CAT_SETTINGS' => $lang['kbadm_cat_settings'],
+						'L_CAT_TITLE' => $lang['kbadm_cat_title'],
+						'L_CAT_DESCRIPTION' => $lang['kbadm_cat_desc'],
+						'L_CAT_PARENT' => $lang['kbadm_cat_parent'],
+						
+						'CAT_TITLE' => $cat['cat_title'],
+						'DESCRIPTION' => $cat['cat_desc'],
+						
+						'S_SUBMIT_VALUE' => $lang['kbadm_editcat'],
+						'S_PARENT' => $parent,
+						'S_HIDDEN_FIELDS' => $s_hidden_fields,
+						'S_FORUM_ACTION' => append_sid("admin_kb." . $phpEx . "?mode=cats&amp;edit=" . $edit))
+					);
+					
+					$template->pparse('body');
+					
+					include('./page_footer_admin.'.$phpEx);
+					exit;
+				}
+				else
+				{
+					$parent = isset($HTTP_POST_VARS['parent']) ? $HTTP_POST_VARS['parent'] : 0;
+					
+					$sql = "UPDATE " . KB_CATEGORIES_TABLE . " 
+							SET cat_main = '" . $parent . "',
+							cat_title = '" . trim(htmlspecialchars($HTTP_POST_VARS['title'])) . "',
+							cat_desc = '" . trim(htmlspecialchars($HTTP_POST_VARS['desc'])) . "'
+							WHERE cat_id = '" . $edit . "'";
+							
+					if(!$db->sql_query($sql))
+					{
+						message_die(GENERAL_ERROR, "Couldn't edit category.", "", __LINE__, __FILE__, $sql);
+					}
+					
+					if($HTTP_POST_VARS['oldparent'] != $HTTP_POST_VARS['parent'])
+					{
+						// Parent category changed, alter the order
+						sort_cats("edit", $edit, 0, array(0 => $HTTP_POST_VARS['parent'], 1 => $HTTP_POST_VARS['oldparent']));
+					}
+					
+					// And a message here somewhere
+					$message = $lang['kbadm_editcat_success'] . '<br /><br />' . sprintf($lang['kbadm_Click_return_catadmin'], '<a href="' . append_sid("admin_kb." . $phpEx . "?mode=cats") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');
+
+					message_die(GENERAL_MESSAGE, $message);
+				}
+			}
+		}
+		
+		if($delete != false)
+		{
+			$confirm = isset($HTTP_POST_VARS['confirm']) ? true : false;
+			$cancel = isset($HTTP_POST_VARS['cancel']) ? true : false;
+			if($cancel)
+			{
+				// Redirect back to cat page
+				
+			}
+			elseif(!$confirm)
+			{
+				$s_hidden_fields = '<input type="hidden" name="cat_id" value="' . $delete . '" />';
+				$l_confirm = $lang['kbadm_confirm_deletecat'];
+			
+				//
+				// 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("admin_kb." . $phpEx . "?mode=cats&amp;delete=true"),
+					'S_HIDDEN_FIELDS' => $s_hidden_fields)
+				);
+			
+				$template->pparse('confirm_body');
+				
+				include('./page_footer_admin.'.$phpEx);
+				exit;
+			}
+			elseif($confirm) // Double check user confirmed
+			{
+				$cat_id = $HTTP_POST_VARS['cat_id'];
+				
+				// Need lang vars for the errors?
+				$sql = "DELETE FROM " . KB_CATEGORIES_TABLE . " WHERE cat_id = '" . $cat_id . "'";
+				if(!$db->sql_query($sql))
+				{
+					message_die(GENERAL_ERROR, "Couldn't delete category from categories table.", "", __LINE__, __FILE__, $sql);
+				}
+				
+				$sql = "DELETE FROM " . KB_ARTICLECATS_TABLE . " WHERE cat_id = '" . $cat_id . "'";
+				if(!$db->sql_query($sql))
+				{
+					message_die(GENERAL_ERROR, "Couldn't delete category from articlecats table.", "", __LINE__, __FILE__, $sql);
+				}
+				
+				// Delete subcats
+				$sql = "DELETE FROM " . KB_ARTICLES_TABLE . " WHERE cat_main = '" . $cat_id . "'";
+				if(!$db->sql_query($sql))
+				{
+					message_die(GENERAL_ERROR, "Couldn't delete subcategories from articlecats table.", "", __LINE__, __FILE__, $sql);
+				}
+				
+				$message = $lang['kbadm_delcat_success'] . '<br /><br />' . sprintf($lang['kbadm_Click_return_catadmin'], '<a href="' . append_sid("admin_kb." . $phpEx . "?mode=cats") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');
+				
+				// Delete all articles in this category or set cat_id to another one or? I'm not sure how we should handle this?
+				message_die(GENERAL_MESSAGE, $message);
+			}
+		}
+		
+		if($add)
+		{
+			if(!isset($HTTP_POST_VARS['submit']))
+			{
+				$template->set_filenames(array(
+					'body' => 'admin/kb_editcat.tpl')
+				);
+				
+				$parent = generate_cat_parents();
+				$s_hidden_fields = '<input type="hidden" name="add" value="1">';
+				
+				$template->assign_vars(array(
+					'L_HEADER' => $lang['kbadm_header_addcat'],
+					'L_EXPLAIN' => $lang['kbadm_explain_addcat'],
+					'L_CAT_SETTINGS' => $lang['kbadm_cat_settings'],
+					'L_CAT_TITLE' => $lang['kbadm_cat_title'],
+					'L_CAT_DESCRIPTION' => $lang['kbadm_cat_desc'],
+					'L_CAT_PARENT' => $lang['kbadm_cat_parent'],
+					
+					'S_SUBMIT_VALUE' => $lang['kbadm_addcat'],
+					'S_PARENT' => $parent,
+					'S_HIDDEN_FIELDS' => $s_hidden_fields,
+					'S_FORUM_ACTION' => append_sid("admin_kb." . $phpEx . "?mode=cats"))
+				);
+				
+				$template->pparse('body');
+				
+				include('./page_footer_admin.'.$phpEx);
+				exit;
+			}
+			else
+			{
+				$error_msg = '';
+				
+				if(!isset($HTTP_POST_VARS['title']) || $HTTP_POST_VARS['title'] == "")
+				{
+					$error_msg .= (!empty($error_msg)) ? '<br />' . $lang['kbadm_empty_cat_title'] : $lang['admkb_empty_cat_title'];
+				}
+				
+				if(!isset($HTTP_POST_VARS['desc']) || $HTTP_POST_VARS['desc'] == "")
+				{
+					$error_msg .= (!empty($error_msg)) ? '<br />' . $lang['kbadm_empty_cat_desc'] : $lang['admkb_empty_cat_title'];
+				}
+				
+				if($error_msg != '')
+				{	
+					$template->set_filenames(array(
+						'body' => 'admin/kb_editcat.tpl')
+					);
+					
+					$parent = generate_cat_parents($HTTP_POST_VARS['parent']);
+					$s_hidden_fields = '<input type="hidden" name="add" value="1">';
+					
+					$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');
+					
+					$template->assign_vars(array(
+						'L_HEADER' => $lang['kbadm_header_editcat'],
+						'L_EXPLAIN' => $lang['kbadm_explain_editcat'],
+						'L_CAT_SETTINGS' => $lang['kbadm_cat_settings'],
+						'L_CAT_TITLE' => $lang['kbadm_cat_title'],
+						'L_CAT_DESCRIPTION' => $lang['kbadm_cat_desc'],
+						'L_CAT_PARENT' => $lang['kbadm_cat_parent'],
+						
+						'CAT_TITLE' => $HTTP_POST_VARS['title'],
+						'DESCRIPTION' => $HTTP_POST_VARS['desc'],
+						
+						'S_SUBMIT_VALUE' => $lang['kbadm_addcat'],
+						'S_PARENT' => $parent,
+						'S_HIDDEN_FIELDS' => $s_hidden_fields,
+						'S_FORUM_ACTION' => append_sid("admin_kb." . $phpEx . "?mode=cats"))
+					);
+					
+					$template->pparse('body');
+					
+					include('./page_footer_admin.'.$phpEx);
+					exit;
+				}
+				else
+				{
+					$parent = isset($HTTP_POST_VARS['parent']) ? $HTTP_POST_VARS['parent'] : 0;
+					
+					$sql = "INSERT INTO " . KB_CATEGORIES_TABLE . " (cat_id, cat_main, cat_title, cat_desc, cat_articles, cat_order)
+							VALUES ('', '" . $parent . "', '" . trim(htmlspecialchars($HTTP_POST_VARS['title'])) . "', '" . trim(htmlspecialchars($HTTP_POST_VARS['desc'])) . "', '0', '9999');";
+							
+					if(!$db->sql_query($sql))
+					{
+						message_die(GENERAL_ERROR, "Couldn't insert new category.", "", __LINE__, __FILE__, $sql);
+					}
+					
+					sort_cats("add", $db->sql_nextid(), 0, $parent);
+					
+					// And a message here somewhere
+					$message = $lang['kbadm_addcat_success'] . '<br /><br />' . sprintf($lang['kbadm_Click_return_catadmin'], '<a href="' . append_sid("admin_kb." . $phpEx . "?mode=cats") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');
+
+					message_die(GENERAL_MESSAGE, $message);
+				}
+			}
+		}
+		
+		if($sort != false)
+		{
+			$sort = explode("|", $sort);
+			
+			// ok so ?sort=id|up/down|level
+			sort_cats("", $sort[0], $sort[1], $sort[2]); // Put id2 in the level argument, nvm that :)
+			
+			// And yes yet another message here
+			$message = $lang['kbadm_sortcat_success'] . '<br /><br />' . sprintf($lang['kbadm_Click_return_catadmin'], '<a href="' . append_sid("admin_kb." . $phpEx . "?mode=cats") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');
+			
+			message_die(GENERAL_MESSAGE, $message);
+		}
+		
+		// Show categories as list
+		$cats = get_cats_structure();
+		
+		$template->set_filenames(array(
+			'body' => 'admin/kb_cats.tpl')
+		);
+		
+		$template->assign_vars(array(
+			'L_CATEGORIES' => $lang['kb_categories'],
+			'L_EDITCAT' => $lang['kbadm_editcat'],
+			'L_DELCAT' => $lang['kbadm_delcat'],
+			'L_HEADER' => $lang['Categories'],
+			'L_EXPLAIN' => $lang['kbadm_maincat_explain'])
+		);
+		
+		if($total_catrows = count($cats))
+		{
+			for($i = 0; $i < $total_catrows; $i++)
+			{
+				// Check if the cat is at the top and therefore cant be moved up
+				if(($cats[$i - 1]['cat_main'] != $cats[$i]['cat_main']) || (strlen($cats[$i - 1]['cat_id']) == 0))
+				{
+					$movecat_up = $lang['kbadm_movecatup'];
+				}
+				else
+				{
+					$movecat_up = '<a href="' . append_sid('admin_kb.' . $phpEx . '?mode=cats&s=' . $cats[$i]['cat_id'] . '|up|' . $cats[$i]['cat_main']) . '">' . $lang['kbadm_movecatup'] . '</a>';
+				}
+				
+				// Check if the cat is at the bottom and therefore cant be moved down
+				if(($cats[$i + 1]['cat_main'] != $cats[$i]['cat_main']) || (strlen($cats[$i + 1]['cat_id']) == 0))
+				{
+					$movecat_down = $lang['kbadm_movecatdown'];
+				}
+				else
+				{
+					$movecat_down = '<a href="' . append_sid('admin_kb.' . $phpEx . '?mode=cats&s=' . $cats[$i]['cat_id'] . '|down|' . $cats[$i]['cat_main']) . '">' . $lang['kbadm_movecatdown'] . '</a>';
+				}
+				
+				// Ok display one cat here
+				$template->assign_block_vars('catrow', array(
+					// Name 'nd stuff
+					'CAT_TITLE' => $cats[$i]['cat_title'],
+					'CAT_DESC' => $cats[$i]['cat_desc'],
+					
+					// Links
+					'U_EDITCAT' => append_sid("admin_kb." . $phpEx . "?mode=cats&amp;edit=" . $cats[$i]['cat_id']),
+					'U_DELCAT' => append_sid("admin_kb." . $phpEx . "?mode=cats&amp;delete=" . $cats[$i]['cat_id']),
+					// sort=id,id2|up/down|level
+					'MOVECAT_UP' => $movecat_up,
+					'MOVECAT_DOWN' => $movecat_down,
+					
+					// Image
+					'FORUM_FOLDER_IMG' => "../" . $images['forum']) // Stolen :D
+				);
+				
+				if($total_subcats = count($cats[$i]['subcats']))
+				{
+					// Contains subcats, show them
+					//$template->assign_block_vars('catrow.switch_subcat', array(
+						//'L_SUBCATS' => $lang['kb_subcats'])
+					//);
+					
+					for($j = 0; $j < $total_subcats; $j++)
+					{
+						if(($cats[$i]['subcats'][$j - 1]['cat_main'] != $cats[$i]['subcats'][$j]['cat_main']) || (strlen($cats[$i]['subcats'][$j - 1]['cat_id']) == 0))
+						{
+							$subcatmove_up = $lang['kbadm_movecatup'];
+						}
+						else
+						{
+							$subcatmove_up = '<a href="' . append_sid('admin_kb.' . $phpEx . '?mode=cats&s=' . $cats[$i]['subcats'][$j]['cat_id'] . '|up') . '">' . $lang['kbadm_movecatup'] . '</a>';
+						}
+						
+						// Check if the cat is at the bottom and therefore cant be moved down
+						if(($cats[$i]['subcats'][$j + 1]['cat_main'] != $cats[$i]['subcats'][$j]['cat_main']) || (strlen($cats[$i]['subcats'][$j + 1]['cat_id']) == 0))
+						{
+							$subcatmove_down = $lang['kbadm_movecatdown'];
+						}
+						else
+						{
+							$subcatmove_down = '<a href="' . append_sid('admin_kb.' . $phpEx . '?mode=cats&s=' . $cats[$i]['subcats'][$j]['cat_id'] . '|down') . '">' . $lang['kbadm_movecatdown'] . '</a>';
+						}
+						
+						// Show the subcat
+						$template->assign_block_vars('catrow.subcatrow', array(
+							'SUBCAT_TITLE' => $cats[$i]['subcats'][$j]['cat_title'],
+							'SUBCAT_DESC' => $cats[$i]['subcats'][$j]['cat_desc'],
+							
+							// Links
+							'U_EDITSUBCAT' => append_sid("admin_kb." . $phpEx . "?mode=cats&amp;edit=" . $cats[$i]['subcats'][$j]['cat_id']),
+							'U_DELSUBCAT' => append_sid("admin_kb." . $phpEx . "?mode=cats&amp;delete=" . $cats[$i]['subcats'][$j]['cat_id']),
+							// sort=id,id2|up/down|level
+							'MOVESUBCAT_UP' => $subcatmove_up,
+							'MOVESUBCAT_DOWN' => $subcatmove_down,
+							
+							'TOPIC_FOLDER_IMG' => "../" . $images['folder']) // Stolen :D
+						);
+					} // for subcats
+					
+					//$template->assign_block_vars('catrow.switch_subcat_close', array());
+				} // if subcats
+			} // for cats
+			
+			$parent = generate_cat_parents();
+			$s_hidden_fields = '<input type="hidden" name="add" value="1">';
+			
+			$template->assign_vars(array(
+				'L_CAT_SETTINGS' => $lang['kbadm_addcat'],
+				'L_CAT_TITLE' => $lang['kbadm_cat_title'],
+				'L_CAT_DESCRIPTION' => $lang['kbadm_cat_desc'],
+				'L_CAT_PARENT' => $lang['kbadm_cat_parent'],
+				
+				'S_SUBMIT_VALUE' => $lang['kbadm_addcat'],
+				'S_PARENT' => $parent,
+				'S_HIDDEN_FIELDS' => $s_hidden_fields,
+				'S_FORUM_ACTION' => append_sid("admin_kb." . $phpEx . "?mode=cats"))
+			);
+			
+			$template->pparse('body');
+		}// total cats
+		else
+		{
+			message_die(GENERAL_MESSAGE, sprintf($lang['No_kbadm_cats'], '<a href="' . append_sid("admin_kb." . $phpEx . "?mode=cats&add=1") . '">', '</a>'));
+		}
+		
+		include('./page_footer_admin.'.$phpEx);
+		exit;
+		break;
+		
+	case "auth": // For later use
+		break;
+		
+	case "files": // For later use
+		break;
+		
+	default: // General settings here
+		break;
+}
+
+
+//////////////////
+/// FUNCTIONS  ///
+//////////////////
+function generate_cat_parents($selected = false)
+{
+	global $db, $lang;
+	
+	$sql = "SELECT cat_id, cat_title 
+			FROM " . KB_CATEGORIES_TABLE . " 
+			WHERE cat_main = '0' 
+			ORDER BY cat_order ASC"; // At the moment only one level of subcats
+	if(!$result = $db->sql_query($sql))
+	{
+		message_die(GENERAL_ERROR, "Couldn't get categories from categories table", "", __LINE__, __FILE__, $sql);
+	}
+	
+	$cats = array();
+	while($row = $db->sql_fetchrow($result))
+	{
+		$cats[] = $row;
+	}
+	
+	if(!$selected)
+	{
+		$parent = '<select name="parent">\n<option value="0" selected="selected">' . $lang['kb_main'] . '</option>\n';
+	}
+	else
+	{
+		$parent = '<select name="parent">\n<option value="0">' . $lang['kb_main'] . '</option>\n';
+	}
+	
+	for($i = 0; $i < count($cats); $i++)
+	{
+		if(!$selected)
+		{
+			$parent .= '<option value="' . $cats[$i]['cat_id'] . '">' . $cats[$i]['cat_title'] . '</option>\n';
+		}
+		else
+		{
+			if($cats[$i]['cat_id'] == $selected)
+			{
+				$parent .= '<option value="' . $cats[$i]['cat_id'] . '" selected="selected">' . $cats[$i]['cat_title'] . '</option>\n';
+			}
+			else
+			{
+				$parent .= '<option value="' . $cats[$i]['cat_id'] . '">' . $cats[$i]['cat_title'] . '</option>\n';
+			}
+		}
+	}
+	
+	$parent .= "</select>";
+	
+	return $parent;
+}
+
+function sort_cats($type = "", $id = 0, $dir = 0, $level = 0)
+{
+	global $db;
+	
+	if($type == "add")
+	{
+		$sql = "SELECT cat_id 
+				FROM " . KB_CATEGORIES_TABLE . "
+				WHERE cat_main = '" . $level . "'
+				ORDER BY cat_order ASC";
+				
+		if(!$result = $db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't retrieve order data from cat table.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		$cat_number = $db->sql_numrows($result);
+		
+		$sql = "UPDATE " . KB_CATEGORIES_TABLE . " 
+				SET cat_order = '" . $cat_number . "' 
+				WHERE cat_id = '" . $id . "'";
+		
+		if(!$db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't alter categories order.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		return;
+	}
+	elseif($type == "edit")
+	{
+		// First clean up in the old level where it is gone from
+		$sql = "SELECT cat_id 
+				FROM " . KB_CATEGORIES_TABLE . "
+				WHERE cat_main = '" . $level[1] . "'
+				ORDER BY cat_order ASC";
+				
+		if(!$result = $db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't retrieve order data from cat table.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		$sql = "";
+		$i = 0;
+		while($old_cat = $db->sql_fetchrow($result))
+		{
+			$i++;
+			$sql = "UPDATE " . KB_CATEGORIES_TABLE . "
+					 SET cat_order = '" . $i . "'
+					 WHERE cat_id = '" . $old_cat['cat_id'] . "';\n";
+			if(!$db->sql_query($sql))
+			{
+				message_die(GENERAL_ERROR, "Couldn't sort old level order in cat table.", "", __LINE__, __FILE__, $sql);
+			}
+		}
+		
+		// Ok insert it in the back of the new one :)	
+		$sql = "SELECT cat_id 
+				FROM " . KB_CATEGORIES_TABLE . "
+				WHERE cat_main = '" . $level[0] . "'
+				ORDER BY cat_order ASC";
+				
+		if(!$result = $db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't retrieve order data from cat table.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		$cat_number = $db->sql_numrows($result);
+		
+		$sql = "UPDATE " . KB_CATEGORIES_TABLE . "
+				SET cat_order = '" . $cat_number . "'
+				WHERE cat_id = '" . $id . "'";
+		
+		if(!$db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't alter categories order.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		return;	
+	}
+	else
+	{
+		$sql = "SELECT cat_order, cat_main 
+				FROM " . KB_CATEGORIES_TABLE . " 
+				WHERE cat_id = '" . $id . "'";
+		
+		if(!$result = $db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't retrieve categories order data.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		$cat = $db->sql_fetchrow($result);
+		
+		if($dir == "up")
+		{
+			$num = $cat['cat_order'] - 1;
+			
+			$sql = "SELECT cat_id, cat_order 
+					FROM " . KB_CATEGORIES_TABLE . " 
+					WHERE cat_order = '" . $num . "'
+					AND cat_main = '" . $cat['cat_main'] . "'";
+					
+			if(!$result = $db->sql_query($sql))
+			{
+				message_die(GENERAL_ERROR, "Couldn't retrieve categories order data.", "", __LINE__, __FILE__, $sql);
+			}
+			
+			$cat2 = $db->sql_fetchrow($result);	
+		}
+		elseif($dir == "down")
+		{
+			$num = $cat['cat_order'] + 1;
+			
+			$sql = "SELECT cat_id, cat_order 
+					FROM " . KB_CATEGORIES_TABLE . " 
+					WHERE cat_order = '" . $num . "'
+					AND cat_main = '" . $cat['cat_main'] . "'";
+					
+			if(!$result = $db->sql_query($sql))
+			{
+				message_die(GENERAL_ERROR, "Couldn't retrieve categories order data.", "", __LINE__, __FILE__, $sql);
+			}
+			
+			$cat2 = $db->sql_fetchrow($result);
+		}
+		
+		$sql = "UPDATE " . KB_CATEGORIES_TABLE . "
+				SET cat_order = '" . $cat2['cat_order'] . "'
+				WHERE cat_id = '" . $id . "'";
+		
+		if(!$db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't alter categories order data.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		$sql = "UPDATE " . KB_CATEGORIES_TABLE . "
+				SET cat_order = '" . $cat['cat_order'] . "'
+				WHERE cat_id = '" . $cat2['cat_id'] . "'";
+		
+		if(!$db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't alter categories order data.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		return;
+	}
+}
+?>

Added: main/trunk/install/kb_install.php
===================================================================
--- main/trunk/install/kb_install.php	                        (rev 0)
+++ main/trunk/install/kb_install.php	2007-01-26 18:02:51 UTC (rev 42)
@@ -0,0 +1,138 @@
+<?php
+/***************************************************************************
+ *                               kb_install.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.
+ *
+ ***************************************************************************/
+
+define('IN_PHPBB', true);
+$phpbb_root_path = './';
+include($phpbb_root_path . 'extension.inc');
+include($phpbb_root_path . 'common.' . $phpEx);
+
+//
+// Start session management
+//
+$userdata = session_pagestart($user_ip, PAGE_INDEX);
+init_userprefs($userdata);
+//
+// End session management
+//
+
+
+if( !$userdata['session_logged_in'] )
+{
+	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
+	header($header_location . append_sid($phpbb_root_path . "login.$phpEx?redirect=kb_install.$phpEx", true));
+	exit;
+}
+
+if( $userdata['user_level'] != ADMIN )
+{
+	message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
+}
+
+$page_title = 'phpBB Knowledge Base MOD';
+include('includes/page_header.' . $phpEx);
+
+$sql = array();
+$sql[] = "CREATE TABLE " . $table_prefix . "kb_categories (
+   cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+   cat_main mediumint(8) UNSIGNED DEFAULT '0',
+   cat_title varchar(100) NOT NULL,
+   cat_desc varchar(255) NOT NULL,
+   cat_articles mediumint(8) UNSIGNED DEFAULT '0',
+   cat_order mediumint(8) UNSIGNED NOT NULL,
+   auth_view tinyint(1) NOT NULL default '0',
+   auth_add tinyint(1) NOT NULL default '0',
+   auth_edit tinyint(1) NOT NULL default '0',
+   auth_delete tinyint(1) NOT NULL default '0',
+   auth_mod tinyint(1) NOT NULL default '0',
+   auth_comment tinyint(1) NOT NULL default '0',
+   auth_rate tinyint(1) NOT NULL default '0',
+   auth_attach tinyint(1) NOT NULL default '0',
+   PRIMARY KEY (cat_id),
+   KEY cat_order (cat_order)
+)";
+
+$sql[] = "CREATE TABLE " . $table_prefix . "kb_articles (
+   article_id mediumint(8) UNSIGNED NOT NULL auto_increment,
+   article_title varchar(100) NOT NULL,
+   article_desc varchar(255) NOT NULL,
+   article_author mediumint(8) UNSIGNED NOT NULL,
+   article_authorname varchar(50) NOT NULL,
+   article_time int(20) UNSIGNED DEFAULT '0',
+   article_edittime int(20) UNSIGNED DEFAULT '0',
+   article_hits mediumint(8) UNSIGNED DEFAULT '0',
+   article_editby mediumint(8) UNSIGNED DEFAULT '0',
+   article_status smallint(1) UNSIGNED DEFAULT '0',
+   bbcode_uid varchar(10) NOT NULL,
+   enable_sig smallint(1) UNSIGNED DEFAULT '0',
+   enable_html smallint(1) UNSIGNED DEFAULT '0',
+   enable_bbcode smallint(1) UNSIGNED DEFAULT '0',
+   enable_smilies smallint(1) UNSIGNED DEFAULT '0',
+   article_text text,
+   PRIMARY KEY (article_id)
+)";
+
+$sql[] = "CREATE TABLE " . $table_prefix . "kb_articlecats (
+	article_id mediumint(8) NOT NULL DEFAULT '0',
+	cat_id mediumint(8) NOT NULL DEFAULT '0'
+)";
+
+$sql[] = "CREATE TABLE " . $table_prefix . "kb_auth_access (
+   group_id mediumint(8) NOT NULL default '0',
+   cat_id smallint(5) unsigned NOT NULL default '0',
+   auth_view tinyint(1) NOT NULL default '0',
+   auth_add tinyint(1) NOT NULL default '0',
+   auth_edit tinyint(1) NOT NULL default '0',
+   auth_delete tinyint(1) NOT NULL default '0',
+   auth_mod tinyint(1) NOT NULL default '0',
+   auth_comment tinyint(1) NOT NULL default '0',
+   auth_rate tinyint(1) NOT NULL default '0',
+   auth_attach tinyint(1) NOT NULL default '0',
+  KEY group_id (group_id),
+  KEY cat_id (cat_id)
+)";
+
+echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
+echo '<tr><th>Updating the database</th></tr>';
+
+for( $i = 0; $i < count($sql); $i++ )
+{
+	$msg = '<tr><td class="catLeft" height="28"><span class="forumlink">';
+
+	if( !$result = $db->sql_query($sql[$i]) )
+	{
+		$error = $db->sql_error();
+		$msg .= '<font color="#FF0000"><b>Error:</b></font> ' . $error['message'];
+	}
+	else
+	{
+		$msg .= '<font color="#00AA00"><b>Successfull</b></font>';
+	}
+
+	$msg .= '</span></td><tr><td class="row1"><pre class="genmed">' . $sql[$i] . '</pre></td></tr>';
+	echo $msg;
+}
+
+echo '<tr><th height="28">End</th></tr><tr><td class="row1"><span class="genmed">Installation is now finished. Please be sure to delete this file now.<br />';
+echo 'If you have run into any errors, please visit the '.
+	'<a href="http://www.phpbbknowledgebase.com" target="_blank">phpBB Knowledge Base Forums</a> or the <a href="http://www.phpbb.com/phpBB/viewtopic.php?t=415458" target="_blank">phpBB.com topic</a> and ask someone for help.</span></td></tr>';
+echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid($phpbb_root_path . "index.$phpEx") . '">Have a nice day, and thanks for using the phpBB Knowledge Base MODification!</a></span></td></table>';
+
+include('includes/page_tail.' . $phpEx);
+?>
\ No newline at end of file

Added: main/trunk/kb.php
===================================================================
--- main/trunk/kb.php	                        (rev 0)
+++ main/trunk/kb.php	2007-01-26 18:02:51 UTC (rev 42)
@@ -0,0 +1,624 @@
+<?php
+/***************************************************************************
+ *                               kb.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.
+ *
+ ***************************************************************************/
+define('IN_PHPBB', true);
+$phpbb_root_path = './';
+include($phpbb_root_path . 'extension.inc');
+include($phpbb_root_path . 'common.' . $phpEx);
+include($phpbb_root_path . 'kb/constants.' . $phpEx); // Added these two files, yes i could just add the 10-15 lines it will end with in
+include($phpbb_root_path . 'kb/functions.' . $phpEx); // the existing files, but this makes it a lot easier to install/uninstall.
+include($phpbb_root_path . 'includes/bbcode.'.$phpEx);
+
+//
+// Start session management
+//
+$userdata = session_pagestart($user_ip, PAGE_KB);
+init_userprefs($userdata);
+//
+// End session management
+//
+
+// File takes care of the following action set via $pid ($HTTP_GET_VARS['pid']):
+// main - views categories, with subcategories listed
+// view_cat - views a category, either lists subcategories or articles contained, or both ofc.
+// view_article - views an article
+// ucp - My idea of this is that it should be the complete possibility for users here. If they are normal users, they can see their own
+//		 articles and if they get approved or not. They can also view their comments, and wether they are approved or not. This should
+//		 also include mod options for admins. Approving/disapproving comments or articles, editing them, so on...
+// search - the kb search engine...
+// More will come whenever i figure something out. Now i'll start coding. :D // Imladris
+include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_kb.' . $phpEx);
+$pid = ( isset($HTTP_GET_VARS['pid']) ) ? $HTTP_GET_VARS['pid'] : "main";
+
+// Making sure the install file has been removed
+if(file_exists($phpbb_root_path . "kb_install." . $phpEx))
+{
+	message_die(GENERAL_MESSAGE, $lang['kb_remove_installfile']);
+}
+
+switch($pid)
+{
+	case "main":
+		$sql = "SELECT c.cat_id, c.cat_main, c.cat_title, c.cat_desc, c.cat_articles, c.cat_order
+			FROM " . KB_CATEGORIES_TABLE . " c
+			WHERE c.cat_main = '0'
+			ORDER BY c.cat_order ASC";
+		if( !($result = $db->sql_query($sql)) )
+		{
+			message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
+		}
+		
+		$catrows = array();
+		while ($row = $db->sql_fetchrow($result))
+		{
+			$catrows[] = $row;
+		}
+		
+		// Start Page output
+		$page_title = $lang['kb_main'];
+		include($phpbb_root_path . 'includes/page_header.' . $phpEx);
+		create_navigation();
+	
+		$template->set_filenames(array(
+			'body' => 'kb_main.tpl')
+		);
+		
+		if($userdata['session_logged_in'])
+		{
+			$template->assign_block_vars('switch_add_article', array());
+		}
+		
+		$template->assign_vars(array(
+			'L_CATEGORIES' => $lang['kb_categories'],
+			'L_ARTICLES' => $lang['kb_articles'],
+			'L_ADD_ARTICLE' => $lang['kb_ucp_articlepost'],
+			'U_ADD_ARTICLE' => append_sid("kb." . $phpEx . "?pid=ucp&action=post_article"))
+		);
+		
+		if($total_catrows = count($catrows))
+		{
+			for($i = 0; $i < $total_catrows; $i++)
+			{
+				//$auth = kb_auth("view", $catrows[$i]['cat_id'], $userdata);
+				
+				// auth not included in alpha
+				//if($auth['auth_view'])
+				//{
+					// Ok display one cat here
+					$template->assign_block_vars('catrow', array(
+						'CAT_TITLE' => $catrows[$i]['cat_title'],
+						'CAT_DESC' => $catrows[$i]['cat_desc'],
+						'CAT_ARTICLES' => $catrows[$i]['cat_articles'],
+						'U_VIEWCAT' => append_sid("kb." . $phpEx . "?pid=view_cat&amp;id=" . $catrows[$i]['cat_id']),
+						'L_SUBCATS' => $lang['kb_subcats'],
+						'FORUM_FOLDER_IMG' => $images['forum']) // Stolen :D
+					);
+					
+					// Now let's look at subcats
+					$sql = "SELECT c.cat_id, c.cat_main, c.cat_title, c.cat_order
+						FROM " . KB_CATEGORIES_TABLE . " c
+						WHERE c.cat_main = '" . $catrows[$i]['cat_id'] . "'
+						ORDER BY c.cat_order ASC";
+					if( !($result = $db->sql_query($sql)) )
+					{
+						message_die(GENERAL_ERROR, 'Could not query subcategories list', '', __LINE__, __FILE__, $sql);
+					} 
+					
+					$subcats = array();
+					while ($row = $db->sql_fetchrow($result))
+					{
+						$subcats[] = $row;
+					}
+					
+					if($total_subcats = count($subcats))
+					{
+						// Contains subcats, show them
+						$template->assign_block_vars('catrow.switch_subcats', array());
+						
+						for($j = 0; $j < $total_subcats; $j++)
+						{
+							//$auth = kb_auth("view", $subcats[$j]['cat_id'], $userdata);
+							
+							// auth not included in alpha
+							//if($auth['auth_view'])
+							//{
+								// Show the subcat
+								$k = $j + 1;
+								$subcat_comma = ( isset($subcats[$k]) ) ? ",&nbsp;" : ".";
+								$template->assign_block_vars('catrow.subcatrow', array(
+									'U_SUBCAT' => append_sid("kb." . $phpEx . "?pid=view_cat&amp;id=" . $subcats[$j]['cat_id']),
+									'SUBCAT_TITLE' => $subcats[$j]['cat_title'],
+									'SUBCAT_COMMA' => $subcat_comma)
+								);
+							//} // if auth view
+						} // for subcats
+					} // if subcats
+				//} // auth view
+			} // for cats
+		}// total cats
+		else
+		{
+			message_die(GENERAL_MESSAGE, $lang['No_kb_cats']);
+		}
+		
+		//
+		// Generate the page
+		//
+		$template->pparse('body');
+		
+		include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
+		break;
+		
+	case "view_cat":
+		$cat_id = ( isset( $HTTP_GET_VARS['id'] ) ) ? $HTTP_GET_VARS['id'] : false;
+		if(!$cat_id)
+		{
+			message_die(GENERAL_MESSAGE, $lang['kb_cat_noexist']);
+		}
+		
+		// Store the main cat in a variable
+		$sql = "SELECT *
+				FROM " . KB_CATEGORIES_TABLE . " 
+				WHERE cat_id = '" . $cat_id . "'";
+		if( !($result = $db->sql_query($sql)) )
+		{
+			message_die(GENERAL_ERROR, 'Could not query the main category', '', __LINE__, __FILE__, $sql);
+		}
+		$cat = $db->sql_fetchrow($result);
+		
+		// Let's find subcats
+		$sql = "SELECT c.cat_id, c.cat_main, c.cat_title, c.cat_desc, c.cat_articles, c.cat_order
+				FROM " . KB_CATEGORIES_TABLE . " c
+				WHERE c.cat_main = '$cat_id'
+				ORDER BY c.cat_order ASC";
+		if( !($result = $db->sql_query($sql)) )
+		{
+			message_die(GENERAL_ERROR, 'Could not query subcategories list', '', __LINE__, __FILE__, $sql);
+		}
+		
+		$subcats = array();
+		while($row = $db->sql_fetchrow($result))
+		{
+			$subcats[] = $row;
+		}
+		
+		// Now articles, the LIKE handles multiple cats
+		// First handle the sorting
+		// default is by edit time, other options: -rating, -author, -title
+		if(isset($HTTP_GET_VARS['sort']))
+		{
+			switch($HTTP_GET_VARS['sort'])
+			{
+				case "rating":
+					// Later
+					$sort = "ORDER BY a.article_edittime DESC";
+					break;
+					
+				case "author":
+					// Later
+					$sort = "ORDER BY a.article_edittime DESC";
+					break;
+				
+				case "title":
+					$sort = "ORDER BY a.article_title";
+					break;
+				
+				case "time":
+				default:
+					$sort = "ORDER BY a.article_edittime DESC";
+					break;
+			}
+		}
+		else
+		{
+			$sort = "ORDER BY a.article_edittime DESC";
+		}
+		
+		$sql = "SELECT a.*
+				FROM " . KB_ARTICLECATS_TABLE . " c, " . KB_ARTICLES_TABLE . " a
+				WHERE c.cat_id = '$cat_id'
+				AND c.article_id = a.article_id
+				$sort";
+		if( !($result = $db->sql_query($sql)) )
+		{
+			message_die(GENERAL_ERROR, 'Could not query articles.', '', __LINE__, __FILE__, $sql);
+		}
+		
+		$articles = array();
+		while($row = $db->sql_fetchrow($result))
+		{			
+			$articles[] = $row;
+		}
+		
+		// Start Page output
+		$page_title = $lang['kb_viewcat'] . ": " . $cat['cat_title'];
+		include($phpbb_root_path . 'includes/page_header.'.$phpEx);
+		
+		if($cat['cat_main'] == "0")
+		{
+			create_navigation("viewcat", array(
+				0 => $cat['cat_id'],
+				1 => $cat['cat_title'])
+			);
+		}
+		else
+		{
+			create_navigation("viewsubcat", array(
+				0 => $cat_id,
+				1 => $cat['cat_title'],
+				2 => $cat['cat_main'])
+			);
+		}
+		
+		$template->set_filenames(array(
+			'body' => 'kb_viewcat.tpl')
+		);
+		
+		if($userdata['session_logged_in'])
+		{
+			$template->assign_block_vars('switch_add_article', array());
+		}
+		
+		// Process the whole thing
+		$template->assign_vars(array(
+			'L_VIEWS' => $lang['Views'],
+			'L_AUTHOR' => $lang['Author'],
+			'L_ARTICLES' => $lang['kb_articles'],
+			'L_SUBCATS' => sprintf($lang['kb_viewcat_subcats'], $cat['cat_title']),
+			'L_LAST_ACTION' => $lang['kb_last_action'],
+			'L_ADD_ARTICLE' => $lang['kb_ucp_articlepost'],
+			'U_ADD_ARTICLE' => append_sid("kb." . $phpEx . "?pid=ucp&action=post_article"))
+		);
+		
+		if( $total_subcats = count($subcats) )
+		{
+			$template->assign_block_vars('switch_subcats', array());
+			
+			// Ok it contains subcats, let's build them.
+			for($i = 0; $i < $total_subcats; $i++)
+			{
+				// Ok display one cat here
+				$template->assign_block_vars('switch_subcats.catrow', array(
+					'CAT_TITLE' => $subcats[$i]['cat_title'],
+					'CAT_DESC' => $subcats[$i]['cat_desc'],
+					'CAT_ARTICLES' => $subcats[$i]['cat_articles'],
+					'U_VIEWCAT' => append_sid("kb." . $phpEx . "?pid=view_cat&amp;id=" . $subcats[$i]['cat_id']),
+					'FORUM_FOLDER_IMG' => $images['forum']) // Stolen :D
+				);
+			}
+		}
+		
+		if( $total_articles = count($articles) )
+		{
+			$template->assign_block_vars('switch_articles', array());
+			
+			// Contains articles
+			for($i = 0; $i < $total_articles; $i++)
+			{
+				if($articles[$i]['article_authorname'] == "")
+				{
+					$sql = "SELECT username
+							FROM " . USERS_TABLE . "
+							WHERE user_id = '" . $articles[$i]['article_author'];
+					if( !($result = $db->sql_query($sql)) )
+					{
+						message_die(GENERAL_ERROR, 'Could not query authorname', '', __LINE__, __FILE__, $sql);
+					}
+					
+					$user = $db->sql_fetchrow($result);
+					$authorname = $user['username'];
+				}
+				else
+				{
+					$authorname = $articles[$i]['article_authorname'];
+				}
+				$author = "<a href=\"profile." . $phpEx . "?mode=viewprofile&amp;u=" . $articles[$i]['article_author'] . "\">$authorname</a>";
+				
+				$sql = "SELECT username
+						FROM " . USERS_TABLE . "
+						WHERE user_id = '" . $articles[$i]['article_editby'] . "'";
+				if( !($result = $db->sql_query($sql)) )
+				{
+					message_die(GENERAL_ERROR, 'Could not query last edited by\'s username.', '', __LINE__, __FILE__, $sql);
+				}
+				
+				$user = $db->sql_fetchrow($result);
+				$last_action = sprintf($lang['kb_last_action_row'], "<a href=\"profile." . $phpEx . "?mode=viewprofile&amp;u=" . $articles[$i]['article_editby'] . "\">" . $user['username'] . "</a>", create_date($board_config['default_dateformat'], $articles[$i]['article_edittime'], $board_config['board_timezone']));
+				
+				$template->assign_block_vars('switch_articles.articlerow', array(
+					'TOPIC_FOLDER_IMG' => $images['folder'],
+					'ARTICLE_TITLE' => $articles[$i]['article_title'],
+					'ARTICLE_DESC' => $articles[$i]['article_desc'],
+					'ARTICLE_AUTHOR' => $author,
+					'ARTICLE_HITS' => $articles[$i]['article_hits'],
+					'ARTICLE_LAST_ACTION' => $last_action,
+					'U_VIEW_ARTICLE' => append_sid("kb." . $phpEx . "?pid=view_article&amp;cid=" . $cat_id . "&amp;id=" . $articles[$i]['article_id']))
+				);
+			}
+		}
+		
+		//
+		// Generate the page
+		//
+		$template->pparse('body');
+		
+		include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
+		break;
+		
+	case "view_article":
+		$cid = ( empty($HTTP_GET_VARS['cid']) ) ? false : $HTTP_GET_VARS['cid'];
+		$id = ( empty($HTTP_GET_VARS['id']) ) ? false : $HTTP_GET_VARS['id'];
+		
+		// Get naughty words :)
+		$orig_word = array();
+		$replacement_word = array();
+		obtain_word_list($orig_word, $replacement_word);
+		
+		$sql = "SELECT a.*, u.*
+				FROM " . KB_ARTICLES_TABLE . " a, " . USERS_TABLE . " u
+				WHERE a.article_id = '$id'
+				AND a.article_author = u.user_id";
+		if( !($result = $db->sql_query($sql)) )
+		{
+			message_die(GENERAL_ERROR, 'Could not query article info', '', __LINE__, __FILE__, $sql);
+		}
+		
+		$article = $db->sql_fetchrow($result);
+		
+		$sql = "SELECT c.*, ca.*
+				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);
+		}
+		
+		//
+		// These vars are for later use
+		//
+		$in_cat = false;
+		$cats = array();
+		while($row = $db->sql_fetchrow($result))
+		{
+			$cats[] = $row;
+			
+			if($row['cat_id'] == $cid)
+			{
+				$in_cat = true;
+				$current_cat['cat_title'] = $row['cat_title'];
+				$current_cat['cat_id'] = $row['cat_id'];
+				$current_cat['cat_main'] = $row['cat_main'];
+			}
+		}
+		
+		//
+		// Check that the given category is true
+		//
+		if(!$in_cat)
+		{
+			message_die(GENERAL_MESSAGE, "The category specified in GET variables did not exist along with this article in the database.");
+		}
+		
+		$article_title = $article['article_title'];
+		$article_text = $article['article_text'];
+		$article_bbcode_uid = $article['bbcode_uid'];
+		
+		$user_sig = ( $article['enable_sig'] && $article['user_sig'] != '' && $board_config['allow_sig'] ) ? $article['user_sig'] : '';
+		$user_sig_bbcode_uid = $article['user_sig_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 ( !$board_config['allow_html'] || !$userdata['user_allowhtml'])
+		{
+			if ( $user_sig != '' )
+			{
+				$user_sig = preg_replace('#(<)([\/]?.*?)(>)#is', "&lt;\\2&gt;", $user_sig);
+			}
+	
+			if ( $article['enable_html'] )
+			{
+				$article_text = preg_replace('#(<)([\/]?.*?)(>)#is', "&lt;\\2&gt;", $article_text);
+			}
+		}
+	
+		//
+		// Parse message and/or sig for BBCode if reqd
+		//
+		if ($user_sig != '' && $user_sig_bbcode_uid != '')
+		{
+			$user_sig = ($board_config['allow_bbcode']) ? bbencode_second_pass($user_sig, $user_sig_bbcode_uid) : preg_replace("/\:$user_sig_bbcode_uid/si", '', $user_sig);
+		}
+	
+		if ($article_bbcode_uid != '')
+		{
+			$article_text = ($board_config['allow_bbcode']) ? bbencode_second_pass($article_text, $article_bbcode_uid) : preg_replace("/\:$article_bbcode_uid/si", '', $article_text);
+		}
+	
+		if ( $user_sig != '' )
+		{
+			$user_sig = make_clickable($user_sig);
+		}
+		$article_text = make_clickable($article_text);
+	
+		//
+		// Parse smilies
+		//
+		if ( $board_config['allow_smilies'] )
+		{
+			if ( $article['user_allowsmile'] && $user_sig != '' )
+			{
+				$user_sig = smilies_pass($user_sig);
+			}
+	
+			if ( $article['enable_smilies'] )
+			{
+				$article_text = smilies_pass($article_text);
+			}
+		}
+	
+		//
+		// Replace naughty words
+		//
+		if (count($orig_word))
+		{
+			$article_title = preg_replace($orig_word, $replacement_word, $article_title);
+			$article_desc = preg_replace($orig_word, $replacement_word, $article_desc);
+	
+			if ($user_sig != '')
+			{
+				$user_sig = str_replace('\"', '"', substr(@preg_replace('#(\>(((?>([^><]+|(?R)))*)\<))#se', "@preg_replace(\$orig_word, \$replacement_word, '\\0')", '>' . $user_sig . '<'), 1, -1));
+			}
+	
+			$article_text = str_replace('\"', '"', substr(@preg_replace('#(\>(((?>([^><]+|(?R)))*)\<))#se', "@preg_replace(\$orig_word, \$replacement_word, '\\0')", '>' . $article_text . '<'), 1, -1));
+		}
+	
+		//
+		// Replace newlines (we use this rather than nl2br because
+		// till recently it wasn't XHTML compliant)
+		//
+		if ( $user_sig != '' )
+		{
+			$user_sig = '<br />_________________<br />' . str_replace("\n", "\n<br />\n", $user_sig);
+		}
+	
+		$article_text = str_replace("\n", "\n<br />\n", $article_text);
+		
+		// Start Page output
+		$page_title = $lang['kb_viewarticle'] . " : " . $article_title;
+		include($phpbb_root_path . 'includes/page_header.' . $phpEx);
+		
+		$template->set_filenames(array(
+			'body' => 'kb_viewarticle.tpl')
+		);
+		
+		create_navigation("viewarticle", array(
+			0 => $current_cat['cat_id'],
+			1 => $current_cat['cat_title'],
+			2 => $current_cat['cat_main'],
+			3 => $article['article_id'],
+			4 => $article_title)
+		);
+		
+		$posted_by = sprintf($lang['kb_posted_by'], '<a href="' . append_sid('profile.' . $phpEx . '?mode=viewprofile&amp;u=' . $article['article_author']) . '">' . $article['article_authorname'] . '</a>', create_date($board_config['default_dateformat'], $article['article_time'], $board_config['board_timezone']), create_date($board_config['default_dateformat'], $article['article_edittime'], $board_config['board_timezone']));
+		
+		$template->assign_vars(array(
+			'U_VIEW_ARTICLE' => append_sid('kb.' . $phpEx . '?pid=view_article&amp;cid=' . $cid . '&amp;id=' . $article['article_id']),
+			'ARTICLE_TITLE' => $article_title,
+			'ARTICLE_TEXT' => $article_text,
+			'POSTED_BY' => $posted_by,
+			'SIGNATURE' => $user_sig,
+			'L_EDITARTICLE' => $lang['kb_ucp_articleedit'],
+			'L_DELETEARTICLE' => $lang['kb_ucp_articledelete'],
+			
+			'U_EDITARTICLE' => append_sid('kb.' . $phpEx . '?pid=ucp&action=edit_article&id=' . $id),
+			'U_DELETEARTICLE' => append_sid('kb.' . $phpEx . '?pid=ucp&action=delete_article&id=' . $id))
+		);
+		
+		if(($userdata['user_level'] == ADMIN) || ($userdata['user_id'] == $article['article_author']))
+		{
+			$template->assign_block_vars('switch_mod', array());
+		}
+		
+		//
+		// Generate the page
+		//
+		$template->pparse('body');
+		
+		include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
+		break;
+		
+	case "ucp":
+		$action = ( isset($HTTP_GET_VARS['action']) ) ? $HTTP_GET_VARS['action'] : "";
+		/*include($phpbb_root_path . "kb/ucp_class." . $phpEx);
+		$ucp = new ucp;
+		
+		// Start Page output
+		$page_title = $ucp->generate_page_title($action);
+		include($phpbb_root_path . 'includes/page_header.' . $phpEx);
+		
+		$ucp->generate_page($action, $HTTP_GET_VARS['id'], $HTTP_GET_VARS['preview']);
+		*/
+		// The above have been removed and changed to functions.php
+		$id = isset($HTTP_GET_VARS['id']) ? $HTTP_GET_VARS['id'] : 0;
+		$preview = isset($HTTP_POST_VARS['preview']) ? true : false;
+		
+		$page_title = ucp_generate_page_title($action);
+		include($phpbb_root_path . 'includes/page_header.' . $phpEx);
+		
+		switch($action)
+		{
+			case "articles":
+				break;
+				
+			case "comments":
+				break;
+				
+			case "post_article":
+				ucp_article_form("post", false, $preview);
+				break;
+				
+			case "edit_article":
+				ucp_article_form("edit", $id, $preview);
+				break;
+				
+			case "delete_article":
+				$confirm = isset($HTTP_POST_VARS['confirm']) ? true : false;
+				ucp_article_delete($id, $confirm);
+				break;
+				
+			case "post_comment": // Only input
+				break;
+				
+			case "edit_comment":
+				break;
+				
+			case "delete_comment":
+				break;
+			
+			default:
+				break;
+		}
+		
+		//
+		// Generate the page
+		//
+		if($action != "delete_article")
+		{
+			$template->pparse('body');
+		}
+		
+		include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
+		break;
+		
+	case "search":
+		break;
+		
+	case "comment":
+		// For Adding, deleting and editing comments, this includes rating.
+		break;
+		
+	default:
+		message_die(GENERAL_MESSAGE, 'Wrong page id defined. No page shown.');
+		break;
+}
+?>
\ No newline at end of file

Added: main/trunk/language/lang_english/lang_kb.php
===================================================================
--- main/trunk/language/lang_english/lang_kb.php	                        (rev 0)
+++ main/trunk/language/lang_english/lang_kb.php	2007-01-26 18:02:51 UTC (rev 42)
@@ -0,0 +1,97 @@
+<?php
+/***************************************************************************
+ *                               lang_kb.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.
+ *
+ ***************************************************************************/
+
+// Page titles
+$lang['kb_main'] = "Knowledge Base Home";
+$lang['kb_viewcat'] = "Viewing Category";
+$lang['kb_viewarticle'] = "Viewing Article";
+$lang['kb_ucp'] = "KB User Control Panel"; 
+$lang['kb_ucp_articlepost'] = "Post new article";
+$lang['kb_ucp_articleedit'] = "Edit article";
+$lang['kb_ucp_articledelete'] = "Delete article";
+
+// Normal Page
+$lang['kb_categories'] = "Knowledge Base Categories";
+$lang['kb_articles'] = "Articles";
+$lang['kb_subcats'] = "Subcategories";
+$lang['kb_remove_installfile'] = "Please ensure that you remove the kb_install.php file located in your phpBB root folder. The Knowledge Base Modification <strong>will not</strong> work before the file is removed.";
+$lang['No_kb_cats'] = "No Knowledge Base categories have been added.";
+$lang['kb_cat_noexist'] = "The category you have chosen does not exist.";
+
+$lang['kb_viewcat_subcats'] = "Subcategories in %s";
+$lang['kb_last_action'] = "Last action";
+$lang['kb_last_action_row'] = "Last action for this article was comitted by %s on the %s";
+
+// Posting Page
+$lang['kb_post_article'] = "Post New Article";
+$lang['kb_edit_article'] = "Edit Article";
+$lang['kb_authorname'] = "Author Name";
+$lang['kb_authorname_desc'] = "This is the name that will be displayed, you can leave your forum username here if you require, or replace it with another name."; 
+$lang['kb_articlename'] = "Article Name";
+$lang['kb_articledesc'] = "Article Description";
+$lang['kb_articlecats'] = "Article Categories";
+$lang['kb_articletext'] = "Article Content";
+$lang['kb_articledesc_desc'] = "Description of your article, max. 255 characters.";
+$lang['kb_articlecats_desc'] = "Choose what categories your article will appear in, use Ctrl & Click for multiple.";
+$lang['kb_empty_article'] = "The article content you have submitted was empty.";
+$lang['kb_empty_article_title'] = "The article title you submitted was empty.";
+$lang['kb_empty_cats'] = "The article you submitted had no category defined.";
+$lang['kb_empty_article_desc'] = "The article has to contain an article description.";
+$lang['kb_added'] = "Your article has been submitted and is awaiting approval.";
+$lang['kb_deleted'] = "Your article has been deleted and is now nonexistant.";
+$lang['kb_edited'] = "Your article has been edited and is awaiting reapproval.";
+$lang['kb_click_view_article'] = "Click %shere%s to view you article."; // Change this later on, they can't view the article yet.
+$lang['kb_click_return_ucp'] = "Click %shere%s to go back to the user control panel";
+$lang['kb_posted_by'] = "This article was submitted by %s on %s, it was last updated on %s.";
+$lang['kb_confirm_deletearticle'] = "Are you sure you want to delete this article?";
+$lang['kb_articlepreview'] = "Article Preview";
+
+// Auth
+$lang['kb_edit_noauth'] = "You are not allowed to edit this article.";
+$lang['kb_delete_noauth'] = "You are not allowed to delete this article.";
+
+// Admin
+$lang['kbadm_header_editcat'] = "Edit Category";
+$lang['kbadm_explain_editcat'] = "Here you can edit the chosen category, specifying its name, parent category and description.";
+$lang['kbadm_cat_settings'] = "Category Properties";
+$lang['kbadm_cat_title'] = "Category Title";
+$lang['kbadm_cat_desc'] = "Category Description";
+$lang['kbadm_cat_parent'] = "Parent Category";
+$lang['kbadm_empty_cat_title'] = "The Category Title submitted was empty.";
+$lang['kbadm_empty_cat_desc'] = "The Category Description submitted was empty.";
+$lang['kbadm_confirm_deletecat'] = "Are you sure you want to delete this category?";
+$lang['kbadm_Click_return_catadmin'] = "Click %shere%s to return to category administration.";
+$lang['kbadm_header_addcat'] = "Add Category";
+$lang['kbadm_explain_addcat'] = "From here you can add a new category.";
+$lang['kbadm_addcat'] = "Add";
+$lang['kbadm_editcat'] = "Edit";
+
+$lang['kbadm_movecatup'] = "Move Up";
+$lang['kbadm_movecatdown'] = "Move Down";
+$lang['kbadm_delcat'] = "Delete";
+$lang['kbadm_maincat_explain'] = "This is the place where you can move categories up and down, create new ones and edit the already existant.";
+
+$lang['kbadm_delcat_success'] = "The category has been deleted successfully.";
+$lang['kbadm_editcat_success'] = "The category has been edited successfully.";
+$lang['kbadm_addcat_success'] = "Your new category has been added.";
+$lang['kbadm_sortcat_success'] = "The category has been moved as specified.";
+
+$lang['No_kbadm_cats'] = "No knowledge base categories has been added. Click %shere%s to create a new one.";
+?>
\ No newline at end of file

Added: main/trunk/templates/subSilver/admin/kb_cats.tpl
===================================================================
--- main/trunk/templates/subSilver/admin/kb_cats.tpl	                        (rev 0)
+++ main/trunk/templates/subSilver/admin/kb_cats.tpl	2007-01-26 18:02:51 UTC (rev 42)
@@ -0,0 +1,66 @@
+<h1>{L_HEADER}</h1>
+
+<p>{L_EXPLAIN}</p>
+
+<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
+  <tr> 
+	<th colspan="2" class="thCornerL" height="25" nowrap="nowrap">&nbsp;{L_CATEGORIES}&nbsp;</th>
+	<th class="thCornerR" colspan="4" nowrap="nowrap">&nbsp;</th>
+  </tr>
+  <tr> 
+	<td class="catLeft" colspan="2" height="28"><span class="cattitle">&nbsp;</span></td>
+	<td class="rowpic" colspan="4" align="right">&nbsp;</td>
+  </tr>
+  <!-- BEGIN catrow -->
+  <tr> 
+	<td class="row1" align="center" valign="middle" height="50"><img src="{catrow.FORUM_FOLDER_IMG}" width="46" height="25" /></td>
+	<td class="row1" width="100%" height="50">{catrow.CAT_TITLE}<br />
+	  </span> <span class="genmed">{catrow.CAT_DESC}</td>
+	<td class="row1" align="center" valign="middle" height="50" nowrap="nowrap"><span class="genmed"><a href="{catrow.U_EDITCAT}">{L_EDITCAT}</a></span></td>
+	<td class="row1" align="center" valign="middle" height="50" nowrap="nowrap"><span class="genmed">{catrow.MOVECAT_UP}</span></td>
+	<td class="row1" align="center" valign="middle" height="50" nowrap="nowrap"><span class="genmed">{catrow.MOVECAT_DOWN}</span></td>
+	<td class="row1" align="center" valign="middle" height="50" nowrap="nowrap"><span class="genmed"><a href="{catrow.U_DELCAT}">{L_DELCAT}</a></span></td>
+  </tr>
+  <!-- BEGIN subcatrow -->
+  <tr> 
+	<td class="row2" align="center" valign="middle" height="50"><img src="{catrow.subcatrow.TOPIC_FOLDER_IMG}" width="19" height="18" /></td>
+	<td class="row2" width="100%" height="50">{catrow.subcatrow.SUBCAT_TITLE}<br />
+	  <span class="genmed">{catrow.subcatrow.SUBCAT_DESC}</span></td>
+	<td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"><span class="genmed"><a href="{catrow.subcatrow.U_EDITSUBCAT}">{L_EDITCAT}</a></span></td>
+	<td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"><span class="genmed">{catrow.subcatrow.MOVESUBCAT_UP}</span></td>
+	<td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"><span class="genmed">{catrow.subcatrow.MOVESUBCAT_DOWN}</span></td>
+	<td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"><span class="genmed"><a href="{catrow.subcatrow.U_DELSUBCAT}">{L_DELCAT}</a></span></td>
+  </tr>
+  <!-- END subcatrow -->
+  <!-- END catrow -->
+  <tr> 
+	  <td class="catBottom" align="center" valign="middle" colspan="6" height="28">&nbsp;</td>
+  </tr>
+</table>
+
+<br clear="all" />
+
+<form action="{S_FORUM_ACTION}" method="post">
+  <table width="100%" cellpadding="4" cellspacing="1" border="0" class="forumline" align="center">
+	<tr> 
+	  <th class="thHead" colspan="2">{L_CAT_SETTINGS}</th>
+	</tr>
+	<tr> 
+	  <td class="row1">{L_CAT_TITLE}</td>
+	  <td class="row2"><input type="text" size="25" name="title" value="" class="post" /></td>
+	</tr>
+	<tr> 
+	  <td class="row1">{L_CAT_DESCRIPTION}</td>
+	  <td class="row2"><textarea rows="5" cols="45" wrap="virtual" name="desc" class="post"></textarea></td>
+	</tr>
+	<tr> 
+	  <td class="row1">{L_CAT_PARENT}</td>
+	  <td class="row2">{S_PARENT}</td>
+	</tr>
+	<tr> 
+	  <td cl...
 
[truncated message content]