| 78 |
lars |
1 |
<?
|
|
|
2 |
//$URL: http://repos.lars-tiefland.de:8080/svn/webhosting/trunk/admin/gen_dbs.php $ last modified in Revision $Rev: 57 $ by $Author: lars $ at $Date: 2007-06-10 16:34:45 +0200 (So, 10. Jun 2007) $
|
|
|
3 |
require_once("common.php");
|
|
|
4 |
$mode=(isset($_POST["mode"]))?$_POST["mode"]:"";
|
|
|
5 |
$id=intval(isset($_POST["id"])?$_POST["id"]:0);
|
|
|
6 |
$user=(isset($_POST["user"]))?$_POST["user"]:"";
|
|
|
7 |
$pass=(isset($_POST["pass"]))?$_POST["pass"]:"";
|
|
|
8 |
$prefix=(isset($_POST["prefix"]))?$_POST["prefix"]:"";
|
|
|
9 |
$smarty->assign("title","Datenbanken anlegen");
|
|
|
10 |
$smarty->assign("h1","Datenbanken für Kunden $id anlegen");
|
|
|
11 |
if($id==0)
|
|
|
12 |
{
|
|
|
13 |
$smarty->assign("error",true);
|
|
|
14 |
$smarty->assign("meld","Es ist ein Fehler aufgetreten!");
|
|
|
15 |
$smarty->assign("db_meld","Keine Kundennummer übergeben!");
|
|
|
16 |
$smarty->display("meld.tpl");
|
|
|
17 |
exit;
|
|
|
18 |
}
|
|
|
19 |
$smarty->assign("k_nr",$id);
|
|
|
20 |
switch($mode)
|
|
|
21 |
{
|
|
|
22 |
case "save":
|
|
|
23 |
$query="SELECT db_anz FROM kunden WHERE k_id=$id";
|
|
|
24 |
$res=$db->query($query);
|
|
|
25 |
$row=$res->fetchRow(MDB2_FETCHMODE_ASSOC);
|
|
|
26 |
$db_anz=$row["db_anz"];
|
|
|
27 |
$query="UPDATE kunden SET db_user='$user', db_pass='$pass', db_prefix='$prefix'";
|
|
|
28 |
$res=$db->exec($query);
|
|
|
29 |
if (PEAR::isError($res))
|
|
|
30 |
{
|
|
|
31 |
$smarty->assign("error",true);
|
|
|
32 |
$smarty->assign("meld","Es ist ein Fehler aufgetreten!");
|
|
|
33 |
$smarty->assign("db_meld",$res->getUserInfo());
|
|
|
34 |
$error=true;
|
|
|
35 |
$smarty->display("meld.tpl");
|
|
|
36 |
exit;
|
|
|
37 |
}
|
|
|
38 |
for ($i=1; $i <= $db_anz;$i++)
|
|
|
39 |
{
|
|
|
40 |
$db_name=$prefix.sprintf("%02d",$i);
|
|
|
41 |
$query="CREATE DATABASE $db_name";
|
|
|
42 |
$res=$db->exec($query);
|
|
|
43 |
if (PEAR::isError($res))
|
|
|
44 |
{
|
|
|
45 |
$smarty->assign("error",true);
|
|
|
46 |
$smarty->assign("meld","Es ist ein Fehler aufgetreten!");
|
|
|
47 |
$smarty->assign("db_meld",$res->getUserInfo());
|
|
|
48 |
$error=true;
|
|
|
49 |
break;
|
|
|
50 |
}
|
|
|
51 |
$error=false;
|
|
|
52 |
$query_r="GRANT ALL PRIVILEGES ON `$db_name`.* TO $user@localhost IDENTIFIED BY '$pass'";
|
|
|
53 |
$res_r=$db->exec($query_r);
|
|
|
54 |
if (PEAR::isError($res_r))
|
|
|
55 |
{
|
|
|
56 |
$smarty->assign("error",true);
|
|
|
57 |
$smarty->assign("meld","Es ist ein Fehler aufgetreten!");
|
|
|
58 |
$smarty->assign("db_meld",$res_r->getUserInfo());
|
|
|
59 |
$error=true;
|
|
|
60 |
break;
|
|
|
61 |
}
|
|
|
62 |
$error=false;
|
|
|
63 |
}
|
|
|
64 |
if(!$error)
|
|
|
65 |
{
|
|
|
66 |
$smarty->assign("meld","Datenbanken für Kunden $id erfolgreich angelegt!");
|
|
|
67 |
$smarty->assign("db_meld","");
|
|
|
68 |
}
|
|
|
69 |
$smarty->display("meld.tpl");
|
|
|
70 |
break;
|
|
|
71 |
default:
|
|
|
72 |
$smarty->assign("title","Datenbanken anlegen");
|
|
|
73 |
$smarty->assign("h1", "Datenbanken für Kunde $id anlegen");
|
|
|
74 |
$smarty->display("gen_dbs.tpl");
|
|
|
75 |
break;
|
|
|
76 |
}
|
|
|
77 |
?>
|