PHP
//------------------------------------------------
// Get new pictures in albums
//------------------------------------------------
$result = $DB->query("SELECT *
FROM " . DB_PREFIX . "pictures as p
WHERE dateadded > $timeframe AND member_id IN ($friend_ids)
ORDER BY dateadded DESC LIMIT 50");
PHP
//------------------------------------------------
// Get new pictures in albums
//------------------------------------------------
$result = $DB->query("SELECT p.*
FROM " . DB_PREFIX . "pictures as p, " . DB_PREFIX . "albums as a
WHERE p.dateadded > $timeframe AND p.member_id IN ($friend_ids) AND p.album_id=a.album_id AND a.password = ''
ORDER BY dateadded DESC LIMIT 50");
Comments
godyn
so it's not for your mod you write a while a go?
radioact
db3204
Log in to leave a comment