diff options
| author | Gábor Hojtsy <gabor@hojtsy.hu> | 2007-07-01 21:39:07 +0000 |
|---|---|---|
| committer | Gábor Hojtsy <gabor@hojtsy.hu> | 2007-07-01 21:39:07 +0000 |
| commit | a1a556b8c1904e624650059e7091f6864119cf65 (patch) | |
| tree | 33eb4310ea411a63a7e03b1156039d0837ff7e62 /modules | |
| parent | b33070d1762aa9f29bea0d6b286713dfad3bc461 (diff) | |
| download | brdo-a1a556b8c1904e624650059e7091f6864119cf65.tar.gz brdo-a1a556b8c1904e624650059e7091f6864119cf65.tar.bz2 | |
#155282 by Jose A Reyero: apply db_rewrite_sql() to the block listing query to allow for multilingual blocks
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/block/block.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/block/block.module b/modules/block/block.module index 10f3bf1a5..e77dd5637 100644 --- a/modules/block/block.module +++ b/modules/block/block.module @@ -683,7 +683,7 @@ function block_list($region) { static $blocks = array(); if (!count($blocks)) { - $result = db_query("SELECT DISTINCT b.* FROM {blocks} b LEFT JOIN {blocks_roles} r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = '%s' AND b.status = 1 AND (r.rid IN (%s) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module", $theme_key, implode(',', array_keys($user->roles))); + $result = db_query(db_rewrite_sql("SELECT DISTINCT b.* FROM {blocks} b LEFT JOIN {blocks_roles} r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = '%s' AND b.status = 1 AND (r.rid IN (%s) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module", 'b', 'bid'), $theme_key, implode(',', array_keys($user->roles))); while ($block = db_fetch_object($result)) { if (!isset($blocks[$block->region])) { $blocks[$block->region] = array(); |