diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-07-04 17:19:00 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-07-04 17:19:00 +0000 |
| commit | 055fe9e82dc15c84dbdad866e8a486397d32cfe9 (patch) | |
| tree | 80ae44e1b48ee1fd7440655574ff1b2641e96078 /phpBB/adm/admin_ban.php | |
| parent | c220126bbd1bac33ca4bf1e13bf2d95a5b980124 (diff) | |
| download | forums-055fe9e82dc15c84dbdad866e8a486397d32cfe9.tar forums-055fe9e82dc15c84dbdad866e8a486397d32cfe9.tar.gz forums-055fe9e82dc15c84dbdad866e8a486397d32cfe9.tar.bz2 forums-055fe9e82dc15c84dbdad866e8a486397d32cfe9.tar.xz forums-055fe9e82dc15c84dbdad866e8a486397d32cfe9.zip | |
sqlite support UNION ALL SELECT method
git-svn-id: file:///svn/phpbb/trunk@4203 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/adm/admin_ban.php')
| -rw-r--r-- | phpBB/adm/admin_ban.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/phpBB/adm/admin_ban.php b/phpBB/adm/admin_ban.php index 7299e20b1c..efed0370c9 100644 --- a/phpBB/adm/admin_ban.php +++ b/phpBB/adm/admin_ban.php @@ -257,11 +257,12 @@ if (isset($_REQUEST['bansubmit'])) break; case 'mssql': + case 'sqlite': $sql .= (($sql != '') ? ' UNION ALL ' : '') . " SELECT $ban_entry, $current_time, $ban_end, $ban_exclude, '$ban_reason'"; break; default: - $sql = "INSERT INTO " . BANLIST_TABLE . " ($type, ban_start, ban_end, ban_exclude, ban_reason) + $sql = 'INSERT INTO ' . BANLIST_TABLE . " ($type, ban_start, ban_end, ban_exclude, ban_reason) VALUES ($ban_entryx, $current_time, $ban_end, $ban_exclude, '$ban_reason')"; $db->sql_query($sql); $sql = ''; @@ -270,7 +271,7 @@ if (isset($_REQUEST['bansubmit'])) if ($sql != '') { - $sql = "INSERT INTO " . BANLIST_TABLE . " ($type, ban_start, ban_end, ban_exclude, ban_reason) + $sql = 'INSERT INTO ' . BANLIST_TABLE . " ($type, ban_start, ban_end, ban_exclude, ban_reason) VALUES $sql"; $db->sql_query($sql); } |