/projects/index.php |
---|
6,8 → 6,27 |
$page->drawHeader(); |
$page->drawMiddle(); |
write('<br /><p class="bold">This page is currently under construction.</p>'); |
write('<p class="bold">Here you can find all the projects that are created by members of Tim32!</p><br />'); |
$ids = $page->findIDs('Projects', 'ORDER BY LastUpdate DESC'); |
for ($i = 0; $i < count($ids); $i++) |
{ |
$id = $ids[$i]; |
$project = $page->getProject($id); |
write('<h3>' . $project->title . '</h3>'); |
write('<table style="border: 0px;">'); |
write('<tr>'); |
write('<td style="border: 0px; vertial-align: top;"><img class="smiley" src="' . $project->logoURL . '" /></td>'); |
write('<td style="border: 0px;">'); |
write('<h4>Latest Version: ' . $project->latestVersion . '</h4>'); |
write('<p>' . $page->replaceBBCode($project->description . '</p>'); |
write('</td>'); |
write('</tr>'); |
write('</table>'); |
write('<br />'); |
} |
$page->drawFooter(); |
?> |
/install.sql |
---|
35,8 → 35,10 |
Title TEXT, |
Description TEXT, |
LogoURL TEXT, |
DownloadURL TEXT, |
WebsiteURL TEXT, |
LatestVersion TEXT, |
LastUpdate DATETIME, |
PRIMARY KEY(ID) |
); |
73,3 → 75,4 |
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); |
INSERT INTO Projects VALUES (1, 1, "TAIOS", "TAIOS (The All In One System) is a PHP based system to make the Tim32 website very self contained and altogether.", "http://websvn.kde.org/*checkout*/trunk/kdesupport/oxygen-icons/64x64/categories/applications-internet.png", "", "http://tim32.org/~tom/taios/", "SVN", NOW()); |
/_taios.php |
---|
374,13 → 374,38 |
$this->drawError('Cannot find blog post, #' . $id); |
} |
function getProject($id) |
{ |
$result = $this->query('SELECT * FROM Projects WHERE ID = ' . $id); |
while ($row = mysql_fetch_array($result)) |
{ |
$project = new Project; |
$project->ID = $row['ID']; |
$project->author = $this->getUserByID($row['AuthorID']); |
$project->title = $row['Title']; |
$project->description = $row['Description']; |
$project->logoURL = $row['LogoURL']; |
$project->downloadURL = $row['DownloadURL']; |
$project->websiteURl = $row['WebsiteURL']; |
$project->latestVersion = $row['LatestVersion']; |
$project->lastUpdate = strtotime($row['LastUpdate']); |
return $project; |
} |
return false; |
} |
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); |
$this->query('DELETE FROM BlogPosts WHERE ID=' . $id); |
} |
function getGetID() |
430,6 → 455,19 |
public $spam; |
} |
class Project |
{ |
public $ID; |
public $author; |
public $title; |
public $description; |
public $logoURL; |
public $downloadURL; |
public $websiteURL; |
public $latestVersion; |
public $lastUpdate; |
} |
function write($str) |
{ |
echo $str; |
/admin/all-blog-posts.php |
---|
24,7 → 24,7 |
write('<td class="bold">Spam</td>'); |
write('</tr>'); |
$ids = $page->findIDs('BlogPosts'); |
$ids = $page->findIDs('BlogPosts', 'ORDER BY DatePosted DESC'); |
for ($i = 0; $i < count($ids); $i++) |
{ |
$post = $page->getBlogPost($ids[$i]); |
40,7 → 40,7 |
} |
write('<td><a href="account.php?id=' . $post->author->ID . '">' . $post->author->name . '</a></td>'); |
write('<td>' . $post->title . '</td>'); |
write('<td>' . $post->content . '</td>'); |
write('<td>' . str_replace("\n", '<br />', $post->content) . '</td>'); |
write('<td>' . date('j/m/Y H:i', $post->datePosted) . '</td>'); |
write('<td>' . $post->category . '</td>'); |
write('<td>' . $post->spam . '</td>'); |
51,7 → 51,7 |
} |
else |
{ |
drawError('You do not have permission to access this page.'); |
$page->drawError('You do not have permission to access this page.'); |
} |
$page->drawFooter(); |
/admin/all-accounts.php |
---|
42,7 → 42,7 |
} |
else |
{ |
drawError('You do not have permission to access this page.'); |
$page->drawError('You do not have permission to access this page.'); |
} |
$page->drawFooter(); |
/admin/account.php |
---|
21,7 → 21,7 |
<form action="account-do.php" method="POST"> |
<table> |
<tr><td class="bold">ID: </td><td><?php echo $user->ID; ?></td></tr> |
<tr><td class="bold">ID: </td><td><input type="hidden" name="id" value="<?php echo $user->ID; ?>" /><?php echo $user->ID; ?></td></tr> |
<?php |
if ($page->isUserAdmin($page->getLoggedInUser())) |
{ |
46,11 → 46,11 |
{ |
if (!$user) |
{ |
drawError('No such user, #' . $userID); |
$page->drawError('No such user, #' . $userID); |
} |
else |
{ |
drawError('You do not have permission to access this page.'); |
$page->drawError('You do not have permission to access this page.'); |
} |
} |
/admin/account-do.php |
---|
39,11 → 39,11 |
{ |
if (!$user) |
{ |
drawError('No such user, #' . $userID); |
$page->drawError('No such user, #' . $userID); |
} |
else |
{ |
drawError('You do not have permission to access this page.'); |
$page->drawError('You do not have permission to access this page.'); |
} |
} |
/index.php |
---|
28,7 → 28,7 |
$id = $ids[$i]; |
$post = $page->getBlogPost($id); |
write('<h4>' . $post->title. '</h4>'); |
write('<h4><a href="blog/post.php?id=' . $post->ID . '">' . $post->title. '</a></h4>'); |
write('<h5 style="color: #666666;">Posted On ' . date('l j F Y', $post->datePosted) . ' by ' . $post->user->name . ' (' . $post->user->username . ')</h5>'); |
write('<p>' . $page->replaceBBCode($post->content) . '</p>'); |
write('<br />'); |
/blog/post.php |
---|
4,7 → 4,7 |
$page = new Taios_Page('Blog Posts', '../'); |
if (empty($_GET['id'])) |
if (empty($_GET['id']) || $_GET['id'] == -1) |
{ |
$page->redirect('index.php'); |
} |
/blog/add-post.php |
---|
40,7 → 40,7 |
} |
else |
{ |
if ($page->getLoggedInUser() >= 2 && $parentID == -1) |
if ($page->getLoggedInUser()->accessID >= 2 && $parentID == -1) |
{ |
$page->drawError('You do not have permission to access this page.'); |
} |