 |
 |
 |
 |
#313333 - 03/02/07 07:03 PM
Re: FlashChat with UBB.Threads 7.0.2
[Re: Gizmo]
|
Wizard
Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
|
|
|
Top
|
|
|
|
 |
 |
 |
 |
|
|
|
|
|
#313336 - 03/02/07 09:16 PM
Re: FlashChat with UBB.Threads 7.0.2
[Re: Gizmo]
|
Wizard
Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
|
found the issue, the table "USERS" was being referanced as "users"; a fix: Find: $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM {$GLOBALS['config']['TABLE_PREFIX']}users WHERE USER_LOGIN_NAME = ? LIMIT 1");
//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}users SET U_Laston = ?, U_SessionId = ? WHERE USER_DISPLAY_NAME = ?");
$this->getUserStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}users WHERE USER_ID = ? LIMIT 1");
$this->getUsersStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}users");
Replace With: $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE USER_LOGIN_NAME = ? LIMIT 1");
//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}USERS SET U_Laston = ?, U_SessionId = ? WHERE USER_DISPLAY_NAME = ?");
$this->getUserStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE USER_ID = ? LIMIT 1");
$this->getUsersStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS");
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
#313424 - 03/06/07 07:10 PM
Re: FlashChat with UBB.Threads 7.0.2
[Re: Daryl Fawcett]
|
Wizard
Registered: 01/10/00
Posts: 5354
Loc: Portland, OR, USA
|
It installs fine, however i have to login manually.
As for the commented out code, those are commented out lines from the 6.5 integration; do NOT uncomment them, they will not work, and it can make things not work at all.
As for auto logins, that'd use a cookie, you'll have to ask them at their site about using the ubb cookies to auto login.
I recommend making any requests on the ubb7 discussion on their site, such as having to use the display name vs login name, and any bugs you find.
|
|
Top
|
|
|
|
|
|
|
|
|
|
Previous Topic
Index