Opgave culturele uitspattingen

Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db"); if($_GET[id] != "" && $_GET[code2] != "") { $email = $_GET[id]; $code2 = $_GET[code2]; //registratie $rs = $conn->Execute("SELECT * FROM reservering WHERE email = '$email' AND code = $code2"); $fv = $rs->Fields("id"); if(@is_numeric($fv->value) == TRUE) { $query = "UPDATE reservering SET verify = 'geannuleerd', code = '0' WHERE email = '$email' AND code = $code2"; $rs = $conn->Execute($query); print("
Hierbij is het betreffende concert of festival geannuleerd."); } else { print("
Er is iets fout gegaan.
Stuur om uw concert of festival te annuleren een e-mail naar reserveren@occultfest.nl

Excuses voor het ongemak."); } } else { if($_GET[id] != "" && $_GET[code] != "") { $email = $_GET[id]; $code = $_GET[code]; //registratie $rs = $conn->Execute("SELECT * FROM reservering WHERE email = '$email' AND code = $code"); $fv = $rs->Fields("id"); if(@is_numeric($fv->value) == TRUE) { $rs = $conn->Execute("SELECT * FROM reservering WHERE email = '$email' AND code = $code"); $fv = $rs->Fields("id"); $dat = $rs->Fields("dat"); $locatie = $rs->Fields("locatie"); $bev = "bevestiging $locatie op $dat"; $id = $email; $id1 = "occultfest@hotmail.com"; $mailBody = "Het onderstaande concert of festival is aan onze concertagenda toegevoegd. $dat $locatie Wij verzoeken u deze via onderstaande link te controleren. http://www.occultfest.nl/content/printform14.php Indien er wijzigingen voordoen vezoeken u dit concert via onderstaande link te annuleren http://www.occultfest.nl/content/form14.php?id=$id&code2=$fv Hierna kunt u via onderstaande link opnieuw het concert of festival inclusief wijzigingen doorgeven. http://www.occultfest.nl/content/form14.php Met vriendelijke groeten namens Stichting Occultfest, Winanda Altena"; $mailHeaders = "From: \"Occultfest\" \nReply-To: \"Occultfest\" "; mail($email,"$bev", $mailBody, $mailHeaders); mail($id1, "$bev", $mailBody, $mailHeaders); $query = "UPDATE reservering SET verify = 'yes', code = '$fv' WHERE email = '$email' AND code = $code"; $rs = $conn->Execute($query); print("
uw gegevens zijn toegevoegd aan de database.

Hartelijk bedankt!
Occultfest."); } else { print("
Er is iets fout gegaan.
Stuur even de e-mail naar bestuur@occultfest.nl

