Maybe you don't use or allow Movies/Videos or you don't want blogs to show up in the list. Perhaps you just want to change the order or sort of rearrange the order they appear. If you don't use or allow Movie/Video uploads it might be a good idea to remove it from showing up in the Site Stats, nobody wants to see a big fat 0 (zeoro) when something isn't even being used.
This is another fast and simple edit for Dolphin 6.1x. You will also need to chmod/permission the file from 666 to 644 so the changes you make are not written back.
Download and backup the original file just in case:
/inc/db_cached/SiteStat.inc
Then open the file in with a text editor like notepad or wordpad and comment out any of the lines you do not want to show in the Site Stats area anymore.
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')
);
Simply comment the line out with // in front of each line you don't want visible like:
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'),
//'pvi'=>array('capt'=>'Videos', 'query'=>'SELECT COUNT(`ID`) FROM `RayMovieFiles` WHERE `Approved`=\'true\'', 'link'=>'video/all/10/1', 'icon'=>'pvi.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'),
//'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'),
'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'),
'tps'=>array('capt'=>'Topics', 'query'=>'SELECT IF( NOT ISNULL( SUM(`forum_topics`)), SUM(`forum_posts`), 0) AS `Num` FROM `pre_forum`', 'link'=>'forums', 'icon'=>'tps.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'=>'forums', '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')
);
And if you want to move them around just move them around to an order you prefer.
Just make sure after each line you have a comma (,) except the very last line no comma(,)
My last 2 lines:
'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')
);
Notice no comma at the end of the Blogs line. If I switched the two around I would need to make sure the last line didn't have the comma and I would need to update the blog line to include a comma at the end now since it is no longer the last line like:
'blg'=>array('capt'=>'Blogs', 'query'=>'SELECT COUNT(*) FROM 'Blogs'', 'link'=>'blogs', 'icon'=>'pts.gif'),
'frs'=>array('capt'=>'Friends', 'query'=>'SELECT COUNT('ID') FROM 'FriendList' WHERE 'Check'=\'1\'', 'link'=>'', 'icon'=>'frs.gif')
);
Then upload your change's back to your host overwriting the original.
And make sure you change the file permission for /inc/db_cached/SiteStat.inc from 666 to 644