Skadate Integration

[CMoss]

I am having trouble, and before I requested a ticket, I thought I'd crowd source a bit first. I have searched these forums, and have come up with nothing with reguards to installing ArrowChat into a Skadate installation. I followed the instructions provided, and have ArrowChat installed correctly. I don't seem to be having trouble with the database settings, but there are two areas I need help troubleshooting.

First, ArrowChat is reporting that no one is logged in. When I run the debug.php file, I get one red entry/error that

Code: Select all

User ID: 0 You are being registered as not logged in. If you are logged in, please check the functions_receive.php file to make sure the getUserID function is correct.

...all the other checks turn up green...

So I checked the functions_receive.php file, hard coded a user ID in the getUserID function (for testing only) so I could make sure ArrowChat at least worked with a single user, and ArrowChat opened the way it should have. I then noticed the second issue.

The user avatar/profile pic is blank. I looked over the database tables ArrowChat is looking at in order to pull the user image, and that table doesn't actually exist in my database...

Code: Select all

DB_USERTABLE_AVATAR','profile_photo

is not an actual column in the profile table of Skadate. I also noticed that if ArrowChat could not find a user image, it was set to default back to vm_gallery.png located in the Dreamdate theme of Skadate. I only have a single theme installed, and it's not Dreamdate.

Is there perhaps an easy fix with an updated functions_receive.php file, or is there something I will need to change in order to get this working the way my client needs it to. I'd much rather not go back to CometChat, since they offer next to no customer service.

Anyone, please help.

[Jason]

There is a small issue we are fixing with the 1.0.6 update, but I'm not sure it would apply to you if the profile_photo field doesn't even exist. Which version of SkaDate are you running? We've only setup the integration with v8 and I'm unaware if it would work with 7 or lower.

Here is the updated functions_receive.php file, it might fix the login issue:

http://www.mediafire.com/?fl4mahhixl66cws

[CMoss]

Thanks for the updated file. It has in fact solved the logged in user issue, but the avatars/user images are still blank.

I am using Skadate 8, the latest release, with a modified version of their Dark Passion template.

When I look at my installed database, the profile table has the following columns:

Code: Select all

profile_id
email
username
password
sex
match_sex
birthdate
headline
general_description
match_agerange
custom_location
country_id
zip
state_id
city_id
join_stamp
activity_stamp
membership_type_id 
affiliate_id 
email_verified
reviewed
has_photo
has_media
status
featured
register_invite_score
rate_score
rates
language_id 
join_ip
is_unsubscribed_mail
neigh_location
neigh_location_distance 
bg_color 
bg_image
bg_image_url
bg_image_mode
bg_image_status
has_music
is_private

I don't see the

Code: Select all

DB_USERTABLE_AVATAR','profile_photo

reference anywhere.

Any ideas on what may be different from mine and your versions. Even in the demo it seemed to work properly.

[CMoss]

So, I've searched some more, and it seems like I do have the Profile_Photo area, but it is its own table in the database, not a part of the Profile table...Is there something wrong with my config.php file maybe?

Code: Select all

<?php 
 
define('DB_SERVER','localhost'); 
define('DB_PORT','3306'); 
define('DB_USERNAME','xxxxxxx_skadate'); 
define('DB_PASSWORD','skadate'); 
define('DB_NAME','xxxxxxx_skadate'); 
define('TABLE_PREFIX','skadate_'); 
define('DB_USERTABLE','profile'); 
define('DB_USERTABLE_NAME','username'); 
define('DB_USERTABLE_USERID','profile_id'); 
define('DB_USERTABLE_AVATAR','profile_photo'); 
define('DB_FRIENDSTABLE','profile_friend_list'); 
define('DB_FRIENDSTABLE_USERID', 'profile_id'); 
define('DB_FRIENDSTABLE_FRIENDID', 'friend_id'); 
define('DB_FRIENDSTABLE_FRIENDS', 'Not Required'); 
include_once dirname(__FILE__).'/version.php';

$dbh = mysql_connect(DB_SERVER.':'.DB_PORT,DB_USERNAME,DB_PASSWORD); 
if (!$dbh) { 
   echo "<h3>Unable to connect to database. Please check details in configuration file.</h3>"; 
   exit(); 
} 
mysql_selectdb(DB_NAME,$dbh); 
mysql_query("SET NAMES utf8"); 
mysql_query("SET CHARACTER SET utf8"); 
mysql_query("SET COLLATION_CONNECTION = 'utf8_general_ci'"); 

?>

[Jason]

The avatars not working is probably just a matter of an incorrect path. Right click the blank image and select copy image URL to see where it's pointing.

[CMoss]

It's pointing to the correct reference: /$userfiles/view_'.$image.'.jpg'; but it's not loading anything, and when I look at the userfiles folder, There are no view_ images there. I do have full_size, and a few original images in there. I know Skadate is supposed to create these on the fly in php, but it doesn't seem to be loading them.

Also, when I edit the } else { return line, to:

Code: Select all

return $base_url.'../$userfiles/full_size_'.$image.'.jpg';

I get the avatars, but it take a long time for them to all load, and it's a waste of my server resources to compress those large images down into a tiny space for the chat window...

[CMoss]

HA! I changed over the code from this:

Code: Select all

   if (is_file(dirname(dirname(__FILE__)).'/$userfiles/view_'.$image.'.jpg')) {
      return $base_url.'../$userfiles/view_'.$image.'.jpg';
    } else {
        return $base_url.'../$userfiles/view_'.$image.'.jpg';

to this:

Code: Select all

   if (is_file(dirname(dirname(__FILE__)).'../$userfiles/thumb_'.$image.'.jpg')) {
      return $base_url.'../$userfiles/thumb_'.$image.'.jpg';
    } else {
        return $base_url.'../$userfiles/thumb_'.$image.'.jpg';
    }

and now I have my users avatars displayed. I takes a shorter time to load, and my users are happy for now...

...But this may be a temporary fix. Is this how it should be done?

[CMoss]

Any final decision on this issue? Am I the only customer with this bug/concern? My fix is working, but is this how it should be?

[Jason]

Sure, that setup will work fine.

[MQueen-Damiani]

Hi, can anyone upload or copy and paste the updated functions_receive.php file here so i can fix the problem above with users not showing online. Thx ;)

P.s how did you solve the users default pics not showing up, i have the same problem with skadate.

[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.