Drugs cron update

YVMdesign · 30 November 2009

Hallo cpers.

Ik heb een cron hour gemaakt.

Is het makelijker te maken?
Mischien wat voorbeelden hoe ik het anders zou kunnen doen.

PHP

if (floor($update['hour']/ 3600) != floor(time()/ 3600)) {
$dbres				= mysql_query("SELECT GET_LOCK('hour_update',0)");
	if (mysql_result($dbres,0) == 1) {
		mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='hour'");
		$morphine 		= array('palermo' => rand(10000, 15000), 'corleone' => rand(10000, 15000), 'baltimore' => rand(10000, 15000), 'philadelphia' => rand(10000, 15000), 'chicago' => rand(10000, 15000), 'detroit' => rand(10000, 15000), 'lasvegas' => rand(10000, 15000), 'newyork' => rand(10000, 15000));
		$heroin 		= array('palermo' => rand(11000, 18000), 'corleone' => rand(11000, 18000), 'baltimore' => rand(11000, 18000), 'philadelphia' => rand(11000, 18000), 'chicago' => rand(11000, 18000), 'detroit' => rand(11000, 18000), 'lasvegas' => rand(11000, 18000), 'newyork' => rand(11000, 18000));
		$opium 			= array('palermo' => rand(6000, 10000), 'corleone' => rand(6000, 10000), 'baltimore' => rand(6000, 10000), 'philadelphia' => rand(6000, 10000), 'chicago' => rand(6000, 10000), 'detroit' => rand(6000, 10000), 'lasvegas' => rand(6000, 10000), 'newyork' => rand(6000, 10000));
		$cocaine 		= array('palermo' => rand(16000, 21000), 'corleone' => rand(16000, 21000), 'baltimore' => rand(16000, 21000), 'philadelphia' => rand(16000, 21000), 'chicago' => rand(16000, 21000), 'detroit' => rand(16000, 21000), 'lasvegas' => rand(16000, 21000), 'newyork' => rand(16000, 21000));
		$marijuana 		= array('palermo' => rand(2000, 4500), 'corleone' => rand(2000, 4500), 'baltimore' => rand(2000, 4500), 'philadelphia' => rand(2000, 4500), 'chicago' => rand(2000, 4500), 'detroit' => rand(2000, 4500), 'lasvegas' => rand(2000, 4500), 'newyork' => rand(2000, 4500));
		$tobacco 		= array('palermo' => rand(400, 1300), 'corleone' => rand(400, 1300), 'baltimore' => rand(400, 1300), 'philadelphia' => rand(400, 1300), 'chicago' => rand(400, 1300), 'detroit' => rand(400, 1300), 'lasvegas' => rand(400, 1300), 'newyork' => rand(400, 1300));
		$glue 			= array('palermo' => rand(100, 1100), 'corleone' => rand(100, 1100), 'baltimore' => rand(100, 1100), 'philadelphia' => rand(100, 1100), 'chicago' => rand(100, 1100), 'detroit' => rand(100, 1100), 'lasvegas' => rand(100, 1100), 'newyork' => rand(100, 1100));
		$wine			= array('palermo' => rand(100, 800), 'corleone' => rand(100, 800), 'baltimore' => rand(100, 800), 'philadelphia' => rand(100, 800), 'chicago' => rand(100, 800), 'detroit' => rand(100, 800), 'lasvegas' => rand(100, 800), 'newyork' => rand(100, 800));
		$cognac			= array('palermo' => rand(2100, 3800), 'corleone' => rand(2100, 3800), 'baltimore' => rand(2100, 3800), 'philadelphia' => rand(2100, 3800), 'chicago' => rand(2100, 3800), 'detroit' => rand(2100, 3800), 'lasvegas' => rand(2100, 3800), 'newyork' => rand(2100, 3800));
		$whiskey		= array('palermo' => rand(2050, 3150), 'corleone' => rand(2050, 3150), 'baltimore' => rand(2050, 3150), 'philadelphia' => rand(2050, 3150), 'chicago' => rand(2050, 3150), 'detroit' => rand(2050, 3150), 'lasvegas' => rand(2050, 3150), 'newyork' => rand(2050, 3150));
		$amaretto		= array('palermo' => rand(1100, 1700), 'corleone' => rand(1100, 1700), 'baltimore' => rand(1100, 1700), 'philadelphia' => rand(1100, 1700), 'chicago' => rand(1100, 1700), 'detroit' => rand(1100, 1700), 'lasvegas' => rand(1100, 1700), 'newyork' => rand(1100, 1700));		
		$beer			= array('palermo' => rand(110, 800), 'corleone' => rand(110, 800), 'baltimore' => rand(110, 800), 'philadelphia' => rand(110, 800), 'chicago' => rand(110, 800), 'detroit' => rand(110, 800), 'lasvegas' => rand(110, 800), 'newyork' => rand(110, 800));
		$port			= array('palermo' => rand(250, 800), 'corleone' => rand(250, 800), 'baltimore' => rand(250, 800), 'philadelphia' => rand(250, 800), 'chicago' => rand(250, 800), 'detroit' => rand(250, 800), 'lasvegas' => rand(250, 800), 'newyork' => rand(250, 800));
		$rum			= array('palermo' => rand(2100, 3700), 'corleone' => rand(2100, 3700), 'baltimore' => rand(2100, 3700), 'philadelphia' => rand(2100, 3700), 'chicago' => rand(2100, 3700), 'detroit' => rand(2100, 3700), 'lasvegas' => rand(2100, 3700), 'newyork' => rand(2100, 3700));
		mysql_query("UPDATE `Smuggling` SET `morphine`=`{$morphine['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `morphine`=`{$morphine['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `morphine`=`{$morphine['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `morphine`=`{$morphine['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `morphine`=`{$morphine['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `morphine`=`{$morphine['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `morphine`=`{$morphine['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `morphine`=`{$morphine['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `heroin`=`{$heroin['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `heroin`=`{$heroin['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `heroin`=`{$heroin['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `heroin`=`{$heroin['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `heroin`=`{$heroin['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `heroin`=`{$heroin['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `heroin`=`{$heroin['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `heroin`=`{$heroin['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `opium`=`{$opium['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `opium`=`{$opium['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `opium`=`{$opium['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `opium`=`{$opium['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `opium`=`{$opium['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `opium`=`{$opium['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `opium`=`{$opium['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `opium`=`{$opium['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `cocaine`=`{$cocaine['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `cocaine`=`{$cocaine['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `cocaine`=`{$cocaine['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `cocaine`=`{$cocaine['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `cocaine`=`{$cocaine['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `cocaine`=`{$cocaine['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `cocaine`=`{$cocaine['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `cocaine`=`{$cocaine['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `marijuana`=`{$marijuana['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `marijuana`=`{$marijuana['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `marijuana`=`{$marijuana['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `marijuana`=`{$marijuana['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `marijuana`=`{$marijuana['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `marijuana`=`{$marijuana['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `marijuana`=`{$marijuana['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `marijuana`=`{$marijuana['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `tobacco`=`{$tobacco['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `tobacco`=`{$tobacco['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `tobacco`=`{$tobacco['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `tobacco`=`{$tobacco['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `tobacco`=`{$tobacco['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `tobacco`=`{$tobacco['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `tobacco`=`{$tobacco['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `tobacco`=`{$tobacco['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `glue`=`{$glue['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `glue`=`{$glue['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `glue`=`{$glue['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `glue`=`{$glue['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `glue`=`{$glue['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `glue`=`{$glue['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `glue`=`{$glue['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `glue`=`{$glue['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `wine`=`{$wine['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `wine`=`{$wine['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `wine`=`{$wine['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `wine`=`{$wine['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `wine`=`{$wine['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `wine`=`{$wine['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `wine`=`{$wine['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `wine`=`{$wine['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `cognac`=`{$cognac['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `cognac`=`{$cognac['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `cognac`=`{$cognac['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `cognac`=`{$cognac['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `cognac`=`{$cognac['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `cognac`=`{$cognac['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `cognac`=`{$cognac['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `cognac`=`{$cognac['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `whiskey`=`{$whiskey['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `whiskey`=`{$whiskey['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `whiskey`=`{$whiskey['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `whiskey`=`{$whiskey['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `whiskey`=`{$whiskey['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `whiskey`=`{$whiskey['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `whiskey`=`{$whiskey['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `whiskey`=`{$whiskey['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `amaretto`=`{$amaretto['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `amaretto`=`{$amaretto['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `amaretto`=`{$amaretto['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `amaretto`=`{$amaretto['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `amaretto`=`{$amaretto['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `amaretto`=`{$amaretto['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `amaretto`=`{$amaretto['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `amaretto`=`{$amaretto['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `beer`=`{$beer['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `beer`=`{$beer['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `beer`=`{$beer['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `beer`=`{$beer['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `beer`=`{$beer['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `beer`=`{$beer['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `beer`=`{$beer['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `beer`=`{$beer['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `port`=`{$port['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `port`=`{$port['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `port`=`{$port['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `port`=`{$port['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `port`=`{$port['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `port`=`{$port['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `port`=`{$port['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `port`=`{$port['newyork']}` WHERE `city`='New York'");
		mysql_query("UPDATE `Smuggling` SET `rum`=`{$rum['palermo']}` WHERE `city`='Palermo'");
		mysql_query("UPDATE `Smuggling` SET `rum`=`{$rum['corleone']}` WHERE `city`='Corleone'");
		mysql_query("UPDATE `Smuggling` SET `rum`=`{$rum['baltimore']}` WHERE `city`='Baltimore'");
		mysql_query("UPDATE `Smuggling` SET `rum`=`{$rum['philadelphia']}` WHERE `city`='Philadelphia'");
		mysql_query("UPDATE `Smuggling` SET `rum`=`{$rum['chicago']}` WHERE `city`='Chicago'");
		mysql_query("UPDATE `Smuggling` SET `rum`=`{$rum['detroit']}` WHERE `city`='Detroit'");
		mysql_query("UPDATE `Smuggling` SET `rum`=`{$rum['lasvegas']}` WHERE `city`='Las Vegas'");
		mysql_query("UPDATE `Smuggling` SET `rum`=`{$rum['newyork']}` WHERE `city`='New York'");
		mysql_query("SELECT RELEASE_LOCK('hour_update')");
	}
}

Toon Meer

Darsstar · 30 November 2009

PHP

<?php


// hier is je nieuwe array structuur...
$cities = array(
    'palermo' => array(
        'morphine' => rand(10000, 15000),
    ),
);


$func = create_func('&$value,$key', '$value = "`$key` = $value";')


foreach($cities AS $city => $fields)
{
    $fields = array_walk($fields, $func);
    mysql_query("UPDATE `Smuggling` SET ".implode(', ', $fields)." WHERE `city` = '".mysql_real_escape_string($city)."'");
}

Toon Meer

Zoiets zou ik gebruiken...
Dat wilt niet zeggen dat er geen fouten in de bovenstaande code kunnen zitten, ik heb deze namelijk niet gestest.
Het gaat om het idee...

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Plesk installer

cpanel / whm themes

PHP Point of Sale

Probleem omtrent Tinymce

Kunnen jullie mij helpen met deze enquete

een eigen cloud sever

Probleem C++ en CL

193 Nieuwe domeinnamen April 2025

228 Nieuwe domeinnamen Maart 2025

285 Nieuwe domeinnamen Februari 2025

Drugs cron update

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

Gebruikers die dit topic bekijken