XoopsModules25x /
smallworld
| @@ 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 |
|
