diff -r 000000000000 -r 03b0d1493584 web/wp-content/plugins/gigs-calendar/gigs-classes.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/web/wp-content/plugins/gigs-calendar/gigs-classes.php	Wed Dec 23 17:55:33 2009 +0000
@@ -0,0 +1,794 @@
+<?php
+global $wpdb;
+define('GIGS_DB_PREFIX', apply_filters('gigCal_db_prefix', $wpdb->prefix));
+define('TABLE_VENUES', GIGS_DB_PREFIX . 'gigs_venue');
+define('TABLE_GIGS', GIGS_DB_PREFIX . 'gigs_gig');
+define('TABLE_PERFORMANCES', GIGS_DB_PREFIX . 'gigs_performance');
+define('TABLE_TOURS', GIGS_DB_PREFIX . 'gigs_tour');
+
+class dtcGigs {
+	
+	function generateSlug($x) {
+		$x = strtolower($x);
+		$x = str_replace(' ', '-', $x);
+		$x = preg_replace('#[^a-z\-0-9]#', '', $x);
+		return $x;
+	}
+		
+	function escapeForInput($x) {
+		if ( '0000-00-00' == $x ) {
+			$x = '';
+		}
+		echo htmlspecialchars($x);
+	}
+	
+	function dateFormat($date, $type = 'short') {
+		if ( is_null($date) || $date == '0000-00-00' ) return null;
+		$options = get_option('gigs-calendar');
+		if ( isset($options['date'][$type]) ) {
+			return mysql2date($options['date'][$type], $date);
+		} else {
+			return mysql2date($type, $date);
+		}
+	}
+	
+	function selectFields($fields, $g) {
+		$options = get_option('gigs-calendar');
+		
+		$result = '';
+		foreach ( $options['gigs-table-show'] as $f ) {
+			if ( isset($fields[$f]) ) {
+				$tmp = $fields[$f];
+				if ( $f == 'venue' && $options['list-venue-link'] && !empty($g->venueLink) ) {
+					$tmp = preg_replace("~\{(.*?)\}~", '<a href="' . $g->venueLink . '">\1</a>', $tmp);
+				} elseif ( $f == $options['gig-link-field'] ) {
+					$tmp = preg_replace("~\{(.*?)\}~", '<a href="' . $g->permalink . '">\1</a>', $tmp);
+				} else {
+					$tmp = preg_replace("~\{(.*?)\}~", '\1', $tmp);
+				}
+					
+				$result .= $tmp;
+			}
+		}
+		
+		return $result;
+	}
+	
+	function timeFormat($time, $format = false) {
+		$options = get_option('gigs-calendar');
+		if ( is_null($time) ) {
+			return $options['tbd-text'];
+		}
+		if ( $options['time-12h'] || $format === "12h" ) {
+			return mysql2date("g:ia", '2008-01-01 ' . $time);
+		} else {
+			return mysql2date("H:i", '2000-01-01 ' . $time);
+		}
+	}
+
+	function mapLink($gig) {
+		global $options;
+		if ( empty($gig->customMap) ) {
+			$a = array();
+			
+			if ( empty($gig->address) ) 
+				$a[] = $gig->name . ' near:';
+			else {}
+				$a[] = str_replace("\n", ", ", $gig->address);
+			if ( !empty($gig->city) ) $a[] = $gig->city;
+			if ( !empty($gig->state) ) $a[] = $gig->state;
+			if ( !empty($gig->country) ) $a[] = $gig->country;
+			if ( !empty($gig->postalCode) ) $a[] = $gig->postalCode;
+			return 'http://maps.google.com/?q=' . urlencode(str_replace('near:,', 'near:', implode(', ', $a)));
+		} else {
+			if ( preg_match("/^https?:\/\//", $gig->customMap) ) {
+				return $gig->customMap;
+			} else {
+				return 'http://maps.google.com/?q=' . urlencode($gig->customMap);
+			}
+		}
+	}
+	
+	function getAttribution() {
+		$options = get_option('gigs-calendar');
+		?>
+			<div class="attribution">
+				<?php if ( $options['b4b-link'] ) : ?>
+					<span class="b4b">Powered by <a target="_blank" href="http://blogsforbands.com">Blogs for Bands</a></span>
+				<?php endif; ?>
+				<?php if ( $options['silk-link'] ) : ?>
+					<span class="silk">Silk icons by <a target="_blank" href="http://www.famfamfam.com/lab/icons/silk/">Mark James</a></span>
+				<?php endif; ?>
+			</div>
+		<?php
+	}
+	
+	function loadTemplate($file, $template = null, $data = array()) {
+		$options = get_option('gigs-calendar');
+		global $gcd;
+		if ( is_null($template) ) {
+			$template = $options['template'];
+		}
+		
+		$folder = dtc_gigs::get_url();
+		
+		extract($data);
+		if ( is_file(dirname(__FILE__) . '/templates/' . $template . '/' . $file . '.php') ) {
+			include(dirname(__FILE__) . '/templates/' . $template . '/' . $file . '.php');
+		} elseif ( is_file(ABSPATH . 'wp-content/gigs-templates/' . $template . '/' . $file . '.php') ) {
+			include(ABSPATH . 'wp-content/gigs-templates/' . $template . '/' . $file . '.php');
+		} else {
+			include(dirname(__FILE__) . '/templates/basic/' . $file . '.php');				
+		}
+	}
+	
+	function extraFields($fields, &$data, $gig = "new") {
+		foreach ( $fields as $key => $field ) {
+			if ( isset($data[$field['name']]) ) {
+				$value = array_pop($data[$field['name']]);
+				if ( empty($data[$field['name']]) ) unset($data[$field['name']]);
+			} else {
+				$value = $field['default'];
+			}
+			?>
+				<tr class="<?php echo addslashes($field['name']) ?>">
+					<td valign="top" class="<?php echo addslashes($field['name']) ?>">
+						<input type="hidden" value="<?php echo addslashes($field['name']) ?>" name="custom-key[<?php echo $key ?>]" />
+						<label for="custom-<?php echo $gig ?>-<?php echo $key ?>"><?php echo $field['label'] ?></label>
+						<textarea style="display:none;" rows="1" name="old-custom-value[<?php echo $key ?>]"><?php echo htmlspecialchars((is_array($value) ? serialize($value) : $value)) ?></textarea>
+						<input class="delete" type="hidden" name="deletecustom[<?php echo $key ?>]" value="0" />
+					</td>
+					<td>
+						<?php if ( $field['type'] == 'text' ) : ?>
+							<input name="custom-value[<?php echo $key ?>]" type="text" id="custom-<?php echo $gig ?>-<?php echo $key ?>" value="<?php echo addslashes($value); ?>" />
+						<?php elseif ( $field['type'] == 'date' ) : ?>
+							<input class="date-field" name="custom-value[<?php echo $key ?>]" type="text" id="custom-<?php echo $gig ?>-<?php echo $key ?>" value="<?php echo addslashes($value); ?>" />
+						<?php elseif ( $field['type'] == 'textarea' ) : ?>
+							<textarea rows="1" id="custom-<?php echo $gig ?>-<?php echo $key ?>" name="custom-value[<?php echo $key ?>]"><?php echo htmlspecialchars($value) ?></textarea>
+						<?php elseif ( $field['type'] == 'select' ) : ?>
+							<select id="custom-<?php echo $gig ?>-<?php echo $key ?>" name="custom-value[<?php echo $key ?>]">
+								<?php foreach ( $field['options'] as $oKey => $oValue ) : ?>
+									<option value="<?php echo addslashes($oKey) ?>"<?php if ( $oKey == $value ) echo ' selected="selected"' ?>><?php echo $oValue ?></option>
+								<?php endforeach; ?>
+							</select>
+						<?php elseif ( $field['type'] == 'radio' ) : ?>
+							<?php foreach ( $field['options'] as $oKey => $oValue ) : ?>
+								<input type="radio" id="custom-<?php echo $gig ?>-<?php echo $key ?>-<?php echo addslashes($oKey) ?>" name="custom-value[<?php echo $key ?>]" value="<?php echo addslashes($oKey) ?>" <?php if ( $value == $oKey ) echo 'checked="checked"' ?> /> 
+								<label for="custom-<?php echo $gig ?>-<?php echo $key ?>-<?php echo addslashes($oKey) ?>">
+									<?php echo $oValue ?>
+								</label>
+								<br />
+							<?php endforeach; ?>
+						<?php elseif ( $field['type'] == 'checkbox' ) : ?>
+							<?php $values = is_array($value) ? $value : unserialize($value); ?>
+							<?php foreach ( $field['options'] as $oKey => $oValue ) : ?>
+								<input type="checkbox" id="custom-<?php echo $gig ?>-<?php echo $key ?>-<?php echo addslashes($oKey) ?>" name="custom-value[<?php echo $key ?>][]" value="<?php echo addslashes($oKey) ?>" <?php if ( in_array($oKey, $values) ) echo 'checked="checked"' ?> /> 
+								<label for="custom-<?php echo $gig ?>-<?php echo $key ?>-<?php echo addslashes($oKey) ?>">
+									<?php echo $oValue ?>
+								</label>
+								<input type="hidden" name="custom-value[<?php echo $key ?>][]" value="" /> 
+								<br />
+							<?php endforeach; ?>
+						<?php endif; ?>
+					</td>
+				</tr>
+			<?php
+		}
+
+	}
+	
+	function get_gig_css_classes($gig) {
+		if ( is_object($gig) && isset($gig->id) ) {
+			$gig = $gig->id;
+		} elseif ( is_array($gig) && isset($gig['id']) ) {
+			$gig = $gig['id'];
+		}
+		
+		$g = new gig();
+		if ( !$g->get($gig) ) {
+			return false;
+		}
+		
+		$classes = array(
+			'gig',
+			mysql2date('\yY', $g->date),
+			mysql2date('\mm', $g->date),
+			( $g->date >= date('Y-m-d') ? 'upcoming' : 'archive' ),
+		);
+		
+		$classes = array_merge($classes, $g->getTags(true, 'gc-'));
+		
+		return implode(' ', apply_filters('gigCal_gigs_css_classes', $classes, $g));
+	}
+}
+
+class dtc_gigs_baseAR {
+	var $wpdb, $_rows, $_row, $_new = true, $_table, $_count;
+	
+	function dtc_gigs_baseAR($id = null){
+		global $wpdb;
+		$this->wpdb = $wpdb;
+		if ( $id !== null ) {
+			$this->get($id);
+		}
+	}
+	
+	function fetch() {
+		if ( count($this->_rows) ) {
+			$this->_row = each($this->_rows);
+			if ( $this->_row ) {
+				$this->load();
+				return true;
+			} else {
+				return false;
+			}
+		} else {
+			return false;
+		}
+	}
+
+	function generate_slug() {
+		if ( isset($this->slug) ) {
+			$first = true;
+			$name = $this->_name;
+			do {
+				if ( $first ) {
+					$this->slug = dtcGigs::generateSlug($this->$name);
+					$first = false;
+				} else {
+					ereg('[0-9]*$', $this->slug, $match);
+					$match = ((int) $match[0]) + 1;
+					if ( 1 == $match ) $match++;
+					$this->slug = preg_replace('/[0-9]*$/', '', $this->slug);
+					$this->slug .= $match;
+				}
+				
+			} while ( $this->wpdb->get_var('SELECT COUNT(*) FROM `' . $this->_table . '` WHERE slug = "' . $this->slug . '"') );
+		}
+	}
+
+	
+	function get($id) {
+		$this->search('`id` = ' . (int) $id);
+		return $this->fetch();
+	}
+	
+	function getRow() {
+		$row = array();
+		foreach ( $this->_fields as $f ) {
+			$row[$f]  = $this->$f;
+		}
+		return $row;
+	}
+	
+	function getTags($slugs = false, $prefix = '') {
+		if ( function_exists('wp_get_post_tags') ) {
+			$tags = wp_get_post_tags($this->postID);
+			foreach ( $tags as $key => $tag ) {
+				$tags[$key] = $prefix . ($slugs ? $tag->slug : $tag->name);
+			}
+			return $tags;
+		} else {
+			return array();
+		}
+	}
+	
+	function getCustom() {
+		if ( !empty($this->postID) ) {
+			return get_post_custom($this->postID);
+		}
+	}
+	
+	function setTags($tags) {
+		if ( function_exists('wp_set_post_tags') )
+			wp_set_post_tags($this->postID, $tags, false);
+	}
+	
+
+
+
+	
+	function load() {
+		foreach ( $this->_fields as $f ) {
+			if ( is_null($this->_row['value']->$f) ) {
+				$this->$f = null;
+			} else {
+				$this->$f = stripslashes($this->_row['value']->$f);
+			}
+		}
+	}
+	
+	function search($where = null, $order = null) {
+		$this->_new = false;
+		$this->_rows = $this->wpdb->get_results('SELECT * FROM `' . $this->_table . '` ' . ($where !== null ? 'WHERE ' . $where : '') . ($order !== null ? ' ORDER BY ' . $order : ''));
+		$this->_count = count($this->_rows);
+		return count($this->_rows);
+	}
+	
+	function save($get_after = true) {
+		$first = true;
+		$name = $this->_name;
+		$this->generate_slug();
+		if ( $this->_new ) {
+			$fields = $this->_fields;
+			$values = array();
+			unset($fields[0]);
+			
+			$this->pre_insert();
+
+			foreach ( $fields as $f ) {
+				if ( is_null($this->$f) ) {
+					$values[$f] = 'null';
+				} else {
+					$values[$f] = '"' . $this->wpdb->escape(stripslashes($this->$f)) . '"';
+				}
+			}
+			
+			if ( !$this->wpdb->query('INSERT INTO `' . $this->_table . '` (`' . implode('`, `', $fields) . '`) VALUES (' . implode(', ', $values) . ')') ) {
+				return false;
+			}
+			$this->id = $this->wpdb->insert_id;
+
+			$this->post_insert();
+			if ( $get_after ) 
+				$this->get((int) $this->id);
+
+			return true;
+		} else {
+			$fields = $this->_fields;
+			$values = array();
+			unset($fields[0]);
+			
+			$this->pre_update();
+			
+			foreach ( $fields as $f ) {
+				if ( is_null($this->$f) ) {
+					$values[$f] = '`' . $f . '` = null';
+				} else {
+					$values[$f] = '`' . $f . '` = "' . $this->wpdb->escape(stripslashes($this->$f)) . '"';
+				}
+			}
+			
+			$result = (bool) $this->wpdb->query('UPDATE `' . $this->_table . '` SET ' . implode(', ', $values) . ' WHERE `id` = ' . (int) $this->id);
+			
+			if ( $result ) $this->post_update();
+			
+			if ( $get_after ) 
+				$this->get((int) $this->id);
+			
+			return $result;
+		}
+	}
+	
+	function pre_insert(){}
+	function post_insert(){}
+	function pre_update(){}
+	function post_update(){}
+	function extraJSON() {return array();}
+	
+	function delete() {
+		if ( !empty($this->id) ) {
+			return (bool) $this->wpdb->query('DELETE FROM `' . $this->_table . '` WHERE `id` = ' . (int) $this->id);
+		}
+	}
+	
+	function toJSON($single = true) {
+		if ( $single ) {
+			$fields = array();
+			if ( function_exists("json_encode") ) {
+				foreach ( $this->_fields as $f ) {
+					$fields[$f] = $this->$f;
+				}
+				
+				$extra = $this->extraJSON();
+				$fields = array_merge($fields, $extra);
+				return json_encode($fields);
+			} else {
+				foreach ( $this->_fields as $f ) {
+					$fields[] = '"' . $f . '":"' . str_replace("\n", '\n', addslashes($this->$f)) . '"';
+				}
+			
+				$extra = $this->extraJSON();
+				$fields = array_merge($fields, $extra);
+
+				return '{' . implode(', ', $fields) . '}';
+			}
+		}
+	}
+	
+	function getError() {
+		return $this->wpdb->last_error;
+	}
+}
+
+class venue extends dtc_gigs_baseAR {
+	var $_table = TABLE_VENUES, $_name = 'name';
+	var $id, $name, $address, $city, $state, $country, $postalCode, $contact, 
+		$phone, $email, $link, $notes, $private = 0, $apiID = 0, $deleted = 0, $customMap;
+	var $_fields = array(
+		'id',
+		'name',
+		'address',
+		'city',
+		'state',
+		'country',
+		'postalCode',
+		'contact',
+		'phone',
+		'email',
+		'link',
+		'notes',
+		'private',
+		'apiID',
+		'deleted',
+		'customMap',
+	);
+	
+	function delete($forReal = false) {
+		if ( $forReal ) {
+			return parent::delete();
+		} else {
+			$this->deleted = 1;
+			return $this->save();
+
+		}
+	}
+	
+	function getAddress($oneLine = false) {
+		$a = array();
+		$city = "";
+		if ( $oneLine ) {
+			if ( !empty($this->address) ) $a[] = str_replace("\n", ', ', $this->address);
+			if ( !empty($this->city) ) $a[] = $this->city;
+			if ( !empty($this->state) ) $a[] = $this->state;
+			if ( !empty($this->postalCode) ) $a[] = $this->postalCode;
+			if ( !empty($this->country) ) $a[] = $this->country;
+			return implode(', ', $a);
+		} else {
+			if ( !empty($this->address) ) $a[] = $this->address;
+			if ( !empty($this->city) ) $temp .= $this->city;
+			if ( !empty($this->state) ) $temp .= (!empty($temp) ? ', ' : '' ) . $this->state;
+			if ( !empty($this->country) ) $temp .= (!empty($temp) ? ', ' : '' ) . $this->country;
+			if ( !empty($this->postalCode) ) $temp .= (!empty($temp) ? ' ' : '' ) . $this->postalCode;
+			if ( !empty($temp) ) $a[] = $temp;
+			return implode("\n", $a);
+		}
+	}
+	
+	function getCity() {
+		$c = array();
+		if ( !empty($this->city) ) $c[] = $this->city;
+		if ( !empty($this->state) ) $c[] = $this->state;
+		//if ( !empty($this->country) ) $c[] = $this->country;
+		return implode(', ', $c);
+	}
+	
+	function getMapLink() {
+		global $options;
+		if ( empty($this->customMap) ) {
+			$a = array();
+			
+			if ( empty($this->address) ) 
+				$a[] = $this->name . ' near:';
+			else {}
+				$a[] = str_replace("\n", ", ", $this->address);
+			if ( !empty($this->city) ) $a[] = $this->city;
+			if ( !empty($this->state) ) $a[] = $this->state;
+			if ( !empty($this->country) ) $a[] = $this->country;
+			if ( !empty($this->postalCode) ) $a[] = $this->postalCode;
+			return 'http://maps.google.com/?q=' . urlencode(str_replace('near:,', 'near:', implode(', ', $a)));
+		} else {
+			if ( preg_match("/^https?:\/\//", $this->customMap) ) {
+				return $this->customMap;
+			} else {
+				return 'http://maps.google.com/?q=' . urlencode($this->customMap);
+			}
+		}
+	}
+	
+	function extraJSON() {
+		if ( function_exists("json_encode") ) {
+			$fields['mapLink'] = $this->getMapLink();
+		} else {
+			$fields[] = '"mapLink":"' . str_replace("\n", '\n', addslashes($this->getMapLink())) . '"';
+		}
+		return $fields;
+	}
+}
+
+class gig extends dtc_gigs_baseAR {
+	var $_table = TABLE_GIGS, $_name = 'id';
+	var $id, $venueID = 0, $date, $notes, $postID = 0, $eventName, $tour_id = 0;
+	var $_fields = array(
+		'id',
+		'venueID',
+		'date',
+		'notes',
+		'postID',
+		'eventName',
+		'tour_id',
+	);
+
+	function delete() {
+		$p = $this->getPerformances();
+		while ( $p->fetch() ) {
+			$p->delete();
+		}
+		wp_delete_post($this->postID);
+		return parent::delete();
+	}
+	
+	function getByPostID($postID) {
+		$this->search("postID = " . (int) $postID);
+		return $this->fetch();
+	}
+	
+	function getPermalink() {
+		$post = get_permalink($this->postID);
+		return $post;
+	}
+	
+	function getPerformances() {
+		$p = new performance();
+		if ( $this->id ) {	
+			$p->search("`gigID` = " . (int) $this->id, "`time`");
+		}
+		return $p;
+	}
+	
+	function getVenue() {
+		$v = new venue();
+		if ( $this->venueID ) {
+			$v->get($this->venueID);
+		}
+		return $v;
+	}
+	
+	function pre_insert() {
+		global $options, $wpdb;
+		$user = wp_get_current_user();
+		$v = $this->getVenue();
+		$p = $this->getPerformances();
+		$p->fetch();
+		
+		if ( $this->tour_id == -1 ) $this->tour_id = null;
+		
+		$title = array();
+		foreach ( $options['gig-title-show'] as $f ) {
+			switch ( $f ) {
+				case 'city' :
+					$title[] = $v->getCity();
+					break;
+				case 'eventName' :
+					$title[] = $this->eventName;
+					break;
+				case 'venue' :
+					$title[] = $v->name;
+					break;
+				case 'date' :
+					$title[] = dtcGigs::dateFormat($this->date);
+					break;
+				case 'country' :
+					$title[] = $v->country;
+					break;
+			}
+		}
+		
+		foreach ( $title  as $key => $value ) {
+			if ( empty($value) ) unset($title[$key]);
+		}
+
+		$post_data = array(
+			'post_author'		=> $user->ID,
+			'post_title'		=> $wpdb->escape(implode(' - ', $title)),
+			'post_status'		=> 'publish',
+			'post_type' 		=> 'post',
+			'post_category'		=> array($options['category']),
+			'post_content' 		=> '',
+		);
+		
+		if ( $options['post-filtering'] ) {
+			$post_data = array_merge($post_data, array(
+				'post_date'			=> $wpdb->escape($this->date . ' ' . $p->time),
+				'post_modified'		=> $wpdb->escape($this->date . ' ' . $p->time),
+				'post_date_gmt'		=> date('Y-m-d H:i:s', strtotime($this->date . ' ' . $p->time) - (60 * 60 * get_option('gmt_offset'))),
+				'post_modified_gmt'	=> date('Y-m-d H:i:s', strtotime($this->date . ' ' . $p->time) - (60 * 60 * get_option('gmt_offset'))),
+			));
+		}
+		$id = wp_insert_post($post_data);
+		$this->postID = $id;
+	}
+	
+	function pre_update() {
+		global $options, $wpdb, $wp_version;
+		$v = $this->getVenue();
+		$p = $this->getPerformances();
+		$p->fetch();
+
+		if ( $this->tour_id == -1 ) $this->tour_id = null;
+		
+		$title = array();
+		foreach ( $options['gig-title-show'] as $f ) {
+			switch ( $f ) {
+				case 'city' :
+					$title[] = $v->getCity();
+					break;
+				case 'eventName' :
+					$title[] = $this->eventName;
+					break;
+				case 'venue' :
+					$title[] = $v->name;
+					break;
+				case 'date' :
+					$title[] = dtcGigs::dateFormat($this->date);
+					break;
+				case 'country' :
+					$title[] = $v->country;
+					break;
+			}
+		}
+		
+		foreach ( $title  as $key => $value ) {
+			if ( empty($value) ) unset($title[$key]);
+		}
+
+		
+		$post = get_post($this->postID);
+		
+		if ( $options['post-filtering'] ) {
+			$post->post_date = $wpdb->escape($this->date . ' ' . $p->time);
+			$post->post_modified = $wpdb->escape($this->date . ' ' . $p->time);
+			$post->post_date_gmt = date('Y-m-d H:i:s', strtotime($this->date . ' ' . $p->time) - (60 * 60 * get_option('gmt_offset')));
+			$post->post_modified_gmt = date('Y-m-d H:i:s', strtotime($this->date . ' ' . $p->time) - (60 * 60 * get_option('gmt_offset')));
+		}
+
+		$post->post_title = $wpdb->escape(implode(' - ', $title));
+		$post->post_name = "";
+		$post->post_status = "publish"; // Do this to trick WordPress into resetting the GUID.
+		$post->post_category = array($options['category']);
+
+		wp_update_post($post);
+		if ( (float) $wp_version < 2.3 ) {  // Hack to make it compatible with WP 2.2
+			global $wpdb; 
+			$wpdb->query('UPDATE ' . $wpdb->prefix . 'posts SET post_status = "publish" WHERE ID = ' . (int) $this->postID);
+		}
+	}
+	
+	function post_insert() {
+		global $wp_version;
+		if ( (float) $wp_version < 2.3 ) {  // Hack to make it compatible with WP 2.2
+			global $wpdb; 
+			$wpdb->query('UPDATE ' . $wpdb->prefix . 'posts SET post_status = "publish" WHERE ID = ' . (int) $this->postID);
+		} else {
+			$post = get_post($this->postID);
+			$post->post_status = "publish";
+			wp_update_post($post);
+		}
+	}
+
+	function extraJSON() {
+		$post = get_post($this->postID);
+		$v = $this->getVenue();
+		$p = $this->getPerformances();
+		if ( function_exists("json_encode") ) {
+			$fields['permalink'] = $this->getPermalink();
+			$fields['venue'] = $v->getRow();
+			while ( $p->fetch() ) {
+				$fields['performances'][] = $p->getRow();
+			}
+		} else {
+			$fields[] = '"permalink":"' . str_replace("\n", '\n', addslashes($this->getPermalink())) . '"';
+			$ps = array();
+			$fields[] = '"venue":' . $v->toJSON();
+			while ( $p && $p->fetch() ) {
+				$ps[] = $p->toJSON();
+			}
+			$fields[] = '"performances":[' . implode(', ', $ps) . ']';
+		}
+		return $fields;
+	}
+}
+
+class performance extends dtc_gigs_baseAR {
+	var $_table = TABLE_PERFORMANCES, $_name = 'id';
+	var $id, $gigID = 0, $time = '20:00', $link, $shortNotes, $ages;
+
+	var $_fields = array(
+		'id',
+		'gigID',
+		'time',
+		'link',
+		'shortNotes',
+		'ages',
+	);
+}
+
+class tour extends dtc_gigs_baseAR {
+	var $_table = TABLE_TOURS, $_name = 'id';
+	var $id, $name, $notes, $pos = 0;
+	var $_fields = array(
+		'id',
+		'name',
+		'notes',
+		'pos',
+	);
+	
+	function post_insert() {
+		$max = $this->wpdb->get_var('SELECT MAX(`pos`) FROM `' . $this->_table . '`') + 1;
+		$this->wpdb->query('UPDATE `' . $this->_table . '` SET `pos` = ' . $max . ' WHERE `id` = ' . (int) $this->id);
+	}
+	
+	function delete() {
+		$g = $this->getGigs();
+		while ( $g->fetch() ) {
+			$g->tour_id = null;
+			$g->save();
+		}
+		return parent::delete();
+	}
+	
+	function sortTours($type = null) {
+		$options = get_option('gigs-calendar');
+		$type = is_null($type) ? $options['tours-sort'] : $type;
+		switch ($type) {
+			case 'date' :
+				return $this->wpdb->get_col('
+					SELECT DISTINCT
+						t.id
+					FROM
+						' . TABLE_TOURS . ' t  
+					LEFT JOIN
+						' . TABLE_GIGS . ' g 
+					ON 
+						t.`id` = g.`tour_id`
+					WHERE
+						`date` is null OR `date` >= CURDATE()
+					ORDER BY 
+						g.`date`, `name`
+				');
+				break;
+			case 'alpha' :
+				return $this->wpdb->get_col('
+					SELECT DISTINCT
+						t.id
+					FROM
+						' . TABLE_TOURS . ' t  
+					ORDER BY 
+						`name`
+				');
+				break;
+		}
+	}
+	
+	function getGigs($slice = 'all') {
+		$g = new gig();
+		if ( $slice == 'past' ) {
+			$g->search('`date` <= CURDATE() AND `tour_id` = ' . (int) $this->id, '`date`');
+		} elseif ( $slice == 'future' ) {
+			$g->search('`date` >= CURDATE() AND `tour_id` = ' . (int) $this->id, '`date`');
+		} else {
+			$g->search('`tour_id` = ' . (int) $this->id, '`date`');
+		}
+		return $g;
+	}
+	
+	function extraJSON(){
+		$fields = array();
+		$g = $this->getGigs();
+		$gs = array();
+		if ( function_exists("json_encode") ) {
+			while ( $g->fetch() ) {
+				$gs[] = $g->getRow();
+			}
+			$fields['gigs'] = $gs;
+		} else {
+			while ( $g->fetch() ) {
+				$gs[] = $g->toJSON();
+			}
+			$fields[] = '"gigs":[' . implode(',', $gs) . ']';
+		}
+		return $fields;
+	}
+}
+
+?>