Version: , by Stasik
Developer Last Online: May 2009
Version: 2.2.x
Rating:
Released: 06-25-2001
Last Update: Never
Installs: 31
No support by the author.
Hi.... it is my first hack - phpProbe
here is it... it was tested under vbb2x RC2 and phpMyChat 0.14.4
News:
Updated on 19.07.01
- FAQ has been add
Updated on 18.07.01 The hack is compatible with version 0.14.5 of phpMyChat
- there is some javaScript code there, so the hack will not work with browsers without JS support (phpMyChat will not work with these browsers too )
- the Exit link in chat works ok now
Hack: Step 1:
open /lib/index.lib.php3 in yours phpMyChat Derictory
find:
PHP Code:
// Fix some security holes
replace it with
PHP Code:
//a VBB integration hack by Stasik (stasik@t-online.de)
//v0.1
//(C)2001
$exiturl = "http://www.blabla.com"; // the url the user will be redirected exiting the chat
if ($bbuserid == 0)
{
print "no"; //Message if the user has no cookie
exit;
}
else
{
if ($bbusername == "" || (isset($bbusername))==0)
{
$getusername=$DB_site->query_first("SELECT username FROM user WHERE userid=$bbuserid");
$username=$getusername[username];
$bbusername = $username;
}
else
{
$username = $bbusername;
} }
FAQ:
Q: I`m getting "no" every time.
A: You need to upgrade a cookie option in your VB control panel. Write under: Options->Change Options->[HTTP Headers and output]->Cookie Domain your domainname ONLY (blabla.com).
Q: I`m getting "you need to register" error.
A: Enable chat using for not registered users in your phpMyChat config (/config/config.lib.php3).
Q: I`m getting "wrong password" error.
A: Make shure you have deleted all user accounts in your chat and have only administrative one. If you are logging is as administrator note that you have to enter your password EVERY time you are logging in.
Questions or Bug reports?
Post it here I`ll answer ASAP.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
hey all...I was able to get it installed, and I was able to get it to work with the user table that vBulletin gives you (after making 4 other tables), now I keep getting this on the right frame:
Quote:
Invalid SQL: SELECT usr.username, usr.latin1, usr.status, reg.gender FROM c_users usr LEFT JOIN user reg ON usr.username = reg.username WHERE usr.room = 'Default' ORDER BY username
MySQL error: 1054 (Unknown column 'reg.gender' in 'field list')
Session halted
This worked great through all of the upgrades, but when I went to 2.2.6, only admin can get into the chat rooms. Everyone else gets the "NO" message. Any idea why??? I thought maybe I needed to reinstall something, but when I looked back over the instructions, all changes were made to the chat files only. HELP! I loved this integration!
They do ... I checked ot myself. I even have a test user name that I tried it with, but no go. These same users were able to access the chat room the day before the upgrade, but not afterwards.