Subversion-Projekte lars-tiefland.content-management

<?php
    $database_name = "content_management";

    $MySQL_Host = "localhost";
    if ( $_SERVER["SERVER_NAME"] != "server3" && !preg_match( "/local/i",
        $_SERVER["SERVER_NAME"] ) )
    {
        $MySQL_User = "content_managem";
        $MySQL_Passwd = "k-dp-u";
        $MySQL_Host_write = "213.203.217.142";
    }
    else
    {
        $MySQL_User = "root";
        $MySQL_Passwd = "";
        $PHP_AUTH_USER = "admin";
    }

    $self = basename( $PHP_SELF );
    //$path = "/usr/share/php/module/content-management/";

    require_once  $path . "whoami.php";
    if ( !$dbh = mysql_connect( "$MySQL_Host", "$MySQL_User", "$MySQL_Passwd" ) )
    {
        echo
            "Die Verbindung zum Datenbanksever konnte nicht hergestellt werden<br>";
        die( mysql_errno() . ": " . mysql_error() );
    }
    else
    {
        $localhost_dbh = $dbh;
        //echo "Die Verbindung zum Datenbanksever wurde hergestellt<br>";
    }

    mysql_select_db( "$database_name" );
    require_once  $path . "get_rechte.php";

        function date2HumanDate($date) {
                $d = substr($date,8,2);
                $m = substr($date,5,2);
                $y = substr($date,0,4);
                return $d.".".$m.".".$y;
        }

    function datetime2human( $date )
    {
        $date = preg_split( "/ /", $date );
        return array( "Datum" => join( ".", array_reverse( preg_split( "/-/",
            $date[0] ) ) ), "Zeit" => $date[1] );
    }

    function date2human( $date )
    {
        return join( ".", array_reverse( preg_split( "/-/", $date ) ) );
    }

    function human2date( $date )
    {
        return join( "-", array_reverse( preg_split( "/\./", $date ) ) );
    }

    function pre( $elem, $r = false )
    {
        $output = "<pre>" . htmlentities( print_r( $elem, true ) ) .
            "</pre>";

        if ( $r == true )
        {
            return $output;
        }
        else
        {
            echo $output;
        }
    }

    require_once  "loginTest.php";

    function getUserInfo()
    {
        $sql = "
            SELECT
                *
            FROM
                Access
            WHERE
                user='" . $_SERVER["PHP_AUTH_USER"] . "'
        ";
        $res = mysql_query( $sql );
        if ( $res )
        {
            $row = mysql_fetch_assoc( $res );
            $ret = $row;
        }
        if ( empty( $ret["name"] ) )
        {
            $ret["name"] = $_SERVER["PHP_AUTH_USER"];
        }
        return $ret;
    }

    $erg = getUserInfo();
    $_SESSION["USERNAME"] = $erg["name"];
    $_SESSION["U_ID"] = $erg["ID"];
    $_SESSION["U_EMAIL"] = $erg["email"];
    $_SESSION["U_TELEFON"] = $erg["telefon"];
    $_SESSION["U_FAX"] = $erg["fax"];
?>