Subversion-Projekte lars-tiefland.webhosting

<?
        //$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) $

        $mode=(isset($_POST["mode"]))?$_POST["mode"]:"";
        $id=intval(isset($_POST["id"])?$_POST["id"]:0);

        require_once("common.php");

        switch($mode)
        {
                case "details":
                        $smarty->assign("title", "Details zu Kunde $id");
                        $sql="SELECT * FROM kunden WHERE k_id=$id";
                        $res=$db->query($sql);
                        $row=$res->fetchRow(MDB2_FETCHMODE_ASSOC);
                        $k_nr=$row["k_id"];
                        $k_name=$row["vname"]." ".$row["nname"];
                        $k_email=$row["email"];
                        $k_domain=$row["domain"];
                        $k_dbs=$row["db_anz"];
                        $k_traffic=$row["traffic"];
                        $k_space=$row["space"];
                        $smarty->assign("k_nr",$k_nr);
                        $smarty->assign("k_name",$k_name);
                        $smarty->assign("k_email",$k_email);
                        $smarty->assign("k_domain",$k_domain);
                        $smarty->assign("k_email_type",($row["email_type"]==1)?"POP3/IMAP":"Weiterleitung");
                        $sql="SELECT * FROM emails WHERE k_id=$id";
                        $res=$db->query($sql);
                        while($row_e=$res->fetchRow(MDB2_FETCHMODE_ASSOC))
                        {
                                $k_emails.=$row_e["email"]."<br>";
                                $k_forwards.=$row_e["target"]."<br>";
                        }
                        $k_forwards=($row["email_type"])?"nicht n&ouml;tig":$k_forwards;
                        $smarty->assign("k_forwards", $k_forwards);
                        $smarty->assign("k_emails",$k_emails);
                        $smarty->assign("k_space",$k_space);
                        $smarty->assign("k_traffic",$k_traffic);
                        $smarty->assign("k_dbs",$k_dbs);
                        $smarty->assign("k_dbs_gen",($row["db_prefix"])?0:1);
                        $sql="SELECT * FROM software WHERE k_id=$id";
                        $res=$db->query($sql);
                        $row_s=$res->fetchRow(MDB2_FETCHMODE_ASSOC);
                        $k_webmail=(($row_s["webmail"]==1)?"V-Webmail":(($row_s["webmail"]==2)?"Squirrelmail":"keines"));
                        $k_forum=(($row_s["forum"]==1)?"phpBB":(($row_s["forum"]==2)?"SMF":"keines"));
                        $smarty->assign("k_webmail",$k_webmail);
                        $smarty->assign("k_forum",$k_forum);
                        $smarty->assign("k_gal",($row_s["copper"])?"Ja":"Nein");
                        $smarty->assign("k_adm",$row_s["admin_name"]);
                        $smarty->assign("k_adm_pw",$row_s["admin_pw"]);
                        $smarty->assign("k_svn",$row_s["repo_name"]);
                        $smarty->assign("k_os",($row_s["system"]==1)?"Gentoo Linux":"Debian");
                        if(file_exists("/home/svn/repos/".$row_s["repo_name"]))
                        {
                                $smarty->assign("repo",1);
                        }
                        else
                        {
                                $smarty->assign("repo",0);
                        }
                        $sql="SELECT * FROM svn_users WHERE k_id=$id";
                        $res=$db->query($sql);
                        while($row_u=$res->fetchRow(MDB2_FETCHMODE_ASSOC))
                        {
                                $k_svn_users.=$row_u["u_name"]." = ". $row_u["u_pw"]."<br>";
                        }
                        $smarty->assign("k_svn_users",$k_svn_users);
                        $smarty->display("details.tpl");
                        break;
                default:
                        $smarty->assign("title","Kundenliste");
                        $sql="SELECT * FROM kunden";
                        $res=$db->query($sql);
                        $i=0;
                        while($row=$res->fetchRow(MDB2_FETCHMODE_ASSOC))
                        {
                                $kunden[$i]["k_nr"]=$row["k_id"];
                                $kunden[$i]["k_name"]=$row["vname"]." ".$row["nname"];
                                $kunden[$i]["k_email"]=$row["email"];
                                $kunden[$i]["k_domain"]=$row["domain"];
                                $i++;
                        }
                        $smarty->assign("kunden",$kunden);
                        $smarty->display("index.tpl");
                        break;
        }
?>