/**
* @param string $localPath
* @param string $filename
*
* @return string URL
*/
public function upload($localPath, $filename)
{
$size = @getimagesize($localPath);
if ($size) {
$extension = image_type_to_extension($size[2]);
} else {
$extension = strrchr($filename, '.');
}
$metadata = $this->client->uploadFile($this->prefix . hash_file('crc32b', $localPath) . $extension, Dropbox\WriteMode::add(), fopen($localPath, 'rb'), filesize($localPath));
if (is_array($metadata) && isset($metadata['path'])) {
//return $this->client->createShareableLink($metadata['path']);
$data = $this->client->createTemporaryDirectLink($metadata['path']);
if (is_array($data)) {
return $data[0];
}
}
return null;
}
public function actionGetdropboxlink($path)
{
$path = base64_decode($path);
$pathError = Dropbox\Path::findError($path);
if ($pathError !== null) {
throw new CHttpException(500, "Invalid <dropbox-path>: {$pathError}\n");
}
$client = new Dropbox\Client(Yii::app()->params['dropboxToken'], 'dropbox-client');
$link = $client->createTemporaryDirectLink($path);
echo CJSON::encode($link);
Yii::app()->end();
}
function loadTable()
{
$connect = mysql_connect("localhost", "root", "123");
mysql_select_db("POKS");
$mail = $_SESSION["user"];
$query_relult = mysql_query("select userId from User where email = '{$mail}'") or die("Не удалось провести запрос к базе данных function isExist");
$id_user = mysql_fetch_array($query_relult);
$id_user = $id_user[0];
$query_relult = mysql_query("select * from userStorrage where idUser = {$id_user}") or die("Не удалось провести запрос к базе данных -- loadTable()");
# Include the Dropbox SDK libraries
require_once './dropbox-sdk-php-1.1.5/lib/Dropbox/autoload.php';
//MODX_BASE_PATH.
//use \Dropbox as dbx;
$accessToken = "-QAlimGqvKAAAAAAAAAAjRWBUFnqWI0AuJV06CSJtnvDKFYMpujYYU2h4fN7-Hlv";
// Здесь ваш Access token
$dbxClient = new \Dropbox\Client($accessToken, "ITMO_POKS_FOLDER");
while ($mail_array = mysql_fetch_array($query_relult)) {
$img_link = $dbxClient->createTemporaryDirectLink("/" . $mail . "/" . $mail_array[5]);
$shared_link = $dbxClient->createShareableLink("/" . $mail . "/" . $mail_array[5]);
echo "<tr>";
echo "\n\t\t\t\t<td>\n\t\t\t\t\t<img class = 'well modal-image' src = '{$img_link['0']}' width = '100' height = '100'/>\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t\t<td>{$mail_array['2']}</td>\n\t\t\t\t<td>{$mail_array['3']}</td>\n\t\t\t\t<td>{$mail_array['4']}</td>\n\t\t\t\t<td>{$mail_array['5']}</td>";
echo "\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<a class='btn btn-success btn-block' href = 'removeImage.php?image_id={$mail_array['0']}&image_name={$mail_array['5']}'>\n\t\t\t\t\t\t\tRemove\n\t\t\t\t\t\t</a>\n\t\t\t\t\t</td>\n\t\t\t\t";
echo "\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<p><a href= {$shared_link}> Скачать файл</a> </p>\n\t\t\t\t\t</td>\n\t\t\t\t";
echo "</tr>";
}
mysql_close($connect);
}
