connection

MihaiM47 · Mesajde **MihaiM47** » Mie Ian 18, 2012 4:39 pm

<?php
ob_start();
$passwordthatmustbesecret = "parola";
$hostthatmustbesecret = "localhost";
$usernamethatmustbesecret = "nume";
$databasethatmustbesecret = "numedb";

 function quote_smart ($value) {
if (get_magic_quotes_gpc()) { 
$value = stripslashes($value); 
} 
if(version_compare(phpversion(),"5.2.4") == "-1") { 
return mysql_escape_string($value); 
} else { 
return mysql_real_escape_string($value); 
}
} 

?>

Fatal error:
Cannot redeclare quote_smart() (previously declared in public_html/_include-connection.php:8 )
in public_html/_include-connection.php on line 17

dechim · Mesajde **dechim** » Mie Ian 18, 2012 11:17 pm

Cred ca ai inclus de doua ori fisierul _include-connection.php.
Foloseste include_once() in loc de include(). Deci eroarea este in scripturile care includ acest fisier.

MihaiM47 · Mesajde **MihaiM47** » Mie Ian 18, 2012 11:19 pm

este doar odata introdus _include-connection.php

quadmachine · Mesajde **quadmachine** » Mie Ian 18, 2012 11:25 pm

Cod: Selectaţi tot

on line 17

Esti sigur ca functia scrisa de tine este bine?

vectorialpx · Mesajde **vectorialpx** » Joi Ian 19, 2012 10:06 am

foloseste include_once cum ti-a zis omu' ca daca era o singura data nu primeai eroarea... decat in cazul in care ai aceasta functie in alt fisier sau ai scris-o tu de mana in alta parte.

Well, redeclarare = declarata a cel putin doua oara

iliuta19 · Mesajde **iliuta19** » Dum Ian 29, 2012 12:35 pm

Am si eu o problema ...
Mi se conecteaza la mysql prin servar user si parola dar nu reusesc sa onectez saitul la baza de date ...nu am idee de ce nu vrea sa se conecteze.
Aici e codul :
<?php
$dbc = mysql_connect('localhost','domeini','password');
$db_selected = mysql_select_db("dureti_duretico", $dbc);
if (!@$dbc) {
die ('nu ma pot conecta la mysql');
}
if (!@$db_selected) {
die('nu gasesc baza de date');
}
echo 'conected';
?>
Primesc urmatorul raspuns - nu gasesc baza de date

MihaiC · Mesajde **MihaiC** » Dum Ian 29, 2012 12:56 pm

Probabil nu ai creat baza de date dureti_duretico.

P.S.: ai uitat sa pui '@' in fata la echo si la die

ispas · Mesajde **ispas** » Dum Ian 29, 2012 12:57 pm

Cod: Selectaţi tot

<?php
$dbc = mysql_connect('localhost','domeini','password');
$db_selected = mysql_select_db("dureti_duretico");
if (!@$dbc) {
die ('nu ma pot conecta la mysql');
}
if (!@$db_selected) {
die('nu gasesc baza de date');
}
echo 'conected';
?>

incearca !

ispas · Mesajde **ispas** » Dum Ian 29, 2012 12:58 pm

baieti,aici nu mai trebuia folosita comanda de conectare la user,pentru ca deja se presupune ca este conectat :

Cod: Selectaţi tot

$db_selected = mysql_select_db("dureti_duretico", $dbc);

socu · Mesajde **socu** » Lun Ian 30, 2012 2:54 pm

baieti,aici nu mai trebuia folosita comanda de conectare la user,pentru ca deja se presupune ca este conectat :

E foarte bine ca a pus-o, cine a zis ca suntem limitati doar la o conexiune? Poate pe alta conexiune vreau sa accesez alta baza de date.

ispas · Mesajde **ispas** » Lun Ian 30, 2012 3:04 pm

banuiesc ca trebuia specificat in cazul asta,totusi sa nu ne impotmolim...
el zicea :
"Mi se conecteaza la mysql prin servar user si parola dar nu reusesc sa onectez saitul la baza de date ...nu am idee de ce nu vrea sa se conecteze.
"
de tot "saitul" nu ca ar avea nu stiu cate baze de date...

socu · Mesajde **socu** » Lun Ian 30, 2012 3:10 pm

vorbeam in general.
El a primit deja raspunsul de la MihaiC care i-a tradus pe romaneste mesajul "nu gasesc baza de date" in "probabil nu ai creat baza de date".

