Web Wiz Forums Modifications - [MOD] Member of the Month

Print Page | Close Window

[MOD] Member of the Month

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20682
Printed Date: 28 March 2026 at 5:51am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: [MOD] Member of the Month

Posted By: mbd2
Subject: [MOD] Member of the Month
Date Posted: 14 July 2006 at 4:48pm

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.

http://www.mbd2.com/member_of_Month_a.zip - http://www.mbd2.com/member_of_Month_a.zip

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.

forum: http://www.mbd2.com/forum - www.mbd2.com/forum

-------------
Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video

Replies:

Posted By: Demon
Date Posted: 14 July 2006 at 6:34pm

Well, to make database changes from a webpage or form, use the following examples.

Adding a Row to a Table:

strSQL = "INSERT INTO table_name VALUES (value1, value2,....)"

adoCon.execute(strSQL)

Updating a Row in a Table:

strSQL = "UPDATE table_name SET column_name = new_value WHERE indexColumn_name = some_value"

adoCon.execute(strSQL)

Deleting a Row from a Table:

strSQL = "DELETE FROM table_name WHERE indexColumn_name = some_value"

adoCon.execute(strSQL)

These should all work fine if used correctly.

-------------
So Sayith the Demon.

Posted By: mbd2
Date Posted: 14 July 2006 at 7:16pm

Thanks Demon for the help.

I haven't had much time to reconfigure the registration.asp page to reflect these changes. I'm thinking that would be the best place to do it. If anybody want to jump in and give me a hand completing this... I would not object.

-------------
Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video