Subversion Repositories taios

Compare Revisions

Ignore whitespace Rev 135 → Rev 171

/blog/edit-post.php
0,0 → 1,93
<?php
 
require '../_taios.php';
 
$page = new Taios_Page('Blog Posts', '../');
 
if (isset($_GET['id']))
{
$id = $_GET['id'];
}
else if (isset($_POST['id']))
{
$id = $_POST['id'];
}
else
{
$page->drawError('No ID set.');
}
 
$page->checkLoggedIn();
 
$post = $page->getBlogPost($id);
if (!$page->isUserAdmin($page->getLoggedInUser()) && $page->getLoggedInUser()->ID != $post->author->ID)
{
$page->drawError('You do not have permission to access this page.');
}
 
$error = '';
 
if (isset($_POST['id']))
{
$title = $_POST['title'];
$content = $_POST['content'];
$category = $_POST['category'];
 
if (empty($title))
{
$error = "No Title Specified";
}
else if (empty($content))
{
$error = "No Content Specified";
}
else
{
$page->query('UPDATE BlogPosts SET Content = "' . $content . '", Title = "' . $title . '", Category = "' . $category . '" WHERE ID = ' . $id);
$page->redirect('index.php');
}
}
 
$page->drawHeader();
$page->drawBlogCategoriesMenu();
$page->drawMiddle();
 
if (!empty($error))
{
$page->drawError($error, false);
}
 
?>
 
<form action="edit-post.php" method="post">
<table>
<tr>
<td class="bold">Title: </td>
<td><input type="text" name="title" value="<?php echo $post->title; ?>"/></td>
</tr>
<tr>
<td class="bold">Content: </td>
<td><textarea name="content" style="width: 500px; height: 300px;"><?php echo $post->content; ?></textarea></td>
</tr>
<tr>
<td class="bold">Catagory: </td>
<td><input type="text" name="category" /><?php echo $post->category; ?></td>
</tr>
 
<?php
write('<input type="hidden" name="id" value="' . $id . '" />');
?>
 
<tr>
<td class="bold"></td>
<td><input type="submit" value="Post" /></td>
</tr>
</table>
</form>
 
<?php
 
$page->drawFooter();
 
?>
 
/blog/add-post.php
1,91 → 1,96
<?php
 
function getParentID()
{
if (isset($_GET['id']))
{
return $_GET['id'];
}
else
{
return -1;
}
}
 
require '../_taios.php';
 
$page = new Taios_Page('Blog Posts', '../');
$page->checkLoggedIn();
 
$error = '';
 
if (isset($_POST['post']))
{
$title = $_POST['title'];
$content = $_POST['content'];
$parentID = $_POST['parentID'];
$category = $_POST['category'];
 
if (empty($title))
{
$error = "No Title Specified";
}
else if (empty($content))
{
$error = "No Content Specified";
}
else if (empty($parentID))
{
$error = "No Parent ID Specified";
}
else
{
$page->query('INSERT INTO BlogPosts VALUES(0, ' . $parentID . ', "' . $page->getLoggedInUser()->ID . '", "' . $title . '", "' . $content . '", NOW(), "' . $category . '", 0)');
$page->redirect('index.php');
}
}
 
$page->drawHeader();
$page->drawBlogCategoriesMenu();
$page->drawMiddle();
 
if (!empty($error))
{
$page->drawError($error, false);
}
 
?>
 
<form action="add-post.php?id=<?php echo getParentID(); ?>" method="post">
<table>
<tr>
<td class="bold">Title: </td>
<td><input type="text" name="title" /></td>
</tr>
<tr>
<td class="bold">Content: </td>
<td><textarea name="content" style="width: 500px; height: 300px;"></textarea></td>
</tr>
<tr>
<td class="bold">Catagory: </td>
<td><input type="text" name="category" /></td>
</tr>
 
<input type="hidden" name="post" value="yes" />
 
<?php
write('<input type="hidden" name="parentID" value="' . getParentID() . '" />');
?>
 
<tr>
<td class="bold"></td>
<td><input type="submit" value="Post" /></td>
</tr>
</table>
</form>
 
<?php
 
$page->drawFooter();
 
?>
<?php
 
function getParentID()
{
if (isset($_GET['id']))
{
return $_GET['id'];
}
else
{
return -1;
}
}
 
require '../_taios.php';
 
$page = new Taios_Page('Blog Posts', '../');
$page->checkLoggedIn();
 
$error = '';
 
if (isset($_POST['post']))
{
$title = $_POST['title'];
$content = $_POST['content'];
$parentID = $_POST['parentID'];
$category = $_POST['category'];
 
if (empty($title))
{
$error = "No Title Specified";
}
else if (empty($content))
{
$error = "No Content Specified";
}
else if (empty($parentID))
{
$error = "No Parent ID Specified";
}
else
{
if ($page->isUserNormal($page->getLoggedInUser()) && $parentID == -1)
{
$page->drawError('You do not have permission to access this page.');
}
$page->query('INSERT INTO BlogPosts VALUES(0, ' . $parentID . ', "' . $page->getLoggedInUser()->ID . '", "' . $title . '", "' . $content . '", NOW(), "' . $category . '", 0)');
$page->redirect('post.php?id=' . $parentID);
}
}
 
$page->drawHeader();
$page->drawBlogCategoriesMenu();
$page->drawMiddle();
 
if (!empty($error))
{
$page->drawError($error, false);
}
 
?>
 
<form action="add-post.php?id=<?php echo getParentID(); ?>" method="post">
<table>
<tr>
<td class="bold">Title: </td>
<td><input type="text" name="title" /></td>
</tr>
<tr>
<td class="bold">Content: </td>
<td><textarea name="content" style="width: 500px; height: 300px;"></textarea></td>
</tr>
<tr>
<td class="bold">Catagory: </td>
<td><input type="text" name="category" /></td>
</tr>
 
<input type="hidden" name="post" value="yes" />
 
<?php
write('<input type="hidden" name="parentID" value="' . getParentID() . '" />');
?>
 
<tr>
<td class="bold"></td>
<td><input type="submit" value="Post" /></td>
</tr>
</table>
</form>
 
<?php
 
$page->drawFooter();
 
?>
/blog/index.php
13,7 → 13,7
write('<br />');
}
 
$query = 'HERE ParentID = -1';
$query = 'WHERE ParentID = -1';
 
if (isset($_GET['cat']))
{
21,7 → 21,7
write('<p>Only showing blog posts from the ' . $_GET['cat'] . ' category. <a href="index.php">Reset Filtering</a></p><br />');
}
 
$query = $query . " AND ORDER BY DatePosted DESC";
$query = $query . " ORDER BY DatePosted DESC";
 
