Stuff

<?php
if (isset($_SESSION['user_id'])) $user_last_read = get_and_set_time('smdb');

$title_order = "desc";
$rating_order = "desc";
$user_order = "desc";
$posts_order = "desc";

switch ($_GET['sort'])
{
	case "title_desc":
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost 
		FROM smdbMovies ORDER By smdbTitle DESC";
		$title_order = "asc";
		break;
		
	case "title_asc":
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost 
		FROM smdbMovies ORDER By smdbTitle ASC";
		$title_order = "desc";
		break;
	
	case "rating_desc":
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost, AVG(ratingPoints) as average 
				FROM smdbMovies JOIN smdbRatings ON smdbMovies.smdbID = smdbRatings.ratingMovieID 
				GROUP BY ratingMovieID ORDER BY average DESC";
		$rating_order = "asc";
		break;
		
	case "rating_asc":
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost, AVG(ratingPoints) as average 
				FROM smdbMovies JOIN smdbRatings ON smdbMovies.smdbID = smdbRatings.ratingMovieID 
				GROUP BY ratingMovieID ORDER BY average ASC";
		$rating_order = "desc";
		break;	
	
	case "user_desc":
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost 
		FROM smdbMovies ORDER By smdbAuthorID DESC";
		$user_order = "asc";
		break;
		
	case "user_asc":
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost 
		FROM smdbMovies ORDER By smdbAuthorID ASC";
		$user_order = "desc";
		break;
	
	case "posts_desc":
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost 
		FROM smdbMovies ORDER By smdbPosts DESC";
		$posts_order = "asc";
		break;
		
	case "posts_asc":
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost 
		FROM smdbMovies ORDER By smdbPosts ASC";
		$posts_order = "desc";
		break;
		
	case "time_asc":
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost 
		FROM smdbMovies ORDER By smdbTimePost ASC";
		$time_order = "desc";
		break;
		
	default:
		$sql = "SELECT smdbID, smdbAuthorID, smdbTitle, smdbRating, smdbPosts, smdbTimePost 
		FROM smdbMovies ORDER By smdbTimePost DESC";
		$time_order = "asc";
		break;
}
?>
<p>
	<a href="./?p=smdb&amp;sub=add">
		L&auml;gg in en ny film
	</a>
</p>
	<table id="smdb_archive">
		<tr>
			<th id="filmtitle"><a href="./?p=smdb&amp;sort=title_<?php echo $title_order; ?>">Filmtitel</a></th>
			<th><a href="./?p=smdb&amp;sort=rating_<?php echo $rating_order; ?>">Betyg</a></th>
			<th><a href="./?p=smdb&amp;sort=user_<?php echo $user_order; ?>">Skapare</a></th>
			<th><a href="./?p=smdb&amp;sort=posts_<?php echo $posts_order; ?>">Inl&auml;gg</a></th>
			<th id="last_post"><a href="./?p=smdb&amp;sort=time_<?php echo $time_order; ?>">Senaste inl&auml;gg</a></th>
		</tr>
<?php
$db = new dbObject();
$results = $db->query($sql);
$i = 0;

while($row = $db->fetch_assoc($results))
{
		$movieID = $row['smdbID'];
		$get = "SELECT AVG(ratingPoints) AS average FROM smdbRatings WHERE ratingMovieID = $movieID GROUP BY ratingMovieID";
		$rating = $db->fetch_assoc($db->query($get));

?>
		<tr class="<?php echo (($i % 2) == 0 ? "dark" : "bright"); ?>">
			<td>
				<a href="./?p=smdb&amp;sub=movie&amp;id=<?php echo $row['smdbID']; ?>">
					<?php echo cut_str($row['smdbTitle'], 50); ?>
				</a>
			</td>
			
			<td><?php echo round($rating['average'],1); ?></td>
			<td><?php echo write_user($row['smdbAuthorID']); ?></td>
			<td><?php echo $row['smdbPosts']; ?></td>
			<td<?php if ($user_last_read < $row['smdbTimePost']) echo ' class="new"'; ?>>
				<?php echo smart_date($row['smdbTimePost']); ?>
			</td>
		</tr>
	
<?php
$i++;
}
unset($db);
?>
	</table>