Changeset 93

Timestamp:

02/21/06 23:36:42 (7 years ago)

Author:

anarcat

Message:

[project @ alternc: changeset 2003-06-09 19:53:33 by root]
voili, mysql semble bien marcher apres ces patchs ;)

Original author: root
Date: 2003-06-09 19:53:36

Files:

• bureau/admin/sql_bck.php (modified) (5 diffs)
• bureau/class/m_mysql.php (modified) (3 diffs)
• install/scripts/mysql.sql (modified) (2 diffs)

bureau/admin/sql_bck.php

@@ -1 +1 @@
 <?php
 /*
- $Id: sql_bck.php,v 1.3 2003/06/09 19:46:29 root Exp $
+ $Id: sql_bck.php,v 1.4 2003/06/09 19:53:33 root Exp $
  ----------------------------------------------------------------------
  AlternC - Web Hosting System
@@ -56 +56 @@
         <input type="hidden" name="id" value="<?php echo $id; ?>">
         <select class="inl" name="bck_mode">
-        <option value="0"<?php if ($r["bck_mode"]==0) echo " selected"; ?>><?php __("No backup"); ?></option>
-        <option value="1"<?php if ($r["bck_mode"]==1) echo " selected"; ?>><?php __("Weekly backup"); ?></option>
-        <option value="2"<?php if ($r["bck_mode"]==2) echo " selected"; ?>><?php __("Daily backup"); ?></option>
+        <option value="0"<?php if ($r["bck"]==0) echo " selected"; ?>><?php __("No backup"); ?></option>
+        <option value="1"<?php if ($r["bck"]==1) echo " selected"; ?>><?php __("Weekly backup"); ?></option>
+        <option value="2"<?php if ($r["bck"]==2) echo " selected"; ?>><?php __("Daily backup"); ?></option>
         </select></td>
 </tr>
@@ -67 +67 @@
         for($i=1;$i<20;$i++) {
                 echo "<option";
-                if ($r["bck_history"]==$i) echo " selected";
+                if ($r["history"]==$i) echo " selected";
                 echo ">$i</option>";
         }
@@ -76 +76 @@
         <th><?php __("Compress the backups? (gzip)"); ?></th>
         <td><select class="inl" name="bck_gzip">
-        <option value="0"<?php if ($r["bck_gzip"]==0) echo " selected"; ?>><?php __("No"); ?></option>
-        <option value="1"<?php if ($r["bck_gzip"]==1) echo " selected"; ?>><?php __("Yes"); ?></option>
+        <option value="0"<?php if ($r["gzip"]==0) echo " selected"; ?>><?php __("No"); ?></option>
+        <option value="1"<?php if ($r["gzip"]==1) echo " selected"; ?>><?php __("Yes"); ?></option>
         </select></td>
 </tr>
@@ -83 +83 @@
 <tr class="lst1">
         <th><?php __("In which folder do you want to store the backups?"); ?></th>
-        <td><input type="text" class="int" name="bck_dir" size="30" maxlength="255" value="<?php echo $r["bck_dir"]; ?>">
+        <td><input type="text" class="int" name="bck_dir" size="30" maxlength="255" value="<?php echo $r["dir"]; ?>">
 <SCRIPT TYPE="text/javascript">
 <!--

bureau/class/m_mysql.php

@@ -1 +1 @@
 <?php
 /*
- $Id: m_mysql.php,v 1.6 2003/06/09 19:46:31 root Exp $
+ $Id: m_mysql.php,v 1.7 2003/06/09 19:53:35 root Exp $
  ----------------------------------------------------------------------
  AlternC - Web Hosting System
@@ -90 +90 @@
   function get_mysql_details($dbn) {
     global $db,$err,$bro,$mem;
+    $root="/var/alternc/html/".substr($mem->user["login"],0,1)."/".$mem->user["login"];
     $err->log("mysql","get_mysql_details");
     $dbname=$mem->user["login"].($dbn?"_":"").$dbn;
-    $db->query("SELECT pass,db, bck_mode, bck_dir FROM db WHERE uid=".$this->uid." AND db='$dbname';");
+    $db->query("SELECT pass,db, bck_mode, bck_gzip, bck_dir, bck_history FROM db WHERE uid=".$this->uid." AND db='$dbname';");
     if (!$db->num_rows()) {
       $err->raise("mysql",4);
@@ -101 +102 @@
     $size=$bro->fsize("/var/alternc/db/".$db->f("db")."/");
     list($dbu,$dbn)=explode("_",$db->f("db"));
-    return array("db"=>$db->f("db"), "name"=>$dbn,"bck"=>$db->f("bck_mode"), "dir"=>$db->f("bck_dir"), "size"=>$size, "pass"=>$db->f("pass"));
+    return array("db"=>$db->f("db"), "name"=>$dbn,"bck"=>$db->f("bck_mode"), "dir"=>substr($db->f("bck_dir"),strlen($root)), "size"=>$size, "pass"=>$db->f("pass"), "history"=>$db->f("bck_history"), "gzip"=>$db->f("bck_gzip"));
   }
 

install/scripts/mysql.sql

@@ -1 +1 @@
 #
-# $Id: mysql.sql,v 1.8 2003/06/09 14:48:48 root Exp $
+# $Id: mysql.sql,v 1.9 2003/06/09 19:53:36 root Exp $
 # ----------------------------------------------------------------------
 # AlternC - Web Hosting System
@@ -78 +78 @@
   login varchar(16) NOT NULL default '',                # Nom d'utilisateur mysql
   pass varchar(16) NOT NULL default '',                 # Mot de passe mysql
+  db varchar(64) NOT NULL default '',                   # Base de données concernée
   bck_mode tinyint(3) unsigned NOT NULL default '0',    # Mode de backup (0/non 1/Daily 2/Weekly)
   bck_history tinyint(3) unsigned NOT NULL default '0', # Nombre de backup à conserver ?