cron1.php
PHP
<?php
mysql_query("UPDATE users SET stad = bestemming, aankomst = '0000-00-00 00:00:00' WHERE UNIX_TIMESTAMP(aankomst) < '" . tijd() . "' AND aankomst != '0000-00-00 00:00:00'");
//CRON
$update = mysql_fetch_query("SELECT time FROM cron WHERE name = 'hour' LIMIT 1");
$lol = $update['time'];
if(tijd() - strtotime($lol) >= 3600) {
$update = floor((tijd() - strtotime($lol)) / 3600);
mysql_query("UPDATE users SET cash = cash + '" . (250 * $update) . "' WHERE '" . tijd() . "' - UNIX_TIMESTAMP(online) < '180'");
mysql_query("UPDATE users SET maffia = maffia - '" . (1 * $update) . "' WHERE maffia > '0'");
mysql_query("UPDATE users SET maffia = '0' WHERE maffia < '0'");
mysql_query("UPDATE users SET bank = bank + bitcheswerken * '" . ($update * 15) . "'");
mysql_query("UPDATE users SET safe = safe - '" . (1 * $update) . "' WHERE safe > '0'");
mysql_query("UPDATE users SET safe = '0' WHERE safe < '0'");
$selection = "";
foreach($steden as $i => $stad) {
$selection .= ", koersen_" . $i;
}
$drinks = mysql_query("SELECT naam" . $selection . " FROM drank");
while($krat = mysql_fetch_array($drinks, MYSQL_ASSOC)) {
foreach($steden as $i => $stad) {
$krat['koersen_' . $i] = rand(500, 6000);
mysql_query("UPDATE drank SET koersen_" . $i . " = '" . $krat['koersen_' . $i] . "' WHERE naam = '" . $krat['naam'] . "'");
}
}
mysql_query("UPDATE cron SET time = '" . get_global_date("Y-m-d H") . ":00:00' WHERE name = 'hour'");
}
Toon Meer
cron_hour.php
PHP
<?php
// DIT BESTAND ROEPT DE SERVER ELKE UUR AAN!
$host = "localhost";
$user = "database_username";
$passwd = "database_password";
$database = "database_naam";
mysql_connect($host, $user, $passwd) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
// HomeMissie
$Homesql = mysql_query("SELECT `staat`, `aantal`, `fam` FROM `plattegrond_fam`") or die(mysql_error());
while($Homeres = mysql_fetch_assoc($Homesql))
{
$famm = mysql_query("SELECT `dag` FROM `familie` WHERE `id`=".$Homeres['fam']) or die(mysql_error());
$fam = mysql_fetch_assoc($famm);
if($fam['dag'] >= 7){
$staat = $Homeres['staat'];
$aantal = $Homeres['aantal'];
if($staat == 1 && $aantal == 57){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
}
if($staat == 2 && $aantal == 86){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
}
if($staat == 3 && $aantal == 60){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
}
if($staat == 4 && $aantal == 113){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
}
if($staat == 5 && $aantal == 69){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
}
if($staat == 6 && $aantal == 49){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
}
if($staat == 7 && $aantal == 68){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$Homeres['fam']) or die(mysql_error());
}
if($staat == 8 && $aantal == 154){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$famID) or die(mysql_error());
}
if($staat == 9 && $aantal == 79){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$famID) or die(mysql_error());
}
if($staat == 10 && $aantal == 84){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$famID) or die(mysql_error());
}
if($staat == 11 && $aantal == 119){
mysql_query("UPDATE familie SET missie_home = '1' WHERE id =".$famID) or die(mysql_error());
}
}
}
Toon Meer
cron1.php is working great withot setup cpanel.
But cron_hour.php doest work .. without setup cpanel cronjob..
Can sb setup me.. that way..it woluld work without cpanel setup cronjob?