| 78 |
lars |
1 |
<?
|
|
|
2 |
//$URL: http://repos.lars-tiefland.de:8080/svn/webhosting/trunk/admin/index.php $ last modified in Revision $Rev: 63 $ by $Author: lars $ at $Date: 2007-06-14 22:03:02 +0200 (Do, 14. Jun 2007) $
|
|
|
3 |
|
|
|
4 |
$mode=(isset($_POST["mode"]))?$_POST["mode"]:"";
|
|
|
5 |
$id=intval(isset($_POST["id"])?$_POST["id"]:0);
|
|
|
6 |
|
|
|
7 |
require_once("common.php");
|
|
|
8 |
|
|
|
9 |
switch($mode)
|
|
|
10 |
{
|
|
|
11 |
case "details":
|
|
|
12 |
$smarty->assign("title", "Details zu Kunde $id");
|
|
|
13 |
$sql="SELECT * FROM kunden WHERE k_id=$id";
|
|
|
14 |
$res=$db->query($sql);
|
|
|
15 |
$row=$res->fetchRow(MDB2_FETCHMODE_ASSOC);
|
|
|
16 |
$k_nr=$row["k_id"];
|
|
|
17 |
$k_name=$row["vname"]." ".$row["nname"];
|
|
|
18 |
$k_email=$row["email"];
|
|
|
19 |
$k_domain=$row["domain"];
|
|
|
20 |
$k_dbs=$row["db_anz"];
|
|
|
21 |
$k_traffic=$row["traffic"];
|
|
|
22 |
$k_space=$row["space"];
|
|
|
23 |
$smarty->assign("k_nr",$k_nr);
|
|
|
24 |
$smarty->assign("k_name",$k_name);
|
|
|
25 |
$smarty->assign("k_email",$k_email);
|
|
|
26 |
$smarty->assign("k_domain",$k_domain);
|
|
|
27 |
$smarty->assign("k_email_type",($row["email_type"]==1)?"POP3/IMAP":"Weiterleitung");
|
|
|
28 |
$sql="SELECT * FROM emails WHERE k_id=$id";
|
|
|
29 |
$res=$db->query($sql);
|
|
|
30 |
while($row_e=$res->fetchRow(MDB2_FETCHMODE_ASSOC))
|
|
|
31 |
{
|
|
|
32 |
$k_emails.=$row_e["email"]."<br>";
|
|
|
33 |
$k_forwards.=$row_e["target"]."<br>";
|
|
|
34 |
}
|
|
|
35 |
$k_forwards=($row["email_type"])?"nicht nötig":$k_forwards;
|
|
|
36 |
$smarty->assign("k_forwards", $k_forwards);
|
|
|
37 |
$smarty->assign("k_emails",$k_emails);
|
|
|
38 |
$smarty->assign("k_space",$k_space);
|
|
|
39 |
$smarty->assign("k_traffic",$k_traffic);
|
|
|
40 |
$smarty->assign("k_dbs",$k_dbs);
|
|
|
41 |
$smarty->assign("k_dbs_gen",($row["db_prefix"])?0:1);
|
|
|
42 |
$sql="SELECT * FROM software WHERE k_id=$id";
|
|
|
43 |
$res=$db->query($sql);
|
|
|
44 |
$row_s=$res->fetchRow(MDB2_FETCHMODE_ASSOC);
|
|
|
45 |
$k_webmail=(($row_s["webmail"]==1)?"V-Webmail":(($row_s["webmail"]==2)?"Squirrelmail":"keines"));
|
|
|
46 |
$k_forum=(($row_s["forum"]==1)?"phpBB":(($row_s["forum"]==2)?"SMF":"keines"));
|
|
|
47 |
$smarty->assign("k_webmail",$k_webmail);
|
|
|
48 |
$smarty->assign("k_forum",$k_forum);
|
|
|
49 |
$smarty->assign("k_gal",($row_s["copper"])?"Ja":"Nein");
|
|
|
50 |
$smarty->assign("k_adm",$row_s["admin_name"]);
|
|
|
51 |
$smarty->assign("k_adm_pw",$row_s["admin_pw"]);
|
|
|
52 |
$smarty->assign("k_svn",$row_s["repo_name"]);
|
|
|
53 |
$smarty->assign("k_os",($row_s["system"]==1)?"Gentoo Linux":"Debian");
|
|
|
54 |
if(file_exists("/home/svn/repos/".$row_s["repo_name"]))
|
|
|
55 |
{
|
|
|
56 |
$smarty->assign("repo",1);
|
|
|
57 |
}
|
|
|
58 |
else
|
|
|
59 |
{
|
|
|
60 |
$smarty->assign("repo",0);
|
|
|
61 |
}
|
|
|
62 |
$sql="SELECT * FROM svn_users WHERE k_id=$id";
|
|
|
63 |
$res=$db->query($sql);
|
|
|
64 |
while($row_u=$res->fetchRow(MDB2_FETCHMODE_ASSOC))
|
|
|
65 |
{
|
|
|
66 |
$k_svn_users.=$row_u["u_name"]." = ". $row_u["u_pw"]."<br>";
|
|
|
67 |
}
|
|
|
68 |
$smarty->assign("k_svn_users",$k_svn_users);
|
|
|
69 |
$smarty->display("details.tpl");
|
|
|
70 |
break;
|
|
|
71 |
default:
|
|
|
72 |
$smarty->assign("title","Kundenliste");
|
|
|
73 |
$sql="SELECT * FROM kunden";
|
|
|
74 |
$res=$db->query($sql);
|
|
|
75 |
$i=0;
|
|
|
76 |
while($row=$res->fetchRow(MDB2_FETCHMODE_ASSOC))
|
|
|
77 |
{
|
|
|
78 |
$kunden[$i]["k_nr"]=$row["k_id"];
|
|
|
79 |
$kunden[$i]["k_name"]=$row["vname"]." ".$row["nname"];
|
|
|
80 |
$kunden[$i]["k_email"]=$row["email"];
|
|
|
81 |
$kunden[$i]["k_domain"]=$row["domain"];
|
|
|
82 |
$i++;
|
|
|
83 |
}
|
|
|
84 |
$smarty->assign("kunden",$kunden);
|
|
|
85 |
$smarty->display("index.tpl");
|
|
|
86 |
break;
|
|
|
87 |
}
|
|
|
88 |
?>
|