5 This script create a quota entry for each existing user.
6 and set the default quota to the specified value.
7 (this script may be used when installing / upgrading an AlternC module)
9 $argv[1] = The named quota to create
10 $argv[2] = The default quota value for each user.
14 echo "Usage : ".$argv[0]." <quota name> <quota value>
15 Create a quota entry for each existing user and set the default quota to the
24 include("/usr/share/alternc/panel/class/local.php");
26 if (!mysqli_connect($L_MYSQL_HOST,$L_MYSQL_LOGIN,$L_MYSQL_PWD)) {
27 echo "Cannot connect to Mysql !\n";
31 $co = mysqli_connect($L_MYSQL_HOST,$L_MYSQL_LOGIN,$L_MYSQL_PWD);
33 if (!mysqli_select_db($co, $L_MYSQL_DATABASE)) {
34 echo "Cannot connect to Mysql database $L_MYSQL_DATABASE !\n";
38 $r=mysqli_query($co, "DELETE FROM defquotas WHERE quota='$name';");
39 if (mysqli_errno($co)) {
40 echo "Mysql Error : ".mysqli_error($co)."\n";
44 $r=mysqli_query($co, "INSERT INTO defquotas (quota,value) VALUES ('$name','$quota');");
45 if (mysqli_errno($co)) {
46 echo "Mysql Error : ".mysqli_error($co)."\n";
50 $r=mysqli_query($co, "SELECT uid FROM membres;");
51 if (mysqli_errno($co)) {
52 echo "Mysql Error : ".mysqli_error($co)."\n";
55 while ($c=mysqli_fetch_array($r)) {
56 $s=mysqli_query($co, "SELECT name FROM quotas WHERE uid='$c[uid]' AND name='$name';");
57 if (!mysqli_num_rows($s)) {
58 mysqli_query($co, "INSERT INTO quotas (uid,name,total) VALUES ('$c[uid]','$name','$quota') on DUPLICATE KEY UPDATE total=$quota;");