thorsten /
phpMyFAQ
| @@ 2254-2278 (lines=25) @@ | ||
| 2251 | * @since 2006-06-18 |
|
| 2252 | * @author Thorsten Rinne <[email protected]> |
|
| 2253 | */ |
|
| 2254 | function updateVoting($votingData) |
|
| 2255 | { |
|
| 2256 | if (!is_array($votingData)) { |
|
| 2257 | return false; |
|
| 2258 | } |
|
| 2259 | ||
| 2260 | $query = sprintf( |
|
| 2261 | "UPDATE |
|
| 2262 | %sfaqvoting |
|
| 2263 | SET |
|
| 2264 | vote = vote + %d, |
|
| 2265 | usr = usr + 1, |
|
| 2266 | datum = %d, |
|
| 2267 | ip = '%s' |
|
| 2268 | WHERE |
|
| 2269 | artikel = %d", |
|
| 2270 | PMF_Db::getTablePrefix(), |
|
| 2271 | $votingData['vote'], |
|
| 2272 | $_SERVER['REQUEST_TIME'], |
|
| 2273 | $votingData['user_ip'], |
|
| 2274 | $votingData['record_id']); |
|
| 2275 | $this->_config->getDb()->query($query); |
|
| 2276 | ||
| 2277 | return true; |
|
| 2278 | } |
|
| 2279 | ||
| 2280 | ||
| 2281 | /** |
|
| @@ 1017-1043 (lines=27) @@ | ||
| 1014 | * @param array $category_data Array of category data |
|
| 1015 | * @return boolean |
|
| 1016 | */ |
|
| 1017 | public function updateCategory(Array $category_data) |
|
| 1018 | { |
|
| 1019 | if (!is_array($category_data)) { |
|
| 1020 | return false; |
|
| 1021 | } |
|
| 1022 | ||
| 1023 | $query = sprintf(" |
|
| 1024 | UPDATE |
|
| 1025 | %sfaqcategories |
|
| 1026 | SET |
|
| 1027 | name = '%s', |
|
| 1028 | description = '%s', |
|
| 1029 | user_id = %d |
|
| 1030 | WHERE |
|
| 1031 | id = %d |
|
| 1032 | AND |
|
| 1033 | lang = '%s'", |
|
| 1034 | PMF_Db::getTablePrefix(), |
|
| 1035 | $category_data['name'], |
|
| 1036 | $category_data['description'], |
|
| 1037 | $category_data['user_id'], |
|
| 1038 | $category_data['id'], |
|
| 1039 | $category_data['lang']); |
|
| 1040 | $this->_config->getDb()->query($query); |
|
| 1041 | ||
| 1042 | return true; |
|
| 1043 | } |
|
| 1044 | ||
| 1045 | /** |
|
| 1046 | * Move the categories ownership, if any. |
|
