Add Skype/Xfire/Google Talk to IM List

Well first off I would like to thank burnist for allowing me to re-release this hack as a product and change a few things so it will work with xfire and google talk also. Here is the original hack by burnist Add Skype To IM List.

The code is almost the same with very few changes all i really did was automate the query and adding the templates and added prases to it but you will still need to edit a few templates and have 1 file edit ONLY IF you want this feature.

Title: Add Skype/Xfire/Google Talk to IM List

Function: Adds a listings for Skype/Xfire/Google Talk along side the instant messengers in the profile, memberlist, postbit and Who's Online (WOL requires file edit)

Installation: - Load The XML file in the Product manager
- Upload im_skype.gif/im_xfire.gif/im_gt.gif to images/misc
- Do Template Edits
- WOL addition is listed in the Thread
- If it becomes available the WOL will be added by a hook (future version)
- Tested on vB 3.5 GOLD

Author: Greg Orsi (Hawkbizkit)
Original Author: Stewart Ritchie (acid burn/burnist)
Date: Tuesday October 18th
Version: 1.0
License: Provided "as is" with no warrnty. I take no responsibility for your board, always make a back up before modifying anything, even more important now as modifications them selves are stored in the database now.
Can only be distributed on Vbulletin.org or other official Sites without my permission.

OPTIONAL FILE MOD IF YOU WANT THIS FEATURE!!!

The following will add Skype/Xfire/Google Talk to the Who's Online IM list, it was not included in the hack file as it requires file edits and the rest of the add-on uses hooks so you can add this at your own discretion.

Depending on which version you install you will need to change a few things in the file edit.

#########
## WOL ###
#########

Open online.php and find

PHP Code:

                          $allusers = $db->query_read(" 
SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, 
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
FROM " . TABLE_PREFIX . "session AS session 
". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ." 
WHERE session.lastactivity > $datecut 
". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") ." 
ORDER BY $sqlsort $sortorder 
"); 


Replace It with

For Skype:

PHP Code:

                         $allusers = $db->query_read(" 
SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype, 
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
FROM " . TABLE_PREFIX . "session AS session 
". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ." 
WHERE session.lastactivity > $datecut 
". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") ." 
ORDER BY $sqlsort $sortorder 
"); 


For Xfire:

PHP Code:

                          $allusers = $db->query_read(" 
SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.xfire, 
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
FROM " . TABLE_PREFIX . "session AS session 
". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ." 
WHERE session.lastactivity > $datecut 
". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") ." 
ORDER BY $sqlsort $sortorder 
"); 


For Googletalk:

PHP Code:

                         $allusers = $db->query_read(" 
SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.googletalk, 
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
FROM " . TABLE_PREFIX . "session AS session 
". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ." 
WHERE session.lastactivity > $datecut 
". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") ." 
ORDER BY $sqlsort $sortorder 
"); 


For Google Talk/Xfire/Skype Triple Pack:

PHP Code:

                         $allusers = $db->query_read(" 
SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.googletalk, user.xfire, user.skype, 
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid 
FROM " . TABLE_PREFIX . "session AS session 
". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ." 
WHERE session.lastactivity > $datecut 
". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") ." 
ORDER BY $sqlsort $sortorder 
"); 


Save and close online.php

Open The template 'whosonlinebit'

Find

            $userinfo[yahooicon]

Add under this

      $userinfo[gticon]
            $userinfo[xfireicon]
            $userinfo[skypeicon]

#############
### /WOL #####
#############

[tasarimdunyasi]

thx a lot...

[GuaRRand]

Originally Posted by Hawkbizkit

you will need to do the template edits inthe install txt file in the zip...for the profile page it is the modifyprofile template

BWHAHA...completely forgot that

Thnx

[Cheertobi]

Hi,

sorry for asking that! Is it right, that for skype all user information are just displayed? Is there no interaction for adding users to the contactlist or sending msg via web to skype?! I do not use skype, but my users

Regards,

Tobi

[Trovador]

I'm interested in add jabber a IM list, What should I change to get this??

[davidw]

Silly question but...
I've installed this (haven't checked the functionality of it yet) and the headinclude edits show up at the top of my forum. Anything that I'm doing wrong to make this happen?

Edit: To make it quit appearing, I had to edit the code from:

PHP Code:

function gtwindow(userid, width, height)
{
    return openWindow(
        'sendmessage.php?' + SESSIONURL + 'do=googletalk&u=' + userid,
        width, height
    );
}
function xfirewindow(userid, width, height)
{
    return openWindow(
        'sendmessage.php?' + SESSIONURL + 'do=xfire&u=' + userid,
        width, height
    );
}
function skypewindow(userid, width, height)
{
    return openWindow(
        'sendmessage.php?' + SESSIONURL + 'do=skype&u=' + userid,
        width, height
    );
} 


to

PHP Code:

<script type="text/javascript">
<!--
function gtwindow(userid, width, height)
{
    return openWindow(
        'sendmessage.php?' + SESSIONURL + 'do=googletalk&u=' + userid,
        width, height
    );
}
function xfirewindow(userid, width, height)
{
    return openWindow(
        'sendmessage.php?' + SESSIONURL + 'do=xfire&u=' + userid,
        width, height
    );
}
function skypewindow(userid, width, height)
{
    return openWindow(
        'sendmessage.php?' + SESSIONURL + 'do=skype&u=' + userid,
        width, height
    );
}
// --> 


Edit - this is also hindering the popup

[Snake]

Hawkbizkit, could you make all those 3 IM images transparent so it will work fine on my dark skin please? Here's the link to my skin: http://forums.mgszone.com

[davidw]

At the bottom of the instructions for WOL, it should read:

			$userinfo[gticon]
			$userinfo[xfireicon]
			$userinfo[skypeicon]

rather than:

			$post[gticon]
 			$post[xfireicon]
 			$post[skypeicon]

[davidw]

I got the headinclude fixed...

The issue was that I was putting it after:

<script type="text/javascript">
<!--
var SESSIONURL = "$session[sessionurl_js]";
var IMGDIR_MISC = "$stylevar[imgdir_misc]";
// -->

rather than in between:

<script type="text/javascript">
<!--
var SESSIONURL = "$session[sessionurl_js]";
var IMGDIR_MISC = "$stylevar[imgdir_misc]";
// -->

and

</script>

I guess I missed the </script> closetag altogether.

[Hawkbizkit]

sorry i am in mexico and have been here since last friday and i come home this friday so until then i will not be around much for support but for the dark themed IM images i included the psd file so you can edit it for a dark theme since i also use a dark them.

[evenmonkeys]

How do we add our own fields based on your hack?