Nieuwe Bug

Gangstawar · 11 Mei 2009

beste cp'ers

ik heb een probleem bij mijn banditi
als je aan het spelen bent krijg je een error

Geen verbinding...Geen verbinding...Geen verbinding...

dit heeft met een connection of config te maken alleen het probleem is dat hij online is en dat je na een paar minuten spelen deze error krijgt en dat is gewoon willekeurig bij een pagina
weet iemand de oplossing of weet iemand wat dit is zou u dan kunnen melden wat het is

alvast bedankt met vriendelijke groeten Gangstawar

CrimeWasted · 11 Mei 2009

Dit licht aan de hosting, gebruik je primawebhosting?

Gangstawar · 11 Mei 2009

ik gebruik euro-host.info

de servers zijn van aviestar production

CrimeWasted · 11 Mei 2009

Ik heb dit probleem ook gehad met primawebhositing, probeer het is bij een andere host

Gangstawar · 11 Mei 2009

ik heb het geprobeerd via een vriend van mijn hij krijgt deze error ook en hij host bij lycos (betaald)

insaneflame · 11 Mei 2009

lycos stinkt als je het mij vraagt

Gangstawar · 11 Mei 2009

maar alsnog heeft iemand hier een idee van wat het is of ligt het aan me connections en configs

insaneflame · 11 Mei 2009

connections ja

Stefan.J · 11 Mei 2009

Plaats die bestanden dan eens... Dan kunnen we ook even meekijken..

Gangstawar · 12 Mei 2009

Hierbij mijn configs en connections

Config uit de public_html

PHP

<?php /* ------------------------- */
  include("connection.php");
  
