42. File Comparison Report

Produced on Wed Jun 18 08:01:46 2008 UTC. This report uses XHTML and CSS2, and is best viewed with a reasonably standards compliant browser such as the latest version of Firefox or Internet Explorer. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.

42.1 Files compared

# Location File Last Modified
1 Dolphin-v.6.1.1\inc\db_cached SiteStat.inc Sun May 11 13:17:00 2008 UTC
2 Dolphin-v.6.1.2\inc\db_cached SiteStat.inc Wed May 28 09:31:21 2008 UTC

42.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 5 36
Changed 4 8
Inserted 0 0
Removed 0 0

42.3 Comparison options

Whitespace All differences in whitespace within lines are ignored
Character case Differences in character case are significant
Line endings Differences in line endings (CR and LF characters) are ignored
CR/LF characters Not shown in the comparison detail

42.4 Active regular expressions

No regular expressions were active.

42.5 Comparison detail

1   return arr ay(    1   return arr ay( 
2   'all'=>arr ay('capt'= >'Members' , 'query'= >'SELECT C OUNT(`ID`)  FROM `Pro files` WHE RE `Status ` = \'Acti ve\' AND ( `Couple`=\ '0\' OR `C ouple`>`ID `)', 'link '=>'browse .php', 'ic on'=>'mbs. gif'),   2   'all'=>arr ay('capt'= >'Members' , 'query'= >'SELECT C OUNT(`ID`)  FROM `Pro files` WHE RE `Status ` = \'Acti ve\' AND ( `Couple`=\ '0\' OR `C ouple`>`ID `)', 'link '=>'browse .php', 'ic on'=>'mbs. gif'),
3   'pph'=>arr ay('capt'= >'Photos',  'query'=> 'SELECT CO UNT(`medID `) FROM `s harePhotoF iles` WHER E `Approve d`=\'true\ '', 'link' =>'photo/a ll/10/1',  'icon'=>'p ph.gif'),   3   'pph'=>arr ay('capt'= >'Photos',  'query'=> 'SELECT CO UNT(`medID `) FROM `s harePhotoF iles` WHER E `Approve d`=\'true\ '', 'link' =>'photo/a ll/10/1',  'icon'=>'p ph.gif'),
4   'evs'=>arr ay('capt'= >'Events',  'query'=> 'SELECT CO UNT(`ID`)  FROM `SDat ingEvents`  WHERE `St atus`=\'Ac tive\'', ' link'=>'ev ents', 'ic on'=>'evs. gif'),   4   'evs'=>arr ay('capt'= >'Events',  'query'=> 'SELECT CO UNT(`ID`)  FROM `SDat ingEvents`  WHERE `St atus`=\'Ac tive\'', ' link'=>'ev ents', 'ic on'=>'evs. gif'),
5   'onl'=>arr ay('capt'= >'Online',  'query'=> 'SELECT CO UNT(`ID`)  AS `count_ onl` FROM  `Profiles`  WHERE `Da teLastNav`  > SUBDATE (NOW(), IN TERVAL 5 M INUTE) AND  (`Couple` =0 OR `Cou ple`>`ID`) ', 'link'= >'search.p hp?online_ only=1', ' icon'=>'mb s.gif'),   5   'onl'=>arr ay('capt'= >'Online',  'query'=> 'SELECT CO UNT(`ID`)  AS `count_ onl` FROM  `Profiles`  WHERE `Da teLastNav`  > SUBDATE (NOW(), IN TERVAL 5 M INUTE) AND  (`Couple` =0 OR `Cou ple`>`ID`) ', 'link'= >'search.p hp?online_ only=1', ' icon'=>'mb s.gif'),
6   'pvi'=>arr ay('capt'= >'Videos',  'query'=> 'SELECT CO UNT(`ID`)  FROM `RayM ovieFiles`  WHERE `Ap proved`=\' true\'', ' link'=>'vi deo/all/10 /1', 'icon '=>'pvi.gi f'),   6   'pvi'=>arr ay('capt'= >'Videos',  'query'=> 'SELECT CO UNT(`ID`)  FROM `RayM ovieFiles`  WHERE `Ap proved`=\' true\'', ' link'=>'vi deo/all/10 /1', 'icon '=>'pvi.gi f'),
7   'pls'=>arr ay('capt'= >'Polls',  'query'=>' SELECT COU NT(`id_pol l`) FROM ` ProfilesPo lls` WHERE  `poll_app roval`=\'1 \'', 'link '=>'polls. php', 'ico n'=>'pls.g if'),   7   'pls'=>arr ay('capt'= >'Polls',  'query'=>' SELECT COU NT(`id_pol l`) FROM ` ProfilesPo lls` WHERE  `poll_app roval`=\'1 \'', 'link '=>'polls. php', 'ico n'=>'pls.g if'),
8   'ntd'=>arr ay('capt'= >'New   Today',   'query'=>' SELECT   COUNT(`ID` )   FROM   `Profiles`   WHERE   `Status`   =   \'Active\'   AND   (TO_DAYS(N OW())   -   TO_DAYS(`D ate LastNav `))   <=   1   AND   (`Couple`= 0   OR   `Couple`>` ID`)',   'link'=>'' ,   'icon'=>'m bs.gif'),   8   'ntd'=>arr ay('capt'= >'New   Today',   'query'=>' SELECT   COUNT(`ID` )   FROM   `Profiles`   WHERE   `Status`   =   \'Active\'   AND   (TO_DAYS(N OW())   -   TO_DAYS(`D ate Reg `))   <=   1   AND   (`Couple`= 0   OR   `Couple`>` ID`)',   'link'=>'' ,   'icon'=>'m bs.gif'),
9   'pmu'=>arr ay('capt'= >'Music',  'query'=>' SELECT COU NT(`ID`) F ROM `RayMu sicFiles`  WHERE `App roved`=\'t rue\'', 'l ink'=>'mus ic/all/10/ 1', 'icon' =>'pmu.gif '),   9   'pmu'=>arr ay('capt'= >'Music',  'query'=>' SELECT COU NT(`ID`) F ROM `RayMu sicFiles`  WHERE `App roved`=\'t rue\'', 'l ink'=>'mus ic/all/10/ 1', 'icon' =>'pmu.gif '),
10   'tps'=>arr ay('capt'= >'Topics',  'query'=> 'SELECT IF ( NOT ISNU LL( SUM(`f orum_topic s`)), SUM( `forum_pos ts`), 0) A S `Num` FR OM `pre_fo rum`', 'li nk'=>'orca ', 'icon'= >'tps.gif' ),   10   'tps'=>arr ay('capt'= >'Topics',  'query'=> 'SELECT IF ( NOT ISNU LL( SUM(`f orum_topic s`)), SUM( `forum_pos ts`), 0) A S `Num` FR OM `pre_fo rum`', 'li nk'=>'orca ', 'icon'= >'tps.gif' ),
11   'nwk'=>arr ay('capt'= >'This   Week',   'query'=>' SELECT   COUNT(`ID` )   FROM   `Profiles`   WHERE   `Status`   =   \'Active\'   AND   (TO_DAYS(N OW())   -   TO_DAYS(`D ate LastNav `))   <=   7   AND   (`Couple`= 0   OR   `Couple`>` ID`)',   'link'=>'' ,   'icon'=>'m bs.gif'),   11   'nwk'=>arr ay('capt'= >'This   Week',   'query'=>' SELECT   COUNT(`ID` )   FROM   `Profiles`   WHERE   `Status`   =   \'Active\'   AND   (TO_DAYS(N OW())   -   TO_DAYS(`D ate Reg `))   <=   7   AND   (`Couple`= 0   OR   `Couple`>` ID`)',   'link'=>'' ,   'icon'=>'m bs.gif'),
12   'pvd'=>arr ay('capt'= >'Profile  Videos', ' query'=>'S ELECT `App roved` FRO M `RayVide oStats`',  'link'=>'' , 'icon'=> 'pvi.gif') ,   12   'pvd'=>arr ay('capt'= >'Profile  Videos', ' query'=>'S ELECT `App roved` FRO M `RayVide oStats`',  'link'=>'' , 'icon'=> 'pvi.gif') ,
13   'pts'=>arr ay('capt'= >'Posts',  'query'=>' SELECT IF(  NOT ISNUL L( SUM(`fo rum_posts` )), SUM(`f orum_posts `), 0) AS  `Num` FROM  `pre_foru m`', 'link '=>'orca',  'icon'=>' pts.gif'),   13   'pts'=>arr ay('capt'= >'Posts',  'query'=>' SELECT IF(  NOT ISNUL L( SUM(`fo rum_posts` )), SUM(`f orum_posts `), 0) AS  `Num` FROM  `pre_foru m`', 'link '=>'orca',  'icon'=>' pts.gif'),
14   'nmh'=>arr ay('capt'= >'This   Month',   'query'=>' SELECT   COUNT(`ID` )   FROM   `Profiles`   WHERE   `Status`   =   \'Active\'   AND   (TO_DAYS(N OW())   -   TO_DAYS(`D ate LastNav `))   <=   30   AND   (`Couple`= 0   OR   `Couple`>` ID`)',   'link'=>'' ,   'icon'=>'m bs.gif'),   14   'nmh'=>arr ay('capt'= >'This   Month',   'query'=>' SELECT   COUNT(`ID` )   FROM   `Profiles`   WHERE   `Status`   =   \'Active\'   AND   (TO_DAYS(N OW())   -   TO_DAYS(`D ate Reg `))   <=   30   AND   (`Couple`= 0   OR   `Couple`>` ID`)',   'link'=>'' ,   'icon'=>'m bs.gif'),
15   'tgs'=>arr ay('capt'= >'Tags', ' query'=>'S ELECT COUN T( DISTINC T `Tag` )  FROM `Tags `', 'link' =>'', 'ico n'=>'tgs.g if'),   15   'tgs'=>arr ay('capt'= >'Tags', ' query'=>'S ELECT COUN T( DISTINC T `Tag` )  FROM `Tags `', 'link' =>'', 'ico n'=>'tgs.g if'),
16   'ars'=>arr ay('capt'= >'Articles ', 'query' =>'SELECT  COUNT(`Art iclesID`)  FROM `Arti cles`', 'l ink'=>'art icles', 'i con'=>'ars .gif'),   16   'ars'=>arr ay('capt'= >'Articles ', 'query' =>'SELECT  COUNT(`Art iclesID`)  FROM `Arti cles`', 'l ink'=>'art icles', 'i con'=>'ars .gif'),
17   'nyr'=>arr ay('capt'= >'This   Year',   'query'=>' SELECT   COUNT(`ID` )   FROM   `Profiles`   WHERE   `Status`   =   \'Active\'   AND   (TO_DAYS(N OW())   -   TO_DAYS(`D ate LastNav `))   <=   365   AND   (`Couple`= 0   OR   `Couple`>` ID`)',   'link'=>'' ,   'icon'=>'m bs.gif'),   17   'nyr'=>arr ay('capt'= >'This   Year',   'query'=>' SELECT   COUNT(`ID` )   FROM   `Profiles`   WHERE   `Status`   =   \'Active\'   AND   (TO_DAYS(N OW())   -   TO_DAYS(`D ate Reg `))   <=   365   AND   (`Couple`= 0   OR   `Couple`>` ID`)',   'link'=>'' ,   'icon'=>'m bs.gif'),
18   'grs'=>arr ay('capt'= >'Groups',  'query'=> 'SELECT CO UNT(`ID`)  FROM `Grou ps` WHERE  `status`=\ 'Active\'' , 'link'=> 'groups/al l', 'icon' =>'grs.gif '),   18   'grs'=>arr ay('capt'= >'Groups',  'query'=> 'SELECT CO UNT(`ID`)  FROM `Grou ps` WHERE  `status`=\ 'Active\'' , 'link'=> 'groups/al l', 'icon' =>'grs.gif '),
19   'cls'=>arr ay('capt'= >'Classifi eds', 'que ry'=>'SELE CT COUNT(` ID`) FROM  `Classifie dsAdvertis ements` WH ERE `Statu s`=\'activ e\' AND DA TE_ADD( `C lassifieds Advertisem ents`.`Dat eTime` , I NTERVAL `C lassifieds Advertisem ents`.`Lif eTime` DAY  ) > NOW(  )', 'link' =>'ads', ' icon'=>'cl s.gif'),   19   'cls'=>arr ay('capt'= >'Classifi eds', 'que ry'=>'SELE CT COUNT(` ID`) FROM  `Classifie dsAdvertis ements` WH ERE `Statu s`=\'activ e\' AND DA TE_ADD( `C lassifieds Advertisem ents`.`Dat eTime` , I NTERVAL `C lassifieds Advertisem ents`.`Lif eTime` DAY  ) > NOW(  )', 'link' =>'ads', ' icon'=>'cl s.gif'),
20   'frs'=>arr ay('capt'= >'Friends' , 'query'= >'SELECT C OUNT(`ID`)  FROM `Fri endList` W HERE `Chec k`=\'1\'',  'link'=>' ', 'icon'= >'frs.gif' ),   20   'frs'=>arr ay('capt'= >'Friends' , 'query'= >'SELECT C OUNT(`ID`)  FROM `Fri endList` W HERE `Chec k`=\'1\'',  'link'=>' ', 'icon'= >'frs.gif' ),
21   'blg'=>arr ay('capt'= >'Blogs',  'query'=>' SELECT COU NT(*) FROM  `Blogs`',  'link'=>' blogs', 'i con'=>'pts .gif')   21   'blg'=>arr ay('capt'= >'Blogs',  'query'=>' SELECT COU NT(*) FROM  `Blogs`',  'link'=>' blogs', 'i con'=>'pts .gif')
22   );   22   );