[trafix]

Most popular links
this finds the most played song

PHP Code:

  $mostplayed = $DB_site->query_first("
   SELECT * 
   FROM " . TABLE_PREFIX . "vb_jukebox_trax 
   WHERE active = 1
     ORDER BY plays 
   DESC LIMIT 1
  "); 


Random link

PHP Code:

  $getimage = $DB_site->query_first("
   SELECT * 
   FROM " . TABLE_PREFIX . "vb_jukebox_trax
   WHERE active = 1
   ORDER BY RAND() DESC LIMIT 1
  ");