212. File Comparison Report

Produced on Mon May 12 13:05:13 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.

212.1 Files compared

# Location File Last Modified
1 Mon May 12 13:05:13 2008 UTC
2 Dolphin-v.6.1.0\inc\db_cached SiteStat.inc Sun Apr 27 07:29:24 2008 UTC

212.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 0 0
Changed 0 0
Inserted 1 22
Removed 0 0

212.3 Comparison options

Whitespace
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

212.4 Active regular expressions

No regular expressions were active.

212.5 Comparison detail

    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'),
    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'),
    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'),
    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 Toda y', 'query '=>'SELECT  COUNT(`ID `) FROM `P rofiles` W HERE `Stat us` = \'Ac tive\' AND  (TO_DAYS( NOW()) - T O_DAYS(`Da teLastNav` )) <= 1 AN D (`Couple `=0 OR `Co uple`>`ID` )', 'link' =>'', 'ico n'=>'mbs.g if'),
    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' ),
    11   'nwk'=>arr ay('capt'= >'This Wee k', 'query '=>'SELECT  COUNT(`ID `) FROM `P rofiles` W HERE `Stat us` = \'Ac tive\' AND  (TO_DAYS( NOW()) - T O_DAYS(`Da teLastNav` )) <= 7 AN D (`Couple `=0 OR `Co uple`>`ID` )', 'link' =>'', 'ico n'=>'mbs.g if'),
    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'),
    14   'nmh'=>arr ay('capt'= >'This Mon th', 'quer y'=>'SELEC T COUNT(`I D`) FROM ` Profiles`  WHERE `Sta tus` = \'A ctive\' AN D (TO_DAYS (NOW()) -  TO_DAYS(`D ateLastNav `)) <= 30  AND (`Coup le`=0 OR ` Couple`>`I D`)', 'lin k'=>'', 'i con'=>'mbs .gif'),
    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'),
    17   'nyr'=>arr ay('capt'= >'This Yea r', 'query '=>'SELECT  COUNT(`ID `) FROM `P rofiles` W HERE `Stat us` = \'Ac tive\' AND  (TO_DAYS( NOW()) - T O_DAYS(`Da teLastNav` )) <= 365  AND (`Coup le`=0 OR ` Couple`>`I D`)', 'lin k'=>'', 'i con'=>'mbs .gif'),
    18   'grs'=>arr ay('capt'= >'Groups',  'query'=> 'SELECT CO UNT(`ID`)  FROM `Grou ps` WHERE  `status`=\ 'Active\'' , 'link'=> 'grp.php',  '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\'', 'lin k'=>'ads',  'icon'=>' cls.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')
    22   );