[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");