| Author |
 Topic  |
|
|
Lydecker
Junior Member
United Kingdom
297 Posts |
 Posted - 28 May 2003 : 18:30:21
|
I would to see a mod that awards little medel icons (.gif's or what not) that appear by a users name if they have the highest post count in a certain forum.
i.e if user 'Tom' has made the most posts in forum_7, then he gets a medal with a 7 on it by his name. As soon as 'Zoe' makes more posts then 'Tom' in forum_7, then she gets the medal by here name, and 'Tom's' medal dissappears.
Any chance?
Many thanks!!!!!!!!!!!!!1 |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 30 May 2003 : 18:14:55
|
| Something that existed similar to that is Crash's Award Member Mod. It will need to be worked on though but it's a start. |
 |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 31 May 2003 : 08:55:02
|
my mod allows the admin to select a member to be awarded for special services, like helping out members or whatever.
it could be rebuilt to function as you, Lydecker, pleases. |
cHosting.nl |
|
|
|
jfitz
Junior Member
USA
345 Posts |
Posted - 31 May 2003 : 15:43:47
|
I modded our forum so that we can assign awards to members who complete different levels of our monthly exercise challenges. In March, the award titles had an academic flavor (Diploma, Graduate, PhD, etc); in April we used miliary titles (Airman, Lieutenant, etc.) The member's current award displays under their name on the topic page.
I added a field to the MEMBERS table with the current award id, and created a separate awards table that matches the award id with the actual title of the award. I wanted to use the same SQL statement that is already used when looking up member data for topic display. Because not every member has an award, I used an outer join to extract the data. Fortunately SQL support an alternative syntax (*=) to express an outer join, so the baseline code modification wasn't too difficult. I don't know if the other Snitz-supported data bases recognize this syntax. |
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down. |
Edited by - jfitz on 31 May 2003 15:44:50 |
|
|
|
jeffery
Junior Member
USA
176 Posts |
|
|
jfitz
Junior Member
USA
345 Posts |
Posted - 27 June 2003 : 17:12:38
|
Sure, I'll have to dig it out. It's not too complicated, except for the outer join which uses a non-ANSI syntax '*=' that is supported by MSSQL, but if you are using a different data base, you might have to rewrite the code that creates the SQL. Also, there is no admin interface - I just go into the DB every month and update the status field by hand.
If you want to see what it looks like, you can visit http://forums.deniseaustin.com/forums/topic.asp?TOPIC_ID=6378
User id: Test User
Password: Test User
You'll see the awards level just below the stars and above the (optional) photo.
I'll try to get the code written up and posted in the next 24 hours or so.
|
--Jördan
It's a wasted day if you don't spend at least part of it flying upside down. |
|
|
|
jeffery
Junior Member
USA
176 Posts |
Posted - 27 June 2003 : 18:04:48
|
| I'm using MSSQL as a matter of fact. Thanks, that would be great! |
www.thomasforum.com |
Edited by - jeffery on 27 June 2003 18:10:07 |
|
|
|
jfitz
Junior Member
USA
345 Posts |
|
| |
Topic |
|
Topic Locked
