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;