root/alternc/tags/0.9.7/src/quota_delete

#!/usr/bin/php -q
<?php

/*
 This script delete completely a quota from the quota managment system.
 (this script may be used when removing an AlternC module)

 $argv[1] = The named quota to create
*/

if ($argc!=2) {
    echo "Usage : ".$argv[0]." <quota name>
 Delete completely a quota from the quota managment system.
";
    return 1;
}

$name=$argv[1];

include("/var/alternc/bureau/class/local.php");

if (!mysql_connect($L_MYSQL_HOST,$L_MYSQL_LOGIN,$L_MYSQL_PWD)) {
    echo "Cannot connect to Mysql !\n";
    return 1;
}

if (!mysql_select_db($L_MYSQL_DATABASE)) {
    echo "Cannot connect to Mysql database $L_MYSQL_DATABASE !\n";
    return 1;
}

$r=mysql_query("DELETE FROM defquotas WHERE quota='$name';");
if (mysql_errno()) {
    echo "Mysql Error : ".mysql_error()."\n";
    return 1;
}

$r=mysql_query("DELETE FROM quotas WHERE name='$name';");
if (mysql_errno()) {
    echo "Mysql Error : ".mysql_error()."\n";
    return 1;
}

return 0;

?>