WebSVN - taios - Blame - Rev 113

Rev	Author	Line No.	Line
33	freddie	1	<?php
		2
		3	require '_config.php';
		4
		5	class Taios_Page
		6	{
		7	function __construct($title, $url = "")
		8	{
		9	$this->title = $title;
		10	$this->url = $url;
		11
		12	$this->drawnHeader = false;
		13	$this->drawnMiddle = false;
		14	$this->drawnFooter = false;
		15
		16	$this->db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD);
		17	if (!$this->db)
		18	{
		19	$this->drawError('Failed to connect to database: ' . mysql_error());
		20	}
		21
		22	if (!mysql_select_db('Tim32'))
		23	{
		24	$this->drawError('Failed to select database: ' . mysql_error());
		25	}
		26	}
		27
		28	function drawHeader()
		29	{
		30	if (!$this->drawnHeader)
		31	{
		32	write('<!DOCTYPE html>');
		33	write('<html>');
		34	write('<head>');
		35	write('<meta http-equiv="Content-Type" content="text/html;charset=utf-8">');
		36	write('<title>Tim32 · ' . $this->title . '</title>');
		37	write('<link href="' . $this->url . 'styles.css" rel="stylesheet" type="text/css" media="screen">');
		38	write('</head>');
		39	write('<body>');
		40	write('<div class="sidebar">');
		41	write('<div class="sidebar-header">');
		42	write('<h1>Tim32</h1>');
		43	write('</div>');
		44	write('<div class="sidebar-menu">');
		45	$this->drawMenuItem('Home', 'index.php');
		46	$this->drawMenuItem('Blog', 'blog/');
		47	$this->drawMenuItem('Projects', 'projects/');
		48	$this->drawMenuItem('Forums', 'forums/');
		49	$this->drawMenuItem('Wiki', 'wiki/');
		50	$this->drawMenuItem('Photos', 'photos/');
		51	write('<br />');
		52	if ($this->isLoggedIn())
		53	{
77	tom	54	$this->drawMenuItem('Administration', 'admin/');
33	freddie	55	$this->drawMenuItem('Logout', 'logout-do.php');
		56	}
		57	else
		58	{
		59	$this->drawMenuItem('Login', 'login.php');
		60	$this->drawMenuItem('Register', 'register.php');
		61	}
		62	write('<br />');
		63
		64	$this->drawnHeader = true;
		65	}
		66	}
		67
		68	function drawMenuItem($t, $u)
		69	{
49	tom	70	write('<p><a href="' . $this->url . $u . '">' . $t . '</a></p>');
33	freddie	71	}
		72
		73	function drawMiddle()
		74	{
		75	if (!$this->drawnMiddle)
		76	{
		77	write('<br />');
		78	write('</div>');
		79	write('</div>');
		80	write('<div class="content">');
		81	write('<h2>' . $this->title . '</h2>');
		82
		83	$this->drawnMiddle = true;
		84	}
		85	}
		86
		87	function drawFooter()
		88	{
		89	if (!$this->drawnFooter)
		90	{
		91	write('</div>');
		92	write('</body>');
		93	write('</html>');
		94
		95	$this->drawnFooter = true;
		96	}
		97
52	tom	98	die();
33	freddie	99	}
		100
		101	function drawError($text, $die = true)
		102	{
		103	$this->drawHeader();
		104	$this->drawMiddle();
		105
		106	write('<h4 style="color: red;">Error: ' . $text . '</h4>');
		107
		108	if ($die)
		109	{
		110	$this->drawFooter();
		111	die();
		112	}
		113	}
		114
