$userid = $_REQUEST['userid']; $actual_user_id = $_REQUEST['actual_user_id']; $totalfollowers = 0; $rows['totalfollowers'] = fngetTotalFollowers($userid); $totaltiles = 0; $rows['totaltiles'] = fngetTotalTiles_counts($userid, $actual_user_id); $totaltiles = 0; $sqlTilesCount = "SELECT user_tileid FROM `fn_user_finao_tile` ft JOIN fn_user_finao fu ON fu.`user_finao_id` = ft.`finao_id` WHERE ft.userid ='" . $userid . "' AND Iscompleted =0 AND finao_activestatus !=2 GROUP BY tile_id"; // $sqlTilesCountRes = mysql_query($sqlTilesCount); $rows['totaltiles'] = mysql_num_rows($sqlTilesCountRes); $rows['totaltiles'] = fngetTotalTiles_counts($userid, $actual_user_id); $totalfinaos = 0; $rows['totalfinaos'] = fngetTotalFinaos($userid, $actual_user_id); $totalfollowings = 0; $rows['totalfollowings'] = fngetTotalFollowings($userid); $json = array(); $json['res'] = $rows; echo json_encode($json); } else { if ($_REQUEST['json'] == 'homepage_user') { $userid = $_REQUEST['userid']; $data = getHomePageDetailsByUser($userid); echo $data; } else { if ($_REQUEST['json'] == 'finao_list') { $myid = $_REQUEST['userid']; $type = $_REQUEST['type']; $otherid = 0; if ($type == 1) { $otherid = $_REQUEST['otherid'];
function homepage_user($userid) { if (!empty($userid)) { 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; $data = array(); $query = "SELECT notification.trackingnotification_id,\n\t\tnotification.tile_id,\n\t\tnotification.finao_id,\n\t\tnotification.notification_action,\n\t\tnotification.updateby,\n\t\tfinao.updateddate,\n\t\tfinao.finao_msg,\n\t\tfinao.finao_status,\n\t\tlookup.lookup_name,\n\t\tprofile.profile_image,\n\t\tprofile.mystory,\n\t\tusr.fname,\n\t\tusr.lname,\n\t\tupload.uploaddetail_id,\n\t\tupload.uploadtype,\n\t\tupload.upload_text,\n\t\tupload.updateddate\n\t\tFROM `fn_trackingnotifications` AS notification\n\t\tINNER JOIN fn_user_finao AS finao ON finao.user_finao_id=notification.finao_id\n\t\tINNER JOIN fn_lookups AS lookup ON lookup.lookup_id= notification.notification_action\n\t\tINNER JOIN fn_user_profile AS profile\n\t\tINNER JOIN fn_users AS usr ON usr.userid= profile.user_id AND usr.userid= notification.updateby\n\t\tINNER JOIN fn_uploaddetails AS upload ON upload.upload_sourceid= notification.finao_id\n\t\tLEFT OUTER JOIN inappropriatepost inapp ON inapp.userpostid = upload.uploaddetail_id\n\t\tWHERE notification.tracker_userid = '{$userid}' AND\n\t\tnotification.notification_action IN ('51','52','53','54','55','56') AND\n\t\tinapp.userpostid IS NULL\n\t\tGROUP BY notification.finao_id\n\t\tORDER BY notification.updateddate DESC LIMIT 0 , 30"; $exe = mysql_query($query); if (mysql_num_rows($exe) > 0) { while ($obj = mysql_fetch_object($exe)) { $videoimg = ""; $videourl = ""; $videoid = 0; if ($obj->uploadtype == '34' || $obj->uploadtype == '62') { if ($obj->uploadtype == '34') { $videoid = 1; } $query1 = mysql_query("select uploadfile_name, uploadfile_path, caption, updateddate from fn_uploaddetails where uploaddetail_id='{$obj->uploaddetail_id}'"); $sno = 0; if (mysql_num_rows($query1) > 0) { while ($obj1 = mysql_fetch_object($query1)) { $imgarr[$sno]['image_url'] = $obj1->uploadfile_name; if (!empty($obj1->caption)) { $imgarr[$sno]['image_caption'] = $obj1->caption; } else { $imgarr[$sno]['image_caption'] = ""; } $sno++; } } else { $imgarr = array(); } } else { if ($obj->uploadtype == '35' || $obj->uploadtype == '62') { if ($obj->uploadtype == '35') { $videoid = 2; } $query1 = mysql_query("select videoid, caption, video_img, video_embedurl from fn_uploaddetails where uploaddetail_id='{$obj->uploaddetail_id}'"); $obj1 = mysql_fetch_object($query1); if (empty($obj1->videoid) && empty($obj1->video_embedurl)) { $videoid = 0; $videourl = ""; $videoimg = ""; if (!empty($obj1->caption)) { $caption = $obj1->caption; } } $videoimg = ""; if (!empty($obj1->videoid)) { $results = $v->viddler_videos_getDetails(array('sessionid' => $session_id, 'video_id' => $obj1->videoid)); $videourl = $results['video']['files'][1]['html5_video_source']; if (!empty($obj1->video_img)) { $videoimg = $obj1->video_img; } $caption = $obj1->caption; } else { if (!empty($obj1->video_embedurl)) { $videocode = str_replace("/default.jpg", "", $obj1->video_img); $videocode = str_replace("http://img.youtube.com/vi/", "", $videocode); $videourl = "http://www.youtube.com/embed/" . $videocode; if (!empty($obj1->video_img)) { $videoimg = $obj1->video_img; } $caption = $obj1->caption; } } } } $data['tile_id'] = $obj->tile_id; $data['finao_id'] = $obj->finao_id; $data['notification_status'] = $obj->lookup_name; $data['updateby'] = $obj->updateby; $data['finao_msg'] = $obj->finao_msg; $data['finao_status'] = $obj->finao_status; $data['profile_image'] = $obj->profile_image; $data['profilename'] = $obj->fname . " " . $obj->lname; $data['story'] = $obj->mystory; $data['uploaddetail_id'] = $obj->uploaddetail_id; $data['type'] = $videoid; $data['videoimg'] = $videoimg; $data['videourl'] = $videourl; if ($caption != NULL) { $data['caption'] = $caption; } else { $data['caption'] = ""; } $data['image_urls'] = $imgarr; if (!empty($obj->upload_text)) { $data['upload_text'] = $obj->upload_text; } else { $data['upload_text'] = ""; } $data['updateddate'] = date("d M y", strtotime($obj->uploadeddate)); // getting count for a user $totalfollowers = 0; $totalfollowers = fngetTotalFollowers($obj->updateby); $totaltiles = 0; $sqlTilesCount = "SELECT user_tileid FROM `fn_user_finao_tile` ft JOIN fn_user_finao fu ON fu.`user_finao_id` = ft.`finao_id` WHERE ft.userid =" . $obj->updateby . " AND finao_activestatus !=2 "; $sqlTilesCount .= " and `finao_status_Ispublic`=1"; $sqlTilesCount .= " GROUP BY tile_id "; $sqlTilesCountRes = mysql_query($sqlTilesCount); $totaltiles = mysql_num_rows($sqlTilesCountRes); $totalfinaos = 0; $sqlFianosCount = "SELECT user_tileid FROM fn_user_finao_tile ft JOIN fn_user_finao f WHERE ft.finao_id = f.user_finao_id AND ft.userid = '" . $obj->updateby . "' AND f.finao_activestatus =1 AND finao_status_Ispublic =1"; $sqlSelectFinaoCountRes = mysql_query($sqlFianosCount); $totalfinaos = mysql_num_rows($sqlSelectFinaoCountRes); $totalfollowings = 0; $totalfollowings = fngetTotalFollowings($obj->updateby); if ($totaltiles == "") { $totaltiles = 0; } if ($totalfinaos == "") { $totalfinaos = 0; } if ($totalfollowers == "") { $totalfollowers = 0; } if ($totalfollowings == "") { $totalfollowings = 0; } $data['totalfinaos'] = $totalfinaos; $data['totaltiles'] = $totaltiles; $data['totalfollowers'] = $totalfollowers; $data['totalfollowings'] = $totalfollowings; $rows[] = $data; } $response = generateResponse(TRUE, NULL, $rows); } else { $response = generateResponse(TRUE, NULL, 'Currently there are no posts'); } echo json_encode($response); } else { getStatusCode(401); $response = generateResponse(FALSE, UNUTHORISED_USER); echo json_encode($response); } }