mambax7 /
smartfaq
| @@ 687-700 (lines=14) @@ | ||
| 684 | * @param bool $force |
|
| 685 | * @return bool |
|
| 686 | */ |
|
| 687 | public function updateAll($fieldname, $fieldvalue, CriteriaElement $criteria = null, $force = false) |
|
| 688 | { |
|
| 689 | $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 690 | $sql = 'UPDATE ' . $this->db->prefix('smartfaq_answers') . ' SET ' . $set_clause; |
|
| 691 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 692 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 693 | } |
|
| 694 | //echo "<br />" . $sql . "<br />"; |
|
| 695 | if (!$this->db->queryF($sql)) { |
|
| 696 | return false; |
|
| 697 | } |
|
| 698 | ||
| 699 | return true; |
|
| 700 | } |
|
| 701 | ||
| 702 | /** |
|
| 703 | * @param $faqids |
|
| @@ 667-679 (lines=13) @@ | ||
| 664 | * |
|
| 665 | * @return bool |
|
| 666 | **/ |
|
| 667 | public function updateAll($fieldname, $fieldvalue, $criteria = null) |
|
| 668 | { |
|
| 669 | $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 670 | $sql = 'UPDATE ' . $this->db->prefix('smartfaq_categories') . ' SET ' . $set_clause; |
|
| 671 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 672 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 673 | } |
|
| 674 | if (!$this->db->queryF($sql)) { |
|
| 675 | return false; |
|
| 676 | } |
|
| 677 | ||
| 678 | return true; |
|
| 679 | } |
|
| 680 | ||
| 681 | /** |
|
| 682 | * @param int $cat_id |
|
| @@ 1438-1450 (lines=13) @@ | ||
| 1435 | * |
|
| 1436 | * @return bool |
|
| 1437 | **/ |
|
| 1438 | public function updateAll($fieldname, $fieldvalue, $criteria = null) |
|
| 1439 | { |
|
| 1440 | $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 1441 | $sql = 'UPDATE ' . $this->db->prefix('smartfaq_faq') . ' SET ' . $set_clause; |
|
| 1442 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 1443 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 1444 | } |
|
| 1445 | if (!$this->db->queryF($sql)) { |
|
| 1446 | return false; |
|
| 1447 | } |
|
| 1448 | ||
| 1449 | return true; |
|
| 1450 | } |
|
| 1451 | ||
| 1452 | /** |
|
| 1453 | * @param $faqid |
|
