MySql problem

LittleMaffia · Nov 18, 2007

Hey guys

I have a problem with somthing but I dont really know what

I had to fill this in, in my config.php :

Code:

  [U]if[/U](!(@mysql_connect("localhost",  "DB Username","DB Password") && @mysql_select_db("littlema_crimenova1"))) {
    [U]print[/U] [B]<<<ENDHTML
<html>[/B]

I saved it and uploaded all other files.

Now it says cant connect to localhost or somthing like that The DB username and pass are fine and the db also.

maybe I have to change the localhost to somthing else, if yes in what do I have to change it?

eminemix · Nov 18, 2007

Can you copy/paste the exact error it gives ?

LittleMaffia · Nov 18, 2007

Er is een fout in de database, onze excuses hiervoor.

Thats dutch now ill translate it in english.

There is a mistake in the data base, our excuses for this.

EDIT: Here is the whole _include-config.php

Code:

<?php /* ------------------------- */include("gegevens.php");  if(!(@mysql_connect("localhost",  "USERNAME","PASSWORD") && @mysql_select_db("littlema_crimenova1"))) {    print <<<ENDHTML<html><head><title>$title</title><link rel="stylesheet" type="text/css" href="css-v1.css"></head><body style="background: #333333; margin: 0px;">  <table width=100%>    <tr><td class="subTitle"><b>Database Error</b></td></tr>    <tr><td class="mainTxt">	<center>$error</center>    </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>$title></title><link rel="stylesheet" type="text/css" href="css-v1.css"></head><body style="background: #333333; margin: 0px;">  <table width=100% height=100%>    <tr><td class="subTitle"><b>Ban</b></td></tr>    <tr><td class="mainTxt">	<center>$error</center>    </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['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')");      }    }  }/* ------------------------- */ ?>

Slothie · Nov 18, 2007

PHP:

<?php include("gegevens.php");
if (!(@mysql_connect("localhost",  "USERNAME","PASSWORD") && @mysql_select_db("littlema_crimenova1"))) {
    print <<<ENDHTML
		<html><head><title>$title</title><link rel="stylesheet" type="text/css" href="css-v1.css"></head><body style="background: #333333; margin: 0px;">  <table width=100%>    <tr><td class="subTitle"><b>Database Error</b></td></tr>    <tr><td class="mainTxt">	<center>$error</center>    </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>$title></title><link rel="stylesheet" type="text/css" href="css-v1.css"></head><body style="background: #333333; margin: 0px;">  <table width=100% height=100%>    <tr><td class="subTitle"><b>Ban</b></td></tr>    <tr><td class="mainTxt">	<center>$error</center>    </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['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')");
        }
    }
}
?>

Copy this exactly, please note that spacings are important when using <<<'s

LittleMaffia · Nov 18, 2007

Now im getting this error :/

Code:

[B]Parse error[/B]: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in [B]/home/littlema/public_html/_include-config.php[/B] on line [B]12

[/B]

Slothie · Nov 18, 2007

Might be it doesn't like { } tags to be separated by carriage returns.

MySql problem

LittleMaffia

New Member

eminemix

Member

LittleMaffia

New Member

Slothie

New Member

LittleMaffia

New Member

Slothie

New Member

Free Web Hosting

Our Community

Legal