| /admin/index.php |
|---|
| 0,0 → 1,26 |
| <?php |
| require '../_taios.php'; |
| $page = new Taios_Page('Administration', '../'); |
| $page->drawHeader(); |
| $page->drawMiddle(); |
| $page->checkLoggedIn(); |
| $user = $page->getLoggedInUser(); |
| write('<h3><a href="account.php?id=' . $user->ID. '">Manage Account</a></h3>'); |
| if ($page->isUserAdmin($user)) |
| { |
| write('<h3><a href="all-accounts.php">Manage All Accounts</a></h3>'); |
| write('<h3><a href="all-blog-posts.php">Manage All Blog Posts</a></h3>'); |
| write('<h3><a href="all-blog-comments.php">Manage All Blog Comments</a></h3>'); |
| write('<h3><a href="all-forum-categories.php">Manage All Forum Categories</a></h3>'); |
| write('<h3><a href="all-forum-topics.php">Manage All Forum Topics</a></h3>'); |
| write('<h3><a href="all-forum-posts.php">Manage All Forum Posts</a></h3>'); |
| } |
| $page->drawFooter(); |
| ?> |
| /install.sql |
|---|
| 26,5 → 26,61 |
| PRIMARY KEY(ID) |
| ); |
| CREATE TABLE BlogComments |
| ( |
| ID INT NOT NUll AUTO_INCREMENT, |
| ParentID INT, |
| AuthorID INT, |
| PostID INT, |
| Title TEXT, |
| Content TEXT, |
| DatePosted DATETIME, |
| 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, "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"); |
| /_taios.php |
|---|
| 51,7 → 51,7 |
| write('<br />'); |
| if ($this->isLoggedIn()) |
| { |
| $this->drawMenuItem('Manage Account', 'admim/?id=' . $this->getLoggedInUser()->ID); |
| $this->drawMenuItem('Manage Account', 'admin/account.php?id=' . $this->getLoggedInUser()->ID); |
| $this->drawMenuItem('Logout', 'logout-do.php'); |
| } |
| else |