Excuses voor het ongemak."); } } else { //controle op het doorvoeren van het formulier if($_SERVER['REQUEST_METHOD']=='POST') { //controle op het invullen van beide velden if($_POST[locatie] == "" ||$_POST[plaats] == "" || $_POST[email] =="") { print("
Wij vragen u in iedergeval de velden: E-Mail: Naam locatie of festival: & te: in te vullen. "); die(); } //alle 3 velden zijn ingevuld. voer gegevens else { $items = "0123456789"; $active_code = ""; srand((double)microtime() * 1000000); for ($f = 1; $f <= 6; $f++) { $code .= substr($items, (rand() % (strlen($items))), 1); } $dat2 = mktime(23,0,0,$_POST[maand]+1,$_POST[nr],date(Y)); if($dat2>time()){$dat1 = mktime(0,0,0,$_POST[maand]+1,$_POST[nr],date("Y"));} else {$dat1 = mktime(0,0,0,$_POST[maand]+1,$_POST[nr],date("Y")+1);} $_POST[datu]= $dat1; $dagen_array = array( "zondag", "maandag", "dinsdag", "woensdag", "donderdag", "vrijdag", "zaterdag"); $dag2 = $dagen_array[date("w", $dat1)]; if($dat2>time()){$jaar2 = date("Y");} else {$jaar2 = date("Y")+1;} if($_POST[site] == "http://"){$_POST[site] = ".";} if($_POST[opmerking] == "") { $_POST[opmerking] = "."; } $_POST[datum]= date("j-m-y G:i"); $maand_array = array( "januari", "februari", "maart", "april", "mei", "juni", "juli", "augustus", "september", "oktober", "november", "december"); $m= $_POST[maand]; $_POST[dat] = "$dag2 $_POST[nr] $maand_array[$m] $jaar2"; $_POST[loc] = "$_POST[locatie] te $_POST[plaats]"; $band_array = array( ".", "Accelerate", "After Forever", "Aggro", "Alien Nation", "Angor Pectoris", "Annatar", "Another Messiah", "Appendix", "Arcorais", "Arminivs", "As It Burns", "Autumn", "Black Rodeo", "BLACKLIST", "Blood Bastard", "Bornloco", "Brain Casket", "Branded Skin", "Bulldozer Breed", "Bullseye-Powerrock", "Burning Hatred", "C of E", "Callenish Circle", "Carach Angren", "Carnal Leftovers", "Cephalic", "Cerebral Tumor", "Chain", "Charlie*Adler", "Colcothar", "Collision", "Constant Paranoia", "Contradiction", "Cutting Daisy", "Cypher", "Dark Reign", "Day Six", "Dead Head", "DEATH SQUAD", "DEATHRAGE", "Deluzion", "Desaster", "Desensitised", "Devious", "Devoted to Hate", "Diggeth", "Disavowed", "Disconsolate", "Dominion", "Dragonfly", "Dying Flame", "Edge Of Anger", "Elexorien", "Eluveitie", "Endemic", "Endless Dawn", "Engine of Pain", "Enraged", "Epica", "Escadron", "Esker", "Fenris", "Flesh Made Sin", "Foretold", "Frusthatred", "Gathering", "Gilo", "God Dethroned", "Grasp of Sense", "Greyline", "Grief", "Grindminded", "Grinroth", "Hatred", "Heavy Lord", "Her Enchantment", "Holy Moses", "In Age And Sadness", "Inhume ", "Innosin", "insatiable", "INSTIL", "Izegrim", "Katafalk", "Kouwe Makkers", "Lahar", "Last Breath Denied", "Led Astray", "Locked&Loaded", "Love Bite", "Makiladoras", "Mantikhoras", "Massive Assault", "Methusalem", "Mindscan", "Monastery", "Monolith-deathcult", "Morbis Exire", "Morning", "MORTAL FORM", "My Own Mess", "Myrkvar", "Mythlorian", "Mytholic", "Necronomical Crucifixion", "New World Depression", "Next Waste Dimension", "nihilistic", "northgate", "Nuestros Derechos", "Obtuse", "One Bullet Left", "On Fire", "Ophiolatry", "Osyris.net", "Peter Pan Speedrock", "Pleurisy", "Portall", "Profane", "Provoke", "Pulverizer", "Putrefied", "sacramental blood", "Saeculum", "Salacious Gods", "Sanguinary", "Sathanas", "Scenario II", "Screamin Daemon", "Second Chance", "See my Solution", "Seizure", "Sephiroth", "Serenade of Darkness", "Serial Butcher", "Severe Torture ", "Sidius", "Silent Edge", "Sinister", "Slechtvalk", "Snakes and Sirens", "Soulreaver", "Stab Back", "Stoma", "Stormrider", "Stronghold", "Sun Caged", "Superbutt", "T.B.C.", "Textures", "Thanatos", "The 8th Sin", "The A.X.E. Project", "The Bleeding", "The Embodiment", "The Lucifer Principle", "the Soulshakers", "The Wounded", "Thronar", "Toxocara", "Trisomy", "Trudus", "Twister of Truth", "Victima", "Vortex", "Vuist", "Vulgar Faction", "Warmaster", "Winter of Sin", "Within Temptation", "Xenomorph", "X-tinxion"); $site_array = array(".","http://www.accelerateband.nl", "http://www.afterforever.com", "http://www.aggromusic.com", "http://www.aliennationcrew.com", "http://www.angorpectorisdeathmetal.be", "http://www.annatar.com", "http://www.anothermessiah.com", "http://www.appendixpunkrock.nl", "http://www.arcorais.de", "http://www.arminius.nl", "http://www.asitburns.nl", "http://www.autumn-band.com", "http://www.black-rodeo.com", "http://www.blacklistmetal.tk", "http://www.bloodbastard.com", "http://www.bornloco.nl", "http://www.braincasket.nl", "http://www.brandedskin.de", "http://www.bulldozerbreed.nl", "http://www.bullseye-powerrock.com", "http://www.burninghatred.net", "http://www.cofe.nl", "http://www.callenish-circle.com", "http://www.carach-angren.nl", "http://www.carnalleftovers.com", "http://www.cephalic.nl", "http://www.cerebraltumor.com", "http://www.run.to/chain", "http://www.charlieadler.nl", "http://www.colcothar.be", "http://www.collisiongrind.nl", "http://www.constantparanoia.com", "http://www.contradiction.de", "http://www.cuttingdaisy.nl", "http://www.cyphercore.com", "http://www.darkreign.nl", "http://www.day-six.com", "http://www.deadhead.nl", "http://www.death-squad.net", "http://deathrage.wingsofdeath.nu", "http://www.deluzion.nl", "http://www.total-desaster.de", "http://www.desensitised.nl", "http://www.devious.nl", "http://www.devotedtohate.nl", "http://www.diggeth.com", "http://www.disavowed.nl/", "http://www.disconsolate.nl", "http://www.dominion-metal.com", "http://www.dragonflyhomepage.nl", "http://www.dyingflame.tk", "http://www.edgeofanger.com", "http://www.elexorien.com", "http://www.eluveitie.ch", "http://www.endemic.nl", "http://www.endlessdawn.tk", "http://www.engineofpain.com", "http://www.enraged.nl", "http://www.epica.nl", "http://www.escadron.net", "http://www.eskermetal.nl", "http://www.fenris.nl", "http://www.fleshmadesin.nl", "http://www.foretold.nl", "http://www.frusthatred.nl", "http://www.gathering.nl", "http://www.gilo.nl", "http://www.goddethroned.com", "http://www.graspofsense.nl", "http://www.greyonline.nl", "http://www.grief.nl", "http://www.grindminded.com", "http://www.grinroth.nl", "http://www.hatred.nl", "http://www.heavylord.nl", "http://www.herenchantment.nl", "http://www.holymoses.de", "http://www.inageandsadness.com", "http://www.inhume.nl", "http://www.innosin.nl", "http://www.insatiable.nl", "http://www.instil.nl", "http://www.izegrim.nl", "http://www.katafalk.com", "http://www.kouwemakkers.nl", "http://www.circlesix.com", "http://www.lastbreathdenied.nl", "http://www.ledastray.nl", "http://www.lockednloaded.com", "http://www.lovebite.nl", "http://www.makiladoras.tk", "http://www.mantikhoras.nl", "http://www.massiveassault.net", "http://www.methusalem.nu", "http://www.scanyourmind.com", "http://www.monastery.nu", "http://www.monolith-deathcult.com", "http://www.morbisexire.nl", "http://www.morning.nl", "http://www.mortalform.nl", "http://www.myownmess.com", "http://www.myrkvar.nl", "http://www.mythlorian.nl", "http://www.mytholic.nl", "http://www.necro.nl", "http://www.newworlddepression.de", "http://www.nextwastedimension.com", "http://www.nihilistic.nl", "http://www.northgate.nl", "http://www.nuestrosderechos.nl", "http://www.obtuse.nl", "http://www.onebulletleft.nl", "http://www.setitonfire.net", "http://www.ophiolatry.org", "http://www.osyris.net", "http://www.peterpanspeedrock.com", "http://www.pleurisy.nl", "http://www.portall.net", "http://www.profanation.nl", "http://www.provoke-metal.nl", "http://myspace.com/pulverizergaylords", "http://www.putrefied.nl", "http://www.sacramentalblood.cjb.net", "http://www.saeculum.nl", "http://www.salaciousgods.com", "http://www.sanguinary.com", "http://www.sathanas.net", "http://www.myspace.com/scenario2", "http://www.screamindaemon.com", "http://www.secondchance.nl", "http://www.seemysolution.com", "http://www.seizure-music.com", "http://www.sephiroth-band.nl", "http://www.serenadeofdarkness.nl", "http://www.serialbutcher.deathmetal.be", "http://www.severetorture.com", "http://www.sidius.nl", "http://www.silentedge.com", "http;//sinister.wingsofdeath.nu/", "http://www.slechtvalk.com", "http://www.snakes-sirens.nl", "http://www.soulreaver.wingsofdeath.nu", "http://www.stabback.com", "http://home.planet.nl/~smid0017/", "http://www.stormrider.nl", "http://www.cyberstronghold.com", "http://www.suncaged.com", "http://www.superbutt.net", "http://www.t-b-c.nl", "http://www.textures.nl", "http://www.thanatos.info", "http://www.the8thsin.net", "http://axe.digispherium.com", "http://www.thebleeding.net", "http://www.embodiment.nl", "http://www.theluciferprinciple.nl", "http://www.the-soulshakers.com", "http://www.the-wounded.nl", "http://www.thronar.com", "http://www.toxocara.com", "http://www.trisomy.nl", "http://users.skynet.be/trudus", "http://www.twisteroftruth.com", "http://www.victima.de", "http://www.vortexhome.nl", "http://connect.to/vuist", "http://home.hetnet.nl/~VulgarFaction", "http://www.warmaster.tk", "http://www.winterofsin.com", "http://www.within-temptation.com", "http://www.xenomorph.nl", "http://www.x-tinxion.com"); if($_POST[keuze1] == "0") {if($_POST[band1] == "") {$_POST[band1] = ".";} if($_POST[site1] == "http://") {$_POST[site1] = "."; } } else { $k1= $_POST[keuze1]; $_POST[band1] = "$band_array[$k1]"; $_POST[site1] = "$site_array[$k1]";} if($_POST[keuze2] == "0") {if($_POST[band2] == "") {$_POST[band2] = ".";} if($_POST[site2] == "http://") {$_POST[site2] = "."; } } else { $k2= $_POST[keuze2]; $_POST[band2] = "$band_array[$k2]"; $_POST[site2] = "$site_array[$k2]";} if($_POST[keuze3] == "0") {if($_POST[band3] == "") {$_POST[band3] = ".";} if($_POST[site3] == "http://") {$_POST[site3] = "."; } } else { $k3= $_POST[keuze3]; $_POST[band3] = "$band_array[$k3]"; $_POST[site3] = "$site_array[$k3]";} if($_POST[keuze4] == "0") {if($_POST[band4] == "") {$_POST[band4] = ".";} if($_POST[site4] == "http://") {$_POST[site4] = "."; } } else { $k4= $_POST[keuze4]; $_POST[band4] = "$band_array[$k4]"; $_POST[site4] = "$site_array[$k4]";} if($_POST[keuze5] == "0") {if($_POST[band5] == "") {$_POST[band5] = ".";} if($_POST[site5] == "http://") {$_POST[site5] = "."; } } else { $k5= $_POST[keuze5]; $_POST[band5] = "$band_array[$k5]"; $_POST[site5] = "$site_array[$k5]";} if($_POST[keuze6] == "0") {if($_POST[band6] == "") {$_POST[band6] = ".";} if($_POST[site6] == "http://") {$_POST[site6] = "."; } } else { $k6= $_POST[keuze6]; $_POST[band6] = "$band_array[$k6]"; $_POST[site6] = "$site_array[$k6]";} if($_POST[keuze7] == "0") {if($_POST[band7] == "") {$_POST[band7] = ".";} if($_POST[site7] == "http://") {$_POST[site7] = "."; } } else { $k7= $_POST[keuze7]; $_POST[band7] = "$band_array[$k7]"; $_POST[site7] = "$site_array[$k7]";} if($_POST[keuze8] == "0") {if($_POST[band8] == "") {$_POST[band8] = ".";} if($_POST[site8] == "http://") {$_POST[site8] = "."; } } else { $k8= $_POST[keuze8]; $_POST[band8] = "$band_array[$k8]"; $_POST[site8] = "$site_array[$k8]";} if($_POST[keuze9] == "0") {if($_POST[band9] == "") {$_POST[band9] = ".";} if($_POST[site9] == "http://") {$_POST[site9] = "."; } } else { $k9= $_POST[keuze9]; $_POST[band9] = "$band_array[$k9]"; $_POST[site9] = "$site_array[$k9]";} if($_POST[keuze10] == "0") {if($_POST[band10] == "") {$_POST[band10] = ".";} if($_POST[site10] == "http://") {$_POST[site10] = "."; } } else { $k10= $_POST[keuze10]; $_POST[band10] = "$band_array[$k10]"; $_POST[site10] = "$site_array[$k10]";} if($_POST[keuze11] == "0") {if($_POST[band11] == "") {$_POST[band11] = ".";} if($_POST[site11] == "http://") {$_POST[site11] = "."; } } else { $k11= $_POST[keuze11]; $_POST[band11] = "$band_array[$k11]"; $_POST[site11] = "$site_array[$k11]";} if($_POST[keuze12] == "0") {if($_POST[band12] == "") {$_POST[band12] = ".";} if($_POST[site12] == "http://") {$_POST[site12] = "."; } } else { $k12= $_POST[keuze12]; $_POST[band12] = "$band_array[$k12]"; $_POST[site12] = "$site_array[$k12]";} if($_POST[keuze13] == "0") {if($_POST[band13] == "") {$_POST[band13] = ".";} if($_POST[site13] == "http://") {$_POST[site13] = "."; } } else { $k13= $_POST[keuze13]; $_POST[band13] = "$band_array[$k13]"; $_POST[site13] = "$site_array[$k13]";} if($_POST[keuze14] == "0") {if($_POST[band14] == "") {$_POST[band14] = ".";} if($_POST[site14] == "http://") {$_POST[site14] = "."; } } else { $k14= $_POST[keuze14]; $_POST[band14] = "$band_array[$k14]"; $_POST[site14] = "$site_array[$k14]";} $rs = $conn->Execute("INSERT INTO reservering (datu, email, dat, datum, locatie, site, band1, site1, band2, site2, band3, site3, band4, site4, band5, site5,band6, site6,band7, site7,band8, site8,band9, site9,band10, site10,band11, site11,band12, site12,band13, site13,band14, site14,opmerking, verify, code) VALUES ( '".$_POST[datu]."','".$_POST[email]."', '".$_POST[dat]."','".$_POST[datum]."', '".$_POST[loc]."', '".$_POST[site]."', '".$_POST[band1]."', '".$_POST[site1]."', '".$_POST[band2]."', '".$_POST[site2]."', '".$_POST[band3]."', '".$_POST[site3]."', '".$_POST[band4]."', '".$_POST[site4]."', '".$_POST[band5]."', '".$_POST[site5]."', '".$_POST[band6]."', '".$_POST[site6]."', '".$_POST[band7]."', '".$_POST[site7]."', '".$_POST[band8]."', '".$_POST[site8]."', '".$_POST[band9]."', '".$_POST[site9]."', '".$_POST[band10]."', '".$_POST[site10]."', '".$_POST[band11]."', '".$_POST[site11]."', '".$_POST[band12]."', '".$_POST[site12]."', '".$_POST[band13]."', '".$_POST[site13]."', '".$_POST[band14]."', '".$_POST[site14]."','".$_POST[opmerking]."', 'no', '$code')"); print("
Bedankt voor de aanvulling op onze Concertagenda. U ontvangt binnenkort via

