} } else { $query_sql_sort = null; } /* * ---------------------- * Instance Class * ---------------------- */ $obj = new AjaxRequest(); $infoSessioUsr = $obj->infoUserLive($_SESSION['authenticated']); $response = $obj->discover('WHERE P.user != ' . $_SESSION['authenticated'] . ' && U.status = "active" && P.status = "1" && B.id IS NULL && U.mode = "1" && P.id ' . $query . ' ' . $offset . ' && P.repost_of_id = "0" && F.id IS NULL ' . $query_sql_sort . ' GROUP BY P.id ORDER BY P.id DESC', 'LIMIT ' . $postnumbers, $_SESSION['authenticated']); ?> <?php $countPosts = count($response); if ($countPosts != 0) { foreach ($response as $key) { $idPost = $key['id']; $_idUser = $key['user_id']; //============ VERIFIED if ($key['type_account'] == '1') { $verified = ' <i class="fa fa-check-circle verified verified-min showTooltip" title="' . $_SESSION["LANG"]["verified"] . '" data-toggle="tooltip" data-placement="right"></i>'; } else {
case 'links': $query_sql_sort = ' && P.url_host != ""'; break; } } else { $query_sql_sort = null; } /* * ---------------------- * Instance Class * ---------------------- */ $obj = new AjaxRequest(); $infoUser = $obj->infoUserLive($_SESSION['authenticated']); $getPosts = $obj->discover('WHERE P.user != ' . $_SESSION['authenticated'] . ' && U.status = "active" && P.status = "1" && P.id > ' . $since_id . ' && U.mode = "1" && F.id IS NULL && P.repost_of_id = "0" ' . $query_sql_sort . ' GROUP BY P.id ORDER BY P.id ASC', null, $_SESSION['authenticated']); $count = count($getPosts); if ($count != 0) { for ($i = 0; $i < $count; ++$i) { $_idUser = $getPosts[$i]['user_id']; if ($getPosts[$i]['repost_of_id'] != 0) { $nameUser = $getPosts[$i]['name']; $idPost = $getPosts[$i]['id']; $getPosts[$i]['type_account'] = $getPosts[$i]['rp_type_account']; $getPosts[$i]['username'] = $getPosts[$i]['rp_username']; $getPosts[$i]['name'] = $getPosts[$i]['rp_name']; $getPosts[$i]['avatar'] = $getPosts[$i]['rp_avatar']; $getPosts[$i]['user'] = $getPosts[$i]['rp_user']; $getPosts[$i]['id'] = $getPosts[$i]['rp_id']; } else {