function quote_smart($value) {
if (get_magic_quotes_gpc()) {
$value = stripslashes($value);
}
if(version_compare(phpversion(),"4.3.0") == "-1") {
return mysql_escape_string($value);
} else {
return mysql_real_escape_string($value);
}
}


  if(!(@mysql_connect("localhost","username","wachtwoord") && @mysql_select_db("databasenaam"))) {
?>
<html>




<head>
<title><?php echo $page->sitetitle; ?></title>
<link rel="stylesheet" type="text/css" href="<? echo $sitelink;?>/layout/layout<?php echo $page->layout; ?>/css/css.css">
<script language="javascript">
function showTxt(id) {
    document.getElementById(id).style.position		= "relative";
    document.getElementById(id).style.visibility	= "visible";
}
</script>
</head>




  <table width=50%>
    <tr><td class="subTitle"><b>FF OFFLINE</b></td></tr>
    <tr><td class="mainTxt">
<center>Offline wegens database fout!</center>
    </td></tr>
  </table>
</body>


</html>
<?
    exit;
  }




  error_reporting ( 0 );
  session_start();
  include("_include-funcs.php");
  if(isset($_SESSION['user'])) {
    $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup`,UNIX_TIMESTAMP(`online`) AS `online` FROM `users` WHERE `login`='{$_SESSION['user']}'");
    $data				= mysql_fetch_object($dbres);
    if($data->ip  == '')
    {
$IP = $_SERVER['REMOTE_ADDR'];    
mysql_query("UPDATE `users` SET `IP`='$IP' WHERE `login`='$data->login'");


}
  }


  
  
  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 `login`='{$data->login}'");


    mysql_query("UPDATE `users` SET `online2`='ja' WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
    mysql_query("UPDATE `users` SET `online2`='nee' WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) >= 300");


    $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup`,UNIX_TIMESTAMP(`online`) AS `online` FROM `users` WHERE `login`='{$_SESSION['user']}'");
    $data				= mysql_fetch_object($dbres);


if($data->rankvord >= 100 && $data->rank <10) {
$rank	                  	= array("","Groentje","Loopjongen","Zakkenroller","Winkeldief","Dief","Mobster","Moordenaar","Lokale leider","Leider","Godfather");
$rank = $rank[$data->rank];


mysql_query("UPDATE `users` SET `rank`=`rank`+'1',`rankvord`=`rankvord`-'100' WHERE `login`='".$data->login."'");
}
$gelderaf = $data->werknemers*50+$data->bewakers*50;
$rank	                  	= array("","Groentje","Loopjongen","Zakkenroller","Winkeldief","Dief","Mobster","Moordenaar","Lokale leider","Leider","Godfather");
$rank = $rank[$data->rank];
$city	                  	= array("","Turijn","Palermo","Milaan","Rome","Catania","Corleone");
$city = $city[$data->city];
if($data->familie == "")
{
$familie = ("Geen familie");
}
else{
$familie = ("$data->familie");
}


mysql_query("UPDATE `[users]` SET `cash`='0' WHERE `cash`<'0'"); 
mysql_query("UPDATE `[users]` SET `bank`='0' WHERE `bank`<'0'");  










#
$select = mysql_query("SELECT * FROM `instellingen`");
#
$page = mysql_fetch_object($select);










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

Toon Meer

Hier het script connection.php uit de public_html

PHP

<?php
$host		=	"localhost";							//de host meestal gewoon localhost
$user		=	"username";							//je database username
$pass		=	"wachtwoord";								//Je database wachtwoord
$tablename	=	"database tabel";								//Je database naam
$sitelink  	= 	"http://gangstawar.nl/";   				//Je website link. GEEN v3 erachter!
?>

Hier uit script config uit de v3 map

PHP

<?php /* ------------------------- */
  include("connection.php");
function quote_smart($value) {
if (get_magic_quotes_gpc()) {
$value = stripslashes($value);
}
if(version_compare(phpversion(),"4.3.0") == "-1") {
return mysql_escape_string($value);
} else {
return mysql_real_escape_string($value);
}
}


  if(!(@mysql_connect("localhost","usernaam","wachtwoord") && @mysql_select_db("databasenaam"))) {
?>
<html>




<head>
<title><?php echo $page->sitetitle; ?></title>
<link rel="stylesheet" type="text/css" href="<? echo $sitelink;?>/layout/layout<?php echo $page->layout; ?>/css/css.css">
<script language="javascript">
function showTxt(id) {
    document.getElementById(id).style.position		= "relative";
    document.getElementById(id).style.visibility	= "visible";
}
</script>
</head>




  <table width=50%>
    <tr><td class="subTitle"><b>FF OFFLINE</b></td></tr>
    <tr><td class="mainTxt">
<center>Offline wegens database fout!</center>
    </td></tr>
  </table>
</body>


</html>
<?
    exit;
  }
function vloeren($getal, $afronding)
   {
   // controleer of getallen een getal zijn
   if(!is_double($getal) AND !is_int($getal) AND (!is_double($afronding) AND !is_int($afronding)))
      {
      return $getal;
      }


   // controleer of de getallen geen 0 zijn
   if ($getal == 0 OR $afronding == 0)
      {
      return $getal;
      }


   // bereken getallen
   $deel_voor_komma = intval($getal / $afronding);
   $deel_na_komma = ($getal / $afronding) - intval($deel_voor_komma);
   $rest = $deel_na_komma * $afronding;


   // als $verschil groter is dan de helft van $afronding...
   if ($rest >= ($afronding / 2 ))
      {
      $afgerond = $getal + ($rest - $rest*2);
      }
   // als $verschil dus kleiner is dan de helft van $afronding...
   else
      {
      $afgerond = $deel_voor_komma * $afronding;
      }


   // geef resultaat terug
   return $afgerond;
   }


  error_reporting ( 0 );
  session_start();
  include("_include-funcs.php");
  if(isset($_SESSION['user']) || isset($_SESSION['login']) || isset($_SESSION['account']) || isset($_SESSION['thisuser'])) {
$hasdbres = 0;
  if(isset($_SESSION['user'])){
    $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup`,UNIX_TIMESTAMP(`online`) AS `online` FROM `users` WHERE `login`='{$_SESSION['user']}'");
$hasdbres = 1;
}
if($hasdbres == 0){
  if(!isset($_SESSION['user']) && isset($_SESSION['login'])){
    $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup`,UNIX_TIMESTAMP(`online`) AS `online` FROM `users` WHERE `login`='{$_SESSION['login']}'");
}
}
if($hasdbres == 0){
  if(!isset($_SESSION['login']) && isset($_SESSION['account'])){
    $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup`,UNIX_TIMESTAMP(`online`) AS `online` FROM `users` WHERE `login`='{$_SESSION['account']}'");
}
}
if($hasdbres == 0){
  if(!isset($_SESSION['account']) && isset($_SESSION['thisuser'])){
    $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup`,UNIX_TIMESTAMP(`online`) AS `online` FROM `users` WHERE `login`='{$_SESSION['thisuser']}'");
}
}
    $data				= mysql_fetch_object($dbres);
      $_SESSION['user']		= $data->login;
      $_SESSION['login']		= $data->login;
      $_SESSION['account']		= $data->login;
      $_SESSION['thisuser']		= $data->login;
      $_SESSION['user']		= $data->login;
      $_SESSION['login']		= $data->login;
      $_SESSION['account']		= $data->login;
      $_SESSION['thisuser']		= $data->login;
      $_SESSION['user']		= $data->login;
      $_SESSION['login']		= $data->login;
      $_SESSION['account']		= $data->login;
      $_SESSION['thisuser']		= $data->login;
      $_SESSION['user']		= $data->login;
      $_SESSION['login']		= $data->login;
      $_SESSION['account']		= $data->login;
      $_SESSION['thisuser']		= $data->login;
    if($data->ip  == '')
    {
$IP = $_SERVER['REMOTE_ADDR'];    
mysql_query("UPDATE `users` SET `IP`='$IP' WHERE `login`='$data->login'");


}
  }
