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

[Ragnarok]

Added the Google Talk expansion without any major issues, and all is working great. ^^

[Murty]

i tried installing the xfire bit for 3.5.4 but doesnt work for some reason, like the icon doesnt show up in the postbit or memberinfo

Edit: LOL i realised that i hadnt entered any data in my profile, all good now, thanks alot. would be good to see some more stuff for it, like online or offline etc.... but this will do for now

[Kacela]

ALOT of template editing, but finally got it to work.
/me clicks install.

[jazde86]

Hey,

your popup Code isn't w3c conform:

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

Line 296 column 51: cannot generate system identifier for general entity "u".
'sendmessage.php?' + SESSIONURL + 'do=googletalk&u=' + userid,

Can you put the code for popup in another template? Every other messenger has the popup script not in the headinclude...

Thanks in advance for your help.

[Shaikan]

@Kacela
Can you tell me how?

I need it on 3.5.2 but I think 3.5.4 is nearly the same.

I tried something but do I have to add these lines to the memberinfo template:

					<if condition="$userinfo['xfire']">
					<tr>
						<td>$vbphrase[xfire]</td>
						<td>$userinfo[xfire]</td>
					</tr>
					</if>

[Jericho2004]

This works fine on vb 3.6 except the icon does not show up in the user's profile next to the field. Adding the handle and then going into a thread, the icon is there. Just not in the profile. Any ideas?

[begore]

Yeah, any chance of full 3.6 support on this mod? Cheers!

[gavinzac]

to fix it you could copy the code that is "hooked" into the postbit usually, into the actual postbit template.

[murdo]

Any chance this can be updated to work with 3.6, without further mods? (i.e copying code into the postbit etc)

[jcfuller]

I installed on a 3.5.4 forum. The xfire information is not showing up in the users public profile under there contact information. Only shows MSN or other Instant Messaging programs. Not xfire. Any clues how or where to fix this? See example here:

http://www.zarkrifle.com/forum/member.php?u=3