Is the upgraded version supposed to work with the newly released FlashChat 4.0? If so, mine is not working . I logged into chat and refreshed the forum homepage to find it still said no users in chat. Is this supposed to be working with 4.0?
Is the upgraded version supposed to work with the newly released FlashChat 4.0? If so, mine is not working . I logged into chat and refreshed the forum homepage to find it still said no users in chat. Is this supposed to be working with 4.0?
The upgrade was nothing to do with any version of Flashchat, it was an alteration to take account of the displaygroupid in vB.
However, this hack works perfectly for Flashchat 4.0.0 (beta) - I have been running this version of the chat on our forum for 2/3 weeks now, so you must have made a mistake somewhere.
The upgrade was nothing to do with any version of Flashchat, it was an alteration to take account of the displaygroupid in vB.
However, this hack works perfectly for Flashchat 4.0.0 (beta) - I have been running this version of the chat on our forum for 2/3 weeks now, so you must have made a mistake somewhere.
I must, however FlashChat came out of beta on the 21. It worked well when I was working with the beta, but not now. I'll post up part of my index.php file and forumhome template
PHP Code:
}
// ############# Paul M - Flashchat - Who is in the chat v2.00 ###############
$chatlist = $DB_site->query("SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.start,
user.usergroupid, user.displaygroupid, user.options, user.username, groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM " . TABLE_PREFIX . "connections as connections
LEFT JOIN " . TABLE_PREFIX . "rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN " . TABLE_PREFIX . "user as user ON(connections.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start" );
unset($chatters);
$totalchatters = 0;
while ($chat = $DB_site->fetch_array($chatlist))
{
$totalchatters += 1;
$roomname = "In private room";
$chat['opentag'] = $chat['opentaga'] ;
$chat['closetag'] = $chat['closetaga'] ;
if ($chat['displaygroupid'])
{
$chat['opentag'] = $chat['opentagb'] ;
$chat['closetag'] = $chat['closetagb'] ;
}
if ($chat['ispublic']) { $roomname = "In ".$chat['name']; }
$chatters .= "<a href='member.php?u=$chat[userid]' title=\"$roomname\" >";
$chatters .= $chat['opentag'].$chat['username'].$chat['closetag']."</a>, ";
}
if ($chatters)
{
$chatters = substr($chatters, 0, strlen($chatters)-2);
}
else
{
$chatters = "No one is currently using the chat";
}
// ############# End of Who is in the chat ###############
Hmmm. I wasn't aware that it had been released in full - I'll grab the latest version then to see if anything has changed.
Yeah, there are now two VBCMPS files. VBCMPS2 being for 3.0.7. Also, I know commen.php and many other files changed drasticly. There were also changes to the MYSQL tables. This may be the problem.
PS: Do not install the bots, there is a bug where if you install them with a cms you will get call to undefined member errors. This is supposed to be fixed in a later release.
Well they really f**ked up from 4.0.0 beta to 4.0.1 didn't they - Yes, the BOTS are a pain - I had to edit proc.php despite turning them off.
The problem with the hack seems to be down to the fact that 4.0.1 now uses it's own table prefix system with vB - as well as the vB table prefix system - and to make it worse, there is an error in the CMS2 file as well. The default prefix they use seems to be "flashchat_", but you will find it in the config.srv.php file as below ;
Try the following experimental fix and let me know how it goes.
Find this in the Hack Code ;
PHP Code:
// ############# Paul M - Flashchat - Who is in the chat v2.00 ###############
$chatlist = $DB_site->query("SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.start,
user.usergroupid, user.displaygroupid, user.options, user.username, groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM " . TABLE_PREFIX . "connections as connections
LEFT JOIN " . TABLE_PREFIX . "rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN " . TABLE_PREFIX . "user as user ON(connections.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start" );
and replace it with this ;
PHP Code:
// ############# Paul M - Flashchat - Who is in the chat v2.05 ###############
require_once('./flashchat/inc/config.srv.php');
$fcprefix = $GLOBALS['fc_config']['db']['pref'];
$chatlist = $DB_site->query("SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.start,
user.usergroupid, user.displaygroupid, user.options, user.username, groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM " . TABLE_PREFIX . $fcprefix . "connections as connections
LEFT JOIN " . TABLE_PREFIX . $fcprefix . "rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN " . TABLE_PREFIX . "user as user ON(connections.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start" );
Can this be change to work with AMF FlashChat http://www.tufat.com/ simular but different. :ermm:
I can fiddle around with it but I am not a coder but know how to play with codes a little. :nervous:
Well they really f**ked up from 4.0.0 beta to 4.0.1 didn't they - Yes, the BOTS are a pain - I had to edit proc.php despite turning them off.
The problem with the hack seems to be down to the fact that 4.0.1 now uses it's own table prefix system with vB - as well as the vB table prefix system - and to make it worse, there is an error in the CMS2 file as well. The default prefix they use seems to be "flashchat_", but you will find it in the config.srv.php file as below ;
Try the following experimental fix and let me know how it goes.
Find this in the Hack Code ;
PHP Code:
// ############# Paul M - Flashchat - Who is in the chat v2.00 ###############
$chatlist = $DB_site->query("SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.start,
user.usergroupid, user.displaygroupid, user.options, user.username, groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM " . TABLE_PREFIX . "connections as connections
LEFT JOIN " . TABLE_PREFIX . "rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN " . TABLE_PREFIX . "user as user ON(connections.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start" );
and replace it with this ;
PHP Code:
// ############# Paul M - Flashchat - Who is in the chat v2.05 ###############
require_once('./flashchat/inc/config.srv.php');
$fcprefix = $GLOBALS['fc_config']['db']['pref'];
$chatlist = $DB_site->query("SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.start,
user.usergroupid, user.displaygroupid, user.options, user.username, groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM " . TABLE_PREFIX . $fcprefix . "connections as connections
LEFT JOIN " . TABLE_PREFIX . $fcprefix . "rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN " . TABLE_PREFIX . "user as user ON(connections.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start" );
Works great perfectly
However where it says
PHP Code:
require_once('./flashchat/inc/config.srv.php');
Should read
PHP Code:
require_once('./chat/inc/config.srv.php');
FlashChat 4.0.1 uses a folder called chat now instead of FlashChat. any new people that will use this hack will run into a file error if it is not changed. Either this, or it can be made a note in installation to change this variable to your directory .
Great job Paul
FlashChat 4.0.1 uses a folder called chat now instead of FlashChat. any new people that will use this hack will run into a file error if it is not changed. Either this, or it can be made a note in installation to change this variable to your directory .
Great job Paul
Don't you just love consistancy, why do they change things just for the sake of it.
I will make a note of it, people who upgrade from 3.x.x to 4.0.1 will probably retain the flashchat folder (as I did).
Don't you just love consistancy, why do they change things just for the sake of it.
I will make a note of it, people who upgrade from 3.x.x to 4.0.1 will probably retain the flashchat folder (as I did).
Yup, you have to love it
I myself just changed the folder to the name chat. I try to keep everything as it came as much as possible . Even with these problems some of which plain acts of negligence on the coding side my members still like 4.0.1, and that's what makes them and myself happy. *with the exception of installation, it was iKonboard all over again*