".$_POST[email]."

een mail met een bevestigingslink. Door deze link aan te klikken kunt u, uw gegevens toevoegen aan onze data base.
Indien het boven genoemde emailadres niet correct is verzoeken wij u opnieuw het formulier in te vullen.
"); $aanm = "aanmelding $_POST[loc] op $_POST[dat]"; $id = $_POST[email]; $id1 = "occultfest@hotmail.com"; $mailBody = "geachte mevrouw/meneer Op ons digitale domein www.occultfest.nl is het volgende concert/festival doorgegeven ".$_POST[email]." is als correspondentie E-mail opgegeven. ".$_POST[dat]." ".$_POST[loc]." ".$_POST[site]." ".$_POST[band1]." ".$_POST[site1]." ".$_POST[band2]." ".$_POST[site2]." ".$_POST[band3]." ".$_POST[site3]." ".$_POST[band4]." ".$_POST[site4]." ".$_POST[band5]." ".$_POST[site5]." ".$_POST[band6]." ".$_POST[site6]." ".$_POST[band7]." ".$_POST[site7]." ".$_POST[band8]." ".$_POST[site8]." ".$_POST[band9]." ".$_POST[site9]." ".$_POST[band10]." ".$_POST[site10]." ".$_POST[band11]." ".$_POST[site11]." ".$_POST[band12]." ".$_POST[site12]." ".$_POST[band13]." ".$_POST[site13]." ".$_POST[band14]." ".$_POST[site14]." opmerkingen: ".$_POST[opmerking]." Indien de bovenstaand gegevens kloppen en u het betreffende concert/festival graag in de occultfest concert agenda & Nieuws brief vermeld ziet, vraag ik u de onderstaande LINK aan te klikken om uw gegevens daarmee toe te voegen aan onze database (plaatsing onder voorbehoud) Indien de gegevens niet kloppen, vraag ik u deze mail te verwijderen en zich opnieuw aan te melden. Indien er ten onrechte gebruik is gemaakt van uw e-mail adres hiervoor onze excuses. http://www.occultfest.nl/content/form14.php?id=$id&code=$code met vriendelijke groeten namens stichting Occultfest Winanda Altena Gegevens stichting Occultfest: Wijsterseweg 2 7901 TC Hoogeveen bestuur@occultfest.nl tel: 06-54607891"; $mailHeaders = "From: \"Occultfest\" \nReply-To:"; mail($_POST[email], "$aanm", $mailBody, $mailHeaders); mail($id1, "$aanm", $mailBody, $mailHeaders); } } //formulier else { $select= "