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
<?
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
<?
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;
}
/* ------------------------- */ ?>