| @@ 1206-1221 (lines=16) @@ | ||
| 1203 | * @param boolean $delete_all Delete all languages? |
|
| 1204 | * @return boolean |
|
| 1205 | */ |
|
| 1206 | public function deleteCategory($category_id, $category_lang, $delete_all = false) |
|
| 1207 | { |
|
| 1208 | $query = sprintf(" |
|
| 1209 | DELETE FROM |
|
| 1210 | %sfaqcategories |
|
| 1211 | WHERE |
|
| 1212 | id = %d", |
|
| 1213 | PMF_Db::getTablePrefix(), |
|
| 1214 | $category_id); |
|
| 1215 | if (!$delete_all) { |
|
| 1216 | $query .= " AND lang = '".$category_lang."'"; |
|
| 1217 | } |
|
| 1218 | $this->_config->getDb()->query($query); |
|
| 1219 | ||
| 1220 | return true; |
|
| 1221 | } |
|
| 1222 | /** |
|
| 1223 | * Deletes a category relation |
|
| 1224 | * |
|
| @@ 1230-1245 (lines=16) @@ | ||
| 1227 | * @param boolean $delete_all Delete all languages? |
|
| 1228 | * @return boolean |
|
| 1229 | */ |
|
| 1230 | public function deleteCategoryRelation($category_id, $category_lang, $delete_all = false) |
|
| 1231 | { |
|
| 1232 | $query = sprintf(" |
|
| 1233 | DELETE FROM |
|
| 1234 | %sfaqcategoryrelations |
|
| 1235 | WHERE |
|
| 1236 | category_id = %d", |
|
| 1237 | PMF_Db::getTablePrefix(), |
|
| 1238 | $category_id); |
|
| 1239 | if (!$delete_all) { |
|
| 1240 | $query .= " AND category_lang = '".$category_lang."'"; |
|
| 1241 | } |
|
| 1242 | $this->_config->getDb()->query($query); |
|
| 1243 | ||
| 1244 | return true; |
|
| 1245 | } |
|
| 1246 | ||
| 1247 | /** |
|
| 1248 | * Create array with translated categories |
|