diff options
| author | matthiasgrimm <matthiasgrimm@users.sourceforge.net> | 2006-06-11 18:43:47 +0200 |
|---|---|---|
| committer | matthiasgrimm <matthiasgrimm@users.sourceforge.net> | 2006-06-11 18:43:47 +0200 |
| commit | 2f3dc51dfd3a547d110bd7c74738db705a75a963 (patch) | |
| tree | dcc4264a5d93bd15b8ad3b5984d22fb41d79f866 | |
| parent | cfedcd21efd6eb1725667b39229aa19c1493a7e1 (diff) | |
| download | rpg-2f3dc51dfd3a547d110bd7c74738db705a75a963.tar.gz rpg-2f3dc51dfd3a547d110bd7c74738db705a75a963.tar.bz2 | |
MySQL 3.23 compatibility issue
MySQL 3.23 doesn't support the keyword OFFSET in the LIMIT statement.
This patch changes the code to the second alternative syntax.
darcs-hash:20060611164347-7ef76-b38861cebe45604c253bd4436451825733fe7083.gz
| -rw-r--r-- | inc/auth/mysql.class.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/inc/auth/mysql.class.php b/inc/auth/mysql.class.php index 71788f57d..da89dd845 100644 --- a/inc/auth/mysql.class.php +++ b/inc/auth/mysql.class.php @@ -339,7 +339,7 @@ class auth_mysql extends auth_basic { if($this->_openDB()) { $this->_lockTables("READ"); $sql = $this->_createSQLFilter($this->cnf['getUsers'], $filter); - $sql .= " ".$this->cnf['SortOrder']." LIMIT $limit OFFSET $first"; + $sql .= " ".$this->cnf['SortOrder']." LIMIT $first, $limit"; $result = $this->_queryDB($sql); foreach ($result as $user) |