| 1 |
<?php |
<?php |
| 2 |
// $Id: og_blueprints.install,v 1.2 2008/04/17 21:17:25 sdboyer Exp $ |
// $Id: og_blueprints.install,v 1.2.2.1 2008/06/06 12:18:22 sdboyer Exp $ |
| 3 |
|
|
| 4 |
function og_blueprints_install() { |
function og_blueprints_install() { |
| 5 |
switch ($GLOBALS['db_type']) { |
switch ($GLOBALS['db_type']) { |
| 10 |
grouptype varchar(32) NOT NULL, |
grouptype varchar(32) NOT NULL, |
| 11 |
bid int(11) PRIMARY KEY, |
bid int(11) PRIMARY KEY, |
| 12 |
vid int(11) NOT NULL DEFAULT 0, |
vid int(11) NOT NULL DEFAULT 0, |
| 13 |
release_id int(4) NULL, |
release_id int(4) NULL, |
| 14 |
KEY (vid), |
KEY (vid), |
| 15 |
KEY bvid (bid, vid) |
KEY bvid (bid, vid) |
| 16 |
) /*!40100 DEFAULT CHARACTER SET utf8 */ |
) /*!40100 DEFAULT CHARACTER SET utf8 */ |
| 29 |
) /*!40100 DEFAULT CHARACTER SET utf8 */ |
) /*!40100 DEFAULT CHARACTER SET utf8 */ |
| 30 |
EOT |
EOT |
| 31 |
); |
); |
| 32 |
|
|
| 33 |
db_query(<<<EOT |
db_query(<<<EOT |
| 34 |
CREATE TABLE {og_blueprint} ( |
CREATE TABLE {og_blueprint} ( |
| 35 |
bid int(11) NOT NULL, |
bid int(11) NOT NULL, |
| 51 |
) /*!40100 DEFAULT CHARACTER SET utf8 */ |
) /*!40100 DEFAULT CHARACTER SET utf8 */ |
| 52 |
EOT |
EOT |
| 53 |
); |
); |
| 54 |
|
|
| 55 |
db_query(<<<EOT |
db_query(<<<EOT |
| 56 |
CREATE TABLE {og_blueprint_control} ( |
CREATE TABLE {og_blueprint_control} ( |
| 57 |
bid int(11) NOT NULL, |
bid int(11) NOT NULL, |
| 66 |
EOT |
EOT |
| 67 |
); |
); |
| 68 |
break; |
break; |
| 69 |
|
|
| 70 |
case 'pgsql': |
case 'pgsql': |
| 71 |
db_query(<<<EOT |
db_query(<<<EOT |
| 72 |
CREATE TABLE {og_bundle} ( |
CREATE TABLE {og_bundle} ( |
| 84 |
db_query(<<<EOT |
db_query(<<<EOT |
| 85 |
CREATE TABLE {og_bundle_revision} ( |
CREATE TABLE {og_bundle_revision} ( |
| 86 |
bid int(11) NOT NULL, |
bid int(11) NOT NULL, |
| 87 |
vid int(11) NOT NULL, |
vid int(11) NOT NULL, |
| 88 |
release_id integer(4) NOT NULL DEFAULT 0, |
release_id integer(4) NOT NULL DEFAULT 0, |
| 89 |
release_name varchar(128), |
release_name varchar(128), |
| 90 |
timestamp integer(11) NULL, |
timestamp integer(11) NULL, |
| 99 |
CREATE TABLE {og_blueprint} ( |
CREATE TABLE {og_blueprint} ( |
| 100 |
bid int(11) NOT NULL, |
bid int(11) NOT NULL, |
| 101 |
vid int(11) NOT NULL, |
vid int(11) NOT NULL, |
| 102 |
bpid int(11) NOT NULL, |
bpid int(11) NOT NULL, |
| 103 |
bpname varchar(32) NOT NULL, |
bpname varchar(32) NOT NULL, |
| 104 |
did int(11) NOT NULL DEFAULT 0, |
did int(11) NOT NULL DEFAULT 0, |
| 105 |
linked int(1) DEFAULT 1, |
linked int(1) DEFAULT 1, |
| 145 |
if (in_array($GLOBALS['db_type'], array('mysql', 'mysqli'))) { |
if (in_array($GLOBALS['db_type'], array('mysql', 'mysqli'))) { |
| 146 |
db_query("DELETE FROM {sequences} WHERE name IN ('{og_bundle}_bid', '{og_blueprint}_bpid')"); |
db_query("DELETE FROM {sequences} WHERE name IN ('{og_bundle}_bid', '{og_blueprint}_bpid')"); |
| 147 |
} |
} |
| 148 |
|
|
| 149 |
// Delete variables |
// Delete variables |
| 150 |
$variables = array('og_blueprints_mode', 'og_blueprints_list', 'og_blueprints_orphaned_bids'); |
db_query("DELETE FROM {variable} WHERE name LIKE ('og_blueprints%')"); |
| 151 |
|
/* $variables = array('og_blueprints_mode', 'og_blueprints_list', 'og_blueprints_orphaned_bids'); |
| 152 |
foreach ($variables as $variable) { |
foreach ($variables as $variable) { |
| 153 |
variable_del($variable); |
variable_del($variable); |
| 154 |
} |
}*/ |
| 155 |
} |
} |
| 156 |
|
|
| 157 |
/** |
/** |
| 163 |
} |
} |
| 164 |
|
|
| 165 |
/** |
/** |
| 166 |
* Smarter implementation of update_sql() that allows for args to be passed |
* Smarter implementation of update_sql() that allows for args to be passed |
| 167 |
* through the normal db_query escaping functions. So, mostly nicked from db_query() |
* through the normal db_query escaping functions. So, mostly nicked from db_query() |
| 168 |
* |
* |
| 169 |
*/ |
*/ |
| 172 |
array_shift($args); |
array_shift($args); |
| 173 |
if (isset($args[0]) and is_array($args[0])) { // 'All arguments in one array' syntax |
if (isset($args[0]) and is_array($args[0])) { // 'All arguments in one array' syntax |
| 174 |
$args = $args[0]; |
$args = $args[0]; |
| 175 |
} |
} |
| 176 |
$result = db_query($sql, $args); |
$result = db_query($sql, $args); |
| 177 |
_db_query_callback($args, TRUE); |
_db_query_callback($args, TRUE); |
| 178 |
$query = preg_replace_callback(DB_QUERY_REGEXP, '_db_query_callback', $sql); |
$query = preg_replace_callback(DB_QUERY_REGEXP, '_db_query_callback', $sql); |