| Author |
 Topic  |
|
Aznknight
Senior Member
USA
1373 Posts |
 Posted - 01 February 2001 : 06:04:20
|
To celebrate my recent title change and my 500th post, I've updated and enhance my Calendar MOD and re-releasing it.
new to this version of the mod.
-support of forum dates
-private events
(both features thanks to Huwr)
-view by week
-posting options
-sql server 7 and 2000 compatibility
-layout changes
-dates on both the small and big calendars match now
-and many subtle functionalities the first one lacked
-also more verstatile
demo: www.calvsa.net/snitz31sr4/events.asp
code: www.calvsa.net/snitz31sr4/eventsV2.zip
just the events.asp page for those that already have the others files and want the latest events.asp page:
www.calvsa.net/snitz31sr4/events.txt
I've tested this for both access and sql server databases and it worked fine for me.
If you have problems with this mod, post it to HELP: MOD implementation
NOTE: if you've already installed the original calendar mod, you have to rebuild the database table as well as replace the events files.
- Alan
Edited by - aznknight on 01 February 2001 06:10:13
Edited by - aznknight on 02 February 2001 12:52:00 |
|
|
KXS
New Member
Canada
66 Posts |
Posted - 01 February 2001 : 06:31:55
|
Kewl, looks like I'm one the first ones to give this baby a shot, thank you sir...
BTW - Congrats on your commitment, keep it moving bro...
------------------
"keeping it real"
Edited by - KXS on 13 February 2001 09:52:02 |
 |
