The Arcive of Official vBulletin Modifications Site.

Add Skype/Xfire/Google Talk to IM List · **Released**: 10-17-2005

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

HTML Code:

            $userinfo[yahooicon]

Add under this

HTML Code:

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

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

Barteh · #**112** 09-16-2006, 05:17 PM

Would love to see a 3.6.1 update for this add-on

domokun · #**113** 10-01-2006, 03:03 PM

Installed and working great. Only issue I have is the GoogleTalk icon does not show up on the Who's Online page. I included the code in the whosonlinebit for vB 3.5.4 but still nothing... What am I missing here?

Domokun

p.s. Here's what I have:

Code:

	<if condition="$vboptions['showimicons']">
		<td class="alt2" align="center" nowrap="nowrap">
			$userinfo[gticon]
			$userinfo[aimicon]
			$userinfo[icqicon]
			$userinfo[msnicon]
			$userinfo[yahooicon]
			$userinfo[skypeicon]
		</td>
	</if>

jcfuller · #**114** 10-04-2006, 05:08 AM

Quote:

Originally Posted by Barteh

Would love to see a 3.6.1 update for this add-on

Me too. Pretty please

CodeRed · #**115** 11-30-2006, 12:56 PM

Quote:

Originally Posted by CodeRed

very cool...

people on my forum use an instant messenger program called Hello (www.Hello.com) quite a bit to share photos etc and i'm curious to see how hard is it to get something like that added as well.

lemme know how tough it is to try to get something like this setup as well..

would it be as simple as say downloading the Googletalk zip and replacing every instance of "googletalk" in the XML with "hello" and then of course tweaking the google talk phrases and templates to fit accordingly to Hello?

maybe im just over simplifying the switch but I wanted to see if that made any sense to you guys...

Thanks

UPDATED INFO:
I went ahead and made the file changes as I mentioned above and tweaked all of the 'googletalk' and 'gticon' references etc over to 'hello' and 'hlicon' respectively as well and tweaked a couple of phrases in order for the popup box to display the correct info about Hello including steps to add member as a friend and where the software can be downloaded etc.

It all works well... So for those wanting another IM Client that is not in the list of the original mod, you can tweak it to your own needs. I myself am not a coder nor do i pretend to be one so if I can do it.... well uh... you get the picture... hehe...

hollyboy · #**116** 03-16-2007, 09:35 PM

nice

MjrNuT · #**117** 07-03-2008, 06:43 PM

Wow, this is an old one. I'm wondering if this works with v3.7.x. Anyone out there know this or provide an alternate hack that is current?

Thanks very much!!

espesso · #**118** 07-05-2008, 10:40 AM

Would love to see a 3.7.2 update for this add-on..

TingelT · #**119** 07-21-2008, 01:51 PM

Go online.php Line 245

PHP Code:


			
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,

And write after

PHP Code:


			
 user.skype,

For X-fire:

PHP Code:


			
user.xfire,

for Googel Talk

PHP Code:


			
user.googletalk,

The rest like described before.
And then the add-on could be up-to-date. I will test it soon....=)
Ok its not all

I'm working on the new version..hope Hawkbizkit allow m working on his addon..

espesso · #**120** 07-21-2008, 05:58 PM

hey nice i hope it comes soon

TingelT · #**121** 07-21-2008, 07:36 PM

I'm tooo lazy too copy&past all so I upload you the new Install.txt. All things are posted in it.
Enjoy..
I hope I don't break any licences with my first Vb Add-on

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05277 seconds Memory Usage 2,353KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (2)bbcode_html (9)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!