Read content from a table then present it on a HTML page?

[fille87]

I'm trying to make a event log for my forum (shows bans, new users and stuff like that) and I wonder how I would make a php script that
1. Reads content from a table (smf_log_banned, smf_members)
2. Uses the member_id to get the username (matching member_id from smf_log_banned to member_id from smf_members and outputs the username)
3. Presents it in a list together with the ban time for each user (how would I show it in days/permanent?)
4. (Maybe another script) reads from that list and presents it on a webpage in a format something like this: "USERNAME was banned for TIME"

If anyone wants to help I would be really happy

EDIT: Forgot to say that I'm on 2.0 RC1-1

[Kermit]

For the ban stuff you can use this

http://custom.simplemachines.org/mods/index.php?mod=1198

IIRC your forum was 2.x,that's why you can ask the mod author for an update