RE: vB CMS 4.1.5
I read someone else with the problem. It was titled "Solved" but I didn't see the solution. Then it was reported as a but.
I have the same problem and not sure how to fix it. I have a Widget for, that uses Direct PHP. It works perfectly, if I set "Disable Content Caching" to "Yes". But works one time, if I set it to "No" then requires waiting a refresh interval, before it works again. If I refresh before the interval is up, the execution fails.
The code is for a Featured Photo Widget, for integrating PhotoPost into vB CMS 4.1.5 Front Page.
I'm really not sure there is any point in showing the code, since I know it works when content caching is disabled. But people always ask. Here is the code.
Code:
ob_start();
// I removed some particulars to the path in the line below, but it's set correctly in my code.
require '/path/to/photopost/config-int.php';
// I deleted some password stuff here
$link = mysql_connect ("$dbhost", "$dbuser", "$dbpass") or die('I cannot connect to the database.');
mysql_select_db ("$dbname")or die("Could not 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";
// == END CONFIGURATION ==
////////////////////////////////////////////////////////////////////////////
function pp_get_ext( $filename )
{
return substr($filename, strrpos($filename,"."));
}
function pp_get_filename($filename)
{
return str_replace( pp_get_ext($filename), "", $filename );
}
function pp_is_image( $filename )
{
$mediatypes = array( ".jpg", ".gif", ".png", ".bmp" );
$ext = pp_get_ext( $filename );
if ( in_array(strtolower($ext), $mediatypes) )
{
return( true );
}
return( false );
}
function pp_is_multimedia( $filename )
{
$mediatypes = array( ".avi", ".mov", ".mpg", ".mpeg", ".swf", ".flv" );
$ext = pp_get_ext( $filename );
if ( in_array(strtolower($ext), $mediatypes) )
{
return( true );
}
return( false );
}
$resultc = mysql_query("SELECT setting FROM {$pp_db_prefix}settings WHERE id=133");
list( $seotype ) = mysql_fetch_row($resultc);
$resultd = mysql_query("SELECT setting FROM {$pp_db_prefix}settings WHERE id=6");
list( $data_full ) = mysql_fetch_row($resultd);
//
// Featured Photos Code
// Follow down to End Feature Photos Code
//
switch ($q_switch)
{
case "most_view":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.title,c.catname,c.photos,c.posts
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
WHERE p.storecat = 0
ORDER BY views DESC";
break;
case "latest":
$query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.title,c.catname,c.photos,c.posts
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
WHERE p.storecat = 0
ORDER BY date DESC";
break;
default:
$query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.title,c.catname,c.photos,c.posts
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
WHERE p.storecat = 0
ORDER BY RAND()";
}
$result = mysql_query($query) or die(mysql_error());
$counted = 0;
$countcol = 0;
$pppro_imagebits = null;
while (list($pid,$puser,$puserid,$pcat,$photo,$ptitle,$catname,$cphotos,$cposts) = mysql_fetch_row($result))
{
if ( pp_is_image($photo)|| pp_is_multimedia($photo) )
{
if ( pp_is_image($photo) )
{
if ( $seotype == "seo" )
{
$plink = "<td><a href=\"{$url_path}/$catname/p{$pid}-{$ptitle}.html\"><img src=\"{$data_dir}/{$pcat}/thumbs/$photo\" border=\"0\" alt=\"\" /></a></td>";
$catlink = "<a href=\"{$url_path}/g{$pcat}-{$catname}.html\">$catname</a><br />";
}
else
{
$plink = "<td><a href=\"{$url_path}/showphoto.php?photo={$pid}\"><img src=\"{$data_dir}/{$pcat}/thumbs/$photo\" border=\"0\" alt=\"\" /></a></td>";
$catlink = "<a href=\"{$url_path}/showgallery.php?cat={$pcat}\">$catname</a><br />";
}
}
if ( pp_is_multimedia($photo) )
{
$filenoext = pp_get_filename( $photo );
$mmthumb = "{$data_dir}/$pcat/thumbs/$filenoext.jpg";
$dirthumb = "{$data_full}/$pcat/thumbs/$filenoext.jpg";
if ( !file_exists($dirthumb) )
{
$mmthumb = "{$url_path}/images/video.gif";
}
if ( $seotype == "seo" )
{
$plink = "<td><a href=\"{$url_path}/$catname/p{$pid}-{$ptitle}.html\"><img src=\"{$mmthumb}\" border=\"0\" alt=\"\" /></a></td>";
$catlink = "<a href=\"{$url_path}/g{$pcat}-{$catname}.html\">$catname</a><br />";
}
else
{
$plink = "<td><br /><a href=\"{$url_path}/showphoto.php?photo={$pid}\"><img src=\"{$mmthumb}\" border=\"0\" alt=\"\" /></a></td>";
$catlink = "<a href=\"{$url_path}/showgallery.php?cat={$pcat}\">$catname</a><br />";
}
}
// One box for each feature
$pppro_imagebits .= <<<PPPRINT
<td align="left" class="alt1">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
$plink
</tr>
</table>
<font size="1" face="verdana,arial">by {$puser}<br />
? ? ?<br />
$catlink
$cphotos photos<br />$cposts comments<br /></font>
</td>
PPPRINT;
$counted++;
$countcol++;
}
// If we've reached our limit, quit
if ( $counted == $num_display )
{
break;
}
// If we need to end the column, do so.
if ( $countcol == $columns )
{
$pppro_imagebits .= <<<PPPRINT
</tr>
<tr>
PPPRINT;
$countcol = 0;
}
}
@mysql_free_result($result);
$pppro_imagebits = '<table cellpadding="$stylevar[cellpadding]" cellspacing="1" border="0" width="100%">'.$pppro_imagebits.'</tr></table>';
print "$pppro_imagebits";
$output=ob_get_contents();
ob_end_clean();
Like I said, without "Disable Content Cashing" set to "Yes" the code doesn't work right.
It should display 4 photos, at the top of the Front Page. After 1 refresh, it displays 1 and the right page column drops and goes to the center. It's busted unless I disable content caching.
Is there a fix to this problem?
More Information