I have create a Member of the Month or Awards Mod based on MadDog Birthday Mod with modifications. Works in 8.X
This is designed for Access DB.
1) Modify the table tblAuthor and add a text field call Awards
2) Create a table called tblAwards
- Author_id Number key field
- Award_Id Text field
- Award-Month Text field
- Award_Year Text field
- Description Text field
- Award_Date Date/Time field
Here are the three programs need.
Check_Permissions.asp is a program created for version 6.x which I updated to work with 7 and 8.
Member_of_Month.asp is a program that I use on my default page using an incude statement. I will show the members Avator, link to there profile, and a link to a list of last month winners (Member_of_Month_a.asp).
Member_of_Month_a.asp show a listing of the members, plus it uses the style sheet from the default page. The listing show, avatar, user name/real name, status, registration date, and award date. All sorted by award date.
To use.
Create table information, upload files, go to tblAuthor and in the Awards row, enter 1 for the person winning the award - Save (remember Author ID number). Go to tblAwards and make a new entry. Enter the Author_Id, 1 for Award_Id, followed by dates and description.
Descriptions is more for admin purposes.
IF done right you should have a listing. - Next month/award change the person who is 1 to 2 and make the new person 1.
PROBLEM - you need to edit the table every month. I have been working on make the registration forum input this date so the Admin can make changes but have not been successful. This is where I need help to make this a really cool mod.
I hope this make sense.
Edited by Demon - 14 July 2006 at 10:08pm
![RSS Feed - [MOD] Member of the Month](forum_images/rss.png "RSS Feed: [MOD] Member of the Month")
Topic Options
Post Options
Thanks(0)