|
|
tteal
Junior Member
USA
438 Posts |
Posted - 01 February 2001 : 11:18:36
|
Thanks for the awesome mods. Just a quick question....
- How is the private/public supposed to work/function? I noticed it's 0/1 based, however, when is the user supposed to see private?
For instance, right now I have 3 events under userid="xx" and cannot see them.
Any help understanding the public/private would be greatly appreciated.
Thanks,
Tim
Cheers,
Tim
http://www.free-guestbook.com |
|
|
|
Kerry
Average Member
USA
553 Posts |
Posted - 01 February 2001 : 11:27:25
|
Tim,
Are logged in as an Admin or Moderator? -I think this was a problem (at least on my install) with HuwR's implementation. Try adding a private event as a general user.
-Kerry
|
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 01 February 2001 : 11:31:32
|
Great MOD, I enjoyed the first version, although I did add one thing: I have noticed if there are allot of events on 1 day. The table size just keeps increasing. Imagine if there are 15 or 20 events in one day. (This could happen on a forum that is very active)
Adding this after this:
'-------------------------------------------------------------------------
' This routine prints the individual table divisions for days of the month
'-------------------------------------------------------------------------
look for this:
do while not(rsevents.EOF)
then add this directly after it:
numberofevents = numberofevents + 1
if numberofevents > 3 then %>
<a href="<% =sScript & "?date=" & Server.URLEncode(dToday) %>">more...</a>
<%
exit do
end if
P.S. You guys like that color coding of the script...
That is my current project I am working on. It is called a Snitz Forum Script Color Coding. I have most of the major tags working but I have found a few bugs... When completed it will work in the [code] tags. When you type in the code, it will add all of the forum code to the tags. I think you all will like it when it is finished. (Sorry for the quick plug in ad here  )
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
tteal
Junior Member
USA
438 Posts |
|
|
KXS
New Member
Canada
66 Posts |
Posted - 01 February 2001 : 12:22:11
|
quote:
Thanks for the awesome mods. Just a quick question....
- How is the private/public supposed to work/function? I noticed it's 0/1 based, however, when is the user supposed to see private?
For instance, right now I have 3 events under userid="xx" and cannot see them.
Any help understanding the public/private would be greatly appreciated.
Thanks,
Tim
Cheers,
Tim
http://www.free-guestbook.com
After reading your post I decided to try the private feature, and it does the same thing as you mentioned...
I did create this with a general user, as well as an admin user, and was unable to view my events...
------------------
"keeping it real" |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 01 February 2001 : 12:27:11
|
quote:
Thanks for the awesome mods. Just a quick question....
- How is the private/public supposed to work/function? I noticed it's 0/1 based, however, when is the user supposed to see private?
For instance, right now I have 3 events under userid="xx" and cannot see them.
Any help understanding the public/private would be greatly appreciated.
Thanks,
Tim
Cheers,
Tim
http://www.free-guestbook.com
Hey Tim,
Private version is based on 1 and 0.
If an event is private, check to see if the strDBNTSQLName = the named associated with the the event. I caded lcase function to it so that it's case-insensitive which I thought fixed the private events for the "Admin".
The login "Admin" seems to be a special case. Don't add private events with it because you might not be able to see the private event. It seems to only apply to that one account though. You can add a private event as another login with admin level status and it'll work fine.
- Alan
|
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 01 February 2001 : 13:27:31
|
Are SQL Server 6.5/7/2000 the only supported DB's? Or is MS Access 97/2000 and MSDE and MySQL also supported?
Reinsnitz (Mike)
><)))'>
"Blessed are those who hear the word of God and obey it." - Luke 11:28
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 01 February 2001 : 13:47:27
|
this mod works with both access database but I think the connection string has to be the one for access 2000.
I've test this in sql server 7 and 2000 and it works great. I haven't tried this on sql 6.5, mysql, or through MSDE though.
- Alan
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 February 2001 : 19:27:03
|
ARGH!!
Alan why are your files Read-Only? I want to replace the events.gif file with another file I have. Firstly it wouldn't let me save the new image over the current events.gif. So I deleted the image and saved the new one. Ok good. Next I wanted to change the image width and height in the events.asp file but that's read-only too!!!
Also, I'm getting a javascript error when changing the screensize, when adding a new event. But I won't even try to debug what's wrong with the script cause the file is Read-Only.
By the way, how do you save a file as read-only?
*----*----*----*----*----*----*----*----*
"Even when you feel you have nothing left,
You still have prayer--And that's enough."
*----*----*----*----*----*----*----*----* |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 February 2001 : 19:30:00
|
Ok, well I got around it by copying the code from the file, delete it, create a new file and paste the code in and save it as events.asp.
I figured out the problem with the javascript error. You have:
document.eventfrm.EVENT_DETAILS.cols
and
document.eventfrm.EVENT_DETAILS.rows
when it should be:
document.PostTopic.Message.cols
and
document.PostTopic.Message.rows.
*----*----*----*----*----*----*----*----*
"Even when you feel you have nothing left,
You still have prayer--And that's enough."
*----*----*----*----*----*----*----*----*
Edited by - Davio on 01 February 2001 19:50:36 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 February 2001 : 19:42:57
|
Davio, In Windows just right click on the file, choose properties and then uncheck the box labeled "Read Only". That will change the files to not be read only.
You can make files read-only using the same procedure.
Or from DOS you can use ATTRIB +r to make it read-only and ATTRIB -r to make change it to not be read-only. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 February 2001 : 19:56:02
|
Ok. Gotcha. Was actually trying to do it from my editor and didn't see any option to change the file from Read-Only. I was like, getting frustrated and stuff. LoL
Thanks anyway Rich.
*----*----*----*----*----*----*----*----*
"Even when you feel you have nothing left,
You still have prayer--And that's enough."
*----*----*----*----*----*----*----*----* |
|
|
|
pinozz
New Member
53 Posts |
Posted - 01 February 2001 : 20:12:28
|
Any changes needed for snitz3.1 SR3?
Edited by - pinozz on 01 February 2001 20:12:57 |
|
|
|
rafa
Starting Member
Spain
10 Posts |
Posted - 01 February 2001 : 22:18:28
|
"Need" a eventstable_setup.asp working on access 97. My ISP don't allow uploads >300 Kb (don't ask me why), and my mdb is *BIGGER* than 300. After lot of tries, can't create table manually on access 2000, convert to access 97, deleting posts, users & compact to get an mdb lower than 300
If anybody here knows how can I solve this or have an eventstable_setup.asp working on access 97, feel free to post or email me...
|
|
|
|
Topic |
|
Topic Locked
