$json['res'] = $rows;
echo json_encode($json);
} else {
if ($_REQUEST['json'] == 'followings') {
$json = array();
$rows = "";
$sqlMyTrackings = "select t.fname,t.lname,t.userid, t5.mystory, group_concat(Distinct t4.tilename ORDER BY t4.tilename SEPARATOR ', ') as gptilename, t5.profile_image as image,t1.tracker_userid,t4.tile_id,t1.tracker_userid,t1.tracked_userid,t1.status,t2.finao_msg from fn_users t join fn_tracking t1 on t.userid = t1.tracked_userid and t1.status = 1 join fn_user_finao t2 on t.userid = t2.userid join fn_user_finao_tile t3 on t.userid = t3.userid and t2.user_finao_id = t3.finao_id left join fn_tilesinfo t4 on t3.tile_id = t4.tile_id and t3.userid = t4.createdby left join fn_user_profile t5 on t.userid = t5.user_id where t1.tracker_userid = '" . $_REQUEST['userid'] . "' and t2.finao_activestatus != 2 and t2.finao_status_Ispublic = 1 and t3.status = 1 group by t.userid,t.fname,t.lname";
$sqlMyTrackingsRes = mysql_query($sqlMyTrackings);
$totalfollowers = mysql_num_rows($sqlMyTrackingsRes);
if ($totalfollowers > 0) {
while ($sqlMyTrackingsDet = mysql_fetch_assoc($sqlMyTrackingsRes)) {
$userid = $sqlMyTrackingsDet['userid'];
$totalfollowers = 0;
$sqlMyTrackingsDet['totalfollowers'] = fngetTotalFollowers($userid);
$totaltiles = 0;
$sqlMyTrackingsDet['totaltiles'] = fngetTotalTiles($userid, "search");
$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 finao_activestatus !=2 ";
$sqlTilesCount .= " and `finao_status_Ispublic` =1";
$sqlTilesCount .= " GROUP BY tile_id ";
$sqlTilesCountRes = mysql_query($sqlTilesCount);
$totaltiles = mysql_num_rows($sqlTilesCountRes);
$sqlMyTrackingsDet['totaltiles'] = $totaltiles;
$totalfinaos = 0;
$sqlMyTrackingsDet['totalfinaos'] = fngetTotalFinaos($userid, "followings");
$totalfollowings = 0;
$sqlMyTrackingsDet['totalfollowings'] = fngetTotalFollowings($userid);
$rows[] = $sqlMyTrackingsDet;
}
}
$json['res'] = $rows;
function followings($user_id)
{
$json = array();
$rows = "";
$sqlMyTrackings = "select t.fname,t.lname,t.userid, t5.mystory, group_concat(Distinct t4.tilename ORDER BY t4.tilename SEPARATOR ', ') as gptilename, t5.profile_image as image,t1.tracker_userid,t4.tile_id,t1.tracker_userid,t1.tracked_userid,t1.status,t2.finao_msg from fn_users t join fn_tracking t1 on t.userid = t1.tracked_userid and t1.status = 1 join fn_user_finao t2 on t.userid = t2.userid join fn_user_finao_tile t3 on t.userid = t3.userid and t2.user_finao_id = t3.finao_id left join fn_tilesinfo t4 on t3.tile_id = t4.tile_id and t3.userid = t4.createdby left join fn_user_profile t5 on t.userid = t5.user_id where t1.tracker_userid = '" . $user_id . "' and t2.finao_activestatus != 2 and t2.finao_status_Ispublic = 1 and t3.status = 1 group by t.userid,t.fname,t.lname";
$sqlMyTrackingsRes = mysql_query($sqlMyTrackings);
$totalfollowers = mysql_num_rows($sqlMyTrackingsRes);
if ($totalfollowers > 0) {
while ($sqlMyTrackingsDet = mysql_fetch_assoc($sqlMyTrackingsRes)) {
$userid = $sqlMyTrackingsDet['userid'];
$totalfollowers = 0;
$sqlMyTrackingsDet['totalfollowers'] = fngetTotalFollowers($userid);
$totaltiles = 0;
$sqlMyTrackingsDet['totaltiles'] = fngetTotalTiles($userid, "search");
$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 finao_activestatus !=2 ";
$sqlTilesCount .= " and `finao_status_Ispublic` =1";
$sqlTilesCount .= " GROUP BY tile_id ";
$sqlTilesCountRes = mysql_query($sqlTilesCount);
$totaltiles = mysql_num_rows($sqlTilesCountRes);
$sqlMyTrackingsDet['totaltiles'] = $totaltiles;
$totalfinaos = 0;
$sqlMyTrackingsDet['totalfinaos'] = fngetTotalFinaos($userid, "followings");
$totalfollowings = 0;
$sqlMyTrackingsDet['totalfollowings'] = fngetTotalFollowings($userid);
$rows[] = $sqlMyTrackingsDet;
}
}
$json['res'] = $rows;
echo json_encode($json);
}
