# HG changeset patch
# User "Meillo  r e t u r n s <meillo@marmaro.de>"
# Date 1165181533 -3600
# Node ID 3021ce32ee142c32840dbc01d6db34487f9daab8

begin of using hg for owls

diff -r 000000000000 -r 3021ce32ee14 .hgignore
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/.hgignore	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,12 @@
+syntax: glob
+
+.*.swp
+.*.swo
+*~
+
+_Dev
+
+Banner.png
+Smilies
+favicon.ico
+robots.txt
diff -r 000000000000 -r 3021ce32ee14 .htaccess
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/.htaccess	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,16 @@
+RewriteEngine On
+Options -MultiViews
+DirectoryIndex Owls.php
+#ErrorDocument 404 /Owls.php?error=404
+
+
+# rules
+
+  RewriteRule ^([0-9]+)$ Owls.php?id=$1&action=show [NC]
+  RewriteRule ^([0-9]+)n$ Owls.php?id=$1&action=new [NC]
+  RewriteRule ^([0-9]+)e$ Owls.php?id=$1&action=edit [NC]
+  RewriteRule ^([0-9]+)d$ Owls.php?id=$1&action=delete [NC]
+
+  RewriteRule ^([0-9]+)login$ Owls.php?id=$1&action=login [NC]
+  RewriteRule ^([0-9]+)logout$ Owls.php?id=$1&action=logout [NC]
+
diff -r 000000000000 -r 3021ce32ee14 Includes/Bbcodeparser.inc.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Includes/Bbcodeparser.inc.php	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,94 @@
+<?php
+
+/**
+ *
+ * BB-Code-Parser
+ *
+ * by Meillo  r e t u r n s
+ *
+ */
+
+
+  function parse_quote1($textinput,$level = 1) {                  // ohne Quelle
+    $pattern = '#\[quote\](((?R)|(.*))*)\[/quote\]#isUe';
+    $replacement = "'<br />[nl]<span class=\"quote0\">Zitat:</span>[nl]<div class=\"quote1\">[nl]'.parse_quote1('$1',
+                     ". ($level + 1) ."
+                   ).'[nl]</div>[nl]'";
+    return preg_replace($pattern, $replacement, $textinput);
+  }
+  function parse_quote2($textinput,$level = 1) {                   // mit Quelle
+    $pattern = '#\[quote\=(.*)\](((?R)|(.*))*)\[/quote\]#isUe';
+    $replacement = "'<br />[nl]<span class=\"quote0\">Zitat: ($1)</span>[nl]<div class=\"quote2\">[nl]'.parse_quote2('$2',
+                     ". ($level + 1) ."
+                   ).'[nl]</div>[nl]'";
+    return preg_replace($pattern, $replacement, $textinput);
+  }
+
+  function smilies($text) {
+    $smilieDir = 'Pics/Smilies/';  // path to smilies
+
+    $smilies = array( ':-)'        => 'Smile.gif',
+                      ':)'         => 'Smile.gif',
+                      ';-)'        => 'Wink.gif',
+                      ';)'         => 'Wink.gif',
+                      ':-D'        => 'Biggrin.gif',
+                      ':D'         => 'Biggrin.gif',
+                      ':-('        => 'Sad.gif',
+                      ':('         => 'Sad.gif',
+                      ':-P'        => 'Lick.gif',
+                      ':P'         => 'Lick.gif',
+                      ':o'         => 'Talk.gif',
+                      ':-S'        => 'Dontknow.gif',
+                      ':dontknow:' => 'Dontknow.gif',
+                      ':-@'        => 'Angry.gif',
+                      ':cool:'        => 'Cool.gif',
+                      '(H)'        => 'Cool.gif',
+                      '%-)'        => 'Crosseyed.gif',
+                      '%-('        => 'Crosseyed.gif',
+                      ':rolleyes:' => 'Rolleyes.gif',
+                      ':eek:'      => 'Shocked.gif');
+    while(list($key, $val) = each($smilies)) {
+      $text = str_replace($key,'[img]'.$smilieDir.$val.'[/img]',$text);
+    }
+    return $text;
+  }
+
+
+  function bbcode($text, $smilies = 0, $images = 0) {
+
+    // smilies
+    if ($smilies == 1) {
+      $text = smilies($text);
+    }
+
+    // new-lines
+    $text = preg_replace("#(\r\n)|(\r)#", "\n", $text);
+    $text = str_replace("\n", '<br />[nl]', htmlentities($text));
+
+    // bold
+    $text = preg_replace("#\[b\](.*?)\[/b\]#i", "<strong>$1</strong>", $text);
+    // italic
+    $text = preg_replace("#\[i\](.*?)\[/i\]#i", "<i>$1</i>", $text);
+    // links
+    $text = preg_replace("#\[url\](.*)\[/url\]#iU", "<a href=\"$1\">$1</a>", $text);
+    $text = preg_replace("#\[url=(.*)\](.*)\[/url\]#iU", "<a href=\"$1\">$2</a>", $text);
+    // lists
+      //$text = preg_replace("#\[list\]\<br /\>(.*)\[/list\]#iU", "<ul>$1</ul>", $text);
+      //$text = preg_replace("#\[\*\](.*)\<br \/\>#iU", "<li>$1</li>", $text);
+    // quotes
+    $text = parse_quote1($text);
+    $text = parse_quote2($text);
+    // images
+    if ($images == 1) {
+      $text = preg_replace("#\[img\](.*?)\[/img\]#i", "<img src=\"$1\" alt=\"&lt;[Bild]&gt;\" />", $text);
+    }
+
+    // remove backslashes
+    $text = preg_replace("#\\\#is", "", $text);
+    // new-lines
+    $text = str_replace('[nl]', "\n", $text);
+
+    return $text;
+  }
+
+?>
\ No newline at end of file
diff -r 000000000000 -r 3021ce32ee14 Includes/Footer.inc.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Includes/Footer.inc.php	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,7 @@
+  </div>
+
+
+</div>
+
+</body>
+</html>
diff -r 000000000000 -r 3021ce32ee14 Includes/Header.inc.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Includes/Header.inc.php	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,71 @@
+<?php
+
+  define('DB_PREFIX', 'rem__1_');
+  define('TITLE', 'Owls');
+
+  require_once '../Db.inc.php';
+  require_once 'Includes/Loginsys.class.php';
+  include_once 'Includes/Bbcodeparser.inc.php';
+
+  $lsys = &new Loginsys();
+
+?>
+<!--
+
+                       `Owls' - some kind of wiki system
+
+
+                (c) Copyright  2006 &>  by Meillo  r e t u r n s
+
+         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.
+
+        This program is distributed in the hope that it will be useful,
+         but WITHOUT ANY WARRANTY; without even the implied warranty of
+         MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+                  GNU General Public License for more details.
+
+
+                          http://prog.marmaro.de/owls/
+
+-->
+
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
+
+<html xml:lang="de" xmlns="http://www.w3.org/1999/xhtml">
+<head>
+  <title><?php echo htmlentities(TITLE); ?></title>
+  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
+  <link rel="shortcut icon" href="favicon.ico" />
+  <link rel="stylesheet" type="text/css" href="Owls.css.php" />
+  <script type="text/javascript">
+  <!--
+    function sureToDelete(id) {
+      if (window.prompt("Type 'delete' to delete","") == "delete") {
+        location.href = id +"d";
+      }
+    }
+
+    
+    function toggleVisibility(boxId) {
+      if (document.getElementById('node'+ boxId).style.display == 'none') {
+        document.getElementById('node'+ boxId).style.display = "";
+        document.getElementById('ctrl'+ boxId).firstChild.nodeValue = "-";
+      } else{
+        document.getElementById('node'+ boxId).style.display = "none";
+        document.getElementById('ctrl'+ boxId).firstChild.nodeValue = "+";
+      }
+    }
+    
+  //-->  
+  </script>
+</head>
+
+<body>
+<div id="websiteContainer">
+
+  <!-- Banner -->
+  <img src="Banner.png" id="banner" alt="<?php echo htmlentities(TITLE); ?>" />
+
diff -r 000000000000 -r 3021ce32ee14 Includes/Loginsys.class.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Includes/Loginsys.class.php	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,65 @@
+<?php
+
+define('TIME_SESSION_EXPIRES', 1800);
+
+
+class Loginsys {
+
+  // Constructors
+
+  public function __construct() {
+    session_start();
+    $this->heartbeat();
+  }
+
+
+
+
+  // Methods
+
+  public function login($loginname, $password_md5) {    // login ------------------------------------
+    $rowuser = mysql_fetch_array(mysql_query("select * from ". DB_PREFIX ."User where loginname='$loginname' and password='$password_md5' "));
+    if (mysql_affected_rows() == 1) {  // valid login
+      $_SESSION[login][id] = $rowuser[id];
+      $_SESSION[login][loginname] = $loginname;
+      $_SESSION[login][logintime] = time();
+    }
+  }
+
+
+
+  public function logout() {    // logout ------------------------------------------------------------
+    unset($_SESSION[login]);
+  }
+
+
+
+  public function loggedIn() {    // return login-status ---------------------------------------------
+    return (isset($_SESSION[login][id]) && $_SESSION[login][logintime] > time()-TIME_SESSION_EXPIRES);
+  }
+
+
+
+  public function heartbeat() {
+    if ($this->loggedIn()) {
+      $_SESSION[login][logintime] = time();
+    }
+  }
+
+
+
+  // Getter and Setter
+
+  public function getUserId() {
+    return $_SESSION[login][id];
+  }
+
+
+  public function getLoginname() {
+    return $_SESSION[login][loginname];
+  }
+
+}
+
+
+?>
diff -r 000000000000 -r 3021ce32ee14 Includes/Nav.inc.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Includes/Nav.inc.php	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,86 @@
+  <!-- Nav -->
+  <ul id="nav">
+
+<?php
+    // build nav tree
+    echo '    '. navtree(0) ."\n";
+
+
+    // find unmatched nodes (orphans)
+    $sql = sprintf("
+      select distinct
+        idParent
+      from %sOwls 
+      where 
+        idParent not in (select id from %sOwls) 
+        and idParent != 0    -- not the real root
+--        and idParent != id   -- avoid endless recursion
+      order by name asc
+      ",
+      DB_PREFIX,
+      DB_PREFIX
+    );
+    $result = mysql_query($sql) or die(mysql_error());
+    unset($sql);
+
+    // output only if there are orphans
+    if (mysql_num_rows($result)) {
+      echo '    <li id="orphans">orphans<ul>';
+      // output subtree for every orphan
+      while($row = mysql_fetch_array($result)) {
+        echo navtree($row['idParent']);
+      }
+      unset($row);
+      mysql_free_result($result);
+
+      echo '</ul></li>';
+    }
+?>
+
+    <li id="login">
+<?php
+      if ($lsys->loggedIn()) {
+        echo '    <a href="'. $_GET['id'] .'logout" style="color: #c00;">logout</a>';
+      } else {
+?>
+      <form name="loginform" action="<?php echo $_GET['id']; ?>login" method="post" enctype="multipart/form-data">
+        <input name="login_loginname" type="text" />
+        <input name="login_password" type="password" />
+        <input name="login" type="submit" value="login" style="padding: 0; cursor: pointer;" />
+      </form>
+<?php
+      }
+?>
+    </li>
+
+  </ul>
+
+<?php
+
+    function navtree($root) {
+      // fetch subcategories
+      $result = mysql_query("select * from ". DB_PREFIX ."Owls where idParent = $root order by name asc");
+
+      $return = '';
+      while($row = mysql_fetch_array($result)) {
+        $return .= '<li><a href="'. $row['id'] .'"'. (($_GET['id'] == $row['id']) ? ' id="selected"' : '') .'>'. $row['name'] .'</a>';
+        if ($row['id'] != $row['idParent']) {
+          $subtree = navtree($row['id']);
+          if (!empty($subtree)) {
+            $return .= '&nbsp;&nbsp;<a href="javascript:toggleVisibility(\''. $row[id] .'\')" id="ctrl'. $row['id'] .'" style="display: none;">-</a>';
+            $return .= '<ul id="node'. $row['id'] .'">'. $subtree .'</ul>';
+          }
+          unset($subtree);
+        }
+        $return .= '</li>';
+      }
+      unset($row);
+      mysql_free_result($result);
+
+      // return
+      return $return;
+    }
+
+?>
+
+  <!-- Content -->
diff -r 000000000000 -r 3021ce32ee14 Owls.css.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Owls.css.php	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,215 @@
+<?php
+  header('Content-Type: text/css; charset=utf8');
+
+  // Caching verhindern
+  header('Expires: Thu, 05 Apr 1984 04:47:00 GMT');
+  header('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT');
+  header('Cache-Control: no-store');
+  header('Pragma: no-cache');
+  echo('/* Anti-Caching: '.microtime()." */\r\n");
+
+
+  // colors
+  $cProject           = '#96c';
+
+  $cBackgroundGlobal  = '#666';
+  //$cBackgroundContent = '#666';  //eee
+
+  $cBorderGlobal      = '#000';
+
+  $cTextH1            = '#aaa';
+
+  $cLinkHover         = $cProject;
+
+  $cNav               = '#333';
+
+
+  $mContentMinHeight  = '22em';
+
+  $mNavWidth          = '12em';
+
+
+?>
+
+
+
+/*####  Standard  ############################################################*/
+body {
+  font-family: sans-serif;
+  margin: 30px 0;
+  text-align: center;
+  background-color: <?php echo $cBackgroundGlobal ?>;
+}
+
+
+#websiteContainer {
+  width: 760px;
+  margin: 0 auto;
+  text-align: left;
+}
+
+#banner {
+  display: block;
+  border: 1px solid <?php echo $cBorderGlobal ?>;
+}
+
+
+#content {
+  margin-left: <?php echo $mNavWidth; ?>;
+  padding: 1em;
+}
+
+
+#edit input,
+#edit select,
+#edit textarea {
+  font-family: sans-serif;
+  font-size: 0.8em;
+}
+
+
+p {
+  text-align: justify;
+}
+
+
+a {
+  text-decoration: underline;
+}
+a:link {
+  color: #000;
+}
+a:visited {
+  color: #aaa;
+}
+a:active,
+a:hover {
+  color: <?php echo $cLinkHover; ?>;
+}
+
+
+img {
+  border: none;
+}
+
+.small {
+  font-size: 0.8em;
+}
+
+
+
+
+
+
+
+
+
+#nav {
+  float: left;
+  width: <?php echo $mNavWidth; ?>;
+  padding: 0.5em 2em 1em 0.5em;
+  margin: 2.5em 0 1em 0;
+  font-size: 0.8em;
+}
+
+#nav ul {
+  padding-left: 1em;
+/*  border: 1px solid #060; */
+}
+
+#nav li {
+  padding: 1px;
+  margin: 0;
+/*  border: 1px solid #006; */
+}
+
+#nav a {
+  text-decoration: none;
+  color: <?php echo $cTextH1; ?>;
+}
+#nav a:link,
+#nav a:visited {
+  text-decoration: none;
+}
+#nav a:active,
+#nav a:hover {
+  color: <?php echo $cLinkHover; ?>;
+  text-decoration: none;
+}
+
+#selected:link,
+#selected:visited {
+  color: <?php echo $cBorderGlobal; ?>;
+}
+#nav #selected:hover {
+  color: <?php echo $cLinkHover; ?>;
+}
+
+
+li#orphans {
+  margin-top: 2em;
+  font-style: italic;
+  color: #aaa;
+}
+
+li#login {
+  margin-top: 3em;
+}
+#login input {
+  background-color: transparent;
+  border: none;
+  border-left: #555 1px solid;
+  display: block;
+  font-size: 0.8em;
+  margin-bottom: 2px;
+  padding-left: 4px;
+}
+
+
+
+
+.ctrl {
+  text-align: right;
+  font-size: 0.8em;
+}
+.ctrl a {
+  margin-left: 1em;
+  color: #eee;
+}
+
+
+
+
+
+
+
+
+/*####  BBCode  ##############################################################*/
+
+.quote1 {
+  border:1px solid #c0c0c0;
+  margin:5px;
+  padding:5px;
+}
+.quote2 {
+  border:1px solid #c0c0c0;
+  margin:5px;
+  margin-bottom:0px;
+  padding:5px;
+}
+.quote0 {
+  color: #000;
+  font-size: 0.8em;
+}
+
+ul {
+  list-style: none;
+  margin-left: 0;
+  padding-left: 1em;
+}
+li {
+  margin-left: 1em;
+  padding-left: 0;
+  /*list-style-image: url(Pics/Bullet.gif);*/
+}
+
diff -r 000000000000 -r 3021ce32ee14 Owls.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Owls.php	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,212 @@
+<?php
+  require_once 'Includes/Header.inc.php';
+
+
+  if ($_GET['action'] == 'show') {    // show
+    show($lsys);
+
+  } else if ($_GET['action'] == 'new' && $lsys->loggedIn()) {    // new
+    create($lsys);
+
+  } else if ($_GET['action'] == 'edit' && $lsys->loggedIn()) {    // edit
+    edit($lsys);
+
+  } else if ($_GET['action'] == 'delete' && $lsys->loggedIn()) {    // delete
+    delete($lsys);
+
+  } else if ($_GET['action'] == 'login') {    // login
+    $lsys->login($_POST['login_loginname'], md5($_POST['login_password']));
+    show($lsys);
+
+  } else if ($_GET['action'] == 'logout') {    // logout
+    $lsys->logout();
+    show($lsys);
+
+  } else {    // startpage
+    $_GET['id'] = 1;
+    show($lsys);
+
+  }
+
+
+  require_once 'Includes/Footer.inc.php';
+
+
+
+
+
+
+
+
+
+
+
+/*
+    displays content of the node
+    performs action 'edit'
+    shows admincontrols if logged in
+*/
+function show($lsys) {
+
+  // perform action: write edited node to db
+  if (isset($_POST['editDoc']) && $lsys->loggedIn()) {
+    $_POST['editDoc_title'] = addslashes($_POST['editDoc_title']);
+    $_POST['editDoc_text'] = addslashes($_POST['editDoc_text']);
+    mysql_query("update ". DB_PREFIX ."Owls set
+      name='$_POST[editDoc_title]',
+      text='$_POST[editDoc_text]',
+      idParent='$_POST[editDoc_idCategory]',
+      date=". time() ."
+    where id='$_GET[id]'") or die(mysql_error());
+  }
+
+  // print nav
+  include 'Includes/Nav.inc.php';
+
+
+  // query data of the node
+  $result = mysql_query("select * from ". DB_PREFIX ."Owls where id=$_GET[id]");
+  
+  // catch nodes that not exist
+  if (!mysql_num_rows($result)) {
+
+    $fnord = array('',
+      'Fnord is the space between the pixels on your screen.',
+      'Fnord is the echo of silence.',
+      'Fnord is evaporated herbal tea without the herbs.',
+      'Fnord is what you see when you close your eyes.',
+      'Fnord is the empty pages at the end of the book.',
+      'Fnord is why ducks eat trees.',
+      'Fnord is the bucket where they keep the unused serifs for H*lvetica.',
+      'Fnord is the source of all the zero bits in your computer.'
+    );
+
+?>
+      <div id="content">
+        <h2>Error 23 - fnord found</h2>
+        <p>
+          <?php echo $fnord[rand(0, sizeof($fnord)-1)]; ?>
+        </p>
+<?php
+
+  } else {
+
+    $row = mysql_fetch_array($result);
+    echo '  <div id="content">'."\n";
+
+      // display admin controls if logged in
+      if ($lsys->loggedIn()) {
+?>
+        <div class="ctrl" style="font-size: 0.8em;">
+          <a href="<?php echo $row['id'] .'n'; ?>">new</a>
+          <a href="<?php echo $row['id'] .'e'; ?>">edit</a>
+<?php
+          if ($row['id'] != 1) {
+            echo '<a href="javascript:sureToDelete('. $row['id'] .')">delete</a>';
+          }
+?>
+        </div>
+<?php
+      }
+
+    // print content of the node
+    echo '    <h2>'.stripslashes($row['name']).'</h2>'."\n";
+    if (!empty($row['text'])) {
+      echo '    <p>'.bbcode(stripslashes($row['text']), 1, 1).'</p>';
+    }
+  }
+  echo "\n\n";
+
+}
+
+
+
+
+
+/*
+    displays edit form
+*/
+function edit($lsys) {
+
+    include 'Includes/Nav.inc.php';
+
+    $sql = "select * from ". DB_PREFIX ."Owls where id=$_GET[id]";
+    $result = mysql_query($sql) or die(mysql_error());
+    $row = mysql_fetch_array($result);
+      echo '<div id="content">';
+?>
+<div id="edit">
+  <form action="<?php echo $row['id']; ?>" method="post" enctype="multipart/form-data">
+<?php
+    if ($_GET['id'] != 1) {
+?>
+      <select name="editDoc_idCategory" style="width: 99%;">
+<?php
+      $result = mysql_query("select * from ". DB_PREFIX ."Owls order by name asc") or die(mysql_error());
+      while($rowCats = mysql_fetch_array($result)) {
+        echo '  <option value="'.$rowCats['id'].'"'. (($row['idParent'] == $rowCats['id']) ? ' selected="selected"' : '') .'>'.stripslashes($rowCats['name']).'</option>';
+      }
+?>
+      </select><br /><br />
+<?php
+    }
+?>
+    <input name="editDoc_title" type="text" value="<?php echo stripslashes($row['name']); ?>" style="width: 99%;" /><br />
+    <textarea name="editDoc_text" cols="60" rows="15" style="width: 99%; height: 30em;"><?php
+      echo stripslashes($row['text']);
+    ?></textarea><br /><br />
+    <input name="editDoc" type="submit" value="edit" class="button" style="width: 99%;" />
+  </form>
+</div>
+<?php
+  unset($row);
+  unset($result);
+}
+
+
+
+
+
+
+/*
+    performs action 'new'
+*/
+function create($lsys) {
+
+  // perform action: new node
+  mysql_query("
+    insert into ". DB_PREFIX ."Owls
+    (idParent, date)
+    values('$_GET[id]',". time() .")
+  ") or die(mysql_error());
+
+  // set node to jump to (new created node)
+  $_GET['id'] = mysql_insert_id();
+  edit($lsys);
+}
+
+
+
+
+
+/*
+    performs action 'delete'
+*/
+function delete($lsys) {
+  // not allowed to delete the root
+  if ($_GET['id'] != 1) {
+    // TODO: get the parent of the one which is to delete
+
+    // delete
+    mysql_query("delete from ". DB_PREFIX ."Owls where id='$_GET[id]'") or die(mysql_error());
+  }
+  // set node to jump to (TODO: parent from above)
+  $_GET['id'] = 1;
+  show($lsys);
+}
+
+
+
+
+?>
+
diff -r 000000000000 -r 3021ce32ee14 Setup.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Setup.php	Sun Dec 03 22:32:13 2006 +0100
@@ -0,0 +1,52 @@
+<?php
+
+// you can customize the config here
+
+$dbPrefix = 'rem__2_';    // the names of the db-tables will be prefixed with this string
+
+//$modifyProtected = true;    // are guests allowed to modify data? (true or false)
+
+$defaultUser = 'admin';    // useraccount if "modifyProtected = true" above
+$defaultUserPassword = 'admin';    // password for useraccount if "modifyProtected = true" above
+
+
+
+// dont change anything form here on (except you know what you do)
+//##################################################################
+
+  // write db-login-data to textfile
+
+
+  // connect to db and create tables
+  require('../Db.inc.php');
+
+
+  // table 'Owls' for the content data
+  mysql_query("
+    CREATE TABLE IF NOT EXISTS `". $dbPrefix ."Owls` (
+      `id` int(11) NOT NULL auto_increment,
+      `idParent` int(11) default '0',
+      `name` text NOT NULL,
+      `text` longtext NOT NULL,
+      `permission` tinyint(4) NOT NULL default '1',
+      `date` int(11) NOT NULL default '0',
+      PRIMARY KEY  (`id`)
+    )
+  ") or die(mysql_error());
+
+  // insert startup nodes
+  mysql_query("INSERT INTO `". $dbPrefix ."Owls` VALUES (1, 0, 'Index', 'Thanks for using [url=http://prog.marmaro.de/owls/]Owls[/url]!', 0, now())") or die(mysql_error());
+
+
+
+  // login should be managed via text file in future
+  mysql_query("CREATE TABLE IF NOT EXISTS `". $dbPrefix ."User` (
+    `id` int(11) NOT NULL auto_increment,
+    `loginname` tinytext NOT NULL,
+    `password` tinytext NOT NULL,
+    PRIMARY KEY  (`id`)
+  )") or die(mysql_error());
+
+  mysql_query("INSERT INTO `". $dbPrefix ."User` VALUES (1, '". $defaultUser ."', '". md5($defaultUserPassword) ."')") or die(mysql_error());
+
+?>