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

Started by fille87, June 06, 2009, 09:48:20 AM

Previous topic - Next topic


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


For the ban stuff you can use this

IIRC your forum was 2.x,that's why you can ask the mod author for an update
My Mods
Please don't PM/mail me for support,unless i invite you
Formerly known as Duncan85
"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe."

A. Einstein