2 replies to this topic

[bogge]

File Name: activecalendar-basic
File Submitter: bogge
File Submitted: 19 Sep 2007
File Category: 3rd Party Integration

This snippet integrates the Active Calendar with the Etomite CMS.

Demo and more information here.

Usage
[ !activecalendar-basic!]
[ !activecalendar-basic?enableWeekNum=true!] = Shows a month calendar with week numbers.
[ !activecalendar-basic?show=w&numberOfWeeks=2!] = Shows 2 weeks in 2rows

Note: You must have a working Active Calendar "installation" for this snippet to work.

Click here to download this file

[mike_e]

I'm trying to get this working, but having troubles.

I guessing that I need some help with the database stuff.

I modified the code for the active calendar source, but do not know what to change for the database.

I get following error.

« Error »

Etomite encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: SELECT UNIX_TIMESTAMP(***) AS ***, ***, *** FROM `chill_admin`.*** ;
[Copy SQL to ClipBoard]

Parser timing
MySQL: 0.0068 s s (2 Requests)
PHP: 0.0217 s s
Total: 0.0285 s s
Powered by Etomite CMS.

Any help greatly appreciated.

[bogge]

Look at the first 9 rows in the script. These are the requierd settings. Replace *** with your settings, and make sure you set the path to Active Calendar.

# Required settings  
## Database settings  
$tblname=isset($tblname)? $tblname: "***"; // the name of your MySQL Database Table  
$tblDateName=isset($tblDateName)? $tblDateName: "***"; // the name of your MySQL Table Date Field (datetime NOT NULL default '0000-00-00 00:00:00') ex. "NOW()"  
$tblContent=isset($tblContent)? $tblContent: "***"; // the name of your MySQL Table Content Field (char(250) NOT NULL default '') ex. "Google"  
$tblLink=isset($tblLink)? $tblLink: "***"; // the name of your MySQL Table Link Field (char(250) NOT NULL default '') ex. "http://www.google.com/"  
## Paths  
$path_to_ac = "activecalendar/source/activecalendar.php"; // Path to activecalendar.php  
$path_to_acw = "activecalendar/source/activecalendarweek.php"; // Path to activecalendarweek.php