$userinfo HELP

[MrLister]

if you go here http://cgi-bin.spaceports.com/~utopia02/ and put your mouse over the last poster you'll see a pop-up menu but in it beside posts i can't get it to work when i put down $userinfo[posts] because it doesn't know who's. this is the code i used for it


by <a href="member.php?s=$session[sessionhash]&action=getinfo&find=lastposter&forumid=$forum[forumid]" onMouseOver="return overlib('Posts: $userinfo[posts]', CAPTION, 'Test', FGCOLOR, '#999999', BGCOLOR, '#333333', BORDER, 4, CAPTIONFONT, 'Garamond', TEXTFONT, 'Courier', TEXTSIZE, 3)" onMouseOut="nd();">$forum[lastposter]</a></smallfont>


how can i fix it.

I couldn't get to the site, it gives me a 404 error.

I think, though, that $userinfo[xxx] is info for the logged in user and $post[xxx] is the info for the person who's post it is.

So $userinfo[username] would be John Doe if John Doe was the one logged in and viewing the thread, and if the thread was started by Jim Doe, then $post[username] would be Jim Doe.

So, basically, replacing $userinfo[posts] with $post[posts] should work.

(it's a while since I've looked at it, though, so that may not be it :))

the site is up it's just that sometimes spaceports screws up. $userinfo[xxx] is the thing used in profiles so i think that's the one that should be used. the post[posts] one doesn't work

oh right, yeah, that only works in the actual thread view, not where you're trying to use it.

Hmm, can't think of a solution right now. It probably needs a little hacking.

You would have to edit forumdisplay. Here is what you should change but I didn't test it and there may be a performance hit. You would use $thread[posts]


$threads=$DB_site->query("
SELECT $dotuserid $votequery icon.title as icontitle,icon.iconpath,
thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postus erid,
lastposter,thread.dateline,views,thread.iconid,not es,thread.visible,sticky,votetotal,attach
FROM thread
LEFT JOIN icon ON (icon.iconid = thread.iconid)
$dotjoin
WHERE $threadids
ORDER BY sticky DESC, $sortfield $sqlsortorder
");

to this:

$threads=$DB_site->query("
SELECT $dotuserid $votequery icon.title as icontitle,icon.iconpath,user.posts,
thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postus erid,
lastposter,thread.dateline,views,thread.iconid,not es,thread.visible,sticky,votetotal,attach
FROM thread
LEFT JOIN icon ON (icon.iconid = thread.iconid)
LEFT JOIN user ON (user.username=thread.lastposter)
$dotjoin
WHERE $threadids
ORDER BY sticky DESC, $sortfield $sqlsortorder
");