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

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

Revision: 69
          http://svn.sourceforge.net/phpbbkb/?rev=69&view=rev
Author:   softphp
Date:     2007-04-05 01:00:39 -0700 (Thu, 05 Apr 2007)

Log Message:
-----------
- Added authorization options in acp
- Other auth stuff, more will follow.
Please note that kb.php is broken at the moment.

Modified Paths:
--------------
    main/trunk/admin/admin_kb.php
    main/trunk/includes/auth_kb.php
    main/trunk/includes/constants.php
    main/trunk/includes/functions_kb.php
    main/trunk/kb.php
    main/trunk/language/lang_english/lang_admin.php
    main/trunk/language/lang_english/lang_kb.php

Added Paths:
-----------
    main/trunk/templates/subSilver/admin/kb_auth.tpl
    main/trunk/templates/subSilver/admin/kb_ugauth.tpl

Modified: main/trunk/admin/admin_kb.php
===================================================================
--- main/trunk/admin/admin_kb.php	2007-03-18 17:29:45 UTC (rev 68)
+++ main/trunk/admin/admin_kb.php	2007-04-05 08:00:39 UTC (rev 69)
@@ -23,7 +23,9 @@
 if( !empty($setmodules) )
 {
 	$file = basename(__FILE__);
-	$module['KB']['Categories'] = "$file?mode=cats";
+	$module['KB']['kbadm_Categories'] = "$file?mode=cats";
+	$module['KB']['kbadm_Auth'] = "$file?mode=auth";
+	$module['KB']['kbadm_Group_Auth'] = "$file?mode=ugauth";
 	return;
 }
 
@@ -444,7 +446,7 @@
 			'L_CATEGORIES' => $lang['kb_categories'],
 			'L_EDITCAT' => $lang['kbadm_editcat'],
 			'L_DELCAT' => $lang['kbadm_delcat'],
-			'L_HEADER' => $lang['Categories'],
+			'L_HEADER' => $lang['kbadm_Categories'],
 			'L_EXPLAIN' => $lang['kbadm_maincat_explain'])
 		);
 		
@@ -563,9 +565,366 @@
 		exit;
 		break;
 		
-	case "auth": // For later use
+	// Auth layout that is
+	case "auth": // Category Auth
+		$template->set_filenames(array(
+			'body' => 'admin/kb_auth.tpl')
+		);
+		
+		$auth_fields = array("auth_view", "auth_add", "auth_edit", "auth_delete", "auth_mod", "auth_comment", "auth_rate", "auth_attach");
+		$auth_levels = array('ALL', 'REG', 'PRIVATE', 'MOD', 'ADMIN');
+		$auth_const = array(AUTH_ALL, AUTH_REG, AUTH_ACL, AUTH_MOD, AUTH_ADMIN);
+		if(isset($HTTP_POST_VARS['submit']) && isset($HTTP_POST_VARS['auth']))
+		{
+			// Process
+			$sql = "UPDATE " . KB_CATEGORIES_TABLE . "
+					SET ";
+			
+			for($i = 0; $i < count($auth_fields); $i++)
+			{
+				$sql .= $auth_fields[$i] . " = " . $HTTP_POST_VARS[$auth_fields[$i]] . ", ";
+			}
+			
+			$sql = substr($sql, 0, -2);
+			
+			$sql .= "
+					WHERE cat_id = '" . $HTTP_GET_VARS['c'] . "'";
+			
+			if(!$db->sql_query($sql))
+			{
+				message_die(GENERAL_ERROR, "Couldn't update auth data for the given category.", "", __LINE__, __FILE__, $sql);
+			}
+			
+			// Show a "choose a category" dialogue
+			$template->assign_vars(array(
+				'COUNT_AUTH_FIELDS' => 1,
+				'L_INFORMATION' => $lang['Information'],
+				'L_CHOOSE_CAT' => $lang['kbadm_authupdate_success'])
+			);
+			
+			$template->assign_block_vars('switch_no_cat', array());
+		}
+		elseif(isset($HTTP_GET_VARS['c']))
+		{
+			// Show cells
+			$sql = "SELECT cat_id, auth_view, auth_add, auth_edit, auth_delete, auth_mod, auth_comment, auth_rate, auth_attach
+					FROM " . KB_CATEGORIES_TABLE . "
+					WHERE cat_id = '" . $HTTP_GET_VARS['c'] . "'";
+			
+			if(!$result = $db->sql_query($sql))
+			{
+				message_die(GENERAL_ERROR, "Couldn't retrieve category auth data.", "", __LINE__, __FILE__, $sql);
+			}
+			
+			$cat = $db->sql_fetchrow($result);
+			
+			$template->assign_block_vars('switch_show_form', array());
+			
+			for($i = 0; $i < count($auth_fields); $i++)
+			{
+				$template->assign_block_vars('switch_show_form.header_authrow', array(
+					'L_AUTH_TITLE' => $lang['kbadm_' . $auth_fields[$i]])
+				);
+				
+				$auth_select = '&nbsp;<select name="' . $auth_fields[$i] . '">';
+				for($j = 0; $j < count($auth_const); $j++)
+				{
+					
+					$selected = ( $cat[$auth_fields[$i]] == $auth_const[$j] ) ? ' selected="selected"' : '';
+					$auth_select .= '<option value="' . $auth_const[$j] . '"' . $selected . '>' . $lang['Forum_' . $auth_levels[$j]] . '</option>';
+				}
+				$auth_select .= '</select>&nbsp;';
+				
+				$template->assign_block_vars('switch_show_form.authrow', array(
+					'S_AUTH_SELECT' => $auth_select)
+				);
+			}
+			
+			$template->assign_vars(array(
+				'COUNT_AUTH_FIELDS' => count($auth_fields),
+				'S_AUTH_ACTION' => append_sid('admin_kb.' . $phpEx . '?mode=auth&amp;c=' . $HTTP_GET_VARS['c']),
+				'L_SUBMIT' => $lang['Submit'])
+			);
+		}
+		else
+		{
+			// Show a "choose a category" dialogue
+			$template->assign_vars(array(
+				'COUNT_AUTH_FIELDS' => 1,
+				'L_INFORMATION' => $lang['Information'],
+				'L_CHOOSE_CAT' => $lang['kbadm_choose_cat'])
+			);
+			
+			$template->assign_block_vars('switch_no_cat', array());
+		}
+		
+		$cats = get_cats_structure('cat_id, cat_title');
+		$select = '<select name="c" onchange="if(this.options[this.selectedIndex].value != -1){ forms[\'choose_cat\'].submit() }"><option value="-1">' . $lang['kbadm_select_cat'] . '</option>';
+		for($i = 0; $i < count($cats); $i++)
+		{
+			$catstring = '';
+			
+			for($j = 0; $j < count($cats[$i]['subcats']); $j++)
+			{
+				$selected = ( $cats[$i]['subcats'][$j]['cat_id'] == $HTTP_GET_VARS['c'] ) ? 'selected="selected"' : '';
+				$catstring .= '<option value="' . $cats[$i]['subcats'][$j]['cat_id'] . '"' . $selected . '>--' . $cats[$i]['subcats'][$j]['cat_title'] . '</option>';
+			}
+			
+			$selected = ( $cats[$i]['cat_id'] == $HTTP_GET_VARS['c'] ) ? 'selected="selected"' : '';
+			$select .= '<option value="' . $cats[$i]['cat_id'] . '"' . $selected . '>' . $cats[$i]['cat_title'] . '</option>';
+			
+			if($catstring != '')
+			{
+				$select .= $catstring;
+				$select .= '<option value="-1">----------------</option>';
+			}
+		}
+		
+		$select .= '</select>';
+		
+		$template->assign_vars(array(
+			'S_CAT_SELECT' => $select,
+			'L_SELECT_CAT' => $lang['kbadm_select_cat'],
+			'S_CHOOSE_CAT_ACTION' => 'admin_kb.' . $phpEx . '?mode=auth',
+			'L_KBAUTH_TITLE' => $lang['kbadm_Auth'],
+			'L_KBAUTH_EXPLAIN' => $lang['kbadm_Auth_explain'], 
+			'SID' => $userdata['session_id'])
+		);
+		
+		$template->pparse('body');
+		
+		include('./page_footer_admin.'.$phpEx);
+		exit;
 		break;
 		
