PugsX Mods

Restrict users viewing

pugsx — Tue, 11 May 2010 17:02:54 +0000

Here is a mod to allow you to set which of your users can view certain videos

1st add the following fields to your database(make backup 1st)
member_profile

Name - restricted_allowed
type - int
length - 1
default - 0

videos

Name - restricted
type - int
length - 1
default - 0

now open up play.php
below

include_once(‘classes/permissions.php’);

add

// restrict code
$r_vid = (int) mysql_real_escape_string($_GET['vid']);
$sql = "SELECT * FROM videos WHERE indexer = $r_vid AND approved ='yes'";
$query = @mysql_query($sql);
$result = @mysql_fetch_array($query);
$restricted = $result['restricted'];
echo "Hey - " . $restricted . "";
if ($restricted == 1){
$r_user_id = $_SESSION['user_id'];
$sql = "SELECT * FROM member_profile WHERE user_id = $r_user_id";
$query = @mysql_query($sql);
$result = @mysql_fetch_array($query);
$restricted_allowed = $result['restricted _allowed'];
echo "Hey - " . $restricted_allowed. "";
echo "Hey - " . $r_user_id. "";
if ($restricted_allowed ==1) {
$proceed = true;
}else{
$proceed = false;
	$error_height = '430px;';
	$message_2 = 'Sorry Not today - You are not allowed to view this clip' ;

	$codes = $codes_internal;
	$error_code = errorcodes($codes);

	// tmp test
	if ( $error_height ==  '' ) {
		if (!empty($error_code)) {
			$blk_notification = $error_code['error_display'];
    			$message_type = $error_code['error_type'];
    			$error_message = $error_code['error_message'];
		}
	}

	$template 		= "themes/$user_theme/templates/main_1.htm";
	$inner_template1 	= "themes/$user_theme/templates/inner_notification.htm";

	$TBS 			= new clsTinyButStrong;
	$TBS->NoErr 	= true;
	$TBS->LoadTemplate("$template");

	$TBS->Render 	= TBS_OUTPUT;
	$TBS->Show();

	@mysql_close();
	die();
}
}

Requests welcome

pugsx — Fri, 07 May 2010 14:48:10 +0000

Hello,
I know its been awhile since I’ve posted anything but had a lot to do changed shifts/roles at work, have a 6 month old little boy, a new house which requires a bit of tlc and a new side project with a mate (links at top of page).

So if theres anything phpmotion related that I can help with post a reply and I’ll let you know if I can help.

Adding Profile Pics to members admin page

pugsx — Sun, 01 Mar 2009 10:36:36 +0000

