| Author |
 Topic  |
|
red1
Junior Member
355 Posts |
 Posted - 25 September 2002 : 07:53:19
|
NEW EVENTS CALENDAR MOD FOR SNITZ 3.4.03 beta
=============================================
by red1
This mod is still being tested. Do not install
on your live forums.
Last Updated 25 October 2002
This is a completely new mod and not an update of the old calendar mod. It works
differently in that the events are inserted in the topics table instead of a separate
events table. I thought of doing it this way so that you can have discussion threads
about the events.
If you don't want your events to be mixed up with all your topics, you can create
a new forum specifically for events and just place all event-related posts there.
THIS MAY STILL HAVE BUGS, SO INSTALL AT YOUR OWN RISK!!!
What's in here:
* Events posted as topics.
* Month calendar and upcoming/recent events displayed on default.asp
* Daily, Weekly, Monthly, Yearly, and Events List views.
* Internationalization-ready.
What's not:
* Events with repeating dates, because I personally don't need it. However if
anyone wants to adopt this mod to add new features, it's fine with me.
Download at http://www.snitzbitz.com
Demo here: http://red1.www2.dotnetplayground.com/forum/< |
My Mods:
New Events Calendar
New Non-database Active Users |
Edited by - red1 on 06 November 2002 22:19:26 |
|
|
Bookie
Average Member
USA
856 Posts |
|
|
Steve D.
Average Member
USA
640 Posts |
Posted - 25 September 2002 : 09:18:48
|
red1 I'm getting this error when I try to download the calendar
HTTP1.1 STATUS 403 Remote Access to this object forbidden This file cannot be directly accessed from a remote site, but must be linked through the Brinkster Member's site.< |
Swing Dancing Video Clips - It's All Swing! Forum |
 |
