diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2009-08-12 15:00:47 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2009-08-12 15:00:47 +0000 |
| commit | 09ad10a734c0993f9465e6ac3463951251602fc6 (patch) | |
| tree | 80b534897042b0bff883687f9248f67b7af393f6 /phpBB/includes/db/dbal.php | |
| parent | 45964352e37217277527480fcd89222b33c22280 (diff) | |
| download | forums-09ad10a734c0993f9465e6ac3463951251602fc6.tar forums-09ad10a734c0993f9465e6ac3463951251602fc6.tar.gz forums-09ad10a734c0993f9465e6ac3463951251602fc6.tar.bz2 forums-09ad10a734c0993f9465e6ac3463951251602fc6.tar.xz forums-09ad10a734c0993f9465e6ac3463951251602fc6.zip | |
ok, i am very sorry, but this needs to be fixed.
Generally, our config table is not really suited for holding large datasets. Because feed settings for the forums to enable news feeds and excluded forums rely on the forums itself we have decided to introduce a forum_options table where custom options can be stored.
Additionally, for this to work across all DBMS we support, we added a new method to the DBAL for the bitwise AND operator.
Also moved the forum/topic feed template variable to the location where they belong to (forum and topic view)
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9965 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/db/dbal.php')
| -rw-r--r-- | phpBB/includes/db/dbal.php | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/phpBB/includes/db/dbal.php b/phpBB/includes/db/dbal.php index 0e1d6cba33..5418ed394b 100644 --- a/phpBB/includes/db/dbal.php +++ b/phpBB/includes/db/dbal.php @@ -412,6 +412,24 @@ class dbal } /** + * Run binary AND operator on DB column. + * Results in sql statement: "{$column_name} & (1 << {$bit}) {$compare}" + * + * @param string $column_name The column name to use + * @param int $bit The value to use for the AND operator, will be converted to (1 << $bit). Is used by options, using the number schema... 0, 1, 2...29 + * @param string $compare Any custom SQL code after the check (for example "= 0") + */ + function sql_bit_and($column_name, $bit, $compare = '') + { + if (method_exists($this, '_sql_bit_and')) + { + return $this->_sql_bit_and($column_name, $bit, $compare); + } + + return $column_name . ' & ' . (1 << $bit) . (($compare) ? ' ' . $compare : ''); + } + + /** * Run more than one insert statement. * * @param string $table table name to run the statements on |