ucast.upm.edu.my ~ Shell I

Editing file /var/www/groups.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_groups.php');
include_once ('classes/sessions.php');

//include_once ('online.php');
//$loggedin = 2;

$referer = mysql_real_escape_string($_SERVER['HTTP_REFERER']);
$todays_date = $config["date_format"];
$result = array();
$load = mysql_real_escape_string($_GET['load']);
//show main groups page, showing by default biggest groups

if ($load == '') {
    $mygroups = array();
    $which_type = $config["all"];//display 'ALL' in html title

//--------------------------------------------------------------------reusable groups code -------------------------------

//Pagination
    $limit = $config['groups_main_limit'];
    $pagination = pagination("SELECT * FROM group_profile WHERE public_private = 'public' ", $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

//get list of videos
    $sql = "SELECT * FROM group_profile WHERE public_private = 'public' LIMIT $set_limit, $limit";
    $query = @mysql_query($sql);
    while ($result = @mysql_fetch_array($query)) {
        $group_id = $result['indexer'];//count the number of videos the group has
        $sql2 = "SELECT * FROM group_videos WHERE group_id = $group_id AND video_status='active'";
        $query2 = @mysql_query($sql2);
        $count_group_videos = @mysql_num_rows($query2);
        //get video picture and details  --------------------------reusable get video picture----------------
        if ($count_group_videos == 0) {
            $video_picture = 'default_no_group_video';//show place holder image2wbmp
            $group_video_id = 0;
        }
        else {
            $result2 = @mysql_fetch_array($query2);
            $group_video_id = mysql_real_escape_string($result2['video_id']);
            $sql0 = "SELECT * FROM videos WHERE indexer = $group_video_id";
            $query0 = @mysql_query($sql0);
            $result0 = @mysql_fetch_array($query0);
            $group_video_image = $result0['video_id'];
            $video_picture = $result0['video_id'];
            $group_video_id = $result0['indexer'];
        }
        $video_array = array('video_picture' => $video_picture, 'group_video_id' => $group_video_id);
        //----------------------------------------------------------------------------------------------------

//count the number of member the group has
        $sql3 = "SELECT * FROM group_membership WHERE group_id = $group_id";
        $query3 = @mysql_query($sql3);
        $count_group_members = @mysql_num_rows($query3);
        //get groupd admin details
        $sql4 = "SELECT * FROM group_membership WHERE group_id = $group_id AND group_admin = 'yes'";
        $query4 = @mysql_query($sql4);
        $result4 = @mysql_fetch_array($query4);
        $admin_username = $result4['member_username'];
        $admin_id = $result4['member_id'];
        //form array of bits and pieces
        $group_other_info = array('group_videos' => $count_group_videos, 'group_members' =>
            $count_group_members, 'admin_username' => $admin_username, 'admin_id' => $admin_id);
        //merge arrays

$group_array = @array_merge($result, $group_other_info, $video_array);
        $mygroups[] = $group_array;
    }

//set condition for hidding certain blocks (e.g "no emails to list")
    if (empty($mygroups)) {
        $show_v = 1;
    }
    else {
        $show_v = 2;
    }

//check for error codes
    $codes = $_GET['code'];//error codes from anywhere
    $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'];
    }

////////////////////////////////////////////
	//PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
	$url = 'groups.php'; //the url to be put in links - EDIT ME
	$additional_url_variable = '&load=';//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

//display my groups
    $template = "templates/main_1.htm";
    $inner_template1 = "templates/inner_groups_main.htm";
    //middle of page
    $TBS = new clsTinyButStrong;
    $TBS->NoErr = true;
    // no more error message displayed.
    $TBS->LoadTemplate("$template");
    $TBS->MergeBlock('blkfeatured', $mygroups);
    $TBS->Render = TBS_OUTPUT;
    $TBS->Show();

@mysql_close();
    die();
}

//show groups that are featured
/////////////////////////////////

