{"meta":{"version":"1.12","build":"1323620803"},"pods":{"2":{"name":"eventbrite_ticket","label":"Eventbrite Tickets","is_toplevel":"0","detail_page":"","list_filters":"","pre_save_helpers":"","pre_drop_helpers":"","post_save_helpers":"","post_drop_helpers":"","fields":[{"name":"display_flag","label":"Display Flag","comment":"(0 = temp, 1 = live)","coltype":"bool","pickval":null,"weight":"13","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"eventbrite_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":null,"display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"visible","label":null,"comment":null,"coltype":"bool","pickval":null,"weight":"12","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"quantity_sold","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"11","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"quantity_available","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"10","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ticket_type","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"5","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"start_date","label":null,"comment":null,"coltype":"date","pickval":null,"weight":"8","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"price","label":null,"comment":null,"coltype":"num","pickval":null,"weight":"7","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"end_date","label":null,"comment":null,"coltype":"date","pickval":null,"weight":"9","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"description","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"4","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"currency","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"6","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ticket_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"2","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"name","label":"Name","comment":null,"coltype":"txt","pickval":null,"weight":"3","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":"1","unique":null,"multiple":null},{"name":"event_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"1","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null}]},"3":{"name":"eventbrite_attendee","label":"Eventbrite Attendees","is_toplevel":"0","detail_page":"","list_filters":"","pre_save_helpers":"","pre_drop_helpers":"","post_save_helpers":"","post_drop_helpers":"","fields":[{"name":"age","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"51","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"birth_date","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"50","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"gender","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"49","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"blog","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"48","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"website","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"47","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"company","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"46","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"job_title","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"45","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"work_phone","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"44","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"work_country_code","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"43","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"work_country","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"42","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"work_region","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"41","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"work_postal_code","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"40","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"work_city","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"39","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"work_address_2","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"38","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"work_address","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"37","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ship_country_code","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"36","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ship_country","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"35","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ship_region","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"34","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ship_postal_code","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"33","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ship_city","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"32","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ship_address_2","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"31","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ship_address","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"30","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"cell_phone","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"29","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"home_phone","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"28","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"home_country_code","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"27","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"home_country","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"26","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"home_region","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"25","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"home_postal_code","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"24","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"home_city","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"23","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"home_address_2","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"22","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"home_address","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"21","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"suffix","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"20","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"last_name","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"19","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"first_name","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"18","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"email","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"16","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"prefix","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"17","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"notes","label":null,"comment":null,"coltype":"code","pickval":null,"weight":"15","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"discount","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"14","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"eventbrite_date","label":null,"comment":null,"coltype":"date","pickval":null,"weight":"13","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"order_modified","label":null,"comment":null,"coltype":"date","pickval":null,"weight":"12","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"order_created","label":null,"comment":null,"coltype":"date","pickval":null,"weight":"11","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"order_type","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"10","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"order_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"9","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"barcode","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"8","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"amount_paid","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"7","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"currency","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"6","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"quantity","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"5","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"ticket_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"4","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"event_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"1","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"name","label":"Name","comment":null,"coltype":"txt","pickval":null,"weight":"2","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":"1","unique":null,"multiple":null},{"name":"attendee_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"3","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"display_flag","label":"Display Flag","comment":"(0 = temp, 1 = live)","coltype":"bool","pickval":null,"weight":"52","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"user_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"53","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"eventbrite_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":null,"display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null}]},"4":{"name":"eventbrite_attendee_answer","label":"Eventbrite Attendee Answers","is_toplevel":"0","detail_page":"","list_filters":"","pre_save_helpers":"","pre_drop_helpers":"","post_save_helpers":"","post_drop_helpers":"","fields":[{"name":"question_type","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"5","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"name","label":"Question","comment":null,"coltype":"txt","pickval":null,"weight":"4","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":"1","unique":null,"multiple":null},{"name":"attendee_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"2","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"answer_text","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"6","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"question_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"3","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"event_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"1","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"display_flag","label":"Display Flag","comment":"(0 = temp, 1 = live)","coltype":"bool","pickval":null,"weight":"7","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"eventbrite_id","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":null,"display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null}]},"5":{"name":"eventbrite","label":"","is_toplevel":"0","detail_page":"","list_filters":"","pre_save_helpers":"","pre_drop_helpers":"","post_save_helpers":"","post_drop_helpers":"","fields":[{"name":"name","label":"Name","comment":null,"coltype":"txt","pickval":null,"weight":null,"display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":"1","unique":null,"multiple":null},{"name":"event_id","label":"Eventbrite Event ID","comment":null,"coltype":"txt","pickval":null,"weight":"2","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":"1","unique":null,"multiple":null},{"name":"display_flag","label":"Display?","comment":null,"coltype":"bool","pickval":null,"weight":"3","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"title","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"4","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"description","label":null,"comment":null,"coltype":"code","pickval":null,"weight":"5","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"category","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"6","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"tags","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"7","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"start_date","label":null,"comment":null,"coltype":"date","pickval":null,"weight":"8","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"end_date","label":null,"comment":null,"coltype":"date","pickval":null,"weight":"9","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"timezone","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"10","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"event_created","label":null,"comment":null,"coltype":"date","pickval":null,"weight":"11","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"event_modified","label":null,"comment":null,"coltype":"date","pickval":null,"weight":"12","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"privacy","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"13","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"password","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"14","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"capacity","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"15","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"url","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"16","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"logo","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"17","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"logo_ssl","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"18","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"status","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"19","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"background_color","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"20","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"text_color","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"21","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"link_color","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"22","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"title_text_color","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"23","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"box_background_color","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"24","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"box_text_color","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"25","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"box_border_color","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"26","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"box_header_background_color","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"27","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null},{"name":"box_header_text_color","label":null,"comment":null,"coltype":"txt","pickval":null,"weight":"28","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":null,"unique":null,"multiple":null}]}},"templates":[{"name":"eventbrite_ticket_list","code":"<li>{@name} <small><?php\n        if (0 < $this->pod_helper('eventbrite_check_attendee')) {\n?>\n            <a href=\"http:\/\/www.eventbrite.com\/mytickets\/\" target=\"_blank\">Registered<\/a>\n<?php\n        }\n        else {\n?>\n            <a href=\"http:\/\/www.eventbrite.com\/orderstart?eid={@event_id}&quant_{@ticket_id}=1&has_javascript=1\">Buy Now &raquo;<\/a>\n<?php\n        }\n?><\/small><\/li>"},{"name":"eventbrite_attendee_list","code":"<li>{@name}<\/li>"}],"helpers":[{"name":"eventbrite_parse_xml","helper_type":"display","phpcode":"<?php\n\/**\n * xml2array() will convert the given XML text to an array in the XML structure.\n * Link: http:\/\/www.bin-co.com\/php\/scripts\/xml2array\/\n * Arguments : $contents - The XML text\n *                $get_attributes - 1 or 0. If this is 1 the function will get the attributes as well as the tag values - this results in a different array structure in the return value.\n *                $priority - Can be 'tag' or 'attribute'. This will change the way the resulting array sturcture. For 'tag', the tags are given more importance.\n * Return: The parsed XML in an array form. Use print_r() to see the resulting array structure.\n * Examples: $array =  xml2array(file_get_contents('feed.xml'));\n *              $array =  xml2array(file_get_contents('feed.xml', 1, 'attribute'));\n *\/\n$contents = $value;\n$get_attributes = 1;\n$priority = 'tag';\nif (!$contents) {\n    $this->parsed_xml = array();\n    return;\n}\n\nif (!function_exists('xml_parser_create')) {\n    \/\/print \"'xml_parser_create()' function not found!\"; \n    $this->parsed_xml = array();\n    return;\n}\n\n\/\/Get the XML parser of PHP - PHP must have this module for the parser to work \n$parser = xml_parser_create('');\nxml_parser_set_option($parser, XML_OPTION_TARGET_ENCODING, \"UTF-8\"); # http:\/\/minutillo.com\/steve\/weblog\/2004\/6\/17\/php-xml-and-character-encodings-a-tale-of-sadness-rage-and-data-loss \nxml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);\nxml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);\nxml_parse_into_struct($parser, trim($contents), $xml_values);\nxml_parser_free($parser);\n\nif (!$xml_values) return; \/\/Hmm... \n\n\/\/Initializations \n$xml_array = array();\n$parents = array();\n$opened_tags = array();\n$arr = array();\n\n$current = &$xml_array; \/\/Refference \n\n\/\/Go through the tags. \n$repeated_tag_index = array(); \/\/Multiple tags with same name will be turned into an array \nforeach ($xml_values as $data) {\n    unset($attributes, $value); \/\/Remove existing values, or there will be trouble \n\n    \/\/This command will extract these variables into the foreach scope \n    \/\/ tag(string), type(string), level(int), attributes(array). \n    extract($data); \/\/We could use the array by itself, but this cooler. \n\n    $result = array();\n    $attributes_data = array();\n\n    if (isset($value)) {\n        if ($priority == 'tag') $result = $value;\n        else $result['value'] = $value; \/\/Put the value in a assoc array if we are in the 'Attribute' mode \n    }\n\n    \/\/Set the attributes too. \n    if (isset($attributes) and $get_attributes) {\n        foreach ($attributes as $attr => $val) {\n            if ($priority == 'tag') $attributes_data[$attr] = $val;\n            else $result['attr'][$attr] = $val; \/\/Set all the attributes in a array called 'attr' \n        }\n    }\n\n    \/\/See tag status and do the needed. \n    if ($type == \"open\") { \/\/The starting of the tag '<tag>' \n        $parent[$level - 1] = &$current;\n        if (!is_array($current) or (!in_array($tag, array_keys($current)))) { \/\/Insert New tag \n            $current[$tag] = $result;\n            if ($attributes_data) $current[$tag . '_attr'] = $attributes_data;\n            $repeated_tag_index[$tag . '_' . $level] = 1;\n\n            $current = &$current[$tag];\n\n        } else { \/\/There was another element with the same tag name \n\n            if (isset($current[$tag][0])) { \/\/If there is a 0th element it is already an array \n                $current[$tag][$repeated_tag_index[$tag . '_' . $level]] = $result;\n                $repeated_tag_index[$tag . '_' . $level]++;\n            } else { \/\/This section will make the value an array if multiple tags with the same name appear together \n                $current[$tag] = array($current[$tag], $result); \/\/This will combine the existing item and the new item together to make an array \n                $repeated_tag_index[$tag . '_' . $level] = 2;\n\n                if (isset($current[$tag . '_attr'])) { \/\/The attribute of the last(0th) tag must be moved as well \n                    $current[$tag]['0_attr'] = $current[$tag . '_attr'];\n                    unset($current[$tag . '_attr']);\n                }\n\n            }\n            $last_item_index = $repeated_tag_index[$tag . '_' . $level] - 1;\n            $current = &$current[$tag][$last_item_index];\n        }\n\n    } elseif ($type == \"complete\") { \/\/Tags that ends in 1 line '<tag \/>' \n        \/\/See if the key is already taken. \n        if (!isset($current[$tag])) { \/\/New Key \n            $current[$tag] = $result;\n            $repeated_tag_index[$tag . '_' . $level] = 1;\n            if ($priority == 'tag' and $attributes_data) $current[$tag . '_attr'] = $attributes_data;\n\n        } else { \/\/If taken, put all things inside a list(array) \n            if (isset($current[$tag][0]) and is_array($current[$tag])) { \/\/If it is already an array... \n\n                \/\/ ...push the new element into that array. \n                $current[$tag][$repeated_tag_index[$tag . '_' . $level]] = $result;\n\n                if ($priority == 'tag' and $get_attributes and $attributes_data) {\n                    $current[$tag][$repeated_tag_index[$tag . '_' . $level] . '_attr'] = $attributes_data;\n                }\n                $repeated_tag_index[$tag . '_' . $level]++;\n\n            } else { \/\/If it is not an array... \n                $current[$tag] = array($current[$tag], $result); \/\/...Make it an array using using the existing value and the new value \n                $repeated_tag_index[$tag . '_' . $level] = 1;\n                if ($priority == 'tag' and $get_attributes) {\n                    if (isset($current[$tag . '_attr'])) { \/\/The attribute of the last(0th) tag must be moved as well \n\n                        $current[$tag]['0_attr'] = $current[$tag . '_attr'];\n                        unset($current[$tag . '_attr']);\n                    }\n\n                    if ($attributes_data) {\n                        $current[$tag][$repeated_tag_index[$tag . '_' . $level] . '_attr'] = $attributes_data;\n                    }\n                }\n                $repeated_tag_index[$tag . '_' . $level]++; \/\/0 and 1 index is already taken \n            }\n        }\n\n    } elseif ($type == 'close') { \/\/End of tag '<\/tag>' \n        $current = &$parent[$level - 1];\n    }\n}\n\n$this->parsed_xml = $xml_array;"},{"name":"eventbrite_update_attendee","helper_type":"display","phpcode":"<?php\nglobal $wpdb;\n$pod_params = $value['params'];\n$xml = $value['xml'];\n\n$api = new PodAPI();\n\n$pod = new Pod($pod_params['datatype']);\n$pod->pod_helper('eventbrite_parse_xml', $xml);\n\n$xml = $pod->parsed_xml;\n\nif (isset($xml['attendees']) && !empty($xml['attendees']['attendee'])) {\n    if (isset($xml['attendees']['created'])) {\n        $xml['attendees']['attendee'] = array($xml['attendees']);\n    }\n    if (isset($xml['attendees']['attendee']['created'])) {\n        $xml['attendees']['attendee'] = array($xml['attendees']['attendee']);\n    }\n    echo \"<strong>\" . count($xml['attendees']['attendee']) . \" Attendee(s) Found<\/strong><br \/>\\n\";\n    foreach ($xml['attendees']['attendee'] as $attendee)\n    {\n        $params = $pod_params;\n        foreach ($params['columns'] as $column => $val)\n        {\n            if (isset($attendee[$column])) {\n                $params['columns'][$column] = trim($attendee[$column]);\n            }\n        }\n        $params['columns']['name'] = $params['columns']['first_name'] . ' ' . $params['columns']['last_name'];\n        $params['columns']['display_flag'] = 0;\n        echo 'Processing Attendee: ' . $params['columns']['name'] . \"<br \/><blockquote>\\n\";\n        $params['columns']['attendee_id'] = $attendee['id'];\n        if (isset($attendee['created']))\n            $params['columns']['order_created'] = $attendee['created'];\n        if (isset($attendee['modified']))\n            $params['columns']['order_modified'] = $attendee['modified'];\n        $the_user_id = @current($wpdb->get_col($wpdb->prepare(\"SELECT ID FROM {$wpdb->users} WHERE user_email=%s OR user_login=%s\", array($attendee['email'], $attendee['email']))));\n        if (empty($the_user_id) && isset($attendee['email']) && !empty($attendee['email']) && get_option('eventbrite_pods_create_user') == 1) {\n            require_once(ABSPATH . WPINC . '\/registration.php');\n            $random_password = wp_generate_password(12, false);\n            $username = str_replace('-', '_', sanitize_title($params['columns']['first_name'] . $params['columns']['last_name']));\n            $check_username = @current($wpdb->get_col($wpdb->prepare(\"SELECT ID FROM {$wpdb->users} WHERE user_login=%s\", array($username))));\n            if (!empty($check_username)) {\n                $username .= 1;\n            }\n            $check_username = @current($wpdb->get_col($wpdb->prepare(\"SELECT ID FROM {$wpdb->users} WHERE user_login=%s\", array($username))));\n            if (!empty($check_username)) {\n                $username .= 2;\n            }\n            $the_user_id = wp_create_user($username, $random_password, $attendee['email']);\n            $prefix = str_replace('_users', '_', $wpdb->users);\n            $field_id = 1;\n            $data_id = @current($wpdb->get_col($wpdb->prepare(\"SELECT id FROM {$prefix}bp_xprofile_data WHERE field_id=%f AND user_id=%f\", array($field_id, $the_user_id))));\n            $now = gmdate('Y-m-d H:i:s', (time() + (get_option('gmt_offset') * 3600)));\n            if (0 < $data_id && is_numeric($data_id)) {\n                $wpdb->query($wpdb->prepare(\"UPDATE {$prefix}bp_xprofile_data SET value=%s,last_updated=%s WHERE field_id=%f AND user_id=%f\", array($params['columns']['name'], $now, $field_id, $the_user_id)));\n            }\n            else\n            {\n                $wpdb->query($wpdb->prepare(\"INSERT INTO {$prefix}bp_xprofile_data (value,last_updated,field_id,user_id) VALUES (%s,%s,%f,%f)\", array($params['columns']['name'], $now, $field_id, $the_user_id)));\n            }\n            $wpdb->query($wpdb->prepare(\"UPDATE {$wpdb->users} SET display_name=%s,user_nicename=%s WHERE ID=%f\", array($params['columns']['name'], $username, $the_user_id)));\n            update_user_meta($the_user_id, 'first_name', $params['columns']['first_name']);\n            update_user_meta($the_user_id, 'last_name', $params['columns']['last_name']);\n        }\n        $params['columns']['user_id'] = (empty($the_user_id) ? '' : $the_user_id);\n        $pod->findRecords(array('orderby' => 't.id',\n                                'limit' => 1,\n                                'where' => \"t.eventbrite_id=\" . $params['columns']['eventbrite_id'] . \" AND t.event_id=\" . $params['columns']['event_id'] . \" AND t.attendee_id=\" . $params['columns']['attendee_id'],\n                                'search' => false,\n                                'page' => 1));\n        if ($pod->fetchRecord())\n            $params['tbl_row_id'] = $pod->get_field('id');\n        if (isset($attendee['answers'])) {\n            $a_columns = array('eventbrite_id' => $params['columns']['eventbrite_id'], 'event_id' => $params['columns']['event_id'], 'attendee_id' => $params['columns']['attendee_id'], 'question_id' => '', 'name' => '', 'question_type' => '', 'answer_text' => '');\n            $a_params = array('datatype' => 'eventbrite_attendee_answer', 'columns' => $a_columns);\n            $a_options = array('params' => $a_params, 'xml' => $attendee['answers']);\n            echo \"Getting Attendee Answers..<br \/><blockquote>\\n\";\n            echo $this->pod_helper('eventbrite_update_attendee_answer', $a_options) . \"<br \/>\\n\";\n        }\n        $api->save_pod_item(pods_sanitize($params));\n        echo \"<\/blockquote><br \/>\\n<strong>Saved Order #\" . $params['columns']['order_id'] . \" \/ Attendee #\" . $params['columns']['attendee_id'] . \"<\/strong><\/blockquote><br \/>\\n\";\n    }\n}"},{"name":"eventbrite_update_ticket","helper_type":"display","phpcode":"<?php\n$pod_params = $value['params'];\n$xml = $value['xml'];\n\n$api = new PodAPI();\n\n$pod = new Pod($pod_params['datatype']);\n$pod->pod_helper('eventbrite_parse_xml', $xml);\n\n$xml = $pod->parsed_xml;\n\nif (isset($xml['event']) && !empty($xml['event']['tickets'])) {\n    if (isset($xml['event']['tickets']['id']))\n        $xml['event']['tickets'] = array($xml['event']['tickets']);\n    echo \"<strong>\" . count($xml['event']['tickets']['ticket']) . \" Ticket(s) Found<\/strong>.<br \/>\\n\";\n    foreach ($xml['event']['tickets']['ticket'] as $ticket)\n    {\n        $params = $pod_params;\n        foreach ($params['columns'] as $column => $val)\n        {\n            if (isset($ticket[$column])) {\n                $params['columns'][$column] = $ticket[$column];\n            }\n        }\n        $params['columns']['display_flag'] = 0;\n        $params['columns']['ticket_id'] = $ticket['id'];\n        $params['columns']['ticket_type'] = $ticket['type'];\n        echo 'Processing Ticket: ' . $params['columns']['name'] . \"<br \/>\\n\";\n        $pod->findRecords(array('orderby' => 't.id',\n            'limit' => 1,\n            'where' => \"t.eventbrite_id=\" . $params['columns']['eventbrite_id'] . \" AND t.event_id=\" . $params['columns']['event_id'] . \" AND t.ticket_id='\" . $params['columns']['ticket_id'] . \"'\",\n            'search' => false,\n            'page' => 1));\n        if ($pod->fetchRecord())\n            $params['tbl_row_id'] = $pod->get_field('id');\n        $api->save_pod_item(pods_sanitize($params));\n        echo \"<strong>Saved Ticket #\" . $params['columns']['ticket_id'] . \"<\/strong><br \/>\\n\";\n    }\n}"},{"name":"eventbrite_update_attendee_answer","helper_type":"display","phpcode":"<?php\n$pod_params = $value['params'];\n$xml = $value['xml'];\n\n$api = new PodAPI();\n\n$pod = new Pod($pod_params['datatype']);\n\nif (isset($xml['answer']) && !empty($xml['answer'])) {\n    if (isset($xml['answer']['answer_text'])) {\n        $xml['answer'] = array($xml['answer']);\n    }\n    echo \"<strong>\" . count($xml['answer']) . \" Answer(s) Found<\/strong><br \/>\\n\";\n    foreach ($xml['answer'] as $answer)\n    {\n        $params = $pod_params;\n        foreach ($params['columns'] as $column => $val)\n        {\n            if (isset($answer[$column])) {\n                $params['columns'][$column] = $answer[$column];\n            }\n        }\n        $params['columns']['name'] = $answer['question'];\n        $params['columns']['display_flag'] = 0;\n        echo 'Processing Question: ' . $params['columns']['name'] . \"<br \/>\\n\";\n        $pod->findRecords(array('orderby' => 't.id',\n            'limit' => 1,\n            'where' => \"t.eventbrite_id=\" . $params['columns']['eventbrite_id'] . \" AND t.event_id=\" . $params['columns']['event_id'] . \" AND t.question_id=\" . $params['columns']['question_id'] . \" AND t.attendee_id=\" . $params['columns']['attendee_id'],\n            'search' => false,\n            'page' => 1));\n        if ($pod->fetchRecord())\n            $params['tbl_row_id'] = $pod->get_field('id');\n        $api->save_pod_item(pods_sanitize($params));\n        echo \"<strong>Saved Question #\" . $params['columns']['question_id'] . \" \/ Name \" . $params['columns']['name'] . \"<\/strong><br \/>\\n\";\n    }\n    echo \"No More Questions!\\n\";\n}\nelse\n{\n    echo \"No Answers Found..\\n\";\n}"},{"name":"eventbrite_check_attendee","helper_type":"display","phpcode":"<?php\nglobal $user_ID;\nif (is_user_logged_in()) {\n    $ticket_id = (int)$this->get_field('ticket_id');\n    $event_id = (int)$this->get_field('event_id');\n    $attendee = new Pod('eventbrite_attendee');\n    $params = array('search' => false, 'page' => 1, 'orderby' => 't.id DESC', 'limit' => 1, 'where' => \"t.event_id={$event_id} AND t.ticket_id={$ticket_id} AND t.user_id={$user_ID}\");\n    $attendee->findRecords($params);\n    if (0 < $attendee->getTotalRows()) {\n        $attendee->fetchRecord();\n        echo $attendee->get_field('id');\n        return;\n    }\n}\necho 0;"},{"name":"eventbrite_ui_ticket","helper_type":"display","phpcode":"<?php\nif (!empty($value)) {\n    $ticket = new Pod('eventbrite_ticket');\n    $params = array('orderby' => 't.id DESC',\n                    'limit' => 1,\n                    'where' => \"t.display_flag=1 AND t.ticket_id={$value}\",\n                    'select' => 't.id,t.name',\n                    'search' => false,\n                    'page' => 1);\n    $ticket->findRecords($params);\n    if (0 < $ticket->fetchRecord()) {\n        echo '<a href=\"' . get_option('wpurl') . '\/wp-admin\/admin.php?page=eventbrite-for-pods-tickets&amp;action=view&amp;id=' . $ticket->get_field('id') . '\">' . $ticket->get_field('name') . '<\/a>';\n        return;\n    }\n}\necho 'N\/A';"},{"name":"eventbrite_ui_date","helper_type":"display","phpcode":"<?php\n$value = strtotime($value);\nif (1000 < $value)\n    echo date_i18n('m\/d\/Y', $value);\nelse\n    echo 'N\/A';"},{"name":"eventbrite_update_event","helper_type":"display","phpcode":"<?php\n$pod_params = $value['params'];\n$xml = $value['xml'];\n\n$api = new PodAPI();\n\n$pod = new Pod($pod_params['datatype']);\n$pod->pod_helper('eventbrite_parse_xml', $xml);\n\n$xml = $pod->parsed_xml;\n\nif (isset($xml['event'])) {\n    $data = $xml['event'];\n    echo \"<strong>Event Data Found<\/strong>.<br \/>\\n\";\n    $params = $pod_params;\n    foreach ($params['columns'] as $column => $val)\n    {\n        if (isset($data[$column]) && !empty($data[$column]) && !is_array($data[$column])) {\n            $params['columns'][$column] = $data[$column];\n        }\n    }\n    $params['columns']['event_created'] = $data['created'];\n    $params['columns']['event_modified'] = $data['modified'];\n    echo 'Processing Event: ' . $params['columns']['title'] . \"<br \/>\\n\";\n    $params['tbl_row_id'] = $this->get_field('id');\n    $api->save_pod_item(pods_sanitize($params));\n    echo \"<strong>Saved Event: \" . $params['columns']['title'] . \"<\/strong><br \/>\\n\";\n}"}]}