$ids = $page->findIDs('BlogPosts', $query);
for ($i = 0; $i < count($ids); $i++)
/data/smilies/face-laugh.png
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/data/smilies/face-laugh.png
Property changes:
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Index: data/smilies/face-plain.png
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: data/smilies/face-plain.png
===================================================================
--- data/smilies/face-plain.png (nonexistent)
+++ data/smilies/face-plain.png (revision 171)
/data/smilies/face-plain.png
Property changes:
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Index: data/smilies/face-sad.png
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: data/smilies/face-sad.png
===================================================================
--- data/smilies/face-sad.png (nonexistent)
+++ data/smilies/face-sad.png (revision 171)
/data/smilies/face-sad.png
Property changes:
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Index: data/smilies/face-uncertain.png
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: data/smilies/face-uncertain.png
===================================================================
--- data/smilies/face-uncertain.png (nonexistent)
+++ data/smilies/face-uncertain.png (revision 171)
/data/smilies/face-uncertain.png
Property changes:
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Index: data/smilies/face-wink.png
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: data/smilies/face-wink.png
===================================================================
--- data/smilies/face-wink.png (nonexistent)
+++ data/smilies/face-wink.png (revision 171)
/data/smilies/face-wink.png
Property changes:
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Index: data/smilies/face-raspberry.png
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: data/smilies/face-raspberry.png
===================================================================
--- data/smilies/face-raspberry.png (nonexistent)
+++ data/smilies/face-raspberry.png (revision 171)
/data/smilies/face-raspberry.png
Property changes:
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Index: data/smilies/face-surprise.png
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: data/smilies/face-surprise.png
===================================================================
--- data/smilies/face-surprise.png (nonexistent)
+++ data/smilies/face-surprise.png (revision 171)
/data/smilies/face-surprise.png
Property changes:
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Index: data/smilies/face-smile.png
===================================================================
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
Index: data/smilies/face-smile.png
===================================================================
--- data/smilies/face-smile.png (nonexistent)
+++ data/smilies/face-smile.png (revision 171)
/data/smilies/face-smile.png
Property changes:
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Index: admin/account-do.php
===================================================================
--- admin/account-do.php (revision 135)
+++ admin/account-do.php (revision 171)
@@ -1,53 +1,53 @@
-
-
-require '../_taios.php';
-
-$page = new Taios_Page('Update Account', '../');
-$userID = $page->getPostID();
-
-$page->checkLoggedIn();
-
-$accessID = $_POST['accessID'];
-$password = $_POST['password'];
-$email = $_POST['email'];
-$name = $_POST['name'];
-
-$user = $page->getUserByID($userID);
-if (($page->getLoggedInUser()->ID == $userID || $page->isUserAdmin($page->getLoggedInUser())) && $user)
-{
- if (isset($accessID) && $page->isUserAdmin($page->getLoggedInUser()))
- {
- $page->query('UPDATE Users SET AccessID = "' . $accessID . '" WHERE ID = ' . $userID);
- }
-
- if (!empty($password))
- {
- $page->query('UPDATE Users SET Password = "' . sha1($password) . '" WHERE ID = ' . $userID);
- }
-
- if (!empty($email))
- {
- $page->query('UPDATE Users SET EmailAddress = "' . $email . '" WHERE ID = ' . $userID);
- }
-
- if (!empty($name))
- {
- $page->query('UPDATE Users SET Name = "' . $name . '" WHERE ID = ' . $userID);
- }
-}
-else
-{
- if (!$user)
- {
- drawError('No such user, #' . $userID);
- }
- else
- {
- drawError('You do not have permission to access this page.');
- }
-}
-
-$page->redirect('account.php?id=' . $userID);
-
-?>
-
+
+
+require '../_taios.php';
+
+$page = new Taios_Page('Update Account', '../');
+$userID = $page->getPostID();
+
+$page->checkLoggedIn();
+
+$accessID = $_POST['accessID'];
+$password = $_POST['password'];
+$email = $_POST['email'];
+$name = $_POST['name'];
+
+$user = $page->getUserByID($userID);
+if (($page->getLoggedInUser()->ID == $userID || $page->isUserAdmin($page->getLoggedInUser())) && $user)
+{
+ if (isset($accessID) && $page->isUserAdmin($page->getLoggedInUser()))
+ {
+ $page->query('UPDATE Users SET AccessID = "' . $accessID . '" WHERE ID = ' . $userID);
+ }
+
+ if (!empty($password))
+ {
+ $page->query('UPDATE Users SET Password = "' . sha1($password) . '" WHERE ID = ' . $userID);
+ }
+
+ if (!empty($email))
+ {
+ $page->query('UPDATE Users SET EmailAddress = "' . $email . '" WHERE ID = ' . $userID);
+ }
+
+ if (!empty($name))
+ {
+ $page->query('UPDATE Users SET Name = "' . $name . '" WHERE ID = ' . $userID);
+ }
+}
+else
+{
+ if (!$user)
+ {
+ drawError('No such user, #' . $userID);
+ }
+ else
+ {
+ drawError('You do not have permission to access this page.');
+ }
+}
+
+$page->redirect('account.php?id=' . $userID);
+
+?>
+
Index: admin/account.php
===================================================================
--- admin/account.php (revision 135)
+++ admin/account.php (revision 171)
@@ -1,60 +1,60 @@
-
-
-require '../_taios.php';
-
-$page = new Taios_Page('Manage Account', '../');
-$page->drawHeader();
-$page->drawMiddle();
-
-$page->checkLoggedIn();
-
-$userID = $page->getGetID();
-$user = $page->getUserByID($userID);
-
-if (($page->getLoggedInUser()->ID == $userID || $page->isUserAdmin($page->getLoggedInUser())) && $user)
-{
-?>
-
-

Here you can edit your account.

-

Only change the password value if you want to change your password.

-
-
-
-');');
-
ID: ID; ?>
-
-if ($page->isUserAdmin($page->getLoggedInUser()))
-{
- write('
AccessID:
-}
-else
-{
- write('
AccessID: ' . $user->accessID . '
-}
-?>
-
Username: username; ?>
-
Password:
-
Email Address:
-
Name:
-
-
-
-
-
-}
-else
-{
- if (!$user)
- {
- drawError('No such user, #' . $userID);
- }
- else
- {
- drawError('You do not have permission to access this page.');
- }
-}
-
-$page->drawFooter();
-
-?>
-
+
+
+require '../_taios.php';
+
+$page = new Taios_Page('Manage Account', '../');
+$page->drawHeader();
+$page->drawMiddle();
+
+$page->checkLoggedIn();
+
+$userID = $page->getGetID();
+$user = $page->getUserByID($userID);
+
+if (($page->getLoggedInUser()->ID == $userID || $page->isUserAdmin($page->getLoggedInUser())) && $user)
+{
+?>
+
+

Here you can edit your account.

+

Only change the password value if you want to change your password.

+
+
+
+');');
+
ID: ID; ?>
+
+if ($page->isUserAdmin($page->getLoggedInUser()))
+{
+ write('
AccessID:
+}
+else
+{
+ write('
AccessID: ' . $user->accessID . '
+}
+?>
+
Username: username; ?>
+
Password:
+
Email Address:
+
Name:
+
+
+
+
+
+}
+else
+{
+ if (!$user)
+ {
+ drawError('No such user, #' . $userID);
+ }
+ else
+ {
+ drawError('You do not have permission to access this page.');
+ }
+}
+
+$page->drawFooter();
+
+?>
+
Index: admin/all-blog-posts.php
===================================================================
--- admin/all-blog-posts.php (revision 135)
+++ admin/all-blog-posts.php (revision 171)
@@ -1,60 +1,60 @@
-
-
-require '../_taios.php';
-
-$page = new Taios_Page('Manage All Blog Posts', '../');
-$page->drawHeader();
-$page->drawMiddle();
-
-$page->checkLoggedIn();
-
-if ($page->isUserAdmin($page->getLoggedInUser()))
-{
- write('

Use this to manage all the blog posts on the Tim32 Website.


');
-
- write('');');');');');');');');');');');');');');');');');');');');');');
- write('
- write('ID
- write('Parent
- write('Author
- write('Title
- write('Content
- write('Date Posted
- write('Category
- write('Spam
- write('
-
- $ids = $page->findIDs('BlogPosts');
- for ($i = 0; $i < count($ids); $i++)
- {
- $post = $page->getBlogPost($ids[$i]);
- write('
- write('' . $post->ID . '
- if ($post->parent == -1)
- {
- write('No Parent
- }
- else
- {
- write('' . $post->parent->title . '
- }
- write('' . $post->author->name . '
- write('' . $post->title . '
- write('' . $post->content . '
- write('' . date('j/m/Y H:i', $post->datePosted) . '
- write('' . $post->category . '
- write('' . $post->spam . '
- write('
- }
-
- write('
');
-}
-else
-{
- drawError('You do not have permission to access this page.');
-}
-
-$page->drawFooter();
-
-?>
-
+
+
+require '../_taios.php';
+
+$page = new Taios_Page('Manage All Blog Posts', '../');
+$page->drawHeader();
+$page->drawMiddle();
+
+$page->checkLoggedIn();
+
+if ($page->isUserAdmin($page->getLoggedInUser()))
+{
+ write('

Use this to manage all the blog posts on the Tim32 Website.


');
+
+ write('');');');');');');');');');');');');');');');');');');');');');');
+ write('
+ write('ID
+ write('Parent
+ write('Author
+ write('Title
+ write('Content
+ write('Date Posted
+ write('Category
+ write('Spam
+ write('
+
+ $ids = $page->findIDs('BlogPosts');
+ for ($i = 0; $i < count($ids); $i++)
+ {
+ $post = $page->getBlogPost($ids[$i]);
+ write('
+ write('' . $post->ID . '
+ if ($post->parent == -1)
+ {
+ write('No Parent
+ }
+ else
+ {
+ write('' . $post->parent->title . '
+ }
+ write('' . $post->author->name . '
+ write('' . $post->title . '
+ write('' . $post->content . '
+ write('' . date('j/m/Y H:i', $post->datePosted) . '
+ write('' . $post->category . '
+ write('' . $post->spam . '
+ write('
+ }
+
+ write('
');
+}
+else
+{
+ drawError('You do not have permission to access this page.');
+}
+
+$page->drawFooter();
+
+?>
+
Index: admin/all-accounts.php
===================================================================
--- admin/all-accounts.php (revision 135)
+++ admin/all-accounts.php (revision 171)
@@ -1,51 +1,51 @@
-
-
-require '../_taios.php';
-
-$page = new Taios_Page('Manage All Accounts', '../');
-$page->drawHeader();
-$page->drawMiddle();
-
-$page->checkLoggedIn();
-
-if ($page->isUserAdmin($page->getLoggedInUser()))
-{
- write('

Use this to manage all the accounts on the Tim32 Website.


');
-
- write('');');');');');');');');');');');');');');');');');');');
- write('
- write('ID
- write('AccessID
- write('Username
- write('Password
- write('Name
- write('Email Address
- write('Challenge ID
- write('
-
- $ids = $page->findIDs('Users');
- for ($i = 0; $i < count($ids); $i++)
- {
- $user = $page->getUserByID($ids[$i]);
- write('
- write('' . $user->ID . '
- write('' . $user->accessID . '
- write('' . $user->username . '
- write('' . $user->password . '
- write('' . $user->name . '
- write('' . $user->emailAddress . '
- write('' . $user->challengeID . '
- write('
- }
-
- write('
');
-}
-else
-{
- drawError('You do not have permission to access this page.');
-}
-
-$page->drawFooter();
-
-?>
-
+
+
+require '../_taios.php';
+
+$page = new Taios_Page('Manage All Accounts', '../');
+$page->drawHeader();
+$page->drawMiddle();
+
+$page->checkLoggedIn();
+
+if ($page->isUserAdmin($page->getLoggedInUser()))
+{
+ write('

Use this to manage all the accounts on the Tim32 Website.


');
+
+ write('');');');');');');');');');');');');');');');');');');');
+ write('
+ write('ID
+ write('AccessID
+ write('Username
+ write('Password
+ write('Name
+ write('Email Address
+ write('Challenge ID
+ write('
+
+ $ids = $page->findIDs('Users');
+ for ($i = 0; $i < count($ids); $i++)
+ {
+ $user = $page->getUserByID($ids[$i]);
+ write('
+ write('' . $user->ID . '
+ write('' . $user->accessID . '
+ write('' . $user->username . '
+ write('' . $user->password . '
+ write('' . $user->name . '
+ write('' . $user->emailAddress . '
+ write('' . $user->challengeID . '
+ write('
+ }
+
+ write('
');
+}
+else
+{
+ drawError('You do not have permission to access this page.');
+}
+
+$page->drawFooter();
+
+?>
+
Index: admin/index.php
===================================================================
--- admin/index.php (revision 135)
+++ admin/index.php (revision 171)
@@ -1,27 +1,27 @@
-
-
-require '../_taios.php';
-
-$page = new Taios_Page('Administration', '../');
-$page->drawHeader();
-$page->drawMiddle();
-
-$page->checkLoggedIn();
-$user = $page->getLoggedInUser();
-
-write('

Manage Account

');
-
-if ($page->isUserAdmin($user))
-{
- write('

Manage All Accounts

');
- write('

Manage All Blog Posts

');
- write('

Manage All Projects

');
- write('

Manage All Forum Categories

');
- write('

Manage All Forum Topics

');
- write('

Manage All Forum Posts

');
-}
-
-$page->drawFooter();
-
-?>
-
+
+
+require '../_taios.php';
+
+$page = new Taios_Page('Administration', '../');
+$page->drawHeader();
+$page->drawMiddle();
+
+$page->checkLoggedIn();
+$user = $page->getLoggedInUser();
+
+write('

Manage Account

');
+
+if ($page->isUserAdmin($user))
+{
+ write('

Manage All Accounts

');
+ write('

Manage All Blog Posts

');
+ write('

Manage All Projects

');
+ write('

Manage All Forum Categories

');
+ write('

Manage All Forum Topics

');
+ write('

Manage All Forum Posts

');
+}
+
+$page->drawFooter();
+
+?>
+
Index: projects/index.php
===================================================================
--- projects/index.php (revision 135)
+++ projects/index.php (revision 171)
@@ -1,14 +1,14 @@
-
-
-require '../_taios.php';
-
-$page = new Taios_Page('Projects', '../');
-$page->drawHeader();
-$page->drawMiddle();
-
-write('

This page is currently under construction.

');
-
-$page->drawFooter();
-
-?>
-
+
+
+require '../_taios.php';
+
+$page = new Taios_Page('Projects', '../');
+$page->drawHeader();
+$page->drawMiddle();
+
+write('

This page is currently under construction.

');
+
+$page->drawFooter();
+
+?>
+
Index: 404.php
===================================================================
--- 404.php (nonexistent)
+++ 404.php (revision 171)
@@ -0,0 +1,28 @@
+
+
+require '_taios.php';
+
+$page = new Taios_Page('404');
+$page->drawHeader();
+write('

Pages

');
+$page->drawMenuItem('Biggles', '/~biggles/');
+$page->drawMenuItem('Freddie', '/~freddie/');
+$page->drawMenuItem('Muzer', '/~muzer/');
+$page->drawMenuItem('Sh4rk', '/~szabot/');
+$page->drawMenuItem('Tom', '/~tom/');
+$page->drawMiddle();
+
+?>
+
+

404 - Page not found

+

The page you requested could not be found.

+
+

Useful Links

+
+
+
+$page->drawMenuItem('Tim32 Homepage', 'index.php');
+
+$page->drawFooter();
+
+?>
Index: index.php
===================================================================
--- index.php (revision 135)
+++ index.php (revision 171)
@@ -1,39 +1,39 @@
-
-
-require '_taios.php';
-
-$page = new Taios_Page('Home');
-$page->drawHeader();
-write('

Pages

');
-$page->drawMenuItem('Biggles', '/~biggles/');
-$page->drawMenuItem('Freddie', '/~freddie/');
-$page->drawMenuItem('Muzer', '/~muzer/');
-$page->drawMenuItem('Sh4rk', '/~szabot/');
-$page->drawMenuItem('Tom', '/~tom/');
-$page->drawMiddle();
-
-?>
-
-

Welcome to Tim32!

-

Tim32 is a 10 year-old laptop running Ubuntu Server Edition 10.04.

-
-
-

Latest Blog Posts

-
-
-
-$ids = $page->findIDs('BlogPosts', 'WHERE ParentID = -1 AND ORDER BY DatePosted DESC');
-for ($i = 0; $i < 5 && $i < count($ids); $i++)
-{
- $id = $ids[$i];
- $post = $page->getBlogPost($id);
-
- write('

' . $post->title. '

');
- write('
Posted On ' . date('l j F Y', $post->datePosted) . ' by ' . $post->user->name . ' (' . $post->user->username . ')
');
- write('

' . $post->content . '

');
- write('
');
-}
-
-$page->drawFooter();
-
-?>
+
+
+require '_taios.php';
+
+$page = new Taios_Page('Home');
+$page->drawHeader();
+write('

Pages

');
+$page->drawMenuItem('Biggles', '/~biggles/');
+$page->drawMenuItem('Freddie', '/~freddie/');
+$page->drawMenuItem('Muzer', '/~muzer/');
+$page->drawMenuItem('Sh4rk', '/~szabot/');
+$page->drawMenuItem('Tom', '/~tom/');
+$page->drawMiddle();
+
+?>
+
+

Welcome to Tim32!

+

Tim32 is a 10 year-old laptop running Ubuntu Server Edition 10.04.

+
+
+

Latest Blog Posts

+
+
+
+$ids = $page->findIDs('BlogPosts', 'WHERE ParentID = -1 ORDER BY DatePosted DESC');
+for ($i = 0; $i < 5 && $i < count($ids); $i++)
+{
+ $id = $ids[$i];
+ $post = $page->getBlogPost($id);
+
+ write('

' . $post->title. '

');
+ write('
Posted On ' . date('l j F Y', $post->datePosted) . ' by ' . $post->user->name . ' (' . $post->user->username . ')
');
+ write('

' . $post->content . '

');
+ write('
');
+}
+
+$page->drawFooter();
+
+?>
Index: login-do.php
===================================================================
--- login-do.php (revision 135)
+++ login-do.php (revision 171)
@@ -1,37 +1,37 @@
-
-
-require '_taios.php';
-
-$page = new Taios_Page('Login');
-
-$username = $_POST['username'];
-$password = $_POST['password'];
-$remember = $_POST['remember'] == 'yes';
-
-if (empty($username))
-{
- $page->redirect('login.php?error=No Username Specified');
-}
-if (empty($password))
-{
- $page->redirect('login.php?error=No Password Specified');
-}
-
-$user = $page->getUserByUsername($username);
-if (!$user || $user->password != sha1($password))
-{
- $page->redirect('login.php?error=Incorrect Username or Password');
-}
-
-$expires = -1;
-
-if ($remember)
-{
- $expires = time() + 60 * 60 * 24 * 30;
-}
-
-setcookie('Tim32_Login', $user->username . '|~|' . $user->password, $expires, '/');
-
-$page->redirect('index.php');
-
-?>
+
+
+require '_taios.php';
+
+$page = new Taios_Page('Login');
+
+$username = $_POST['username'];
+$password = $_POST['password'];
+$remember = $_POST['remember'] == 'yes';
+
+if (empty($username))
+{
+ $page->redirect('login.php?error=No Username Specified');
+}
+if (empty($password))
+{
+ $page->redirect('login.php?error=No Password Specified');
+}
+
+$user = $page->getUserByUsername($username);
+if (!$user || $user->password != sha1($password))
+{
+ $page->redirect('login.php?error=Incorrect Username or Password');
+}
+
+$expires = -1;
+
+if ($remember)
+{
+ $expires = time() + 60 * 60 * 24 * 30;
+}
+
+setcookie('Tim32_Login', $user->username . '|~|' . $user->password, $expires, '/');
+
+$page->redirect('index.php');
+
+?>
Index: login.php
===================================================================
--- login.php (revision 135)
+++ login.php (revision 171)
@@ -1,48 +1,48 @@
-
-
-require '_taios.php';
-
-$page = new Taios_Page('Login');
-$page->drawHeader();
-$page->drawMiddle();
-
-?>
-
-

Here you can login to Tim32 using your Tim32 account.

-
-
-
-
-if (isset($_GET['error']))
-{
- $page->drawError($_GET['error'], false);
-}
-
-?>
-
-
-
-
-Username:
-
-
-
-Password:
-
-
-
-Remember Me:
-
-
-
-
-
-
-
-
-
-
-
-$page->drawFooter();
-
-?>
+
+
+require '_taios.php';
+
+$page = new Taios_Page('Login');
+$page->drawHeader();
+$page->drawMiddle();
+
+?>
+
+

Here you can login to Tim32 using your Tim32 account.

+
+
+
+
+if (isset($_GET['error']))
+{
+ $page->drawError($_GET['error'], false);
+}
+
+?>
+
+
+
+
+Username:
+
+
+
+Password:
+
+
+
+Remember Me:
+
+
+
+
+
+
+
+
+
+
+
+$page->drawFooter();
+
+?>
Index: logout-do.php
===================================================================
--- logout-do.php (revision 135)
+++ logout-do.php (revision 171)
@@ -1,6 +1,6 @@
-
-
-setcookie('Tim32_Login', '', -1, '/');
-header('Location: index.php');
-
-?>
+
+
+setcookie('Tim32_Login', '', -1, '/');
+header('Location: index.php');
+
+?>
Index: wiki/index.php
===================================================================
--- wiki/index.php (revision 135)
+++ wiki/index.php (revision 171)
@@ -1,14 +1,14 @@
-
-
-require '../_taios.php';
-
-$page = new Taios_Page('Wiki', '../');
-$page->drawHeader();
-$page->drawMiddle();
-
-write('

This page is currently under construction.

');
-
-$page->drawFooter();
-
-?>
-
+
+
+require '../_taios.php';
+
+$page = new Taios_Page('Wiki', '../');
+$page->drawHeader();
+$page->drawMiddle();
+
+write('

This page is currently under construction.

');
+
+$page->drawFooter();
+
+?>
+
Index: _taios.php
===================================================================
--- _taios.php (revision 135)
+++ _taios.php (revision 171)
@@ -1,392 +1,432 @@
-
-
-require '_config.php';
-
-class Taios_Page
-{
- function __construct($title, $url = "")
- {
- $this->title = $title;
- $this->url = $url;
-
- $this->drawnHeader = false;
- $this->drawnMiddle = false;
- $this->drawnFooter = false;
-
- $this->db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD);
- if (!$this->db)
- {
- $this->drawError('Failed to connect to database: ' . mysql_error());
- }
-
- if (!mysql_select_db('Tim32'))
- {
- $this->drawError('Failed to select database: ' . mysql_error());
- }
- }
-
- function drawHeader()
- {
- if (!$this->drawnHeader)
- {
- write('');
- write('');
- write('');
- write('');
- write('Tim32 · ' . $this->title . '');
- write('');
- write('');
- write('');
- write('
');
- write('
');
- write('

Tim32

');
- write('');
- write('
');
- $this->drawMenuItem('Home', 'index.php');
- $this->drawMenuItem('Blog', 'blog/');
- $this->drawMenuItem('Projects', 'projects/');
- $this->drawMenuItem('Forums', 'forums/');
- $this->drawMenuItem('Wiki', 'wiki/');
- $this->drawMenuItem('Photos', 'photos/');
- write('
');
- if ($this->isLoggedIn())
- {
- $this->drawMenuItem('Administration', 'admin/');
- $this->drawMenuItem('Logout', 'logout-do.php');
- }
- else
- {
- $this->drawMenuItem('Login', 'login.php');
- $this->drawMenuItem('Register', 'register.php');
- }
- write('
');
-
- $this->drawnHeader = true;
- }
- }
-
- function drawMenuItem($t, $u)
- {
- write('

' . $t . '

');
- }
-
- function drawMiddle()
- {
- if (!$this->drawnMiddle)
- {
- write('
');
- write('');
- write('');
- write('
');
- write('

' . $this->title . '

');
-
- $this->drawnMiddle = true;
- }
- }
-
- function drawFooter()
- {
- if (!$this->drawnFooter)
- {
- write('');
- write('');
- write('');
-
- $this->drawnFooter = true;
- }
-
- die();
- }
-
- function drawError($text, $die = true)
- {
- $this->drawHeader();
- $this->drawMiddle();
-
- write('

Error: ' . $text . '

');
-
- if ($die)
- {
- $this->drawFooter();
- die();
- }
- }
-
- function drawBlogPostTree($id, $first = false)
- {
- $post = $this->getBlogPost($id);
- if ($first)
- write('

' . $post->title. ' ^

');
- else
- write('

' . $post->title. '

');
- write('
Posted On ' . date('l j F Y', $post->datePosted) . ' by ' . $post->user->name . ' (' . $post->user->username . ')
');
- write('

' . $post->content . '

');
- write('
');
- if ($this->isUserNormal($this->getLoggedInUser()))
- {
- echo '

Add Comment';

- if ($this->isUserAdmin($this->getLoggedInUser()) || $this->getLoggedInUser() == $post->author->ID)
- echo ' · Delete Post';
- write('


');
- }
-
- $ids = $this->findIDs('BlogPosts', 'WHERE ParentID=' . $id);
- for ($i = 0; $i < count($ids); $i++)
- {
- write('
');
- $this->drawBlogPostTree($ids[$i]);
- write('');
- }
- }
-
- function drawBlogCategoriesMenu()
- {
- $cats = array();
-
- $ids = $this->findIDs('BlogPosts', 'WHERE ParentID = -1');
- for ($i = 0; $i < count($ids); $i++)
- {
- $cat = $this->getBlogPost($ids[$i])->category;
- if (!in_array($cat, $cats))
- {
- array_push($cats, $cat);
- }
- }
-
- write('

Categories

');
- for ($i = 0; $i < count($cats); $i++)
- {
- $this->drawMenuItem($cats[$i], 'blog/index.php?cat=' . $cats[$i]);
- }
- }
-
- function redirect($u)
- {
- header('Location: ' . $u);
- die();
- }
-
- function isLoggedIn()
- {
- $cookie = $_COOKIE['Tim32_Login'];
- if (!empty($cookie))
- {
- $clist = explode('|~|', $cookie);
- $user = $this->getUserByUsername($clist[0]);
- if ($user)
- {
- if ($user->password == $clist[1])
- {
- return true;
- }
- }
- }
-
- return false;
- }
-
- function isUserAdmin()
- {
- if ($this->isLoggedIn())
- {
- if ($this->getLoggedInUser()->accessID <= 0)
- {
- return true;
- }
- }
-
- return false;
- }
-
- function isUserGM()
- {
- if ($this->isLoggedIn())
- {
- if ($this->getLoggedInUser()->accessID <= 1)
- {
- return true;
- }
- }
-
- return false;
- }
-
- function isUserNormal()
- {
- if ($this->isLoggedIn())
- {
- if ($this->getLoggedInUser()->accessID <= 2)
- {
- return true;
- }
- }
-
- return false;
- }
-
- function checkLoggedIn()
- {
- if (!$this->isLoggedIn())
- {
- $this->drawError('You need to be logged in.');
- }
- }
-
- function query($query)
- {
- $result = mysql_query($query);
- if (!$result)
- {
- $this->drawError('MySQL Error: ' . mysql_error());
- }
-
- return $result;
- }
-
- function findIDs($table, $query = '')
- {
- $array = array();
-
- $result = $this->query('SELECT ID FROM ' . $table . ' ' . $query);
- while ($row = mysql_fetch_array($result))
- {
- array_push($array, $row['ID']);
- }
-
- return $array;
- }
-
- function getUserByID($id)
- {
- $result = $this->query('SELECT * FROM Users WHERE ID = ' . $id);
- while ($row = mysql_fetch_array($result))
- {
- $user = new User;
- $user->ID = $row['ID'];
- $user->accessID = $row['AccessID'];
- $user->username = $row['Username'];
- $user->password = $row['Password'];
- $user->emailAddress = $row['EmailAddress'];
- $user->name = $row['Name'];
- $user->challengeID = $row['ChallengeID'];
-
- return $user;
- }
-
- return false;
- }
-
- function getUserByUsername($username)
- {
- $result = $this->query('SELECT * FROM Users WHERE Username = "' . $username . '"');
- while ($row = mysql_fetch_array($result))
- {
- return $this->getUserByID($row['ID']);
- }
-
- return false;
- }
-
- function getLoggedInUser()
- {
- if ($this->isLoggedIn())
- {
- $clist = explode('|~|', $_COOKIE['Tim32_Login']);
- return $this->getUserByUsername($clist[0]);
- }
-
- return false;
- }
-
- function getBlogPost($id)
- {
- $result = $this->query('SELECT * FROM BlogPosts WHERE ID = ' . $id);
- while ($row = mysql_fetch_array($result))
- {
- $post = new BlogPost;
- $post->ID = $row['ID'];
- if ($row['ParentID'] == -1)
- {
- $post->parent = -1;
- }
- else
- {
- $post->parent = $this->getBlogPost($row['ParentID']);
- }
- $post->author = $this->getUserByID($row['AuthorID']);
- $post->user = $this->getUserByID($row['AuthorID']); // For some older pages
- $post->title = $row['Title'];
- $post->content = $row['Content'];
- $post->datePosted = strtotime($row['DatePosted']);
- $post->category = $row['Category'];
- $post->spam = $row['Spam'];
-
- return $post;
- }
-
- $this->drawError('Cannot find blog post, #' . $id);
- }
-
- function delBlogPost($id)
- {
- $ids = $this->findIDs('BlogPosts', 'WHERE ParentID=' . $id);
- for ($i = 0; $i < count($ids); $i++)
- $this->delBlogPost($ids[$i]);
-
- $this->query('delete from BlogPosts where ID=' . $id);
- }
-
- function getGetID()
- {
- $id = $_GET['id'];
- if (empty($id))
- {
- $id = 1;
- }
-
- return $id;
- }
-
- function getPostID()
- {
- $id = $_POST['id'];
- if (empty($id))
- {
- $id = 1;
- }
-
- return $id;
- }
-
-}
-
-class User
-{
- public $ID;
- public $accessID;
- public $username;
- public $password;
- public $emailAddress;
- public $name;
- public $challengeID;
-}
-
-class BlogPost
-{
- public $ID;
- public $parent;
- public $author;
- public $title;
- public $content;
- public $datePosted;
- public $category;
- public $spam;
-}
-
-function write($str)
-{
- echo $str;
- echo "\n";
-}
-
-?>
+
+
+require '_config.php';
+
+class Taios_Page
+{
+ function __construct($title, $url = "")
+ {
+ $this->title = $title;
+ $this->url = $url;
+
+ $this->drawnHeader = false;
+ $this->drawnMiddle = false;
+ $this->drawnFooter = false;
+
+ $this->db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD);
+ if (!$this->db)
+ {
+ $this->drawError('Failed to connect to database: ' . mysql_error());
+ }
+
+ if (!mysql_select_db('Tim32'))
+ {
+ $this->drawError('Failed to select database: ' . mysql_error());
+ }
+ }
+
+ function drawHeader()
+ {
+ if (!$this->drawnHeader)
+ {
+ write('');
+ write('');
+ write('');
+ write('');
+ write('Tim32 · ' . $this->title . '');
+ write('');
+ write('');
+ write('');
+ write('
');
+ write('
');
+ write('

Tim32

');
+ write('');
+ write('
');
+ $this->drawMenuItem('Home', 'index.php');
+ $this->drawMenuItem('Blog', 'blog/');
+ $this->drawMenuItem('Projects', 'projects/');
+ $this->drawMenuItem('Forums', 'forums/');
+ $this->drawMenuItem('Wiki', 'wiki/');
+ $this->drawMenuItem('Photos', 'photos/');
+ write('
');
+ if ($this->isLoggedIn())
+ {
+ $this->drawMenuItem('Administration', 'admin/');
+ $this->drawMenuItem('Logout', 'logout-do.php');
+ }
+ else
+ {
+ $this->drawMenuItem('Login', 'login.php');
+ $this->drawMenuItem('Register', 'register.php');
+ }
+ write('
');
+
+ $this->drawnHeader = true;
+ }
+ }
+
+ function drawMenuItem($t, $u)
+ {
+ write('

' . $t . '

');
+ }
+
+ function drawMiddle()
+ {
+ if (!$this->drawnMiddle)
+ {
+ write('
');
+ write('');
+ write('');
+ write('
');
+ write('

' . $this->title . '

');
+
+ $this->drawnMiddle = true;
+ }
+ }
+
+ function drawFooter()
+ {
+ if (!$this->drawnFooter)
+ {
+ write('');
+ write('');
+ write('');
+
+ $this->drawnFooter = true;
+ }
+
+ die();
+ }
+
+ function drawError($text, $die = true)
+ {
+ $this->drawHeader();
+ $this->drawMiddle();
+
+ write('

Error: ' . $text . '

');
+
+ if ($die)
+ {
+ $this->drawFooter();
+ die();
+ }
+ }
+
+ function drawBlogPostTree($id, $first = false)
+ {
+ $post = $this->getBlogPost($id);
+ if ($first)
+ write('

' . $post->title. ' ^

');
+ else
+ write('

' . $post->title. '

');
+ write('
Posted On ' . date('l j F Y', $post->datePosted) . ' by ' . $post->user->name . ' (' . $post->user->username . ')
');
+ write('

' . $post->content . '

');
+ write('
');
+ if ($this->isUserNormal($this->getLoggedInUser()))
+ {
+ echo '

Add Comment';

+ if ($this->isUserAdmin($this->getLoggedInUser()) || $this->getLoggedInUser() == $post->author->ID)
+ echo ' · Delete Post';
+ write('


');
+ }
+
+ $ids = $this->findIDs('BlogPosts', 'WHERE ParentID=' . $id);
+ for ($i = 0; $i < count($ids); $i++)
+ {
+ write('
');
+ $this->drawBlogPostTree($ids[$i]);
+ write('');
+ }
+ }
+
+ function drawBlogCategoriesMenu()
+ {
+ $cats = array();
+
+ $ids = $this->findIDs('BlogPosts', 'WHERE ParentID = -1');
+ for ($i = 0; $i < count($ids); $i++)
+ {
+ $cat = $this->getBlogPost($ids[$i])->category;
+ if (!in_array($cat, $cats))
+ {
+ array_push($cats, $cat);
+ }
+ }
+
+ write('

Categories

');
+ for ($i = 0; $i < count($cats); $i++)
+ {
+ $this->drawMenuItem($cats[$i], 'blog/index.php?cat=' . $cats[$i]);
+ }
+ }
+
+ function replaceBBCode($str)
+ {
+ $newstr = str_replace("\n", '

', $str);

+ $newstr = str_replace(' ', '  ', $newstr);
+ $newstr = str_replace(' :)', ' ', $newstr);
+ $newstr = str_replace(' :p', ' ', $newstr);
+ $newstr = str_replace(' :P', ' ',$newstr);
+ $newstr = str_replace(' :|', ' ',$newstr);
+ $newstr = str_replace(' :D', ' ',$newstr);
+ $newstr = str_replace(' =D', ' ',$newstr);
+ $newstr = str_replace(' :(', ' ',$newstr);
+ $newstr = str_replace(' :0', ' ',$newstr);
+ $newstr = str_replace(' :o', ' ',$newstr);
+ $newstr = str_replace(' :O', ' ',$newstr);
+ $newstr = str_replace(' :/', ' ',$newstr);
+ $newstr = str_replace(' ;)', ' ',$newstr);
+
+ $bbcode = array(
+ '/\[b\](.+?)\[\/b\]/is',
+ '/\[i\](.+?)\[\/i\]/is',
+ '/\[u\](.+?)\[\/u\]/is',
+ '/\[url\](.+?)\[\/url\]/is',
+ '/\[code\](.+?)\[\/code\]/is',
+ '/\[img\](.+?)\[\/img\]/is'
+ );
+
+ $html = array(
+ '$1',
+ '$1',
+ '$1',
+ '$1',
+ '
$1
',
+ ''
+ );
+
+ $newstr = preg_replace($bbcode, $html, $newstr);
+
+ return $newstr;
+ }
+
+ function redirect($u)
+ {
+ header('Location: ' . $u);
+ die();
+ }
+
+ function isLoggedIn()
+ {
+ $cookie = $_COOKIE['Tim32_Login'];
+ if (!empty($cookie))
+ {
+ $clist = explode('|~|', $cookie);
+ $user = $this->getUserByUsername($clist[0]);
+ if ($user)
+ {
+ if ($user->password == $clist[1])
+ {
+ return true;
+ }
+ }
+ }
+
+ return false;
+ }
+
+ function isUserAdmin()
+ {
+ if ($this->isLoggedIn())
+ {
+ if ($this->getLoggedInUser()->accessID <= 0)
+ {
+ return true;
+ }
+ }
+
+ return false;
+ }
+
+ function isUserGM()
+ {
+ if ($this->isLoggedIn())
+ {
+ if ($this->getLoggedInUser()->accessID <= 1)
+ {
+ return true;
+ }
+ }
+
+ return false;
+ }
+
+ function isUserNormal()
+ {
+ if ($this->isLoggedIn())
+ {
+ if ($this->getLoggedInUser()->accessID <= 2)
+ {
+ return true;
+ }
+ }
+
+ return false;
+ }
+
+ function checkLoggedIn()
+ {
+ if (!$this->isLoggedIn())
+ {
+ $this->drawError('You need to be logged in.');
+ }
+ }
+
+ function query($query)
+ {
+ $result = mysql_query($query);
+ if (!$result)
+ {
+ $this->drawError('MySQL Error: ' . mysql_error());
+ }
+
+ return $result;
+ }
+
+ function findIDs($table, $query = '')
+ {
+ $array = array();
+
+ $result = $this->query('SELECT ID FROM ' . $table . ' ' . $query);
+ while ($row = mysql_fetch_array($result))
+ {
+ array_push($array, $row['ID']);
+ }
+
+ return $array;
+ }
+
+ function getUserByID($id)
+ {
+ $result = $this->query('SELECT * FROM Users WHERE ID = ' . $id);
+ while ($row = mysql_fetch_array($result))
+ {
+ $user = new User;
+ $user->ID = $row['ID'];
+ $user->accessID = $row['AccessID'];
+ $user->username = $row['Username'];
+ $user->password = $row['Password'];
+ $user->emailAddress = $row['EmailAddress'];
+ $user->name = $row['Name'];
+ $user->challengeID = $row['ChallengeID'];
+
+ return $user;
+ }
+
+ return false;
+ }
+
+ function getUserByUsername($username)
+ {
+ $result = $this->query('SELECT * FROM Users WHERE Username = "' . $username . '"');
+ while ($row = mysql_fetch_array($result))
+ {
+ return $this->getUserByID($row['ID']);
+ }
+
+ return false;
+ }
+
+ function getLoggedInUser()
+ {
+ if ($this->isLoggedIn())
+ {
+ $clist = explode('|~|', $_COOKIE['Tim32_Login']);
+ return $this->getUserByUsername($clist[0]);
+ }
+
+ return false;
+ }
+
+ function getBlogPost($id)
+ {
+ $result = $this->query('SELECT * FROM BlogPosts WHERE ID = ' . $id);
+ while ($row = mysql_fetch_array($result))
+ {
+ $post = new BlogPost;
+ $post->ID = $row['ID'];
+ if ($row['ParentID'] == -1)
+ {
+ $post->parent = -1;
+ }
+ else
+ {
+ $post->parent = $this->getBlogPost($row['ParentID']);
+ }
+ $post->author = $this->getUserByID($row['AuthorID']);
+ $post->user = $this->getUserByID($row['AuthorID']); // For some older pages
+ $post->title = $row['Title'];
+ $post->content = $this->replaceBBCode($row['Content']);
+ $post->datePosted = strtotime($row['DatePosted']);
+ $post->category = $row['Category'];
+ $post->spam = $row['Spam'];
+
+ return $post;
+ }
+
+ $this->drawError('Cannot find blog post, #' . $id);
+ }
+
+ function delBlogPost($id)
+ {
+ $ids = $this->findIDs('BlogPosts', 'WHERE ParentID=' . $id);
+ for ($i = 0; $i < count($ids); $i++)
+ $this->delBlogPost($ids[$i]);
+
+ $this->query('delete from BlogPosts where ID=' . $id);
+ }
+
+ function getGetID()
+ {
+ $id = $_GET['id'];
+ if (empty($id))
+ {
+ $id = 1;
+ }
+
+ return $id;
+ }
+
+ function getPostID()
+ {
+ $id = $_POST['id'];
+ if (empty($id))
+ {
+ $id = 1;
+ }
+
+ return $id;
+ }
+
+}
+
+class User
+{
+ public $ID;
+ public $accessID;
+ public $username;
+ public $password;
+ public $emailAddress;
+ public $name;
+ public $challengeID;
+}
+
+class BlogPost
+{
+ public $ID;
+ public $parent;
+ public $author;
+ public $title;
+ public $content;
+ public $datePosted;
+ public $category;
+ public $spam;
+}
+
+function write($str)
+{
+ echo $str;
+ echo "\n";
+}
+
+?>
Index: install.sql
===================================================================
--- install.sql (revision 135)
+++ install.sql (revision 171)
@@ -1,75 +1,75 @@
-DROP DATABASE Tim32;
-CREATE DATABASE Tim32;
-
-USE Tim32;
-
-CREATE TABLE Users
-(
- ID INT NOT NULL AUTO_INCREMENT,
- AccessID INT,
- Username TEXT,
- Password TEXT,
- EmailAddress TEXT,
- Name TEXT,
- ChallengeID INT,
- PRIMARY KEY(ID)
-);
-
-CREATE TABLE BlogPosts
-(
- ID INT NOT NUll AUTO_INCREMENT,
- ParentID INT,
- AuthorID INT,
- Title TEXT,
- Content TEXT,
- DatePosted DATETIME,
- Category TEXT,
- Spam BOOLEAN,
- PRIMARY KEY(ID)
-);
-
-CREATE TABLE Projects
-(
- ID INT NOT NUll AUTO_INCREMENT,
- AuthorID INT,
- Title TEXT,
- Description TEXT,
- LogoURL TEXT,
- WebsiteURL TEXT,
- LatestVersion TEXT,
- PRIMARY KEY(ID)
-);
-
-CREATE TABLE ForumCategories
-(
- ID INT NOT NUll AUTO_INCREMENT,
- ParentID INT,
- Title TEXT,
- Description TEXT,
- PRIMARY KEY(ID)
-);
-
-CREATE TABLE ForumTopics
-(
- ID INT NOT NUll AUTO_INCREMENT,
- AuthorID INT,
- CategoryID INT,
- Title TEXT,
- DatePosted DATETIME,
- PRIMARY KEY(ID)
-);
-
-CREATE TABLE ForumPosts
-(
- ID INT NOT NUll AUTO_INCREMENT,
- AuthorID INT,
- TopicID INT,
- Title TEXT,
- Content TEXT,
- DatePosted DATETIME,
- Spam BOOLEAN,
- PRIMARY KEY(ID)
-);
-
-INSERT INTO Users VALUES (1, 0, "admin", SHA1("password"), "admins@tim32.org", "Tim32 Admin", 0);
-INSERT INTO BlogPosts VALUES(1, -1, 1, "Welcome to Tim32!", "Welcome to the new Tim32 website! It has had a complete design re-think to make it simpler and easier to use!", NOW(), "Tim32", FALSE);
+DROP DATABASE Tim32;
+CREATE DATABASE Tim32;
+
+USE Tim32;
+
+CREATE TABLE Users
+(
+ ID INT NOT NULL AUTO_INCREMENT,
+ AccessID INT,
+ Username TEXT,
+ Password TEXT,
+ EmailAddress TEXT,
+ Name TEXT,
+ ChallengeID INT,
+ PRIMARY KEY(ID)
+);
+
+CREATE TABLE BlogPosts
+(
+ ID INT NOT NUll AUTO_INCREMENT,
+ ParentID INT,
+ AuthorID INT,
+ Title TEXT,
+ Content TEXT,
+ DatePosted DATETIME,
+ Category TEXT,
+ Spam BOOLEAN,
+ PRIMARY KEY(ID)
+);
+
+CREATE TABLE Projects
+(
+ ID INT NOT NUll AUTO_INCREMENT,
+ AuthorID INT,
+ Title TEXT,
+ Description TEXT,
+ LogoURL TEXT,
+ WebsiteURL TEXT,
+ LatestVersion TEXT,
+ PRIMARY KEY(ID)
+);
+
+CREATE TABLE ForumCategories
+(
+ ID INT NOT NUll AUTO_INCREMENT,
+ ParentID INT,
+ Title TEXT,
+ Description TEXT,
+ PRIMARY KEY(ID)
+);
+
+CREATE TABLE ForumTopics
+(
+ ID INT NOT NUll AUTO_INCREMENT,
+ AuthorID INT,
+ CategoryID INT,
+ Title TEXT,
+ DatePosted DATETIME,
+ PRIMARY KEY(ID)
+);
+
+CREATE TABLE ForumPosts
+(
+ ID INT NOT NUll AUTO_INCREMENT,
+ AuthorID INT,
+ TopicID INT,
+ Title TEXT,
+ Content TEXT,
+ DatePosted DATETIME,
+ Spam BOOLEAN,
+ PRIMARY KEY(ID)
+);
+
+INSERT INTO Users VALUES (1, 0, "admin", SHA1("password"), "admins@tim32.org", "Tim32 Admin", 0);
+INSERT INTO BlogPosts VALUES(1, -1, 1, "Welcome to Tim32!", "Welcome to the new Tim32 website! It has had a complete design re-think to make it simpler and easier to use!", NOW(), "Tim32", FALSE);
Index: register-do.php
===================================================================
--- register-do.php (revision 135)
+++ register-do.php (revision 171)
@@ -1,34 +1,34 @@
-
-
-require '_taios.php';
-
-$page = new Taios_Page('Login');
-
-$username = $_POST['username'];
-$password = $_POST['password'];
-$password2 = $_POST['password2'];
-$email = $_POST['email'];
-$name = $_POST['name'];
-
-if (empty($username))
-{
- $page->redirect('register.php?error=No Username Specified');
-}
-if (empty($password))
-{
- $page->redirect('register.php?error=No Password Specified');
-}
-if (empty($password2))
-{
- $page->redirect('register.php?error=No Repeat Password Specified');
-}
-if ($password != $password2)
-{
- $page->redirect('register.php?error=Passwords do not match');
-}
-
-$page->query('INSERT INTO Users (AccessID, Username, Password, EmailAddress, Name, ChallengeID) VALUES (2, "' . $username . '", "' . sha1($password) . '", "' . $email . '", "' . $name . '", 0)');
-
-$page->redirect('login.php');
-
-?>
+
+
+require '_taios.php';
+
+$page = new Taios_Page('Login');
+
+$username = $_POST['username'];
+$password = $_POST['password'];
+$password2 = $_POST['password2'];
+$email = $_POST['email'];
+$name = $_POST['name'];
+
+if (empty($username))
+{
+ $page->redirect('register.php?error=No Username Specified');
+}
+if (empty($password))
+{
+ $page->redirect('register.php?error=No Password Specified');
+}
+if (empty($password2))
+{
+ $page->redirect('register.php?error=No Repeat Password Specified');
+}
+if ($password != $password2)
+{
+ $page->redirect('register.php?error=Passwords do not match');
+}
+
+$page->query('INSERT INTO Users (AccessID, Username, Password, EmailAddress, Name, ChallengeID) VALUES (2, "' . $username . '", "' . sha1($password) . '", "' . $email . '", "' . $name . '", 0)');
+
+$page->redirect('login.php');
+
+?>
Index: register.php
===================================================================
--- register.php (revision 135)
+++ register.php (revision 171)
@@ -1,56 +1,56 @@
-
-
-require '_taios.php';
-
-$page = new Taios_Page('Register');
-$page->drawHeader();
-$page->drawMiddle();
-
-?>
-
-

Here you can create an account with Tim32.

-
-
-
-
-if (isset($_GET['error']))
-{
- $page->drawError($_GET['error'], false);
-}
-
-?>
-
-
-: :
-
-Username:
-
-
-
-Password:
-
-
-
-Repeat Password:
-
-
-
-Email Address
-
-
-
-Name
-
-
-
-
-
-
-
-
-
-
-
-$page->drawFooter();
-
-?>
+
+
+require '_taios.php';
+
+$page = new Taios_Page('Register');
+$page->drawHeader();
+$page->drawMiddle();
+
+?>
+
+

Here you can create an account with Tim32.

+
+
+
+
+if (isset($_GET['error']))
+{
+ $page->drawError($_GET['error'], false);
+}
+
+?>
+
+
+: :
+
+Username:
+
+
+
+Password:
+
+
+
+Repeat Password:
+
+
+
+Email Address
+
+
+
+Name
+
+
+
+
+
+
+
+
+
+
+
+$page->drawFooter();
+
+?>
Index: styles.css
===================================================================
--- styles.css (revision 135)
+++ styles.css (revision 171)
@@ -1,124 +1,140 @@
-body {
- background-color: #FFFFFF;
- color: #000000;
-
- font-family: Droid Sans, Tahoma, sans-serif;
- font-size: 11pt;
-}
-
-h1 {
- font-size: 28pt;
- margin: 6px;
- margin-top: 0px;
- color: #000089;
- border-bottom: 1px solid #000000;
-}
-
-h2 {
- font-size: 20pt;
- margin: 6px;
- margin-left: 8px;
- color: #00004B;
-}
-
-h3 {
- font-size: 16pt;
- margin: 6px;
- margin-left: 10px;
- color: #000055;
-}
-
-h4 {
- font-size: 12pt;
- margin: 6px;
- margin-left: 12px;
- color: #00005F;
-}
-
-h5 {
- font-size: 10pt;
- margin: 6px;
- margin-left: 14px;
- color: #000069;
-}
-
-p, table, span {
- font-size: 11pt;
- margin: 6px;
- margin-left: 16px;
-}
-
-a {
- text-decoration: none;
- color: #000050;
-}
-
-a:hover {
- text-decoration: underline;
-}
-
-input {
- border: 1px solid #000000;
- color: #000000;
- background-color: #B5D7FF;
-}
-
-table {
- border: 1px solid #222222;
-}
-
-td {
- padding: 3px;
- border: 1px solid #888888;
-}
-
-.sidebar {
- left: 0px;
- top: 0px;
- position: fixed;
- padding: 0px;
- padding-left: 32px;
- border-right: 1px solid #000089;
- background-color: #FFFF73;
- background-image: url('data/sidebar-gradient.png');
- background-repeat: repeat-x;
- background-position: center bottom;
-
-}
-
-.sidebar-header {
- left: 0px;
- width: 140px;
- padding: 6px;
- text-align: right;
-}
-
-.sidebar-menu {
- text-align: right;
- padding: 6px;
-}
-
-.sidebar-menu h3 {
- margin: 6px;
-}
-
-.sidebar-menu p {
- font-size: 12pt;
- margin: 4px;
-}
-
-.content {
- left: 200px;
- top: 0px;
- position: absolute;
- margin-right: 32px;
-}
-
-.bold {
- font-weight: bold;
-}
-
-.indent {
- margin-left: 14px;
- border-left: 1px solid #BBBBBB;
-}
+body {
+ background-color: #FFFFFF;
+ color: #000000;
+
+ font-family: Droid Sans, Tahoma, sans-serif;
+ font-size: 11pt;
+}
+
+h1 {
+ font-size: 28pt;
+ margin: 6px;
+ margin-top: 0px;
+ color: #000089;
+ border-bottom: 1px solid #000000;
+}
+
+h2 {
+ font-size: 20pt;
+ margin: 6px;
+ margin-left: 8px;
+ color: #00004B;
+}
+
+h3 {
+ font-size: 16pt;
+ margin: 6px;
+ margin-left: 10px;
+ color: #000055;
+}
+
+h4 {
+ font-size: 12pt;
+ margin: 6px;
+ margin-left: 12px;
+ color: #00005F;
+}
+
+h5 {
+ font-size: 10pt;
+ margin: 6px;
+ margin-left: 14px;
+ color: #000069;
+}
+
+p, table, span {
+ font-size: 11pt;
+ margin: 6px;
+ margin-left: 16px;
+}
+
+a {
+ text-decoration: none;
+ color: #000050;
+}
+
+a:hover {
+ text-decoration: underline;
+}
+
+input {
+ border: 1px solid #000000;
+ color: #000000;
+ background-color: #B5D7FF;
+}
+
+table {
+ border: 1px solid #222222;
+}
+
+td {
+ padding: 3px;
+ border: 1px solid #888888;
+}
+
+img {
+ border: 2px solid #333333;
+}
+
+.smiley {
+ border: 0px;
+ vertical-align: middle;
+}
+
+.sidebar {
+ left: 0px;
+ top: 0px;
+ position: fixed;
+ padding: 0px;
+ padding-left: 32px;
+ border-right: 1px solid #000089;
+ background-color: #FFFF73;
+ background-image: url('data/sidebar-gradient.png');
+ background-repeat: repeat-x;
+ background-position: center bottom;
+
+}
+
+.sidebar-header {
+ left: 0px;
+ width: 140px;
+ padding: 6px;
+ text-align: right;
+}
+
+.sidebar-menu {
+ text-align: right;
+ padding: 6px;
+}
+
+.sidebar-menu h3 {
+ margin: 6px;
+}
+
+.sidebar-menu p {
+ font-size: 12pt;
+ margin: 4px;
+}
+
+.content {
+ left: 200px;
+ top: 0px;
+ position: absolute;
+ margin-right: 32px;
+}
+
+.bold {
+ font-weight: bold;
+}
+
+.indent {
+ margin-left: 14px;
+ border-left: 1px solid #BBBBBB;
+}
+
+.code {
+ border: 1px solid #333333;
+ background-color: #DDDDDD;
+ font-family: Droid Sans Mono, Monospace, Fixed;
+}
+
Index: forums/index.php
===================================================================
--- forums/index.php (revision 135)
+++ forums/index.php (revision 171)
@@ -1,14 +1,14 @@
-
-
-require '../_taios.php';
-
-$page = new Taios_Page('Forums', '../');
-$page->drawHeader();
-$page->drawMiddle();
-
-write('

This page is currently under construction.

');
-
-$page->drawFooter();
-
-?>
-
+
+
+require '../_taios.php';
+
+$page = new Taios_Page('Forums', '../');
+$page->drawHeader();
+$page->drawMiddle();
+
+write('

This page is currently under construction.

');
+
+$page->drawFooter();
+
+?>
+
Index: photos/index.php
===================================================================
--- photos/index.php (revision 135)
+++ photos/index.php (revision 171)
@@ -1,14 +1,14 @@
-
-
-require '../_taios.php';
-
-$page = new Taios_Page('Photos', '../');
-$page->drawHeader();
-$page->drawMiddle();
-
-write('

This page is currently under construction.

');
-
-$page->drawFooter();
-
-?>
-
+
+
+require '../_taios.php';
+
+$page = new Taios_Page('Photos', '../');
+$page->drawHeader();
+$page->drawMiddle();
+
+write('

This page is currently under construction.

');
+
+$page->drawFooter();
+
+?>
+