Tutorial

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

 
Written By
Tutorial by: Jeremy LeSarge (AKA Ray)

I am the owner and administrator of DialMe.com. I write Tutorials for Boonex Dolphin as well as tips and resources surrounding website programming and development. I enjoy working with WordPress, SEO, and Web Hosting / Servers. I also maintain a WordPress Blog here on this site where you will find a variety of technology and webmaster resources.

Actions
Sponsored Links
Recommend