$hhtimestamp = time();

$hhuhrzeit = date("H:i",$hhtimestamp);

$hhwochentag = date("w", $hhtimestamp);



if ('6' == $hhwochentag || '0' == $hhwochentag) {

if ($hhuhrzeit >= "00:00" && $hhuhrzeit < "01:00"){

opentable("PREMIUM Happy Hour");



$premiumsettings = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."mfp_scores WHERE user_id=".$userdata['user_id'].""));

$mfpssettings = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."mfp_scores_conf"));

$hhend = mktime(01,00,00);



if (($premiumsettings['status'] =='inaktiv') || ($premiumsettings['status'] =='')) {

$result = dbquery("INSERT INTO ".DB_PREFIX."mfp_scores SET

      user_id='".$userdata['user_id']."',

      status='aktiv',

      seit='".time()."',

      bis='".$hhend."'

      ON DUPLICATE KEY UPDATE

      user_id='".$userdata['user_id']."',

      status='aktiv',

      seit='".time()."',

      bis='".$hhend."'");



$user_id = $userdata['user_id'];

mysql_query("UPDATE ".DB_USERS." SET  `user_groups` =  '".str_replace(".".$mfpssettings['prem_gruppe']."", "", $userdata['user_groups']).".".$mfpssettings['prem_gruppe']."' WHERE  `user_id` = ".mysql_real_escape_string($user_id).";");

}

echo '<center>Happy Hour: <span style="color: #00ff00;"><strong>AKTIV</strong></span><img style="display: block; margin-left: auto; margin-right: auto;" src="'.BASEDIR.'images/HHpremium.png" alt="" width="468" height="60" />Immer Samstags & Sonntags von 00:00 bis 01:00 Premium für alle!</center>';



closetable();

}

}