RSS Feed to DB

<?php // Get RSS Feed
include_once"wp-config.php";
include_once"wp-load.php";
include_once"wp-includes/wp-db.php";
global $wpdb;

$feeds = ('http://www.trumba.com/calendars/vd.rss?mixin=236385%2c236392%2c236393%2c236288');
$xml = simplexml_load_file($feeds);

$post_fields = array('event_slug','event_owner','event_name','event_attributes','post_id','post_content');
$event_metas = array(); //restart metas

$i=0;

foreach($xml->channel->item as $item) {

        //Data for each event entry
        $title = $item->title;
        $slug = strtolower(str_replace(" ", "-", $title));
        $description = $item->description;
        $weblink = $item->children('x-trumba', true)->weblink;
        $location = $item->children('xCal', true)->location;
        $location = substr($location,0,-1); //Only for VailDaily Feed
        $sdate = substr(date("Y-n-j H:i:s",strtotime($item->children('x-trumba', true)->localstart)),0, -9);
        $edate = substr(date("Y-n-j H:i:s",strtotime($item->children('x-trumba', true)->localend)),0, -9);
        $stime = substr(date("Y-n-j H:i:s",strtotime($item->children('x-trumba', true)->localstart)),-8);
        $etime = substr(date("Y-n-j H:i:s",strtotime($item->children('x-trumba', true)->localend)),-8);
        $category = $item->children('x-trumba', true)->customfield;

        //Insert New WP Post
        $post_array = array();
        $post_array['post_type'] = 'event';
        $post_array['post_title'] = wp_strip_all_tags($title);
        $post_array['post_content'] = $description;
        $post_array['post_status'] = 'pending';
        $post_array['post_author'] = 1;
        $event['start_ts'] = $sdate;
        $event['end_ts'] = $edate;
        //Save post, register post id in index
        $post_id = wp_insert_post($post_array);
        if( is_wp_error($post_id) || $post_id == 0 ){ $post_id = 999999999999999999; }
        if( $post_id != 999999999999999999 ){
                $wpdb->query('UPDATE '.EM_EVENTS_TABLE." SET post_id='$post_id' WHERE event_id='{$event['event_id']}'");
                //meta
                foreach($event as $meta_key => $meta_val){
                        if( !in_array($meta_key, $post_fields) && $meta_key != 'event_attributes' ){
                                $event_metas[] = $wpdb->prepare("(%d, '%s', '%s')", array($post_id, '_'.$meta_key, $meta_val));
                        }elseif($meta_key == 'event_attributes'){
                                $event_attributes = unserialize($meta_val); //from em table it's serialized
                                if( is_array($event_attributes) ){
                                        foreach($event_attributes as $att_key => $att_val){
                                                $event_metas[] = $wpdb->prepare("(%d, '%s', '%s')", array($post_id, $att_key, $att_val));
                                        }
                                }
                        }
                }
        }

        //Find possible existing location via text query
        $query = 'SELECT location_id FROM wp_em_locations WHERE location_name ="'.$location.'"';
        $locresult = mysql_query($query);
                  echo mysql_error();
                //Set location_id to query returned
                if (mysql_num_rows($locresult) > 0) {
                    while ($row = mysql_fetch_assoc($locresult)) {
                                $location_id = $row['location_id'];
                        }
                } else { $location_id = NULL; }


        //Insert INTO EM Table
        $sql = "INSERT INTO wp_em_events (event_owner, event_status, event_name, event_start_time, event_end_time, event_start_date, event_end_date, post_content, event_rsvp, post_id, location_id)
        values (
        1,
        0,
        '".mysql_real_escape_string($title)."' ,
        '".$stime."' ,
        '".$etime."' ,
        '".$sdate."' ,
        '".$edate."' ,
        '".mysql_real_escape_string($description)."',
        0,
        '".$post_id."',
        '".$location_id."'
        )";

                mysql_query($sql);
                echo mysql_error();

        //Display Results
    echo '<div>TITLE: '.$title.'</div>';
        echo '<div>LOCATION: '.$location.'</div>';
        echo '<div>START: '.$sdate.'</div>';
        echo '<div>END: ' .$edate.'</div>';
        echo '<div>START: '.$stime.'</div>';
        echo '<div>END: ' .$etime.'</div>';
        // echo '<div>LINK: ' .$weblink.'</div>';
        // echo '<div>CATEGORY: '.$category.'</div>';
                                if (mysql_num_rows($locresult) > 0) {
                                    while ($row = mysql_fetch_assoc($locresult)) {
                                                echo $row['location_id'];
                                        }
                                } else {
                                    echo "No existing location matched this in the Database";
                                }
        echo '<hr>';

//TODO Delete this for production or tweak to a manageable count
$i++;
if($i==3) break;
}
        //insert the metas in one go, faster than one by one
        if( count($event_metas) > 0 ){
                $result = $wpdb->query("INSERT INTO ".$wpdb->postmeta." (post_id,meta_key,meta_value) VALUES ".implode(',',$event_metas));
        }

//Confirmation
echo "<br><strong>Events have been inserted into the database</strong>";
?>