PHP usercommenttable Examples

Example #1

File: userfriends.php Project: ZenoX2012/CyBerFuN-CoDeX

    print "<td class=bottom width=50%>&nbsp;</td></tr></table>\n";
}
if (isset($friends)) {
    print $friends;
}
print "</td></tr></table>\n";
print "</td></tr></table>\n";
print "<h1>Comments for <a href=userdetails.php?id={$userid}>" . $user["username"] . "</a></h1>\n";
print "<p><a name=\"startcomments\"></a></p>\n";
$commentbar = "<p align=center><a class=index href=usercomment.php?action=add&amp;userid={$userid}>Add a comment</a></p>\n";
$subres = mysql_query("SELECT COUNT(*) FROM usercomments WHERE userid = {$userid}");
$subrow = mysql_fetch_array($subres, MYSQL_NUM);
$count = $subrow[0];
if (!$count) {
    print "<h2>No comments yet</h2>\n";
} else {
    $pager = pager(20, $count, "userfriends.php?id={$userid}&", array('lastpagedefault' => 1));
    $subres = mysql_query("SELECT usercomments.id, text, user, usercomments.added, editedby, editedat, avatar, warned, " . "username, title, class, donor FROM usercomments LEFT JOIN users ON usercomments.user = users.id WHERE userid = " . "{$userid} ORDER BY usercomments.id " . $pager['limit']) or sqlerr(__FILE__, __LINE__);
    $allrows = array();
    while ($subrow = mysql_fetch_assoc($subres)) {
        $allrows[] = $subrow;
    }
    print $commentbar;
    print $pager['pagertop'];
    usercommenttable($allrows);
    print $pager['pagerbottom'];
}
print $commentbar;
print "<p><a href=users.php><b>Find User/Browse User List</b></a></p>";
end_frame();
stdfoot();

Example #2

File: usercomments.php Project: UniversalAdministrator/U-232-V4

        $htmlout .= "</table>";
    }
    $htmlout .= end_frame();
    $htmlout .= "</td></tr></table>";
    return $htmlout;
}
//==Usercomments - pdq
$HTMLOUT .= "<h1>{$lang['userdetails_comm_left']}<a href='userdetails.php?id={$id}'>" . htmlsafechars($user['username']) . "</a></h1>\n    <a name='startcomments'></a>";
$commentbar = "<a href='usercomment.php?action=add&amp;userid={$id}'>Add a comment</a>\n";
$subres = sql_query("SELECT COUNT(id) FROM usercomments WHERE userid = " . sqlesc($id));
$subrow = mysqli_fetch_array($subres, MYSQLI_NUM);
$count = $subrow[0];
if (!$count) {
    $HTMLOUT .= "<h2>{$lang['userdetails_comm_yet']}</h2>\n";
} else {
    require_once INCL_DIR . 'pager_functions.php';
    $pager = pager(5, $count, "userdetails.php?id={$id}&amp;", array('lastpagedefault' => 1));
    $subres = sql_query("SELECT usercomments.id, text, user, usercomments.added, editedby, editedat, edit_name, avatar, warned, username, title, class, leechwarn, chatpost, pirate, king, donor FROM usercomments LEFT JOIN users ON usercomments.user = users.id WHERE userid = {$id} ORDER BY usercomments.id {$pager['limit']}") or sqlerr(__FILE__, __LINE__);
    $allrows = array();
    while ($subrow = mysqli_fetch_assoc($subres)) {
        $allrows[] = $subrow;
    }
    $HTMLOUT .= $commentbar;
    $HTMLOUT .= $pager['pagertop'];
    $HTMLOUT .= usercommenttable($allrows);
    $HTMLOUT .= $pager['pagerbottom'];
}
$HTMLOUT .= $commentbar;
//==end
// End Class
// End File