UseBB Community

Hi guys, I noticed nobody had requested a welcome panel modification. I'm going to give it a try, but I need to know what kind of info people would like to see on such a panel.

Please post some suggestions and I'll try to integrate them (note that the info must come from a unmodified board, so don't ask me to integrate the stats from a gallery mod or something alike).

Will tidy this post up later and am also going to post this to UseBB Zone.
I allready have some results, so screenshots will be added later.

I would like to see a default avatar then links to the profile and recent topics and posts

This is what I currently have, there's also a guest mode, but it's not that interesting yet:

Oh, and about the recent topics and stuff: it's a good idea but I think it's best to just display one recent topic.

Sounds good to me, its gonna be interesting.

Perhaps you could put in there something like:

There have been XX posts since your last visit.

The posts since last visit has crossed my mind aswell. But the problem is, what would be the most reliable way to calculate that? I don't think UseBB has such a function by default.

Well, you would probably have to do a MySQL COUNT(*) query.

Something like:

SELECT COUNT(*) WHERE post_time =< member_last_visited_time

I know those aren't the correct tables, but, i think you get the idea i'm trying to get at?

Err, damn edit :p.

By tables, i mean fields.

For the tables, there would be some sort of LEFT JOIN in there. To select the values from both the user and posting tables.

So basically I have to do this:
Get the last_login value from the usebb_members table. Then compare it with the current time, and figure out which posts were added in the meantime. Right?

Exactly. . It will find the posts that were added after their last visit and before the current time. Based on the post time in the database.

I'm quite good with PHP, but not this good, so it would take me some more time to get it functioning