[Phpbbkb-checkins] SF.net SVN: phpbbkb: [29] root

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

Revision: 29
          http://svn.sourceforge.net/phpbbkb/?rev=29&view=rev
Author:   softphp
Date:     2006-12-13 16:13:52 -0800 (Wed, 13 Dec 2006)

Log Message:
-----------
-Added acp structure for categories and did a bit of untested code :) Please note that I'm probably restructuring the ucp_class very shortly, so it's not a class, due to several problems I've encountered.

Modified Paths:
--------------
    root/admin/admin_kb.php

Added Paths:
-----------
    root/templates/subSilver/admin/
    root/templates/subSilver/admin/kb_editcat.tpl

Modified: root/admin/admin_kb.php
===================================================================
--- root/admin/admin_kb.php	2006-12-12 22:17:54 UTC (rev 28)
+++ root/admin/admin_kb.php	2006-12-14 00:13:52 UTC (rev 29)
@@ -27,6 +27,12 @@
 	return;
 }
 
+// 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)
@@ -35,6 +41,98 @@
 		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;
+		$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 = "";
+				
+				$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'],
+					'CAT_DESC' => $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 . "?edit=" . $edit)
+				);
+				
+				$template->pparse('body');
+			}
+			else
+			{
+				
+			}
+		}
+		
+		if($delete != false)
+		{
+			
+		}
+		
+		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)
+				);
+				
+				$template->pparse('body');
+			}
+			else
+			{
+				
+			}
+		}
+		
+		if($sort != false)
+		{
+			
+		}
+		
+		// Show categories as list
 		break;
 		
 	case "permissions": // For later use
@@ -47,3 +145,26 @@
 		break;
 }
 
+
+//////////////////
+/// FUNCTIONS  ///
+//////////////////
+function generate_cat_parents($selected = false)
+{
+	global $db;
+	
+	$sql = "SELECT * FROM " . KB_CATEGORIES_TABLE . " WHERE cat_main = '0' ORDER BY cat_order"; // 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;
+	}
+	
+	$parent = "";
+}
+?>

Added: root/templates/subSilver/admin/kb_editcat.tpl
===================================================================
--- root/templates/subSilver/admin/kb_editcat.tpl	                        (rev 0)
+++ root/templates/subSilver/admin/kb_editcat.tpl	2006-12-14 00:13:52 UTC (rev 29)
@@ -0,0 +1,29 @@
+
+<h1>{L_HEADER}</h1>
+
+<p>{L_EXPLAIN}</p>
+
+<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="forumname" value="{CAT_TITLE}" class="post" /></td>
+	</tr>
+	<tr> 
+	  <td class="row1">{L_CAT_DESCRIPTION}</td>
+	  <td class="row2"><textarea rows="5" cols="45" wrap="virtual" name="forumdesc" class="post">{DESCRIPTION}</textarea></td>
+	</tr>
+	<tr> 
+	  <td class="row1">{L_CAT_PARENT}</td>
+	  <td class="row2">{S_PARENT}</td>
+	</tr>
+	<tr> 
+	  <td class="catBottom" colspan="2" align="center">{S_HIDDEN_FIELDS}<input type="submit" name="submit" value="{S_SUBMIT_VALUE}" class="mainoption" /></td>
+	</tr>
+  </table>
+</form>
+		
+<br clear="all" />
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.