Photopost Latest uploads in user profile

hi, People,

this plugin will display the latest upload user "x" did in user "x" profile page eg member.php?u=1 (admin) installation is very easy

• download the plugin
• edit the plugin to match your setup (path to PhotoPost and possible login & passwords if you use seperated databases)
• import the plugin in vbulletin
• template modification

template "MEMBERINFO" wherever you want it to appaer for example i have i right under my signature find

<!-- / signature row -->
<br />
</if>

add below

<!--PhotoPost -->
<if condition="$profileimagebits">
<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
<tr>
    <td class="tcat" colspan="$columns">$userinfo[username]'s Latest Gallery Submissions</td>
</tr>
<tr>$profileimagebits</tr>
</table>
<br />
</if>
<!-- PhotoPost end -->

done

[phkk]

if you are using diff database or and database account
delete //

the original of the plug in is
//$link=mysql_connect("localhost","$dbuserid","$dbus erpassword") OR die("I cannot connected to the Database");
//mysql_select_db("products") OR die("failed to select PhotoPost Database");

make them become . delete the // . your forum will connect to your database

$link=mysql_connect("localhost","$dbuserid","$dbus erpassword") OR die("I cannot connected to the Database");
mysql_select_db("products") OR die("failed to select PhotoPost Database");

[bada_bing]

Is there a way to have it display more then one row ? I am showing 3 images so that it will allign with my style correctly but I would like to add two rows and 3 images per row

[glowinggal]

Originally Posted by AsukaValentine

I installed it and obtain this error:

Parse error: parse error, unexpected '<' in /home/bbsdream/public_html/member.php(653) : eval()'d code on line 304


This appears at top of users profile, and I don't modify the MEMBERINFO template yet (only in my test template and it doesn't show anything).

I uninstall the plugin and the error persist.

Some fields on my user profile don't show now.
How can I fix it??

I'm getting this as well this morning and when I disable the module - no more errors so it's definetely related to this.

Here is my members.php coding; HAVE NO IDEA what the issue is... but it's something....

I know FOR CERTAIN that my path is correct..... running PP Gallery database on vbulletin - integrated. No database extension prefix.


Parse error: parse error, unexpected '<' in /home/sbbamy/public_html/chat/member.php(651) : eval()'d code on line 1


****** update to the above issue ******
deleted the plug in and then reinstalled it.... .Now receiving this error. Our PP gallery does not have a prefix (as noted above).


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /member.php(651) : eval()'d code on line 34

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /member.php(651) : eval()'d code on line 86

[glowinggal]

Originally Posted by Delphiprogrammi

check your database config your datase needs a predix i guess

So what happens if PP doesn't a prefix for the database? Is this not useable

[futuredood]

can this be fixed to work with vbgallery? it's pretty much the same file system isn't it, except filenames?

[mcyates]

I'm getting this error:

Warning: mysql_connect(): Access denied for user 'myfootba'@'localhost' (using password: NO) in /member.php(829) : eval()'d code on line 32
I cannot connect to the database.

EVEN though i have entered the username and password for the photopost database. The one at the top and the one at the very bottom.

[LICryptkeeper]

I tried installing it on 3.6.1, installing the plugin breaks member.php I really need this!

[LICryptkeeper]

by breaks, I mean nothing shows up.

I did manage to start playing with some connection settings, and now I get "cannot connect" but I know the paths are correct. I'm not sure if it's a VB issue, version isue, or PP issue.

edit: Now I get "failed to select PhotoPost Database" I changed it from 192.168.1.1(which is the pp database) to localhost, do i need to edit anythign else?

I unccomented out the 2 lines in the mysql connection, and the last line. inside confic_inc.php the database user is $mysql_user and in the plugin it's $dbuserid,

is that correct?
vb3.6.1
pp 5.21

edit 2: moved the gallery into the forum directory, still no go.

$ppath="/home/******/public_html/forums/m_gallery";
require "{$ppath}/config-int.php";
//###################################################################################
//if you use Photopost in a SEPERATED database from vbulletin uncomment these lines
//###################################################################################
$link=mysql_connect("localhost","$dbuserid","$dbuserpassword") OR die("I cannot connected to the Database");
mysql_select_db("products") OR die("failed to select PhotoPost Database");
//####################################################################################

//##############################
// Number of photos to display
$num_display = 4;
//##############################

//#####################################
// Number of columns (1 for vertical)
$columns = 4;
//#####################################

