function dbLookupArray($query, $unsetkey = 0) { $res = dbwrite($query); $array = array(); while ($row = $res->fetch_assoc()) { $key = current($row); if ($unsetkey == 1) { array_shift($row); } $array[$key] = $row; } return $array; }
<?php require_once 'google-api-php-client/src/Google_Client.php'; require_once 'google-api-php-client/src/contrib/Google_CalendarService.php'; require './config.php'; include './requests.php'; dbwrite("delete from gigs"); dbwrite("delete from gigs_availability"); dbwrite("alter table gigs auto_increment =1"); foreach (fetch_gigs(0) as $gig) { $description = $gig['description']; $entries = explode("\n\n", $description); $details = array(); foreach ($entries as $entry) { $bits = explode(': ', $entry, 2); if ($bits[0] == 'TIME') { $times = explode(' - ', $bits[1]); $gig['start_time'] = $times[0]; $gig['end_time'] = $times[1]; } else { if ($bits[0] == 'EVENT TIME') { $times = explode(' - ', $bits[1]); $gig['start_time'] = trim($times[0]); $gig['end_time'] = trim($times[1]); } else { if ($bits[0] == 'BAND PLAY TIME') { $times = explode(' - ', $bits[1]); $gig['band_start'] = trim($times[0]); $gig['band_end'] = trim($times[1]); } else { if ($bits[0]) {
function deleteFromCalendar($gig, $calendartype = 'private') { global $calendars; extract($calendars[$calendartype]); if (!$gig[$id_field]) { return; } $cal = getGoogleClient(); $event = new Google_Event(); $cal->events->delete($calendar_id, $gig[$id_field]); dbwrite("update gigs set {$id_field} = '' where gig_id = {$gig['gig_id']}"); }