/**
* Deletes group-option-categories and/or group-options which where installed by the package.
*/
public function uninstall()
{
// Delete value-entries using categories or options
// which will be deleted.
$sql = "DELETE FROM\twcf" . WCF_N . "_user_group_option_value\n\t\t\tWHERE\t\toptionID IN (\n\t\t\t\t\t\tSELECT\toptionID\n\t\t\t\t\t\tFROM\twcf" . WCF_N . "_user_group_option\n\t\t\t\t\t\tWHERE\tpackageID = ?\n\t\t\t\t\t)";
$statement = WCF::getDB()->prepareStatement($sql);
$statement->execute(array($this->installation->getPackageID()));
parent::uninstall();
}
/**
* Drops the columns from user option value table from options
* installed by this package.
*/
public function uninstall()
{
// get optionsIDs from package
$sql = "SELECT\toptionID\n\t\t\tFROM \twcf" . WCF_N . "_user_option\n\t\t\tWHERE\tpackageID = ?";
$statement = WCF::getDB()->prepareStatement($sql);
$statement->execute(array($this->installation->getPackageID()));
while ($row = $statement->fetchArray()) {
WCF::getDB()->getEditor()->dropColumn('wcf' . WCF_N . '_user_option_value', 'userOption' . $row['optionID']);
}
// uninstall options and categories
parent::uninstall();
}