index.php

<?php
/*
+ ----------------------------------------------------------------------------+
|     PHPDirector.
|		$License: GPL General Public License
|		$Website: phpdirector.co.uk
|		$Author: Ben Swanson
|		$Contributors - Dennis Berko and Monte Ohrt (Monte Ohrt)
+----------------------------------------------------------------------------+
*/

require('header.php');

// required connect
    SmartyPaginate::connect();
	
// set items per page
	$limit = config('vids_per_page');
    SmartyPaginate::setLimit($limit);

//SORTING???
		
switch ($_GET["sort"]){
case "name":
	$sort = "name";
	break;
case "date":
	$sort = "date";
	break;
case "views":
	$sort = "views";
	break;
default:
	$sort = "date";
	$order1 = "DESC";
}

//Check if theres a Get called order then is its down order by DESC if its up dont order by DESC if no get varriable order by non DESC
if(isset($_GET["order"])){
	$order = $_GET["order"];
	if($order == "up"){
		$order1 = "";
	}
	if($order == "down"){
		$order1 = "DESC";
	}
}
		
		//SORTING END ???
if ($_GET["pt"] == "all") {		
		$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `approved` = '1' AND `reject` = '0' ORDER BY $sort $order1 LIMIT %d,%d",
		 SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());
}elseif ($_GET["pt"] == "feature") {
		$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `approved` = '1' AND `feature` = '1' AND `reject` = '0' ORDER BY $sort $order1 LIMIT %d,%d",
            SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());
}elseif (isset($_GET["cat"])) {
$cat = $_GET["cat"];
		$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `category` = '$cat' AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",
            SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());
			$smarty->assign('pagetype', $cat);
}elseif (isset($_GET[search])){
	
		$search = $_GET[search];
		$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `name` like '%%$search%%' AND `approved` = '1' ORDER BY $sort $order1 LIMIT %d,%d",
            SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());
			$smarty->assign('pagetype', 'Search Results');
			
}elseif(isset($_GET[tag])){

//Dam those people who want to see which videos have a tag!
//This is getting the tags from pp_tags
$tagquery = mysql_query('SELECT video_id FROM `pp_tags` WHERE `name` LIKE CONVERT(_utf8 \''.$_GET[tag].'\' USING latin1) COLLATE latin1_swedish_ci');

//This is so at the end of $in it doesn't have a extra comma
$tagrows = mysql_num_rows($tagquery); 
$in = null;
$i = 0;
while ($tags = mysql_fetch_assoc($tagquery)){
$i++;
		if($i == $tagrows){//This is so at the end of $in it doesn't have a extra comma
			$in = $in." '".$tags[video_id]."'";
		}else{
			$in = $in." '".$tags[video_id]."',";
		}

	}
		$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `approved` = '1' AND `id` IN (".$in.") AND `reject` = '0' ORDER BY $sort $order1 LIMIT %d,%d",SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit()); //$in is all the rows that have the correct tag

			$smarty->assign('pagetype', 'Tags'); 
}else{
		$_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `approved` = '1' AND `feature` = '1' AND `reject` = '0' ORDER BY $sort $order1 LIMIT %d,%d",
    SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());
	$smarty->assign('pagetype', 'Featured Videos');
	
};
        $_result = mysql_query($_query);   // assign your db results to the template

$_data = array();
$i=0;
       while ($_row = mysql_fetch_array($_result, MYSQL_ASSOC)) {
		
		
		$month = date("M", strtotime($_row[date]));
		$day = date("d", strtotime($_row[date]));
		//image
		if ($_row['picture'] !== null){
			$tehpic = $_row[picture];
			$amp = array("&amp;");
			$new_replace  = array("&");
			$newphrase = str_replace("$amp", "$new_replace", "$tehpic");
			$picture = $newphrase;
		}
		//image
		
		$tmp = array(
			'id' => $_row['id'], 
			'month' => $month, 
			'day' => $day,
			'name' => $_row['name'],
			'creator' => $_row['creator'],
			'picture' => $picture,
			'description' => $_row['description'],
			'br' => $br
		);
			
			$_data[$i++] = $tmp;
		
		
            // collect each record into $_data
        }
        
        // now we get the total number of records from the table
// now we get the total number of records from the table
        $_query = "SELECT FOUND_ROWS() as total";
        $_result = mysql_query($_query);
        $_row = mysql_fetch_array($_result, MYSQL_ASSOC);
        SmartyPaginate::setTotal($_row['total']);

        mysql_free_result($_result);
 	
	///DB
	
	
	$smarty->assign('videos', $_data);
	
		if ($_row['total'] == 0){ //if no videos display error.
	$error = "There Where No Results";
	$smarty->assign_by_ref('error', $error);
	$smarty->display('error.tpl');
	exit;
}
    // assign {$paginate} var
    SmartyPaginate::assign($smarty);
	if (isset($_GET["pt"])){
	SmartyPaginate::setUrl('index.php?pt='.$_GET["pt"]);
	}elseif(isset($_GET["cat"])){
	SmartyPaginate::setUrl('index.php?cat='.$_GET["cat"]);
	}else{
	
	}
    // display results

	    $smarty->display('index.tpl');	

SmartyPaginate::disconnect();
mysql_close($mysql_link);
?>