public function actionGetadminVideodetail() { //print_r($_REQUEST);exit; // echo 'HEllo '; $userid = Yii::app()->session['login']['id']; $groupid = $_REQUEST['groupid']; $videoid = ""; $results = ""; $videoembcode = ""; $srctype = ""; $video = Uploaddetails::model()->findByAttributes(array('upload_sourcetype' => 64, 'upload_sourceid' => $groupid)); if ($video) { // echo 'updating';exit; //print_r($_POST);exit; $video->video_embedurl = ''; $video->upload_sourcetype = 64; //Admin Video if (isset($_REQUEST["videoid"])) { $videoid = $_REQUEST["videoid"]; $vidler = Yii::app()->getComponents(false); $user = $vidler['vidler']['user']; $pass = $vidler['vidler']['pwd']; $api_key = $vidler['vidler']['appkey']; $callback_url = '/'; $v = new Viddler_V2($api_key); $auth = $v->viddler_users_auth(array('user' => $user, 'password' => $pass)); $sessionid = $auth['auth']['sessionid']; $results = $v->viddler_videos_getDetails(array('sessionid' => $sessionid, 'video_id' => $videoid)); //print_r($results); $description = $results['video']['description']; if (trim($description) == '') { $video->uploadtype = 35; } else { $video->uploadtype = 62; $video->upload_text = $results['video']['description']; } } else { $videoid = ''; $videoembcodeURL = $_REQUEST['emburl']; $videodesc = $_REQUEST['embdescr']; $srctype = $_REQUEST['sourcetype']; $yt_vid = $this->extractUTubeVidId($videoembcodeURL); $videoembcode = $this->generateYoutubeEmbedCode($yt_vid, 230, 230); $videoembImgUrl = "http://img.youtube.com/vi/" . $yt_vid . "/mqdefault.jpg"; if (!empty($_REQUEST['journaltxt'])) { $video->uploadtype = 62; $video->upload_text = $_REQUEST['journaltxt']; } else { $video->uploadtype = 35; } } $video->videoid = $videoid; $video->videostatus = "ready"; $video->video_img = isset($results['video']['thumbnail_url']) ? $results['video']['thumbnail_url'] : $videoembImgUrl; $video->video_caption = isset($results['video']['title']) ? $results['video']['title'] : $videodesc; $video->video_embedurl = $videoembcode; if ($video->save(false)) { if (isset($_REQUEST["videoid"])) { if (isset($_REQUEST["groupid"]) && !empty($_REQUEST["groupid"])) { $this->redirect(Yii::app()->createUrl('group/dashboard', array('groupid' => $_REQUEST['groupid']))); } } else { echo $_REQUEST['groupid']; } } } else { //echo 'New';exit; $model = new Uploaddetails(); //Type should be here... $model->upload_sourcetype = 64; //Admin Video if (isset($_REQUEST["videoid"])) { $videoid = $_REQUEST["videoid"]; $vidler = Yii::app()->getComponents(false); $user = $vidler['vidler']['user']; $pass = $vidler['vidler']['pwd']; $api_key = $vidler['vidler']['appkey']; $callback_url = '/'; $v = new Viddler_V2($api_key); $auth = $v->viddler_users_auth(array('user' => $user, 'password' => $pass)); $sessionid = $auth['auth']['sessionid']; $results = $v->viddler_videos_getDetails(array('sessionid' => $sessionid, 'video_id' => $videoid)); print_r($results); $description = $results['video']['description']; if (trim($description) == '') { $model->uploadtype = 35; } else { $model->uploadtype = 62; $model->upload_text = $results['video']['description']; } } else { $videoembcodeURL = $_REQUEST['emburl']; $videodesc = $_REQUEST['embdescr']; $srctype = $_REQUEST['sourcetype']; $yt_vid = $this->extractUTubeVidId($videoembcodeURL); $videoembcode = $this->generateYoutubeEmbedCode($yt_vid, 230, 230); $videoembImgUrl = "http://img.youtube.com/vi/" . $yt_vid . "/mqdefault.jpg"; if (!empty($_REQUEST['journaltxt'])) { $model->uploadtype = 62; $model->upload_text = $_REQUEST['journaltxt']; } else { $model->uploadtype = 35; } } //Group id should be here... $model->upload_sourceid = $groupid; $model->uploadedby = $userid; $model->uploadeddate = new CDbExpression('NOW()'); $model->status = 1; $userid = Yii::app()->session['login']['id']; $model->updatedby = $userid; $model->updateddate = new CDbExpression('NOW()'); $model->videoid = $videoid; $model->videostatus = "ready"; $model->video_img = isset($results['video']['thumbnail_url']) ? $results['video']['thumbnail_url'] : $videoembImgUrl; $model->video_caption = isset($results['video']['title']) ? $results['video']['title'] : $videodesc; $model->video_embedurl = $videoembcode; if ($model->save(false)) { if (isset($_REQUEST["videoid"])) { if (isset($_REQUEST["groupid"]) && !empty($_REQUEST["groupid"])) { $this->redirect(Yii::app()->createUrl('group/dashboard', array('groupid' => $_REQUEST['groupid']))); } } else { echo $_REQUEST['groupid']; } } } }
public function actionCheckVideoStatus() { //print_r($_POST); /*SELECT * FROM `fn_uploaddetails` WHERE `upload_sourceid` = 1748 and `uploadedby` = 20 and `videoid` !='' and status = 1 and videostatus != 'ready'*/ $ids = array(); $Criteria = new CDbCriteria(); $Criteria->condition = "`upload_sourceid` = " . $_POST['finaoid'] . " and `uploadedby` = " . $_POST['userid'] . " and `videoid` !='' and status = 1 and videostatus != 'ready'"; $uploadids = Uploaddetails::model()->findAll($Criteria); foreach ($uploadids as $finaoids) { $ids[] = $finaoids->uploaddetail_id . '-' . $finaoids->upload_sourceid; } foreach ($ids as $updet) { //echo $updet; $datastring = $updet; $item = explode(" ", $datastring); $item[0]; // uploadid $item[1]; // uploadsourceid or finaoid $updetupload = new Uploaddetails(); $updetupload = Uploaddetails::model()->findByAttributes(array('uploaddetail_id' => $item[0])); if (!empty($updetupload)) { if ($updetupload->videostatus != 'ready') { //echo $updetupload->videostatus; $vidler = Yii::app()->getComponents(false); $user = $vidler['vidler']['user']; $pass = $vidler['vidler']['pwd']; $api_key = $vidler['vidler']['appkey']; $v = new Viddler_V2($api_key); $auth = $v->viddler_users_auth(array('user' => $user, 'password' => $pass)); $sessionid = $auth['auth']['sessionid']; $results = $v->viddler_videos_getDetails(array('sessionid' => $sessionid, 'video_id' => $updetupload->videoid)); $i = 0; if ($results['video']['status'] == 'ready') { //echo 'video'.$results['video']['status']; $i++; $updetupload->videostatus = $results['video']['status']; if ($updetupload->save(false)) { echo 1; //succes } else { echo 0; //fail } } //echo $i.'updated'; } } } }
function uploaddata($type, $sourcetype, $finaoid, $userid, $uploadtext, $data, $captiondata) { $target_path = $globalpath . "images/uploads/finaoimages/"; $target_thumb = $globalpath . "images/uploads/finaoimages/thumb/"; $target_medium = $globalpath . "images/uploads/finaoimages/medium/"; $upload_path = "/images/uploads/finaoimages"; $query = "insert into fn_uploaddetails (`uploadtype`,`upload_text`,`upload_sourcetype`, `upload_sourceid`, `uploadedby`, `uploadeddate`, `status`) values ('{$type}','{$uploadtext}','{$sourcetype}','{$finaoid}','{$userid}',now(),1)"; mysql_query($query); $uploadid = mysql_insert_id(); if (!empty($data)) { if ($data['image1']['name'] != '') { $sno = 0; foreach ($data as $key => $val) { $name = $val['name']; $uploadfile_name = $finaoid . "-" . $name; $tmpname = $val['tmp_name']; $target_main = $target_path . $uploadfile_name; $target_thumb = $target_thumb . $uploadfile_name; $target_medium = $target_medium . $uploadfile_name; @move_uploaded_file($tmpname, $target_main); $resize = new ResizeImage($target_main); $resize->resizeTo(100, 100, 'default'); $resize->saveImage($target_thumb); $resize_m = new ResizeImage($target_main); $resize_m->resizeTo(240, 240, 'default'); $resize_m->saveImage($target_medium); $query = "insert into fn_images (`upload_id`,`uploadfile_name`,`uploadfile_path`, `caption`, `uploadedby`, `uploadeddate`, `status`) values ('{$uploadid}','{$uploadfile_name}','{$upload_path}','{$captiondata[$sno]}','{$userid}',now(),1)"; mysql_query($query); $sno++; } } else { $target_path = $target_path . $finaoid . "-" . basename($data['video']['name']); @move_uploaded_file($data['video']['tmp_name'], $target_path); set_time_limit(0); include 'phpviddler.php'; $v = new Viddler_V2('145i86zgnzi1h1xln0ly'); $auth = $v->viddler_users_auth(array('user' => ' finaonation', 'password' => 'Finao123')); $session_id = isset($auth['auth']['sessionid']) ? $auth['auth']['sessionid'] : NULL; $response = $v->viddler_videos_prepareUpload(array('sessionid' => $session_id)); $endpoint = isset($response['upload']['endpoint']) ? $response['upload']['endpoint'] : NULL; $token = isset($response['upload']['token']) ? $response['upload']['token'] : NULL; $query = array('uploadtoken' => $token, 'title' => 'Video from iphone App', 'description' => 'Video from iphone App', 'tags' => 'testing,upload', 'file' => '@../../preprod/images/uploads/finaoimages/' . $finaoid . "-" . basename($data['video']['name'])); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $endpoint); curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, TRUE); curl_setopt($ch, CURLOPT_HEADER, TRUE); curl_setopt($ch, CURLOPT_NOBODY, FALSE); curl_setopt($ch, CURLOPT_TIMEOUT, 0); curl_setopt($ch, CURLOPT_POST, TRUE); curl_setopt($ch, CURLOPT_POSTFIELDS, $query); $response = curl_exec($ch); $info = curl_getinfo($ch); $header_size = $info['header_size']; $header = substr($response, 0, $header_size); $video = unserialize(substr($response, $header_size)); curl_close($ch); @unlink('../../preprod/images/uploads/finaoimages/' . $finaoid . "-" . basename($data['video']['name'])); $videoid = $video['video']['id']; $results = $v->viddler_videos_getDetails(array('sessionid' => $session_id, 'video_id' => $videoid)); $videostatus = $results['video']['status']; $video_img = $results['video']['thumbnail_url']; $query = "insert into fn_videos (`upload_id`,`videoid`,`videostatus`, `video_img`, `caption`, `uploadedby`, `uploadeddate`, `status`) values ('{$uploadid}','{$videoid}','{$videostatus}','{$video_img}','{$captiondata['0']}','{$userid}',now(),1)"; mysql_query($query); } } // updating the current date time in fn_user_finao $sqlUpdate = "update fn_user_finao set updateddate=NOW(),updatedby=" . $userid . " where user_finao_id=" . $finaoid; mysql_query($sqlUpdate); // end of fn_user_finao update }