90	freddie	115	function drawBlogPostTree($id, $first = false)
33	freddie	116	{
		117	$post = $this->getBlogPost($id);
90	freddie	118	if ($first)
95	freddie	119	write('<h3><a href="post.php?id=' . $id . '">' . $post->title. '</a> <a href="post.php?id=' . $post->parent->ID . '">^</a></h3>');
90	freddie	120	else
		121	write('<a href="post.php?id=' . $id . '"><h3>' . $post->title. '</h3></a>');
33	freddie	122	write('<h5 style="color: #666666;">Posted On ' . date('l j F Y', $post->datePosted) . ' by ' . $post->user->name . ' (' . $post->user->username . ')</h5>');
		123	write('<p>' . $post->content . '</p>');
74	tom	124	write('<br />');
73	tom	125	if ($this->isUserNormal($this->getLoggedInUser()))
72	tom	126	{
101	freddie	127	write('<p class="bold"><a href="add-post.php?id=' . $id . '">Add Comment</a></p>');
113	freddie	128	if ($this->isUserAdmin($this->getLoggedInUser()))
		129	write(' \| <p class="bold"><a href="del-post.php?id=' . $id . '">Delete Post</a></p>');
72	tom	130	write('<br />');
		131	}
33	freddie	132
43	freddie	133	$ids = $this->findIDs('BlogPosts', 'WHERE ParentID=' . $id);
33	freddie	134	for ($i = 0; $i < count($ids); $i++)
		135	{
52	tom	136	write('<div class="indent">');
43	freddie	137	$this->drawBlogPostTree($ids[$i]);
52	tom	138	write('</div>');
33	freddie	139	}
		140	}
57	tom	141
58	tom	142	function drawBlogCategoriesMenu()
57	tom	143	{
		144	$cats = array();
		145
62	tom	146	$ids = $this->findIDs('BlogPosts', 'WHERE ParentID = -1');
57	tom	147	for ($i = 0; $i < count($ids); $i++)
		148	{
		149	$cat = $this->getBlogPost($ids[$i])->category;
		150	if (!in_array($cat, $cats))
		151	{
		152	array_push($cats, $cat);
		153	}
		154	}
		155
61	tom	156	write('<h3>Categories</h3>');
57	tom	157	for ($i = 0; $i < count($cats); $i++)
		158	{
65	tom	159	$this->drawMenuItem($cats[$i], 'blog/index.php?cat=' . $cats[$i]);
57	tom	160	}
		161	}
33	freddie	162
64	tom	163	function redirect($u)
33	freddie	164	{
64	tom	165	header('Location: ' . $u);
33	freddie	166	die();
		167	}
		168
		169	function isLoggedIn()
		170	{
		171	$cookie = $_COOKIE['Tim32_Login'];
		172	if (!empty($cookie))
		173	{
		174	$clist = explode('\|~\|', $cookie);
		175	$user = $this->getUserByUsername($clist[0]);
		176	if ($user)
		177	{
		178	if ($user->password == $clist[1])
		179	{
		180	return true;
		181	}
		182	}
		183	}
		184
		185	return false;
		186	}
		187
		188	function isUserAdmin()
		189	{
		190	if ($this->isLoggedIn())
		191	{
		192	if ($this->getLoggedInUser()->accessID <= 0)
		193	{
		194	return true;
		195	}
		196	}
		197
		198	return false;
		199	}
		200
		201	function isUserGM()
		202	{
		203	if ($this->isLoggedIn())
		204	{
		205	if ($this->getLoggedInUser()->accessID <= 1)
		206	{
		207	return true;
		208	}
		209	}
		210
		211	return false;
		212	}
		213
		214	function isUserNormal()
		215	{
		216	if ($this->isLoggedIn())
		217	{
		218	if ($this->getLoggedInUser()->accessID <= 2)
		219	{
		220	return true;
		221	}
		222	}
		223
		224	return false;
		225	}
		226
		227	function checkLoggedIn()
		228	{
		229	if (!$this->isLoggedIn())
		230	{
		231	$this->drawError('You need to be logged in.');
		232	}
		233	}
		234
		235	function query($query)
		236	{
		237	$result = mysql_query($query);
		238	if (!$result)
		239	{
		240	$this->drawError('MySQL Error: ' . mysql_error());
		241	}
		242
		243	return $result;
		244	}
		245
		246	function findIDs($table, $query = '')
		247	{
		248	$array = array();
		249
		250	$result = $this->query('SELECT ID FROM ' . $table . ' ' . $query);
		251	while ($row = mysql_fetch_array($result))
		252	{
		253	array_push($array, $row['ID']);
		254	}
		255
		256	return $array;
		257	}
		258
		259	function getUserByID($id)
		260	{
		261	$result = $this->query('SELECT * FROM Users WHERE ID = ' . $id);
		262	while ($row = mysql_fetch_array($result))
		263	{
		264	$user = new User;
		265	$user->ID = $row['ID'];
		266	$user->accessID = $row['AccessID'];
		267	$user->username = $row['Username'];
		268	$user->password = $row['Password'];
		269	$user->emailAddress = $row['EmailAddress'];
		270	$user->name = $row['Name'];
		271	$user->challengeID = $row['ChallengeID'];
		272
		273	return $user;
		274	}
		275
		276	return false;
		277	}
		278
		279	function getUserByUsername($username)
		280	{
		281	$result = $this->query('SELECT * FROM Users WHERE Username = "' . $username . '"');
		282	while ($row = mysql_fetch_array($result))
		283	{
		284	return $this->getUserByID($row['ID']);
		285	}
		286
		287	return false;
		288	}
		289
		290	function getLoggedInUser()
		291	{
		292	if ($this->isLoggedIn())
		293	{
		294	$clist = explode('\|~\|', $_COOKIE['Tim32_Login']);
		295	return $this->getUserByUsername($clist[0]);
		296	}
		297
		298	return false;
		299	}
		300
		301	function getBlogPost($id)
		302	{
		303	$result = $this->query('SELECT * FROM BlogPosts WHERE ID = ' . $id);
		304	while ($row = mysql_fetch_array($result))
		305	{
		306	$post = new BlogPost;
		307	$post->ID = $row['ID'];
		308	if ($row['ParentID'] == -1)
		309	{
		310	$post->parent = -1;
		311	}
		312	else
		313	{
		314	$post->parent = $this->getBlogPost($row['ParentID']);
		315	}
104	tom	316	$post->author = $this->getUserByID($row['AuthorID']);
105	tom	317	$post->user = $this->getUserByID($row['AuthorID']); // For some older pages
33	freddie	318	$post->title = $row['Title'];
		319	$post->content = $row['Content'];
		320	$post->datePosted = strtotime($row['DatePosted']);
		321	$post->category = $row['Category'];
		322	$post->spam = $row['Spam'];
		323
		324	return $post;
		325	}
		326
		327	$this->drawError('Cannot find blog post, #' . $id);
		328	}
		329
113	freddie	330	function delBlogPost($id)
		331	{
		332	$ids = $this->findIDs('BlogPosts', 'WHERE ParentID=' . $id);
		333	for ($i = 0; $i < count($ids); $i++)
		334	$this->delBlogPost($ids[$i]);
		335
		336	$this->query('delete from BlogPosts where ID=' . $id);
		337	}
		338
33	freddie	339	function getGetID()
		340	{
		341	$id = $_GET['id'];
		342	if (empty($id))
		343	{
		344	$id = 1;
		345	}
		346
		347	return $id;
		348	}
		349
		350	function getPostID()
		351	{
41	freddie	352	$id = $_POST['id'];
33	freddie	353	if (empty($id))
		354	{
		355	$id = 1;
		356	}
		357
		358	return $id;
		359	}
		360
		361	}
		362
		363	class User
		364	{
		365	public $ID;
		366	public $accessID;
		367	public $username;
		368	public $password;
		369	public $emailAddress;
		370	public $name;
		371	public $challengeID;
		372	}
		373
		374	class BlogPost
		375	{
		376	public $ID;
		377	public $parent;
		378	public $author;
		379	public $title;
		380	public $content;
		381	public $datePosted;
		382	public $category;
		383	public $spam;
		384	}
		385
		386	function write($str)
		387	{
		388	echo $str;
		389	echo "\n";
		390	}
		391
		392	?>

Subversion Repositories taios

(root)/_taios.php - Rev 113