return array( 'all'=>array('capt'=>'Members', 'query'=>'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = \'Active\' AND (`Couple`=\'0\' OR `Couple`>`ID`)', 'link'=>'browse.php', 'icon'=>'mbs.gif'), 'pph'=>array('capt'=>'Photos', 'query'=>'SELECT COUNT(`medID`) FROM `sharePhotoFiles` WHERE `Approved`=\'true\'', 'link'=>'photo/all/10/1', 'icon'=>'pph.gif'), 'evs'=>array('capt'=>'Events', 'query'=>'SELECT COUNT(`ID`) FROM `SDatingEvents` WHERE `Status`=\'Active\'', 'link'=>'events', 'icon'=>'evs.gif'), 'onl'=>array('capt'=>'Online', 'query'=>'SELECT COUNT(`ID`) AS `count_onl` FROM `Profiles` WHERE `DateLastNav` > SUBDATE(NOW(), INTERVAL 5 MINUTE) AND (`Couple`=0 OR `Couple`>`ID`)', 'link'=>'search.php?online_only=1', 'icon'=>'mbs.gif'), 'pvi'=>array('capt'=>'Videos', 'query'=>'SELECT COUNT(`ID`) FROM `RayMovieFiles` WHERE `Approved`=\'true\'', 'link'=>'video/all/10/1', 'icon'=>'pvi.gif'), 'pls'=>array('capt'=>'Polls', 'query'=>'SELECT COUNT(`id_poll`) FROM `ProfilesPolls` WHERE `poll_approval`=\'1\'', 'link'=>'polls.php', 'icon'=>'pls.gif'), 'ntd'=>array('capt'=>'New Today', 'query'=>'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = \'Active\' AND (TO_DAYS(NOW()) - TO_DAYS(`DateReg`)) <= 1 AND (`Couple`=0 OR `Couple`>`ID`)', 'link'=>'', 'icon'=>'mbs.gif'), 'pmu'=>array('capt'=>'Music', 'query'=>'SELECT COUNT(`ID`) FROM `RayMusicFiles` WHERE `Approved`=\'true\'', 'link'=>'music/all/10/1', 'icon'=>'pmu.gif'), 'tps'=>array('capt'=>'Topics', 'query'=>'SELECT IF( NOT ISNULL( SUM(`forum_topics`)), SUM(`forum_posts`), 0) AS `Num` FROM `pre_forum`', 'link'=>'orca', 'icon'=>'tps.gif'), 'nwk'=>array('capt'=>'This Week', 'query'=>'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = \'Active\' AND (TO_DAYS(NOW()) - TO_DAYS(`DateReg`)) <= 7 AND (`Couple`=0 OR `Couple`>`ID`)', 'link'=>'', 'icon'=>'mbs.gif'), 'pvd'=>array('capt'=>'Profile Videos', 'query'=>'SELECT `Approved` FROM `RayVideoStats`', 'link'=>'', 'icon'=>'pvi.gif'), 'pts'=>array('capt'=>'Posts', 'query'=>'SELECT IF( NOT ISNULL( SUM(`forum_posts`)), SUM(`forum_posts`), 0) AS `Num` FROM `pre_forum`', 'link'=>'orca', 'icon'=>'pts.gif'), 'nmh'=>array('capt'=>'This Month', 'query'=>'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = \'Active\' AND (TO_DAYS(NOW()) - TO_DAYS(`DateReg`)) <= 30 AND (`Couple`=0 OR `Couple`>`ID`)', 'link'=>'', 'icon'=>'mbs.gif'), 'tgs'=>array('capt'=>'Tags', 'query'=>'SELECT COUNT( DISTINCT `Tag` ) FROM `Tags`', 'link'=>'', 'icon'=>'tgs.gif'), 'ars'=>array('capt'=>'Articles', 'query'=>'SELECT COUNT(`ArticlesID`) FROM `Articles`', 'link'=>'articles', 'icon'=>'ars.gif'), 'nyr'=>array('capt'=>'This Year', 'query'=>'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = \'Active\' AND (TO_DAYS(NOW()) - TO_DAYS(`DateReg`)) <= 365 AND (`Couple`=0 OR `Couple`>`ID`)', 'link'=>'', 'icon'=>'mbs.gif'), 'grs'=>array('capt'=>'Groups', 'query'=>'SELECT COUNT(`ID`) FROM `Groups` WHERE `status`=\'Active\'', 'link'=>'groups/all', 'icon'=>'grs.gif'), 'cls'=>array('capt'=>'Classifieds', 'query'=>'SELECT COUNT(`ID`) FROM `ClassifiedsAdvertisements` WHERE `Status`=\'active\' AND DATE_ADD( `ClassifiedsAdvertisements`.`DateTime` , INTERVAL `ClassifiedsAdvertisements`.`LifeTime` DAY ) > NOW( )', 'link'=>'ads', 'icon'=>'cls.gif'), 'frs'=>array('capt'=>'Friends', 'query'=>'SELECT COUNT(`ID`) FROM `FriendList` WHERE `Check`=\'1\'', 'link'=>'', 'icon'=>'frs.gif'), 'blg'=>array('capt'=>'Blogs', 'query'=>'SELECT COUNT(*) FROM `Blogs`', 'link'=>'blogs', 'icon'=>'pts.gif') );