@@ 231-243 (lines=13) @@ | ||
228 | * @param int $msgid |
|
229 | * @returns int |
|
230 | */ |
|
231 | public function countVotesCom($type, $val, $comid, $msgid) |
|
232 | { |
|
233 | global $xoopsUser, $xoopsDB; |
|
234 | $query = 'Select SUM(' . $val . ') as sum from ' . $xoopsDB->prefix('smallworld_vote') . " where com_id = '" . $comid . "' AND msg_id = '" . $msgid . "'"; |
|
235 | $result = $xoopsDB->queryF($query); |
|
236 | while ($row = $xoopsDB->fetchArray($result)) { |
|
237 | $sum = $row['sum']; |
|
238 | } |
|
239 | if ('' == $sum) { |
|
240 | $sum = '0'; |
|
241 | } |
|
242 | return $sum; |
|
243 | } |
|
244 | ||
245 | /** |
|
246 | * @Check is user is friend |
@@ 209-222 (lines=14) @@ | ||
206 | * @param int $msgid |
|
207 | * @return int |
|
208 | */ |
|
209 | public function countVotes($type, $val, $msgid) |
|
210 | { |
|
211 | global $xoopsUser, $xoopsDB; |
|
212 | $sum = 0; |
|
213 | $query = 'Select SUM(' . $val . ') as sum from ' . $xoopsDB->prefix('smallworld_vote') . " where msg_id = '" . $msgid . "' and com_id = '0'"; |
|
214 | $result = $xoopsDB->queryF($query); |
|
215 | while ($row = $xoopsDB->fetchArray($result)) { |
|
216 | $sum = $row['sum']; |
|
217 | } |
|
218 | if ('' == $sum) { |
|
219 | $sum = 0; |
|
220 | } |
|
221 | return $sum; |
|
222 | } |
|
223 | ||
224 | /** |
|
225 | * @Count comments votes |
|
@@ 232-245 (lines=14) @@ | ||
229 | * @param int $msgid |
|
230 | * @returns int |
|
231 | */ |
|
232 | public function countVotesCom($type, $val, $comid, $msgid) |
|
233 | { |
|
234 | global $xoopsUser, $xoopsDB; |
|
235 | $sum = 0; |
|
236 | $query = 'Select SUM(' . $val . ') as sum from ' . $xoopsDB->prefix('smallworld_vote') . " where com_id = '" . $comid . "' AND msg_id = '" . $msgid . "'"; |
|
237 | $result = $xoopsDB->queryF($query); |
|
238 | while ($row = $xoopsDB->fetchArray($result)) { |
|
239 | $sum = $row['sum']; |
|
240 | } |
|
241 | if ('' == $sum) { |
|
242 | $sum = 0; |
|
243 | } |
|
244 | return $sum; |
|
245 | } |
|
246 | ||
247 | /** |
|
248 | * @Check is user is friend |
@@ 290-302 (lines=13) @@ | ||
287 | * @param int $msgid |
|
288 | * @returns int |
|
289 | */ |
|
290 | public function countVotesCom($type, $val, $comid, $msgid) |
|
291 | { |
|
292 | global $xoopsUser, $xoopsDB; |
|
293 | $query = 'Select SUM(' . $val . ') as sum from ' . $xoopsDB->prefix('smallworld_vote') . " where com_id = '" . $comid . "' AND msg_id = '" . $msgid . "'"; |
|
294 | $result = $xoopsDB->queryF($query); |
|
295 | while ($row = $xoopsDB->fetchArray($result)) { |
|
296 | $sum = $row['sum']; |
|
297 | } |
|
298 | if ('' == $sum) { |
|
299 | $sum = '0'; |
|
300 | } |
|
301 | return $sum; |
|
302 | } |
|
303 | ||
304 | /** |
|
305 | * @Check if user is friend |
@@ 295-307 (lines=13) @@ | ||
292 | * @param int $msgid |
|
293 | * @returns int |
|
294 | */ |
|
295 | public function countVotesCom($type, $val, $comid, $msgid) |
|
296 | { |
|
297 | global $xoopsUser, $xoopsDB; |
|
298 | $query = 'Select SUM(' . $val . ') as sum from ' . $xoopsDB->prefix('smallworld_vote') . " where com_id = '" . $comid . "' AND msg_id = '" . $msgid . "'"; |
|
299 | $result = $xoopsDB->queryF($query); |
|
300 | while ($row = $xoopsDB->fetchArray($result)) { |
|
301 | $sum = $row['sum']; |
|
302 | } |
|
303 | if ('' == $sum) { |
|
304 | $sum = '0'; |
|
305 | } |
|
306 | return $sum; |
|
307 | } |
|
308 | ||
309 | /** |
|
310 | * @Check if user is friend |