ucast.upm.edu.my ~ Shell I

Editing file /var/www/i3tube_old/index.php (0755)

<?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');
include_once ('tag_cloud.php');
include_once ('online.php');

$codes = mysql_real_escape_string($_GET['code']);//error codes from anywhere
$proceed = true;

//javascript for carousel
$load_carousel = 
'<script type="text/javascript" src="carousel_files/javascripts/utilities.js"></script>
<link href="carousel_files/carousel.css" rel="stylesheet" type="text/css">';

//START-----------------------

//Get recent videos
$recent = array();
$sql = "SELECT * FROM videos WHERE approved='yes' AND public_private = 'public' ORDER BY indexer DESC LIMIT 10";
$query = @mysql_query($sql);
while ($result1 = mysql_fetch_array($query)) {
    $recent[] = $result1;
}

//get featured videos
$result_featured = array();
$sql = "SELECT * FROM videos WHERE featured = 'yes' AND approved='yes' AND public_private = 'public' ORDER BY indexer DESC LIMIT 10";
$query = @mysql_query($sql);
while ($result1 = @mysql_fetch_array($query)) {

//get comments inforation
    $video_id = mysql_real_escape_string($result1['indexer']);
    $sql2 = "SELECT * FROM videocomments WHERE video_id = $video_id";
    $query2 = @mysql_query($sql2);
    $comments_number = @mysql_num_rows($query2);
    $comments_array = array('comments' => $comments_number);
    //get video rating stars ---reusable -------------------------------------------------------------------------------
    $stars_array = array();
    $stars_array = stars_array($video_id);
    //--------------------------------------------------------------------------------------------------------------------
    //merge comments array and video array
    $result2 = @array_merge($result1, $comments_array, $stars_array);
    $result_featured[] = $result2;
}

//getrandom video to play
  $sql = "SELECT * FROM videos WHERE approved='yes' AND public_private = 'public' ORDER BY RAND() LIMIT 1";
  $query = @mysql_query($sql);
  $result = @mysql_fetch_array($query);
  $video_play = $result['video_id'].'.flv';
  $video_thumb = $result['video_id'].'.jpg';
          
//get some site stats
/////////////////////

//total videos
$sql = "SELECT * FROM videos WHERE approved='yes'";
$video_total = @mysql_num_rows(mysql_query($sql));

//total members
$sql = "SELECT * FROM member_profile";
$members_total = @mysql_num_rows(mysql_query($sql));

//watched vids
$sql = "SELECT sum(number_of_views) from videos";
$result = @mysql_query($sql);
$total_watched = @mysql_result($result , 0);

//latest member
$sql = "select user_name, user_id from member_profile order by user_id desc";
$result = @mysql_query($sql);
$row = @mysql_fetch_row($result);
$newest_user_name = $row[0];
$newest_userid = $row[1];
    
//total comments
$sql = "SELECT * FROM videocomments";
$comments_total = @mysql_num_rows(mysql_query($sql));

//create a list of all users that are online
while ($onlineusers = @mysql_fetch_array($onlinequery)){
	
	//form list with links to users page
	if ($onlineusers['logged_in_username'] != 'guest'){
		$show_online_users = $show_online_users.'<a href="memberprofile.php?uid='.$onlineusers['logged_in_id'].'">'.$onlineusers['logged_in_username'].'&nbsp;&nbsp;&nbsp;</a>';
		}
	}
        
//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_notification = $error_code['error_display'];
    $message_type = $error_code['error_type'];
    $error_message =$error_code['error_message'];
}

//what to display when user logged in
if ($_SESSION["user_id"] != ""){
$template = "templates/main_1.htm";
$inner_template1 = "templates/inner_index.htm";//middle of page
$TBS = new clsTinyButStrong;
$TBS->NoErr = true;// no more error message displayed.
$TBS->LoadTemplate("$template");
$TBS->MergeBlock('mp', $recent);
$TBS->MergeBlock('blkfeatured', $result_featured);
$TBS->Render = TBS_OUTPUT;
$TBS->Show();
@mysql_close();
die();
}

//what to display when not logged - and remove such things as login box
$show_login_box = 1;	
$template = "templates/main_1.htm";
$inner_template1 = "templates/inner_index.htm";//middle of page
$TBS = new clsTinyButStrong;
$TBS->NoErr = true;// no more error message displayed.
$TBS->LoadTemplate("$template");
$TBS->MergeBlock('mp', $recent);
$TBS->MergeBlock('blkfeatured', $result_featured);
$TBS->Render = TBS_OUTPUT;
$TBS->Show();
@mysql_close();
die();