$page = $filter->get('page', 'INTEGER'); $uid = isset($_SESSION['uid']) ? intval($_SESSION['uid']) : NULL; $sql = "SELECT username FROM signup WHERE UID = " . $oid . " LIMIT 1"; $rs = $conn->execute($sql); $username = $rs->fields['username']; $sql = "SELECT COUNT(wall_id) AS total_walls FROM wall WHERE OID = " . $oid; $rsc = $conn->execute($sql); $total = $rsc->fields['total_walls']; $pagination = new Pagination(10, $page); $limit = $pagination->getLimit($total); $sql = "SELECT w.wall_id, w.UID, w.message, w.addtime, u.username, u.photo, u.gender\n FROM wall AS w, signup AS u WHERE w.OID = " . $oid . " AND w.status = '1' AND w.UID = u.UID \n ORDER BY w.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username . '/wall', 'p_wall_comments_' . $oid . '_'); $page_link_b = $pagination->getPagination('user/' . $username . '/wall', 'pp_wall_comments_' . $oid . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $code[] = $lang['global.showing'] . ' <span class="text-white">' . $start_num . '</span> ' . $lang['global.to'] . ' <span id="end_num" class="text-white">' . $end_num . '</span> ' . $lang['global.of'] . ' <span id="total_comments" class="text-white">' . $total . '</span> ' . $lang['global.comments'] . '.'; $code[] = '<div id="wall_response" class="wall_posting" style="display: none;">' . $lang['global.posting'] . '</div>'; if ($comments) { $code[] = '<div id="comments_delimiter" style="display:none;"></div>'; foreach ($comments as $comment) { $photo = $comment['photo'] == '' ? 'nopic-' . $comment['gender'] . '.gif' : $comment['photo']; $username = $comment['username']; $code[] = '<div id="wall_comment_' . $comment['wall_id'] . '" class="col-xs-12 m-t-15">'; $code[] = '<div class="row">'; $code[] = '<div class="pull-left">'; $code[] = '<a href="' . $config['BASE_URL'] . '/user/' . $username . '">'; $code[] = '<img src="' . $config['BASE_URL'] . '/media/users/' . $photo . '" title="' . $username . '" alt="' . $username . '" class="img-responsive comment-avatar" />'; $code[] = '</a>'; $code[] = '</div>';