No regular expressions were active.
|
|
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 |
|
);
|