query(" SELECT * FROM `ads_sys_b` WHERE `UserIP` ='$UserIP' LIMIT 0 , 1 "); $row = $db_adv->fetch($result); //kijken of advertentie moet worden weergegeven //******************************************************** if($row['UserIP'] == ""){ $GameViews = 1; }else{ $GameViews = $row['UserViews'] + 1; //direct kijken of record gewist moet worden omdat de timestamp te oud is $StampLeeftijd = $TimeStampNow - $row['UserTimeStamp']; if($StampLeeftijd > $LoopTijdStamp){ //record wissen (einde record wissen) $db_adv->query(" UPDATE `ads_sys_b` SET `UserTimeStamp` = '$TimeStampNow', `UserViews` = '0' WHERE UserIP = '".$row['UserIP']."' LIMIT 1 ; "); $GameViews = 1; $row['UserViews'] = 0; //einde record wissen (updaten) }; //eide direct kijken of record gewist moet worden omdat de timestamp te oud is }; //******************************************************** //einde kijken of advertentie moet worden weergegeven if($row['UserIP'] == ""){ //inserten $db_adv->query(" INSERT INTO `ads_sys_b` ( `UserIP` , `UserViews` , `UserTimeStamp` ) VALUES ( '$UserIP', '1', '$TimeStampNow' ); "); //einde inserten }else{ //updaten $db_adv->query(" UPDATE `ads_sys_b` SET UserViews=UserViews+1 WHERE UserIP = '".$row['UserIP']."' LIMIT 1 ; "); //einde updaten }; //uitpakken ShowAdTime if(in_array($GameViews,$ShowAdTime)){ if($GameViews != ""){ $ShowAdTime = $GameViews; }; }; if($GameViews == $ShowAdTime){ //******************************************************** //**************advertentie weergeven********************* //******************************************************** echo"$Adv_Code"; //******************************************************** //*******einde *advertentie weergeven********************* //******************************************************** }else{ ?>