[geeklog-cvs] Geeklog-1.x/plugins/calendar/sql mssql_install.php, 1.4, 1.5 mysql_install.php, 1.2, 1.3

[Dirk Haun]

Update of /cvsroot/geeklog/Geeklog-1.x/plugins/calendar/sql
In directory qs1489.pair.com:/tmp/cvs-serv42113/calendar/sql

Modified Files:
	mssql_install.php mysql_install.php 
Log Message:
An attempt to update the MS SQL for the plugin installs (and no, I don't know what I'm doing ...)


Index: mssql_install.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/plugins/calendar/sql/mssql_install.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** mssql_install.php	27 Jan 2008 15:23:33 -0000	1.4
--- mssql_install.php	2 May 2008 12:08:07 -0000	1.5
***************
*** 7,11 ****
  // | Installation SQL                                                          |
  // +---------------------------------------------------------------------------+
! // | Copyright (C) 2000-2006 by the following authors:                         |
  // |                                                                           |
  // | Authors: Tony Bibbs        - tony AT tonybibbs DOT com                    |
--- 7,11 ----
  // | Installation SQL                                                          |
  // +---------------------------------------------------------------------------+
! // | Copyright (C) 2000-2008 by the following authors:                         |
  // |                                                                           |
  // | Authors: Tony Bibbs        - tony AT tonybibbs DOT com                    |
***************
*** 13,17 ****
  // |          Jason Whittenburg - jwhitten AT securitygeeks DOT com            |
  // |          Dirk Haun         - dirk AT haun-online DOT de                   |
! // |          Trinity Bays      - trinity AT steubentech DOT com               |
  // |          Randy Kolenko     - randy AT nextide DOT ca                      |
  // +---------------------------------------------------------------------------+
--- 13,17 ----
  // |          Jason Whittenburg - jwhitten AT securitygeeks DOT com            |
  // |          Dirk Haun         - dirk AT haun-online DOT de                   |
! // |          Trinity Bays      - trinity93 AT gmail DOT com                   |
  // |          Randy Kolenko     - randy AT nextide DOT ca                      |
  // +---------------------------------------------------------------------------+
***************
*** 34,38 ****
  // $Id$
  
- 
  $_SQL[] = "
  CREATE TABLE [dbo].[{$_TABLES['events']}] (
--- 34,37 ----
***************
*** 137,142 ****
  ";
  
  
- $_SQL[] = "INSERT INTO {$_TABLES['eventsubmission']} (eid, title, description, location, datestart, dateend, url, allday, zipcode, state, city, address2, address1, event_type, timestart, timeend) VALUES ('2006051410130162','Installed the Calendar plugin','Today, you successfully installed the Calendar plugin.','Your webserver',getdate(),getdate(),'http://www.geeklog.net/',1,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL)";
  $_SQL[] = "INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, tid, blockorder, content, onleft, phpblockfn, owner_id, group_id, perm_owner, perm_group) VALUES (1,'events_block','phpblock','Events','all',4,'',1,'phpblock_calendar',{$_USER['uid']},#group#,3,3)";
  
--- 136,141 ----
  ";
  
+ $_SQL[] = "INSERT INTO {$_TABLES['eventsubmission']} (eid, title, description, location, datestart, dateend, url, allday, zipcode, state, city, address2, address1, event_type, timestart, timeend) VALUES ('2008050110130162','Installed the Calendar plugin','Today, you successfully installed the Calendar plugin.','Your webserver',getdate(),getdate(),'http://www.geeklog.net/',1,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL)";
  
  $_SQL[] = "INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, tid, blockorder, content, onleft, phpblockfn, owner_id, group_id, perm_owner, perm_group) VALUES (1,'events_block','phpblock','Events','all',4,'',1,'phpblock_calendar',{$_USER['uid']},#group#,3,3)";
  

Index: mysql_install.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/plugins/calendar/sql/mysql_install.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_install.php	27 Jan 2008 15:23:33 -0000	1.2
--- mysql_install.php	2 May 2008 12:08:07 -0000	1.3
***************
*** 13,17 ****
  // |          Jason Whittenburg - jwhitten AT securitygeeks DOT com            |
  // |          Dirk Haun         - dirk AT haun-online DOT de                   |
! // |          Trinity Bays      - trinity AT steubentech DOT com               |
  // +---------------------------------------------------------------------------+
  // |                                                                           |
--- 13,17 ----
  // |          Jason Whittenburg - jwhitten AT securitygeeks DOT com            |
  // |          Dirk Haun         - dirk AT haun-online DOT de                   |
! // |          Trinity Bays      - trinity93 AT gmail DOT com                   |
  // +---------------------------------------------------------------------------+
  // |                                                                           |
***************
*** 119,123 ****
  ";
  
! $_SQL[] = "INSERT INTO {$_TABLES['eventsubmission']} (eid, title, description, location, datestart, dateend, url, allday, zipcode, state, city, address2, address1, event_type, timestart, timeend) VALUES ('2006051410130162','Installed the Calendar plugin','Today, you successfully installed the Calendar plugin.','Your webserver',CURDATE(),CURDATE(),'http://www.geeklog.net/',1,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL)";
  
  $_SQL[] = "INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, tid, blockorder, content, onleft, phpblockfn, owner_id, group_id, perm_owner, perm_group) VALUES (1,'events_block','phpblock','Events','all',4,'',1,'phpblock_calendar',{$_USER['uid']},#group#,3,3)";
--- 119,123 ----
  ";
  
! $_SQL[] = "INSERT INTO {$_TABLES['eventsubmission']} (eid, title, description, location, datestart, dateend, url, allday, zipcode, state, city, address2, address1, event_type, timestart, timeend) VALUES ('2008050110130162','Installed the Calendar plugin','Today, you successfully installed the Calendar plugin.','Your webserver',CURDATE(),CURDATE(),'http://www.geeklog.net/',1,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL)";
  
  $_SQL[] = "INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, tid, blockorder, content, onleft, phpblockfn, owner_id, group_id, perm_owner, perm_group) VALUES (1,'events_block','phpblock','Events','all',4,'',1,'phpblock_calendar',{$_USER['uid']},#group#,3,3)";