<?php
    set_time_limit(0);
        ignore_user_abort(true);

            //XML-Quotenfeed laden
            $xml = simplexml_load_file('./xml/test.xml');

            //Datenbankverbindung herstellen
            require ("./inc/datenbank.php");

            //DB-Tabelle leeren
            $stmt = $db->query("TRUNCATE xml_event1");


            //Tabellen erstellen
            foreach ($xml->xpath("event/wette") as $wette) {
                $stmt = $db->query("CREATE TABLE IF NOT EXISTS `xml_event1_".$wette[evid]."` (
                                   `eventid` int(20) unsigned NOT NULL,
                                   `matchname` varchar(255) NOT NULL,
                                   `matchid` int(20) NOT NULL,
                                   `matchdatum` timestamp NOT NULL,
                                   `wettname` varchar(255) NOT NULL,
                                   `wettid` int(20) NOT NULL,
                                   `ergebnisname` varchar(255) NOT NULL,
                                   `ergebnisid` int(20) NOT NULL,
                                   `ergebnisodd` varchar(255) NOT NULL
                                   )");
            }



            //Füllen der ebend gelöschten Tabellen
            foreach ($xml->xpath('event') as $event) {
                $querystring = "INSERT INTO xml_event1 (sportid, eventid, sportname, eventname) VALUES";
                $querystring .= "(".$event['sportid'].",".$event['eventid'].",".$event['sportname'].",".$event['eventname']."),";
            }
            $querystring = substr($querystring, 0, -1);
            $stm = $db->prepare($querystring);
            $stm ->execute();

            foreach ($xml->xpath("event/wette") as $wette) {
                $querystring2 = "INSERT INTO xml_event_".$wette[evid]." (eventid, matchname, matchid, matchdatum, wettname, wettid, ergebnisname, ergebnisid, ergebnisodd) VALUES";
                $querystring2 .= "(".$wette['eventid'].",".$wette['matchname'].",".$wette['matchid'].",".$wette['matchdatum']."),".$wette['wettname'].",".$wette['wettid'].",".$wette['ergebnisname'].",".$wette['ergebnisid'].",".$wette['ergebnisodd'].",";
            }
            $querystring2 = substr($querystring2, 0, -1);
            $stm2 = $db->prepare($querystring2);
            $stm2 ->execute();