Oxle's Sponsor Mod - Add Expiration - Help Needed - Posted (2763 Views)
stwilson
Junior Member
stwilson
Posts: 385
385
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?<
Shannon
RidingArizona.com
Last edited by stwilson on 04 December 2006, 08:40
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
MarcelG
Retired Support Moderator
MarcelG
Posts: 2625
2625
Good thought ; I was thinking of something similar myself....haven't found the time and inspiration to make it.<
portfolio - linkshrinker - oxle - twitter
Posted
tribaliztic
Senior Member
tribaliztic
Posts: 1532
1532
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 -
Posted
stwilson
Junior Member
stwilson
Posts: 385
385
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
Posted
MarcelG
Retired Support Moderator
MarcelG
Posts: 2625
2625
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
Posted
stwilson
Junior Member
stwilson
Posts: 385
385
Any other takers?<
Shannon
RidingArizona.com
Posted
MarcelG
Retired Support Moderator
MarcelG
Posts: 2625
2625
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 ;
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 Sponsormod
Just a wild guess...<
portfolio - linkshrinker - oxle - twitter
Posted
stwilson
Junior Member
stwilson
Posts: 385
385
Still looking for a solution to this. Any takers?<
Shannon
RidingArizona.com
Posted
TStewartFan
Junior Member
TStewartFan
Posts: 190
190
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<
If You Have to Ask, You Wouldn't Understand.
Posted
hawkdrean
New Member
hawkdrean
Posts: 73
73
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?<
Posted
stwilson
Junior Member
stwilson
Posts: 385
385
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
You Must enter a message