| Author |
 Topic  |
|
HgB
Starting Member
8 Posts |
 Posted - 02 February 2004 : 10:44:13
|
I've done an install of Snitz 34_03 on top of my test server files (OVERWRITE) and then applied 5 mods, testing each one as I went. Calendar Beta3 was the last mod to be applied. Note: The existing DB had Calendar rev 1 on it.
While the DB gets updated to create the new table, it appears there is no upgrade path to retaining existing dates for Calendar rev 1.
Would think this is a problem for those doing Beta3 on top of version 1 (read the opening posts of this thread and last posts but skipped 14 pages in between).
If an invalid value is entered into the array, you'll generate
Error Type:
Microsoft VBScript runtime (0x800A0006)
Overflow: 'cLng'
/web/forum/cal.asp, line ####
As FORUM_ID of 1 was not a valid value for my DB, it appeared to not be a problem. But, if I entered valid values after it (separating by comma) it would error out. Eliminating the bad entry (the default in this distribution) resolved the problem.
Also got something mucked up in the adding of an event had a page come up showing the word
MESSAGE:
twice and had pushed over the Smilies and message box to the right. Should be able to isolate and remedy this. Probably fat fingered.< |
 |
|
|
HgB
Starting Member
8 Posts |
Posted - 02 February 2004 : 10:46:38
|
quote:
Originally posted by HgB
I've done an install of Snitz 34_04 on top of my test server files (OVERWRITE) and then applied 5 mods, testing each one as I went. Calendar Beta3 was the last mod to be applied. Note: The existing DB had Calendar rev 1 on it.
FAT Finger gets in the way of posts too!< |
|
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 02 February 2004 : 23:56:43
|
quote:
Originally posted by golfmann
I see no birthdays...
Set to TRUE in Cal config.
What am I missing??? :)
Anybody know? Why was there a birthday icon and true false in the config?  < |
|
|
|
yeewah
Starting Member
1 Posts |
Posted - 09 February 2004 : 23:35:18
|
quote:
Originally posted by RichardE
UK Date Format - Using the Recurring Dates MOD - How can I change the date in post event to UK date format?
Anybody know how to do that? my forum is set to UK date format, but can't get the date in post event set to UK date format. Thanks! < |
Edited by - yeewah on 10 February 2004 04:25:25 |
|
|
|
jensen
New Member
United Kingdom
97 Posts |
Posted - 13 February 2004 : 08:12:09
|
installed this mod on 3.4.04 - allowing for line number changes, and all appears to work.
 Great work red1.
