diff options
Diffstat (limited to 'modules/block.module')
| -rw-r--r-- | modules/block.module | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/modules/block.module b/modules/block.module index 5ec29cc73..a6bac4fbb 100644 --- a/modules/block.module +++ b/modules/block.module @@ -67,7 +67,7 @@ function block_block($op = "list", $delta = 0) { return $blocks; } else { - $block = db_fetch_object(db_query("SELECT * FROM boxes WHERE bid = '%d'", $delta)); + $block = db_fetch_object(db_query("SELECT * FROM boxes WHERE bid = %d", $delta)); $data["subject"] = $block->title; $data["content"] = ($block->type == 1) ? eval($block->body) : $block->body; return $data; @@ -77,7 +77,7 @@ function block_block($op = "list", $delta = 0) { function block_admin_save($edit) { foreach ($edit as $module => $blocks) { foreach ($blocks as $delta => $block) { - db_query("UPDATE blocks SET region = '%s', status = '%d', custom = '%d', path = '%s', weight = '%d' WHERE module = '%s' AND delta = '%s'", + db_query("UPDATE blocks SET region = %d, status = %d, custom = %d, path = '%s', weight = %d WHERE module = '%s' AND delta = '%s'", $block["region"], $block["status"], $block["custom"], $block["path"], $block["weight"], $module, $delta); } } @@ -119,7 +119,7 @@ function _block_rehash($order_by = array("weight")) { } // reinsert blocks into table - db_query("INSERT INTO blocks (module, delta, status, weight, region, path, custom) VALUES ('%s', '%s', '%d', '%d', '%d', '%s', '%d')", + db_query("INSERT INTO blocks (module, delta, status, weight, region, path, custom) VALUES ('%s', '%s', %d, %d, %d, '%s', %d)", $block["module"], $block["delta"], $block["status"], $block["weight"], $block["region"], $block["path"], $block["custom"]); $blocks[] = $block; @@ -215,7 +215,7 @@ function block_admin_preview() { } function block_box_get($bid) { - return db_fetch_array(db_query("SELECT * FROM boxes WHERE bid = '%d'", $bid)); + return db_fetch_array(db_query("SELECT * FROM boxes WHERE bid = %d", $bid)); } function block_box_form($edit = array()) { @@ -243,18 +243,18 @@ function block_box_save($edit) { } if ($edit["bid"]) { - db_query("UPDATE boxes SET title = '%s', body = '%s', info = '%s', type = '%s' WHERE bid = '%d'", $edit["title"], $edit["body"], $edit["info"], $edit["type"], $edit["bid"]); + db_query("UPDATE boxes SET title = '%s', body = '%s', info = '%s', type = %d WHERE bid = %d", $edit["title"], $edit["body"], $edit["info"], $edit["type"], $edit["bid"]); return t("the block has been updated."); } else { - db_query("INSERT INTO boxes (title, body, info, type) VALUES ('%s', '%s', '%s', '%s')", $edit["title"], $edit["body"], $edit["info"], $edit["type"]); + db_query("INSERT INTO boxes (title, body, info, type) VALUES ('%s', '%s', '%s', %d)", $edit["title"], $edit["body"], $edit["info"], $edit["type"]); return t("the new block has been added."); } } function block_box_delete($bid) { if ($bid) { - db_query("DELETE FROM boxes WHERE bid = '%d'", $bid); + db_query("DELETE FROM boxes WHERE bid = %d", $bid); return t("the block has been deleted."); } } @@ -304,7 +304,7 @@ function block_admin() { function block_user($type, &$edit, &$user) { switch ($type) { case "register_form": - $result = db_query("SELECT * FROM blocks WHERE custom = '%d' ORDER BY module, delta", 1); + $result = db_query("SELECT * FROM blocks WHERE custom = %d ORDER BY module, delta", 1); while ($block = db_fetch_object($result)) { $form .= form_hidden("block][$block->module][$block->delta", $block->status); @@ -312,7 +312,7 @@ function block_user($type, &$edit, &$user) { return $form; case "edit_form": - $result = db_query("SELECT * FROM blocks WHERE custom = '%d' ORDER BY module, delta", 1); + $result = db_query("SELECT * FROM blocks WHERE custom = %d ORDER BY module, delta", 1); while ($block = db_fetch_object($result)) { $data = module_invoke($block->module, "block", "list"); |