Page 1 of 1
Vbulletin 4.1.12 Integration Issue
PostPosted: 21 Apr 2012, 18:30
by FatherJuan
Free Trial
Vbulletin 4.1.12
When I enable members only chatting the bar doesn't show up. ArrowChat/Debug reports that Username is not set.
Chat works fantastic if I enable guests.
integration.php is the same as the functions_vbullettin at least as far as I can tell since it's encrypted.
PostPosted: 21 Apr 2012, 23:01
by Jason
Can you please copy and paste the includes/config.php here. Make sure to remove the username/password in that file first.
PostPosted: 22 Apr 2012, 16:01
by FatherJuan
- Code: Select all
<?php
/*
|| #################################################################### ||
|| # ArrowChat # ||
|| # ---------------------------------------------------------------- # ||
|| # Copyright ©2010-2012 ArrowSuites LLC. All Rights Reserved. # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- ARROWCHAT IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.arrowchat.com | http://www.arrowchat.com/license/ # ||
|| #################################################################### ||
*/
// Require any necessary external files for retrieving the user's session
require_once dirname(dirname(dirname(__FILE__)))."/includes/config.php";
/**
* The database information
*
* Your existing users and information should already be in this database. Do NOT create
* a new database for ArrowChat.
*/
define('DB_SERVER','localhost');
define('DB_USERNAME','myuser');
define('DB_PASSWORD','mypass');
define('DB_NAME','gatbriga_vbulletin');
/**
* The table prefix can be left blank. A quick example of what you should input here:
*
* Example - Pretend the following list are tables:
* phpbb_friends
* phpbb_threads
* phpbb_users
*
* In the example above, the prefix would be phpbb_ because everything starts with it.
*
* Example - Pretend the following list are tables:
* friends
* threads
* users
*
* In the example above, the prefix would be blank.
*/
define('TABLE_PREFIX','zp_');
/**
* These variables will help automatically connect your existing website with ArrowChat. Please
* review the descriptions below to better understand them. DO NOT INCLUDE THE PREFIX WITH THESE
* VALUES!
*
* DB_USERTABLE = The name of the user's table
* DB_USERTABLE_USERID = The field for the user ID in the user's table
* DB_USERTABLE_NAME = The field for the username in the user's table
* DB_USERTABLE_AVATAR = The field for the avatar (input the user ID field if none exists)
*
* DB_FRIENDSTABLE = (Optional) The name of the friend's table
* DB_FRIENDSTABLE_USERID = (Optional) The field for the user ID in the friend's table
* DB_FRIENDSTABLE_FRIENDID = (Optional) The field for the relationship/friend ID in the firned's table
* DB_FRIENDSTABLE_FRIENDS = (Optional) The field to check if the users are friends
*
* All the friends stuff is optional. If your site does not have a friend's system, leave the
* values blank and change the no friend system value.
*/
define('DB_USERTABLE','user');
define('DB_USERTABLE_NAME','username');
define('DB_USERTABLE_USERID','userid');
define('DB_USERTABLE_AVATAR','userid');
define('DB_FRIENDSTABLE','userlist');
define('DB_FRIENDSTABLE_USERID', 'userid');
define('DB_FRIENDSTABLE_FRIENDID', 'relationid');
define('DB_FRIENDSTABLE_FRIENDS', 'friend');
/**
* Friend System
*
* If your website does not have a friend system (ex: you want to display all online users) then
* change the value below from 0 to 1.
*/
define('NO_FREIND_SYSTEM', '0');
/**
* MSSQL Database
*
* If your database is MSSQL then change the value below from 0 to 1.
*/
define('MSSQL_DATABASE', '0');
// DO NOT EDIT BELOW THIS POINT
// Initiate a connection to the database
if (MSSQL_DATABASE == 1)
$db = new QuickMSDB(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false, false);
else
$db = new QuickDB(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false, false);
?>
PostPosted: 22 Apr 2012, 16:11
by Jason
Looks okay, but are you 100% sure the table prefix is "zp_"? Usually vBulletin prefix is blank.
PostPosted: 23 Apr 2012, 01:59
by FatherJuan
You were absolutely correct sir.
zp_ was the auto-detected prefix and I didn't bother to look to see if it was correct.
My apologies for being lazy.
Thank you for your quick response!
PostPosted: 23 Apr 2012, 02:11
by Jason
FatherJuan wrote:You were absolutely correct sir.
zp_ was the auto-detected prefix and I didn't bother to look to see if it was correct.
My apologies for being lazy.
Thank you for your quick response!
Yes, auto-detection isn't 100% correct, unfortunately :/
PostPosted: 23 Apr 2012, 11:01
by FatherJuan
Solved the original problem but seems to have opened up a new one.
Logged out users are still getting the bar despite guest access being denied and can view users online.
http://i135.photobucket.com/albums/q152 ... pture1.pnghttp://i135.photobucket.com/albums/q152 ... pture2.png
PostPosted: 23 Apr 2012, 11:03
by FatherJuan
I have deselected show all online users and now they can't see people when not logged in, but the bar still displays.
PostPosted: 23 Apr 2012, 14:53
by Jason
Just tested this out and there was indeed an issue. Please re-download the trial and go into the includes/functions/integrations folder and rename the functions_vbulletin.php file to integration.php and place it in your includes folder.
So it would look like:
includes/functions/integrations/functions_vbulletin.php => includes/integration.php
I also fixed the problem with the avatars. Just download the attached file (ccpic.php) and place it in the root of your vbulletin folder (ex: /forum/ccpic.php).
PostPosted: 24 Apr 2012, 09:59
by nayo
I can not make them show online users, this makes it difficult to have a chat available. Someone can help me?
PostPosted: 26 Apr 2012, 12:00
by FatherJuan
nayo,
As Jason said, make sure your table prefix is correct. It should probably be blank.
Also you might need to delete all the arrowchat tables and re-install.
Chat has been working perfectly for days now and we are definitely going to purchase it.
Topic Closed
PostPosted: 07 Nov 2012, 12:40
by Staff Bot
This thread has been locked because the last post is greater than six months old. There is a good chance that the information in this thread is outdated. Please open a new topic if you wish to discuss this further.