No regular expressions were active.
1 |
|
<?
|
|
1 |
|
<?
|
2 |
|
|
|
2 |
|
|
3 |
|
/*********
**********
**********
**********
**********
**********
**********
******
|
|
3 |
|
/*********
**********
**********
**********
**********
**********
**********
******
|
4 |
|
*
D
olphin Sma
rt Communi
ty Builder
|
|
4 |
|
*
D
olphin Sma
rt Communi
ty Builder
|
5 |
|
*
---------
--------
|
|
5 |
|
*
---------
--------
|
6 |
|
* begi
n
: M
on Mar 23
2006
|
|
6 |
|
* begi
n
: M
on Mar 23
2006
|
7 |
|
* copy
right
: (
C) 2006 Bo
onEx Group
|
|
7 |
|
* copy
right
: (
C) 2006 Bo
onEx Group
|
8 |
|
* webs
ite
: h
ttp://www.
boonex.com
/
|
|
8 |
|
* webs
ite
: h
ttp://www.
boonex.com
/
|
9 |
|
* This fil
e is part
of Dolphin
- Smart C
ommunity B
uilder
|
|
9 |
|
* This fil
e is part
of Dolphin
- Smart C
ommunity B
uilder
|
10 |
|
*
|
|
10 |
|
*
|
11 |
|
* Dolphin
is free so
ftware. Th
is work is
licensed
under a Cr
eative Com
mons Attri
bution 3.0
License.
|
|
11 |
|
* Dolphin
is free so
ftware. Th
is work is
licensed
under a Cr
eative Com
mons Attri
bution 3.0
License.
|
12 |
|
* http://c
reativecom
mons.org/l
icenses/by
/3.0/
|
|
12 |
|
* http://c
reativecom
mons.org/l
icenses/by
/3.0/
|
13 |
|
*
|
|
13 |
|
*
|
14 |
|
* Dolphin
is distrib
uted in th
e hope tha
t it will
be useful,
but WITHO
UT ANY WAR
RANTY;
|
|
14 |
|
* Dolphin
is distrib
uted in th
e hope tha
t it will
be useful,
but WITHO
UT ANY WAR
RANTY;
|
15 |
|
* without
even the i
mplied war
ranty of
MERCHANTAB
ILITY or F
ITNESS FOR
A PARTICU
LAR PURPOS
E.
|
|
15 |
|
* without
even the i
mplied war
ranty of
MERCHANTAB
ILITY or F
ITNESS FOR
A PARTICU
LAR PURPOS
E.
|
16 |
|
* See the
Creative C
ommons Att
ribution 3
.0 License
for more
details.
|
|
16 |
|
* See the
Creative C
ommons Att
ribution 3
.0 License
for more
details.
|
17 |
|
* You shou
ld have re
ceived a c
opy of the
Creative
Commons At
tribution
3.0 Licens
e along wi
th Dolphin
,
|
|
17 |
|
* You shou
ld have re
ceived a c
opy of the
Creative
Commons At
tribution
3.0 Licens
e along wi
th Dolphin
,
|
18 |
|
* see lice
nse.txt fi
le; if not
, write to
marketing
@boonex.co
m
|
|
18 |
|
* see lice
nse.txt fi
le; if not
, write to
marketing
@boonex.co
m
|
19 |
|
**********
**********
**********
**********
**********
**********
**********
*****/
|
|
19 |
|
**********
**********
**********
**********
**********
**********
**********
*****/
|
20 |
|
|
|
20 |
|
|
21 |
|
require_on
ce( '../in
c/header.i
nc.php' );
|
|
21 |
|
require_on
ce( '../in
c/header.i
nc.php' );
|
22 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'd
esign.inc.
php' );
|
|
22 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'd
esign.inc.
php' );
|
23 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'a
dmin_desig
n.inc.php'
);
|
|
23 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'a
dmin_desig
n.inc.php'
);
|
24 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'u
tils.inc.p
hp' );
|
|
24 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'u
tils.inc.p
hp' );
|
25 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_CLASSES
. 'BxDolGr
oups.php'
);
|
|
25 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_CLASSES
. 'BxDolGr
oups.php'
);
|
26 |
|
|
|
26 |
|
|
27 |
|
$logged['a
dmin'] = m
ember_auth
( 1 );
|
|
27 |
|
$logged['a
dmin'] = m
ember_auth
( 1 );
|
28 |
|
|
|
28 |
|
|
29 |
|
$_page['he
ader'] = '
Groups';
|
|
29 |
|
$_page['he
ader'] = '
Groups';
|
30 |
|
$_page['cs
s_name'] =
'groups.c
ss';
|
|
30 |
|
$_page['cs
s_name'] =
'groups.c
ss';
|
31 |
|
$actionMsg
= '';
|
|
31 |
|
$actionMsg
= '';
|
32 |
|
|
|
32 |
|
|
33 |
|
switch( $_
REQUEST['a
ction'] )
|
|
33 |
|
switch( $_
REQUEST['a
ction'] )
|
34 |
|
{
|
|
34 |
|
{
|
35 |
|
case '
add_cat':
|
|
35 |
|
case '
add_cat':
|
36 |
|
$c
ategName =
trim( $_P
OST['Categ
_Name'] );
|
|
36 |
|
$c
ategName =
trim( $_P
OST['Categ
_Name'] );
|
37 |
|
|
|
37 |
|
|
38 |
|
if
( $categNa
me ) {
|
|
38 |
|
if
( $categNa
me ) {
|
39 |
|
$sPrepNa
me = proce
ss_db_inpu
t($categNa
me);
|
|
39 |
|
$sPrepNa
me = proce
ss_db_inpu
t($categNa
me);
|
40 |
|
$sNewURI
= uriGene
rate($sPre
pName, 'Gr
oupsCateg'
, 'Uri', 2
55);
|
|
40 |
|
$sNewURI
= uriGene
rate($sPre
pName, 'Gr
oupsCateg'
, 'Uri', 2
55);
|
41 |
|
db_res(
"INSERT IN
TO `Groups
Categ` SET
`Name`='{
$sPrepName
}', `Uri`=
'{$sNewURI
}'" );
|
|
41 |
|
db_res(
"INSERT IN
TO `Groups
Categ` SET
`Name`='{
$sPrepName
}', `Uri`=
'{$sNewURI
}'" );
|
42 |
|
$newID =
mysql_ins
ert_id();
|
|
42 |
|
$newID =
mysql_ins
ert_id();
|
43 |
|
if( $new
ID )
|
|
43 |
|
if( $new
ID )
|
44 |
|
$act
ionMsg .=
'Added suc
cesfully';
|
|
44 |
|
$act
ionMsg .=
'Added suc
cesfully';
|
45 |
|
else
|
|
45 |
|
else
|
46 |
|
$act
ionMsg .=
'Some erro
r occured
while addi
ng';
|
|
46 |
|
$act
ionMsg .=
'Some erro
r occured
while addi
ng';
|
47 |
|
}
else
|
|
47 |
|
}
else
|
48 |
|
$actionM
sg .= 'Ple
ase enter
category n
ame';
|
|
48 |
|
$actionM
sg .= 'Ple
ase enter
category n
ame';
|
49 |
|
break;
|
|
49 |
|
break;
|
50 |
|
case '
del_cat':
|
|
50 |
|
case '
del_cat':
|
51 |
|
$c
atID = (in
t)$_GET['c
at'];
|
|
51 |
|
$c
atID = (in
t)$_GET['c
at'];
|
52 |
|
if
( $catID )
{
|
|
52 |
|
if
( $catID )
{
|
53 |
|
db_res(
"DELETE FR
OM `Groups
Categ` WHE
RE `ID`=$c
atID" );
|
|
53 |
|
db_res(
"DELETE FR
OM `Groups
Categ` WHE
RE `ID`=$c
atID" );
|
54 |
|
if( mysq
l_affected
_rows() )
|
|
54 |
|
if( mysq
l_affected
_rows() )
|
55 |
|
$act
ionMsg .=
'Deleted s
uccesfully
';
|
|
55 |
|
$act
ionMsg .=
'Deleted s
uccesfully
';
|
56 |
|
else
|
|
56 |
|
else
|
57 |
|
$act
ionMsg .=
'Couldn\'t
delete';
|
|
57 |
|
$act
ionMsg .=
'Couldn\'t
delete';
|
58 |
|
}
|
|
58 |
|
}
|
59 |
|
break;
|
|
59 |
|
break;
|
60 |
|
case '
edit_cat':
|
|
60 |
|
case '
edit_cat':
|
61 |
|
$c
atID = (in
t)$_REQUES
T['cat'];
|
|
61 |
|
$c
atID = (in
t)$_REQUES
T['cat'];
|
62 |
|
$n
ame = trim
( $_REQUES
T['name']
);
|
|
62 |
|
$n
ame = trim
( $_REQUES
T['name']
);
|
63 |
|
|
|
63 |
|
|
64 |
|
if
( $catID a
nd $name )
{
|
|
64 |
|
if
( $catID a
nd $name )
{
|
65 |
|
db_res(
"UPDATE `G
roupsCateg
` SET `Nam
e`='".proc
ess_db_inp
ut($name).
"' WHERE `
ID`=$catID
" );
|
|
65 |
|
db_res(
"UPDATE `G
roupsCateg
` SET `Nam
e`='".proc
ess_db_inp
ut($name).
"' WHERE `
ID`=$catID
" );
|
66 |
|
if( mysq
l_affected
_rows() )
|
|
66 |
|
if( mysq
l_affected
_rows() )
|
67 |
|
$act
ionMsg .=
'Renamed s
uccesfully
';
|
|
67 |
|
$act
ionMsg .=
'Renamed s
uccesfully
';
|
68 |
|
else
|
|
68 |
|
else
|
69 |
|
$act
ionMsg .=
'Error whi
le renamin
g';
|
|
69 |
|
$act
ionMsg .=
'Error whi
le renamin
g';
|
70 |
|
}
|
|
70 |
|
}
|
71 |
|
break;
|
|
71 |
|
break;
|
72 |
|
case '
suspend_gr
oup':
|
|
72 |
|
case '
suspend_gr
oup':
|
73 |
|
$g
roupID = (
int)$_REQU
EST['group
'];
|
|
73 |
|
$g
roupID = (
int)$_REQU
EST['group
'];
|
74 |
|
|
|
74 |
|
|
75 |
|
if
( $groupID
) {
|
|
75 |
|
if
( $groupID
) {
|
76 |
|
db_res(
"UPDATE `G
roups` SET
`status`=
'Suspended
' WHERE `I
D`=$groupI
D" );
|
|
76 |
|
db_res(
"UPDATE `G
roups` SET
`status`=
'Suspended
' WHERE `I
D`=$groupI
D" );
|
77 |
|
}
|
|
77 |
|
}
|
78 |
|
break;
|
|
78 |
|
break;
|
79 |
|
case '
activate_g
roup':
|
|
79 |
|
case '
activate_g
roup':
|
80 |
|
$g
roupID = (
int)$_REQU
EST['group
'];
|
|
80 |
|
$g
roupID = (
int)$_REQU
EST['group
'];
|
81 |
|
|
|
81 |
|
|
82 |
|
if
( $groupID
) {
|
|
82 |
|
if
( $groupID
) {
|
83 |
|
db_res(
"UPDATE `G
roups` SET
`status`=
'Active' W
HERE `ID`=
$groupID"
);
|
|
83 |
|
db_res(
"UPDATE `G
roups` SET
`status`=
'Active' W
HERE `ID`=
$groupID"
);
|
84 |
|
}
|
|
84 |
|
}
|
85 |
|
break;
|
|
85 |
|
break;
|
86 |
|
}
|
|
86 |
|
}
|
87 |
|
|
|
87 |
|
|
88 |
|
TopCodeAdm
in();
|
|
88 |
|
TopCodeAdm
in();
|
89 |
|
ContentBlo
ckHead("Gr
oups Categ
ories");
|
|
89 |
|
ContentBlo
ckHead("Gr
oups Categ
ories");
|
90 |
|
?>
|
|
90 |
|
?>
|
91 |
|
<div sty
le="color:
green;marg
in:5px aut
o;">
|
|
91 |
|
<div sty
le="color:
green;marg
in:5px aut
o;">
|
92 |
|
<?=$
actionMsg?
>
|
|
92 |
|
<?=$
actionMsg?
>
|
93 |
|
</div>
|
|
93 |
|
</div>
|
94 |
|
|
|
94 |
|
|
95 |
|
<table s
tyle="widt
h:350px;ma
rgin:5px a
uto;border
-collapse:
collapse;"
>
|
|
95 |
|
<table s
tyle="widt
h:350px;ma
rgin:5px a
uto;border
-collapse:
collapse;"
>
|
96 |
|
<?php
|
|
96 |
|
<?php
|
97 |
|
$oGroups =
new BxDol
Groups();
|
|
97 |
|
$oGroups =
new BxDol
Groups();
|
98 |
|
$arrCategs
= $oGroup
s->getGrou
psCategLis
t();
|
|
98 |
|
$arrCategs
= $oGroup
s->getGrou
psCategLis
t();
|
99 |
|
|
|
99 |
|
|
100 |
|
$tr = 'odd
';
|
|
100 |
|
$tr = 'odd
';
|
101 |
|
|
|
101 |
|
|
102 |
|
foreach( $
arrCategs
as $arrCat
eg )
|
|
102 |
|
foreach( $
arrCategs
as $arrCat
eg )
|
103 |
|
{
|
|
103 |
|
{
|
104 |
|
?>
|
|
104 |
|
?>
|
105 |
|
<tr
style="bac
kground:#<
?=( $tr ==
'odd' ? '
DDD' : 'FF
F' )?>;">
|
|
105 |
|
<tr
style="bac
kground:#<
?=( $tr ==
'odd' ? '
DDD' : 'FF
F' )?>;">
|
106 |
|
<td style=
"border:1p
x solid gr
ay;padding
:3px;">
|
|
106 |
|
<td style=
"border:1p
x solid gr
ay;padding
:3px;">
|
107 |
|
<a hre
f="<?="{$_
SERVER['PH
P_SELF']}?
view_cat={
$arrCateg[
'ID']}#vie
w_cat"?>">
<b><?=html
specialcha
rs_adv($ar
rCateg['Na
me'])?></b
></a>
|
|
107 |
|
<a hre
f="<?="{$_
SERVER['PH
P_SELF']}?
view_cat={
$arrCateg[
'ID']}#vie
w_cat"?>">
<b><?=html
specialcha
rs_adv($ar
rCateg['Na
me'])?></b
></a>
|
108 |
|
(<?=$a
rrCateg['g
roupsCount
']?> group
s)
|
|
108 |
|
(<?=$a
rrCateg['g
roupsCount
']?> group
s)
|
109 |
|
</td>
|
|
109 |
|
</td>
|
110 |
|
<td style=
"border:1p
x solid gr
ay;padding
:3px;width
:16px;">
|
|
110 |
|
<td style=
"border:1p
x solid gr
ay;padding
:3px;width
:16px;">
|
111 |
|
<a hre
f="javascr
ipt:void(0
);" onclic
k="if( nam
e = prompt
('Enter ne
w name', '
<?=addslas
hes(htmlsp
ecialchars
($arrCateg
['Name']))
?>') ) { d
ocument.lo
cation='<?
=$_SERVER[
'PHP_SELF'
]?>?action
=edit_cat&
amp;cat=<?
=$arrCateg
['ID']?>&a
mp;name='+
encodeURIC
omponent(n
ame);} ret
urn false;
" title="e
dit"><img
src="image
s/edit.gif
" alt="edi
t" /></a>
|
|
111 |
|
<a hre
f="javascr
ipt:void(0
);" onclic
k="if( nam
e = prompt
('Enter ne
w name', '
<?=addslas
hes(htmlsp
ecialchars
($arrCateg
['Name']))
?>') ) { d
ocument.lo
cation='<?
=$_SERVER[
'PHP_SELF'
]?>?action
=edit_cat&
amp;cat=<?
=$arrCateg
['ID']?>&a
mp;name='+
encodeURIC
omponent(n
ame);} ret
urn false;
" title="e
dit"><img
src="image
s/edit.gif
" alt="edi
t" /></a>
|
112 |
|
</td>
|
|
112 |
|
</td>
|
113 |
|
<td style=
"border:1p
x solid gr
ay;padding
:3px;width
:14px;">
|
|
113 |
|
<td style=
"border:1p
x solid gr
ay;padding
:3px;width
:14px;">
|
114 |
|
<a hre
f="<?=$_SE
RVER['PHP_
SELF']?>?a
ction=del_
cat&ca
t=<?=$arrC
ateg['ID']
?>" title=
"delete" o
nclick="re
turn confi
rm('Are yo
u sure wan
t to delet
e this ima
ge?');"><i
mg src="im
ages/delet
e.gif" alt
="delete"
/></a>
|
|
114 |
|
<a hre
f="<?=$_SE
RVER['PHP_
SELF']?>?a
ction=del_
cat&ca
t=<?=$arrC
ateg['ID']
?>" title=
"delete" o
nclick="re
turn confi
rm('Are yo
u sure wan
t to delet
e this ima
ge?');"><i
mg src="im
ages/delet
e.gif" alt
="delete"
/></a>
|
115 |
|
</td>
|
|
115 |
|
</td>
|
116 |
|
</tr
>
|
|
116 |
|
</tr
>
|
117 |
|
<?php
|
|
117 |
|
<?php
|
118 |
|
$tr =
( $tr == '
odd' ? 'ev
en' : 'odd
' );
|
|
118 |
|
$tr =
( $tr == '
odd' ? 'ev
en' : 'odd
' );
|
119 |
|
}
|
|
119 |
|
}
|
120 |
|
?>
|
|
120 |
|
?>
|
121 |
|
</table>
|
|
121 |
|
</table>
|
122 |
|
<div sty
le="width:
300px;marg
in:5px aut
o;padding:
3px;border
:1px solid
silver;te
xt-align:c
enter;back
ground-col
or:#EEE;">
|
|
122 |
|
<div sty
le="width:
300px;marg
in:5px aut
o;padding:
3px;border
:1px solid
silver;te
xt-align:c
enter;back
ground-col
or:#EEE;">
|
123 |
|
<b>A
dd new cat
egory:</b>
|
|
123 |
|
<b>A
dd new cat
egory:</b>
|
124 |
|
<for
m action="
<?=$_SERVE
R['PHP_SEL
F']?>" met
hod="POST"
>
|
|
124 |
|
<for
m action="
<?=$_SERVE
R['PHP_SEL
F']?>" met
hod="POST"
>
|
125 |
|
<input typ
e="hidden"
name="act
ion" value
="add_cat"
/>
|
|
125 |
|
<input typ
e="hidden"
name="act
ion" value
="add_cat"
/>
|
126 |
|
<input typ
e="text" n
ame="Categ
_Name" sty
le="width:
200px;" />
|
|
126 |
|
<input typ
e="text" n
ame="Categ
_Name" sty
le="width:
200px;" />
|
127 |
|
<input typ
e="submit"
value="Ad
d" />
|
|
127 |
|
<input typ
e="submit"
value="Ad
d" />
|
128 |
|
</fo
rm>
|
|
128 |
|
</fo
rm>
|
129 |
|
</div>
|
|
129 |
|
</div>
|
130 |
|
<?php
|
|
130 |
|
<?php
|
131 |
|
ContentBlo
ckFoot();
|
|
131 |
|
ContentBlo
ckFoot();
|
132 |
|
|
|
132 |
|
|
133 |
|
|
|
133 |
|
|
134 |
|
// if sele
cted categ
ory - view
it's grou
ps.
|
|
134 |
|
// if sele
cted categ
ory - view
it's grou
ps.
|
135 |
|
if( $_REQU
EST['view_
cat'] )
|
|
135 |
|
if( $_REQU
EST['view_
cat'] )
|
136 |
|
{
|
|
136 |
|
{
|
137 |
|
$cat =
(int)$_RE
QUEST['vie
w_cat'];
|
|
137 |
|
$cat =
(int)$_RE
QUEST['vie
w_cat'];
|
138 |
|
|
|
138 |
|
|
139 |
|
$aCate
g = db_arr
( "SELECT
* FROM `Gr
oupsCateg`
WHERE `ID
`=$cat" );
|
|
139 |
|
$aCate
g = db_arr
( "SELECT
* FROM `Gr
oupsCateg`
WHERE `ID
`=$cat" );
|
140 |
|
if( $a
Categ['ID'
] )
|
|
140 |
|
if( $a
Categ['ID'
] )
|
141 |
|
{
|
|
141 |
|
{
|
142 |
|
?>
<a name="v
iew_cat"><
/a><?
|
|
142 |
|
?>
<a name="v
iew_cat"><
/a><?
|
143 |
|
Co
ntentBlock
Head( "Gro
ups of cat
egory &quo
t;" . html
specialcha
rs_adv($aC
ateg['Name
']) . "&qu
ot;" );
|
|
143 |
|
Co
ntentBlock
Head( "Gro
ups of cat
egory &quo
t;" . html
specialcha
rs_adv($aC
ateg['Name
']) . "&qu
ot;" );
|
144 |
|
?>
<div style
="text-ali
gn:right;"
><a href="
#">Top</a>
</div><?
|
|
144 |
|
?>
<div style
="text-ali
gn:right;"
><a href="
#">Top</a>
</div><?
|
145 |
|
|
|
145 |
|
|
146 |
|
|
|
146 |
|
|
147 |
|
$a
GroupsNum
= db_arr(
"SELECT CO
UNT(*) FRO
M `Groups`
WHERE `ca
tegID`=$ca
t" );
|
|
147 |
|
$a
GroupsNum
= db_arr(
"SELECT CO
UNT(*) FRO
M `Groups`
WHERE `ca
tegID`=$ca
t" );
|
148 |
|
$i
GroupsNum
= (int)$aG
roupsNum[0
];
|
|
148 |
|
$i
GroupsNum
= (int)$aG
roupsNum[0
];
|
149 |
|
if
( $iGroups
Num ) // $
iGroupsNum
> 0
|
|
149 |
|
if
( $iGroups
Num ) // $
iGroupsNum
> 0
|
150 |
|
{
|
|
150 |
|
{
|
|
|
151 |
|
$resPerP
age = (int
)$_GET['pe
r_page'];
|
|
|
152 |
|
if( !$re
sPerPage )
|
151 |
|
$resPerP
age = 10;
|
|
153 |
|
$res
PerPage =
10;
|
152 |
|
$pagesNu
m = ceil(
$iGroupsNu
m / $resPe
rPage );
|
|
154 |
|
$pagesNu
m = ceil(
$iGroupsNu
m / $resPe
rPage );
|
153 |
|
$page =
(int)$_REQ
UEST['page
'];
|
|
155 |
|
$page =
(int)$_REQ
UEST['page
'];
|
154 |
|
|
|
156 |
|
|
155 |
|
if( $pag
e < 1 )
|
|
157 |
|
if( $pag
e < 1 )
|
156 |
|
$pag
e = 1;
|
|
158 |
|
$pag
e = 1;
|
157 |
|
if( $pag
e > $pages
Num )
|
|
159 |
|
if( $pag
e > $pages
Num )
|
158 |
|
$pag
e = $pages
Num;
|
|
160 |
|
$pag
e = $pages
Num;
|
159 |
|
|
|
161 |
|
|
160 |
|
$sqlFrom
= ( ( $pa
ge - 1 ) *
$resPerPa
ge );
|
|
162 |
|
$sqlFrom
= ( ( $pa
ge - 1 ) *
$resPerPa
ge );
|
161 |
|
|
|
163 |
|
|
162 |
|
$sQuery
= "
|
|
164 |
|
$sQuery
= "
|
163 |
|
SELE
CT
|
|
165 |
|
SELE
CT
|
164 |
|
`Groups`.*
,
|
|
166 |
|
`Groups`.*
,
|
165 |
|
COUNT( `Gr
oupsMember
s`.`member
ID` ) AS `
membersCou
nt`,
|
|
167 |
|
COUNT( `Gr
oupsMember
s`.`member
ID` ) AS `
membersCou
nt`,
|
166 |
|
`GroupsGal
lery`.`see
d`,
|
|
168 |
|
`GroupsGal
lery`.`see
d`,
|
167 |
|
`GroupsGal
lery`.`ext
` AS `thum
bExt`
|
|
169 |
|
`GroupsGal
lery`.`ext
` AS `thum
bExt`
|
168 |
|
FROM
`Groups`
|
|
170 |
|
FROM
`Groups`
|
169 |
|
LEFT
JOIN `Gro
upsMembers
`
|
|
171 |
|
LEFT
JOIN `Gro
upsMembers
`
|
170 |
|
ON (`Group
sMembers`.
`groupID`
= `Groups`
.`ID` AND
`GroupsMem
bers`.`sta
tus`='Acti
ve')
|
|
172 |
|
ON (`Group
sMembers`.
`groupID`
= `Groups`
.`ID` AND
`GroupsMem
bers`.`sta
tus`='Acti
ve')
|
171 |
|
LEFT
JOIN `Gro
upsGallery
`
|
|
173 |
|
LEFT
JOIN `Gro
upsGallery
`
|
172 |
|
ON (`Group
s`.`thumb`
= `Groups
Gallery`.`
ID`)
|
|
174 |
|
ON (`Group
s`.`thumb`
= `Groups
Gallery`.`
ID`)
|
173 |
|
WHER
E `categID
`=$cat
|
|
175 |
|
WHER
E `categID
`=$cat
|
174 |
|
GROU
P BY `Grou
ps`.`ID` D
ESC
|
|
176 |
|
GROU
P BY `Grou
ps`.`ID` D
ESC
|
175 |
|
LIMI
T $sqlFrom
, $resPerP
age
|
|
177 |
|
LIMI
T $sqlFrom
, $resPerP
age
|
176 |
|
";
|
|
178 |
|
";
|
177 |
|
|
|
179 |
|
|
178 |
|
$resGrou
ps = db_re
s( $sQuery
);
|
|
180 |
|
$resGrou
ps = db_re
s( $sQuery
);
|
179 |
|
|
|
181 |
|
|
180 |
|
$numOnPa
ge = mysql
_num_rows(
$resGroup
s );
|
|
182 |
|
$numOnPa
ge = mysql
_num_rows(
$resGroup
s );
|
181 |
|
$showing
From = $sq
lFrom + 1;
|
|
183 |
|
$showing
From = $sq
lFrom + 1;
|
182 |
|
$showing
To = $sq
lFrom + $n
umOnPage;
|
|
184 |
|
$showing
To = $sq
lFrom + $n
umOnPage;
|
183 |
|
|
|
185 |
|
|
184 |
|
$showing
Results =
"Showing r
esults: <b
>$showingF
rom</b> -
<b>$showin
gTo</b> of
<b>$iGrou
psNum</b>"
;
|
|
186 |
|
$showing
Results =
"Showing r
esults: <b
>$showingF
rom</b> -
<b>$showin
gTo</b> of
<b>$iGrou
psNum</b>"
;
|
185 |
|
|
|
187 |
|
|
186 |
|
if( $pag
esNum > 1
)
|
|
188 |
|
if( $pag
esNum > 1
)
|
187 |
|
{
|
|
189 |
|
{
|
188 |
|
$pagesUrl
=
"{$_SERVER
['PHP_SELF
']}?view_c
at=$cat&
amp;
page={page
}#view_cat
";
|
|
190 |
|
$pagesUrl
=
"{$_SERVER
['PHP_SELF
']}?view_c
at=$cat&
page={page
}#view_cat
";
|
189 |
|
$paginatio
n
=
genPaginat
ion(
$pagesNum,
$page,
$
page
s
U
r
l
);
|
|
191 |
|
//$p
agination
= genPagin
ation( $pa
gesNum, $p
age, $page
sUrl );
|
|
|
192 |
|
|
|
|
193 |
|
$sRe
quest = $_
SERVER['PH
P_SELF'] .
'?';
|
|
|
194 |
|
$aFi
elds = arr
ay( 'actio
n', 'view_
cat' );
|
|
|
195 |
|
|
|
|
196 |
|
fore
ach( $aFie
lds as $vF
ield )
|
|
|
197 |
|
if( isset(
$_GET[$vF
ield] ) )
|
|
|
198 |
|
$sRequ
est .= "&{
$vField}="
. htmlent
ities( pro
cess_pass_
data( $_GE
T[$vField]
) );
|
|
|
199 |
|
|
|
|
200 |
|
$pag
ination =
'<div styl
e="text-al
ign: cente
r; positio
n: relativ
e;">'._t("
_Results p
er page").
':
|
|
|
201 |
|
<selec
t name="pe
r_page" on
change="wi
ndow.locat
ion=\'' .
$sRequest
. '&per_pa
ge=\' + th
is.value;"
>
|
|
|
202 |
|
<o
ption valu
e="10"' .
( $resPerP
age == 10
? ' select
ed="select
ed"' : ''
) . '>10</
option>
|
|
|
203 |
|
<o
ption valu
e="20"' .
( $resPerP
age == 20
? ' select
ed="select
ed"' : ''
) . '>20</
option>
|
|
|
204 |
|
<o
ption valu
e="50"' .
( $resPerP
age == 50
? ' select
ed="select
ed"' : ''
) . '>50</
option>
|
|
|
205 |
|
<o
ption valu
e="100"' .
( $resPer
Page == 10
0 ? ' sele
cted="sele
cted"' : '
' ) . '>10
0</option>
|
|
|
206 |
|
</sele
ct></div>'
.
|
|
|
207 |
|
genPaginat
ion( $page
sNum, $pag
e, $pagesU
rl );
|
|
|
208 |
|
//
genPaginat
ion(
$pagesNum,
$page,
(
$
sRequest
.
'&
page
={page}&pe
r_page='.$
re
s
Pe
r
Page
)
);
|
190 |
|
}
|
|
209 |
|
}
|
191 |
|
else
|
|
210 |
|
else
|
192 |
|
$pag
ination =
'';
|
|
211 |
|
$pag
ination =
'';
|
193 |
|
|
|
212 |
|
|
194 |
|
$sRowTmp
l = file_g
et_content
s("{$dir['
root']}{$a
dmin_dir}/
group_sear
chrow.html
");
|
|
213 |
|
$sRowTmp
l = file_g
et_content
s("{$dir['
root']}{$a
dmin_dir}/
group_sear
chrow.html
");
|
195 |
|
$date_fo
rmat_php =
getParam(
'php_date_
format');
|
|
214 |
|
$date_fo
rmat_php =
getParam(
'php_date_
format');
|
196 |
|
|
|
215 |
|
|
197 |
|
?><div s
tyle="text
-align:cen
ter;"><?=$
pagination
?></div><?
|
|
216 |
|
?><div s
tyle="text
-align:cen
ter;"><?=$
pagination
?></div><?
|
198 |
|
?><div s
tyle="text
-align:cen
ter;"><?=$
showingRes
ults?></di
v><?
|
|
217 |
|
?><div s
tyle="text
-align:cen
ter;"><?=$
showingRes
ults?></di
v><?
|
199 |
|
|
|
218 |
|
|
200 |
|
?>
|
|
219 |
|
?>
|
201 |
|
<div
style="bo
rder:1px s
olid #CCC;
margin:5px
;position:
relative;p
adding:3px
;">
|
|
220 |
|
<div
style="bo
rder:1px s
olid #CCC;
margin:5px
;position:
relative;p
adding:3px
;">
|
202 |
|
<?php
|
|
221 |
|
<?php
|
203 |
|
while( $
arrGroup =
mysql_fet
ch_assoc(
$resGroups
) )
|
|
222 |
|
while( $
arrGroup =
mysql_fet
ch_assoc(
$resGroups
) )
|
204 |
|
{
|
|
223 |
|
{
|
205 |
|
$aRo
wTmpl = ar
ray();
|
|
224 |
|
$aRo
wTmpl = ar
ray();
|
206 |
|
|
|
225 |
|
|
207 |
|
if (
$arrGroup
['thumb']
and file_e
xists($oGr
oups->sGrp
GalPath .
"{$arrGrou
p['ID']}_{
$arrGroup[
'thumb']}_
{$arrGroup
['seed']}_
.{$arrGrou
p['thumbEx
t']}" ) )
|
|
226 |
|
if (
$arrGroup
['thumb']
and file_e
xists($oGr
oups->sGrp
GalPath .
"{$arrGrou
p['ID']}_{
$arrGroup[
'thumb']}_
{$arrGroup
['seed']}_
.{$arrGrou
p['thumbEx
t']}" ) )
|
208 |
|
$groupImag
eUrl = "{$
site['grou
ps_gallery
']}{$arrGr
oup['ID']}
_{$arrGrou
p['thumb']
}_{$arrGro
up['seed']
}_.{$arrGr
oup['thumb
Ext']}";
|
|
227 |
|
$groupImag
eUrl = "{$
site['grou
ps_gallery
']}{$arrGr
oup['ID']}
_{$arrGrou
p['thumb']
}_{$arrGro
up['seed']
}_.{$arrGr
oup['thumb
Ext']}";
|
209 |
|
else
|
|
228 |
|
else
|
210 |
|
$groupImag
eUrl = "{$
site['grou
ps_gallery
']}no_pic.
gif";
|
|
229 |
|
$groupImag
eUrl = "{$
site['grou
ps_gallery
']}no_pic.
gif";
|
211 |
|
|
|
230 |
|
|
212 |
|
|
|
231 |
|
|
213 |
|
if(
(int)$arrG
roup['hidd
en_group']
)
|
|
232 |
|
if(
(int)$arrG
roup['hidd
en_group']
)
|
214 |
|
$typeHelp
= 7;
|
|
233 |
|
$typeHelp
= 7;
|
215 |
|
else
|
|
234 |
|
else
|
216 |
|
if( (int)$
arrGroup['
open_join'
] )
|
|
235 |
|
if( (int)$
arrGroup['
open_join'
] )
|
217 |
|
$typeH
elp = 5;
|
|
236 |
|
$typeH
elp = 5;
|
218 |
|
else
|
|
237 |
|
else
|
219 |
|
$typeH
elp = 6;
|
|
238 |
|
$typeH
elp = 6;
|
220 |
|
|
|
239 |
|
|
221 |
|
$typ
eHelpLink
= "{$site[
'url']}gro
ups_help.p
hp?i=$type
Help";
|
|
240 |
|
$typ
eHelpLink
= "{$site[
'url']}gro
ups_help.p
hp?i=$type
Help";
|
222 |
|
|
|
241 |
|
|
223 |
|
if(
$arrGroup[
'status']
== 'Active
' )
|
|
242 |
|
if(
$arrGroup[
'status']
== 'Active
' )
|
224 |
|
{
|
|
243 |
|
{
|
225 |
|
$statusAct
= 'suspen
d_group';
|
|
244 |
|
$statusAct
= 'suspen
d_group';
|
226 |
|
$statusAct
Title = 'S
uspend';
|
|
245 |
|
$statusAct
Title = 'S
uspend';
|
227 |
|
}
|
|
246 |
|
}
|
228 |
|
else
|
|
247 |
|
else
|
229 |
|
{
|
|
248 |
|
{
|
230 |
|
$statusAct
= 'activa
te_group';
|
|
249 |
|
$statusAct
= 'activa
te_group';
|
231 |
|
$statusAct
Title = 'A
ctivate';
|
|
250 |
|
$statusAct
Title = 'A
ctivate';
|
232 |
|
}
|
|
251 |
|
}
|
233 |
|
|
|
252 |
|
|
234 |
|
$aRo
wTmpl['gro
up_type_he
lp'] = '<a
href="'.$
typeHelpLi
nk.'" targ
et="_blank
" onclick=
"window.op
en(this.hr
ef,\'helpw
in\',\'wid
th=350,hei
ght=200\')
;return fa
lse;" >Hel
p</a>';
|
|
253 |
|
$aRo
wTmpl['gro
up_type_he
lp'] = '<a
href="'.$
typeHelpLi
nk.'" targ
et="_blank
" onclick=
"window.op
en(this.hr
ef,\'helpw
in\',\'wid
th=350,hei
ght=200\')
;return fa
lse;" >Hel
p</a>';
|
235 |
|
|
|
254 |
|
|
236 |
|
$aRo
wTmpl['thu
mbnail']
= "<div
class=\"g
roup_thumb
\"><a href
=\"{$site[
'url']}gro
up.php?ID=
{$arrGroup
['ID']}\">
<img src=\
"{$groupIm
ageUrl}\"
/></a></di
v>";
|
|
255 |
|
$aRo
wTmpl['thu
mbnail']
= "<div
class=\"g
roup_thumb
\"><a href
=\"{$site[
'url']}gro
up.php?ID=
{$arrGroup
['ID']}\">
<img src=\
"{$groupIm
ageUrl}\"
/></a></di
v>";
|
237 |
|
$aRo
wTmpl['gro
up_name']
= "<a h
ref=\"{$si
te['url']}
group.php?
ID={$arrGr
oup['ID']}
\">".htmls
pecialchar
s_adv( $ar
rGroup['Na
me'] )."</
a>";
|
|
256 |
|
$aRo
wTmpl['gro
up_name']
= "<a h
ref=\"{$si
te['url']}
group.php?
ID={$arrGr
oup['ID']}
\">".htmls
pecialchar
s_adv( $ar
rGroup['Na
me'] )."</
a>";
|
238 |
|
$aRo
wTmpl['gro
up_about']
= htmls
pecialchar
s_adv( $ar
rGroup['Ab
out'] );
|
|
257 |
|
$aRo
wTmpl['gro
up_about']
= htmls
pecialchar
s_adv( $ar
rGroup['Ab
out'] );
|
239 |
|
$aRo
wTmpl['mem
bers_count
'] = $arrG
roup['memb
ersCount']
;
|
|
258 |
|
$aRo
wTmpl['mem
bers_count
'] = $arrG
roup['memb
ersCount']
;
|
240 |
|
$aRo
wTmpl['cre
ated']
= date(
$date_for
mat_php, s
trtotime(
$arrGroup[
'created']
) );
|
|
259 |
|
$aRo
wTmpl['cre
ated']
= date(
$date_for
mat_php, s
trtotime(
$arrGroup[
'created']
) );
|
241 |
|
$aRo
wTmpl['gro
up_type']
= ( ( (
int)$arrGr
oup['open_
join'] and
!(int)$ar
rGroup['hi
dden_group
'] ) ? 'Pu
blic group
' : 'Priva
te group'
);
|
|
260 |
|
$aRo
wTmpl['gro
up_type']
= ( ( (
int)$arrGr
oup['open_
join'] and
!(int)$ar
rGroup['hi
dden_group
'] ) ? 'Pu
blic group
' : 'Priva
te group'
);
|
242 |
|
$aRo
wTmpl['cou
ntry']
= _t( $
aPreValues
['Country'
][ $arrGro
up['Countr
y'] ]['LKe
y'] );
|
|
261 |
|
$aRo
wTmpl['cou
ntry']
= _t( $
aPreValues
['Country'
][ $arrGro
up['Countr
y'] ]['LKe
y'] );
|
243 |
|
$aRo
wTmpl['cit
y']
= htmls
pecialchar
s_adv( $ar
rGroup['Ci
ty'] );
|
|
262 |
|
$aRo
wTmpl['cit
y']
= htmls
pecialchar
s_adv( $ar
rGroup['Ci
ty'] );
|
244 |
|
$aRo
wTmpl['sta
tus']
= $arrG
roup['stat
us'];
|
|
263 |
|
$aRo
wTmpl['sta
tus']
= $arrG
roup['stat
us'];
|
245 |
|
$aRo
wTmpl['sta
tus_color'
] = ( $ar
rGroup['st
atus'] ==
'Active' ?
'green' :
'red' );
|
|
264 |
|
$aRo
wTmpl['sta
tus_color'
] = ( $ar
rGroup['st
atus'] ==
'Active' ?
'green' :
'red' );
|
246 |
|
|
|
265 |
|
|
247 |
|
$aRo
wTmpl['sta
tus_action
'] = "<a h
ref=\"{$_S
ERVER['PHP
_SELF']}?a
ction=$sta
tusAct&
;group={$a
rrGroup['I
D']}&v
iew_cat=$c
at&pag
e=$page#vi
ew_cat\" o
nclick=\"r
eturn conf
irm('Are y
ou sure wa
nt to $sta
tusActTitl
e this gro
up?');\">$
statusActT
itle</a>";
|
|
266 |
|
$aRo
wTmpl['sta
tus_action
'] = "<a h
ref=\"{$_S
ERVER['PHP
_SELF']}?a
ction=$sta
tusAct&
;group={$a
rrGroup['I
D']}&v
iew_cat=$c
at&pag
e=$page#vi
ew_cat\" o
nclick=\"r
eturn conf
irm('Are y
ou sure wa
nt to $sta
tusActTitl
e this gro
up?');\">$
statusActT
itle</a>";
|
248 |
|
|
|
267 |
|
|
249 |
|
|
|
268 |
|
|
250 |
|
$sRo
w = $sRowT
mpl;
|
|
269 |
|
$sRo
w = $sRowT
mpl;
|
251 |
|
fore
ach( $aRow
Tmpl as $w
hat => $to
)
|
|
270 |
|
fore
ach( $aRow
Tmpl as $w
hat => $to
)
|
252 |
|
$sRow = st
r_replace(
"__{$what
}__", $to,
$sRow );
|
|
271 |
|
$sRow = st
r_replace(
"__{$what
}__", $to,
$sRow );
|
253 |
|
|
|
272 |
|
|
254 |
|
echo
$sRow;
|
|
273 |
|
echo
$sRow;
|
255 |
|
}
|
|
274 |
|
}
|
256 |
|
?>
|
|
275 |
|
?>
|
257 |
|
</di
v>
|
|
276 |
|
</di
v>
|
258 |
|
<?
|
|
277 |
|
<?
|
259 |
|
|
|
278 |
|
|
260 |
|
?><div s
tyle="text
-align:cen
ter;"><?=$
showingRes
ults?></di
v><?
|
|
279 |
|
?><div s
tyle="text
-align:cen
ter;"><?=$
showingRes
ults?></di
v><?
|
261 |
|
?><div s
tyle="text
-align:cen
ter;"><?=$
pagination
?></div><?
|
|
280 |
|
?><div s
tyle="text
-align:cen
ter;"><?=$
pagination
?></div><?
|
262 |
|
}
|
|
281 |
|
}
|
263 |
|
el
se
|
|
282 |
|
el
se
|
264 |
|
{
|
|
283 |
|
{
|
265 |
|
?>
|
|
284 |
|
?>
|
266 |
|
<div
style="te
xt-align:c
enter;font
-weight:bo
ld;padding
:20px;">
|
|
285 |
|
<div
style="te
xt-align:c
enter;font
-weight:bo
ld;padding
:20px;">
|
267 |
|
Sorry, no
groups fou
nd in this
category
|
|
286 |
|
Sorry, no
groups fou
nd in this
category
|
268 |
|
</di
v>
|
|
287 |
|
</di
v>
|
269 |
|
<?
|
|
288 |
|
<?
|
270 |
|
}
|
|
289 |
|
}
|
271 |
|
|
|
290 |
|
|
272 |
|
?>
<div style
="text-ali
gn:right;"
><a href="
#">Top</a>
</div><?
|
|
291 |
|
?>
<div style
="text-ali
gn:right;"
><a href="
#">Top</a>
</div><?
|
273 |
|
Co
ntentBlock
Foot();
|
|
292 |
|
Co
ntentBlock
Foot();
|
274 |
|
}
|
|
293 |
|
}
|
275 |
|
}
|
|
294 |
|
}
|
276 |
|
BottomCode
();
|
|
295 |
|
BottomCode
();
|
277 |
|
|
|
296 |
|
|
278 |
|
?>
|
|
297 |
|
?>
|