+	case "ugauth": // Usergroup Auth
+		$template->set_filenames(array(
+			'body' => 'admin/kb_ugauth.tpl')
+		);
+		
+		$auth_fields = array("auth_view", "auth_add", "auth_edit", "auth_delete", "auth_mod", "auth_comment", "auth_rate", "auth_attach");
+		$auth_levels = array('ALL', 'REG', 'PRIVATE', 'MOD', 'ADMIN');
+		$auth_const = array(AUTH_ALL, AUTH_REG, AUTH_ACL, AUTH_MOD, AUTH_ADMIN);
+		if(isset($HTTP_POST_VARS['submit']) && isset($HTTP_POST_VARS['ugauth']))
+		{
+			// The select names will be: ugauth:cat_id:auth_field
+			// Process
+			
+			$cats = array();
+			// Sort all the post variables, so we get an array with submitted auth fields, based on $cats[cat_id][auth_field]
+			foreach($_POST as $key => $value)
+			{
+				// Ok break them up and use them if they have ugauth: prefix.
+				if(strstr($key, "ugauth:"))
+				{
+					// Break it up using explode
+					$rawdata = explode(":", $key);
+					$cats[$rawdata[1]][$rawdata[2]] = $value;
+				}
+			}
+			
+			// great let's run a foreach on the cats and do one cat at a time :)
+			foreach($cats as $cat_id => $auth_field)
+			{
+				// Right! Before doing the sql we need to find out wether the entry is already existant, or whether we have to insert it.
+				$sql = "SELECT group_id
+						FROM " . KB_AUTH_ACCESS_TABLE . "
+						WHERE group_id = '" . $HTTP_GET_VARS['g'] . "'
+						AND cat_id = '" . $cat_id . "'";
+						
+				if(!$result = $db->sql_query($sql))
+				{
+					message_die(GENERAL_ERROR, "Couldn't check whether the group entry already is existant in the auth table.", "", __LINE__, __FILE__, $sql);
+				}
+				
+				if($db->sql_numrows($result) > 0)
+				{
+					$sql = "UPDATE " . KB_AUTH_ACCESS_TABLE . "
+							SET ";
+				
+					for($i = 0; $i < count($auth_fields); $i++)
+					{
+						$sql .= $auth_fields[$i] . " = " . $auth_field[$auth_fields[$i]] . ", ";
+					}
+				
+					$sql = substr($sql, 0, -2);
+					
+					$sql .= "
+							WHERE group_id = '" . $HTTP_GET_VARS['g'] . "'
+							AND cat_id = '" . $cat_id . "'";
+				}
+				else
+				{
+					$sql = "INSERT INTO " . KB_AUTH_ACCESS_TABLE . " (group_id, cat_id, ";
+					
+					for($i = 0; $i < count($auth_fields); $i++)
+					{
+						$sql .= $auth_fields[$i] . ", ";
+					}
+					
+					$sql = substr($sql, 0, -2);
+					$sql .= ") VALUES ('" . $HTTP_GET_VARS['g'] . "', '" . $cat_id . "', ";
+					
+					for($i = 0; $i < count($auth_fields); $i++)
+					{
+						$sql .= "'" . $auth_field[$auth_fields[$i]] . "', ";
+					}
+					
+					$sql = substr($sql, 0, -2);
+					$sql .= ");";
+				}
+				
+				if(!$db->sql_query($sql))
+				{
+					message_die(GENERAL_ERROR, "Couldn't update auth data for the given group.", "", __LINE__, __FILE__, $sql);
+				}
+			}
+			
+			// Show a "choose a category" dialogue
+			$template->assign_vars(array(
+				'COUNT_AUTH_FIELDS' => 1,
+				'L_INFORMATION' => $lang['Information'],
+				'L_CHOOSE_GROUP' => $lang['kbadm_ugauthupdate_success'])
+			);
+			
+			$template->assign_block_vars('switch_no_cat', array());
+		}
+		elseif(isset($HTTP_GET_VARS['g']))
+		{
+			// Show cells
+			$sql = "SELECT g.*, c.cat_title
+					FROM " . KB_AUTH_ACCESS_TABLE . " g, " . KB_CATEGORIES_TABLE . " c
+					WHERE g.group_id = '" . $HTTP_GET_VARS['g'] . "'
+					AND g.cat_id = c.cat_id";
+					
+			if(!$result = $db->sql_query($sql))
+			{
+				message_die(GENERAL_ERROR, "Couldn't retrieve group auth data.", "", __LINE__, __FILE__, $sql);
+			}
+			
+			// lets sort the group auth entries based on $group[cat_id].
+			$group = array();
+			while($row = $db->sql_fetchrow($result))
+			{
+				$group[$row['cat_id']] = $row;
+			}
+			
+			$template->assign_block_vars('switch_show_form', array());
+			
+			// Create header =)
+			for($i = 0; $i < count($auth_fields); $i++)
+			{
+				$template->assign_block_vars('switch_show_form.header_authrow', array(
+					'L_AUTH_TITLE' => $lang['kbadm_' . $auth_fields[$i]])
+				);
+			}
+				
+			$cats = get_cats_structure('cat_id, cat_title');
+			for($i = 0; $i < count($cats); $i++)
+			{
+				$template->assign_block_vars('switch_show_form.catrow', array(
+					'CAT_TITLE' => $cats[$i]['cat_title'])
+				);
+				
+				// Okay, per cat do the auth field switch
+				for($k = 0; $k < count($auth_fields); $k++)
+				{
+					$auth_select = '&nbsp;<select name="ugauth:' . $cats[$i]['cat_id'] . ':' . $auth_fields[$k] . '">';
+					for($j = 0; $j < count($auth_const); $j++)
+					{
+						$selected = ( $group[$cats[$i]['cat_id']][$auth_fields[$k]] == $auth_const[$j] ) ? ' selected="selected"' : '';
+						$auth_select .= '<option value="' . $auth_const[$j] . '"' . $selected . '>' . $lang['Forum_' . $auth_levels[$j]] . '</option>';
+					}
+					$auth_select .= '</select>&nbsp;';
+					
+					$template->assign_block_vars('switch_show_form.catrow.authrow', array(
+						'S_AUTH_SELECT' => $auth_select)
+					);
+				}
+				
+				// Handle subcats
+				for($j = 0; $j < count($cats[$i]['subcats']); $j++)
+				{
+					$temlate->assign_block_vars('switch_show_form.catrow.subcatrow', array(
+						'SUBCAT_TITLE' => $cats[$i]['subcats'][$j]['cat_title'])
+					);
+					
+					for($l = 0; $l < count($auth_fields); $l++)
+					{
+						// And auth fields
+						$auth_select = '&nbsp;<select name="ugauth' . $cats[$i]['subcats'][$j]['cat_id'] . ':' . $auth_fields[$l] . '">';
+						for($k = 0; $k < count($auth_const); $k++)
+						{
+							$selected = ( $group[$cats[$i]['subcats'][$j]['cat_id']][$auth_fields[$l]] == $auth_const[$k] ) ? ' selected="selected"' : '';
+							$auth_select .= '<option value="' . $auth_const[$k] . '"' . $selected . '>' . $lang['Forum_' . $auth_levels[$j]] . '</option>';
+						}
+						$auth_select .= '</select>&nbsp;';
+						
+						$template->assign_block_vars('switch_show_form.catrow.subcatrow.authrow', array(
+							'S_AUTH_SELECT' => $auth_select)
+						);
+					}
+				}
+			}
+			
+			$template->assign_vars(array(
+				'COUNT_AUTH_FIELDS' => (count($auth_fields) + 1), // +1 because of the extra column to the left
+				'S_UGAUTH_ACTION' => append_sid('admin_kb.' . $phpEx . '?mode=ugauth&amp;g=' . $HTTP_GET_VARS['g']),
+				'L_SUBMIT' => $lang['Submit'])
+			);
+		}
+		else
+		{
+			// Show a "choose a category" dialogue
+			$template->assign_vars(array(
+				'COUNT_AUTH_FIELDS' => 2,
+				'L_INFORMATION' => $lang['Information'],
+				'L_CHOOSE_GROUP' => $lang['kbadm_choose_group'])
+			);
+			
+			$template->assign_block_vars('switch_no_cat', array());
+		}
+		
+		$sql = "SELECT group_id, group_name
+				FROM " . GROUPS_TABLE . "
+				WHERE group_type = '0'";
+				
+		if(!$result = $db->sql_query($sql))
+		{
+			message_die(GENERAL_ERROR, "Couldn't retrieve groups.", "", __LINE__, __FILE__, $sql);
+		}
+		
+		$groups = array();
+		while($row = $db->sql_fetchrow($result))
+		{
+			$groups[] = $row;
+		}
+		
+		$select = '<select name="g" onchange="if(this.options[this.selectedIndex].value != -1){ forms[\'choose_group\'].submit() }"><option value="-1">' . $lang['kbadm_select_group'] . '</option>';
+		for($i = 0; $i < count($groups); $i++)
+		{	
+			$selected = ( $groups[$i]['group_id'] == $HTTP_GET_VARS['g'] ) ? 'selected="selected"' : '';
+			$select .= '<option value="' . $groups[$i]['group_id'] . '"' . $selected . '>' . $groups[$i]['group_name'] . '</option>';
+		}
+		
+		$select .= '</select>';
+		
+		$template->assign_vars(array(
+			'S_GROUP_SELECT' => $select,
+			'L_SELECT_GROUP' => $lang['kbadm_select_group'],
+			'S_CHOOSE_GROUP_ACTION' => 'admin_kb.' . $phpEx . '?mode=ugauth',
+			'L_KBUGAUTH_TITLE' => $lang['kbadm_Group_Auth'],
+			'L_KBUGAUTH_EXPLAIN' => $lang['kbadm_ugAuth_explain'], 
+			'SID' => $userdata['session_id'])
+		);
+		
+		$template->pparse('body');
+		
+		include('./page_footer_admin.'.$phpEx);
+		exit;
+		break;
+		
+	// attachment configuration
 	case "files": // For later use
 		break;
 		

