function get_og_image($remote_source_root)
{
global $serverUploadDir;
global $accountSn;
if (@file($remote_source_root)) {
$image = file_get_contents($remote_source_root);
$parts = basename($remote_source_root);
$serverFileName = GtTime_GetGmtDateTimeMicro() . "-" . $accountSn . ".enc";
$encType = 0;
$encKey = hash("sha256", rand() . rand() . rand() . rand(), true);
$encKeySql = mysql_real_escape_string($encKey);
$fileNames = explode(".", $parts);
$fileExtension = $fileNames[count($fileNames) - 1];
if (strcmp("png", strtolower($fileExtension)) == 0) {
$nameExt = "png";
} else {
if (strcmp("jpg", strtolower($fileExtension)) == 0) {
$nameExt = "jpg";
} else {
if (strcmp("jpeg", strtolower($fileExtension)) == 0) {
$nameExtameExt = "jpeg";
} else {
if (strcmp("gif", strtolower($fileExtension)) == 0) {
$nameExt = "gif";
} else {
if (strcmp("mp4", strtolower($fileExtension)) == 0) {
$nameExt = "mp4";
} else {
$nameExt = $fileExtension;
}
}
}
}
}
//echo 'thumb/'.$parts."\n";
//copy($remote_source_root, 'thumb/'.$parts."\n");
//sql
//
//Find Sn image
$sqlFile = "SELECT sn, encName, type FROM file WHERE forumSn = '{$sn}'";
$resultFile = mysql_query($sqlFile, $dbLink);
$rowFile = mysql_fetch_array($resultFile);
$fileSn = $rowFile[sn];
$fileEncName = $rowFile[encName];
//insert new image
if ($row == FALSE) {
//insert new image to file table
$sql = "INSERT INTO file SET type = '4', name = '" . mysql_real_escape_string($parts) . "', nameExt = '{$nameExt}', forumSn = '{$sn}', rank = '0', createTimeSec = '{$timeSec}', createAccountSn = '{$accountSn}', encType = '{$encType}', encKey = '{$encKey}', encName = '{$serverFileName}', status = '1', width = '{$imageSrcWidth}', height = '{$imageSrcHeight}'";
//insert new image to uploader
if (!stripos($remote_source_root, "leaderg")) {
/*
if(stripos ($parts, "?")){
$parts_unit=explode("?", $serverFileName);
file_put_contents($serverUploadDir.'/'.$parts_unit[0], $image);
}
else
*/
file_put_contents($serverUploadDir . '/' . $serverFileName, $image);
}
//insert new image to file table
} else {
}
}
}
//echo "account=".$accountSn.", timesec=".$timeSec."\n";
//global
global $serverUploadDir;
global $sn;
global $accountSn;
global $serverTimeZone;
global $dbLink;
//Test
//$remote_source_root = "http://tw-leaderg.leadergstaging.com/forum/thumb/8680443-3426524.jpg";
//$remote_source_root = "http://s2.imgs.cc/img/bs29zpq.jpg";
//$remote_source_root = "http://t0.thumb.ckcdn.com/22/52/2982252_f.jpg";
//$remote_source_root = "http://udn.com/NEWS/MEDIA/8682091-3427396.jpg";
if (@file($remote_source_root)) {
$image = file_get_contents($remote_source_root);
$parts = basename($remote_source_root);
$serverFileName = GtTime_GetGmtDateTimeMicro() . "-" . $accountSn . ".enc";
$encType = 0;
$encKey = hash("sha256", rand() . rand() . rand() . rand(), true);
$encKeySql = mysql_real_escape_string($encKey);
$imageSrc = getimagesize($remote_source_root);
//print_r($imageSrc);
$imageSrcWidth = $imageSrc[0];
$imageSrcHeight = $imageSrc[1];
$fileNames = explode("/", $imageSrc["mime"]);
$nameExt = $fileNames[1];
//find forum sn by image link
$sql = "SELECT sn FROM forum WHERE imageUrl = '{$remote_source_root}' ORDER BY 'createTimeSec' desc";
$resultFile = mysql_query($sql, $dbLink);
$rowFile = mysql_fetch_array($resultFile);
$forumSn = $rowFile[sn];
//echo "dblink=".$dblink;
