dan werkt het ook niet
Posts by soqotra
-
-
-
-
-
Ik vraag mij wel af waarom ik dan al deze codes in me config heb staan? Hij geeft hier toch aan wanneer de crons uitgevoerd moeten worden? Als ik dit via een ander programma doen kan ik dit net zo goed weghalen, op de passworden na? :((
-
Oh dat is dus wel echt nodig.
Ik kan mij namelijk niet herinneren dat ik dit ooit gedaan heb maar voorheen werkte dit wel bij mijn wete.Maar bedankt iig, ik zal even een kijkje nemen.
Ik zit op localhost via XAMPP.
-
Goedemiddag,
Het lijkt erop dat ik geen 1 van mijn crons werkend kan krijgen. Ik zit er nu al 2 dagen naar te kijken maar het wilt niet echt lukken.
Cron hour:
PHP
Toon Meer<? if($cron_pass != "stefancron") exit; mysql_query("UPDATE `[users]` SET `cash`=`cash`+100 WHERE `activated`=1"); mysql_query("UPDATE `[users]` SET `bank`=`bank`+100 WHERE `type`=3 AND `activated`=1"); mysql_query("UPDATE `[clans]` SET `cash`=`cash`+200,`bank`=`bank`+200"); $dbres = mysql_query("SELECT * FROM `[clans]` WHERE `money_lvl1` > 0"); while($clan = mysql_fetch_object($dbres)) { if($clan->type == 1) mysql_query("UPDATE `[users]` SET `cash`=`cash`+". (50*$clan->money_lvl1) .",`bank`=`bank`+". (150*$clan->money_lvl1) ." WHERE `clan`='{$clan->name}'"); else if($clan->type == 2) mysql_query("UPDATE `[users]` SET `cash`=`cash`+". (100*$clan->money_lvl1) .",`bank`=`bank`+". (100*$clan->money_lvl1) ." WHERE `clan`='{$clan->name}'"); else if($clan->type == 3) mysql_query("UPDATE `[users]` SET `bank`=`bank`+". (rand(150,300)*$clan->money_lvl1) ." WHERE `clan`='{$clan->name}'"); } ?>
config:
PHP
Toon Meer<? if(!(@mysql_connect("localhost","xxxxx","xxxx") && @mysql_select_db("xxxx"))) { print <<<ENDHTML <html> include("layout.php"); <head> <title>Database Error</title> </head> <table width=100%> <tr><td class="subTitle"><b>Database Error</b></td></tr> <tr><td class="mainTxt"> We zijn zo spoedig mogelijk terug. </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 = "stefancron"; $times = (floor(time()/3600))-(floor($update['hour']/3600)); $date = $update['hour']+3600*$times; $date = date("Y-m-d H:i:s", $date); for($nr = 1; $nr <= $times; $nr++) { include("_cron_hour.php"); } mysql_query("UPDATE `[cron]` SET `time`='" . $date . "' WHERE `name`='hour'"); 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 = "stefancron"; $times = (floor(time()/86400))-(floor($update['hour']/86400)); $date = $update['day']+86400*$times; $date = date("Y-m-d H:i:s", $date); for($nr = 1; $nr <= $times; $nr++) { include("_cron_day.php"); } mysql_query("UPDATE `[cron]` SET `time`='" . $date . "' WHERE `name`='day'"); 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 = "stefancron"; $times = (floor(time()/604800))-(floor($update['hour']/60480)); $date = $update['week']+604800*$times; $date = date("Y-m-d H:i:s", $date); for($nr = 1; $nr <= $times; $nr++) { include("_cron_week.php"); } mysql_query("UPDATE `[cron]` SET `time`='" . $date . "' WHERE `name`='week'"); 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 = "stefancron"; include("_cron_month.php"); mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='month'"); 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 = "stefancron"; include("_cron_horserace.php"); mysql_query("UPDATE `[cron]` SET `time`=NOW() WHERE `name`='horserace'"); mysql_query("SELECT RELEASE_LOCK('horserace_update')"); } } } session_start(); include("_include-funcs.php"); if(check_login() === true) { $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>Banned</title> </head> <table width=100% height=100%> <tr><td class="subTitle"><b>Ban</b></td></tr> <tr><td class="mainTxt"> Het IP waarmee je speelt staat op de ban-lijst. </td></tr> </table> </body> </html> ENDHTML; exit; } /* ------------------------- */ ?>
-
-
Hallo, ik probeer mijn topbalk.php op te roepen zodra deze in de database op 1 staat.
De standaard waarde is 0
zodra deze op 0 staat werkt alles prima.
zodra ik deze naar 1 verander kan hij mijn hoofdkwartier niet meer vinden(Kan de pagina niet weergeven).als ik naar mijn top.php ga werkt deze ook prima.
Enig idee iemand?
Voorbeeld:
In mijn hoofdkwartier voeg ik deze code toe:
Dit is mijn top.php
PHP
Toon Meer<? include("_include-config.php"); include("layout.php"); if(! check_login()) { header('Location: login.php'); exit; } mysql_query("UPDATE `[users]` SET `online`=NOW() WHERE `login`='{$data->login}'"); ?> <html> <head> <title>Top</title> </head> <body> <table width="100%"> <tr> <td class="subTitle" colspan=3>Ingelogd als <? echo $data->login; ?></td> </tr> <tr> <? $dbres = mysql_query("SELECT id FROM `[messages]` WHERE `read`=0 AND `inbox`=1 AND `to`='{$data->login}'"); $berichten = mysql_num_rows($dbres); $bericht2en = mysql_query('SELECT * FROM `[messages]` WHERE `inbox`=0 AND `read` = 0 AND `to` = "$data->login"'); if ($berichten == 0) { $berichten = 'Geen nieuwe berichten'; } elseif ($berichten == 1) { $berichten = '<a href="message.php?p=inbox">1 nieuw bericht</a>'; } else { $berichten = '<a href="message.php?p=inbox">'.$berichten.' nieuwe berichten</a>'; } ?> <td width="180" class="mainTxt"><b>Cash:</b> €<? echo number_format($data->cash,0,',','.'); ?></td> <td width="180" class="mainTxt"><b>Bank:</b> €<? echo number_format($data->bank,0,',','.'); ?></td> <td width="180" class="mainTxt"><? echo $berichten; ?></td> </tr> </table> <br> </html>
(L)(L)