Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 05:30 pm EST

Geeklog Forums

Geeklog Calendar Entries code for 2005-2010

04/10/07 10:55pm (Read 2,887 times)

Guy De Marco

Anonymous

There's probably someone who already did this, but I'd suggest having a group of pre-setup standard holidays for the calendar function. To get things started, here's a quick SQL list of common US, Canadian and religious holidays. It imported fine for me (http://www.nococomputers.com), and since I took the time to assemble these holidays from 2005-2010, I figured others may want to use it. Check it before importing, back up the dbase, yada yada. Here it is, just make sure you change the gl_events to the table you need, assuming you changed the default gl_ prefix of tables in your installation.

====CODE BEGINS HERE====

Text Formatted Code

INSERT INTO `gl_events` (`eid`, `title`, `description`, `postmode`, `datestart`, `dateend`, `url`, `hits`, `owner_id`, `group_id`, `perm_owner`, `perm_group`, `perm_members`, `perm_anon`, `address1`, `address2`, `city`, `state`, `zipcode`, `allday`, `event_type`, `location`, `timestart`, `timeend`) VALUES 

('2007040420075511', 'New Year\\''s Day', '', 'html', '2005-01-01', '2005-01-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075512', 'New Year\\''s Day', '', 'html', '2006-01-01', '2006-01-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075513', 'New Year\\''s Day', '', 'html', '2007-01-01', '2007-01-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075514', 'New Year\\''s Day', '', 'html', '2008-01-01', '2008-01-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075515', 'Martin Luther King Jr Day', 'USA', 'html', '2005-01-17', '2005-01-17', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075516', 'Martin Luther King Jr Day', 'USA', 'html', '2006-01-16', '2006-01-16', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075517', 'Martin Luther King Jr Day', 'USA', 'html', '2007-01-15', '2007-01-15', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075518', 'Martin Luther King Jr Day', 'USA', 'html', '2008-01-21', '2008-01-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075519', 'Martin Luther King Jr Day', 'USA', 'html', '2009-01-19', '2009-01-19', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075520', 'Martin Luther King Jr Day', 'USA', 'html', '2010-01-18', '2010-01-18', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075521', 'New Year\\''s Day', '', 'html', '2009-01-01', '2009-01-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075522', 'New Year\\''s Day', '', 'html', '2010-01-01', '2010-01-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075523', 'Chinese New Year', 'Rooster, Year 4703', 'html', '2005-02-09', '2005-02-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075524', 'Chinese New Year', 'Dog, Year 4704', 'html', '2006-01-29', '2006-01-29', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075525', 'Chinese New Year', 'Pig, Year 4705', 'html', '2007-02-18', '2007-02-18', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075526', 'Chinese New Year', 'Rat, Year 4706', 'html', '2008-02-07', '2008-02-07', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075527', 'Chinese New Year', 'Cow, Year 4707', 'html', '2009-01-26', '2009-01-26', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075528', 'Chinese New Year', 'Tiger, Year 4708', 'html', '2010-02-14', '2010-02-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075529', 'Lincoln\\''s Birthday', 'USA', 'html', '2005-02-12', '2005-02-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075530', 'Lincoln\\''s Birthday', 'USA', 'html', '2006-02-12', '2006-02-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075531', 'Lincoln\\''s Birthday', 'USA', 'html', '2007-02-12', '2007-02-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075532', 'Lincoln\\''s Birthday', 'USA', 'html', '2008-02-12', '2008-02-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075533', 'Lincoln\\''s Birthday', 'USA', 'html', '2009-02-12', '2009-02-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075534', 'Lincoln\\''s Birthday', 'USA', 'html', '2010-02-12', '2010-02-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075535', 'Valentine\\''s Day', '', 'html', '2005-02-14', '2005-02-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075536', 'Valentine\\''s Day', '', 'html', '2006-02-14', '2006-02-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075537', 'Valentine\\''s Day', '', 'html', '2008-02-14', '2008-02-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075538', 'Valentine\\''s Day', '', 'html', '2009-02-14', '2009-02-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075539', 'Valentine\\''s Day', '', 'html', '2010-02-14', '2010-02-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075540', 'President\\''s Day', 'USA', 'html', '2005-02-21', '2005-02-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075541', 'President\\''s Day', 'USA', 'html', '2006-02-20', '2006-02-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075542', 'President\\''s Day', 'USA', 'html', '2007-02-19', '2007-02-19', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075543', 'President\\''s Day', 'USA', 'html', '2008-02-18', '2008-02-18', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075544', 'President\\''s Day', 'USA', 'html', '2009-02-16', '2009-02-16', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075545', 'President\\''s Day', 'USA', 'html', '2010-02-15', '2010-02-15', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075546', 'Family Day', 'Canada', 'html', '2005-02-21', '2005-02-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075547', 'Family Day', 'Canada', 'html', '2006-02-20', '2006-02-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075548', 'Family Day', 'Canada', 'html', '2007-02-19', '2007-02-19', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075549', 'Family Day', 'Canada', 'html', '2008-02-18', '2008-02-18', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075550', 'Family Day', 'Canada', 'html', '2009-02-16', '2009-02-16', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075551', 'Family Day', 'Canada', 'html', '2010-02-15', '2010-02-15', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075552', 'Ash Wednesday', '', 'html', '2005-02-09', '2005-02-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075553', 'Ash Wednesday', '', 'html', '2006-03-01', '2006-03-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075554', 'Ash Wednesday', '', 'html', '2007-02-21', '2007-02-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075555', 'Ash Wednesday', '', 'html', '2008-02-06', '2008-02-06', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075556', 'Ash Wednesday', '', 'html', '2009-02-25', '2009-02-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075557', 'Ash Wednesday', '', 'html', '2010-02-17', '2010-02-17', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075558', 'Orthodox Lent', '', 'html', '2005-03-14', '2005-03-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075559', 'Orthodox Lent', '', 'html', '2006-03-06', '2006-03-06', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075560', 'Orthodox Lent', '', 'html', '2007-02-19', '2007-02-19', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075561', 'Orthodox Lent', '', 'html', '2008-03-10', '2008-03-10', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075562', 'Orthodox Lent', '', 'html', '2009-03-02', '2009-03-02', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075563', 'Orthodox Lent', '', 'html', '2010-02-15', '2010-02-15', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075564', 'Washington\\''s Birthday', 'USA', 'html', '2005-02-22', '2005-02-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075565', 'Washington\\''s Birthday', 'USA', 'html', '2006-02-22', '2006-02-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075566', 'Washington\\''s Birthday', 'USA', 'html', '2007-02-22', '2007-02-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075567', 'Washington\\''s Birthday', 'USA', 'html', '2008-02-22', '2008-02-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075568', 'Washington\\''s Birthday', 'USA', 'html', '2009-02-22', '2009-02-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075569', 'Washington\\''s Birthday', 'USA', 'html', '2010-02-22', '2010-02-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075570', 'Saint Patrick\\''s Day', '', 'html', '2005-03-17', '2005-03-17', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075571', 'Saint Patrick\\''s Day', '', 'html', '2006-03-17', '2006-03-17', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075572', 'Saint Patrick\\''s Day', '', 'html', '2008-03-17', '2008-03-17', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075573', 'Saint Patrick\\''s Day', '', 'html', '2009-03-17', '2009-03-17', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075574', 'Saint Patrick\\''s Day', '', 'html', '2010-03-17', '2010-03-17', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075575', 'Spring Equinox', '', 'html', '2005-03-20', '2005-03-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075576', 'Spring Equinox', '', 'html', '2006-03-20', '2006-03-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075577', 'Spring Equinox', '', 'html', '2007-03-21', '2007-03-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075578', 'Spring Equinox', '', 'html', '2008-03-20', '2008-03-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075579', 'Spring Equinox', '', 'html', '2009-03-20', '2009-03-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075580', 'Spring Equinox', '', 'html', '2010-03-20', '2010-03-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075581', 'Palm Sunday', '', 'html', '2005-03-20', '2005-03-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075582', 'Palm Sunday', '', 'html', '2006-04-09', '2006-04-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075583', 'Palm Sunday', '', 'html', '2007-04-01', '2007-04-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075584', 'Palm Sunday', '', 'html', '2008-03-16', '2008-03-16', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075585', 'Palm Sunday', '', 'html', '2009-04-05', '2009-04-05', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075586', 'Palm Sunday', '', 'html', '2010-03-28', '2010-03-28', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075587', 'Passover', '', 'html', '2005-04-24', '2005-04-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075588', 'Passover', '', 'html', '2006-04-13', '2006-04-13', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075589', 'Passover', '', 'html', '2007-04-03', '2007-04-03', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075590', 'Passover', '', 'html', '2008-04-20', '2008-04-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075591', 'Passover', '', 'html', '2009-04-09', '2009-04-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075592', 'Passover', '', 'html', '2010-03-30', '2010-03-30', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075593', 'Good Friday', '', 'html', '2005-03-25', '2005-03-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075594', 'Good Friday', '', 'html', '2006-04-14', '2006-04-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075595', 'Good Friday', '', 'html', '2007-04-06', '2007-04-06', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075596', 'Good Friday', '', 'html', '2008-03-21', '2008-03-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075597', 'Good Friday', '', 'html', '2009-04-10', '2009-04-10', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075598', 'Good Friday', '', 'html', '2010-04-02', '2010-04-02', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075599', 'Easter', '', 'html', '2005-03-27', '2005-03-27', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075100', 'Easter', '', 'html', '2006-04-16', '2006-04-16', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075101', 'Easter', '', 'html', '2008-03-23', '2008-03-23', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075102', 'Easter', '', 'html', '2009-04-12', '2009-04-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075103', 'Easter', '', 'html', '2010-04-04', '2010-04-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075104', 'Cinco de Mayo', '', 'html', '2005-05-05', '2005-05-05', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075105', 'Cinco de Mayo', '', 'html', '2006-05-05', '2006-05-05', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075106', 'Cinco de Mayo', '', 'html', '2008-05-05', '2008-05-05', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075107', 'Cinco de Mayo', '', 'html', '2009-05-05', '2009-05-05', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075108', 'Cinco de Mayo', '', 'html', '2010-05-05', '2010-05-05', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075109', 'Cinco de Mayo', '', 'html', '2007-05-05', '2007-05-05', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075110', 'Mother\\''s Day', '', 'html', '2005-05-08', '2005-05-08', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075111', 'Mother\\''s Day', '', 'html', '2006-05-14', '2006-05-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075112', 'Mother\\''s Day', '', 'html', '2007-05-13', '2007-05-13', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075113', 'Mother\\''s Day', '', 'html', '2008-05-11', '2008-05-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075114', 'Mother\\''s Day', '', 'html', '2009-05-10', '2009-05-10', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075115', 'Mother\\''s Day', '', 'html', '2010-05-09', '2010-05-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075116', 'Victoria Day', 'Canada', 'html', '2005-05-23', '2005-05-23', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075117', 'Victoria Day', 'Canada', 'html', '2006-05-22', '2006-05-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075118', 'Victoria Day', 'Canada', 'html', '2007-05-21', '2007-05-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075119', 'Victoria Day', 'Canada', 'html', '2008-05-20', '2008-05-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075120', 'Victoria Day', 'Canada', 'html', '2009-05-19', '2009-05-19', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075121', 'Victoria Day', 'Canada', 'html', '2010-05-24', '2010-05-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075122', 'Memorial Day', 'USA', 'html', '2005-05-30', '2005-05-30', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075123', 'Memorial Day', 'USA', 'html', '2006-05-29', '2006-05-29', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075124', 'Memorial Day', 'USA', 'html', '2007-05-28', '2007-05-28', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075125', 'Memorial Day', 'USA', 'html', '2008-05-26', '2008-05-26', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075126', 'Memorial Day', 'USA', 'html', '2009-05-25', '2009-05-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075127', 'Memorial Day', 'USA', 'html', '2010-05-31', '2010-05-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075128', 'Flag Day', 'USA', 'html', '2005-06-14', '2005-06-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075129', 'Flag Day', 'USA', 'html', '2006-06-14', '2006-06-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075130', 'Flag Day', 'USA', 'html', '2007-06-14', '2007-06-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075131', 'Flag Day', 'USA', 'html', '2008-06-14', '2008-06-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075132', 'Flag Day', 'USA', 'html', '2009-06-14', '2009-06-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075133', 'Flag Day', 'USA', 'html', '2010-06-14', '2010-06-14', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075134', 'Father\\''s Day', '', 'html', '2005-06-19', '2005-06-19', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075135', 'Father\\''s Day', '', 'html', '2006-06-18', '2006-06-18', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075136', 'Father\\''s Day', '', 'html', '2007-06-17', '2007-06-17', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075137', 'Father\\''s Day', '', 'html', '2008-06-15', '2008-06-15', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075138', 'Father\\''s Day', '', 'html', '2009-06-21', '2009-06-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075139', 'Father\\''s Day', '', 'html', '2010-06-20', '2010-06-20', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075140', 'Summer Solstice', '', 'html', '2005-06-21', '2005-06-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075141', 'Summer Solstice', '', 'html', '2006-06-21', '2006-06-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075142', 'Summer Solstice', '', 'html', '2007-06-21', '2007-06-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075143', 'Summer Solstice', '', 'html', '2008-06-21', '2008-06-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075144', 'Summer Solstice', '', 'html', '2009-06-21', '2009-06-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075145', 'Summer Solstice', '', 'html', '2010-06-21', '2010-06-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075146', 'St John-Baptiste Day', 'Quebec', 'html', '2005-06-24', '2005-06-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075147', 'St John-Baptiste Day', 'Quebec', 'html', '2006-06-24', '2006-06-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075148', 'St John-Baptiste Day', 'Quebec', 'html', '2007-06-24', '2007-06-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075149', 'St John-Baptiste Day', 'Quebec', 'html', '2008-06-24', '2008-06-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075150', 'St John-Baptiste Day', 'Quebec', 'html', '2009-06-24', '2009-06-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075151', 'St John-Baptiste Day', 'Quebec', 'html', '2010-06-24', '2010-06-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075152', 'Canada Day', 'Canada', 'html', '2005-07-01', '2005-07-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075153', 'Canada Day', 'Canada', 'html', '2006-07-01', '2006-07-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075154', 'Canada Day', 'Canada', 'html', '2007-07-01', '2007-07-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075155', 'Canada Day', 'Canada', 'html', '2008-07-01', '2008-07-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075156', 'Canada Day', 'Canada', 'html', '2009-07-01', '2009-07-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075157', 'Canada Day', 'Canada', 'html', '2010-07-01', '2010-07-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075158', 'Independence Day', 'US Fourth of July', 'html', '2005-07-04', '2005-07-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075159', 'Independence Day', 'US Fourth of July', 'html', '2006-07-04', '2006-07-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075160', 'Independence Day', 'US Fourth of July', 'html', '2007-07-04', '2007-07-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075161', 'Independence Day', 'US Fourth of July', 'html', '2008-07-04', '2008-07-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075162', 'Independence Day', 'US Fourth of July', 'html', '2009-07-04', '2009-07-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075163', 'Independence Day', 'US Fourth of July', 'html', '2010-07-04', '2010-07-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075164', 'Labor Day', 'USA and Canada', 'html', '2005-09-05', '2005-09-05', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075165', 'Labor Day', 'USA and Canada', 'html', '2006-09-04', '2006-09-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075166', 'Labor Day', 'USA and Canada', 'html', '2007-09-03', '2007-09-03', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075167', 'Labor Day', 'USA and Canada', 'html', '2008-09-01', '2008-09-01', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075168', 'Labor Day', 'USA and Canada', 'html', '2009-09-07', '2009-09-07', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075169', 'Labor Day', 'USA and Canada', 'html', '2010-09-06', '2010-09-06', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075170', 'Grandparent\\''s Day', '', 'html', '2005-09-11', '2005-09-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075171', 'Grandparent\\''s Day', '', 'html', '2006-09-10', '2006-09-10', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075172', 'Grandparent\\''s Day', '', 'html', '2007-09-09', '2007-09-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075173', 'Grandparent\\''s Day', '', 'html', '2008-09-07', '2008-09-07', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075174', 'Grandparent\\''s Day', '', 'html', '2009-09-13', '2009-09-13', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075175', 'Grandparent\\''s Day', '', 'html', '2010-09-12', '2010-09-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075176', 'Fall Equinox', '', 'html', '2005-09-22', '2005-09-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075177', 'Fall Equinox', '', 'html', '2006-09-23', '2006-09-23', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075178', 'Fall Equinox', '', 'html', '2007-09-23', '2007-09-23', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075179', 'Fall Equinox', '', 'html', '2008-09-22', '2008-09-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075180', 'Fall Equinox', '', 'html', '2009-09-22', '2009-09-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075181', 'Fall Equinox', '', 'html', '2010-09-23', '2010-09-23', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075182', 'Jewish New Year', '', 'html', '2005-10-04', '2005-10-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075183', 'Jewish New Year', '', 'html', '2006-09-23', '2006-09-23', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075184', 'Jewish New Year', '', 'html', '2007-09-13', '2007-09-13', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075185', 'Jewish New Year', '', 'html', '2008-09-30', '2008-09-30', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075186', 'Jewish New Year', '', 'html', '2009-09-19', '2009-09-19', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075187', 'Jewish New Year', '', 'html', '2010-09-09', '2010-09-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075188', 'Yom Kippur', '', 'html', '2005-10-13', '2005-10-13', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075189', 'Yom Kippur', '', 'html', '2006-10-02', '2006-10-02', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075190', 'Yom Kippur', '', 'html', '2007-09-22', '2007-09-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075191', 'Yom Kippur', '', 'html', '2008-10-09', '2008-10-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075192', 'Yom Kippur', '', 'html', '2009-09-28', '2009-09-28', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075193', 'Yom Kippur', '', 'html', '2010-09-18', '2010-09-18', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075194', 'Columbus Day', 'USA', 'html', '2005-10-10', '2005-10-10', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075195', 'Columbus Day', 'USA', 'html', '2006-10-09', '2006-10-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075196', 'Columbus Day', 'USA', 'html', '2007-10-08', '2007-10-08', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075197', 'Columbus Day', 'USA', 'html', '2008-10-13', '2008-10-13', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075198', 'Columbus Day', 'USA', 'html', '2009-10-12', '2009-10-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075199', 'Columbus Day', 'USA', 'html', '2010-10-11', '2010-10-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075200', 'Canadian Thanksgiving Day', 'Canada', 'html', '2005-10-10', '2005-10-10', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075201', 'Canadian Thanksgiving Day', 'Canada', 'html', '2006-10-09', '2006-10-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075202', 'Canadian Thanksgiving Day', 'Canada', 'html', '2007-10-08', '2007-10-08', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075203', 'Canadian Thanksgiving Day', 'Canada', 'html', '2008-10-13', '2008-10-13', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075204', 'Canadian Thanksgiving Day', 'Canada', 'html', '2009-10-12', '2009-10-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075205', 'Canadian Thanksgiving Day', 'Canada', 'html', '2010-10-11', '2010-10-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075206', 'Halloween', '', 'html', '2005-10-31', '2005-10-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075207', 'Halloween', '', 'html', '2006-10-31', '2006-10-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075208', 'Halloween', '', 'html', '2007-10-31', '2007-10-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075209', 'Halloween', '', 'html', '2008-10-31', '2008-10-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075210', 'Halloween', '', 'html', '2009-10-31', '2009-10-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075211', 'Halloween', '', 'html', '2010-10-31', '2010-10-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075212', 'Election Day', 'USA', 'html', '2006-11-07', '2006-11-07', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075213', 'Election Day', 'USA', 'html', '2008-11-04', '2008-11-04', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075214', 'Election Day', 'USA', 'html', '2010-11-02', '2010-11-02', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075215', 'Veteran\\''s Day', 'USA', 'html', '2005-11-11', '2005-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075216', 'Veteran\\''s Day', 'USA', 'html', '2006-11-11', '2006-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075217', 'Veteran\\''s Day', 'USA', 'html', '2007-11-11', '2007-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075218', 'Veteran\\''s Day', 'USA', 'html', '2008-11-11', '2008-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075219', 'Veteran\\''s Day', 'USA', 'html', '2009-11-11', '2009-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075220', 'Veteran\\''s Day', 'USA', 'html', '2010-11-11', '2010-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075221', 'Remembrance Day', 'Canada', 'html', '2005-11-11', '2005-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075222', 'Remembrance Day', 'Canada', 'html', '2006-11-11', '2006-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075223', 'Remembrance Day', 'Canada', 'html', '2007-11-11', '2007-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075224', 'Remembrance Day', 'Canada', 'html', '2008-11-11', '2008-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075225', 'Remembrance Day', 'Canada', 'html', '2009-11-11', '2009-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075226', 'Remembrance Day', 'Canada', 'html', '2010-11-11', '2010-11-11', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075227', 'Thanksgiving Day', 'USA', 'html', '2005-11-24', '2005-11-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075228', 'Thanksgiving Day', 'USA', 'html', '2006-11-23', '2006-11-23', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075229', 'Thanksgiving Day', 'USA', 'html', '2007-11-22', '2007-11-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075230', 'Thanksgiving Day', 'USA', 'html', '2008-11-27', '2008-11-27', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075231', 'Thanksgiving Day', 'USA', 'html', '2009-11-26', '2009-11-26', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075232', 'Thanksgiving Day', 'USA', 'html', '2010-11-25', '2010-11-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075233', 'Hanukkah', '', 'html', '2005-12-26', '2006-01-02', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075234', 'Hanukkah', '', 'html', '2006-12-16', '2006-12-23', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075235', 'Hanukkah', '', 'html', '2007-12-05', '2007-12-12', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075236', 'Hanukkah', '', 'html', '2008-12-22', '2008-12-29', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075237', 'Hanukkah', '', 'html', '2009-12-12', '2009-12-19', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075238', 'Hanukkah', '', 'html', '2010-12-02', '2010-12-09', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075239', 'Winter Solstice', '', 'html', '2005-12-21', '2005-12-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075240', 'Winter Solstice', '', 'html', '2006-12-22', '2006-12-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075241', 'Winter Solstice', '', 'html', '2007-12-22', '2007-12-22', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075242', 'Winter Solstice', '', 'html', '2008-12-21', '2008-12-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075243', 'Winter Solstice', '', 'html', '2009-12-21', '2009-12-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075244', 'Winter Solstice', '', 'html', '2010-12-21', '2010-12-21', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075245', 'Christmas Eve', '', 'html', '2005-12-24', '2005-12-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075246', 'Christmas Eve', '', 'html', '2006-12-24', '2006-12-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075247', 'Christmas Eve', '', 'html', '2007-12-24', '2007-12-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075248', 'Christmas Eve', '', 'html', '2008-12-24', '2008-12-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075249', 'Christmas Eve', '', 'html', '2009-12-24', '2009-12-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075250', 'Christmas Eve', '', 'html', '2010-12-24', '2010-12-24', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075251', 'Christmas Day', '', 'html', '2005-12-25', '2005-12-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075252', 'Christmas Day', '', 'html', '2006-12-25', '2006-12-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075253', 'Christmas Day', '', 'html', '2007-12-25', '2007-12-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075254', 'Christmas Day', '', 'html', '2008-12-25', '2008-12-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075255', 'Christmas Day', '', 'html', '2009-12-25', '2009-12-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075256', 'Christmas Day', '', 'html', '2010-12-25', '2010-12-25', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075257', 'Boxing Day', 'Canada', 'html', '2005-12-26', '2005-12-26', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075258', 'Boxing Day', 'Canada', 'html', '2006-12-26', '2006-12-26', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075259', 'Boxing Day', 'Canada', 'html', '2007-12-26', '2007-12-26', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075260', 'Boxing Day', 'Canada', 'html', '2008-12-26', '2008-12-26', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075261', 'Boxing Day', 'Canada', 'html', '2009-12-26', '2009-12-26', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075262', 'Boxing Day', 'Canada', 'html', '2010-12-26', '2010-12-26', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075263', 'New Year\\''s Eve', '', 'html', '2005-12-31', '2005-12-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075264', 'New Year\\''s Eve', '', 'html', '2006-12-31', '2006-12-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075265', 'New Year\\''s Eve', '', 'html', '2007-12-31', '2007-12-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075266', 'New Year\\''s Eve', '', 'html', '2008-12-31', '2008-12-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075267', 'New Year\\''s Eve', '', 'html', '2009-12-31', '2009-12-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00'),

