mambax7 /
smartfaq
| @@ 737-750 (lines=14) @@ | ||
| 734 | * @param bool $force |
|
| 735 | * @return bool |
|
| 736 | */ |
|
| 737 | public function updateAll($fieldname, $fieldvalue, CriteriaElement $criteria = null, $force = false) |
|
| 738 | { |
|
| 739 | $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 740 | $sql = 'UPDATE ' . $this->db->prefix('smartfaq_answers') . ' SET ' . $set_clause; |
|
| 741 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 742 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 743 | } |
|
| 744 | //echo "<br>" . $sql . "<br>"; |
|
| 745 | if (!$this->db->queryF($sql)) { |
|
| 746 | return false; |
|
| 747 | } |
|
| 748 | ||
| 749 | return true; |
|
| 750 | } |
|
| 751 | ||
| 752 | /** |
|
| 753 | * @param $faqids |
|
| @@ 684-696 (lines=13) @@ | ||
| 681 | * |
|
| 682 | * @return bool |
|
| 683 | **/ |
|
| 684 | public function updateAll($fieldname, $fieldvalue, $criteria = null) |
|
| 685 | { |
|
| 686 | $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 687 | $sql = 'UPDATE ' . $this->db->prefix('smartfaq_categories') . ' SET ' . $set_clause; |
|
| 688 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 689 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 690 | } |
|
| 691 | if (!$this->db->queryF($sql)) { |
|
| 692 | return false; |
|
| 693 | } |
|
| 694 | ||
| 695 | return true; |
|
| 696 | } |
|
| 697 | ||
| 698 | /** |
|
| 699 | * @param int $cat_id |
|
| @@ 1477-1489 (lines=13) @@ | ||
| 1474 | * |
|
| 1475 | * @return bool |
|
| 1476 | **/ |
|
| 1477 | public function updateAll($fieldname, $fieldvalue, $criteria = null) |
|
| 1478 | { |
|
| 1479 | $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 1480 | $sql = 'UPDATE ' . $this->db->prefix('smartfaq_faq') . ' SET ' . $set_clause; |
|
| 1481 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 1482 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 1483 | } |
|
| 1484 | if (!$this->db->queryF($sql)) { |
|
| 1485 | return false; |
|
| 1486 | } |
|
| 1487 | ||
| 1488 | return true; |
|
| 1489 | } |
|
| 1490 | ||
| 1491 | /** |
|
| 1492 | * @param $faqid |
|