Is this mod still in beta form - or r u ready to issue
How do "popular mods", like this one get added to the next "base code" revision of snitz< |
Edited by - jensen on 13 February 2004 08:14:41 |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
golfmann
Junior Member
United States
450 Posts |
Posted - 17 February 2004 : 22:33:17
|
quote:
Originally posted by golfmann
quote:
Originally posted by golfmann
I see no birthdays...
Set to TRUE in Cal config.
What am I missing??? :)
Anybody know? Why was there a birthday icon and true false in the config?
Still wondering...< |
|
|
|
indianBoy
New Member
56 Posts |
Posted - 07 June 2004 : 05:53:42
|
i havent gone through all the 18 pages in this topic, so forgive me if i am representing this query:
How can i restrict a new even to be created only by an Admin or a Moderator?
after this has been solved : how can i restrict events to be created only in a particulat forum category? ( Like in the poll mod u can select in the dit foru cat properties, whether polls are allowed in this forum or not or whether who can post em )
< |
|
|
|
HuwR
Forum Admin
United Kingdom
20611 Posts |
Posted - 07 June 2004 : 06:03:02
|
quote:
Originally posted by indianBoy
i havent gone through all the 18 pages in this topic, so forgive me if i am representing this query:
How can i restrict a new even to be created only by an Admin or a Moderator?
after this has been solved : how can i restrict events to be created only in a particulat forum category? ( Like in the poll mod u can select in the dit foru cat properties, whether polls are allowed in this forum or not or whether who can post em )
It would help matters imensley if you did actually read the topic before asking your question, that is why they are here, if you don't bother reading them we may as well just delete everything rather than keep it.
If you are not willing to help yourself, why should we bother to help you.< |
|
|
|
indianBoy
New Member
56 Posts |
Posted - 08 June 2004 : 13:49:53
|
| i am indeed sorry fo this, just lost my patience after modding my forum so much.< |
|
|
|
Nertz
Junior Member
Canada
341 Posts |
Posted - 08 June 2004 : 14:15:30
|
quote:
Originally posted by indianBoy
How can i restrict a new even to be created only by an Admin or a Moderator?
after this has been solved : how can i restrict events to be created only in a particulat forum category? ( Like in the poll mod u can select in the dit foru cat properties, whether polls are allowed in this forum or not or whether who can post em )
In cal_config.asp,
to restrict event posting to admins and moderators only set Const intCalMLev = 3, 4 for admins only.
Events can only be created in the forums listed in the array arrCalForumID = Array(xx,yy,zz), where xx, yy, etc. are the forum ID numbers separated by commas where events may be posted.
cheers,
Nat
< |
Sadly, most Family Court Judges wrongfully reward opportunistic gold diggers
that use our children unjustly as "instruments" of power.
www.fathers-4-justice-canada.ca |
|
|
|
HgB
Starting Member
8 Posts |
Posted - 07 July 2004 : 13:23:54
|
Clng - Calendar Bug
My earlier post based upon invalid forum_id is incorrect.
The Clng() function (Cal.asp) returns a LONG INTEGER. This function has a limit to the value it can convert. Anything out of range generates the OVERFLOW error.
~line 1397 of Cal.ASP
If cLng(arrRqCalForumID) = cLng(ForumForumID) then strOptions = strOptions & " selected"
In Cal_Config.asp the server admin defines which FORUM_IDs are to be allowed to be posted in.
Cal_config.asp
arrCalForumID = Array(2, 3, 4, 17, 21, 20)
When cLng(arrRqCalForumID)funtion is performed it converts the array to a value of :
234,172,120.
No problem there as the value is between acceptable values for clng to convert. (2,147,483,648 and -2,147,483,647)
However if you add other forum_id's to the array in Cal_config that push the value past the converted LONG value that Clng can convert it ends up with the Clng OVERFLOW error.
I also can matter which order the numbers are listed in as it will push the envelope depending upon how they are ordered.
i.e.
forums 2, 14, 74, 8, 36, 47 will be acceptable.
2,147,483,647
However order of 47, 2, 14, 74, 8, 36 being ordered differently will generate the error condition.
Number of forums that calendar events can be posted in are directly related to this converted value.
We use a number of PRIVATE calendar events that different members are allowed to see. When I added a new one it went over the top again. Now I've got to eliminate events to allow use within a different forum ID.< |
|
|
|
HgB
Starting Member
8 Posts |
Posted - 07 July 2004 : 13:35:39
|
| Can you have an IF check on the length of arrRqCalForumID and only execute the Clng() function if the length is less than that of 9 characters (one digit less than INTEGER value of 2147483648)? That way you open it up and eliminate potential problems till someone has more than 999,999,999 forum_ids.< |
|
|
|
HgB
Starting Member
8 Posts |
Posted - 07 July 2004 : 13:45:52
|
Seems to work, but leave Red1 to direct a formal change:
[red]
If recForumCount <> "" then
For iForum = 0 to recForumCount
ForumForumID = allForumData(fFORUM_ID, iForum)
ForumSubject = allForumData(fF_SUBJECT, iForum)
strOptions = strOptions & "<option value=""" & ForumForumID & """"
if len(arrRqCalForumID) < 9 then
If cLng(arrRqCalForumID) = cLng(ForumForumID) then strOptions = strOptions & " selected"
end if
strOptions = strOptions & ">" & ChkString(left(ForumSubject, 50),"display") & "</option>" & vbNewline
Next
End if
< |
|
|
|
rfelker
Starting Member
14 Posts |
Posted - 28 August 2004 : 12:16:49
|
HgB,
i added those 2 lines to my code;
"if len(arrRqCalForumID) < 9 then
If cLng(arrRqCalForumID) = cLng(ForumForumID) then strOptions = strOptions & " selected"
end if"
and it also fixed the same problem on my forum.
thanks!< |
|
|
|
Topic |
|
MOD: New Events Calendar for 3.4.03 beta
