dulynoted-oldwebsite/repertoire.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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?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

					// Store Members Full Names into Array
					include "soloists.php";

					// Obtain page # or item ID from URL
					$page = $_REQUEST['page'];
					$id = $_REQUEST['id'];

					if ($id < 1) $id = 0;

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

					// 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);
					if ($page < 1) $page = 1;
					$start = $limit * ($page - 1);
					$width += (floor($width / 2) == $width / 2);


					if ($id > 0) {

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

						// Redirect Retired Song to retired repertoire page
						if ($row['archived']) header('location: retired_repertoire.php?id=' . $id);

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

					}

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

					if (!$result)
					{
						die("MYSQL ERROR: ".mysql_error());
					}
					// Insert Song data into table
					$i = 0;
					while ($row = mysql_fetch_array($result))
			{ ?><div>
						<em><a<?php if (!$row['deleted']) { ?> href="repertoire.php?id=<?php echo $row['id']; ?>"<?php } ?>><?php /* song */ echo $row['title']; ?></a></em>
						by <a href="http://www.last.fm/music/<?php echo str_ireplace(' ', '+', $row['artist']); ?>"><?php /* artist */ echo $row['artist']; ?></a>
						during <?php /* semester */ echo $row['semester'] . "\r"; ?>
						<br />Solo by <a href="members.php?id=<?php echo $row['soloid']; ?>"><?php /* soloist */ echo $solo[$row['soloid']]; ?></a> /
						<a href="<?php /* video link */ echo $row['youtube']; ?>">Watch a Video</a>
					</div>
					<?php $i++; } echo "\r";
					if ($i == 0)
					{ ?>
						<p>There are currently no songs in the repertoire.</p>
					<?php } ?>

				</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); ?>