| T O P I C R E V I E W |
| stwilson |
Posted - 23 January 2005 : 01:27:18
This idea is in regards to Oxle's sponsoring member mod found here:
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=51932
Has anyone updated this mod to include a start/stop date for the sponsorhip status? I have this mod installed but would like to grant sponsorship status annually. So when a member makes a site donation I would like to also enter a start and stop date. Has anyone see this done with this mod?< |
| 15 L A T E S T R E P L I E S (Newest First) |
| tribaliztic |
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 =)
< |
| stwilson |
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.< |
| tribaliztic |
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! =)
< |
| MarcelG |
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.< |
| Rob Alan |
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< |
| stwilson |
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.< |
| MarcelG |
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?< |
| RArch |
Posted - 08 December 2006 : 03:43:19
Glad to have helped and we learned a bit a long the way 
< |
| stwilson |
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!!!!< |
| RArch |
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 |
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???< |
| RArch |
Posted - 06 December 2006 : 02:23:49
Try this:
strSql = strSql & " AND M_SPONSORENDS > '" & StrToDate(strForumTimeAdjust)& "'"
< |
| stwilson |
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?< |
| stwilson |
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.< |
| RArch |
Posted - 05 December 2006 : 14:58:44
Its great this trial and error style of coding But we will get there in the end...
Again I would put a Response.Write strSql after your select statement and check that the output is what you expect.
Instead of using strDBNTSQLName in your where clause you could try MemberID so that you dont have to run the ChkString function.
< |
