ArrowChat (SOLVED)

flyalaska · February 17, 2013

Is anyone using ArrowChat, and able to get it to use the phpvms database? - http://www.arrowchat.com

Strider · February 17, 2013

I dont have it, but I would not say it would be that hard to get it to use the phpvms db.

freshJet · February 17, 2013

Agreed, should be easy to make the members list your pilots.

flyalaska · February 17, 2013

I been trying to get this to work for a few months now. Only able to get to work with my IPB, Not many people stay connected to IPB. Here is the details that I need, if someone can help me out.

User Table

Username Field

User Avatar Field

Strider · February 17, 2013

Unfortunately I do not have it. But I can purchase it in the next few weeks and help out, and if I can get it to work, I will let ya know how.

flyalaska · February 17, 2013

Unfortunately I do not have it. But I can purchase it in the next few weeks and help out, and if I can get it to work, I will let ya know how.

Don't buy it on my account. If you were already planing on it, I would really appreciate it.

Vangelis · July 10, 2013

Have you managed to conect it ?

flyalaska · July 12, 2013

Have you managed to conect it ?

No I haven't

Vangelis · July 13, 2013

If you want please tell me what version do you have and i will have a look at it

flyalaska · July 13, 2013

If you want please tell me what version do you have and i will have a look at it

1.6.1

Vangelis · July 13, 2013

Status update almost done got it working on the template just need to fix the pilotid from cookie ,i hope that tomorrow you wil have something as today i am working

Best regards

flyalaska · July 13, 2013

Status update almost done got it working on the template just need to fix the pilotid from cookie ,i hope that tomorrow you wil have something as today i am working

Best regards

Vangelis · July 13, 2013

Almost done 1 more detail how do you want the user to be show in the chatlist

Please select 1 of bellow

1 Callsign only

2 Name and last name only

3 Callsign + Name + LastName

freshJet · July 13, 2013

I would personally use option 3

flyalaska · July 13, 2013

Option 3

Vangelis · July 13, 2013

Looking what code to alter because arrowchat works with only 1 field

Vangelis · July 13, 2013

You can see a demo @ www.baggelis.com/phpvms and login with the details writen on page

plane is now coming as i am still at work will continue or later on or 2morrow to get the info in the chat table

flyalaska · July 13, 2013

That is awesome!

Vangelis · July 14, 2013

well option 3 Callsign + Name + LastName doesnt fit in the box it show something like gsa108 va.........

so my sugestion is to show the callsign and if you dont know who it is just click on it and it will open the profile if you agree tell me so i can send you the code

Vangelis · July 14, 2013

So i am done

i suppose you have installed arrowchat in the root of your server and you have done the proper settings

so the only thing that you have to do is overwrite integration.php with this one

integration.php

each user avatar will show with his callsign and his lastname

If you have any problem tell me

And this is my config just for reference

config.php

flyalaska · July 14, 2013

Thank you! I will work on it today.

Vangelis · July 14, 2013

Sorry i forgot to mention the tpl settings

You need to put this core_htmlhead in your skin folderit contains the jquery references

core_htmlhead.zip

and this is a copy of the default template so you can see where you have to put the css and java

layout.zip

If you have any other problem just tell me

Vangelis · July 15, 2013

Your template that you sended me seems to be working

I thinks there was a mistake in the integration.php so i send you a new one

integration.php

If you dont manage it we can do a teamviewer session so i can see it on first hand on your server

Best regards

flyalaska · July 16, 2013

Thank you for all the help!

FSX30HD · April 25, 2014

Need help with version 1.72 Someone have the code for this version of integration.php ?

The original code

<?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/   # ||
|| #################################################################### ||
*/

// UNCOMMENT THE SESSION START IF YOU ARE USING SESSIONS TO GET THE USER ID
// session_start();
/**
 * This function returns the user ID of the logged in user on your site.  Technical support will not
 * help you with this for stand-alone installations.  You must purchase the professional installation
 * if you are having trouble.
 *
 * Suggestion: Check out the other integration files in the functions/integrations directory for
 * many examples of how this can be done.  The easiest way is to get the user ID through a cookie.
 *
 * @return the user ID of the logged in user or NULL if not logged in
 */
function get_user_id()
{
 $userid = NULL;

 if (isset($_COOKIE['userid']))
 {
  $userid = $_COOKIE['userid'];
 }
 return $userid;
}
/**
 * This function returns the SQL statement for the buddylist of the user.  You should retrieve
 * all ONLINE friends that the user is friends with.  Do not retrieve offline users.  You can use
 * global $online_timeout to get the online timeout.
 * ex: AND (arrowchat_status.session_time + 60 + " . $online_timeout . ") > " . time() . "
 *
 * @param userid the user ID of the person receiving the buddylist
 * @param the time of the buddylist request
 * @return the SQL statement to retrieve the user's friend list
 */
