[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.97,1.98

[dhaun at iowaoutdoors.org]

Update of /var/cvs/geeklog-1.3/sql
In directory www:/tmp/cvs-serv7378/sql

Modified Files:
	mysql_tableanddata.php 
Log Message:
Moved the list of sites to ping (weblog directory services like blo.gs) to the database.


Index: mysql_tableanddata.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.97
retrieving revision 1.98
diff -C2 -d -r1.97 -r1.98
*** mysql_tableanddata.php	29 Jan 2005 09:02:11 -0000	1.97
--- mysql_tableanddata.php	3 Feb 2005 19:57:40 -0000	1.98
***************
*** 596,599 ****
--- 596,611 ----
  
  $_SQL[41] = "
+ CREATE TABLE {$_TABLES['pingservice']} (
+   pid smallint(5) unsigned NOT NULL auto_increment,
+   name varchar(128) default NULL,
+   ping_url varchar(255) default NULL,
+   site_url varchar(255) default NULL,
+   method varchar(80) default NULL,
+   is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1',
+   PRIMARY KEY (pid),
+   INDEX pingservice_is_enabled(is_enabled)
+ ) TYPE=MyISAM
+ ";
+ $_SQL[41] = "
  CREATE TABLE {$_TABLES['staticpage']} (
    sp_id varchar(40) NOT NULL default '',
***************
*** 804,807 ****
--- 816,823 ----
  $_DATA[] = "INSERT INTO {$_TABLES['maillist']} (code, name) VALUES (1,'Email Headlines Each Night') ";
  
+ $_DATA[] = "INSERT INTO {$_TABLES['pingservice']} (pid, name, site_url, ping_url, method, is_enabled) VALUES (1, 'blo.gs', 'http://blo.gs/', 'http://ping.blo.gs/', 'weblogUpdates.extendedPing', 1)";
+ $_DATA[] = "INSERT INTO {$_TABLES['pingservice']} (pid, name, site_url, ping_url, method, is_enabled) VALUES (2, 'Weblogs.Com', 'http://www.weblogs.com/', 'http://rpc.weblogs.com/RPC2', 'weblogUpdates.ping', 1)";
+ $_DATA[] = "INSERT INTO {$_TABLES['pingservice']} (pid, name, site_url, ping_url, method, is_enabled) VALUES (3, 'Blogrolling.com', 'http://fresh.blogrolling.com/', 'http://rpc.blogrolling.com/pinger/', 'weblogUpdates.ping', 1)";
+ 
  $_DATA[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version, pi_gl_version, pi_enabled, pi_homepage) VALUES ('staticpages', '1.4.1','1.3.10',1,'http://www.tonybibbs.com') ";
  $_DATA[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version, pi_gl_version, pi_enabled, pi_homepage) VALUES ('spamx', '1.0.1','1.3.10',1,'http://www.pigstye.net/gplugs/staticpages/index.php/spamx') ";