('2007040420075268', 'New Year\\''s Eve', '', 'html', '2010-12-31', '2010-12-31', '',3,2,7,3,2,2,2,'','','','--','',1,'','','12:00:00','12:00:00')

;

====CODE ENDS HERE====

Enjoy, folks...
Guy

15 13 Quote

04/10/07 11:54pm

Guy De Marco

Anonymous

In case you want some wacky calendar entries, here's some more for 2007.

Text Formatted Code

INSERT INTO `gl_events` (`eid`, `title`, `description`, `postmode`, `datestart`, `dateend`, `url`, `hits`, `owner_id`, `group_id`, `perm_owner`, `perm_group`, `perm_members`, `perm_anon`, `address1`, `address2`, `city`, `state`, `zipcode`, `allday`, `event_type`, `location`, `timestart`, `timeend`) VALUES 

('2007040420070002', 'International Women\\''s Day', '', 'html', '2007-03-08', '2007-03-08', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070003', 'Hug a Cop Day', '', 'html', '2007-06-23', '2007-06-23', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070007', 'Loyalty Day', '', 'html', '2007-05-01', '2007-05-01', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070010', 'Evoloterra', 'Lunar Landing Anniversary', 'html', '2007-07-20', '2007-07-20', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070011', 'Festivus', '', 'html', '2007-12-23', '2007-12-23', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070012', 'Talk like a Pirate Day', 'Arrrgh...', 'html', '2007-09-19', '2007-09-19', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070013', 'Mole Day', '', 'html', '2007-10-23', '2007-10-23', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070014', 'Pi Day', '', 'html', '2007-03-14', '2007-03-14', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070015', 'Duga Duga Day', 'Must do the Chicken Dance on this day.', 'html', '2007-04-23', '2007-04-23', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070016', 'Towel Day', 'In memory of Douglas Adams.', 'html', '2007-05-25', '2007-05-25', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070017', 'X-Day', '', 'html', '2007-07-05', '2007-07-05', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070018', 'Peace Corps', 'Anniversary of the founding of the Peace Corps.', 'html', '2007-03-01', '2007-03-01', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070020', 'US Mint Founded', '', 'html', '2007-04-02', '2007-04-02', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070021', 'Army Day', '', 'html', '2007-04-06', '2007-04-06', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070022', 'National Tartan Day', '', 'html', '2007-04-06', '2007-04-06', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070023', 'Licorice Day', '', 'html', '2007-04-12', '2007-04-12', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070024', '1st McDonald\\''s Opens', '', 'html', '2007-04-15', '2007-04-15', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070025', 'Titanic Sank', '', 'html', '2007-04-15', '2007-04-15', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070026', 'Ides of March', '', 'html', '2007-03-15', '2007-03-15', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070028', 'Big Bird\\''s Birthday', '', 'html', '2007-03-20', '2007-03-20', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070030', 'International Earth Day', '', 'html', '2007-03-20', '2007-03-20', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070031', 'National Medal of Honor Day', '', 'html', '2007-03-25', '2007-03-25', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070032', 'National Library Week', '', 'html', '2007-04-15', '2007-04-15', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070033', 'Paul Revere\\''s Ride', '', 'html', '2007-04-18', '2007-04-18', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070034', 'Faith L. Miller Born', '', 'html', '2007-04-18', '2007-04-18', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070035', 'National Jelly Bean Day', '', 'html', '2007-04-22', '2007-04-22', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070036', 'National Park Week', '', 'html', '2007-04-21', '2007-04-28', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070037', 'Earth Day', '', 'html', '2007-04-22', '2007-04-22', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070038', 'Library of Congress Founded', '', 'html', '2007-04-24', '2007-04-24', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070039', 'Pretzel Day', '', 'html', '2007-04-26', '2007-04-26', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070041', 'National Pet Week', '', 'html', '2007-04-29', '2007-05-04', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070042', 'Empire State Bldg Completed', '', 'html', '2007-05-01', '2007-05-01', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070044', 'Mother Goose Day', '', 'html', '2007-05-01', '2007-05-01', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00'),

('2007040420070045', 'Cinco de Mayo', '', 'html', '2007-05-05', '2007-05-05', '', 3,2,7,3,2,2,2, '', '', '', '--', '', 1, '', '', '12:00:00', '12:00:00');

Enjoy!

Guy De Marco
http://www.NoCoComputers.com

9 11 Quote

04/11/07 01:01am

Status: offline

jmucchiello

Forum User

Full Member

Registered: 08/29/05

Posts: 985

Quote by: Guy De Marco

Check it before importing, back up the dbase, yada yada.

Pay special attention to owner_id and group_id. Owner_id in those statements is 2 and group_id is 7. That should be Admin and Calendar Admin respectively but if they aren't in your database, you will need to change those fields.

Guy, what does this have to do with GL2?

13 12 Quote

04/11/07 02:44am

Guy De Marco

Anonymous

I was hoping to have some of these included with the GL2 when it goes out, assuming the DB doesn't change much for the gl_events table. Since the calendar is essentially built-in now, I thought an option to actually populate it would be nice. If you think this should be relocated, that's fine. Also, good point about the owner_id, I should've noted it was put together for my GL 1.4.1 install.

Thanks,
Guy

7 14 Quote

04/11/07 07:34am

Status: offline

jmucchiello

Forum User

Full Member

Registered: 08/29/05

Posts: 985

Everything must be rewritten to work with GL2 so there's no telling if the events table will be similar between the two systems. This is part of the reason GL2 development is slow to move.

11 11 Quote

04/12/07 11:29am

Guy De Marco

Anonymous

Makes sense to me, thank you. Well, most of the grunt work is done, so hopefully it can be included as an option. Changing the structure should be an easy find-and-replace, if need be. I certainly wouldn't mind if the post were moved to somewhere that makes more sense. GL2 looks like it will be an interesting change from the current 1.4.1.

Thanks again, I've enjoyed reading your posts here.
Guy De Marco
http://www.nococomputers.com

8 11 Quote

New Topic Post Reply

All times are EST. The time is now 05:30 pm.

Normal Topic
Sticky Topic
Locked Topic

New Post
Sticky Topic W/ New Post
Locked Topic W/ New Post

View Anonymous Posts
Able to post
Filtered HTML Allowed
Censored Content

Geeklog Forums

Geeklog Calendar Entries code for 2005-2010

Guy De Marco

Guy De Marco

jmucchiello

Guy De Marco

jmucchiello

Guy De Marco

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks