XOOPS /
XoopsCore25
| @@ 625-646 (lines=22) @@ | ||
| 622 | * @param mixed $showFunc |
|
| 623 | * @return int |
|
| 624 | */ |
|
| 625 | public function countSimilarBlocks($moduleId, $funcNum, $showFunc = null) |
|
| 626 | { |
|
| 627 | $funcNum = (int)$funcNum; |
|
| 628 | $moduleId = (int)$moduleId; |
|
| 629 | if ($funcNum < 1 || $moduleId < 1) { |
|
| 630 | // invalid query |
|
| 631 | return 0; |
|
| 632 | } |
|
| 633 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 634 | if (isset($showFunc)) { |
|
| 635 | // showFunc is set for more strict comparison |
|
| 636 | $sql = sprintf('SELECT COUNT(*) FROM %s WHERE mid = %d AND func_num = %d AND show_func = %s', $db->prefix('newblocks'), $moduleId, $funcNum, $db->quoteString(trim($showFunc))); |
|
| 637 | } else { |
|
| 638 | $sql = sprintf('SELECT COUNT(*) FROM %s WHERE mid = %d AND func_num = %d', $db->prefix('newblocks'), $moduleId, $funcNum); |
|
| 639 | } |
|
| 640 | if (!$result = $db->query($sql)) { |
|
| 641 | return 0; |
|
| 642 | } |
|
| 643 | list($count) = $db->fetchRow($result); |
|
| 644 | ||
| 645 | return $count; |
|
| 646 | } |
|
| 647 | } |
|
| 648 | ||
| @@ 620-641 (lines=22) @@ | ||
| 617 | * @param mixed $showFunc |
|
| 618 | * @return int |
|
| 619 | */ |
|
| 620 | public function countSimilarBlocks($moduleId, $funcNum, $showFunc = null) |
|
| 621 | { |
|
| 622 | $funcNum = (int)$funcNum; |
|
| 623 | $moduleId = (int)$moduleId; |
|
| 624 | if ($funcNum < 1 || $moduleId < 1) { |
|
| 625 | // invalid query |
|
| 626 | return 0; |
|
| 627 | } |
|
| 628 | /* @var $db XoopsMySQLDatabase */ |
|
| 629 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 630 | if (isset($showFunc)) { |
|
| 631 | // showFunc is set for more strict comparison |
|
| 632 | $sql = sprintf('SELECT COUNT(*) FROM %s WHERE mid = %d AND func_num = %d AND show_func = %s', $db->prefix('newblocks'), $moduleId, $funcNum, $db->quoteString(trim($showFunc))); |
|
| 633 | } else { |
|
| 634 | $sql = sprintf('SELECT COUNT(*) FROM %s WHERE mid = %d AND func_num = %d', $db->prefix('newblocks'), $moduleId, $funcNum); |
|
| 635 | } |
|
| 636 | if (!$result = $db->query($sql)) { |
|
| 637 | return 0; |
|
| 638 | } |
|
| 639 | list($count) = $db->fetchRow($result); |
|
| 640 | ||
| 641 | return $count; |
|
| 642 | } |
|
| 643 | } |
|
| 644 | ||
