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']}");
}
