Server Time Out ?

[fla5h]

thanks for the tips xenon.

I want to produce a stats page,

I basically need the following variables.

The username
The userid
The usertitle ( not custom title, default usergroup title )
Number of post the user has posted
Number of threads the user has created
The Intro thread id ( PPN's hack, basically do a lookup in the intro forum for a thread with a title of the users username )
The users last post date / time
The users last post id
The users last visit date / time
The users join date / time
The users referral users id
The users referral username

Thanks for your help once again, I am maybe asking a lot here, I know you are busy with your other duties so if you do not have time to do this, if you can give me some pointers as to where to look / start that would be great.

Thanks

[Xenon]

ahh i see

then use instead of this code:

PHP Code:

$r1=$DB_site->query("SELECT user.userid, user.username, user.joindate, user.posts, user.lastactivity, 

post.dateline, 

post.threadid,
usergroup.title, thread.title as ptitle
FROM user,post,usergroup,thread
WHERE user.lastpost=post.dateline AND user.usergroupid=usergroup.usergroupid AND 

post.threadid=thread.threadid
ORDER BY usergroup.title,user.username"); 


this:

PHP Code:

$r1=$DB_site->query("SELECT user.userid, user.username, user.joindate, user.posts, user.lastvisit, 
post.postid, post.threadid, thread.title as ptitle,
usergroup.title, thread.title as ptitle
FROM user
LEFT JOIN usergroup USING (usergroupid)
LEFT JOIN post ON (post.userid=user.userid AND dateline>=user.lastpost-30)
LEFT JOIN thread ON (thread.threadid=post.threadid)
ORDER BY usergroup.title,user.username"); 


the referrals would mean extra queries again... (same procedure as threads counter )