Example #1
0
 $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>';