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

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

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

Log Message:
-----------
A couple of changes including;
- Moving the install schema into to install/schemas/kb_schema.sql. The current install is only a tempory solution and is a bit of a hack; it probably won't get fixed before Alpha 1 but it should be by at least the betas.
- Adding a "Viewing KB" to both viewonline and the admin index.

Modified Paths:
--------------
    main/trunk/admin/index.php
    main/trunk/viewonline.php

Added Paths:
-----------
    main/trunk/install/schemas/kb_schema.sql
    main/trunk/templates/subSilver/images/lang_english/Thumbs.db

Modified: main/trunk/admin/index.php
===================================================================
--- main/trunk/admin/index.php	2007-01-26 18:02:51 UTC (rev 42)
+++ main/trunk/admin/index.php	2007-01-26 18:12:17 UTC (rev 43)
@@ -430,6 +430,10 @@
 							$location = $lang['Viewing_FAQ'];
 							$location_url = "index.$phpEx?pane=right";
 							break;
+						case PAGE_KB:
+							$location = $lang['Viewing_KB'];
+							$location_url = "index.$phpEx?pane=right";
+							break;
 						default:
 							$location = $lang['Forum_index'];
 							$location_url = "index.$phpEx?pane=right";
@@ -522,6 +526,10 @@
 						$location = $lang['Viewing_FAQ'];
 						$location_url = "index.$phpEx?pane=right";
 						break;
+					case PAGE_KB:
+							$location = $lang['Viewing_KB'];
+							$location_url = "index.$phpEx?pane=right";
+							break;
 					default:
 						$location = $lang['Forum_index'];
 						$location_url = "index.$phpEx?pane=right";

Added: main/trunk/install/schemas/kb_schema.sql
===================================================================
--- main/trunk/install/schemas/kb_schema.sql	                        (rev 0)
+++ main/trunk/install/schemas/kb_schema.sql	2007-01-26 18:12:17 UTC (rev 43)
@@ -0,0 +1,64 @@
+#
+# phpBB2 Knowledge Base :: MySQL install schema
+#
+# $Id: Exp $
+#
+
+CREATE TABLE phpbb_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)
+);
+
+CREATE TABLE phpbb_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)
+);
+
+CREATE TABLE phpbb_kb_articlecats (
+	article_id mediumint(8) NOT NULL DEFAULT '0',
+	cat_id mediumint(8) NOT NULL DEFAULT '0'
+);
+
+CREATE TABLE phpbb_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)
+);
\ No newline at end of file

Added: main/trunk/templates/subSilver/images/lang_english/Thumbs.db
===================================================================
(Binary files differ)


Property changes on: main/trunk/templates/subSilver/images/lang_english/Thumbs.db
___________________________________________________________________
Name: svn:mime-type
   + application/octet-stream

Modified: main/trunk/viewonline.php
===================================================================
--- main/trunk/viewonline.php	2007-01-26 18:02:51 UTC (rev 42)
+++ main/trunk/viewonline.php	2007-01-26 18:12:17 UTC (rev 43)
@@ -195,6 +195,10 @@
 					$location = $lang['Viewing_FAQ'];
 					$location_url = "faq.$phpEx";
 					break;
+				case PAGE_KB:
+					$location = $lang['Viewing_KB'];
+					$location_url = "kb.$phpEx";
+					break;
 				default:
 					$location = $lang['Forum_index'];
 					$location_url = "index.$phpEx";


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