mambax7 /
smartfaq
| @@ 98-102 (lines=5) @@ | ||
| 95 | $sql = sprintf('UPDATE %s SET STATUS = %u, faqid = %s, answer = %s, uid = %u, datesub = %u, notifypub = %u WHERE answerid = %u', $this->db->prefix('smartfaq_answers'), $status, $faqid, $this->db->quoteString($answer), $uid, $datesub, $notifypub, $answerid); |
|
| 96 | } |
|
| 97 | ||
| 98 | if (false !== $force) { |
|
| 99 | $result = $this->db->queryF($sql); |
|
| 100 | } else { |
|
| 101 | $result = $this->db->query($sql); |
|
| 102 | } |
|
| 103 | ||
| 104 | if (!$result) { |
|
| 105 | return false; |
|
| @@ 133-137 (lines=5) @@ | ||
| 130 | ||
| 131 | //echo "<br>" . $sql . "<br>"; |
|
| 132 | ||
| 133 | if (false !== $force) { |
|
| 134 | $result = $this->db->queryF($sql); |
|
| 135 | } else { |
|
| 136 | $result = $this->db->query($sql); |
|
| 137 | } |
|
| 138 | if (!$result) { |
|
| 139 | return false; |
|
| 140 | } |
|
| @@ 115-119 (lines=5) @@ | ||
| 112 | $categoryid |
|
| 113 | ); |
|
| 114 | } |
|
| 115 | if (false !== $force) { |
|
| 116 | $result = $this->db->queryF($sql); |
|
| 117 | } else { |
|
| 118 | $result = $this->db->query($sql); |
|
| 119 | } |
|
| 120 | if (!$result) { |
|
| 121 | return false; |
|
| 122 | } |
|
| @@ 162-166 (lines=5) @@ | ||
| 159 | $smartModule = Smartfaq\Utility::getModuleInfo(); |
|
| 160 | $module_id = $smartModule->getVar('mid'); |
|
| 161 | ||
| 162 | if (false !== $force) { |
|
| 163 | $result = $this->db->queryF($sql); |
|
| 164 | } else { |
|
| 165 | $result = $this->db->query($sql); |
|
| 166 | } |
|
| 167 | ||
| 168 | xoops_groupperm_deletebymoditem($module_id, 'category_read', $category->categoryid()); |
|
| 169 | //xoops_groupperm_deletebymoditem ($module_id, "category_admin", $categoryObj->categoryid()); |
|
| @@ 145-149 (lines=5) @@ | ||
| 142 | $faqid |
|
| 143 | ); |
|
| 144 | } |
|
| 145 | if (false !== $force) { |
|
| 146 | $result = $this->db->queryF($sql); |
|
| 147 | } else { |
|
| 148 | $result = $this->db->query($sql); |
|
| 149 | } |
|
| 150 | ||
| 151 | if (!$result) { |
|
| 152 | $faq->setErrors('Could not store data in the database.<br />'.$this->db->error().' ('.$this->db->errno().')<br />'.$sql); |
|
| @@ 207-211 (lines=5) @@ | ||
| 204 | ||
| 205 | $sql = sprintf('DELETE FROM %s WHERE faqid = %u', $this->db->prefix('smartfaq_faq'), $faq->getVar('faqid')); |
|
| 206 | ||
| 207 | if (false !== $force) { |
|
| 208 | $result = $this->db->queryF($sql); |
|
| 209 | } else { |
|
| 210 | $result = $this->db->query($sql); |
|
| 211 | } |
|
| 212 | if (!$result) { |
|
| 213 | return false; |
|
| 214 | } |
|