function get_friend_list($userid, $time)
{
 global $db;
 global $online_timeout;

 $sql = ("
  SELECT DISTINCT " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " userid, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " username, arrowchat_status.session_time lastactivity, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_AVATAR . " avatar, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " link, arrowchat_status.is_admin, arrowchat_status.status
  FROM " . TABLE_PREFIX . DB_FRIENDSTABLE . "
  JOIN " . TABLE_PREFIX . DB_USERTABLE . "
   ON  " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_FRIENDID . " = " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . "
  LEFT JOIN arrowchat_status
   ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid
  WHERE " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_USERID . " = '" . $db->escape_string($userid) . "'
   AND " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_FRIENDS . " = 1
   AND (arrowchat_status.session_time + 60 + " . $online_timeout . ") > " . time() . "
  ORDER BY " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " ASC
 ");

 return $sql;
}
/**
 * This function returns the SQL statement for all online users.  You should retrieve
 * all ONLINE users regardless of friend status.  Do not retrieve offline users.  You can use
 * global $online_timeout to get the online timeout.
 * ex: AND (arrowchat_status.session_time + 60 + " . $online_timeout . ") > " . time() . "
 *
 * @param userid the user ID of the person receiving the buddylist
 * @param the time of the buddylist request
 * @return the SQL statement to retrieve all online users
 */
function get_online_list($userid, $time)
{
 global $db;
 global $online_timeout;

 $sql = ("
  SELECT DISTINCT " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " userid, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " username, arrowchat_status.session_time lastactivity, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_AVATAR . " avatar, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " link, arrowchat_status.is_admin, arrowchat_status.status
  FROM " . TABLE_PREFIX . DB_USERTABLE . "
  JOIN arrowchat_status
   ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid
  WHERE ('" . time() . "' - arrowchat_status.session_time - 60 < '" . $online_timeout . "')
   AND " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " != '" . $db->escape_string($userid) . "'
  ORDER BY " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " ASC
 ");

 return $sql;
}
/**
 * This function returns the SQL statement to get the user details of a specific user.  You should
 * get the user's ID, username, last activity time in unix, link to their profile, avatar, and status.
 *
 * @param userid the user ID to get the details of
 * @return the SQL statement to retrieve the user's defaults
 */
function get_user_details($userid)
{
 global $db;

 $sql = ("
  SELECT " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " userid, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " username, arrowchat_status.session_time lastactivity,  " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " link,  " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_AVATAR . " avatar, arrowchat_status.is_admin, arrowchat_status.status
  FROM " . TABLE_PREFIX . DB_USERTABLE . "
  LEFT JOIN arrowchat_status
   ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid
  WHERE " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = '" . $db->escape_string($userid) . "'
 ");

 return $sql;
}
/**
 * This function returns the profile link of the specified user ID.
 *
 * @param userid the user ID to get the profile link of
 * @return the link of the user ID's profile
 */
function get_link($link, $user_id)
{
 global $base_url;

 return $base_url . '../users.php?id=' . $link;
}
/**
 * This function returns the URL of the avatar of the specified user ID.
 *
 * @param userid the user ID of the user
 * @param image if the image includes more than just a user ID, this param is passed
 * in from the avatar row in the buddylist and get user details functions.
 * @return the link of the user ID's profile
 */
function get_avatar($image, $user_id)
{
 global $base_url;

 if (is_file(dirname(dirname(dirname(__FILE__))) . '/images/' . $image . '.gif'))
 {
  return $base_url . '../images/' . $image . '.gif';
 }
 else
 {
  return $base_url . AC_FOLDER_ADMIN . "/images/img-no-avatar.gif";
 }
}
/**
 * This function returns the name of the logged in user.  You should not need to
 * change this function.
 *
 * @param userid the user ID of the user
 * @return the name of the user
 */
function get_username($userid)
{
 global $db;
 global $language;
 global $show_full_username;

 $users_name = $language[83];
 $result = $db->execute("
  SELECT " . DB_USERTABLE_NAME . " name
  FROM " . TABLE_PREFIX . DB_USERTABLE . "
  WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($userid) . "'
 "); 
 if ($result AND $db->count_select() > 0) 
 {
  $row = $db->fetch_array($result);
  $users_name = $row['name'];
 }
 $pieces = explode(" ", $users_name);

 if ($show_full_username == 1)
 {
  return $users_name;
 }
 else
 {
  return $pieces[0];
 }
}
?>

Thanks Fred

Vangelis · April 26, 2014

Have you tried the files that i previously had givven to

flyalaska ? and if yes dont they work ?

Your template that you sended me seems to be working

I thinks there was a mistake in the integration.php so i send you a new one

integration.php

If you dont manage it we can do a teamviewer session so i can see it on first hand on your server

Best regards

FSX30HD · April 26, 2014

Doesn't work don't have the cookie VMSAUTH present look here http://www.skydream-airlines.com

Thanks for you help

Vangelis · April 26, 2014

I will need a test account in order to see what kind of cookis it saves

Thanks

flyalaska · April 26, 2014

Doesn't work don't have the cookie VMSAUTH present look here http://www.skydream-airlines.com

Thanks for you help

I am home now. I will send you the files that you need to integrate the chat. Not 100% sure it will work. I am on Aerochat v1.6

FSX30HD · April 27, 2014

I will need a test account in order to see what kind of cookis it saves

Thanks

PM sent Thanks Vangelis

I am home now. I will send you the files that you need to integrate the chat. Not 100% sure it will work. I am on Aerochat v1.6

Thanks Eddie

ArrowChat (SOLVED)

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation