mirror of
https://github.com/Xkeeper0/jul.git
synced 2025-07-25 17:21:58 -07:00
cruft
css
errors
ext
images
js
lib
numgfx
schemes
tlayouts
.editorconfig
.gitignore
README.md
acs.php
activeusers.php
activity.php
activity2.php
activity3.php
activity3u.php
admin-editforums.php
admin-editmods.php
admin-slammer.php
admin-threads.php
admin-threads2.php
admin.php
adnonsense.php
announcement.php
avatar.php
biggestposters.php
calendar.php
del.php
doomcounter.php
editpost.php
editprofile.php
editthread.php
edituser.php
faq.php
favicon.ico
forum.php
hex.php
index.php
ipsearch.php
irc.php
latestposts.php
login.php
memberlist.php
milestones.php
newreply.php
newthread.php
numgfx.php
numgfxbig.php
online.php
posticons.dat
postradar.php
postsbyforum.php
postsbythread.php
postsbytime.php
postsbyuser.php
private.php
profile.php
ranks.php
register.php
sendprivate.php
shitbugs.php
shop.php
shoped.php
shoph.php
showprivate.php
sigsize.php
smilies.dat
smilies.php
smilies2.dat
smilies2.php
smilieslol.dat
stats-daily.php
stats.php
status.php
thread.php
83 lines
2.5 KiB
PHP
83 lines
2.5 KiB
PHP
<?php
|
|
require 'lib/function.php';
|
|
|
|
$user = $sql->resultq("SELECT name FROM users WHERE id=$id");
|
|
$windowtitle = "Listing posts by $user";
|
|
require 'lib/layout.php';
|
|
|
|
if (!$id)
|
|
errorpage('No user specified.', 'return to the board', 'index.php');
|
|
|
|
if ($_GET['forum']) {
|
|
$fid = intval($_GET['forum']);
|
|
$forum = $sql->fetchq("SELECT title, minpower FROM forums WHERE id={$fid}");
|
|
if ($forum['minpower'] > 0 && $power < $forum['minpower'])
|
|
errorpage('You don\'t have access to view posts in this forum.', 'return to the board', 'index.php');
|
|
$where = "in $forum[title]";
|
|
$forumquery = " AND t.forum = {$fid}";
|
|
}
|
|
else {
|
|
$forumquery = '';
|
|
$where = "on the board";
|
|
}
|
|
|
|
if ($_GET['time']) {
|
|
$time = intval($_GET['time']);
|
|
$when = " over the past ".timeunits2($time);
|
|
$timequery = ' AND p.date > ' . (ctime()-$time);
|
|
}
|
|
else
|
|
$timequery = $when = '';
|
|
|
|
if (!$page) $page=0;
|
|
if (!$ppp) $ppp=50;
|
|
$min = $ppp*$page;
|
|
|
|
$posts=$sql->query("SELECT p.id,thread,ip,date,num,t.title,minpower "
|
|
."FROM posts p "
|
|
."LEFT JOIN threads t ON (thread=t.id) "
|
|
."LEFT JOIN forums f ON (t.forum=f.id) "
|
|
."WHERE p.user={$id}{$forumquery}{$timequery} ORDER BY p.id DESC");
|
|
|
|
$posttotal=mysql_num_rows($posts);
|
|
|
|
// Seek to page
|
|
if (!@mysql_data_seek($posts, $min)) $page = 0;
|
|
|
|
$pagelinks=$smallfont.'Pages:';
|
|
for($i=0;$i<($posttotal/$ppp);$i++) {
|
|
if($i==$page) $pagelinks.=' '.($i+1);
|
|
else {
|
|
if($ppp != 50) $postperpage = "&ppp=$ppp";
|
|
if($forumquery) $forumlink = '&forum='.intval($_GET['forum']);
|
|
$pagelinks.=" <a href=postsbyuser.php?id=$id$postperpage$forumlink&page=$i>".($i+1).'</a>';
|
|
}
|
|
}
|
|
|
|
$postlist="
|
|
$tccellhs width=50>#</td>
|
|
$tccellhs width=50>Post</td>
|
|
$tccellhs width=130>Date</td>
|
|
$tccellhs>Thread</td>
|
|
" . (($isadmin) ? "$tccellhs width=110>IP address</td>" : "");
|
|
|
|
while(($post = $sql->fetch($posts)) && $ppp--) {
|
|
if($post['minpower']<=$power or !$post['minpower'])
|
|
$threadlink="<a href=thread.php?pid=$post[0]#$post[0]>".str_replace('<','<',$post['title']).'</a>';
|
|
else $threadlink='(restricted)';
|
|
|
|
if(!$post['num']) $post['num']='?';
|
|
|
|
$postlist.="<tr>
|
|
$tccell1s>$post[0]</td>
|
|
$tccell1s>$post[num]</td>
|
|
$tccell1s>".date($dateformat,$post[3]+$tzoff)."</td>
|
|
$tccell1ls>#<a href=thread.php?id=$post[thread]>$post[1]</a> - $threadlink
|
|
" . (($isadmin) ? "</td>$tccell1s>$post[2]" : "") ."
|
|
</tr>";
|
|
}
|
|
|
|
print "{$header}{$fonttag}Posts by {$user} {$where}{$when}: ({$posttotal} posts found)
|
|
$tblstart$postlist$tblend$pagelinks$footer";
|
|
printtimedif($startingtime);
|
|
?>
|