thorsten /
phpMyFAQ
| @@ 1535-1550 (lines=16) @@ | ||
| 1532 | * |
|
| 1533 | * @return bool |
|
| 1534 | */ |
|
| 1535 | public function deleteCategory($category_id, $category_lang, $delete_all = false) |
|
| 1536 | { |
|
| 1537 | $query = sprintf(' |
|
| 1538 | DELETE FROM |
|
| 1539 | %sfaqcategories |
|
| 1540 | WHERE |
|
| 1541 | id = %d', |
|
| 1542 | Db::getTablePrefix(), |
|
| 1543 | $category_id); |
|
| 1544 | if (!$delete_all) { |
|
| 1545 | $query .= " AND lang = '".$category_lang."'"; |
|
| 1546 | } |
|
| 1547 | $this->config->getDb()->query($query); |
|
| 1548 | ||
| 1549 | return true; |
|
| 1550 | } |
|
| 1551 | ||
| 1552 | /** |
|
| 1553 | * Deletes a category relation. |
|
| @@ 1561-1576 (lines=16) @@ | ||
| 1558 | * |
|
| 1559 | * @return bool |
|
| 1560 | */ |
|
| 1561 | public function deleteCategoryRelation($category_id, $category_lang, $delete_all = false) |
|
| 1562 | { |
|
| 1563 | $query = sprintf(' |
|
| 1564 | DELETE FROM |
|
| 1565 | %sfaqcategoryrelations |
|
| 1566 | WHERE |
|
| 1567 | category_id = %d', |
|
| 1568 | Db::getTablePrefix(), |
|
| 1569 | $category_id); |
|
| 1570 | if (!$delete_all) { |
|
| 1571 | $query .= " AND category_lang = '".$category_lang."'"; |
|
| 1572 | } |
|
| 1573 | $this->config->getDb()->query($query); |
|
| 1574 | ||
| 1575 | return true; |
|
| 1576 | } |
|
| 1577 | ||
| 1578 | /** |
|
| 1579 | * Create array with translated categories. |
|