$fakedatum = (date("YmdHis"));


  
  
  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 `login`='{$data->login}'");


    mysql_query("UPDATE `users` SET `online2`='ja' WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
    mysql_query("UPDATE `users` SET `online2`='nee' WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) >= 300");
include("cron_hour.php");
include("cron_day.php");
include("cron_week.php");
if($data->rankvord >= 100 && $data->rank <10) {
$rank	                  	= array("","Groentje","Loopjongen","Zakkenroller","Winkeldief","Dief","Mobster","Moordenaar","Lokale leider","Leider","Godfather");
$data->rank = $data->rank+1;
$rank = $rank[$data->rank];
mysql_query("INSERT INTO `messages`(`date`,`to`,`from`,`ip`,`title`,`content`,`date2`,`read`,`inbox`,`reply`) values(NOW(),'$data->login','Anoniem','$data->IP','Promotie','Proficiat. Je bent gepromoveerd naar $rank!','$date2','0','1','0')");
mysql_query("UPDATE `users` SET `rank`=`rank`+'1',`rankvord`=`rankvord`-'100' WHERE `login`='".$data->login."'");
}
$gelderaf = $data->werknemers*50+$data->bewakers*50;
$rank	                  	= array("","Groentje","Loopjongen","Zakkenroller","Winkeldief","Dief","Mobster","Moordenaar","Lokale leider","Leider","Godfather");
$rank = $rank[$data->rank];
$city	                  	= array("","Turijn","Palermo","Milaan","Rome","Catania","Corleone");
$city = $city[$data->city];
$fam3 = mysql_query("SELECT * FROM `families` WHERE `naam`='$data->familie'");
$fam2 = mysql_fetch_object($fam3);
if($data->familie == "")
{
$familie = ("Geen familie");
}
if($data->famlevel == -1){
$familie = ("<a href=$sitelink/v3/index.php?a=famprofile&x=$fam2->id>Wachtlijst</a> - <a href=$sitelink/v3/leaveclan.php?x=$fam2->id>Uit wachtlijst?</a>");
}
if($data->familie != "" && $data->famlevel != -1){
$familie = ("<a href=$sitelink/v3/index.php?a=famprofile&x=$fam2->id>$data->familie</a>");
}
mysql_query("UPDATE `users` SET `draaien`='10800' WHERE `vipdays`<'1'");
mysql_query("UPDATE `users` SET `draaien`='7200' WHERE `vipdays`>'0'");
if($data->rankvord > 99){$data->rankvord = 100;}
$doden1 = mysql_query("SELECT * FROM `users` WHERE `vermoord`>'0'");
$numdood = mysql_num_rows($doden1);
$y = (date("Y"));
$m = (date("m"));
$d = (date("d"));
$nextd = $d+1;
if($nextd < 10){$nextd = "0$nextd";}
$changeveilingshow = "$nextd-$m-$y / 00:00";
$changeveiling = "$y-$m-$nextd 00:00:00";
if($numdood > 0){
while($doden = mysql_fetch_object($doden1)){
mysql_query("UPDATE `vliegveld` SET `showtot`='$changeveilingshow', `tot`='$changeveiling', `eigenaar`='', `laatstebod`='0', `laatstebieder`='' WHERE `eigenaar`='$doden->login'");
mysql_query("UPDATE `station` SET `showtot`='$changeveilingshow', `tot`='$changeveiling', `eigenaar`='', `laatstebod`='0', `laatstebieder`='' WHERE `eigenaar`='$doden->login'");
}
}
$vliegveld1 = mysql_query("SELECT * FROM `vliegveld` WHERE `eigenaar`=''");
while($vliegveld = mysql_fetch_object($vliegveld1)){
$fakedatum = (date("YmdHis"));
$overheen = $vliegveld->tot;
$overheen = str_replace(":", "",$overheen);
$overheen = str_replace("-", "",$overheen);
$overheen = str_replace(" ", "",$overheen);


if($fakedatum > $overheen){
if($vliegveld->laatstebieder != ""){
mysql_query("UPDATE `vliegveld` SET `showtot`='00-00-0000 / 00:00', `tot`='0000-00-00 00:00:00', `eigenaar`='$vliegveld->laatstebieder' WHERE `stad`='$vliegveld->stad'");
}else{mysql_query("UPDATE `vliegveld` SET `showtot`='$changeveilingshow', `tot`='$changeveiling' WHERE `stad`='$vliegveld->stad'");}}}
$station1 = mysql_query("SELECT * FROM `station` WHERE `eigenaar`=''");
while($station = mysql_fetch_object($station1)){
$fakedatum = (date("YmdHis"));
$overheen = $station->tot;
$overheen = str_replace(":", "",$overheen);
$overheen = str_replace("-", "",$overheen);
$overheen = str_replace(" ", "",$overheen);
if($fakedatum > $overheen){
if($station->laatstebieder != ""){
mysql_query("UPDATE `station` SET `showtot`='00-00-0000 / 00:00', `tot`='0000-00-00 00:00:00', `eigenaar`='$station->laatstebieder' WHERE `stad`='$station->stad'");
}else{mysql_query("UPDATE `station` SET `showtot`='$changeveilingshow', `tot`='$changeveiling' WHERE `stad`='$station->stad'");}}}


##############################
###   HIER IS GENOEG PLEK  ###
##############################


$online1 = mysql_query("SELECT * FROM `chat_online`");
while($online = mysql_fetch_object($online1)){
$dbres = mysql_query("SELECT * FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND `login`='$online->person'");
$user = mysql_fetch_object($dbres);
if($user->login != $online->person){
mysql_query("DELETE FROM `chat_online` WHERE `person`='$online->person'");
}}


$select = mysql_query("SELECT * FROM `instellingen`");
#
$page = mysql_fetch_object($select);
$dituur = date(H);
$verschil = $dituur-$data->aankomst;
if($data->aankomst != 25 && $data->aankomst != "" && $data->aankomst < $dituur){
mysql_query("UPDATE `users` SET `aankomst`='25',`city`='$data->aankomststad' WHERE `login`='$data->login'");
}
if($data->aankomst != 25 && $data->aankomst != "" && $dituur >= $data->aankomst){
mysql_query("UPDATE `users` SET `aankomst`='25',`city`='$data->aankomststad' WHERE `login`='$data->login'");
}


if($data->vakantie > 0){
    unset($_SESSION['login']);
    unset($_SESSION['thisuser']);
    unset($_SESSION['account']);
    unset($_SESSION['user']);
    unset($_SESSION['IP']);
    unset($_SESSION['data']);
   header("Location: $sitelink/index.php?vakantie");
exit;
}
$bank = $data->bank;
$contant = $data->contant;
$gebruikers = mysql_query("SELECT * FROM `users`");
$page->registered = mysql_num_rows($gebruikers);
$overheen = $data->vliegen;
$overheen = str_replace(":", "",$overheen);
$overheen = str_replace("-", "",$overheen);
$overheen = str_replace(" ", "",$overheen);
if($data->vliegen != "0000-00-00 00:00:00" && $fakedatum > $overheen){
mysql_query("UPDATE `users` SET `vliegen`='0000-00-00 00:00:00',`city`='$data->aankomststad' WHERE `login`='$data->login'");

Toon Meer

PHP

[b] hier het connection script uti de v3 map[/b]


<?php
$host		=	"localhost";							//de host meestal gewoon localhost
$user		=	"usernaam";							//je database username
$pass		=	"wachtwoord";								//Je database wachtwoord
$tablename	=	"databasenaam";								//Je database naam
$sitelink  	= 	"http://gangstawar.nl/";   				//Je website link. GEEN v3 erachter!
?>

dit waren ze zou u willen kijken wat er fout kan zijn

Stefan.J · 12 Mei 2009

PHP

<?php


include("cron_hour.php");
include("cron_day.php");
include("cron_week.php");


?>

Die maken waarschijnlijk ook allemaal een connectie... 4 connecties per gebruiker, tikt aardig aan aan je limiet...

Gangstawar · 12 Mei 2009

okee het is gelukt ik moest de connections ok in de crons gooien allemaal bedankt topic mag gesloten worden

adidasstyle · 12 Mei 2009

oke.

Kunnen jullie mij helpen met deze enquete

PHP Point of Sale

een eigen cloud sever

Probleem C++ en CL

Unraid

Smarty Update

DNS update Directadmin

Graag advies voor mijn website

252 Nieuwe domeinnamen November 2024

Evesi Marktplaats Script

265 Nieuwe domeinnamen Oktober 2024

Nieuwe Bug

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2

Delen