No regular expressions were active.
1 |
|
<?php
|
|
|
2 |
|
|
|
|
3 |
|
/*********
**********
**********
**********
**********
**********
**********
******
|
|
|
4 |
|
*
D
olphin Sma
rt Communi
ty Builder
|
|
|
5 |
|
*
---------
--------
|
|
|
6 |
|
* begi
n
: M
on Mar 23
2006
|
|
|
7 |
|
* copy
right
: (
C) 2006 Bo
onEx Group
|
|
|
8 |
|
* webs
ite
: h
ttp://www.
boonex.com
/
|
|
|
9 |
|
* This fil
e is part
of Dolphin
- Smart C
ommunity B
uilder
|
|
|
10 |
|
*
|
|
|
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/
|
|
|
13 |
|
*
|
|
|
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.
|
|
|
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
,
|
|
|
18 |
|
* see lice
nse.txt fi
le; if not
, write to
marketing
@boonex.co
m
|
|
|
19 |
|
**********
**********
**********
**********
**********
**********
**********
*****/
|
|
|
20 |
|
|
|
|
21 |
|
require_on
ce( '../in
c/header.i
nc.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 . 'p
rofiles.in
c.php' );
|
|
|
24 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'p
rofile_dis
p.inc.php'
);
|
|
|
25 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 's
haring.inc
.php' );
|
|
|
26 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'a
dmin_desig
n.inc.php'
);
|
|
|
27 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_INC . 'u
tils.inc.p
hp' );
|
|
|
28 |
|
|
|
|
29 |
|
$_page['ex
tra_js'] =
'';
|
|
|
30 |
|
|
|
|
31 |
|
$logged[ad
min] = mem
ber_auth(
1 );
|
|
|
32 |
|
$ADMIN = $
logged[adm
in];
|
|
|
33 |
|
|
|
|
34 |
|
$_page['cs
s_name']
= 'bro
wse.css';
|
|
|
35 |
|
|
|
|
36 |
|
|
|
|
37 |
|
$_page['he
ader'] = "
Browse Mus
ic";
|
|
|
38 |
|
$_page['he
ader_text'
] = "Brows
e Music";
|
|
|
39 |
|
|
|
|
40 |
|
$_ni = $_p
age['name_
index'];
|
|
|
41 |
|
|
|
|
42 |
|
$sType= 'M
usic';
|
|
|
43 |
|
|
|
|
44 |
|
if (isset(
$_POST['Ch
eck']) &&
is_array(
$_POST['Ch
eck']))
|
|
|
45 |
|
{
|
|
|
46 |
|
foreac
h($_POST['
Check'] as
$iKey =>
$iVal)
|
|
|
47 |
|
{
|
|
|
48 |
|
sw
itch (true
)
|
|
|
49 |
|
{
|
|
|
50 |
|
case iss
et($_POST[
'Delete'])
:
|
|
|
51 |
|
dele
teMedia((i
nt)$iVal,
$sType);
|
|
|
52 |
|
brea
k;
|
|
|
53 |
|
case iss
et($_POST[
'Approve']
):
|
|
|
54 |
|
appr
oveMedia((
int)$iVal,
$sType);
|
|
|
55 |
|
brea
k;
|
|
|
56 |
|
}
|
|
|
57 |
|
}
|
|
|
58 |
|
}
|
|
|
59 |
|
|
|
|
60 |
|
$aWhere =
array();
|
|
|
61 |
|
|
|
|
62 |
|
$aWhere[]
= '1';
|
|
|
63 |
|
|
|
|
64 |
|
if (isset(
$_GET['use
rID']))
|
|
|
65 |
|
{
|
|
|
66 |
|
$iUser
= (int)$_
GET['userI
D'];
|
|
|
67 |
|
$aWher
e[] = "`a`
.`medProfI
d`=$iUser"
;
|
|
|
68 |
|
}
|
|
|
69 |
|
|
|
|
70 |
|
if (isset(
$_GET['tag
']))
|
|
|
71 |
|
{
|
|
|
72 |
|
$sTag
= htmlspec
ialchars_a
dv($_GET['
tag']);
|
|
|
73 |
|
$aWher
e[] = "`a`
.`medTags`
like '%$s
Tag%'";
|
|
|
74 |
|
}
|
|
|
75 |
|
|
|
|
76 |
|
$sqlWhere
= "WHERE "
. implode
( ', ', $a
Where );
|
|
|
77 |
|
|
|
|
78 |
|
$iTotalNum
= db_valu
e( "SELECT
COUNT( *
) FROM `Ra
y".$sType.
"Files` AS
`a` $sqlW
here" );
|
|
|
79 |
|
if( !$iTot
alNum )
|
|
|
80 |
|
$sCode
.= '<div>
There is n
o files</d
iv>';
|
|
|
81 |
|
|
|
|
82 |
|
$iPerPage
= 10;
|
|
|
83 |
|
$iTotalPag
es = ceil(
$iTotalNu
m / $iPerP
age );
|
|
|
84 |
|
|
|
|
85 |
|
$iCurPage
= (int)$_G
ET['page']
;
|
|
|
86 |
|
|
|
|
87 |
|
if( $iCurP
age > $iTo
talPages )
|
|
|
88 |
|
$iCurP
age = $iTo
talPages;
|
|
|
89 |
|
|
|
|
90 |
|
if( $iCurP
age < 1 )
|
|
|
91 |
|
$iCurP
age = 1;
|
|
|
92 |
|
|
|
|
93 |
|
$sLimitFro
m = ( $iCu
rPage - 1
) * $iPerP
age;
|
|
|
94 |
|
|
|
|
95 |
|
$sqlOrder
= " ORDER
BY `medDat
e` DESC ";
|
|
|
96 |
|
$sqlLimit
= "LIMIT $
sLimitFrom
, $iPerPag
e";
|
|
|
97 |
|
|
|
|
98 |
|
$sQuery =
"
|
|
|
99 |
|
SELECT
|
|
|
100 |
|
`a
`.`ID` as
`medID`,
|
|
|
101 |
|
`a
`.`Owner`
as `medPro
fId`,
|
|
|
102 |
|
`a
`.`Title`
as `medTit
le`,
|
|
|
103 |
|
`a
`.`Date` a
s `medDate
`,
|
|
|
104 |
|
`a
`.`Listens
` as `medL
istens`,
|
|
|
105 |
|
`a
`.`Approve
d`,
|
|
|
106 |
|
`b
`.`NickNam
e`
|
|
|
107 |
|
FROM `
Ray".$sTyp
e."Files`
as `a`
|
|
|
108 |
|
LEFT J
OIN `Profi
les` as `b
` ON
|
|
|
109 |
|
`b
`.`ID` = `
a`.`Owner`
|
|
|
110 |
|
$sqlWh
ere
|
|
|
111 |
|
$sqlOr
der
|
|
|
112 |
|
$sqlLi
mit
|
|
|
113 |
|
";
|
|
|
114 |
|
|
|
|
115 |
|
$rData = d
b_res($sQu
ery);
|
|
|
116 |
|
|
|
|
117 |
|
TopCodeAdm
in();
|
|
|
118 |
|
ContentBlo
ckHead("Li
st of musi
c files");
|
|
|
119 |
|
|
|
|
120 |
|
echo brows
eCode();
|
|
|
121 |
|
|
|
|
122 |
|
ContentBlo
ckFoot();
|
|
|
123 |
|
BottomCode
();
|
|
|
124 |
|
|
|
|
125 |
|
function b
rowseCode(
)
|
|
|
126 |
|
{
|
|
|
127 |
|
global
$site;
|
|
|
128 |
|
global
$rData;
|
|
|
129 |
|
global
$iTotalPa
ges;
|
|
|
130 |
|
global
$iCurPage
;
|
|
|
131 |
|
|
|
|
132 |
|
$sCode
= '<div i
d = "brows
eMain">';
|
|
|
133 |
|
|
|
|
134 |
|
$sCode
.= '<form
method="p
ost" actio
n="'.$_SER
VER['PHP_S
ELF'].'">'
;
|
|
|
135 |
|
|
|
|
136 |
|
if (my
sql_num_ro
ws($rData)
)
|
|
|
137 |
|
{
|
|
|
138 |
|
wh
ile ($aDat
a = mysql_
fetch_arra
y($rData))
|
|
|
139 |
|
{
|
|
|
140 |
|
$sStyle
= $aData['
Approved']
== 'true'
? ' style
="border:
2px solid
#00CC00;"'
: ' style
="border:
2px solid
#CC0000;"'
;
|
|
|
141 |
|
$sProf =
'<a href=
"'.$site['
url'].'pro
file_edit.
php?ID='.$
aData['med
ProfId'].'
">'.$aData
['NickName
'].'</a>';
|
|
|
142 |
|
$sCode .
= '<div cl
ass="brows
eUnit"'.$s
Style.'>';
|
|
|
143 |
|
$sCo
de .= '<di
v class="b
rowseCheck
box"><inpu
t type="ch
eckbox" na
me="Check[
]" value="
'.$aData['
medID'].'"
></div>';
|
|
|
144 |
|
$sCo
de .= '<di
v class="l
astFilesPi
c"><img sr
c="'.$site
['url_admi
n'].'image
s/music.pn
g"></div>'
;
|
|
|
145 |
|
$sCo
de .= '<di
v class="b
rowseInfo"
><div><a h
ref="'.$si
te['url'].
'viewMusic
.php?fileI
D='.$aData
['medID'].
'"><b>'.$a
Data['medT
itle'].'</
b></a></di
v>';
|
|
|
146 |
|
$sCo
de .= '<di
v>'._t("_A
dded").':
<b>'.defin
eTimeInter
val($aData
['medDate'
]).'</b> b
y '.$sProf
.'</div>';
|
|
|
147 |
|
$sCo
de .= '<di
v>'._t("_P
laybacks")
.': <b>'.$
aData['med
Listens'].
'</b></div
></div>';
|
|
|
148 |
|
$sCode .
= '</div>'
;
|
|
|
149 |
|
}
|
|
|
150 |
|
}
|
|
|
151 |
|
else
|
|
|
152 |
|
{
|
|
|
153 |
|
$s
Code .= '<
div>There
are no fil
es</div>';
|
|
|
154 |
|
}
|
|
|
155 |
|
$sCode
.= '</div
>';
|
|
|
156 |
|
$sCode
.= '<div
class="cle
ar_both"><
/div>';
|
|
|
157 |
|
$sCode
.= '<div
class="bot
tomPart"><
input type
="submit"
name="Dele
te" value=
"Delete"><
input type
="submit"
name="Appr
ove" value
="Change s
tatus"></d
iv>';
|
|
|
158 |
|
|
|
|
159 |
|
// gen
erate pagi
nation
|
|
|
160 |
|
if( $i
TotalPages
> 1)
|
|
|
161 |
|
{
|
|
|
162 |
|
$s
Request =
$_SERVER['
PHP_SELF']
. '?page=
{page}';
|
|
|
163 |
|
$a
Fields = a
rray( 'use
rID', 'tag
' );
|
|
|
164 |
|
|
|
|
165 |
|
fo
reach( $aF
ields as $
field )
|
|
|
166 |
|
if( isse
t( $_GET[$
field] ) )
|
|
|
167 |
|
$sRe
quest .= "
&{$field}=
" . htmlen
tities( pr
ocess_pass
_data( $_G
ET[$field]
) );
|
|
|
168 |
|
|
|
|
169 |
|
$p
agination
= '<div st
yle="text-
align:cent
er;">' . g
enPaginati
on( $iTota
lPages, $i
CurPage, $
sRequest )
. '</div>
';
|
|
|
170 |
|
}
|
|
|
171 |
|
else
|
|
|
172 |
|
$p
agination
= '';
|
|
|
173 |
|
|
|
|
174 |
|
return
$sCode .
$paginatio
n.'</form>
';
|
|
|
175 |
|
}
|
|
|
176 |
|
|
|
|
177 |
|
?>
|
|
|