I was forced to add a table to the FORUM_MEMBERS table called M_SPONSOR to show contributers to my site. My goal is to have a link appear by the user's name when a post is made on topic.asp if the member's M_SPONSOR field equals 1. I was able to setup an if test in pop_profile.asp to see if the value is one. If it is then an image is set to display. This works and looks similar to this:
if rs("M_SPONSOR") = "1" then blah blah end if
However this same thing doesn't work on topic.asp. I realize it's probably because I'm not opening the table in the correct way, but any help on getting this test working would be appreciated.
This example adds 3 fields, but you can see what changes need to be made. The main thing to remember is keep everything in order. 1. If you add your new field after M_COUNTRY, make sure you add it after M_COUNTRY in all the changes.(except where you put your "if M_SPONSOR" statement) 2. On the numbered fields, make sure you change the numbers so they are all in sequence. 3. There are 2 places to add "if M_SPONSOR", the 1st place is for the "replies" and the 2nd place is in "sub GetFirst" for the "topic"(first post)>
Thanks. It was much easier than I thought once I had a little advice to get the concept down. I am however scared of alienating some members... I may change the wording to sponsor instead of supporter after I get some feedback from the members.
I've polled the population (of my site) and it looks like everyone likes the wording that is currently there. I've also gone out to similar sites and they have chosen to word things very similarly as well. One good thing is that donations has gone up considerably since adding this latest addition. The "regulars" feel more compelled to throw in a few bucks.
As for the value in the database, there is an M_SPONSOR field that I added to the user's table. I've also built the editing feature into the pop_profile.asp page. If an admin level user edits a profile there in an entry that reads as "Is Sponsor" (I'm not very creative). Enter a 1 and the tests in the pop_profile.asp and topic.asp will place the information accordingly.
Topic Locked
Posted - 30 January 2004 : 08:35:09