//#####################################################################
// which type of images do you want to show (random, most_view, latest)
$q_switch = "random";
//######################################################################
if(!isset($ViewPerm))
{
	if(isset($vbulletin->userinfo['usergroupid']))
	{
		 $mygroups = $vbulletin->userinfo['usergroupid'];
		 if ($vbulletin->userinfo['membergroupids'] != "") $mygroups .= ",".$vbulletin->userinfo['membergroupids'];
	}
	 $grouparr = explode( ",", $mygroups );
	 $resultb = mysql_query("SELECT id,ugnoview FROM {$pp_db_prefix}categories");
	 $ViewPerm = array();
	 while (list($catugid,$ugnoview)=mysql_fetch_row($resultb))
	{
		 $noview=0; $ViewPerm[$catugid] = 1;
		 $allnoview = explode( ",", $ugnoview );
		 foreach ($allnoview as $key)
		{
			 if (in_array($key,$grouparr))
			{
				  $noview=1;
			}
		}
		if ($noview == 0)
		{
			 $ViewPerm[$catugid]=0;
		}
	}
}
function pp_get_ext($filename)
{
	return substr($filename, strrpos($filename,"."));
}
function pp_is_image( $filename)
{
	$retval = 0;
	$mediatypes = array( ".jpg", ".gif", ".png", ".bmp");
	$ext = pp_get_ext($filename);
	if (in_array(strtolower($ext),$mediatypes)) $retval=1;
	return $retval;
}
switch ($q_switch)
{
	case "latest":
        $query = "SELECT id,user,userid,cat,bigimage,height,width
                        FROM {$pp_db_prefix}photos
                        WHERE storecat = 0 AND userid = $userinfo[userid]
                        ORDER BY date DESC";
		break;
	case "most_view":
        $query = "SELECT id,user,userid,cat,bigimage,height,width
                        FROM {$pp_db_prefix}photos
                        WHERE storecat = 0 AND userid = $userinfo[userid]
                        ORDER BY views DESC";
		break;
	case "random":
        $query = "SELECT id,user,userid,cat,bigimage,height,width
                        FROM {$pp_db_prefix}photos
                        WHERE storecat = 0 AND userid = $userinfo[userid]
                        ORDER BY RAND()";
		break;
}
$result=mysql_query($query);
$counted = 0; $countcol = 0; $profileimagebits = "";
while (list($pid,$puser,$puserid,$pcat,$photo,$height,$width) = mysql_fetch_row($result))
{
	if ( $ViewPerm[$pcat] == 1 ) continue;
	if (pp_is_image($photo))
	{
		 $temp_user = $puserid;
		 if ($height > $width)
			  $mthumb = "<img src=\"{$url_path}/images/overlay-roundp.gif\" height=\"105\" width=\"81\" border=\"0\" alt=\"\" />";
		 else
			 $mthumb = "<img src=\"{$url_path}/images/overlay-round.gif\" height=\"81\" width=\"105\" border=\"0\" alt=\"\" />";
		 $profileimagebits .= <<<PPPRINT
    <td align="center" class="alt1">
        <table cellpadding="0" cellspacing="0" border="0">
         <tr>
          <td style="background: url({$data_dir}{$pcat}/thumbs/$photo); background-color: #000000; background-repeat: no-repeat; background-position: center;"><a href="{$url_path}/showphoto.php?photo={$pid}">$mthumb</a></td>
         </tr>
        </table>
    </td>
PPPRINT;
        $counted++;
        $countcol++;
	}
	if ($counted == $num_display ) break;
	if ($countcol == $columns)
	{
		$profileimagebits .= <<<PPPRINT
    </tr>
    <tr>
PPPRINT;
    $countcol = 0;
	}
}
@mysql_free_result($result);

//###################################################################################################################
//if you use PhotoPost in a SEPERATED database you need to uncomment this line to reselect it
//###################################################################################################################
//mysql_select_db("products") or die("Unable to select PhotoPost Database");

[Delphiprogrammi]

Originally Posted by futuredood

can this be fixed to work with vbgallery? it's pretty much the same file system isn't it, except filenames?

No photopost pro and photopost vbgallerry is a big difference

[Delphiprogrammi]

Originally Posted by mcyates

I'm getting this error:

Warning: mysql_connect(): Access denied for user 'myfootba'@'localhost' (using password: NO) in /member.php(829) : eval()'d code on line 32
I cannot connect to the database.

EVEN though i have entered the username and password for the photopost database. The one at the top and the one at the very bottom.

don't fill in both that error means your MySQL account info is not correct