The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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?<
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?<
Shannon
RidingArizona.com
RidingArizona.com
آخرین ویرایش توسط
نوشته شده در
Good thought ; I was thinking of something similar myself....haven't found the time and inspiration to make it.<
portfolio - linkshrinker - oxle - twitter
نوشته شده در
Just what I was thinking about a few days ago! Haven't had the time to look into it any more though.. Could anyone just give a push in the right direction on how to do this?
<
/Tribaliztic
- www.gotlandrace.se -
- www.gotlandrace.se -
نوشته شده در
How about this? I will PayPal $25 (I know it's not much but hopefully more will offer up some help) to the developer who provides the tweek to this MOD. I hope Marcel takes this...I know your busy but this would really be a good mod to this MOD.<
Shannon
RidingArizona.com
RidingArizona.com
نوشته شده در
Shannon, I'd be happy to do it, if I could to it. But, as I said before to other people who asked me to do something ; I am no programmer.
The only thing I can do is copy/paste programming ...
<
<
portfolio - linkshrinker - oxle - twitter
نوشته شده در
Any other takers?<
Shannon
RidingArizona.com
RidingArizona.com
نوشته شده در
Well, I created this mod based on the 'Custom Member fields mod', so I guess the only thing that needs to be done is create two new columns in the FORUM_MEMBERS table, M_SPONSORSTART and M_SPONSOREND (or just one, M_SPONSOREND?)
After that, we need an option for admins to sét these values, together with the M_SPONSORLEVEL (that's already in there...)
If that's done, we need to change the function that checks for the sponsorlevel ;
Just a wild guess...<
After that, we need an option for admins to sét these values, together with the M_SPONSORLEVEL (that's already in there...)
If that's done, we need to change the function that checks for the sponsorlevel ;
Code:
'MarcelG's Sponsormod
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.M_SPONSORLEVEL"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(strDBNTUserName, "SQLString") & "'"
strSql = strSql & " AND M_SPONSOREND > '" & strForumTimeAdjust & "'"
set rsSponsor = my_Conn.Execute (strSql)
if rsSponsor.EOF or rsSponsor.BOF then
sLev = 0
else
sLev = rsSponsor("M_SPONSORLEVEL")
end if
rsSponsor.close
set rsSponsor = nothing
'end of MarcelG's Sponsormodportfolio - linkshrinker - oxle - twitter
نوشته شده در
Still looking for a solution to this. Any takers?<
Shannon
RidingArizona.com
RidingArizona.com
نوشته شده در
It shouldn't be that hard and do you really need a start date?!? I do not have this mod installed but chances are that somewhere within this mod an sql statemement is being made that resembles the following:
strSql = "SELECT * FROM " & strMemberTablePrefix & "MEMBERS
strSql = strSql & " WHERE MEMBER_ID = " & intMemberID
set rs = my_Conn.Execute (strSql)
Add the following beneath the set command:
mStDate = rs("M_START")
mStDate = rs("M_END")
strSql = "update " & strMemberTablePrefix & " MEMBERS set M_START= " & DateToStr(dtDateTime) & " WHERE MEMBER_ID = " & intMemberID
my_Conn.Execute (strSql)
strSql = "update " & strMemberTablePrefix & " MEMBERS set M_END= " & (DateToStr(dtDateTime))+ 10000000000) & " WHERE MEMBER_ID = " & intMemberID
my_Conn.Execute (strSql)
I am not going to install this mod into my forum but something along those lines otta work. Then all you would need to do is run an update statement if end date is < then todays day set end date to 0 and start date to 0<
strSql = "SELECT * FROM " & strMemberTablePrefix & "MEMBERS
strSql = strSql & " WHERE MEMBER_ID = " & intMemberID
set rs = my_Conn.Execute (strSql)
Add the following beneath the set command:
mStDate = rs("M_START")
mStDate = rs("M_END")
strSql = "update " & strMemberTablePrefix & " MEMBERS set M_START= " & DateToStr(dtDateTime) & " WHERE MEMBER_ID = " & intMemberID
my_Conn.Execute (strSql)
strSql = "update " & strMemberTablePrefix & " MEMBERS set M_END= " & (DateToStr(dtDateTime))+ 10000000000) & " WHERE MEMBER_ID = " & intMemberID
my_Conn.Execute (strSql)
I am not going to install this mod into my forum but something along those lines otta work. Then all you would need to do is run an update statement if end date is < then todays day set end date to 0 and start date to 0<
If You Have to Ask, You Wouldn't Understand.
نوشته شده در
What do it do I added this mod and the only thing I can see that was added was the drop down box in the members profile. What else dose it do or show?<
نوشته شده در
Marcel.....any chance you added the end-date to your sponsorship MOD? I still would pay for the update to this MOD. Any takers?<
Shannon
RidingArizona.com
RidingArizona.com
Email Member
Message Member
Post Moderation
بارگزاری فایل
If you're having problems uploading, try choosing a smaller image.
پیشنمایش مطلب
Send Topic
Loading...