Quote:
Originally Posted by The M.I.P.
photopostpal.php isn't part of original vBulletin - contact the author of this script for support.
Check the SQL query some lines before ($result=...), the problem seems to start there.
@Third party developers:
If using this product in your scripts, make sure the init_startup hook exists (required for the calls to the view_ad function plugin).
|
I understand but photopost says the same "we can't help because you're using a hack"
Maybe you can help, this is before/after the problem lines in the file:
Code:
$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;
Code:
$query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.height,p.width,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 c.cattype = 'c' AND p.cat != 500 AND p.storecat = 0
ORDER BY RAND()";
}
$result = mysql_query($query);
$counted = 0; $countcol = 0; $featured = "";
while (list($pid,$puser,$puserid,$pcat,$photo,$height,$width,$catname,$cphotos,$cposts) = mysql_fetch_row($result)) {
if ( $ViewPerm[$pcat] == 1 ) continue;
Any clue?