[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.11_to_1.3.12.php,1.3,1.4

[dhaun at iowaoutdoors.org]

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

Modified Files:
	mysql_1.3.11_to_1.3.12.php 
Log Message:
Introduced a 'story.ping' permission, allowing users to send trackbacks / pings.


Index: mysql_1.3.11_to_1.3.12.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/updates/mysql_1.3.11_to_1.3.12.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mysql_1.3.11_to_1.3.12.php	28 Jan 2005 08:36:55 -0000	1.3
--- mysql_1.3.11_to_1.3.12.php	29 Jan 2005 09:02:11 -0000	1.4
***************
*** 20,22 ****
--- 20,39 ----
  $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD rdflimit smallint(5) unsigned NOT NULL default '0' AFTER rdfupdated";
  
+ $_SQL[] = "INSERT INTO {$_TABLES['features']} (ft_name, ft_descr, ft_gl_core) VALUES ('story.ping', 'Ability to send pings, pingbacks, or trackbacks for stories', 1)";
+ 
+ // add the new 'story.ping' feature to the Story Admin group
+ function upgrade_addFeature ()
+ {
+     global $_TABLES;
+ 
+     $grp_id = DB_getItem ($_TABLES['groups'], 'grp_id',
+                           "grp_name = 'Story Admin'");
+     $ft_id = DB_getItem ($_TABLES['features'], 'ft_id',
+                          "ft_name = 'story.ping'");
+ 
+     if (($grp_id > 0) && ($ft_id > 0)) {
+         DB_query ("INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES ($ft_id,$grp_id)");
+     }
+ }
+ 
  ?>