thorsten /
phpMyFAQ
| @@ 3038-3049 (lines=12) @@ | ||
| 3035 | * |
|
| 3036 | * @return boolean |
|
| 3037 | */ |
|
| 3038 | public function updateQuestionAnswer($openQuestionId, $faqId, $categoryId) |
|
| 3039 | { |
|
| 3040 | $query = sprintf( |
|
| 3041 | 'UPDATE %sfaqquestions SET answer_id = %d, category_id= %d, WHERE id= %d', |
|
| 3042 | PMF_Db::getTablePrefix(), |
|
| 3043 | $faqId, |
|
| 3044 | $categoryId, |
|
| 3045 | $openQuestionId |
|
| 3046 | ); |
|
| 3047 | ||
| 3048 | return $this->_config->getDb()->query($query); |
|
| 3049 | } |
|
| 3050 | ||
| 3051 | /** |
|
| 3052 | * Returns a part of a query to check permissions |
|
| @@ 214-225 (lines=12) @@ | ||
| 211 | * |
|
| 212 | * @return boolean |
|
| 213 | */ |
|
| 214 | public function updateInstance($id, Array $data) |
|
| 215 | { |
|
| 216 | $update = sprintf( |
|
| 217 | "UPDATE %sfaqinstances SET instance = '%s', comment = '%s' WHERE id = %d", |
|
| 218 | PMF_Db::getTablePrefix(), |
|
| 219 | $data['instance'], |
|
| 220 | $data['comment'], |
|
| 221 | (int)$id |
|
| 222 | ); |
|
| 223 | ||
| 224 | return $this->config->getDb()->query($update); |
|
| 225 | } |
|
| 226 | ||
| 227 | ||
| 228 | /** |
|