Modified: main/trunk/includes/auth_kb.php
===================================================================
--- main/trunk/includes/auth_kb.php	2007-03-18 17:29:45 UTC (rev 68)
+++ main/trunk/includes/auth_kb.php	2007-04-05 08:00:39 UTC (rev 69)
@@ -25,10 +25,12 @@
 // 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
+// This function returns info on whether the user is allowed to do the supplied argument(s) all dependant on the given category id, shamelessly ripped off from auth.php =)
 //
 function kb_auth($type, $cat_id, $userdata)
 {
+	global $db, $lang;
+	
 	switch($type)
 	{
 		case "view":
@@ -96,7 +98,7 @@
 	
 	if(!$result = $db->sql_query($sql))
 	{
-		message_die(GENERAL_MESSAGE, 'Could not retrieve categorys auth info.', '', __LINE__, __FILE__, $sql);
+		message_die(GENERAL_MESSAGE, 'Could not retrieve categories auth info.', '', __LINE__, __FILE__, $sql);
 	}
 	
 	$f_access = $db->sql_fetchrow($result);

Modified: main/trunk/includes/constants.php
===================================================================
--- main/trunk/includes/constants.php	2007-03-18 17:29:45 UTC (rev 68)
+++ main/trunk/includes/constants.php	2007-04-05 08:00:39 UTC (rev 69)
@@ -187,7 +187,7 @@
 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");
+define('KB_AUTH_ACCESS_TABLE', $table_prefix . "kb_auth_access");
 define('KB_CONFIG_TABLE', $table_prefix . "kb_config");
 
 // Article Status

Modified: main/trunk/includes/functions_kb.php
===================================================================
--- main/trunk/includes/functions_kb.php	2007-03-18 17:29:45 UTC (rev 68)
+++ main/trunk/includes/functions_kb.php	2007-04-05 08:00:39 UTC (rev 69)
@@ -104,12 +104,12 @@
 	return;
 }
 
-function get_cats_structure()
+function get_cats_structure($fields = "*")
 {
 	global $db;
 	
 	$cats = array();
-	$sql = "SELECT *
+	$sql = "SELECT " . $fields . "
 			FROM " . KB_CATEGORIES_TABLE . "
 			WHERE cat_main = '0'
 			ORDER BY cat_order ASC";
@@ -123,7 +123,7 @@
 	{
 		$cats[$i] = $row;
 		
-		$sql = "SELECT *
+		$sql = "SELECT " . $fields . "
 				FROM " . KB_CATEGORIES_TABLE . "
 				WHERE cat_main = '" . $row['cat_id'] . "'
 				ORDER BY cat_order ASC";

Modified: main/trunk/kb.php
===================================================================
--- main/trunk/kb.php	2007-03-18 17:29:45 UTC (rev 68)
+++ main/trunk/kb.php	2007-04-05 08:00:39 UTC (rev 69)
@@ -22,6 +22,7 @@
 include($phpbb_root_path . 'extension.inc');
 include($phpbb_root_path . 'common.' . $phpEx);
 include($phpbb_root_path . 'includes/functions_kb.' . $phpEx);
+include($phpbb_root_path . 'includes/auth_kb.' . $phpEx);
 include($phpbb_root_path . 'includes/bbcode.'.$phpEx);
 
 //
@@ -54,6 +55,12 @@
 		message_die(GENERAL_MESSAGE, $lang['kb_cat_noexist']);
 	}
 	
+	$auth = kb_auth("cat", $cat_id, $userdata);
+	if(!$auth['auth_view'])
+	{
+		message_die(GENERAL_MESSAGE, $lang['kb_noauth_viewcat'];
+	}
+	
 	// Store the main cat in a variable
 	$sql = "SELECT *
 			FROM " . KB_CATEGORIES_TABLE . " 
@@ -117,6 +124,7 @@
 			FROM " . KB_ARTICLECATS_TABLE . " c, " . KB_ARTICLES_TABLE . " a
 			WHERE c.cat_id = '$cat_id'
 			AND c.article_id = a.article_id
+			AND a.article_status = '" . KB_STATUS_ACCEPTED . "'
 			$sort";
 	if( !($result = $db->sql_query($sql)) )
 	{
@@ -155,7 +163,7 @@
 		'body' => 'kb_viewcat.tpl')
 	);
 	
-	if($userdata['session_logged_in'])
+	if($auth['auth_add'])
 	{
 		$template->assign_block_vars('switch_add_article', array());
 	}
@@ -179,14 +187,19 @@
 		// Ok it contains subcats, let's build them.
 		for($i = 0; $i < $total_subcats; $i++)
 		{
+			$view = kb_auth("view", $subcats[$i]['cat_id'], $userdata);
+			
 			// 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?cat_id=" . $subcats[$i]['cat_id']),
-				'FORUM_FOLDER_IMG' => $images['forum'])
-			);
+			if($view['auth_view'])
+			{
+				$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?cat_id=" . $subcats[$i]['cat_id']),
+					'FORUM_FOLDER_IMG' => $images['forum'])
+				);
+			}
 		}
 	}
 	
@@ -246,11 +259,8 @@
 		);
 		
 		$template->assign_block_vars('switch_no_articles', array());
-	}
+	} // if ... total_categories
 	
-	// if ... total_categories
-	
-	
 	//
 	// Generate the page
 	//
@@ -258,11 +268,53 @@
 	
 	include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
 }
+elseif(isset($HHTP_GET_VARS['search']))
+{
+	// Search function
+	$string = $HTTP_GET_VARS['search'];
+	
+	// Search form
+	if($string == "f")
+	{
+		
+	}
+	elseif($string == "newarticles")
+	{
+		
+	}
+	else
+	{
+		$search_sql = "SELECT *
+					   FROM " . KB_ARTICLES . "
+					   WHERE article_title LIKE '%" . $HTTP_GET_VARS['search'] . "%'
+					   ";
+		
+		if(isset($HTTP_GET_VARS['a']))
+		{
+			// Search on author aswell
+			$search_sql .= "";
+		}
+		
+		if(isset($HTTP_GET_VARS['w']))
+		{
+			// Search the article text and description
+			$search_sql .= "";
+		}
+		
+		
+	}
+}
 elseif(isset($HTTP_GET_VARS['cat_id']) && isset($HTTP_GET_VARS['article']))
 {
 	$cid = ( empty($HTTP_GET_VARS['cat_id']) ) ? false : $HTTP_GET_VARS['cat_id'];
 	$article_query = unwiki_article_title($HTTP_GET_VARS['article']);
+	$auth = kb_auth("article", $cid, $userdata);
 	
+	if(!$auth['auth_view'])
+	{
+		message_die(GENERAL_MESSAGE, $lang['kb_noauth_viewarticle']);	
+	}
+	
 	// Get naughty words :)
 	$orig_word = array();
 	$replacement_word = array();
@@ -540,11 +592,10 @@
 	{
 		for($i = 0; $i < $total_catrows; $i++)
 		{
-			//$auth = kb_auth("view", $catrows[$i]['cat_id'], $userdata);
+			$auth = kb_auth("view", $catrows[$i]['cat_id'], $userdata);
 			
-			// auth not included in alpha
-			//if($auth['auth_view'])
-			//{
+			if($auth['auth_view'])
+			{
 				// Ok display one cat here
 				$template->assign_block_vars('catrow', array(
 					'CAT_TITLE' => $catrows[$i]['cat_title'],
@@ -578,11 +629,10 @@
 					
 					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'])
-						//{
+						$auth = kb_auth("view", $subcats[$j]['cat_id'], $userdata);
+					
+						if($auth['auth_view'])
+						{
 							// Show the subcat
 							$k = $j + 1;
 							$subcat_comma = ( isset($subcats[$k]) ) ? ",&nbsp;" : ".";
@@ -591,10 +641,10 @@
 								'SUBCAT_TITLE' => $subcats[$j]['cat_title'],
 								'SUBCAT_COMMA' => $subcat_comma)
 							);
-						//} // if auth view
+						} // if auth view
 					} // for subcats
 				} // if subcats
-			//} // auth view
+			} // auth view
 		} // for cats
 	}// total cats
 	else

