Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Birthdate MOD Fix.		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Azaniah
Senior Member

United Kingdom
1004 Posts
Posted - 15 January 2002 :  11:52:22  Show Profile  Visit Azaniah's Homepage
Found a problem with the birthdate MOD.
You may notice no-one has a birthday this month? well...

Easy to fix,

inc_birthdate.asp

about line 155.


strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE LIKE '____" & doublenum(currMonth) & "__'"  
strSql = strSql & "AND Right(" & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE,2)>'" & (doublenum(currday-30)) & "' "


events_functions.asp

about line 699


		bSql = bSql & "FROM " & strMemberTablePrefix & "MEMBERS "
		bSql = bSql & "WHERE " & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE LIKE '____" & doublenum(intThisMonth) & doublenum(intPrintDay) & "'"
		bSql = bSql & "AND " & strMemberTablePrefix & "MEMBERS.M_HIDEAGE = 0"


Just make sure the code in red is as above for these files.

Will update the .zip

Cheers Az


-------
Eagles fly!, but weasels don't get sucked into jet engines.

T.G.K
Junior Member

Vietnam
347 Posts
Posted - 20 January 2002 :  06:31:44  Show Profile  Visit T.G.K's Homepage  Send T.G.K an AOL message  Send T.G.K an ICQ Message  Send T.G.K a Yahoo! Message
I didn't have these line in my inc_birthdate.asp Azaniah. I just got these:
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID," & strMemberTablePrefix & "MEMBERS.M_NAME," & strMemberTablePrefix & "MEMBERS.M_HIDEAGE," & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE LIKE '____" & currMonth & "__'"  
strSql = strSql & "AND Right(" & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE,2)>'" & (doublenum(currday-3)) & "' "
strSql = strSql & "AND Right(" & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE,2)<'" & (doublenum(currday+3)) & "' "
strSql = strSql & "ORDER BY Right(" & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE,4) "


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"A Woman without her man is nothing." (but put some punction it will be diffrent.
Go to Top of Page

Azaniah
Senior Member

United Kingdom
1004 Posts
Posted - 20 January 2002 :  08:00:15  Show Profile  Visit Azaniah's Homepage
You will need to make the statement currmonth read doublenum(currmonth).



Cheers Az

-------
Eagles fly!, but weasels don't get sucked into jet engines.
Go to Top of Page

bb8636
New Member

68 Posts
Posted - 01 February 2002 :  13:16:43  Show Profile
quote:

Found a problem with the birthdate MOD.
You may notice no-one has a birthday this month? well...

Easy to fix,

inc_birthdate.asp

about line 155.


strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE LIKE '____" & doublenum(currMonth) & "__'"  
strSql = strSql & "AND Right(" & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE,2)>'" & (doublenum(currday-30)) & "' "


events_functions.asp

about line 699


		bSql = bSql & "FROM " & strMemberTablePrefix & "MEMBERS "
		bSql = bSql & "WHERE " & strMemberTablePrefix & "MEMBERS.M_BIRTHDATE LIKE '____" & doublenum(intThisMonth) & doublenum(intPrintDay) & "'"
		bSql = bSql & "AND " & strMemberTablePrefix & "MEMBERS.M_HIDEAGE = 0"


Just make sure the code in red is as above for these files.

Will update the .zip

Cheers Az


-------
Eagles fly!, but weasels don't get sucked into jet engines.


still no one has a birthday today please help...
Go to Top of Page

Intrepidone
Average Member

Canada
515 Posts
Posted - 01 February 2002 :  23:03:52  Show Profile
Just noticed the MOD did not show any Birthdays for today even though 2 are for Feb 1st. I changed mine to Feb 2nd and it did not show any upcoming. I set my clock to Feb 2nd and then the MOD showed my Birthday as Feb 2nd (the way it should)

For some reason it skipped Feb 1st, could that be because there are only 28 days in this Month?

Oh yea, and I did apply the patch in this Topic when you posted it and January worked fine.

Intrepidone

Edited by - Intrepidone on 01 February 2002 23:05:59
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07