No regular expressions were active.
1 |
|
<?php
|
|
1 |
|
<?php
|
2 |
|
|
|
2 |
|
|
3 |
|
define( 'B
X_DOL_TABL
E_MEDIA',
'`media`'
);
|
|
3 |
|
define( 'B
X_DOL_TABL
E_MEDIA',
'`media`'
);
|
4 |
|
|
|
4 |
|
|
5 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_CLASSES
. 'BxDolDb
.php' );
|
|
5 |
|
require_on
ce( BX_DIR
ECTORY_PAT
H_CLASSES
. 'BxDolDb
.php' );
|
6 |
|
|
|
6 |
|
|
7 |
|
class BxDo
lMediaQuer
y extends
BxDolDb
|
|
7 |
|
class BxDo
lMediaQuer
y extends
BxDolDb
|
8 |
|
{
|
|
8 |
|
{
|
9 |
|
var $o
Db;
|
|
9 |
|
var $o
Db;
|
10 |
|
|
|
10 |
|
|
11 |
|
functi
on BxDolMe
diaQuery()
|
|
11 |
|
functi
on BxDolMe
diaQuery()
|
12 |
|
{
|
|
12 |
|
{
|
13 |
|
pa
rent::BxDo
lDb();
|
|
13 |
|
pa
rent::BxDo
lDb();
|
14 |
|
}
|
|
14 |
|
}
|
15 |
|
|
|
15 |
|
|
16 |
|
|
|
16 |
|
|
17 |
|
functi
on getMedi
aArray( $i
ProfileID,
$sMediaTy
pe, &$oDol
Voting )
|
|
17 |
|
functi
on getMedi
aArray( $i
ProfileID,
$sMediaTy
pe, &$oDol
Voting )
|
18 |
|
{
|
|
18 |
|
{
|
19 |
|
$a
SqlVoting
= $oDolVot
ing -> get
SqlParts(B
X_DOL_TABL
E_MEDIA, '
`med_id`')
;
|
|
19 |
|
$a
SqlVoting
= $oDolVot
ing -> get
SqlParts(B
X_DOL_TABL
E_MEDIA, '
`med_id`')
;
|
20 |
|
$s
Query = "
|
|
20 |
|
$s
Query = "
|
21 |
|
SELECT
|
|
21 |
|
SELECT
|
22 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
`,
|
|
22 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
`,
|
23 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id`,
|
|
23 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id`,
|
24 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe`,
|
|
24 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe`,
|
25 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_fi
le`,
|
|
25 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_fi
le`,
|
26 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ti
tle`,
|
|
26 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ti
tle`,
|
27 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus`,
|
|
27 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus`,
|
28 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_da
te`,
|
|
28 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_da
te`,
|
|
|
29 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`rate_a
ble`,
|
29 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pri
mPhoto`
|
|
30 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pri
mPhoto`
|
30 |
|
{$aS
qlVoting['
fields']}
|
|
31 |
|
{$aS
qlVoting['
fields']}
|
31 |
|
FROM
|
|
32 |
|
FROM
|
32 |
|
" .
BX_DOL_TAB
LE_MEDIA .
"
|
|
33 |
|
" .
BX_DOL_TAB
LE_MEDIA .
"
|
33 |
|
INNER JO
IN " . BX_
DOL_TABLE_
PROFILES .
" ON " .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id` = "
. BX_DOL_
TABLE_PROF
ILES . ".`
ID`
|
|
34 |
|
INNER JO
IN " . BX_
DOL_TABLE_
PROFILES .
" ON " .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id` = "
. BX_DOL_
TABLE_PROF
ILES . ".`
ID`
|
34 |
|
{$aSqlVo
ting['join
']}
|
|
35 |
|
{$aSqlVo
ting['join
']}
|
35 |
|
WHERE
|
|
36 |
|
WHERE
|
36 |
|
`med
_prof_id`
= '$iProfi
leID'
|
|
37 |
|
`med
_prof_id`
= '$iProfi
leID'
|
37 |
|
AND `med
_type` = '
$sMediaTyp
e'
|
|
38 |
|
AND `med
_type` = '
$sMediaTyp
e'
|
38 |
|
ORDER BY
`med_date
` ASC
|
|
39 |
|
ORDER BY
`med_date
` ASC
|
39 |
|
";
|
|
40 |
|
";
|
40 |
|
|
|
41 |
|
|
41 |
|
re
turn $this
-> getAll
( $sQuery
);
|
|
42 |
|
re
turn $this
-> getAll
( $sQuery
);
|
42 |
|
}
|
|
43 |
|
}
|
43 |
|
|
|
44 |
|
|
44 |
|
functi
on getActi
veMediaArr
ay( $iProf
ileID, $sM
ediaType,
&$oDolVoti
ng )
|
|
45 |
|
functi
on getActi
veMediaArr
ay( $iProf
ileID, $sM
ediaType,
&$oDolVoti
ng )
|
45 |
|
{
|
|
46 |
|
{
|
46 |
|
$a
SqlVoting
= $oDolVot
ing -> get
SqlParts(B
X_DOL_TABL
E_MEDIA, '
`med_id`')
;
|
|
47 |
|
$a
SqlVoting
= $oDolVot
ing -> get
SqlParts(B
X_DOL_TABL
E_MEDIA, '
`med_id`')
;
|
47 |
|
$s
Query = "
|
|
48 |
|
$s
Query = "
|
48 |
|
SELECT
|
|
49 |
|
SELECT
|
49 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
`,
|
|
50 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
`,
|
50 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id`,
|
|
51 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id`,
|
51 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe`,
|
|
52 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe`,
|
52 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_fi
le`,
|
|
53 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_fi
le`,
|
53 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ti
tle`,
|
|
54 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ti
tle`,
|
54 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus`,
|
|
55 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus`,
|
55 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_da
te`,
|
|
56 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_da
te`,
|
56 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pri
mPhoto`
|
|
57 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pri
mPhoto`
|
57 |
|
{$aS
qlVoting['
fields']}
|
|
58 |
|
{$aS
qlVoting['
fields']}
|
58 |
|
FROM
|
|
59 |
|
FROM
|
59 |
|
" .
BX_DOL_TAB
LE_MEDIA .
"
|
|
60 |
|
" .
BX_DOL_TAB
LE_MEDIA .
"
|
60 |
|
INNER JO
IN " . BX_
DOL_TABLE_
PROFILES .
" ON " .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id` = "
. BX_DOL_
TABLE_PROF
ILES . ".`
ID`
|
|
61 |
|
INNER JO
IN " . BX_
DOL_TABLE_
PROFILES .
" ON " .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id` = "
. BX_DOL_
TABLE_PROF
ILES . ".`
ID`
|
61 |
|
{$aSqlVo
ting['join
']}
|
|
62 |
|
{$aSqlVo
ting['join
']}
|
62 |
|
WHERE
|
|
63 |
|
WHERE
|
63 |
|
`med
_prof_id`
= '$iProfi
leID'
|
|
64 |
|
`med
_prof_id`
= '$iProfi
leID'
|
64 |
|
AND " .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus` = 'a
ctive'
|
|
65 |
|
AND " .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus` = 'a
ctive'
|
65 |
|
AND `med
_type` = '
$sMediaTyp
e'
|
|
66 |
|
AND `med
_type` = '
$sMediaTyp
e'
|
66 |
|
ORDER BY
`med_date
` ASC
|
|
67 |
|
ORDER BY
`med_date
` ASC
|
67 |
|
";
|
|
68 |
|
";
|
68 |
|
|
|
69 |
|
|
69 |
|
re
turn $this
-> getAll
( $sQuery
);
|
|
70 |
|
re
turn $this
-> getAll
( $sQuery
);
|
70 |
|
}
|
|
71 |
|
}
|
71 |
|
|
|
72 |
|
|
72 |
|
functi
on setPrim
aryPhoto(
$iProfileI
D, $iPhoto
ID )
|
|
73 |
|
functi
on setPrim
aryPhoto(
$iProfileI
D, $iPhoto
ID )
|
73 |
|
{
|
|
74 |
|
{
|
74 |
|
$i
ProfileID
= (int)$iP
rofileID;
|
|
75 |
|
$i
ProfileID
= (int)$iP
rofileID;
|
75 |
|
$i
PhotoID =
(int)$iPho
toID;
|
|
76 |
|
$i
PhotoID =
(int)$iPho
toID;
|
76 |
|
|
|
77 |
|
|
77 |
|
$s
Query = "
|
|
78 |
|
$s
Query = "
|
78 |
|
UPDATE "
. BX_DOL_
TABLE_PROF
ILES . " S
ET `PrimPh
oto` = '$i
PhotoID',
`Picture`
= '1' WHER
E `ID` = '
$iProfileI
D' LIMIT 1
|
|
79 |
|
UPDATE "
. BX_DOL_
TABLE_PROF
ILES . " S
ET `PrimPh
oto` = '$i
PhotoID',
`Picture`
= '1' WHER
E `ID` = '
$iProfileI
D' LIMIT 1
|
79 |
|
";
|
|
80 |
|
";
|
80 |
|
|
|
81 |
|
|
81 |
|
$t
his -> que
ry($sQuery
);
|
|
82 |
|
$t
his -> que
ry($sQuery
);
|
82 |
|
}
|
|
83 |
|
}
|
|
|
84 |
|
|
|
|
85 |
|
functi
on setRabl
ePhoto( $i
PhotoID )
{
|
|
|
86 |
|
$i
PhotoID =
(int)$iPho
toID;
|
|
|
87 |
|
$s
Query = "
|
|
|
88 |
|
UPDATE "
. BX_DOL_
TABLE_MEDI
A . " SET
`rate_able
` = IF(`ra
te_able`='
1','0','1'
) WHERE `m
ed_id` = '
{$iPhotoID
}' LIMIT 1
|
|
|
89 |
|
";
|
|
|
90 |
|
$t
his -> que
ry($sQuery
);
|
|
|
91 |
|
}
|
|
|
92 |
|
|
83 |
|
functi
on resetPr
imPhoto( $
iProfileId
)
|
|
93 |
|
functi
on resetPr
imPhoto( $
iProfileId
)
|
84 |
|
{
|
|
94 |
|
{
|
85 |
|
$s
Query = "
|
|
95 |
|
$s
Query = "
|
86 |
|
UPDATE "
. BX_DOL_
TABLE_PROF
ILES . " S
ET `PrimPh
oto` = '0'
, `Picture
` = '0' WH
ERE `ID` =
'$iProfil
eId' LIMIT
1
|
|
96 |
|
UPDATE "
. BX_DOL_
TABLE_PROF
ILES . " S
ET `PrimPh
oto` = '0'
, `Picture
` = '0' WH
ERE `ID` =
'$iProfil
eId' LIMIT
1
|
87 |
|
";
|
|
97 |
|
";
|
88 |
|
$t
his -> que
ry( $sQuer
y );
|
|
98 |
|
$t
his -> que
ry( $sQuer
y );
|
89 |
|
}
|
|
99 |
|
}
|
90 |
|
|
|
100 |
|
|
91 |
|
functi
on insertM
edia( $iPr
ofileID, $
sMediaType
, $sFileNa
me, $sFile
Title, $sF
ileStatus
= 'passive
' )
|
|
101 |
|
functi
on insertM
edia( $iPr
ofileID, $
sMediaType
, $sFileNa
me, $sFile
Title, $sF
ileStatus
= 'passive
' )
|
92 |
|
{
|
|
102 |
|
{
|
93 |
|
$s
FileTitle
= addslash
es( $sFile
Title );
|
|
103 |
|
$s
FileTitle
= addslash
es( $sFile
Title );
|
94 |
|
$s
Query = "
|
|
104 |
|
$s
Query = "
|
95 |
|
INSERT I
NTO " . BX
_DOL_TABLE
_MEDIA . "
|
|
105 |
|
INSERT I
NTO " . BX
_DOL_TABLE
_MEDIA . "
|
96 |
|
SET
|
|
106 |
|
SET
|
97 |
|
`med
_prof_id`
= '$iProfi
leID',
|
|
107 |
|
`med
_prof_id`
= '$iProfi
leID',
|
98 |
|
`med
_type` = '
$sMediaTyp
e',
|
|
108 |
|
`med
_type` = '
$sMediaTyp
e',
|
99 |
|
`med
_file` = '
$sFileName
',
|
|
109 |
|
`med
_file` = '
$sFileName
',
|
100 |
|
`med
_title` =
'$sFileTit
le',
|
|
110 |
|
`med
_title` =
'$sFileTit
le',
|
101 |
|
`med
_status` =
'$sFileSt
atus',
|
|
111 |
|
`med
_status` =
'$sFileSt
atus',
|
102 |
|
`med
_date` = N
OW()
|
|
112 |
|
`med
_date` = N
OW()
|
103 |
|
";
|
|
113 |
|
";
|
104 |
|
|
|
114 |
|
|
105 |
|
re
turn $this
-> query(
$sQuery )
;
|
|
115 |
|
re
turn $this
-> query(
$sQuery )
;
|
106 |
|
}
|
|
116 |
|
}
|
107 |
|
|
|
117 |
|
|
108 |
|
functi
on getVide
oArray( $i
ProfileId
)
|
|
118 |
|
functi
on getVide
oArray( $i
ProfileId
)
|
109 |
|
{
|
|
119 |
|
{
|
110 |
|
|
|
120 |
|
|
111 |
|
|
|
121 |
|
|
112 |
|
$s
Query = "
|
|
122 |
|
$s
Query = "
|
113 |
|
SELECT
|
|
123 |
|
SELECT
|
114 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
`,
|
|
124 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
`,
|
115 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id`,
|
|
125 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id`,
|
116 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe`,
|
|
126 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe`,
|
117 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_fi
le`,
|
|
127 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_fi
le`,
|
118 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ti
tle`,
|
|
128 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ti
tle`,
|
119 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus`,
|
|
129 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus`,
|
120 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_da
te`,
|
|
130 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_da
te`,
|
121 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pho
tos`,
|
|
131 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pho
tos`,
|
122 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pri
mPhoto`
|
|
132 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pri
mPhoto`
|
123 |
|
FROM
|
|
133 |
|
FROM
|
124 |
|
" .
BX_DOL_TAB
LE_MEDIA .
"
|
|
134 |
|
" .
BX_DOL_TAB
LE_MEDIA .
"
|
125 |
|
INNER JO
IN " . BX_
DOL_TABLE_
PROFILES .
" ON " .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id` = "
. BX_DOL_
TABLE_PROF
ILES . ".`
ID`
|
|
135 |
|
INNER JO
IN " . BX_
DOL_TABLE_
PROFILES .
" ON " .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id` = "
. BX_DOL_
TABLE_PROF
ILES . ".`
ID`
|
126 |
|
WHERE
|
|
136 |
|
WHERE
|
127 |
|
`med
_prof_id`
= '$iProfi
leId'
|
|
137 |
|
`med
_prof_id`
= '$iProfi
leId'
|
128 |
|
AND `med
_type` = '
video'
|
|
138 |
|
AND `med
_type` = '
video'
|
129 |
|
ORDER BY
`med_date
` ASC
|
|
139 |
|
ORDER BY
`med_date
` ASC
|
130 |
|
";
|
|
140 |
|
";
|
131 |
|
|
|
141 |
|
|
132 |
|
/*
|
|
142 |
|
/*
|
133 |
|
ec
ho '<hr>';
|
|
143 |
|
ec
ho '<hr>';
|
134 |
|
ec
ho $sQuery
;
|
|
144 |
|
ec
ho $sQuery
;
|
135 |
|
ec
ho '<hr>';
|
|
145 |
|
ec
ho '<hr>';
|
136 |
|
*/
|
|
146 |
|
*/
|
137 |
|
$a
Photo = $t
his -> get
All( $sQue
ry );
|
|
147 |
|
$a
Photo = $t
his -> get
All( $sQue
ry );
|
138 |
|
|
|
148 |
|
|
139 |
|
re
turn $aPho
to;
|
|
149 |
|
re
turn $aPho
to;
|
140 |
|
}
|
|
150 |
|
}
|
141 |
|
|
|
151 |
|
|
142 |
|
functi
on deleteM
edia( $iPr
ofileID, $
iMediaID,
$sMediaTyp
e )
|
|
152 |
|
functi
on deleteM
edia( $iPr
ofileID, $
iMediaID,
$sMediaTyp
e )
|
143 |
|
{
|
|
153 |
|
{
|
144 |
|
$s
Query = "
|
|
154 |
|
$s
Query = "
|
145 |
|
DELETE F
ROM " . BX
_DOL_TABLE
_MEDIA . "
WHERE
|
|
155 |
|
DELETE F
ROM " . BX
_DOL_TABLE
_MEDIA . "
WHERE
|
146 |
|
`med
_id` = '$i
MediaID'
|
|
156 |
|
`med
_id` = '$i
MediaID'
|
147 |
|
AND `med
_type` = '
$sMediaTyp
e'
|
|
157 |
|
AND `med
_type` = '
$sMediaTyp
e'
|
148 |
|
AND `med
_prof_id`
= '$iProfi
leID'
|
|
158 |
|
AND `med
_prof_id`
= '$iProfi
leID'
|
149 |
|
LIMIT 1
|
|
159 |
|
LIMIT 1
|
150 |
|
";
|
|
160 |
|
";
|
151 |
|
$t
his -> que
ry( $sQuer
y );
|
|
161 |
|
$t
his -> que
ry( $sQuer
y );
|
152 |
|
|
|
162 |
|
|
153 |
|
//
delete vo
ting
|
|
163 |
|
//
delete vo
ting
|
154 |
|
re
quire_once
( BX_DIREC
TORY_PATH_
CLASSES .
'BxDolVoti
ng.php' );
|
|
164 |
|
re
quire_once
( BX_DIREC
TORY_PATH_
CLASSES .
'BxDolVoti
ng.php' );
|
155 |
|
$o
VotingMedi
a = new Bx
DolVoting
('media',
0, 0);
|
|
165 |
|
$o
VotingMedi
a = new Bx
DolVoting
('media',
0, 0);
|
156 |
|
$o
VotingMedi
a->deleteV
otings ($i
MediaID);
|
|
166 |
|
$o
VotingMedi
a->deleteV
otings ($i
MediaID);
|
157 |
|
}
|
|
167 |
|
}
|
158 |
|
|
|
168 |
|
|
159 |
|
|
|
169 |
|
|
160 |
|
functi
on selectV
otingItem(
&$oDolVot
ing, $sVot
ed, $sSexO
nly = '' )
|
|
170 |
|
functi
on selectV
otingItem(
&$oDolVot
ing, $sVot
ed, $sSexO
nly = '' )
|
161 |
|
{
|
|
171 |
|
{
|
162 |
|
if
( $sSexOnl
y )
|
|
172 |
|
if
( $sSexOnl
y )
|
163 |
|
{
|
|
173 |
|
{
|
164 |
|
if( $sSe
xOnly == '
couple' )
|
|
174 |
|
if( $sSe
xOnly == '
couple' )
|
165 |
|
{
|
|
175 |
|
{
|
166 |
|
$sQu
eryAdd = "
AND `Prof
iles`.`Pro
fileType`
= 'couple'
";
|
|
176 |
|
$sQu
eryAdd = "
AND `Prof
iles`.`Pro
fileType`
= 'couple'
";
|
167 |
|
}
|
|
177 |
|
}
|
168 |
|
else
|
|
178 |
|
else
|
169 |
|
{
|
|
179 |
|
{
|
170 |
|
$sQu
eryAdd = "
AND `Prof
iles`.`Sex
` = '$sSex
Only' ";
|
|
180 |
|
$sQu
eryAdd = "
AND `Prof
iles`.`Sex
` = '$sSex
Only' ";
|
171 |
|
}
|
|
181 |
|
}
|
172 |
|
}
|
|
182 |
|
}
|
173 |
|
|
|
183 |
|
|
174 |
|
$a
SqlVoting
= $oDolVot
ing -> get
SqlParts(B
X_DOL_TABL
E_MEDIA, '
`med_id`')
;
|
|
184 |
|
$a
SqlVoting
= $oDolVot
ing -> get
SqlParts(B
X_DOL_TABL
E_MEDIA, '
`med_id`')
;
|
175 |
|
|
|
185 |
|
|
176 |
|
$s
Query = "
|
|
186 |
|
$s
Query = "
|
177 |
|
SELECT
|
|
187 |
|
SELECT
|
178 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
`,
|
|
188 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
`,
|
179 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id`,
|
|
189 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id`,
|
180 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe`,
|
|
190 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe`,
|
181 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_fi
le`,
|
|
191 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_fi
le`,
|
182 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ti
tle`,
|
|
192 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ti
tle`,
|
183 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus`,
|
|
193 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus`,
|
184 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_da
te`,
|
|
194 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_da
te`,
|
185 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pri
mPhoto`
|
|
195 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Pri
mPhoto`
|
186 |
|
{$aS
qlVoting['
fields']}
|
|
196 |
|
{$aS
qlVoting['
fields']}
|
187 |
|
FROM
|
|
197 |
|
FROM
|
188 |
|
" . BX_D
OL_TABLE_M
EDIA . "
|
|
198 |
|
" . BX_D
OL_TABLE_M
EDIA . "
|
189 |
|
INNER JO
IN " . BX_
DOL_TABLE_
PROFILES .
" ON " .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id` = "
. BX_DOL_
TABLE_PROF
ILES . ".I
D
|
|
199 |
|
INNER JO
IN " . BX_
DOL_TABLE_
PROFILES .
" ON " .
BX_DOL_TAB
LE_MEDIA .
".`med_pr
of_id` = "
. BX_DOL_
TABLE_PROF
ILES . ".I
D
|
190 |
|
{$aSqlVo
ting['join
']}
|
|
200 |
|
{$aSqlVo
ting['join
']}
|
191 |
|
WHERE
|
|
201 |
|
WHERE
|
192 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe` = 'pho
to'
|
|
202 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_ty
pe` = 'pho
to'
|
193 |
|
AND
|
|
203 |
|
AND
|
194 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
` NOT IN (
$sVoted)
|
|
204 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_id
` NOT IN (
$sVoted)
|
195 |
|
AND
|
|
205 |
|
AND
|
196 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus` = 'a
ctive'
|
|
206 |
|
" .
BX_DOL_TAB
LE_MEDIA .
".`med_st
atus` = 'a
ctive'
|
197 |
|
AND
|
|
207 |
|
AND
|
198 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Sta
tus` = 'ac
tive'
|
|
208 |
|
" .
BX_DOL_TAB
LE_PROFILE
S . ".`Sta
tus` = 'ac
tive'
|
|
|
209 |
|
AND
|
|
|
210 |
|
`rat
e_able`='1
'
|
199 |
|
$sQueryA
dd
|
|
211 |
|
$sQueryA
dd
|
200 |
|
ORDER BY
RAND()
|
|
212 |
|
ORDER BY
RAND()
|
201 |
|
";
|
|
213 |
|
";
|
202 |
|
|
|
214 |
|
|
203 |
|
re
turn $this
-> getRow
( $sQuery
);
|
|
215 |
|
re
turn $this
-> getRow
( $sQuery
);
|
204 |
|
}
|
|
216 |
|
}
|
205 |
|
|
|
217 |
|
|
206 |
|
}
|
|
218 |
|
}
|
207 |
|
|
|
219 |
|
|
208 |
|
?>
|
|
220 |
|
?>
|