ucast.upm.edu.my ~ Shell I

Editing file /var/www/genre_home.php (0775)

<?php

///////////////////////////////////////////////////////////////////////////////////////
// PHPmotion                                                http://www.phpmotion.com //
///////////////////////////////////////////////////////////////////////////////////////
// License: You are not to sell or distribute this software without permission       //
// Main Author: Brian Shawa -  bshawa@gmail.com                                      //
// Help and support please visit http://www.phpmotion.com                            //
// Copyright reserved                                                                //
///////////////////////////////////////////////////////////////////////////////////////

include_once ("classes/config.php");
include_once ('classes/menu.php');
include_once ('classes/sessions.php');

//////////////////////////////////////
// AUDIO WORDS OVER-RIDE /////////////
// NEED AUDIO WORDS IN CONFIG ////////
$config['word_audios'] = 'Audios';

$tab_switch = 'Genre';
$tab_switch_link = 'genre.php';

//////////////////////////////////////
$codes = $_GET['code'];//error codes from anywhere
$channel = $_GET['cid'];
$limit = $config["search_page_limits"]; // number of video per page

//check if category exists
$channel = mysql_real_escape_string($channel);

$sql1 = "SELECT * FROM genre WHERE has_audio = 'yes' AND channel_name = '$channel'";
$query1 = @mysql_query($sql1);
if (@mysql_num_rows($query1) == 0){
	@mysql_close();
	error_redirect(121);	//"An error has occurred. The item could not be found"
}

///////////////////////////////////////////////////
// get all categories/genre that has an audio file
// we only show categories with content
$all_categories = array();
$sql = "SELECT * FROM genre WHERE has_audio = 'yes' order by channel_name";
$query = @mysql_query($sql);
while ($result = @mysql_fetch_array($query)){
$all_categories[] = $result;
}

//get all category audios
    $pagination = pagination("SELECT * FROM audios WHERE channel = '$channel' AND approved='yes' ORDER BY indexer DESC", $limit);
    $set_limit = $pagination[0]['set_limit'];
    $total_pages = $pagination[0]['total_pages'];
    $current_page = $pagination[0]['current_page'];
    $total_records = $pagination[0]['total_records'];
    $next_page = $pagination[0]['next_page'];//use in html navigation (src)
    $prev_page = $pagination[0]['prev_page'];//use in html navigation (src)
    $nl = $pagination[0]['nl'];//use in html navigation: next>>
    $pl = $pagination[0]['pl'];//use in html navigation: <<previous

$result_featured = array();
$sql = "SELECT * FROM audios WHERE channel = '$channel' AND approved='yes' AND public_private = 'public' ORDER BY indexer DESC LIMIT $set_limit, $limit";
$query = @mysql_query($sql);
while ($result1 = @mysql_fetch_array($query)) {

//get comments information
    $audio_id = $result1['indexer'];
    $sql2 = "SELECT * FROM audiocomments WHERE audio_id = $audio_id";
    $query2 = @mysql_query($sql2);
    $comments_number = @mysql_num_rows($query2);
    $comments_array = array('comments' => $comments_number);

/*
    //get audio rating stars ---reusable -------------------------------------------
	$stars_array = array();
	$stars_array = stars_array($audio_id);
    //------------------------------------------------------------------------------
    */

//get audio rating stars -------------------------------------------------------
    include ('stars_audio_include.php');
    $stars_array = array('star1' => $star1,'star2' => $star2,'star3' => $star3, 'star4' => $star4,'star5' => $star5);
    //------------------------------------------------------------------------------
    //merge comments array and audio array
    $result2 = @array_merge($result1, $comments_array, $stars_array);
    $result_featured[] = $result2;

}

//show "no audios" if none found
if(empty($result_featured)){

$show_v =1;

}

else {
    $show_v = 2;
}

////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'genre_home.php';//the url to be put in links - EDIT ME
    $additional_url_variable = "&cid=$channel";//add addtions information that goes in query string here , e.g. '&load=groups&friends=all' - EDIT ME

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end

//show any errors/notifications
if ($codes == "") {//only if page is not trying to load refer error.

$codes = $codes_internal;
}
$error_code = errorcodes($codes);
if (!empty($error_code)) {
    $blk_code = $error_code['error_display'];
    $code_type = $error_code['error_type'];
    $code_message = $error_code['error_message'];
}
$blk_id = 0;//html table - error block
$template = "templates/main_1.htm";
$inner_template1 = "templates/inner_genre_home.htm";//middle of page
$TBS = new clsTinyButStrong;
$TBS->NoErr = true;// no more error message displayed.
$TBS->LoadTemplate("$template");
$TBS->MergeBlock('blkfeatured',$result_featured);
$TBS->MergeBlock('blk1', $all_categories);
$TBS->Render = TBS_OUTPUT;
$TBS->Show();

@mysql_close();
die();