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

[Hawkbizkit]

Version Log:

Version 1.0
-Finallized the packs
-Added template caching

Added Screenshots

Version 0.3 Beta
-Fixed a few minor code issues.
-Cleaned up icons and added PSD's for people to customize with.
-Added the Google Talk/Xfire/Skype triple pack install as beta 0.3.

Version 0.2 Beta
-Fix template edits in install files.
-Changed a few phrases around.

Version 0.1 Beta
-First release.

Upgrading:

0.1-0.2 Beta --> 0.3 Beta:

Just import over old version and reapply Template edits for Skype only.

0.1-0.2 Beta --> 0.3 Beta Triple Pack:

If you wish to keep the data from the other versions just remove the uninstall code from the other products and then uninstall and remove template edits.

Import new triple pack product and apply template edits again.

0.3 Beta's --> 1.0:

Just upload the new product with allow overwrite option checked.

[jesus likes pie]

Wrong forum, but I will install it later. This is code modification.

[Snake]

Screenshots please?

[Hawkbizkit]

i always love how people do this the code mod is optional and not required unless you want those features....

i will do my best tonight to get a screenshot up but i'm not sure it's really needed as it just add's the buttons for those different IM clients just like AIM/Yahoo/MSN/ICQ it just adds them to the right.

[Azhrialilu]

I like it

[jugo]

Is it still in beta?

[TyleR]

Originally Posted by jugo

Is it still in beta?

Release: Today

Very doubtful that it isnt..please read the release date before asking such questions

Also, installed the google talk one, and works fine

[high]* TyleR clicks install[/high]

[kall]

Originally Posted by TyleR

Very doubtful that it isnt..please read the release date before asking such questions

Also, installed the google talk one, and works fine

[high]* TyleR clicks install[/high]

Given that the author has marked it as IN BETA STAGE.. it's not a bad question to ask.

[TyleR]

Originally Posted by kall

Given that the author has marked it as IN BETA STAGE.. it's not a bad question to ask.

Did you read the whole post? it was just released today, so why would it be out of beta within the same day? its never happened from what i've seen before.