Hi,
I like to use the "lastup" statement on the fron page, however it does generate quiet the queryload when it scans the entire pictures table.. I've modified the "Lastup" statement, and it's running very much faster for me now, however i'm not a expert so i wish to know what it was i really removed (features or what not)
This is the original code:
case 'lastup': // Last uploads
if ($META_ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = $lang_meta_album_names['lastup'].' - '. $CURRENT_CAT_NAME;
} else {
$album_name = $lang_meta_album_names['lastup'];
}
$query = "SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' $META_ALBUM_SET";
$result = cpg_db_query($query);
$nbEnr = mysql_fetch_array($result);
$count = $nbEnr[0];
mysql_free_result($result);
//if($select_columns != '*' ) $select_columns .= ',title, caption, owner_id, owner_name, aid';
$select_columns = '*'; //allows building any data into any thumbnail caption
$query = "SELECT $select_columns FROM {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' $META_ALBUM_SET ORDER BY pid DESC $limit";
$result = cpg_db_query($query);
$rowset = cpg_db_fetch_rowset($result);
mysql_free_result($result);
if ($set_caption) build_caption($rowset,array('ctime'));
$rowset = CPGPluginAPI::filter('thumb_caption_lastup',$rowset);
return $rowset;
break;
I've removed this part:
$query = "SELECT COUNT(*) from {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' $META_ALBUM_SET";
$result = cpg_db_query($query);
$nbEnr = mysql_fetch_array($result);
$count = $nbEnr[0];
mysql_free_result($result);
From what i can understand (with no real knowledge of sql or php) this query asks the database table pictures if there's any pictures that are private or not accessible? Then the second query asks to sort by and how many to display.
If this is true, i'm all good, however will i loose any other features then private albums?
Thanks for the help!