[Aerdan]

Posting with a question: my mySQL is awful, and looking at the xml it seems it would be an easy adjustment: is there a query that would get the same looking result, only it would be from the "Most Recently Updated Albums"? This way if one person uploads a lot from one album, it won't flood it and only prompt one of the values while still maintaining a fresh homepage?

The database has a column "lastpicturedate", so the query should be easy to reproduce, but I'm just not good enough at constructing it to do it myself If would reconstruct from the following block:

  $displayrecords = ($vbulletin->options['afm_sayi'] ? $vbulletin->options['afm_sayi'] : 4);
    switch ($vbulletin->options['afm_dt'])
    {
      case 1: $sorgu = "ORDER BY dateline DESC LIMIT 0, $displayrecords"; break;
      case 2: $sorgu = "ORDER BY rand(NOW()) DESC LIMIT 0, $displayrecords"; break;
    }  
  $lpictures = $db->query("
  SELECT albumpicture.*, album.*, user.username, user.usergroupid,
  IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
  FROM " . TABLE_PREFIX . "albumpicture AS albumpicture
  LEFT JOIN " . TABLE_PREFIX . "album AS album ON(album.albumid = albumpicture.albumid)
  LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = album.userid)
  WHERE album.state = 'public' 
  $sorgu  
  ");

Anyone know how it could be put together? =) Thanks in advance!