Modified: main/trunk/language/lang_english/lang_admin.php
===================================================================
--- main/trunk/language/lang_english/lang_admin.php	2007-03-18 17:29:45 UTC (rev 68)
+++ main/trunk/language/lang_english/lang_admin.php	2007-04-05 08:00:39 UTC (rev 69)
@@ -1,766 +1,775 @@
-<?php
-
-/***************************************************************************
- *                            lang_admin.php [English]
- *                              -------------------
- *     begin                : Sat Dec 16 2000
- *     copyright            : (C) 2001 The phpBB Group
- *     email                : su...@ph...
- *
- *     $Id: lang_admin.php,v 1.35.2.17 2006/02/05 15:59:48 grahamje 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.
- *
- ***************************************************************************/
-
-/* CONTRIBUTORS
-	2002-12-15	Philip M. White (pw...@ma...)
-		Fixed many minor grammatical mistakes
-*/
-
-//
-// Format is same as lang_main
-//
-
-//
-// Modules, this replaces the keys used
-// in the modules[][] arrays in each module file
-//
-$lang['General'] = 'General Admin';
-$lang['Users'] = 'User Admin';
-$lang['Groups'] = 'Group Admin';
-$lang['Forums'] = 'Forum Admin';
-$lang['Styles'] = 'Styles Admin';
-
-$lang['Configuration'] = 'Configuration';
-$lang['Permissions'] = 'Permissions';
-$lang['Manage'] = 'Management';
-$lang['Disallow'] = 'Disallow names';
-$lang['Prune'] = 'Pruning';
-$lang['Mass_Email'] = 'Mass Email';
-$lang['Ranks'] = 'Ranks';
-$lang['Smilies'] = 'Smilies';
-$lang['Ban_Management'] = 'Ban Control';
-$lang['Word_Censor'] = 'Word Censors';
-$lang['Export'] = 'Export';
-$lang['Create_new'] = 'Create';
-$lang['Add_new'] = 'Add';
-$lang['Backup_DB'] = 'Backup Database';
-$lang['Restore_DB'] = 'Restore Database';
-
-
-//
-// Index
-//
-$lang['Admin'] = 'Administration';
-$lang['Not_admin'] = 'You are not authorised to administer this board';
-$lang['Welcome_phpBB'] = 'Welcome to phpBB';
-$lang['Admin_intro'] = 'Thank you for choosing phpBB as your forum solution. This screen will give you a quick overview of all the various statistics of your board. You can get back to this page by clicking on the <u>Admin Index</u> link in the left pane. To return to the index of your board, click the phpBB logo also in the left pane. The other links on the left hand side of this screen will allow you to control every aspect of your forum experience. Each screen will have instructions on how to use the tools.';
-$lang['Main_index'] = 'Forum Index';
-$lang['Forum_stats'] = 'Forum Statistics';
-$lang['Admin_Index'] = 'Admin Index';
-$lang['Preview_forum'] = 'Preview Forum';
-
-$lang['Click_return_admin_index'] = 'Click %sHere%s to return to the Admin Index';
-
-$lang['Statistic'] = 'Statistic';
-$lang['Value'] = 'Value';
-$lang['Number_posts'] = 'Number of posts';
-$lang['Posts_per_day'] = 'Posts per day';
-$lang['Number_topics'] = 'Number of topics';
-$lang['Topics_per_day'] = 'Topics per day';
-$lang['Number_users'] = 'Number of users';
-$lang['Users_per_day'] = 'Users per day';
-$lang['Board_started'] = 'Board started';
-$lang['Avatar_dir_size'] = 'Avatar directory size';
-$lang['Database_size'] = 'Database size';
-$lang['Gzip_compression'] ='Gzip compression';
-$lang['Not_available'] = 'Not available';
-
-$lang['ON'] = 'ON'; // This is for GZip compression
-$lang['OFF'] = 'OFF'; 
-
-
-//
-// DB Utils
-//
-$lang['Database_Utilities'] = 'Database Utilities';
-
-$lang['Restore'] = 'Restore';
-$lang['Backup'] = 'Backup';
-$lang['Restore_explain'] = 'This will perform a full restore of all phpBB tables from a saved file. If your server supports it, you may upload a gzip-compressed text file and it will automatically be decompressed. <b>WARNING</b>: This will overwrite any existing data. The restore may take a long time to process, so please do not move from this page until it is complete.';
-$lang['Backup_explain'] = 'Here you can back up all your phpBB-related data. If you have any additional custom tables in the same database with phpBB that you would like to back up as well, please enter their names, separated by commas, in the Additional Tables textbox below. If your server supports it you may also gzip-compress the file to reduce its size before download.';
-
-$lang['Backup_options'] = 'Backup options';
-$lang['Start_backup'] = 'Start Backup';
-$lang['Full_backup'] = 'Full backup';
-$lang['Structure_backup'] = 'Structure-Only backup';
-$lang['Data_backup'] = 'Data only backup';
-$lang['Additional_tables'] = 'Additional tables';
-$lang['Gzip_compress'] = 'Gzip compress file';
-$lang['Select_file'] = 'Select a file';
-$lang['Start_Restore'] = 'Start Restore';
-
-$lang['Restore_success'] = 'The Database has been successfully restored.<br /><br />Your board should be back to the state it was when the backup was made.';
-$lang['Backup_download'] = 'Your download will start shortly; please wait until it begins.';
-$lang['Backups_not_supported'] = 'Sorry, but database backups are not currently supported for your database system.';
-
-$lang['Restore_Error_uploading'] = 'Error in uploading the backup file';
-$lang['Restore_Error_filename'] = 'Filename problem; please try an alternative file';
-$lang['Restore_Error_decompress'] = 'Cannot decompress a gzip file; please upload a plain text version';
-$lang['Restore_Error_no_file'] = 'No file was uploaded';
-
-
-//
-// Auth pages
-//
-$lang['Select_a_User'] = 'Select a User';
-$lang['Select_a_Group'] = 'Select a Group';
-$lang['Select_a_Forum'] = 'Select a Forum';
-$lang['Auth_Control_User'] = 'User Permissions Control'; 
-$lang['Auth_Control_Group'] = 'Group Permissions Control'; 
-$lang['Auth_Control_Forum'] = 'Forum Permissions Control'; 
-$lang['Look_up_User'] = 'Look up User'; 
-$lang['Look_up_Group'] = 'Look up Group'; 
-$lang['Look_up_Forum'] = 'Look up Forum'; 
-
-$lang['Group_auth_explain'] = 'Here you can alter the permissions and moderator status assigned to each user group. Do not forget when changing group permissions that individual user permissions may still allow the user entry to forums, etc. You will be warned if this is the case.';
-$lang['User_auth_explain'] = 'Here you can alter the permissions and moderator status assigned to each individual user. Do not forget when changing user permissions that group permissions may still allow the user entry to forums, etc. You will be warned if this is the case.';
-$lang['Forum_auth_explain'] = 'Here you can alter the authorisation levels of each forum. You will have both a simple and advanced method for doing this, where advanced offers greater control of each forum operation. Remember that changing the permission level of forums will affect which users can carry out the various operations within them.';
-
-$lang['Simple_mode'] = 'Simple Mode';
-$lang['Advanced_mode'] = 'Advanced Mode';
-$lang['Moderator_status'] = 'Moderator status';
-
-$lang['Allowed_Access'] = 'Allowed Access';
-$lang['Disallowed_Access'] = 'Disallowed Access';
-$lang['Is_Moderator'] = 'Is Moderator';
-$lang['Not_Moderator'] = 'Not Moderator';
-
-$lang['Conflict_warning'] = 'Authorisation Conflict Warning';
-$lang['Conflict_access_userauth'] = 'This user still has access rights to this forum via group membership. You may want to alter the group permissions or remove this user the group to fully prevent them having access rights. The groups granting rights (and the forums involved) are noted below.';
-$lang['Conflict_mod_userauth'] = 'This user still has moderator rights to this forum via group membership. You may want to alter the group permissions or remove this user the group to fully prevent them having moderator rights. The groups granting rights (and the forums involved) are noted below.';
-
-$lang['Conflict_access_groupauth'] = 'The following user (or users) still have access rights to this forum via their user permission settings. You may want to alter the user permissions to fully prevent them having access rights. The users granted rights (and the forums involved) are noted below.';
-$lang['Conflict_mod_groupauth'] = 'The following user (or users) still have moderator rights to this forum via their user permissions settings. You may want to alter the user permissions to fully prevent them having moderator rights. The users granted rights (and the forums involved) are noted below.';
-
-$lang['Public'] = 'Public';
-$lang['Private'] = 'Private';
-$lang['Registered'] = 'Registered';
-$lang['Administrators'] = 'Administrators';
-$lang['Hidden'] = 'Hidden';
-
-// These are displayed in the drop down boxes for advanced
-// mode forum auth, try and keep them short!
-$lang['Forum_ALL'] = 'ALL';
-$lang['Forum_REG'] = 'REG';
-$lang['Forum_PRIVATE'] = 'PRIVATE';
-$lang['Forum_MOD'] = 'MOD';
-$lang['Forum_ADMIN'] = 'ADMIN';
-
-$lang['View'] = 'View';
-$lang['Read'] = 'Read';
-$lang['Post'] = 'Post';
-$lang['Reply'] = 'Reply';
-$lang['Edit'] = 'Edit';
-$lang['Delete'] = 'Delete';
-$lang['Sticky'] = 'Sticky';
-$lang['Announce'] = 'Announce'; 
-$lang['Vote'] = 'Vote';
-$lang['Pollcreate'] = 'Poll create';
-
-$lang['Permissions'] = 'Permissions';
-$lang['Simple_Permission'] = 'Simple Permissions';
-
-$lang['User_Level'] = 'User Level'; 
-$lang['Auth_User'] = 'User';
-$lang['Auth_Admin'] = 'Administrator';
-$lang['Group_memberships'] = 'Usergroup memberships';
-$lang['Usergroup_members'] = 'This group has the following members';
-
-$lang['Forum_auth_updated'] = 'Forum permissions updated';
-$lang['User_auth_updated'] = 'User permissions updated';
-$lang['Group_auth_updated'] = 'Group permissions updated';
-
-$lang['Auth_updated'] = 'Permissions have been updated';
-$lang['Click_return_userauth'] = 'Click %sHere%s to return to User Permissions';
-$lang['Click_return_groupauth'] = 'Click %sHere%s to return to Group Permissions';
-$lang['Click_return_forumauth'] = 'Click %sHere%s to return to Forum Permissions';
-
-
-//
-// Banning
-//
-$lang['Ban_control'] = 'Ban Control';
-$lang['Ban_explain'] = 'Here you can control the banning of users. You can achieve this by banning either or both of a specific user or an individual or range of IP addresses or hostnames. These methods prevent a user from even reaching the index page of your board. To prevent a user from registering under a different username you can also specify a banned email address. Please note that banning an email address alone will not prevent that user from being able to log on or post to your board. You should use one of the first two methods to achieve this.';
-$lang['Ban_explain_warn'] = 'Please note that entering a range of IP addresses results in all the addresses between the start and end being added to the banlist. Attempts will be made to minimise the number of addresses added to the database by introducing wildcards automatically where appropriate. If you really must enter a range, try to keep it small or better yet state specific addresses.';
-
-$lang['Select_username'] = 'Select a Username';
-$lang['Select_ip'] = 'Select an IP address';
-$lang['Select_email'] = 'Select an Email address';
-
-$lang['Ban_username'] = 'Ban one or more specific users';
-$lang['Ban_username_explain'] = 'You can ban multiple users in one go using the appropriate combination of mouse and keyboard for your computer and browser';
-
-$lang['Ban_IP'] = 'Ban one or more IP addresses or hostnames';
-$lang['IP_hostname'] = 'IP addresses or hostnames';
-$lang['Ban_IP_explain'] = 'To specify several different IP addresses or hostnames separate them with commas. To specify a range of IP addresses, separate the start and end with a hyphen (-); to specify a wildcard, use an asterisk (*).';
-
-$lang['Ban_email'] = 'Ban one or more email addresses';
-$lang['Ban_email_explain'] = 'To specify more than one email address, separate them with commas. To specify a wildcard username, use * like *@hotmail.com';
-
-$lang['Unban_username'] = 'Un-ban one more specific users';
-$lang['Unban_username_explain'] = 'You can unban multiple users in one go using the appropriate combination of mouse and keyboard for your computer and browser';
-
-$lang['Unban_IP'] = 'Un-ban one or more IP addresses';
-$lang['Unban_IP_explain'] = 'You can unban multiple IP addresses in one go using the appropriate combination of mouse and keyboard for your computer and browser';
-
-$lang['Unban_email'] = 'Un-ban one or more email addresses';
-$lang['Unban_email_explain'] = 'You can unban multiple email addresses in one go using the appropriate combination of mouse and keyboard for your computer and browser';
-
-$lang['No_banned_users'] = 'No banned usernames';
-$lang['No_banned_ip'] = 'No banned IP addresses';
-$lang['No_banned_email'] = 'No banned email addresses';
-
-$lang['Ban_update_sucessful'] = 'The banlist has been updated successfully';
-$lang['Click_return_banadmin'] = 'Click %sHere%s to return to Ban Control';
-
-
-//
-// Configuration
-//
-$lang['General_Config'] = 'General Configuration';
-$lang['Config_explain'] = 'The form below will allow you to customize all the general board options. For User and Forum configurations use the related links on the left hand side.';
-
-$lang['Click_return_config'] = 'Click %sHere%s to return to General Configuration';
-
-$lang['General_settings'] = 'General Board Settings';
-$lang['Server_name'] = 'Domain Name';
-$lang['Server_name_explain'] = 'The domain name from which this board runs';
-$lang['Script_path'] = 'Script path';
-$lang['Script_path_explain'] = 'The path where phpBB2 is located relative to the domain name';
-$lang['Server_port'] = 'Server Port';
-$lang['Server_port_explain'] = 'The port your server is running on, usually 80. Only change if different';
-$lang['Site_name'] = 'Site name';
-$lang['Site_desc'] = 'Site description';
-$lang['Board_disable'] = 'Disable board';
-$lang['Board_disable_explain'] = 'This will make the board unavailable to users. Administrators are able to access the Administration Panel while the board is disabled.';
-$lang['Acct_activation'] = 'Enable account activation';
-$lang['Acc_None'] = 'None'; // These three entries are the type of activation
-$lang['Acc_User'] = 'User';
-$lang['Acc_Admin'] = 'Admin';
-
-$lang['Abilities_settings'] = 'User and Forum Basic Settings';
-$lang['Max_poll_options'] = 'Max number of poll options';
-$lang['Flood_Interval'] = 'Flood Interval';
-$lang['Flood_Interval_explain'] = 'Number of seconds a user must wait between posts'; 
-$lang['Board_email_form'] = 'User email via board';
-$lang['Board_email_form_explain'] = 'Users send email to each other via this board';
-$lang['Topics_per_page'] = 'Topics Per Page';
-$lang['Posts_per_page'] = 'Posts Per Page';
-$lang['Hot_threshold'] = 'Posts for Popular Threshold';
-$lang['Default_style'] = 'Default Style';
-$lang['Override_style'] = 'Override user style';
-$lang['Override_style_explain'] = 'Replaces users style with the default';
-$lang['Default_language'] = 'Default Language';
-$lang['Date_format'] = 'Date Format';
-$lang['System_timezone'] = 'System Timezone';
-$lang['Enable_gzip'] = 'Enable GZip Compression';
-$lang['Enable_prune'] = 'Enable Forum Pruning';
-$lang['Allow_HTML'] = 'Allow HTML';
-$lang['Allow_BBCode'] = 'Allow BBCode';
-$lang['Allowed_tags'] = 'Allowed HTML tags';
-$lang['Allowed_tags_explain'] = 'Separate tags with commas';
-$lang['Allow_smilies'] = 'Allow Smilies';
-$lang['Smilies_path'] = 'Smilies Storage Path';
-$lang['Smilies_path_explain'] = 'Path under your phpBB root dir, e.g. images/smiles';
-$lang['Allow_sig'] = 'Allow Signatures';
-$lang['Max_sig_length'] = 'Maximum signature length';
-$lang['Max_sig_length_explain'] = 'Maximum number of characters in user signatures';
-$lang['Allow_name_change'] = 'Allow Username changes';
-
-$lang['Avatar_settings'] = 'Avatar Settings';
-$lang['Allow_local'] = 'Enable gallery avatars';
-$lang['Allow_remote'] = 'Enable remote avatars';
-$lang['Allow_remote_explain'] = 'Avatars linked to from another website';
-$lang['Allow_upload'] = 'Enable avatar uploading';
-$lang['Max_filesize'] = 'Maximum Avatar File Size';
-$lang['Max_filesize_explain'] = 'For uploaded avatar files';
-$lang['Max_avatar_size'] = 'Maximum Avatar Dimensions';
-$lang['Max_avatar_size_explain'] = '(Height x Width in pixels)';
-$lang['Avatar_storage_path'] = 'Avatar Storage Path';
-$lang['Avatar_storage_path_explain'] = 'Path under your phpBB root dir, e.g. images/avatars';
-$lang['Avatar_gallery_path'] = 'Avatar Gallery Path';
-$lang['Avatar_gallery_path_explain'] = 'Path under your phpBB root dir for pre-loaded images, e.g. images/avatars/gallery';
-
-$lang['COPPA_settings'] = 'COPPA Settings';
-$lang['COPPA_fax'] = 'COPPA Fax Number';
-$lang['COPPA_mail'] = 'COPPA Mailing Address';
-$lang['COPPA_mail_explain'] = 'This is the mailing address to which parents will send COPPA registration forms';
-
-$lang['Email_settings'] = 'Email Settings';
-$lang['Admin_email'] = 'Admin Email Address';
-$lang['Email_sig'] = 'Email Signature';
-$lang['Email_sig_explain'] = 'This text will be attached to all emails the board sends';
-$lang['Use_SMTP'] = 'Use SMTP Server for email';
-$lang['Use_SMTP_explain'] = 'Say yes if you want or have to send email via a named server instead of the local mail function';
-$lang['SMTP_server'] = 'SMTP Server Address';
-$lang['SMTP_username'] = 'SMTP Username';
-$lang['SMTP_username_explain'] = 'Only enter a username if your SMTP server requires it';
-$lang['SMTP_password'] = 'SMTP Password';
-$lang['SMTP_password_explain'] = 'Only enter a password if your SMTP server requires it';
-
-$lang['Disable_privmsg'] = 'Private Messaging';
-$lang['Inbox_limits'] = 'Max posts in Inbox';
-$lang['Sentbox_limits'] = 'Max posts in Sentbox';
-$lang['Savebox_limits'] = 'Max posts in Savebox';
-
-$lang['Cookie_settings'] = 'Cookie settings'; 
-$lang['Cookie_settings_explain'] = 'These details define how cookies are sent to your users\' browsers. In most cases the default values for the cookie settings should be sufficient, but if you need to change them do so with care -- incorrect settings can prevent users from logging in';
-$lang['Cookie_domain'] = 'Cookie domain';
-$lang['Cookie_name'] = 'Cookie name';
-$lang['Cookie_path'] = 'Cookie path';
-$lang['Cookie_secure'] = 'Cookie secure';
-$lang['Cookie_secure_explain'] = 'If your server is running via SSL, set this to enabled, else leave as disabled';
-$lang['Session_length'] = 'Session length [ seconds ]';
-
-// Visual Confirmation
-$lang['Visual_confirm'] = 'Enable Visual Confirmation';
-$lang['Visual_confirm_explain'] = 'Requires users enter a code defined by an image when registering.';
-
-// Autologin Keys - added 2.0.18
-$lang['Allow_autologin'] = 'Allow automatic logins';
-$lang['Allow_autologin_explain'] = 'Determines whether users are allowed to select to be automatically logged in when visiting the forum';
-$lang['Autologin_time'] = 'Automatic login key expiry';
-$lang['Autologin_time_explain'] = 'How long a autologin key is valid for in days if the user does not visit the board. Set to zero to disable expiry.';
-
-// Search Flood Control - added 2.0.20
-$lang['Search_Flood_Interval'] = 'Search Flood Interval';
-$lang['Search_Flood_Interval_explain'] = 'Number of seconds a user must wait between search requests'; 
-
-//
-// Forum Management
-//
-$lang['Forum_admin'] = 'Forum Administration';
-$lang['Forum_admin_explain'] = 'From this panel you can add, delete, edit, re-order and re-synchronise categories and forums';
-$lang['Edit_forum'] = 'Edit forum';
-$lang['Create_forum'] = 'Create new forum';
-$lang['Create_category'] = 'Create new category';
-$lang['Remove'] = 'Remove';
-$lang['Action'] = 'Action';
-$lang['Update_order'] = 'Update Order';
-$lang['Config_updated'] = 'Forum Configuration Updated Successfully';
-$lang['Edit'] = 'Edit';
-$lang['Delete'] = 'Delete';
-$lang['Move_up'] = 'Move up';
-$lang['Move_down'] = 'Move down';
-$lang['Resync'] = 'Resync';
-$lang['No_mode'] = 'No mode was set';
-$lang['Forum_edit_delete_explain'] = 'The form below will allow you to customize all the general board options. For User and Forum configurations use the related links on the left hand side';
-
-$lang['Move_contents'] = 'Move all contents';
-$lang['Forum_delete'] = 'Delete Forum';
-$lang['Forum_delete_explain'] = 'The form below will allow you to delete a forum (or category) and decide where you want to put all topics (or forums) it contained.';
-
-$lang['Status_locked'] = 'Locked';
-$lang['Status_unlocked'] = 'Unlocked';
-$lang['Forum_settings'] = 'General Forum Settings';
-$lang['Forum_name'] = 'Forum name';
-$lang['Forum_desc'] = 'Description';
-$lang['Forum_status'] = 'Forum status';
-$lang['Forum_pruning'] = 'Auto-pruning';
-
-$lang['prune_freq'] = 'Check for topic age every';
-$lang['prune_days'] = 'Remove topics that have not been posted to in';
-$lang['Set_prune_data'] = 'You have turned on auto-prune for this forum but did not set a frequency or number of days to prune. Please go back and do so.';
-
-$lang['Move_and_Delete'] = 'Move and Delete';
-
-$lang['Delete_all_posts'] = 'Delete all posts';
-$lang['Nowhere_to_move'] = 'Nowhere to move to';
-
-$lang['Edit_Category'] = 'Edit Category';
-$lang['Edit_Category_explain'] = 'Use this form to modify a category\'s name.';
-
-$lang['Forums_updated'] = 'Forum and Category information updated successfully';
-
-$lang['Must_delete_forums'] = 'You need to delete all forums before you can delete this category';
-
-$lang['Click_return_forumadmin'] = 'Click %sHere%s to return to Forum Administration';
-
-
-//
-// Smiley Management
-//
-$lang['smiley_title'] = 'Smiles Editing Utility';
-$lang['smile_desc'] = 'From this page you can add, remove and edit the emoticons or smileys that your users can use in their posts and private messages.';
-
-$lang['smiley_config'] = 'Smiley Configuration';
-$lang['smiley_code'] = 'Smiley Code';
-$lang['smiley_url'] = 'Smiley Image File';
-$lang['smiley_emot'] = 'Smiley Emotion';
-$lang['smile_add'] = 'Add a new Smiley';
-$lang['Smile'] = 'Smile';
-$lang['Emotion'] = 'Emotion';
-
-$lang['Select_pak'] = 'Select Pack (.pak) File';
-$lang['replace_existing'] = 'Replace Existing Smiley';
-$lang['keep_existing'] = 'Keep Existing Smiley';
-$lang['smiley_import_inst'] = 'You should unzip the smiley package and upload all files to the appropriate Smiley directory for your installation. Then select the correct information in this form to import the smiley pack.';
-$lang['smiley_import'] = 'Smiley Pack Import';
-$lang['choose_smile_pak'] = 'Choose a Smile Pack .pak file';
-$lang['import'] = 'Import Smileys';
-$lang['smile_conflicts'] = 'What should be done in case of conflicts';
-$lang['del_existing_smileys'] = 'Delete existing smileys before import';
-$lang['import_smile_pack'] = 'Import Smiley Pack';
-$lang['export_smile_pack'] = 'Create Smiley Pack';
-$lang['export_smiles'] = 'To create a smiley pack from your currently installed smileys, click %sHere%s to download the smiles.pak file. Name this file appropriately making sure to keep the .pak file extension.  Then create a zip file containing all of your smiley images plus this .pak configuration file.';
-
-$lang['smiley_add_success'] = 'The Smiley was successfully added';
-$lang['smiley_edit_success'] = 'The Smiley was successfully updated';
-$lang['smiley_import_success'] = 'The Smiley Pack was imported successfully!';
-$lang['smiley_del_success'] = 'The Smiley was successfully removed';
-$lang['Click_return_smileadmin'] = 'Click %sHere%s to return to Smiley Administration';
-
-$lang['Confirm_delete_smiley'] = 'Are you sure you want to delete this Smiley?';
-
-//
-// User Management
-//
-$lang['User_admin'] = 'User Administration';
-$lang['User_admin_explain'] = 'Here you can change your users\' information and certain options. To modify the users\' permissions, please use the user and group permissions system.';
-
-$lang['Look_up_user'] = 'Look up user';
-
-$lang['Admin_user_fail'] = 'Couldn\'t update the user\'s profile.';
-$lang['Admin_user_updated'] = 'The user\'s profile was successfully updated.';
-$lang['Click_return_useradmin'] = 'Click %sHere%s to return to User Administration';
-
-$lang['User_delete'] = 'Delete this user';
-$lang['User_delete_explain'] = 'Click here to delete this user; this cannot be undone.';
-$lang['User_deleted'] = 'User was successfully deleted.';
-
-$lang['User_status'] = 'User is active';
-$lang['User_allowpm'] = 'Can send Private Messages';
-$lang['User_allowavatar'] = 'Can display avatar';
-
-$lang['Admin_avatar_explain'] = 'Here you can see and delete the user\'s current avatar.';
-
-$lang['User_special'] = 'Special admin-only fields';
-$lang['User_special_explain'] = 'These fields are not able to be modified by the users.  Here you can set their status and other options that are not given to users.';
-
-
-//
-// Group Management
-//
-$lang['Group_administration'] = 'Group Administration';
-$lang['Group_admin_explain'] = 'From this panel you can administer all your usergroups. You can delete, create and edit existing groups. You may choose moderators, toggle open/closed group status and set the group name and description';
-$lang['Error_updating_groups'] = 'There was an error while updating the groups';
-$lang['Updated_group'] = 'The group was successfully updated';
-$lang['Added_new_group'] = 'The new group was successfully created';
-$lang['Deleted_group'] = 'The group was successfully deleted';
-$lang['New_group'] = 'Create new group';
-$lang['Edit_group'] = 'Edit group';
-$lang['group_name'] = 'Group name';
-$lang['group_description'] = 'Group description';
-$lang['group_moderator'] = 'Group moderator';
-$lang['group_status'] = 'Group status';
-$lang['group_open'] = 'Open group';
-$lang['group_closed'] = 'Closed group';
-$lang['group_hidden'] = 'Hidden group';
-$lang['group_delete'] = 'Delete group';
-$lang['group_delete_check'] = 'Delete this group';
-$lang['submit_group_changes'] = 'Submit Changes';
-$lang['reset_group_changes'] = 'Reset Changes';
-$lang['No_group_name'] = 'You must specify a name for this group';
-$lang['No_group_moderator'] = 'You must specify a moderator for this group';
-$lang['No_group_mode'] = 'You must specify a mode for this group, open or closed';
-$lang['No_group_action'] = 'No action was specified';
-$lang['delete_group_moderator'] = 'Delete the old group moderator?';
-$lang['delete_moderator_explain'] = 'If you\'re changing the group moderator, check this box to remove the old moderator from the group.  Otherwise, do not check it, and the user will become a regular member of the group.';
-$lang['Click_return_groupsadmin'] = 'Click %sHere%s to return to Group Administration.';
-$lang['Select_group'] = 'Select a group';
-$lang['Look_up_group'] = 'Look up group';
-
-
-//
-// Prune Administration
-//
-$lang['Forum_Prune'] = 'Forum Prune';
-$lang['Forum_Prune_explain'] = 'This will delete any topic which has not been posted to within the number of days you select. If you do not enter a number then all topics will be deleted. It will not remove topics in which polls are still running nor will it remove announcements. You will need to remove those topics manually.';
-$lang['Do_Prune'] = 'Do Prune';
-$lang['All_Forums'] = 'All Forums';
-$lang['Prune_topics_not_posted'] = 'Prune topics with no replies in this many days';
-$lang['Topics_pruned'] = 'Topics pruned';
-$lang['Posts_pruned'] = 'Posts pruned';
-$lang['Prune_success'] = 'Pruning of forums was successful';
-
-
-//
-// Word censor
-//
-$lang['Words_title'] = 'Word Censoring';
-$lang['Words_explain'] = 'From this control panel you can add, edit, and remove words that will be automatically censored on your forums. In addition people will not be allowed to register with usernames containing these words. Wildcards (*) are accepted in the word field. For example, *test* will match detestable, test* would match testing, *test would match detest.';
-$lang['Word'] = 'Word';
-$lang['Edit_word_censor'] = 'Edit word censor';
-$lang['Replacement'] = 'Replacement';
-$lang['Add_new_word'] = 'Add new word';
-$lang['Update_word'] = 'Update word censor';
-
-$lang['Must_enter_word'] = 'You must enter a word and its replacement';
-$lang['No_word_selected'] = 'No word selected for editing';
-
-$lang['Word_updated'] = 'The selected word censor has been successfully updated';
-$lang['Word_added'] = 'The word censor has been successfully added';
-$lang['Word_removed'] = 'The selected word censor has been successfully removed';
-
-$lang['Click_return_wordadmin'] = 'Click %sHere%s to return to Word Censor Administration';
-
-$lang['Confirm_delete_word'] = 'Are you sure you want to delete this word censor?';
-
-
-//
-// Mass Email
-//
-$lang['Mass_email_explain'] = 'Here you can email a message to either all of your users or all users of a specific group.  To do this, an email will be sent out to the administrative email address supplied, with a blind carbon copy sent to all recipients. If you are emailing a large group of people please be patient after submitting and do not stop the page halfway through. It is normal for a mass emailing to take a long time and you will be notified when the script has completed';
-$lang['Compose'] = 'Compose'; 
-
-$lang['Recipients'] = 'Recipients'; 
-$lang['All_users'] = 'All Users';
-
-$lang['Email_successfull'] = 'Your message has been sent';
-$lang['Click_return_massemail'] = 'Click %sHere%s to return to the Mass Email form';
-
-
-//
-// Ranks admin
-//
-$lang['Ranks_title'] = 'Rank Administration';
-$lang['Ranks_explain'] = 'Using this form you can add, edit, view and delete ranks. You can also create custom ranks which can be applied to a user via the user management facility';
-
-$lang['Add_new_rank'] = 'Add new rank';
-
-$lang['Rank_title'] = 'Rank Title';
-$lang['Rank_special'] = 'Set as Special Rank';
-$lang['Rank_minimum'] = 'Minimum Posts';
-$lang['Rank_maximum'] = 'Maximum Posts';
-$lang['Rank_image'] = 'Rank Image (Relative to phpBB2 root path)';
-$lang['Rank_image_explain'] = 'Use this to define a small image associated with the rank';
-
-$lang['Must_select_rank'] = 'You must select a rank';
-$lang['No_assigned_rank'] = 'No special rank assigned';
-
-$lang['Rank_updated'] = 'The rank was successfully updated';
-$lang['Rank_added'] = 'The rank was successfully added';
-$lang['Rank_removed'] = 'The rank was successfully deleted';
-$lang['No_update_ranks'] = 'The rank was successfully deleted. However, user accounts using this rank were not updated.  You will need to manually reset the rank on these accounts';
-
-$lang['Click_return_rankadmin'] = 'Click %sHere%s to return to Rank Administration';
-
-$lang['Confirm_delete_rank'] = 'Are you sure you want to delete this rank?';
-
-//
-// Disallow Username Admin
-//
-$lang['Disallow_control'] = 'Username Disallow Control';
-$lang['Disallow_explain'] = 'Here you can control usernames which will not be allowed to be used.  Disallowed usernames are allowed to contain a wildcard character of *.  Please note that you will not be allowed to specify any username that has already been registered. You must first delete that name then disallow it.';
-
-$lang['Delete_disallow'] = 'Delete';
-$lang['Delete_disallow_title'] = 'Remove a Disallowed Username';
-$lang['Delete_disallow_explain'] = 'You can remove a disallowed username by selecting the username from this list and clicking submit';
-
-$lang['Add_disallow'] = 'Add';
-$lang['Add_disallow_title'] = 'Add a disallowed username';
-$lang['Add_disallow_explain'] = 'You can disallow a username using the wildcard character * to match any character';
-
-$lang['No_disallowed'] = 'No Disallowed Usernames';
-
-$lang['Disallowed_deleted'] = 'The disallowed username has been successfully removed';
-$lang['Disallow_successful'] = 'The disallowed username has been successfully added';
-$lang['Disallowed_already'] = 'The name you entered could not be disallowed. It either already exists in the list, exists in the word censor list, or a matching username is present.';
-
-$lang['Click_return_disallowadmin'] = 'Click %sHere%s to return to Disallow Username Administration';
-
-
-//
-// Styles Admin
-//
-$lang['Styles_admin'] = 'Styles Administration';
-$lang['Styles_explain'] = 'Using this facility you can add, remove and manage styles (templates and themes) available to your users';
-$lang['Styles_addnew_explain'] = 'The following list contains all the themes that are available for the templates you currently have. The items on this list have not yet been installed into the phpBB database. To install a theme, simply click the install link beside an entry.';
-
-$lang['Select_template'] = 'Select a Template';
-
-$lang['Style'] = 'Style';
-$lang['Template'] = 'Template';
-$lang['Install'] = 'Install';
-$lang['Download'] = 'Download';
-
-$lang['Edit_theme'] = 'Edit Theme';
-$lang['Edit_theme_explain'] = 'In the form below you can edit the settings for the selected theme';
-
-$lang['Create_theme'] = 'Create Theme';
-$lang['Create_theme_explain'] = 'Use the form below to create a new theme for a selected template. When entering colours (for which you should use hexadecimal notation) you must not include the initial #, i.e.. CCCCCC is valid, #CCCCCC is not';
-
-$lang['Export_themes'] = 'Export Themes';
-$lang['Export_explain'] = 'In this panel you will be able to export the theme data for a selected template. Select the template from the list below and the script will create the theme configuration file and attempt to save it to the selected template directory. If it cannot save the file itself it will give you the option to download it. In order for the script to save the file you must give write access to the webserver for the selected template dir. For more information on this see the phpBB 2 users guide.';
-
-$lang['Theme_installed'] = 'The selected theme has been installed successfully';
-$lang['Style_removed'] = 'The selected style has been removed from the database. To fully remove this style from your system you must delete the appropriate style from your templates directory.';
-$lang['Theme_info_saved'] = 'The theme information for the selected template has been saved. You should now return the permissions on the theme_info.cfg (and if applicable the selected template directory) to read-only';
-$lang['Theme_updated'] = 'The selected theme has been updated. You should now export the new theme settings';
-$lang['Theme_created'] = 'Theme created. You should now export the theme to the theme configuration file for safe keeping or use elsewhere';
-
-$lang['Confirm_delete_style'] = 'Are you sure you want to delete this style?';
-
-$lang['Download_theme_cfg'] = 'The exporter could not write the theme information file. Click the button below to download this file with your browser. Once you have downloaded it you can transfer it to the directory containing the template files. You can then package the files for distribution or use elsewhere if you desire';
-$lang['No_themes'] = 'The template you selected has no themes attached to it. To create a new theme click the Create New link on the left hand panel';
-$lang['No_template_dir'] = 'Could not open the template directory. It may be unreadable by the webserver or may not exist';
-$lang['Cannot_remove_style'] = 'You cannot remove the style selected since it is currently the forum default. Please change the default style and try again.';
-$lang['Style_exists'] = 'The style name to selected already exists, please go back and choose a different name.';
-
-$lang['Click_return_styleadmin'] = 'Click %sHere%s to return to Style Administration';
-
-$lang['Theme_settings'] = 'Theme Settings';
-$lang['Theme_element'] = 'Theme Element';
-$lang['Simple_name'] = 'Simple Name';
-$lang['Value'] = 'Value';
-$lang['Save_Settings'] = 'Save Settings';
-
-$lang['Stylesheet'] = 'CSS Stylesheet';
-$lang['Stylesheet_explain'] = 'Filename for CSS stylesheet to use for this theme.';
-$lang['Background_image'] = 'Background Image';
-$lang['Background_color'] = 'Background Colour';
-$lang['Theme_name'] = 'Theme Name';
-$lang['Link_color'] = 'Link Colour';
-$lang['Text_color'] = 'Text Colour';
-$lang['VLink_color'] = 'Visited Link Colour';
-$lang['ALink_color'] = 'Active Link Colour';
-$lang['HLink_color'] = 'Hover Link Colour';
-$lang['Tr_color1'] = 'Table Row Colour 1';
-$lang['Tr_color2'] = 'Table Row Colour 2';
-$lang['Tr_color3'] = 'Table Row Colour 3';
-$lang['Tr_class1'] = 'Table Row Class 1';
-$lang['Tr_class2'] = 'Table Row Class 2';
-$lang['Tr_class3'] = 'Table Row Class 3';
-$lang['Th_color1'] = 'Table Header Colour 1';
-$lang['Th_color2'] = 'Table Header Colour 2';
-$lang['Th_color3'] = 'Table Header Colour 3';
-$lang['Th_class1'] = 'Table Header Class 1';
-$lang['Th_class2'] = 'Table Header Class 2';
-$lang['Th_class3'] = 'Table Header Class 3';
-$lang['Td_color1'] = 'Table Cell Colour 1';
-$lang['Td_color2'] = 'Table Cell Colour 2';
-$lang['Td_color3'] = 'Table Cell Colour 3';
-$lang['Td_class1'] = 'Table Cell Class 1';
-$lang['Td_class2'] = 'Table Cell Class 2';
-$lang['Td_class3'] = 'Table Cell Class 3';
-$lang['fontface1'] = 'Font Face 1';
-$lang['fontface2'] = 'Font Face 2';
-$lang['fontface3'] = 'Font Face 3';
-$lang['fontsize1'] = 'Font Size 1';
-$lang['fontsize2'] = 'Font Size 2';
-$lang['fontsize3'] = 'Font Size 3';
-$lang['fontcolor1'] = 'Font Colour 1';
-$lang['fontcolor2'] = 'Font Colour 2';
-$lang['fontcolor3'] = 'Font Colour 3';
-$lang['span_class1'] = 'Span Class 1';
-$lang['span_class2'] = 'Span Class 2';
-$lang['span_class3'] = 'Span Class 3';
-$lang['img_poll_size'] = 'Polling Image Size [px]';
-$lang['img_pm_size'] = 'Private Message Status size [px]';
-
-
-//
-// Install Process
-//
-$lang['Welcome_install'] = 'Welcome to phpBB 2 Installation';
-$lang['Initial_config'] = 'Basic Configuration';
-$lang['DB_config'] = 'Database Configuration';
-$lang['Admin_config'] = 'Admin Configuration';
-$lang['continue_upgrade'] = 'Once you have downloaded your config file to your local machine you may\'Continue Upgrade\' button below to move forward with the upgrade process.  Please wait to upload the config file until the upgrade process is complete.';
-$lang['upgrade_submit'] = 'Continue Upgrade';
-
-$lang['Installer_Error'] = 'An error has occurred during installation';
-$lang['Previous_Install'] = 'A previous installation has been detected';
-$lang['Install_db_error'] = 'An error occurred trying to update the database';
-
-$lang['Re_install'] = 'Your previous installation is still active.<br /><br />If you would like to re-install phpBB 2 you should click the Yes button below. Please be aware that doing so will destroy all existing data and no backups will be made! The administrator username and password you have used to login in to the board will be re-created after the re-installation and no other settings will be retained.<br /><br />Think carefully before pressing Yes!';
-
-$lang['Inst_Step_0'] = 'Thank you f...
 
[truncated message content]