| Author |
 Topic  |
|
stwilson
Junior Member
USA
385 Posts |
 Posted - 05 December 2006 : 18:29:41
|
| OK. I'm getting really close now. Question for you...am I supposed to use strForumTimeAdjust as the variable that I compare my expiration field against? The reason I ask is that then I added the Response.Write strSql to my output it shows the date as 12/5/2006 not a string of 200612050000.< |
Shannon
RidingArizona.com |
 |
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 06 December 2006 : 00:54:46
|
I have added the following code to show the supporing member status under the member name in the left colum. Small issue though, it still shows every member that is marked as a Sponsor member, even if their expiration date has passed:
if Reply_MemberSponsorDate > strForumTimeAdjust AND Reply_MemberSponsorlevel = 1 then
Response.Write " <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><b><small><a href=""http://ridingarizona.com/store/scripts/prodview.asp?idProduct=36"", target=""_blank"", title=""This member is a RA site supporter. Click here for more information on becoming a site supporter.""><img border=""0"" src=""http://ridingarizona.com/forum/images/supporting_member.gif"" width=""64"" height=""64""></a></small></b></font><br />" & vbNewLine
end if
Any suggestions on how to get this to show ONLY those marked as supporting members AND whose expiration date has not passed?< |
Shannon
RidingArizona.com |
|
|
|
RArch
Junior Member
United Kingdom
103 Posts |
Posted - 06 December 2006 : 02:23:49
|
Try this:
strSql = strSql & " AND M_SPONSORENDS > '" & StrToDate(strForumTimeAdjust)& "'"
< |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 07 December 2006 : 00:13:53
|
RArch,
Thanks for the help. I still cannot get it to compare the expiration date against the forum date and show a seal if the member is still an active supporting member. Here is a link to my topic.asp so you can see what I was attempting to do:
http://www.ridingarizona.com/new_forum/topic.txt
You can see around lines 790 (for replies) and 1018 (for topic starter) where I attempted to see if a member was a supporting member that had not expired and to show a graphic if they were. As it sits, it shows the seal for everyone who was has a supporting member status of 1 (supporting member for my site), regardless of it they are expired or not. What am I missing???< |
Shannon
RidingArizona.com |
|
|
|
RArch
Junior Member
United Kingdom
103 Posts |
Posted - 07 December 2006 : 18:42:23
|
We must not be comparing like values. Can you tell what values are set to the following:
Reply_MemberSponsorEnds
Member_SponsorEnds
You can display these by adding a Response.write variable name directly after your code within the file.
For example this is what I get:
Response.Write datetostr(strForumTimeAdjust) = 20061207235305 (YYYYMMDDHHMMSS)
Response.Write strtodate(strForumTimeAdjust) = 7/12/2006 23:53:5 (DD/MM/YYYY HH:MM:S)
Response.Write strForumTimeAdjust & vbNewLine = 07/12/2006 23:53:05 (DD/MM/YYYY HH:MM:SS)
Note the differences, when you compare your two variables they need to be in the same format. So use the datetostr or strtodate functions to make them match or drop the function as appropriate.
< |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 08 December 2006 : 01:24:57
|
RArch,
Thank you SO much for your help. It took me a while but I figured it out. You were correct....dates are tough. The problem was my date formats were not matching. Once I figured out how to spit them out in the same format I was able to make it work. THANK YOU. I sincerely appreciate your help!!!!< |
Shannon
RidingArizona.com |
|
|
|
RArch
Junior Member
United Kingdom
103 Posts |
Posted - 08 December 2006 : 03:43:19
|
Glad to have helped and we learned a bit a long the way 
< |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 08 December 2006 : 05:47:26
|
Shannon,
good to read you got it working!!! 
Planning on releasing it as an addition for the mod?< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 09 December 2006 : 11:08:48
|
Marcel,
Me? Release a mod/addition? Just the thought of that scares me to death. As you can see from this thread, I could not support it. However, I will write up what I have done and will gladly share it with anyone who wants to beat it up, test it and use it. Just shoot me a PM with your email address.< |
Shannon
RidingArizona.com |
|
|
|
Rob Alan
Starting Member
10 Posts |
Posted - 09 December 2006 : 23:05:21
|
Shannon,
I sent you an email as this forum doesn't support PMs. Maybe you should just post what you have here....
Rob< |
|
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 11 December 2006 : 04:59:34
|
quote:
Originally posted by stwilson
Marcel,
Me? Release a mod/addition? Just the thought of that scares me to death. As you can see from this thread, I could not support it. However, I will write up what I have done and will gladly share it with anyone who wants to beat it up, test it and use it. Just shoot me a PM with your email address.
Shannon, if you just write down the steps you took, I'm very happy to whip up a documented mod of it!
You can find me at marcel at oxle.com.< |
portfolio - linkshrinker - oxle - twitter |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 11 December 2006 : 05:33:21
|
Can't wait to be able to add this to my forum, thought of doing it myself but haven't had the time. Thanks alot guys! =)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 11 December 2006 : 22:19:26
|
OK. I will gladly work with Marcel and get this documented as an add-on to his MOD. It will take me another day or two because the wife (I am Mr. Shannon) wants the Christmas cards sent out BEFORE I take any more time on website stuff. So I have to do a Word mail-merge for her 120 labels before I can play.
I did manage to get this implemented on my site and it works great. The worst part of it was figuring out all the existing supporting member's expiration dates. That took about five hours of research/updating.< |
Shannon
RidingArizona.com |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 12 December 2006 : 02:33:32
|
Hehe, I don't have to do that check since I'm starting on a fresh version of the site and we haven't gotten any payments from any members for over a year =)
< |
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Topic |
|
Oxle's Sponsor Mod - Add Expiration - Help Needed
