thorsten /
phpMyFAQ
| @@ 1036-1062 (lines=27) @@ | ||
| 1033 | * @param array $category_data Array of category data |
|
| 1034 | * @return boolean |
|
| 1035 | */ |
|
| 1036 | public function updateCategory(Array $category_data) |
|
| 1037 | { |
|
| 1038 | if (!is_array($category_data)) { |
|
| 1039 | return false; |
|
| 1040 | } |
|
| 1041 | ||
| 1042 | $query = sprintf(" |
|
| 1043 | UPDATE |
|
| 1044 | %sfaqcategories |
|
| 1045 | SET |
|
| 1046 | name = '%s', |
|
| 1047 | description = '%s', |
|
| 1048 | user_id = %d |
|
| 1049 | WHERE |
|
| 1050 | id = %d |
|
| 1051 | AND |
|
| 1052 | lang = '%s'", |
|
| 1053 | PMF_Db::getTablePrefix(), |
|
| 1054 | $category_data['name'], |
|
| 1055 | $category_data['description'], |
|
| 1056 | $category_data['user_id'], |
|
| 1057 | $category_data['id'], |
|
| 1058 | $category_data['lang']); |
|
| 1059 | $this->_config->getDb()->query($query); |
|
| 1060 | ||
| 1061 | return true; |
|
| 1062 | } |
|
| 1063 | ||
| 1064 | /** |
|
| 1065 | * Move the categories ownership, if any. |
|
| @@ 2251-2275 (lines=25) @@ | ||
| 2248 | * @since 2006-06-18 |
|
| 2249 | * @author Thorsten Rinne <[email protected]> |
|
| 2250 | */ |
|
| 2251 | function updateVoting($votingData) |
|
| 2252 | { |
|
| 2253 | if (!is_array($votingData)) { |
|
| 2254 | return false; |
|
| 2255 | } |
|
| 2256 | ||
| 2257 | $query = sprintf( |
|
| 2258 | "UPDATE |
|
| 2259 | %sfaqvoting |
|
| 2260 | SET |
|
| 2261 | vote = vote + %d, |
|
| 2262 | usr = usr + 1, |
|
| 2263 | datum = %d, |
|
| 2264 | ip = '%s' |
|
| 2265 | WHERE |
|
| 2266 | artikel = %d", |
|
| 2267 | PMF_Db::getTablePrefix(), |
|
| 2268 | $votingData['vote'], |
|
| 2269 | $_SERVER['REQUEST_TIME'], |
|
| 2270 | $votingData['user_ip'], |
|
| 2271 | $votingData['record_id']); |
|
| 2272 | $this->_config->getDb()->query($query); |
|
| 2273 | ||
| 2274 | return true; |
|
| 2275 | } |
|
| 2276 | ||
| 2277 | ||
| 2278 | /** |
|
