// Add a "Log out of Google Drive" button. $C .= '<a class="btn" title="Disconnect your Pika CMS account from Google Drive." href="' . $base_url . '/pm.php/google_drive_connector/auth.php?action=unauthorize&username='******'username']); $C .= '" target="_blank">Disconnect Drive</a>'; /* TODO: Use this button once Pika CMS is using a version of Bootstrap that includes Font Awesome <i class="icon-signout"></i> */ $C .= ' </div> </div> </form>'; } else { $clean_username = htmlspecialchars($auth_row['username']); $C .= '<p>To upload and view case-related files, you need to connect your Pika CMS account to your Google account. To do so, <a class=""'; $C .= ' onClick=\'window.open("' . $base_url . '/pm.php/google_drive_connector/auth.php?action=authenticate", "Request for Authorization", "width=450, height=500, scrollbars=yes");\''; $C .= '><strong>click here to log into Google Drive</strong></a>.</p>'; $C .= '<p><em>Please reload or refresh this page once you have logged in</em>.</p>'; } // End Drive Upload Form require_once getcwd() . '-custom/extensions/google_drive_connector/file_list.php'; $a['file_list'] = file_list($case1->google_drive_folder_id, null, $case1->google_drive_folder_id); $template = new pikaTempLib('subtemplates/case-drive.html', $a); $C .= $template->draw(); // Handle Drive uploads // TODO Move this elsewhere if (array_key_exists('file_upload', $_FILES)) { $rest = new PikaDrive($auth_row['username']); $y = $rest->uploadFile($_FILES['file_upload']['tmp_name'], $_FILES['file_upload']['name'], htmlspecialchars($_POST['folder_id'])); // $_POST['title'], $_POST['folder_id']) } }
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': echo json_encode($rest->uploadFile($_FILES['upfile']['tmp_name'], $_POST['file_name'], $_POST['folder_id'])); break; case 'new_folder': echo json_encode($rest->createFolder($_POST['folder_name'])); break; case 'unauthorize': $rest->unauthorize(htmlspecialchars($_GET['username'])); break; default: break; } } } } else { http_response_code(400); // BAD REQUEST
$result = mysql_query($sql); if (mysql_num_rows($result) == 0) { echo "No more documents found in {$plSettings['db_name']}.\n"; break; } $row = mysql_fetch_assoc($result); if ($row['folder_ptr'] > 0) { $sql0 = "SELECT google_drive_path FROM doc_storage WHERE doc_id = '{$row['folder_ptr']}'"; $result0 = mysql_query($sql0) or print_diagnostic($row); $row0 = mysql_fetch_assoc($result0); $x = $row0['google_drive_path']; } else { $x = $row['google_drive_folder_id']; } file_put_contents("/tmp/{$row['doc_name']}", gzuncompress(stripslashes($row['doc_data']))); $upload_results = $drive->uploadFile("/tmp/{$row['doc_name']}", $row['doc_name'], $x); unlink("/tmp/{$row['doc_name']}"); if (array_key_exists('kind', $upload_results) && $upload_results['kind'] == 'drive#file') { $sql1 = "DELETE FROM doc_storage WHERE doc_id = '{$row['doc_id']}'"; $result1 = mysql_query($sql1) or die('DELETE Query failed: ' . mysql_error()); echo "Moved " . $row['doc_id'] . " to Google Drive.\n"; } else { echo "Upload of doc_id {$row['doc_id']} failed.\n"; print_r($upload_results); exit; } } $sql = "SELECT COUNT(*) AS a FROM doc_storage WHERE doc_type='C' AND case_id IS NOT NULL"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); if ($row['a'] == 0) {