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 #####
#############

[adb22791]

Nice hack! *installed*

[funinthesun]

How do I install only google and skype? :nervous:

[Hawkbizkit]

you can do just the 2 you want you will just wanna work the template changes so they look good/correctly

[GrendelKhan{TSU]

Q: how easy/hard would it be to add other IM services? I'm in korea and would LOVE to have a couple of the most popular korean im services added (most people here dont' use any of those).

and is this fully phrased?


thanks for the hack in any case good stuff!

[funinthesun]

I'm a newbie though so don't recognise any coding. Do I just copy the skype code and the google code then? I don't know how to put the two codes together like you've done for all 3?

[funinthesun]

Anyone? Please?

[Joshua5692]

funinthesun can I ask, why not simply use the hack as it is?

So you want to use only Skype & GoogleTalk features?

[funinthesun]

Because I've never heard of Xfire? Yes, I only want the GoogleTalk and Skype features

[GrendelKhan{TSU]

Originally Posted by GrendelKhan{TSU

Q: how easy/hard would it be to add other IM services? I'm in korea and would LOVE to have a couple of the most popular korean im services added (most people here dont' use any of those).

and is this fully phrased?


thanks for the hack in any case good stuff!

bumpy

[Joshua5692]

Originally Posted by funinthesun

Because I've never heard of Xfire? Yes, I only want the GoogleTalk and Skype features

I believe you can simply choose the Skype.zip & Googletalk.zip and install those two individually. I don't think it forces X-Fire on anyone. I do not have X-Fire as an option on my forum, but I really don't remember which .zip file I used to tell you. I might have used the individual packages, or I may have edited the full package.

As a side note X-Fire is an instant messenger based on the gaming community and it logs what games are played and how much time is spent on them. It also will allow a user to join their friend in whatever game/server they are currently playing in. It is quite advanced and many like it alot as a sole communication program. But again it is for the gaming community.