}
}
} 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";
