php inlogscript

Status
Niet open voor verdere reacties.
E

element999

Gebruiker
Lid geworden
11 apr 2003
Berichten
87
hallo,

ik heb een probleem met een phpscript. op een of andere manier wil deze niet met mijn database connecten? willen jullie kijken of jullie misschien de fout zien zitten ?

of weten jullie anders een goeie debugger?

super bedankt alvast

groeten

Element999

<?php /* ------------------------- */

if(!(@mysql_connect("http://www.website.nl","gebruikersnaam","wachtwoord") && @mysql_select_db("database"))) {
print <<<ENDHTML
<html>


<head>
<title>[( Streetwar )]</title>
<link rel="stylesheet" type="text/css" href="css-v1.css">

</head>


<link rel="stylesheet" type="text/css" href="css-v1.css">
<table width=100%>
<tr><td class="subTitle"><b>Database Error</b></td></tr>
<tr><td class="mainTxt">
Er is een fout opgetreden in de database
</td></tr>
</table>
</body>

</html>
ENDHTML;
exit;
}


session_start();
include("_include-funcs.php");
if(isset($_SESSION['login'])) {
$dbres = mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup`,UNIX_TIMESTAMP(`online`) AS `online` FROM `[users]` WHERE `login`='{$_SESSION['login']}'");
$data = mysql_fetch_object($dbres);
}

if(((count($_POST) > 0 && !isset($_POST['omnilog'])) || ($_POST['omnilog'] == 1 && count($_GET) > 1)) && isset($OMNILOG)) {
$forwardedFor = ($_SERVER['HTTP_X_FORWARDED_FOR'] != "") ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['HTTP_CLIENT_IP'];
$forwardedFor = preg_replace('/, .+/','',$forwardedFor);
$postVars = addslashes(var_export($_POST,TRUE));
if($postVars == "array (\n)" || (count($_POST) == 1 && isset($_POST['omnilog'])))
$postVars = "";
$getVars = addslashes(var_export($_GET,TRUE));
if($getVars == "array (\n)")
$getVars = "";
mysql_query("INSERT INTO `[omnilog]` VALUES(NOW(),'{$_COOKIE['login']}','{$_SERVER['REMOTE_ADDR']}','$forwardedFor','{$_SERVER['PHP_SELF']}','$postVars','$getVars')");
}

foreach($_POST as $key => $value) {
if(gettype($_POST[$key]) == "array")
foreach($_POST[$key] as $key2 => $value2)
$_POST[$key][$key2] = addslashes($_POST[$key][$key2]);
else
$_POST[$key] = addslashes($_POST[$key]);
}
foreach($_GET as $key => $value) {
if(gettype($_GET[$key]) == "array")
foreach($_GET[$key] as $key2 => $value2)
$_GET[$key][$key2] = addslashes($_GET[$key][$key2]);
else
$_GET[$key] = addslashes($_GET[$key]);
}
foreach($_COOKIE as $key => $value) {
if(gettype($_COOKIE[$key]) == "array")
foreach($_COOKIE[$key] as $key2 => $value2)
$_COOKIE[$key][$key2] = addslashes($_COOKIE[$key][$key2]);
else
$_COOKIE[$key] = addslashes($_COOKIE[$key]);
}



$clientIP = $_SERVER['REMOTE_ADDR'];
$forwardedFor = ($_SERVER['HTTP_X_FORWARDED_FOR'] != "") ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['HTTP_CLIENT_IP'];
$forwardedFor = preg_replace('/, .+/','',$forwardedFor);
$dbres = mysql_query("SELECT `id` FROM `[users]` WHERE `level`='-1' AND (`IP`='$clientIP' OR `IP`='$forwardedFor')");
if(mysql_num_rows($dbres) != 0) {
print <<<ENDHTML
<html>


<head>
<title>[( Streetwar )]</title>
<link rel="stylesheet" type="text/css" href="css-v1.css">

</head>


<link rel="stylesheet" type="text/css" href="css-v1.css">
<table width=100% height=100%>
<tr><td class="subTitle"><b>Ban</b></td></tr>
<tr><td class="mainTxt">
Het IP waarmee je speelt is geband
</td></tr>
</table>
</body>

</html>
ENDHTML;
exit;
}



if(isset($UPDATE_DB)) {
$dbres = mysql_query("SELECT UNIX_TIMESTAMP(`time`) AS `time`,`name` FROM `[cron]`");
while($x = mysql_fetch_object($dbres))
$update[$x->name] = $x->time;

if(floor($update['hours']/7200) != floor(time()/7200)) {
$dbres = mysql_query("SELECT GET_LOCK('hours_update',0)");
if(mysql_result($dbres,0) == 1) {
$cron_pass = "secretcronpassword";
mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='hours'");
include("_cron_hours.php");
mysql_query("SELECT RELEASE_LOCK('hours_update')");
}
}

if(floor($update['hour']/3600) != floor(time()/3600)) {
$dbres = mysql_query("SELECT GET_LOCK('hour_update',0)");
if(mysql_result($dbres,0) == 1) {
$cron_pass = "secretcronpassword";
mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='hour'");
include("_cron_hour.php");
mysql_query("SELECT RELEASE_LOCK('hour_update')");
}
}

if(floor($update['day']/86400) != floor(time()/86400)) {
$dbres = mysql_query("SELECT GET_LOCK('day_update',0)");
if(mysql_result($dbres,0) == 1) {
$cron_pass = "secretcronpassword";
mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='day'");
include("_cron_day.php");
mysql_query("SELECT RELEASE_LOCK('day_update')");
}
}

if(floor($update['week']/604800) != floor(time()/604800)) {
$dbres = mysql_query("SELECT GET_LOCK('week_update',0)");
if(mysql_result($dbres,0) == 1) {
$cron_pass = "secretcronpassword";
mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='week'");
include("_cron_week.php");
mysql_query("SELECT RELEASE_LOCK('week_update')");
}
}

if(date('n',$update['month']) != date('n',time())) {
$dbres = mysql_query("SELECT GET_LOCK('month_update',0)");
if(mysql_result($dbres,0) == 1) {
$cron_pass = "secretcronpassword";
mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='month'");
include("_cron_month.php");
mysql_query("SELECT RELEASE_LOCK('month_update')");
}
}

if((date('G',time()) >= 16 && date('z',time()) != date('z',$update['horserace'])) || (date('G',time()) >= 21 && date('G',$update['horserace']) < 21)) {
$dbres = mysql_query("SELECT GET_LOCK('horserace_update',0)");
if(mysql_result($dbres,0) == 1) {
$cron_pass = "secretcronpassword";
mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='horserace'");
include("_cron_horserace.php");
mysql_query("SELECT RELEASE_LOCK('horserace_update')");
}
}
}

/* ------------------------- */ ?>
 
if(!(@mysql_connect("http://www.website.nl","gebruikersnaam","wachtwoord") && @mysql_select_db("database"))) {
print <<<ENDHTML

:P moet het echt zo ingewikkeld. Nuja het zou moeten werken als die print <<<ENDHTML werkt...
Anyway, wat geeft ie als output?
 
Wat is de foutmelding die MySQL geeft, waarom kan die verbinding niet tot stand worden gebracht ?
 
ik ben er al uit. de localhost stond verkeerd ingevult.

dank voor het meedenken !

groeten

Element999
 
Status
Niet open voor verdere reacties.
                    Steun ons                    

Nieuwste berichten

Terug
Bovenaan Onderaan