X-Cart forums - Events Calendar addin

Crunch42, I have also used this script and below is the information how to place this in your x-cart software.

I first made a static page in my admin area and called it "Calender of events", below is the code:

Code:





<IFRAME border=0 name=calender align=center marginWidth=1 marginHeight=1 src="../orgcal/view.php" frameBorder=0 width=100% scrolling=no height=700>

Your browser does not support inline frames or is currently configured not to display inline frames.

</IFRAME></P>

I placed the directory "orgcal" in my root, so it did not have anything to do with my xcart directory which is websitename/shopcart/ that's the reason for the "../orgcal/view.php" by using the ../ I just instructed to go back a directory and then into the orgcal directory.

Now the index.php that comes with the orgcal mod, just delete it, you dont need it.

What you do need is:
Folder: orgcal/js/
Folder: orgcal/js/overlib400/
Folder: orgcal/js/overlib400/mini/

Folder: orgcal/include/main.php
Folder: orgcal/include/db.php - This is the file you enter your MYSQL info

Code:

$OC_CONFIG['DBHOST'] = 'your database server'; // database server

$OC_CONFIG['DBUSER'] = 'database user';        // username

$OC_CONFIG['DBPASS'] = 'database password'; // password

$OC_CONFIG['DBNAME'] = 'database name'; // database name

$OC_CONFIG['DBTYPE'] = 'mysql';

Folder: orgcal/include/classes/
Folder: orgcal/include/classes/adodb400-lite/
Folder: orgcal/include/classes/adodb400-lite/lang/
Folder: orgcal/include/classes/adodb400-lite/drivers/
Folder: orgcal/include/classes/adodb400-lite/datadict/
Folder: orgcal/include/classes/adodb400-lite/CVS/

Folder: orgcal/images/up.gif - http://www.shisha.co.uk/orgcal/images/up.gif
Folder: orgcal/images/icon_edit.png - http://www.shisha.co.uk/orgcal/images/icon_edit.png
Folder: orgcal/images/icon_del.png - http://www.shisha.co.uk/orgcal/images/icon_del.png
Folder: orgcal/images/down.gif - http://www.shisha.co.uk/orgcal/images/down.gif
Folder: orgcal/images/calendar.gif - http://www.shisha.co.uk/orgcal/images/calendar.gif

Folder: orgcal/css/simplecalendar.css
Folder: orgcal/css/oc-week.css
Folder: orgcal/css/oc-month.css
Folder: orgcal/css/oc-minical.css
Folder: orgcal/css/oc-main.css
Folder: orgcal/css/oc-event.css
Folder: orgcal/css/oc-day.css

The php files
File: orgcal/user.php
File: orgcal/view.php
File: orgcal/minical.php
File: orgcal/event.php
File: orgcal/config.php

You can still download all these files (217 KB) from http://www.kevinsouthworth.com/Projects/OrgCal/tabid/60/Default.aspx

Thank you Kevin for a great mod :D

You can see the finished calender at: http://www.shisha.co.uk/shopcart/pages.php?pageid=25

Don't forget to add in the below patch file in admin/patch / upgrade section:

Code:



CREATE TABLE `config` (

  `config_name` varchar(45) NOT NULL default '',

  `config_value` varchar(100) default NULL,

  PRIMARY KEY  (`config_name`)

) TYPE=MyISAM;



INSERT INTO `config` VALUES ('week_starts_on_mon', 'N');

INSERT INTO `config` VALUES ('tz_offset', '0');

INSERT INTO `config` VALUES ('12_hour', 'Y');

INSERT INTO `config` VALUES ('time_in_link', 'Y');

INSERT INTO `config` VALUES ('name_in_link', 'Y');



CREATE TABLE `event` (

  `e_id` int(11) NOT NULL auto_increment,

  `e_override_id` int(11) default NULL,

  `e_ext_id` int(11) default NULL,

  `e_date` int(11) NOT NULL default '0',

  `e_time` varchar(6) default '-1',

  `e_duration` int(11) NOT NULL default '0',

  `e_repeat` char(1) default 'N',

  `e_access` char(1) default 'P',

  `e_name` varchar(80) NOT NULL default '',

  `e_description` text,

  PRIMARY KEY  (`e_id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;





CREATE TABLE `event_repeats` (

  `e_id` int(11) NOT NULL default '0',

  `e_type` varchar(20) default NULL,

  `e_end` int(11) default NULL,

  `e_frequency` int(11) default '1',

  `e_days` varchar(7) default NULL,

  PRIMARY KEY  (`e_id`)

) TYPE=MyISAM;





CREATE TABLE `event_repeats_not` (

  `e_id` int(11) NOT NULL default '0',

  `e_date` int(11) NOT NULL default '0',

  PRIMARY KEY  (`e_id`,`e_date`)

) TYPE=MyISAM;





CREATE TABLE `users` (

  `id` int(11) NOT NULL auto_increment,

  `uname` varchar(15) NOT NULL default '',

  `upass` varchar(15) NOT NULL default '',

  `ulevel` tinyint(1) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) TYPE=MyISAM AUTO_INCREMENT=2 ;





INSERT INTO `users` VALUES (1, 'admin', 'admin', 1);