Upgrade to Pro Version | Donate | Support
Reporting features provide a list of events, list of attendees, and excel export.
Version: 2.1.3
Author: Seth Shoultes
Author URI: http://www.shoultes.net
Contributors:
Ben Dunkle http://field2.com - Icon Design - Thanks Ben!!
Changes:
2.1.3
Fixed database security holes.
2.1.2
Minor fixes throughout.
2.1.1
Added the ability to copy/duplicate an event.
Fixed a bug with the event questions/answers not showing in the Excel export.
Added event titles to the event url's for better SEO.
2.1.0
Removed the events_organization database table, we are now using the native Wordpress options database table to store the organization settings. This has speeded up the regsistration process considerably.
*/
/* Copyright 2009 SETH SHOULTES (email: seth@smartwebutah.com)
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*/
//Define static variables
define("EVNT_RGR_PLUGINPATH", "/" . plugin_basename( dirname(__FILE__) ) . "/");
define("EVNT_RGR_PLUGINFULLURL", WP_PLUGIN_URL . EVNT_RGR_PLUGINPATH );
define('EVENT_REGIS_vNum','2.1.3');
require("includes/event_regis_security_api.php");
define('organization_security_api',$organization_security_api);
define('events_security_api',$events_security_api);
define('events_registration_api',$events_registration_api);
//Install/Update Tables when plugin is activated
require("includes/database_install.php");
register_activation_hook(__FILE__,'events_data_tables_install');
//Event questions/options
require("includes/event_form_config.php");
//Payment Page/PayPal Buttons - Used to display the payment options and the payment link in the email. Used with the {EVENTREGPAY} tag
require("includes/paypal.class.php");
require("includes/payment_page.php");
//The calendar pop function
require("includes/tc_calendar.php");
//Events Listing - Shows the events on your page. Used with the {EVENTREGIS} tag
require("includes/get_event_details.php");
require("includes/display_all_events.php");
//List Attendees - Used with the {EVENTATTENDEES} tag
require("includes/attendee_list.php");
//Widget - Display the list of events in your sidebar
require("includes/widget.php");
//Admin Widget - Display event stats in your admin dashboard
require("includes/event_regis_dashboard_widget.php");
//Payment processing - Used for onsite payment processing. Used with the {EVENTPAYPALTXN} tag
require("includes/process_payments.php");
//Build the admin header for the plugin
require("includes/admin_header.php");
add_action('admin_head', 'admin_register_head');
//Event Registration Subpage - Configure Organization
require("includes/organization_config_mnu.php");
//Event Registration Subpage - Add/Delete/Edit Events
require("includes/manage_events.php");
//Event Registration Subpage - View Attendees
require("includes/event_registration_reports.php");
require("includes/edit_attendee_record.php");
//require("includes/admin_list_attendees.php");
//Event Registration Subpage - Enter Attendee Payments
require("includes/admin_reports.php");
require("includes/admin_process_payments.php");
require("includes/list_attendee_payments.php");
require("includes/enter_attendee_payments.php");
//Event Registration Subpage - Plugin Support
require("includes/admin_event_categories.php");
require("includes/event_regis_categories.php");
//Event Registration Subpage - Plugin Support
require("includes/admin_support.php");
//Main form events page
require("includes/event_register_attendees.php");
//Event Registration Main Admin Page
function event_regis_main_mnu(){
/* The following functions are what I wish to add to the main menu page
1. Display current count of attendees for active event (show event name, description and id)- shows by default
*/
organization_config_mnu();
}
/**
* Add a settings link to the Plugins page, so people can go straight from the plugin page to the
* settings page.
*/
function event_regis_filter_plugin_actions( $links, $file ){
// Static so we don't call plugin_basename on every plugin row.
static $this_plugin;
if ( ! $this_plugin ) $this_plugin = plugin_basename(__FILE__);
if ( $file == $this_plugin ){
$org_settings_link = '' . __('Settings') . '';
$events_link = '' . __('Events') . '';
array_unshift( $links, $org_settings_link, $events_link ); // before other links
}
return $links;
}
add_filter( 'plugin_action_links', 'event_regis_filter_plugin_actions', 10, 2 );
function add_event_registration_menus() {
add_menu_page('PayPal Events Registration', 'Events', 8, __FILE__, 'event_regis_main_mnu', EVNT_RGR_PLUGINFULLURL.'images/events_icon_16.png');
add_submenu_page(__FILE__, 'Configure Organization', 'Configure Organization', 8, __FILE__, 'event_regis_main_mnu');
add_submenu_page(__FILE__, 'Event Setup', 'Event Setup', 8, 'events', 'event_regis_manage_events');
add_submenu_page(__FILE__, 'Manage Event Categories', 'Event Categories', 8, 'event_categories', 'event_regis_categories_config_mnu');
add_submenu_page(__FILE__, 'Regform Setup', 'Regform Setup', 8, 'form', 'event_form_config');
//add_submenu_page(__FILE__, 'View Attendees', 'View Attendees', 8, 'attendees', 'event_registration_reports');
add_submenu_page(__FILE__, 'Attendees/Payments', 'Attendees/Payments', 8, 'admin_reports', 'event_admin_reports');
add_submenu_page(__FILE__, 'Help/Support', 'Help/Support', 8, 'support', 'event_regis_support');
}
//ADMIN MENU
add_action('admin_menu', 'add_event_registration_menus');
// Enable the ability for the event_funct to be loaded from pages
add_filter('the_content','event_regis_insert');
add_filter('the_content','event_regis_attendees_insert');
add_filter('the_content','event_regis_pay_insert');
add_filter('the_content','event_paypal_txn_insert');
// Function to deal with loading the events into pages
function event_regis_insert($content)
{
if (preg_match('{EVENTREGIS}',$content))
{
$content = str_replace('{EVENTREGIS}',event_regis_run(),$content);
}
return $content;
}
function event_regis_attendees_insert($content)
{
if (preg_match('{EVENTATTENDEES}',$content))
{
$content = str_replace('{EVENTATTENDEES}',event_attendee_list_run(),$content);
}
return $content;
}
function event_regis_pay_insert($content)
{
if (preg_match('{EVENTREGPAY}',$content))
{
$content = str_replace('{EVENTREGPAY}',event_regis_pay(),$content);
}
return $content;
}
function event_paypal_txn_insert($content)
{
if (preg_match('{EVENTPAYPALTXN}',$content))
{
$content = str_replace('{EVENTPAYPALTXN}',event_paypal_txn(),$content);
}
return $content;
}
/*********Shortcode support starts here************/
// [SINGLEEVENT single_event_id="your_event_identifier"]
function show_single_event($atts) {
extract(shortcode_atts(array('single_event_id' => 'No ID Supplied'), $atts));
$single_event_id = "{$single_event_id}";
register_attendees($single_event_id);
}
add_shortcode('SINGLEEVENT', 'show_single_event');
// [EVENT_REGIS_CATEGORY event_category_id="your_category_identifier"]
function show_event_category($atts) {
extract(shortcode_atts(array('event_category_id' => 'No Category ID Supplied'), $atts));
$event_category_id = "{$event_category_id}";
display_event_regis_categories($event_category_id);
}
add_shortcode('EVENT_REGIS_CATEGORY', 'show_event_category');
/*********Shortcode support ends here************/
//Date formatting function starts here
function event_date_display($date){
if (empty($date)){
echo 'NO DATE SUPPLIED';
}else{
list($year, $month, $day) = split("-", $date);
$event_date_display = date('M d, Y', mktime(0, 0, 0, $month, $day, $year));
}
return $event_date_display;
}
//Run the program
function event_regis_run(){
global $wpdb;
$events_attendee_tbl = get_option('events_attendee_tbl');
$events_detail_tbl = get_option('events_detail_tbl');
$org_options = get_option('events_organization_settings');
$events_listing_type =$org_options['events_listing_type'];
$event_page_id =$org_options['event_page_id'];
if ($events_listing_type == ""){ echo "