Instructions in detail:
  
	      To install my Knowledge Base
	      download the zip archive file knowledge.zip or myknowledgebase.zip from: http://schick.tripod.com and unzip it into
	      a new subdirectory on your Web server (ie. /kb). 
	       
	      Customize the file "knowledge.ini.php", the file
	      "footnote.html", the file
	      "top.html", select your own logo and change it with image 
	      "smile.gif" and your background image with "back.jpg" for the background of the Web
	      pages and your are finished (if mySQL and PHP are installed and running on your Web server or
	      localhost and the path for this Web application is aliased in the Web server's
	      configuration menu or file). The file "knowledge.ini.php"
             could be modified by the install page: "install.html"
             and the related php script "install.php".
             The URL address for the installation by install.html and install.php on localhost is: 
              
                   http://localhost/kb/install.html      if your virtual Web directory is /kb
  
             Fill out on input fields your settings or select suggested options there and submit it.
             To translate the Web page content (11 pages) into another language as the present languages click the language link on install page, this takes some time. 
              
             After completed installation, please remove these files: install.html, install.php and translate.php from your Web
             directory. 
              
             There must grant permissions to a user of mySQL with the userid from the init file: knowledge.ini.php
             with privileges like: select, insert, update, alter, create, delete, drop, reload, index on tables and databases
             with grant option go from allowed hosts; see table mysql.user
             or ask your DBA of the mySQL server on your used system. During installation of mySQL, you will be asked for that userid and password
             and it will be assumed the necessary privileges to that userid by default. On multiple user systems, it is preferable to use a separate
             userid for that PHP & mySQL application with own privileges which are not the complete root admin privileges.
             For that, use INSERT SQL statement on table mysql.user to insert a new user for using as userid in file knowledge.ini.php 
             and GRANT SQL statement to grant permissions for the new user inserted into table mysql.user on your mySQL server.
              
	       
	      The start pages of my Knowledge Base (that PHP & mySQL application) are
	      knowledge.html or
	      lookup.php. At a localhost with virtual Web path $path = "/kb" is the URL address 
             for the Web browser ie. 
            http://localhost/kb/knowledge.html   or
            http://localhost/kb/lookup.php
             log in there by clicking of the icon:  ,   type in a first test note and submit it. This test note could be deleted later.
	      
	      The needed database on mySQL server and the knowledge bases (tables) will
	      be created at the first login. The first login should be with username: admin
	      and a password you are typed in on logon window. Be sure that the admin password
	      is your own. You can create new knowledge bases (tables) by inserting the
	      knowledge base names in the FORM selection list as new options in the file
	      "tables.html" and select the configuration option $tables=true on file
	      "knowledge.ini.php". You can also create as user "admin" new knowledge bases
	      (tables) by calling the page "knowledge.php", "knowledge.php" can only be
	      called if you want to reply (icon:  )   to an existing message from the subject ("list.php")
	      or message ("show.php") listing and you are logged in. 
	       
	      If the PHP script files were loaded into the Web browser (via Web address
	      or localhost) and a user was not logged in, a line on the response page at
	      the top tells the user to login. 
	       
	      There is a language option implemented.
             On configuration file knowledge.ini.php there
	      could be defined at present 3 languages of the Web page text content:
	      $language="english" or 
             $language="french" or
             $language="german".
             The selected language uses the language files from the related PHP script file names. 
              
	      If you speak other languages and would translate the language files in your
	      language you could do it, ...and if you are so nice you can send me a copy
	      to provide these language files here to share it with others, Thanks!.  
	       
	      The following files will be unzipped: 
   readme.html
   knowledge.ini.php
   top.html
   footnote.html
   knowledge.html
   install.html
   tables.html
   smile.gif
   back.jpg
   knowledge.english.php
   list.english.php
   show.english.php
   delete.english.php
   lookup.english.php
   search.english.php
   insert.english
   delete_kb.english.php
   create.english.php
   browse.english.php
   logon.english.php
   knowledge.french.php
   list.french.php
   show.french.php
   delete.french.php
   lookup.french.php
   search.french.php
   insert.french.php
   delete_kb.french.php
   create.french.php
   browse.french.php
   logon.french.php.php
   knowledge.german.php
   list.german.php
   show.german.php
   delete.german.php
   lookup.german.php
   search.german.php
   insert.german.php
   delete_kb.german.php
   create.german.php
   browse.german.php
   logon.german.php.php
   firstmessage.txt.php
   pwd.css
   delete_kb.php
   delete.php
   insert.php
   knowledge.php
   list.php
   logon.php
   lookup.php
   search.php
   show.php
   create.php
   install.php
   browse.inc.php
   nichts.gif
   create.gif
   create1.gif
   answer.gif
   answer1.gif
   eye.gif
   eye1.gif
   left.gif
   left1.gif
   logged.gif
   logged1.gif
   logon.gif
   logon1.gif
   lookup.gif
   lookup1.gif
   right.gif
   right1.gif
   trash.gif
   trash1.gif
 
	      
	      The file 
	      readme.html include this instructions (could be removed from your public Web directory where you provide this tool). 
	       
	      The
	      knowledge.ini.php file includes the following configuration 
	      options for the PHP scripts (lines with pre // are comment lines):
	      
<?php
// name or IP-address of mySQL database server,
// userid and password for that server
$server      = "localhost";
$userid      = "mySQL_userid";
$passwd      = "mySQL_password";
$verbindung = @mysql_connect($server, $userid, $passwd) or
              die("Sorry!<br><br> no connection to mySQL" .
              " database server at host: $server.<br><br>" .
              " That could be happen:<br>" .
              " if the mySQL user: $userid" .
              " has no access to the mySQL server,<br>" .
              " or the mySQL database server is down at present,<br>" .
              " or you are using wrong userid/passwd on file knowledge.ini.php.");
// name of mySQL database
//      note: on some hosts, this name is restricted or 
//            pre-defined with value of $userid, ie. "mySQL_userid".
$db          = "know";
// name of administrator table in mySQL database $db
$know_admin  = "my_admin";
// tables are defined in file "tables.html" on FORM selection list
// and uses more than one knowledge bases (tables) in $db "know"
// $tables = true;   // switches this feature ON
// $tables = false;  // switches this feature OFF 
$tables      = false;
// default Knowledge Base table in $db
if (!$tables) $table       = "howto";
// language of Web page content
//$language    = "german";
//$language    = "french";
$language    = "english";
// $charset sets the character-set for the used Web browser
$charset     = "iso-8859-1";
// virtual Web path (alias on Web server path for that
// mySQL & PHP application) with one trailing slash (no leading slash)
// (all files from 'knowledge.zip' must be unzipped and saved into the
// subdirectory with that virtual path on your Web server or localhost)
$path        = "/kb";
// out fit parameters of Web pages
$bgcolor     = "whitesmoke";
$background  = "back.jpg";
$text        = "black";
$link        = "navy";
$alink       = "blue";
$vlink       = "mangenta"; 
// color of key on found search result page
$searchcolor = "red";  //darkblue, navy, etc.
$body        = "text='$text' link='$link' alink='$alink'
                vlink='$vlink' bgcolor='$bgcolor'
                background='$path/$background'";
?>
	       
	      The red values
	       above in the file knowledge.ini.php are
	      to customize to the conditions on your Web server settings or localhost. 
	       
	      Create & Delete one or more Knowledge Base Tables 
	       
	      If a knowledge base table does not exist, this table will be created by
	      "login.php" or by
	      "insert.php". In other words, if a user logs
	      in or the logged in user selects another table and inserts a message, the
	      table will be created. Within the file knowledge.ini.php is to set the statement
	      $tables=true if you'll use multiple knowledge
	      base tables or, if you want to use only one knowledge base tables use the statement
	      $tables=false.  
	       
	      New knowledge base tables can be added in "tables.html"
	      by inserting of new names in the FORM selection list with new option:  
	       
	      <FORM name='tabl'><TT> 
	      <select name='tables' size=1
	      onChange='selectTable(this.form.tables)'> 
	      <!-- option values must be enclosed with 'single' quotes and should be
	      lowercase -->  
	      <option value=''>Please select a specific Knowledge Base  
	        
	      <option value='howto'>  
	      howto 
	      <option
	      value='mykb'>
	       
	      mykb 
	      </select></TT>  
	      </FORM>  
	       
             If a knowledge base table should be deleted, remove the releated
             option on the HTML FORM selection list in file tables.html.
              
	      The user "admin" can also create new knowledge base tables by calling
	      the page "knowledge.php". This page "knowledge.php" can only be called if
	      you want to reply to an existing subject from the subject or message listing (icon  ).
	      That page "knowledge.php" offers the user "admin" the icons to create     or
             delete     knowledge base tables. The releated PHP scripts are create.php
             and delete_kb.php which update also the file "tables.html".
             In the file "knowledge.ini.php" must be set the option $tables = true if you want to use multiple
             knowledge base tables and will be create or delete tables as user "admin". 
	       
	      If you don't want to use this feature, set the $tables = false within the
	      configuration file "knowledge.ini.php". This is preferable. 
	       
	       
	      Password Security and login 
	      The password to login with username on the startpages: "knowledge.html",
	      "knowledge.php" or "lookup.php" (icon:  )  will be encrypted by a simple-complicated
	      algorithm -developed by the author- for using this tool also in Windows
	      95/98/2000/NT which have no default subroutine, like CRYPT on UNIX platforms.
	      The e-mail will not be used in that version. 
	       
	      The username and password will be used only to check the permission for the
	       access to the knowledge bases created by this tool; this is
	      >>not<< the mySQL username and >>not<< the password
	      to access mySQL on your server.
  
             Security & Privacy      
             For saving secret or private messages or notes, this tool is to that unsuitable. 
              
             To list or search messages from the knowledge base only (icons:    ) no login is necessary. 
              Message owners and the user "admin" can delete
             messages from the knowledge base message listing -if they are logged in. Therefore, the icon   will be appeared on the message listing. 
             
 
  
	      Well, that's all for now! Hope it's a nice
	      tool. 
	       
	      And if you find an error condition, please send me a note
	      (chic@arcor.de).  
             This tool is provided   "as it is"   (no warrenty) © Copyright of all scripts in this tool written in PHP & JavaScript by Arnold Schick
           |