Backup and open manage.php
find

    $result_featured = array();
    $query = @mysql_query($result_sql);
    while ($result1 = @mysql_fetch_array($query)) {
       //get comments inforation
        $user_id = mysql_real_escape_string($result1['user_id']);

add this straight after

		###pics####
        $member_id = $result1['user_id'];
        $sql11 = "SELECT * FROM pictures WHERE user_id = $member_id AND approved ='yes'";
        $result11 = @mysql_query($sql11);
        if (@mysql_num_rows($result11) == 0) {
            // show place holder for no image uploaded by user at all
            $picture = $config['site_base_url'] . '/image_s/placeholder.png';
            $picture_array = array('picture' => $picture);
        }
        else {
            $results12 = mysql_fetch_array($result11);
            $result11_existing_file = $results12['file_name'];
            $result11_approved = $results12['approved'];
            // show current picture
            $picture = $config['site_base_url'] . '/pictures/' . $result11_existing_file;
            $picture_array = array('picture' => $picture);
        }
		#####

then find this

$result2 = @array_merge($result1,$video_array);

change it to this

$result2 = @array_merge($result1,$video_array,$picture_array);

then in your inner_management.htm file use this code to add the picture

Last login and member since mod

pugsx — Sun, 22 Feb 2009 11:38:08 +0000

This mod will add these 2 stats to your members profile

add the following sql code to your members_profile table

ALTER TABLE `member_profile` ADD `lastlog` VARCHAR( 255 ) NOT NULL

Backup and open memberprofile.php

find

$current_city = wordwrap($result["current_city"],15," ",true);

on the next line add

$lastlog = $result["lastlog"];
$date_created = $result["date_created"];

Save and close memberprofile.php

Backup and open login.php

find

//success login - checkinng if user has confirmed email

add this before that

$lastlog = date('j, n, Y');
$sql = "UPDATE member_profile SET lastlog = '$lastlog' WHERE user_name = '$user_name_login'";
@mysql_query($sql);

Save and close login.php

Backup and open inner_members_profile.htm

Use these 2 variables to add them where you want them

[var.lastlog]
[var.date_created]

Then save inner_members_profile.htm

Congratulations its complete.

General Stats Mod

pugsx — Sat, 21 Feb 2009 11:22:29 +0000

Enter this sql into your database(sql button in phpmyadmin) (backup first)

^?View Code SQL

ALTER TABLE `messages` ADD `message_status` VARCHAR( 20 ) NOT NULL ;
ALTER TABLE `member_profile` ADD `video_viewed` INT( 10 ) NOT NULL DEFAULT '0';
ALTER TABLE `member_profile` ADD `uploaded` INT( 10 ) NOT NULL DEFAULT '0';

Make these changes to your files (backup first)
Open inner_index_2.htm and add this code somewhere where you would like to display the stats

^?View Code HTML






Welcome Back
Welcome back 
New Messages : 
New Friend Requests : 
Videos I've Watched : 
Videos I've uploaded : Some site stats
Total Members : 
New Members Today: 
New Members Yesterday : 
Total Videos : 
Latest Member : 
Watched Videos : 
Online Visitors : ()

open index.php and add this towards the top of the file

^?View Code PHP

//Msg count
$sql2 = "SELECT * FROM messages WHERE to_id = $user_id AND message_status = 'unread'";
$query2 = @mysql_query($sql2);
$msg_num = @mysql_num_rows($query2);
 
//friends requests
$sql2 = "SELECT * FROM friends WHERE invitation_status = 'pending' AND friends_id = $user_id";
$query2 = @mysql_query($sql2);
$mate_req = @mysql_num_rows($query2);
 
//total members
$sql2 = "SELECT * FROM member_profile";
$query2 = @mysql_query($sql2);
$members = @mysql_num_rows($query2);
 
//Total vids
$sql2 = "SELECT * FROM videos WHERE approved='yes'";
$query2 = @mysql_query($sql2);
$tvids = @mysql_num_rows($query2);
 
//vids ive watched
$sql2 = "select video_viewed from member_profile where user_id = $user_id";
$query2 = @mysql_query($sql2);
$row = @mysql_fetch_row($query2);
$myvids = $row[0];
 
//watched vids
$sql2 = "SELECT sum(number_of_views) from videos";
$query2 = @mysql_query($sql2);
$watvid = @mysql_result($query2 , 0);
 
//my vids
$sql2 = "SELECT * FROM videos WHERE user_id = $user_id AND approved='yes'";
$query2 = @mysql_query($sql2);
$nummyvids = @mysql_num_rows($query2);
 
//new members today
$today = $config["date_format"];
$sql2 = "SELECT * FROM member_profile where date_created LIKE '%$today%'";
$query2 = @mysql_query($sql2);
$todaymem = @mysql_num_rows($query2);
 
//yesterday members new
$Yesterday = date("d-m-y",mktime(0,0,0,date("m") ,date("d")-1,date("Y")));
$sql2 = "SELECT * FROM member_profile where date_created LIKE '%$Yesterday%'";
$query2 = @mysql_query($sql2);
$yesdaymem = @mysql_num_rows($query2);
 
//new videos today
$today = $config["date_format"];
$sql2 = "SELECT * FROM videos where date_uploaded LIKE '%$today%'";
$query2 = @mysql_query($sql2);
$todayvids = @mysql_num_rows($query2);
 
//latest mem
$sql2 = "select user_name, user_id from member_profile order by user_id desc";
$query2 = @mysql_query($sql2);
$row = @mysql_fetch_row($query2);
$late_mem = $row[0];
$late_uid = $row[1];
 
//Most viewed video
$sql2 = "SELECT title, MAX(`number_of_views`), indexer FROM `videos` GROUP BY number_of_views DESC LIMIT 1";
$query2 = @mysql_query($sql2);
$row = @mysql_fetch_row($query2);
$mvtitle = $row[0];
$numv = $row[1];
$mvind = $row[2];
 
//Most uploaded
$sql2 = "SELECT user_id, user_name, MAX(`uploaded`) FROM `member_profile` GROUP BY uploaded DESC LIMIT 1";
$query2 = @mysql_query($sql2);
$row = @mysql_fetch_row($query2);
$usrid = $row[0];
$uname = $row[1];
$uup = $row[2];

open emailread.php and find the following

^?View Code PHP

///////////////////////////////////////////
//show message
///////////////////////////////////////////
 
$sql = "SELECT * FROM messages WHERE to_id =$user_id AND indexer = $indexer";
$query = @mysql_query($sql);
$result = @mysql_fetch_array($query);
$message = wordwrap($result['message'], 20, " ", true);
$subject = wordwrap($result['subject'], 20, " ", true);
$email_id= $result['indexer'];

And change it to

^?View Code PHP

///////////////////////////////////////////
//show message
///////////////////////////////////////////
 
$sql = "SELECT * FROM messages WHERE to_id =$user_id AND indexer = $indexer";
$query = @mysql_query($sql);
$result = @mysql_fetch_array($query);
$message = wordwrap($result['message'], 20, " ", true);
$subject = wordwrap($result['subject'], 20, " ", true);
$email_id= $result['indexer'];
 
$sql2 = "UPDATE messages SET message_status = 'read' WHERE to_id =$user_id AND indexer = $indexer";
@mysql_query($sql2);

And open and edit emailcompose.php and find

^?View Code PHP

////////////////
//record message
////////////////
 
$sql = "INSERT into messages (from_username, subject, message, todays_date, to_id) VALUES ('$user_name', '$subject', '$message', '$todays_date', $to_id)";
@mysql_query($sql) or die(header("Location: " . "system_error.php?code=101"));

And change to

^?View Code PHP

 ////////////////
//record message
////////////////
 
$sql = "INSERT into messages (from_username, subject, message, todays_date, to_id, message_status) VALUES ('$user_name', '$subject', '$message', '$todays_date', $to_id, 'unread')";
@mysql_query($sql) or die(header("Location: " . "system_error.php?code=101"));

Open play.php
add

^?View Code PHP

$sql = "UPDATE member_profile SET video_viewed=(video_viewed + 1) WHERE user_id = $user_id";
$query = @mysql_query($sql);

after

^?View Code PHP

$sql = "UPDATE videos SET number_of_views = $views_counter WHERE indexer = $vid";
$query = @mysql_query($sql);

Open uploader_finished.php and add

^?View Code PHP

$sql2 = "UPDATE member_profile SET uploaded=(uploaded + 1) WHERE user_id = $user_id";
@mysql_query($sql2);

After

^?View Code PHP

$sql = "INSERT INTO videos
(video_id, GID, title, description, tags, channel, date_uploaded, location_recorded, video_length, allow_comments, allow_embedding, rating_number_votes,
rating_total_points, updated_rating, public_private, approved, number_of_views, user_id) VALUES ('$uploaded_file_name', '$GID', '$title', '$description', '$tags',
'$channel', '$date_uploaded', '$location_recorded', '0h 0mins', '$allow_comments', '$allow_embedding', 0, 0, 0, '$public_private', 'pending_conversion', 0, $user_id)";
 
@mysql_query($sql);

Open myvideos.php and add

^?View Code PHP

 $sql = "UPDATE member_profile SET uploaded=(uploaded - 1) WHERE user_id = $user_id";
@mysql_query($sql);

After

^?View Code PHP

 //delete from videocomments
$sql = "DELETE FROM videocomments WHERE video_id = $video_id";
@mysql_query($sql);