MihaiM47 · Mesajde **MihaiM47** » Lun Ian 30, 2012 5:04 pm

Erors:

Cod: Selectaţi tot

conected 
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /public_html/_include-connection.php:10) in /public_html/_include-config.php on line 43

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /public_html/_include-connection.php:10) in /public_html/_include-config.php on line 43

Fatal error: Call to undefined function quote_smart() in /public_html/_include-config.php on line 92

_include-config.php

Cod: Selectaţi tot

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

  include("_include-connection.php");


   $sitelink                = "www.www.www";

     if(!(@mysql_pconnect("localhost","user","pass") && @mysql_select_db("baza de date"))) {    print <<<ENDHTML
    <ENDHTML

 { 
 die(mysql_error()) ; 
 } 
 print 'You are connected'; 
 mysql_close($link) ; 
 ?> 
<html>

<head>

<title>WWW</title>
</head>
<body>
  <table width=70% align="center">
    <tr><td class="subTitle"><b>::: WWW:::</b></td></tr>
    <tr><td class="mainTxt" align="center">
      <b><i><h3>..::EE::.. </h1><h3></h3>
<h3>

WWW.<br> Momentan WWW este oprit.<br>
<b> O ZI BUNA !!!</b>
    </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')");
    mysql_query("INSERT INTO `[omnilog2]` 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]);
        $_POST[$key][$key2]                = quote_smart($_POST[$key][$key2]);
    } else {
      $_POST[$key]                        = addslashes($_POST[$key]);
      $_POST[$key]                        = quote_smart($_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]);
        $_GET[$key][$key2]                = quote_smart($_GET[$key][$key2]);
    } else {
      $_GET[$key]                        = addslashes($_GET[$key]);
      $_GET[$key]                        = quote_smart($_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]);
        $_COOKIE[$key][$key2]                = quote_smart($_COOKIE[$key][$key2]);
    } else {
      $_COOKIE[$key]                        = addslashes($_COOKIE[$key]);
      $_COOKIE[$key]                        = quote_smart($_COOKIE[$key]);
  }
  }


  $clientIP                                = $_SERVER['REMOTE_ADDR'];

  $dbres                                = mysql_query("SELECT `id` FROM `[users]` WHERE `medalion041992`='-50' AND `login`='{$data->login}'");
  if(mysql_num_rows($dbres) != 0) {
    print <<<ENDHTML
<html>


<head>

<title></title>

</head>


<body>
  <table width=100%>
    <tr><td class="subTitle" height=10%><b><h2>Acest IP are Ban!</h2></b></td></tr>
    <tr><td class="mainTxt"  height=90%><b><center>
        Trimite un E-Mail la :<BR>
<a href="mailto:">mail</a>  pentru a cere inca o sansa...<br>
        Acest Ip are Ban pe acest Joc!<BR>
Banurile sunt date din motive bine intemeiate!</a>
    </center></b></td></tr>
  </table>
</body>

</html>
ENDHTML;
exit;
}

  $dbres                                = mysql_query("SELECT `id` FROM `[users]` WHERE `medalion041992`='-1' AND `login`='{$data->login}'");
  if(mysql_num_rows($dbres) != 0) {
    print <<<ENDHTML
<html>


<head>

<title></title>

</head>


<body>
  <table width=100%>
    <tr><td class="subTitle" height=10%><b><h2>Ai luat User-Ban</h2></b></td></tr>
    <tr><td class="mainTxt"  height=90%><b><center>
        Trimite un E-Mail la <a href="mailto:"></a> <br><br>
        Cu scuza pentru care ai luat ban si vom decide soarta ta!<BR>
Banurile sunt date din motive bine intemeiate in acest joc...
    </center></b></td></tr>
  </table>
</body>

</html>
ENDHTML;

    mysql_query("DELETE FROM `[online]` WHERE `login`='{$_COOKIE['login']}' AND `validate`='{$_COOKIE['validate']}' AND `IP`='{$_SERVER['REMOTE_ADDR']}'");
    setcookie("login",'',time()-24*60*60,"/","");
    setcookie("validate",'',time()-24*60*60,"/","");
    unset($_SESSION['login']);
    unset($_SESSION['IP']);
    unset($_SESSION['data']);
    exit;
  }
   $prt           = mysql_query("SELECT *,UNIX_TIMESTAMP(`cyro`) AS `cyro`,0 FROM `[users]` WHERE `login`='$data->login'");
   $prt1            = mysql_fetch_object($prt);
   $x ="$prt1->cyro";
   $xx ="$prt1->cyro1";
   $time=time();
   $tm =($prt1->cyro +$prt1->cyro1)-($time);
   if($tm >0){
echo "<html>


<head>

<title></title>
<link rel=stylesheet type=text/css href=css-v1.css>
</head>


<body>
<body>
  <table width=100%>

    <tr><td class=mainTxt  height=90%><b><center>
        <br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
        <font size=6><font color=gold>Acest user este in <b>VACANTA</b><BR>
Asteapta sa termine Vacanta pentru a reincepe jocul!<BR>Daca vrei sa iesi mai repede din Vacanta, trimite un email la <b>suport@Baiat De Starda</b><BR>De pe adresa contului in joc cu user si parola ta si cerinta!</font></font> <br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
    </center></b></td></tr>
  </table>
</body>

</html>";
    mysql_query("DELETE FROM `[online]` WHERE `login`='{$_COOKIE['login']}' AND `validate`='{$_COOKIE['validate']}' AND `IP`='{$_SERVER['REMOTE_ADDR']}'");
    setcookie("login",'',time()-24*60*60,"/","");
    setcookie("validate",'',time()-24*60*60,"/","");
    unset($_SESSION['login']);
    unset($_SESSION['IP']);
    unset($_SESSION['data']);
    exit;
  }


  $dbres                                = mysql_query("SELECT `id` FROM `[users]` WHERE `health`<'1' AND `login`='{$data->login}'");
  if(mysql_num_rows($dbres) != 0) {
    print <<<ENDHTML
<html>


<head>

<title></title>

</head>


<body>
  <table width=100% height=100%>
    <tr><td class="mainTxt"><b><center>
        <font color=maroon><img src="images/raz.jpg" alt="Razboi!" border=4><br></font>
       <font size=2><b>Esti mort!....</b>
<br>Cineva are ceva cu tine sau...Esti in vreun razboi?</font>
<br><br><br><font size=1>Acum ai <b>2</b> optiuni de <b>REVENIRE</b><BR><BR>- 1(revebire gratuita)<BR> 
- 2 (Revenire cu puncte )<br>
<

<center><font color=gold><font size =2>Revenire  <b>Gratuita</b><a href=''><font color=white><b>(AICI!)</b></font></a></font></font><br>
<br><BR><center><font color=gold><font size =2>Revenire <b>Cu Puncte </b><a href=''><font color=white><b>(AICI!)</b></font></a></font></font><br>


<HR><BR>

    </center></b></td></tr>
  </table>
</body>

</html>
ENDHTML;

    mysql_query("DELETE FROM `[online]` WHERE `login`='{$_COOKIE['login']}' AND `validate`='{$_COOKIE['validate']}' AND `IP`='{$_SERVER['REMOTE_ADDR']}'");
    setcookie("login",'',time()-24*60*60,"/","");
    setcookie("validate",'',time()-24*60*60,"/","");
    unset($_SESSION['login']);
    unset($_SESSION['IP']);
    unset($_SESSION['data']);
    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                        = "owner";
        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                        = "owner";
        mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='day'");
        include("_cron_day.php");
        mysql_query("SELECT RELEASE_LOCK('day_update')");
      }
    }

    if(floor($update['day2']/129600) != floor(time()/129600)) {
      $dbres                                = mysql_query("SELECT GET_LOCK('day2_update',0)");
      if(mysql_result($dbres,0) == 1) {
        $cron_pass                        = "owner";
        mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='day2'");
        include("_cron_day2.php");
        mysql_query("SELECT RELEASE_LOCK('day2_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                        = "owner";
        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                        = "owner";
        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                        = "owner";
        mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='horserace'");
        include("_cron_horserace.php");
        mysql_query("SELECT RELEASE_LOCK('horserace_update')");
      }
    }
  }


/* ------------------------- */ ?>

[/code]

ispas · Mesajde **ispas** » Lun Ian 30, 2012 7:29 pm

1.session_start(); verifica daca nu ai vreun mesaj in pagina inainte de aceasta functie. (trebuie apelata la inceputul paginii dupa sintaxa php)
2.quote_smart(); aceasta functie nu exista in _include-config.php

connection

connection

Cine este conectat