vb.org Archive
Page 18 of 27 « First 81617 18 1920 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Flashchat: Who is chatting (https://vborg.vbsupport.ru/showthread.php?t=73042)

Paul M 05-16-2005 11:38 AM
Quote:
Originally Posted by Romeos Tune
Hey Paul,

I'm running VB3.03 and the latest FlashChat.... For some reason I'm getting this error. It's adding an extra vb3_ it seems when doing the queries.... I'm still too new to figure this out I guess..... Any help would be appreciated.....

Database error in vBulletin 3.0.3:

Invalid SQL: 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 vb3_vb3__fc_connections as connections
LEFT JOIN vb3_vb3__fc_rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN vb3_user as user ON(connections.userid = user.userid)
LEFT JOIN vb3_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb3_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start
mysql error: Table 'vb.vb3_vb3__fc_connections' doesn't exist

mysql error number: 1146
Which versions of flashchat, and this hack are you using ?

The 'vb3_' is your vB table prefix, because it assumes the flashchat tables were also created with this prefix. On top of this there is also a flashchat prefix which was added in 4.0.x which has complicated matters. Does your chat actually work ? What are you flashchat tables actually called ? What prefix (pref) is defined in your flashchat config.srv.php ?

esology 05-16-2005 12:19 PM
Quote:
Originally Posted by Paul M
Which versions of flashchat, and this hack are you using ?
FlashChat 4.0.6
Whos chatting Hack 2.16
Quote:
Originally Posted by Paul M
The 'vb3_' is your vB table prefix, because it assumes the flashchat tables were also created with this prefix. On top of this there is also a flashchat prefix which was added in 4.0.x which has complicated matters. Does your chat actually work ?
Yes, chat works fine
Quote:
Originally Posted by Paul M
What are you flashchat tables actually called ? What prefix (pref) is defined in your flashchat config.srv.php ?
vb3_fc

Paul M 05-16-2005 01:24 PM
Okay, looks like flashchat 4.0.x now ignores the vB prefix (except at install ?) and just uses it's own internal one.

Try replacing the code in index.php with this 2.17 version and let me know how it goes.

PHP Code:
// ## Paul M - Flashchat - Who is in the chat v2.17 ## //

$fcfolder = 'chat';
// ## Make sure the folder name defined above is the correct name of your flashchat installation folder ## //

$GLOBALS['fc_config_stop'] = true;
require_once("./" . $fcfolder . "/inc/common.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 " . $fcprefix . "connections as connections
LEFT JOIN " . $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" );
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 ############### 
If this cures it then I will update the first post.

esology 05-16-2005 01:42 PM
Thanks Paul! Works like a charm.

Paul M 05-16-2005 02:29 PM
Quote:
Originally Posted by esology
Thanks Paul! Works like a charm.
Good. I have updated the install file. I hope they don't change this behaviour again ......

Romeos Tune 05-16-2005 10:39 PM
Thanks Paul! That fixed my problem too.... Awesome! :)

dfaonxa 05-18-2005 04:58 AM
Just wanted to say thanks for the mod, works perfectly and so easy to install! Thanks! :up:

plateau 05-18-2005 10:53 AM
good job!

install clicked!!!

Cyricx 05-18-2005 06:57 PM
Running vb 3.0.7 and flash chat 4.0.6

Works great!! :)

No errors at all, only bug I noticed is that it counts bots as being in the room(bad), but doesn't list them in the Who's In Chat(good).

We have 1 bot in our chat so unfortunately it never thinks noone is in chat thought it will have a blank area where the names list heh.

Cyricx 05-18-2005 07:51 PM
the inthechat.php is missing the code to grab the template..

Find
Code:
?>

And Add ABOVE it:
Code:
eval('$home[$onlineid][\'content\'] = "' . fetch_template('adv_portal_ts') . '";');

Has the same problem as the forumhome section in counting bots though.


All times are GMT. The time now is 09:08 PM.
Page 18 of 27 « First 81617 18 1920 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01271 seconds
  • Memory Usage 1,763KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete