mambax7 /
smartfaq
| @@ 733-746 (lines=14) @@ | ||
| 730 | * @param bool $force |
|
| 731 | * @return bool |
|
| 732 | */ |
|
| 733 | public function updateAll($fieldname, $fieldvalue, CriteriaElement $criteria = null, $force = false) |
|
| 734 | { |
|
| 735 | $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 736 | $sql = 'UPDATE ' . $this->db->prefix('smartfaq_answers') . ' SET ' . $set_clause; |
|
| 737 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 738 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 739 | } |
|
| 740 | //echo "<br>" . $sql . "<br>"; |
|
| 741 | if (!$this->db->queryF($sql)) { |
|
| 742 | return false; |
|
| 743 | } |
|
| 744 | ||
| 745 | return true; |
|
| 746 | } |
|
| 747 | ||
| 748 | /** |
|
| 749 | * @param $faqids |
|
| @@ 681-693 (lines=13) @@ | ||
| 678 | * |
|
| 679 | * @return bool |
|
| 680 | **/ |
|
| 681 | public function updateAll($fieldname, $fieldvalue, CriteriaElement $criteria = null) |
|
| 682 | { |
|
| 683 | $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 684 | $sql = 'UPDATE ' . $this->db->prefix('smartfaq_categories') . ' SET ' . $set_clause; |
|
| 685 | if (null !== ($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 686 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 687 | } |
|
| 688 | if (!$this->db->queryF($sql)) { |
|
| 689 | return false; |
|
| 690 | } |
|
| 691 | ||
| 692 | return true; |
|
| 693 | } |
|
| 694 | ||
| 695 | /** |
|
| 696 | * @param int $cat_id |
|
| @@ 1465-1477 (lines=13) @@ | ||
| 1462 | * |
|
| 1463 | * @return bool |
|
| 1464 | **/ |
|
| 1465 | public function updateAll($fieldname, $fieldvalue, $criteria = null) |
|
| 1466 | { |
|
| 1467 | $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 1468 | $sql = 'UPDATE ' . $this->db->prefix('smartfaq_faq') . ' SET ' . $set_clause; |
|
| 1469 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 1470 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 1471 | } |
|
| 1472 | if (!$this->db->queryF($sql)) { |
|
| 1473 | return false; |
|
| 1474 | } |
|
| 1475 | ||
| 1476 | return true; |
|
| 1477 | } |
|
| 1478 | ||
| 1479 | /** |
|
| 1480 | * @param $faqid |
|
