![]() |
Quote:
|
Any way to get this to count bots as well?
|
Quote:
Quote:
|
This is the error I am recieving after installing everything. Can someone please tell me what I did wrong or how to fix this? Thanks!
Database error in vBulletin 3.5.1: 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 flashchat_connections as connections LEFT JOIN flashchat_rooms as rooms ON(connections.roomid = rooms.id) LEFT JOIN user as user ON(connections.userid = user.userid) LEFT JOIN usergroup as groupa ON(user.usergroupid = groupa.usergroupid) LEFT JOIN usergroup as groupb ON(user.displaygroupid = groupb.usergroupid) WHERE connections.userid > 0 AND connections.ip != '0.0.0.0' ORDER BY start; MySQL Error : Table 'texasatv_vbulletin.flashchat_connections' doesn't exist Error Number : 1146 Date : Saturday, November 26th 2005 @ 10:02:34 PM Script : http://69.16.204.245/forums/index.php Referrer : IP Address : 70.114.206.223 Username : Brandon Classname : vb_database |
Make sure the prefix defined in flashchat's config.srv.php is correct (i.e matches the actual prefix of your flashchat tables). atm it looks like it's set to 'flashchat_' , which appears to be wrong.
|
Quote:
texasatv_flashchat flashchat_bans flashchat_bot flashchat_bots flashchat_connections flashchat_conversationlog flashchat_dstore flashchat_gmcache flashchat_gossip flashchat_ignors flashchat_messages flashchat_patterns flashchat_rooms flashchat_templates flashchat_thatindex flashchat_thatstack flashchat_users Isn't this correct ?? I dont see what is wrong with the tables |
What is texasatv_flashchat ?
Also - if you want me to look at what's wrong then I need ftp access and an admin id with full permissions (inc running sql queries). I suggest you disable the product in the product manager until I can take a look. |
Okay, thanks for the PM, I have checked your system and the probem is that you have not installed flashchat as an integrated solution with vbulletin - it is installed as a totally seperate entity, even to the point of having it's own seperate database.
You cannot use this hack with such an installation - it requires you to have installed flashchat integrated with vb. :) |
How hard would it be or would it be possible to have it show in the users postbit or profile (preferably profile) that they're in the chat?
|
It wouldn't be very difficult - just add a plugin to global_start to scan the users in the chat and set a global variable to true if they are - that variable could then be used anywhere in the forum (like in a template conditional).
|
All times are GMT. The time now is 03:59 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|