} } } else { if ('drive' == $api_request[0]) { $driveExtensionPath = '../../' . $site_folder_name . '-custom/extensions/google_drive_connector/index.php'; if (!file_exists($driveExtensionPath)) { http_response_code(405); } else { require_once $driveExtensionPath; $username = ""; if (isset($_SERVER['PHP_AUTH_USER'])) { $username = $_SERVER['PHP_AUTH_USER']; } $rest = new PikaDrive($username); if (!isset($api_request[1])) { if ($rest->check()) { echo "authorized"; } } else { switch ($api_request[1]) { case 'auth': if (isset($_GET['code'])) { $rest->setToken($_SESSION['username'], $_GET['code']); unset($_SESSION['username']); echo "<script>window.close();</script>"; } else { $_SESSION['username'] = get_value('username'); $rest->authenticate(); } break; case 'upload':
if ($sub_folder['title'] == $folder_name && $sub_folder['mimeType'] == 'application/vnd.google-apps.folder') { return $sub_folder['id']; } } // If the foreach() loop didn't return a value, that means the folder doesn't // exist and it needs to be created. $z = $drive->createFolder($folder_name, $parent_id); return $z['id']; } function print_diagnostic($x) { print_r($x); echo "\nError retrieving folder with doc_id of '{$x['folder_ptr']}'\n"; } $drive = new PikaDrive($pika_cms_username); if (!$drive->check()) { echo "{$pika_cms_username} is not logged in to google drive."; exit; } mysql_connect($plSettings['db_host'], $plSettings['db_user'], $plSettings['db_password']); mysql_select_db($plSettings['db_name']); /* add cases.google_drive_folder_id add doc_storage.google_drive_path ALTER TABLE doc_storage ADD COLUMN google_drive_path VARCHAR(255); */ /* create drive folder for all case_id's in SELECT case_id FROM doc_storage GROUP by case_id; Save the unique_id */ $sql = "SELECT case_id FROM doc_storage LEFT JOIN cases USING(case_id) " . "WHERE case_id IS NOT NULL AND google_drive_folder_id IS NULL GROUP BY case_id";