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.png
http://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.