can you help me?

[Murphinator]

im trying to make a featured diary, on my forums members can request a member forum with the member hosting hack that i got somewhere i dont remember :P well anyway that forum they have is a place they can vent and just post anything, what i want to do is have on my portal a featured diary where the cron job actually picks one of the forums specified randomly and shows the title and description and a link to the diary itself. ive tried basing it off the memeber of the day hack but i have absolutly no clue waht im doing so that sucks, so can someone help me write this please!

[sabret00the]

ok what you need to do is

make a new table in your database called homepage_featured_diary with three columns, "featuredid" (tinyint(4), auto increment), "featured_name" (varchar(250), "featured_description (mediumtext)"

ok now make a simple cron, it's going to randomly select a record (from the threads table) and then temporarily store that data in order to insert it into the new table)

so you're not gonna insert the id as that's on autoincrement, you're just inserting the name and description

ok now you've got that and it's tested you're gonna upload it and set it to run every however long you want to keep one member on the homepage for.