diff -r 6b96085291d7 -r fb7cd02b9848 web/wp-content/plugins/gigs-calendar/gigs-calendar.php
--- a/web/wp-content/plugins/gigs-calendar/gigs-calendar.php Tue Jan 05 09:48:24 2010 +0000
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,917 +0,0 @@
-
-
-
-
- = 2.5 ) {
- ?>
-
-
-
-
-
- __('Gigs', $gcd),
- 'archive' => __('Archive', $gcd),
- 'venues' => __('Venues', $gcd),
- 'tours' => __('Tours', $gcd),
- 'settings' => __('Settings', $gcd),
- 'feedback' => __('Feedback/Bugs', $gcd),
- 'credits' => __('Credits', $gcd),
- );
-
- foreach ( $pages as $key => $name ) {
- $pages[$key] = array('name'=>$name, 'key'=>$key, 'url'=>$folder . $key . '.ajax.php');
- }
-
- if ( $options['admin-only-settings'] && !current_user_can('administrator') ) {
- unset($pages['settings']);
- }
-
- $pages = apply_filters('gigCal_pages', $pages);
- ?>
-
-
-
-
-
-
-
-

-
-
-
-
-
-
-
- sortTours();
- foreach ( $tours as $tour ) {
- dtc_gigs::generateList(array(
- 'caption'=> $is_archive ? __('Upcoming shows', $gcd) : '',
- 'dateFormat' => 'short',
- 'tour' => $tour,
- ));
- }
- dtc_gigs::generateList(array(
- 'caption'=> '' . __('Other shows', $gcd) . '
',
- 'dateFormat' => 'short',
- 'tour' => -1,
- ));
- } else {
- dtc_gigs::generateList(array(
- 'caption'=> $is_archive ? __('Upcoming shows', $gcd) : '',
- 'dateFormat' => 'short',
- ));
- }
- }
- if ( !empty($options['archive']) && is_page($options['archive']) ) {
- if ( $options['tours-display'] ) {
- $t = new tour();
- $tours = $t->sortTours();
- foreach ( $tours as $tour ) {
- dtc_gigs::generateList(array(
- 'upcoming'=>false,
- 'caption'=> $is_archive ? __('Upcoming shows', $gcd) : '',
- 'dateFormat' => 'short',
- 'tour' => $tour,
- ));
- }
- dtc_gigs::generateList(array(
- 'upcoming'=>false,
- 'caption'=> '' . __('Other shows', $gcd) . '
',
- 'dateFormat' => 'short',
- 'tour' => -1,
- ));
- } else {
- dtc_gigs::generateList(array(
- 'upcoming'=>false,
- 'caption'=> $is_parent ? __('Past show archive', $gcd) : '',
- 'dateFormat' => 'archive',
- ));
- }
- }
-
- dtcGigs::loadTemplate('rss');
- dtcGigs::loadTemplate('attribution');
- $out = ob_get_clean();
- if ( $options['calendar-position'] == 'bottom' ) {
- $out = '' . $in . '
' . $out;
- } else {
- $out .= '' . $in . '
';
- }
- } else {
- $g = new gig();
- if ( $g->getByPostID($post->ID) ) {
- $data = array(
- 'g' => $g,
- 'v' => $g->getVenue(),
- 'p' => $g->getPerformances(),
- 'image_folder' => dtc_gigs::get_url() . 'images/',
- 'tags' => $g->getTags(),
- 'tags_slugs' => $g->getTags(true),
- 'custom' => $g->getCustom(),
- );
- ob_start();
- dtcGigs::loadTemplate('gig-post', null, $data);
- $out = ob_get_clean();
-
- $out = '' . $in . '
' . $out;
- } else {
- $out = $in;
- }
- }
- if ( preg_match_all('~\[gig-cal ?(.*?)\]~', $out, $matches) ) {
- $matches[0] = array_unique($matches[0]);
- foreach ( $matches[0] as $key => $match ) {
- $args = array();
- parse_str(str_replace(' ', '&', $matches[1][$key]), $args);
- $args['upcoming'] = (strpos($matches[1][$key], 'archive') !== FALSE) ? false : true;
- $args['return'] = true;
- $out = str_replace($match, dtc_gigs::generateList($args), $out);
- }
- }
- return $out;
- }
-
- function upgrade() {
- global $wpdb;
-
- if ( isset($wpdb->charset) && !empty($wpdb->charset) ) {
- $charset = ' DEFAULT CHARSET=' . $wpdb->charset;
- } elseif ( defined(DB_CHARSET) && DB_CHARSET != '' ) {
- $charset = ' DEFAULT CHARSET=' . DB_CHARSET;
- } else {
- $charset = '';
- }
-
- $queries = array(
- array( // 1
- '
- CREATE TABLE IF NOT EXISTS `' . TABLE_VENUES . '` (
- `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
- `name` VARCHAR( 255 ) NOT NULL ,
- `address` TEXT NOT NULL ,
- `city` VARCHAR( 255 ) NOT NULL ,
- `state` VARCHAR( 255 ) NOT NULL ,
- `country` VARCHAR( 255 ) NOT NULL ,
- `postalCode` VARCHAR( 255 ) NOT NULL ,
- `contact` VARCHAR( 255 ) NOT NULL ,
- `phone` VARCHAR( 255 ) NOT NULL ,
- `email` VARCHAR( 255 ) NOT NULL ,
- `link` VARCHAR( 255 ) NOT NULL ,
- `notes` TEXT NOT NULL ,
- `private` TINYINT NOT NULL ,
- `apiID` INT UNSIGNED NOT NULL ,
- `deleted` TINYINT NOT NULL
- ) ' . $charset . '
- ', '
- CREATE TABLE IF NOT EXISTS `' . TABLE_GIGS . '` (
- `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
- `venueID` INT UNSIGNED NOT NULL ,
- `date` DATE NOT NULL ,
- `notes` TEXT NOT NULL,
- `postID` BIGINT UNSIGNED NOT NULL
- ) ' . $charset . '
- ', '
- CREATE TABLE IF NOT EXISTS `' . TABLE_PERFORMANCES . '` (
- `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
- `gigID` INT UNSIGNED NOT NULL ,
- `time` TIME NULL ,
- `link` VARCHAR( 255 ) NOT NULL ,
- `shortNotes` VARCHAR( 255 ) NOT NULL ,
- `ages` VARCHAR( 255 ) NOT NULL
- ) ' . $charset . '
- '
- ), array( // 2
- 'ALTER TABLE `' . TABLE_VENUES . '` ADD `customMap` VARCHAR( 255 ) NOT NULL',
- 'ALTER TABLE `' . TABLE_GIGS . '` ADD `eventName` VARCHAR( 255 ) NOT NULL',
- ), array( // 3
- '
- CREATE TABLE `' . TABLE_TOURS . '` (
- `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
- `name` VARCHAR( 255 ) NOT NULL ,
- `notes` MEDIUMTEXT NOT NULL ,
- `pos` INT UNSIGNED NOT NULL
- ) ' . $charset . '
- ', '
- ALTER TABLE `' . TABLE_GIGS . '` ADD `tour_id` INT UNSIGNED NULL
- ',
- ),
-
-
-
- );
- for ( $i = (int) get_option('gig_db_version'); $i < (int) DTC_GIGS_DB_VERSION; $i++) {
- if ( isset($queries[$i]) ) {
- foreach ( $queries[$i] as $q ) {
- $wpdb->query($q);
- }
- }
- }
-
- if ( count($wpdb->get_results('show tables like "' . GIGS_DB_PREFIX . 'gigs_%"')) != 4 ) {
- update_option("gig_db_version", -1);
- } else {
- update_option("gig_db_version", (int) DTC_GIGS_DB_VERSION);
- }
- }
-
-
- function hide_posts($where) {
- $o = get_option('gigs-calendar');
- if ( 0 < (int) get_option('gig_db_version') && $o['post-filtering'] ) {
- global $wp_the_query;
- global $wp_query;
- global $wp_actions;
- global $wpdb;
- if ( in_array('get_sidebar', $wp_actions) ) {
- $where .= ' AND ID NOT IN (SELECT postID FROM ' . TABLE_GIGS . ')';
- } elseif ( (is_single() || (function_exists('is_tag') && is_tag())) ) {
- return $where;
- } elseif ( (!is_category() || $wp_the_query->query_vars['cat'] != $o['category']) || defined('gigs-query-mod')) {
- $where .= ' AND ID NOT IN (SELECT postID FROM ' . TABLE_GIGS . ')';
- }
- }
- return $where;
- }
-
- function hide_archives($where) {
- $o = get_option('gigs-calendar');
- if ( $o['post-filtering'] ) {
- global $wpdb;
- return $where . ' AND ID NOT IN (SELECT postID FROM ' . TABLE_GIGS . ')';
- }
- }
-
-
- function post_nav($where) {
- $o = get_option('gigs-calendar');
- if ( 0 < (int) get_option('gig_db_version') && $o['post-filtering'] ) {
- global $wp_the_query, $include_folder, $wpdb, $wp_version;
-
- include_once 'gigs-classes.php';
-
- $wtq = $wp_the_query;
- $g = new gig();
-
- $table = ''; // This will let me support versions < 2.3
- if ( (float) $wp_version >= 2.3 ) {
- $table = 'p.';
- }
-
- if ( $wtq->is_single && $wpdb->get_var('SELECT COUNT(*) FROM ' . TABLE_GIGS . ' WHERE postID = ' . $wtq->post->ID) ) { // Is a gig
- $where .= ' AND ' . $table . 'ID IN (SELECT postID FROM ' . TABLE_GIGS . ')';
- } else {
- $where .= ' AND ' . $table . 'ID NOT IN (SELECT postID FROM ' . TABLE_GIGS . ')';
- }
- }
- return $where;
- }
-
- function widget_upcoming($args) {
- extract($args);
- $o = get_option('gigs-calendar');
- if ( !isset($o['widget']['upcoming']) ) $o['widget']['upcoming'] = array();
- ?>
-
-
- true,
- 'limit'=>$o['widget']['upcoming']['length'],
- 'template'=>'upcoming-widget',
- ),
- $o['widget']['upcoming']
- ));
- ?>
-
- 'City',
- 'country' => 'Country',
- 'venue' => 'Venue',
- 'eventName' => 'Event Name',
- );
-
- ?>
-
-
-
-
-
-
-
- date() function syntax', $gcd) ?>
-
-
-
-
-
-
-
-
-
-
-
-
-
- __('Next Gig', $gcd));
- ?>
-
-
- true,
- 'limit'=>1,
- 'template'=>'next-widget',
- ));
- ?>
-
- __('Next Gig', $gcd),
- );
-
- if ( !isset($o['widget']['next']) ) {
- $o['widget']['next'] = array();
- }
-
- $o['widget']['next'] = array_merge($defaults, $o['widget']['next']);
-
- if ( isset($_POST['gigs_next_title']) ) {
- $o['widget']['next']['title'] = !empty($_POST['gigs_next_title']) ? $_POST['gigs_next_title'] : $defaults['title'];
- print_r($o['widget']);
- update_option('gigs-calendar', $o);
- }
-
- ?>
-
-
-
- true,
- 'limit' => false,
- 'tour' => false,
- 'template' => 'gigs-list',
- 'dateFormat' => ($args['upcoming'] === false ? 'archive' : 'short'),
- 'force' => false,
- 'year' => null,
- 'month' => null,
- 'caption' => null,
- );
-
-
- $args = is_array($args) ? array_merge($defaults, $args) : $defaults;
- extract($args);
-
- $listFields = array(
- 'city' => __('City', $gcd),
- 'country' => __('Country', $gcd),
- 'venue' => __('Venue', $gcd),
- 'eventName' => __('Event', $gcd),
- 'date' => __('Date', $gcd),
- 'time' => __('Time', $gcd),
- 'shortNotes' => __('Notes', $gcd),
- 'tickets' => __('Tickets', $gcd),
- 'map' => __('Map', $gcd),
- );
-
- $show_fields = $options['gigs-table-show'];
- if ( !$upcoming && in_array( 'tickets', $show_fields ) ) {
- unset( $show_fields[array_search('tickets', $show_fields)] );
- }
-
- $gig_ids = array();
- if ( is_null($year) && is_null($month) ) {
- $gigs = $wpdb->get_results('
- SELECT
- *,
- g.notes as gigNotes,
- v.notes as venueNotes,
- g.id as gigID,
- v.link as venueLink
- FROM
- `' . TABLE_GIGS . '` AS g
- LEFT JOIN
- `' . TABLE_VENUES . '` AS v ON ( g.venueID = v.id )
- WHERE
- `date` ' . ($upcoming ? '>=' : '<=') . ' CURDATE()
- ' . (($tour && $tour != -1) ? ' AND tour_id = ' . (int) $tour : '') . '
- ' . ($tour == -1 ? ' AND tour_id is null' : '') . '
- ORDER BY
- `date` ' . ($upcoming ? 'ASC' : 'DESC') . '
- ' . ( !empty($limit) ? ' LIMIT ' . $limit : '' ) . '
-
- ');
- } else {
- $gigs = $wpdb->get_results('
- SELECT
- *,
- g.notes as gigNotes,
- v.notes as venueNotes,
- g.id as gigID,
- v.link as venueLink
- FROM
- `' . TABLE_GIGS . '` AS g
- LEFT JOIN
- `' . TABLE_VENUES . '` AS v ON ( g.venueID = v.id )
- WHERE
- 1=1
- ' . ( !is_null($year) ? 'AND YEAR(`date`) = ' . (int) $year : '' ) . '
- ' . ( !is_null($month) ? 'AND MONTH(`date`) = ' . (int) $month : '' ) . '
- ' . (($tour && $tour != -1) ? ' AND tour_id = ' . (int) $tour : '') . '
- ' . ($tour == -1 ? ' AND tour_id is null' : '') . '
- ORDER BY
- `date` ' . ($upcoming ? 'ASC' : 'DESC') . '
- ' . ( !empty($limit) ? ' LIMIT ' . $limit : '' ) . '
-
- ');
- }
-
- if ( $tour !== false && $tour !== "false" ) {
- if ( !count($gigs) && !$options['tours-empty'] && !$force ) {
- return '';
- }
- if ( $t != -1 && empty($caption) ) {
- $t = new tour($tour);
- $caption = '' . $t->name . '
' . $t->notes . '
';
- }
- }
-
-
- $performances = $wpdb->get_results('
- SELECT
- p.*
- FROM
- `' . TABLE_GIGS . '` AS g
- LEFT JOIN
- `' . TABLE_PERFORMANCES . '` AS p ON ( g.id = p.gigID )
- ORDER BY
- `time` ASC
- ');
-
- foreach ( $gigs as $key => $g ) {
- if ( empty($g->venueID) ) {
- $g->mapLink = false;
- } else {
- $g->mapLink = dtcGigs::mapLink($g);
- }
- $g->cityState = $g->city . ( empty($g->state) ? '' : ', ' . $g->state );
- $g->cityStateCountry = $g->city . ( empty($g->state) ? '' : ', ' . $g->state ) . ( empty($g->country) ? '' : ', ' . $g->country );
- $g->cityCountry = $g->city . ( empty($g->country) ? '' : ', ' . $g->country );
- $g->permalink = get_permalink($g->postID);
- $g->shortDate = dtcGigs::dateFormat($g->date, 'short');
- $g->longDate = dtcGigs::dateFormat($g->date, 'long');
- $g->archiveDate = dtcGigs::dateFormat($g->date, 'archive');
- $g->mysqlDate = $g->date;
- $g->date = dtcGigs::dateFormat($g->date, $dateFormat);
- $g->id = $g->gigID;
- $g->id = $g->gigID;
- $g->performances = array();
- $g->tags_slugs = array();
- $g->tags = function_exists('wp_get_post_tags') ? wp_get_post_tags($g->postID) : array();
- $gig_ids[$g->gigID] = $key;
- foreach ( $g->tags as $tagkey => $tag ) {
- $g->tags[$tagkey] = $tag->name;
- $g->tags_slugs[$tagkey] = 'gc-' . $tag->slug;
- }
- $g->custom = get_post_custom($g->postID);
- $gigs[$key] = $g;
- }
-
- foreach ( $performances as $p ) {
- $p->time_12h = dtcGigs::timeFormat($p->time, '12h');
- $p->time_24h = dtcGigs::timeFormat($p->time, '24h');
- $p->time = dtcGigs::timeFormat($p->time);
-
- if ( isset($gigs[$gig_ids[$p->gigID]]) ) {
- $gigs[$gig_ids[$p->gigID]]->performances[] = $p;
- }
- }
-
- if ( is_file(dirname(__FILE__) . '/templates/' . $options['template'] . '/' . $template . '.php') ) {
- include(dirname(__FILE__) . '/templates/' . $options['template'] . '/' . $template . '.php');
- } elseif ( is_file(ABSPATH . 'wp-content/gigs-templates/' . $options['template'] . '/' . $template . '.php') ) {
- include(ABSPATH . 'wp-content/gigs-templates/' . $options['template'] . '/' . $template . '.php');
- } else {
- include(dirname(__FILE__) . '/templates/' . 'basic/' . $template . '.php');
- }
- $result = ob_get_clean();
- if ( $return ) return $result;
- else echo $result;
- }
-
- function upcomingList($args = array()) {
- // This method has been depriciated. Stop using it!
- global $include_folder;
- $o = get_option('gigs-calendar');
- $defaults = array(
- "length" => 5,
- "dateFormat" => 'M j',
- 'dateFormatYear' => 'M j, Y',
- 'link' => array('city'),
- 'return' => false,
- );
-
-
- $args = array_merge($defaults, $args);
-
- include_once 'gigs-classes.php';
- $g = new gig();
- $g->search('`date` >= CURDATE()', '`date` ASC');
-
- $count = 0;
- if ( $g->_count ) :
-
- ?>
-
- fetch() ) :
- $v = $g->getVenue();
- $p = $g->getPerformances();
- $link = array();
- foreach ( $args['link'] as $f ) {
- switch ( $f ) {
- case 'city':
- $link[] = $v->getCity();
- break;
- case 'venue':
- $link[] = $v->name;
- break;
- case 'eventName':
- $link[] = $g->eventName;
- break;
- }
- }
- $link = array_unique($link);
- foreach ( $link as $key => $value ) {
- if ( empty($value) ) unset($link[$key]);
- }
- ?>
-
- - date))) ? $args['dateFormat'] : $args['dateFormatYear'], strtotime($g->date . ' ' . $p->time)) ?>:
-
-
- = $args['length'] ) break; endwhile; ?>
-
-
-
- get_var('SELECT COUNT(*) FROM ' . TABLE_GIGS . ' WHERE postID = ' . (int) $id ) ) {
- wp_publish_post($id);
- } else {
- _future_post_hook($id, $post);
- }
- }
- }
-
-
-
- add_action('init', array('dtc_gigs', 'setup_future_hook'));
- add_action('admin_menu', array('dtc_gigs', 'add_admin_page'));
-
- //add_filter('the_posts', array('dtc_gigs', 'test'));
-
- if ( 4.1 <= mysql_get_server_info() ) {
- add_filter('posts_where', array('dtc_gigs', 'hide_posts'));
- add_filter('get_next_post_where', array('dtc_gigs', 'post_nav'));
- add_filter('get_previous_post_where', array('dtc_gigs', 'post_nav'));
- add_filter('getarchives_where', array('dtc_gigs', 'hide_archives'));
- } else {
-
- }
-
- add_filter('the_content', array('dtc_gigs', 'display'));
-
- add_action('plugins_loaded', array('dtc_gigs', 'init'));
-
-
- if ( $_GET['page'] == 'gigs' ) :
- // If not WP > 2.6, we'll need to include some custom scripts.
- $folder = dtc_gigs::get_url();
- if ( (float) $wp_version < 2.6 ) {
- wp_deregister_script('jquery');
- wp_deregister_script('interface');
- wp_deregister_script('jquery-form');
- wp_enqueue_script('jquery', $folder . 'js/jquery.js', array(), '1.2.6');
- wp_enqueue_script('jquery-form', $folder . 'js/jquery.form.js', array(), '2.02');
- wp_enqueue_script('jquery-ui-core', $folder . 'js/ui.core.js', array(), '1.5');
- wp_enqueue_script('jquery-ui-sortable', $folder . 'js/ui.sortable.js', array(), '1.5');
- } else {
- wp_enqueue_script('jquery');
- wp_enqueue_script('jquery-form');
- wp_enqueue_script('jquery-ui-core');
- wp_enqueue_script('jquery-ui-sortable');
- }
- wp_enqueue_script('jquery-ui-datepicker', $folder . 'js/ui.datepicker.min.js', array(), '1.5');
- wp_enqueue_script('jquery-tooltip', $folder . 'js/jquery.tooltip.min.js', array(), '1.2');
-
- add_action('admin_head', array('dtc_gigs', 'admin_css'));
-
- if ( get_option('gig_db_version') != DTC_GIGS_DB_VERSION ) {
- dtc_gigs::upgrade();
- }
-
- endif;
-
- add_action('wp_head', array('dtc_gigs', 'display_css'));
-else:
- require_once $include_folder . '/ajaxSetup.php';
-endif;
-
-?>