WebSVN - taios - Blame - Rev 138

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	{
116	freddie	127	echo '<p class="bold"><a href="add-post.php?id=' . $id . '">Add Comment</a>';
117	freddie	128	if ($this->isUserAdmin($this->getLoggedInUser()) \|\| $this->getLoggedInUser() == $post->author->ID)
		129	echo ' &middot <a href="del-post.php?id=' . $id . '">Delete Post</a>';
116	freddie	130	write('</p><br />');
72	tom	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	}
137	tom	162
		163	function replaceBBCode($str)
		164	{
		165	$newstr = str_replace("\n", '</p><p>', $str);
		166
		167	return $newstr;
		168	}
33	freddie	169
64	tom	170	function redirect($u)
33	freddie	171	{
64	tom	172	header('Location: ' . $u);
33	freddie	173	die();
		174	}
		175
		176	function isLoggedIn()
		177	{
		178	$cookie = $_COOKIE['Tim32_Login'];
		179	if (!empty($cookie))
		180	{
		181	$clist = explode('\|~\|', $cookie);
		182	$user = $this->getUserByUsername($clist[0]);
		183	if ($user)
		184	{
		185	if ($user->password == $clist[1])
		186	{
		187	return true;
		188	}
		189	}
		190	}
		191
		192	return false;
		193	}
		194
		195	function isUserAdmin()
		196	{
		197	if ($this->isLoggedIn())
		198	{
		199	if ($this->getLoggedInUser()->accessID <= 0)
		200	{
		201	return true;
		202	}
		203	}
		204
		205	return false;
		206	}
		207
		208	function isUserGM()
		209	{
		210	if ($this->isLoggedIn())
		211	{
		212	if ($this->getLoggedInUser()->accessID <= 1)
		213	{
		214	return true;
		215	}
		216	}
		217
		218	return false;
		219	}
		220
		221	function isUserNormal()
		222	{
		223	if ($this->isLoggedIn())
		224	{
		225	if ($this->getLoggedInUser()->accessID <= 2)
		226	{
		227	return true;
		228	}
		229	}
		230
		231	return false;
		232	}
		233
		234	function checkLoggedIn()
		235	{
		236	if (!$this->isLoggedIn())
		237	{
		238	$this->drawError('You need to be logged in.');
		239	}
		240	}
		241
		242	function query($query)
		243	{
		244	$result = mysql_query($query);
		245	if (!$result)
		246	{
		247	$this->drawError('MySQL Error: ' . mysql_error());
		248	}
		249
		250	return $result;
		251	}
		252
		253	function findIDs($table, $query = '')
		254	{
		255	$array = array();
		256
		257	$result = $this->query('SELECT ID FROM ' . $table . ' ' . $query);
		258	while ($row = mysql_fetch_array($result))
		259	{
		260	array_push($array, $row['ID']);
		261	}
		262
		263	return $array;
		264	}
		265
		266	function getUserByID($id)
		267	{
		268	$result = $this->query('SELECT * FROM Users WHERE ID = ' . $id);
		269	while ($row = mysql_fetch_array($result))
		270	{
		271	$user = new User;
		272	$user->ID = $row['ID'];
		273	$user->accessID = $row['AccessID'];
		274	$user->username = $row['Username'];
		275	$user->password = $row['Password'];
		276	$user->emailAddress = $row['EmailAddress'];
		277	$user->name = $row['Name'];
		278	$user->challengeID = $row['ChallengeID'];
		279
		280	return $user;
		281	}
		282
		283	return false;
		284	}
		285
		286	function getUserByUsername($username)
		287	{
		288	$result = $this->query('SELECT * FROM Users WHERE Username = "' . $username . '"');
		289	while ($row = mysql_fetch_array($result))
		290	{
		291	return $this->getUserByID($row['ID']);
		292	}
		293
		294	return false;
		295	}
		296
		297	function getLoggedInUser()
		298	{
		299	if ($this->isLoggedIn())
		300	{
		301	$clist = explode('\|~\|', $_COOKIE['Tim32_Login']);
		302	return $this->getUserByUsername($clist[0]);
		303	}
		304
		305	return false;
		306	}
		307
		308	function getBlogPost($id)
		309	{
		310	$result = $this->query('SELECT * FROM BlogPosts WHERE ID = ' . $id);
		311	while ($row = mysql_fetch_array($result))
		312	{
		313	$post = new BlogPost;
		314	$post->ID = $row['ID'];
		315	if ($row['ParentID'] == -1)
		316	{
		317	$post->parent = -1;
		318	}
		319	else
		320	{
		321	$post->parent = $this->getBlogPost($row['ParentID']);
		322	}
104	tom	323	$post->author = $this->getUserByID($row['AuthorID']);
105	tom	324	$post->user = $this->getUserByID($row['AuthorID']); // For some older pages
33	freddie	325	$post->title = $row['Title'];
137	tom	326	$post->content = $this->replaceBBCode($row['Content']);
33	freddie	327	$post->datePosted = strtotime($row['DatePosted']);
		328	$post->category = $row['Category'];
		329	$post->spam = $row['Spam'];
		330
		331	return $post;
		332	}
		333
		334	$this->drawError('Cannot find blog post, #' . $id);
		335	}
		336
113	freddie	337	function delBlogPost($id)
		338	{
		339	$ids = $this->findIDs('BlogPosts', 'WHERE ParentID=' . $id);
		340	for ($i = 0; $i < count($ids); $i++)
		341	$this->delBlogPost($ids[$i]);
		342
		343	$this->query('delete from BlogPosts where ID=' . $id);
		344	}
		345
33	freddie	346	function getGetID()
		347	{
		348	$id = $_GET['id'];
		349	if (empty($id))
		350	{
		351	$id = 1;
		352	}
		353
		354	return $id;
		355	}
		356
		357	function getPostID()
		358	{
41	freddie	359	$id = $_POST['id'];
33	freddie	360	if (empty($id))
		361	{
		362	$id = 1;
		363	}
		364
		365	return $id;
		366	}
		367
		368	}
		369
		370	class User
		371	{
		372	public $ID;
		373	public $accessID;
		374	public $username;
		375	public $password;
		376	public $emailAddress;
		377	public $name;
		378	public $challengeID;
		379	}
		380
		381	class BlogPost
		382	{
		383	public $ID;
		384	public $parent;
		385	public $author;
		386	public $title;
		387	public $content;
		388	public $datePosted;
		389	public $category;
		390	public $spam;
		391	}
		392
		393	function write($str)
		394	{
		395	echo $str;
		396	echo "\n";
		397	}
		398
		399	?>

Subversion Repositories taios

(root)/_taios.php - Rev 138