dulynoted-oldwebsite/news_feed.php at master · yuanb10/dulynoted-oldwebsite · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
<?php /* Enable GZIP Compression */ include "/home/dulynote/public_html/members/includes/gzip_compress.php"; ?>
<?php /* Connect to MySQL Database on the PHP server */ session_start(); include "connect.php"; ?>
<?php /* Get Canvas Elements */ $canvas = mysql_fetch_array(mysql_query("SELECT logo, navbar, addthis, tray FROM canvas WHERE id=1")); ?>
<?php /* Fetch Page Description from MySQL Database */ $url = explode("/", $_SERVER["SCRIPT_NAME"]); $url = explode(".", $url[count($url)-1]); $webpage = mysql_fetch_array(mysql_query("SELECT title, item, heading, description, detail, content, note, searchable FROM pages WHERE page='$url[0]'")); if ($_REQUEST['id'] > 0) { eval($webpage['detail']); } else $description =  $webpage['description']; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">

	<head>

		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<meta name="description" content="<?php /* Page Description */ echo $description; ?>" />
		<title><?php /* Fetch Page Title from MySQL Database */ if ($_REQUEST['id'] > 0) { eval($webpage['item']); echo " - "; } echo $webpage['title']; ?> - Duly Noted All-Male A Cappella - RPI Troy, NY</title>
		<base href="http://dulynoted.union.rpi.edu/" />
		<link rel="search" type="application/opensearchdescription+xml" title="Duly Noted" href="search.xml" />
		<link href="atom/index.php" type="application/atom+xml" rel="alternate" title="Duly Noted A Cappella Feed" />
		<link href="style.css" type="text/css" rel="stylesheet" />
		<script type="text/javascript" src=".jquery.js"></script>
		<script type="text/javascript" src="script.js"></script>

	</head>

	<body>
		<div class="container">

			<!-- Duly Noted Logo -->
			<?php echo $canvas['logo'] . "\r"; ?>

			<!-- Navigation Menu -->
			<?php echo $canvas['navbar'] . "\r"; ?>

			<!-- Main Content of Page -->
			<div class="canvas">

				<h1><?php echo $webpage['heading']; ?></h1>
				<?php	echo $webpage['content'] . "\r"; ?>

				<div class="shaded_div">
					<?php

					// Include Extensions
					include "timestamper.php";

					// Obtain page # or item ID from URL
					$page = $_REQUEST['page'];
					$id = $_REQUEST['id'];
					if ($page < 1) $page = 1;
					if ($id < 1) $id = 0;

					// Set table size and scroll width
					list ($limit, $width) = array (12, 7);

					// Determine position of first (top) item on table
					$num_rows = mysql_num_rows(mysql_query("SELECT id FROM " . $webpage['searchable']));
					if ($page > $num_rows / $limit) $page = ceil($num_rows / $limit);
					$start = $limit * ($page - 1);
					$width += (floor($width / 2) == $width / 2);

					if ($id > 0) {

						// Search for and fetch Post from the MySQL Database
						$row = mysql_fetch_array(mysql_query("SELECT deleted FROM posts WHERE id='$id'"));

						// Return Error if Post deleted
						if ($row['deleted'] || count($row) == 1) header ('location: 404.shtml');

					}

					// Search for and fetch Post(s) from the MySQL Database
					if ($id > 0) $result = mysql_query("SELECT id, title, content, updated FROM " . $webpage['searchable'] . " && id='$id'");
					else $result = mysql_query("SELECT id, title, content, updated FROM " . $webpage['searchable'] . " ORDER BY updated DESC LIMIT $start,$limit");

					// Insert Post data into table
					while($row = mysql_fetch_array($result))
			{ ?><div>
						<strong><a href="news_feed.php?id=<?php echo $row['id']; ?>"><?php echo $row["title"]; ?></a></strong>
						<br /><?php echo $row["content"]; ?>
						<br /><span style="font-size:75%"><?php echo timestamper ($row["updated"]); ?></span>
					</div>
					<?php } echo "\r"; ?>
				</div>
				<?php /* Page Navigation */ include "pages.php"; ?>

				<div class="note"><?php echo $webpage['note']; ?></div>

				<!-- AddThis -->
				<?php echo $canvas['addthis'] . "\r"; ?>

			</div>

			<!-- Bottom Navigation Tray -->
			<?php echo $canvas['tray'] . "\r"; ?>

			<!-- Footnotes -->
			<?php include "footnotes.php"; ?>

		</div>
	</body>

</html>
<?php /* Close connection to the MySQL Database */ mysql_close($connection); ?>