if ($load == 'new') {
    $mygroups = array();
    $which_type = $config["featured"];
    //display 'ALL' in html title

//--------------------------------------------------------------------reusable groups code -------------------------------

//Pagination
    $limit = $config['groups_main_limit'];
    $pagination = pagination("SELECT * FROM group_profile WHERE todays_date = '$todays_date' AND public_private = 'public'",
        $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

//get list of videos
    $sql = "SELECT * FROM group_profile WHERE todays_date = '$todays_date' AND public_private = 'public' LIMIT $set_limit, $limit";
    $query = mysql_query($sql);
    while ($result = mysql_fetch_array($query)) {
        $group_id = $result['indexer'];//count the number of videos the group has
        $sql2 = "SELECT * FROM group_videos WHERE group_id = $group_id AND video_status='active'";
        $query2 = mysql_query($sql2);
        $count_group_videos = mysql_num_rows($query2);
        //get video picture and details  --------------------------reusable get video picture----------------
        if ($count_group_videos == 0) {
            $video_picture = 'default_no_group_video';//show place holder image2wbmp
            $group_video_id = 0;
        }
        else {
            $result2 = mysql_fetch_array($query2);
            $group_video_id = $result2['video_id'];
            $sql0 = "SELECT * FROM videos WHERE indexer = $group_video_id";
            $query0 = mysql_query($sql0);
            $result0 = @mysql_fetch_array($query0);
            $group_video_image = $result0['video_id'];
            $video_picture = $result0['video_id'];
            $group_video_id = $result0['indexer'];
        }
        $video_array = array('video_picture' => $video_picture, 'group_video_id' => $group_video_id);
        //----------------------------------------------------------------------------------------------------

//count the number of member the group has
        $sql3 = "SELECT * FROM group_membership WHERE group_id = $group_id";
        $query3 = mysql_query($sql3);
        $count_group_members = mysql_num_rows($query3);
        //get groupd admin details
        $sql4 = "SELECT * FROM group_membership WHERE group_id = $group_id AND group_admin = 'yes'";
        $query4 = mysql_query($sql4);
        $result4 = mysql_fetch_array($query4);
        $admin_username = $result4['member_username'];
        $admin_id = $result4['member_id'];
        //form array of bits and pieces
        $group_other_info = array('group_videos' => $count_group_videos, 'group_members' =>
            $count_group_members, 'admin_username' => $admin_username, 'admin_id' => $admin_id);
        //merge arrays

$group_array = array_merge($result, $group_other_info, $video_array);
        $mygroups[] = $group_array;
    }

//set condition for hidding certain blocks (e.g "no emails to list")
    if (empty($mygroups)) {
        $show_v = 1;
    }
    else {
        $show_v = 2;
    }

////////////////////////////////////////////
	//PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
	$url = 'groups.php'; //the url to be put in links - EDIT ME
	$additional_url_variable = '&load=new';//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

//display my groups
    $template = "templates/main_1.htm";
    $inner_template1 = "templates/inner_groups_main.htm";
    //middle of page
    $inner_template2 = "templates/inner_blank.htm";// bottom of page
    $TBS = new clsTinyButStrong;
    $TBS->NoErr = true;
    // no more error message displayed.
    $TBS->LoadTemplate("$template");
    $TBS->MergeBlock('blkfeatured', $mygroups);
    $TBS->Render = TBS_OUTPUT;
    $TBS->Show();

@mysql_close();
    die();
}

//show groups that were created today
/////////////////////////////////////

if ($load == 'featured') {
    $mygroups = array();
    $which_type = $config["featured"];
    //display 'ALL' in html title

//--------------------------------------------------------------------reusable groups code -------------------------------

//Pagination
    $limit = $config['groups_main_limit'];
    $pagination = pagination("SELECT * FROM group_profile WHERE featured = 'yes' AND public_private = 'public'", $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

//get list of videos
    $sql = "SELECT * FROM group_profile WHERE featured = 'yes' AND public_private = 'public' LIMIT $set_limit, $limit";
    $query = mysql_query($sql);
    while ($result = mysql_fetch_array($query)) {
        $group_id = $result['indexer'];//count the number of videos the group has
        $sql2 = "SELECT * FROM group_videos WHERE group_id = $group_id AND video_status='active'";
        $query2 = mysql_query($sql2);
        $count_group_videos = mysql_num_rows($query2);
        //get video picture and details  --------------------------reusable get video picture----------------
        if ($count_group_videos == 0) {
            $video_picture = 'default_no_group_video';//show place holder image2wbmp
            $group_video_id = 0;
        }
        else {
            $result2 = mysql_fetch_array($query2);
            $group_video_id = $result2['video_id'];
            $sql0 = "SELECT * FROM videos WHERE indexer = $group_video_id";
            $query0 = mysql_query($sql0);
            $result0 = @mysql_fetch_array($query0);
            $group_video_image = $result0['video_id'];
            $video_picture = $result0['video_id'];
            $group_video_id = $result0['indexer'];
        }
        $video_array = array('video_picture' => $video_picture, 'group_video_id' => $group_video_id);
        //----------------------------------------------------------------------------------------------------

$group_array = array_merge($result, $group_other_info, $video_array);
        $mygroups[] = $group_array;
    }

//set condition for hidding certain blocks (e.g "no emails to list")
    if (empty($mygroups)) {
        $show_v = 1;
    }
    else {
        $show_v = 2;
    }
    //check for error codes
    $codes = $_GET['code'];//error codes from anywhere
    $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'];
    }

////////////////////////////////////////////
	//PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
	$url = 'groups.php'; //the url to be put in links - EDIT ME
	$additional_url_variable = '&load=featured';//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

@mysql_close();
    die();
}