|
|
red1
Junior Member
355 Posts |
Posted - 25 September 2002 : 09:37:48
|
quote:
Originally posted by Steve D.
red1 I'm getting this error when I try to download the calendar
HTTP1.1 STATUS 403 Remote Access to this object forbidden This file cannot be directly accessed from a remote site, but must be linked through the Brinkster Member's site.
Yeah that's a brinkster thing. I fixed it.< |
My Mods:
New Events Calendar
New Non-database Active Users |
Edited by - red1 on 06 November 2002 22:21:18 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 25 September 2002 : 10:46:13
|
| I'll test it tonight< |
|
|
|
Del
Starting Member
8 Posts |
Posted - 25 September 2002 : 13:02:53
|
I have added this MOD to the Server Hacker Ful-MOD version of Snitz.
I have found a few issues so far mainly due to the code not being clean. I think it's just a matter of Server Hacker adding the MOD to his version of the forum.
I created a Calender Events Catagory and sub-forum to hold all the Calender Events. Otherwise, it wants to use the Announcements (or other selectable forum) for the events.
Error Encountered
------------------
Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/forum/topic.asp, line 938
" <tr>" & vbNewLine & _
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Page:
GET /forum/topic.asp
** I get this when trying to VIEW the event from either the calender section or the events forum.
---------------------
Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/forum/inc_mail.asp, line 210
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Page:
POST 460 bytes to /forum/register.asp
POST Data:
Refer=http%3A%2F%2F166.44.65.109%2Fforum%2Fdefault.asp&Email=111@111.com&Email2=&Email3=111@111.com&ReceiveEMail=1&AIM=&ICQ=&MSN=&YAHOO=&Homepage=http%3A%2F%2F&Link1=http%3A%2F%2F&Link2=http%3A%2F%2F& . . .
** I get this when I try to add new members to the forum.
Testing continues.
< |
|
|
|
red1
Junior Member
355 Posts |
Posted - 25 September 2002 : 15:27:39
|
quote:
Originally posted by Del
I have added this MOD to the Server Hacker Ful-MOD version of Snitz.
I have found a few issues so far mainly due to the code not being clean. I think it's just a matter of Server Hacker adding the MOD to his version of the forum.
I'm sorry I cannot help you with this because I'm not using ServerHacker's code. The install instructions uses the default files that came with 3.4.03
quote:
I created a Calender Events Catagory and sub-forum to hold all the Calender Events. Otherwise, it wants to use the Announcements (or other selectable forum) for the events.
This isn't a bug, this was how I designed it. Create a new forum for events, then place all event posts there.
< |
My Mods:
New Events Calendar
New Non-database Active Users |
|
|
|
jtcoyle
Starting Member
17 Posts |
Posted - 25 September 2002 : 16:36:11
|
Here is the error I am getting when following the instructions. I have Snitz 3.4.03
I get this error when runing dbs_events_mod.asp
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/forum/cal_functions.asp, line 59
Any help would be appricated
Joe< |
Edited by - jtcoyle on 25 September 2002 16:37:11 |
|
|
|
red1
Junior Member
355 Posts |
Posted - 25 September 2002 : 17:05:53
|
Sorry, I should have been more explicit with my instructions. You don't run dbs_events_mod.asp. To update the database:
1. Upload dbs_events_mod.asp to your forum folder.
2. Log-on as admin, then go to Admin options.
3. Click on Mod Setup
---a. If Mod Setup takes you to a page that says "Database Setup, Select the Mod from the list below... " and presents you with a selectbox, choose "New Events Calendar Mod for Snitz 3.4.02 if its not already selected, and Click "Update"
---b. If the Mod Setup page doesn't load, go back to Admin Options and choose "Alternative Mod Setup." You will see a textbox, an empty space for you to enter code. Open the file dbs_events_mod.asp in notepad and COPY and PASTE its contents into the textbox, and hit Submit.
Your Database should now be updated correctly.< |
My Mods:
New Events Calendar
New Non-database Active Users |
Edited by - red1 on 25 September 2002 17:20:33 |
|
|
|
jtcoyle
Starting Member
17 Posts |
Posted - 25 September 2002 : 17:52:37
|
OK, I started from scrach.
I first verified that snitz 3.4.03 was up and running.
I then uploaded the dbs_events_mod.asp into the forum directory.
I then when into the admin options and selected Mod Update. Your mod was listed there and I succesfully updated the data base.
I then extracted the following files into the forum directory:
cal.asp
cal_constants.asp
cal_default.asp
cal_functions.asp
cal_style.asp
I then extracted the following files into the image directory:
icon_event.gif
icon_leftarrow.gif
icon_rightarrrow.gif
I modified the the following files as oulined in the readme.txt file:
active.asp - 6 changes
admin_forums.asp - 4 changes
config.asp - 1 change
default.asp - 1 change
forum.asp - 6 changes
post.asp - 7 changes
post_info.asp - 6 changes
topic.asp - 5 changes
Once I finished updating all the files, I still get the following error.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/forum/cal_functions.asp, line 59
I guess I could have messed up one of the changes.
Any ideas?
JOe
< |
Edited by - jtcoyle on 25 September 2002 17:54:52 |
|
|
|
red1
Junior Member
355 Posts |
Posted - 25 September 2002 : 18:21:02
|
I'm assuming you didn't change anything in cal_functions.asp.
I rechecked my code and it looks ok, so I think this is a database error.
Were there no errors returned from Mod Setup?
Is this on a fresh install or do you have other mods installed?
If that's not the problem, you can post here again< |
My Mods:
New Events Calendar
New Non-database Active Users |
Edited by - red1 on 25 September 2002 18:26:55 |
|
|
|
jtcoyle
Starting Member
17 Posts |
Posted - 25 September 2002 : 18:38:33
|
I did not receive any errors when updating the data base.
I did not modify call_functions.asp.
I only have a chat mod installed. Very little code was modified to install this.
I just just went through all the files again from scratch and updated the code to make sure I did not make any mistakes. I still get the same error.
I think this is the line that the error is being reported on.
rs.open StrSql, My_conn, adOpenStatic
Here is the output from the update:
New Events Calendar Mod for Snitz 3.4.03
Adding Column T_EVENT_DATE...
ALTER TABLE FORUM_TOPICS ADD COLUMN T_EVENT_DATE varchar(50) NULL
Column added successfully
Adding Column T_ISEVENT...
ALTER TABLE FORUM_TOPICS ADD COLUMN T_ISEVENT int NULL
Column added successfully
UPDATE FORUM_TOPICS SET T_ISEVENT=0
Populating Current Records with new Default value
Table(s) updated
--------------------------------------------------------------------------------
Adding Column T_EVENT_DATE...
ALTER TABLE FORUM_A_TOPICS ADD COLUMN T_EVENT_DATE varchar(50) NULL
Column added successfully
Adding Column T_ISEVENT...
ALTER TABLE FORUM_A_TOPICS ADD COLUMN T_ISEVENT int NULL
Column added successfully
UPDATE FORUM_A_TOPICS SET T_ISEVENT=0
Populating Current Records with new Default value
Table(s) updated
--------------------------------------------------------------------------------
Database setup finished
Joe< |
Edited by - jtcoyle on 25 September 2002 18:46:43 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 25 September 2002 : 23:19:42
|
| Do you have a set of instructions to make this work with 3.4.02?< |
|
|
|
red1
Junior Member
355 Posts |
|
|
jtcoyle
Starting Member
17 Posts |
Posted - 26 September 2002 : 01:21:09
|
red1--Thanks and please let me know if you find an answer. I really want to get this to work.
Joe< |
|
|
|
red1
Junior Member
355 Posts |
|
|
Topic |
|
MOD: New Events Calendar for 3.4.03 beta
