| 1 |
lars |
1 |
<?
|
|
|
2 |
session_start();
|
|
|
3 |
|
|
|
4 |
$database_name = "content_management";
|
|
|
5 |
|
|
|
6 |
$self = basename( $PHP_SELF );
|
|
|
7 |
$MySQL_Host = "localhost";
|
|
|
8 |
|
|
|
9 |
if ( $_SERVER["SERVER_NAME"] != "server2" )
|
|
|
10 |
{
|
|
|
11 |
$MySQL_User = "Shop_Daemon";
|
|
|
12 |
$MySQL_Passwd = "S-Jp-g";
|
|
|
13 |
}
|
|
|
14 |
|
|
|
15 |
else
|
|
|
16 |
{
|
|
|
17 |
$MySQL_User = "root";
|
|
|
18 |
$MySQL_Passwd = "";
|
|
|
19 |
$PHP_AUTH_USER = "admin";
|
|
|
20 |
$root = -1;
|
|
|
21 |
}
|
|
|
22 |
|
|
|
23 |
// Verbindung zum Server herstellen
|
|
|
24 |
if ( !$dbh = mysql_pconnect("$MySQL_Host", "$MySQL_User", "$MySQL_Passwd") )
|
|
|
25 |
{
|
|
|
26 |
echo "Die Verbindung zum Datenbanksever konnte nicht hergestellt werden<br>";
|
|
|
27 |
die( mysql_errno() . ": " . mysql_error() );
|
|
|
28 |
}
|
|
|
29 |
|
|
|
30 |
// Datenbank CMS anwählen
|
|
|
31 |
if ( !$db = mysql_select_db("$database_name") )
|
|
|
32 |
{
|
|
|
33 |
echo "Die Verbindung zur Datenbank <font color=\"#FF0000\">$database_name</font> konnte nicht hergestellt werden<br>";
|
|
|
34 |
die( mysql_errno() . ": " . mysql_error() );
|
|
|
35 |
}
|
|
|
36 |
|
|
|
37 |
// Kundenrechte einlesen
|
|
|
38 |
// require_once "../get_rechte.php";
|
|
|
39 |
// Datenbank des Kunden auslesen
|
|
|
40 |
require_once "../whoami.php";
|
|
|
41 |
$query = "SELECT * from webs where domain='$site'";
|
|
|
42 |
$result = mysql_query( $query ) or die( mysql_errno() . ": " . mysql_error() .
|
|
|
43 |
$query );
|
|
|
44 |
$webs = mysql_fetch_array( $result );
|
|
|
45 |
|
|
|
46 |
// Falls ein remoteServer eingetragen ist Verbindung zu diesem Server herstellen
|
|
|
47 |
if ( $webs[db_server] )
|
|
|
48 |
{
|
|
|
49 |
if ( !$remoteServer_dbh = mysql_connect($webs[db_server], $webs[db_username],
|
|
|
50 |
$webs[db_password]) )
|
|
|
51 |
{
|
|
|
52 |
echo "Die Verbindung zum Datenbanksever konnte nicht hergestellt werden<br>";
|
|
|
53 |
die( mysql_errno() . ": " . mysql_error() );
|
|
|
54 |
}
|
|
|
55 |
}
|
|
|
56 |
|
|
|
57 |
// Shop-Datenbank anwählen
|
|
|
58 |
if ( !$db = mysql_select_db($webs[datenbank]) )
|
|
|
59 |
{
|
|
|
60 |
echo "Die Verbindung zur Datenbank <font color=\"#FF0000\">$webs[datenbank]</font> konnte nicht hergestellt werden<br>";
|
|
|
61 |
die( mysql_errno() . ": " . mysql_error() );
|
|
|
62 |
}
|
|
|
63 |
if ( !$webs[bgcolor_seite] )
|
|
|
64 |
{
|
|
|
65 |
$webs[bgcolor_seite] = "FFFFFF";
|
|
|
66 |
}
|
|
|
67 |
if ( !$webs[bgcolor_links] )
|
|
|
68 |
{
|
|
|
69 |
$webs[bgcolor_links] = "FFFFFF";
|
|
|
70 |
}
|
|
|
71 |
if ( !$webs[bgcolor_rechts] )
|
|
|
72 |
{
|
|
|
73 |
$webs[bgcolor_rechts] = "FFFFFF";
|
|
|
74 |
}
|
|
|
75 |
|
|
|
76 |
// Variablen freigeben
|
|
|
77 |
unset( $query );
|
|
|
78 |
unset( $result );
|
|
|
79 |
|
|
|
80 |
function datetime2human( $date )
|
|
|
81 |
{
|
|
|
82 |
$date = preg_split( "/ /", $date );
|
|
|
83 |
return array( "Datum" => join(".", array_reverse(preg_split("/-/", $date[0]))),
|
|
|
84 |
"Zeit" => $date[1] );
|
|
|
85 |
}
|
|
|
86 |
|
|
|
87 |
function date2human( $date )
|
|
|
88 |
{
|
|
|
89 |
return join( ".", array_reverse(preg_split("/-/", $date)) );
|
|
|
90 |
}
|
|
|
91 |
|
|
|
92 |
function human2date( $date )
|
|
|
93 |
{
|
|
|
94 |
return join( "-", array_reverse(preg_split("/\./", $date)) );
|
|
|
95 |
}
|
|
|
96 |
|
|
|
97 |
require_once "../loginTest.php";
|
|
|
98 |
?>
|