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

majorxp · #22 10-19-2005, 02:22 PM

Cool...I look forward to this fully working! This is exactly what I needed.

jugo · #23 10-19-2005, 02:49 PM

Quote:

Originally Posted by TyleR

by posting that you made yourself look dumb..you're the one who asked if it was still in beta..so really, you answered you're own question :ermm:

Dude...if thi is not your hack ..SHUT UP!!

If the question didn't start with "Tyler ".....SHUT UP!!

If you're breathing....STOP!!!

PS: I have seen hacks released as FULL VERSIONS and not in beta...so.....SHUT UP!!!

Cheertobi · #24 10-19-2005, 03:15 PM

Hi,

I just checked the install.txt within the skype zipfile and all template edits seem to be for xfire?! Is this right?

Tobi

Hawkbizkit · #25 10-19-2005, 03:29 PM

Quote:

Originally Posted by Cheertobi

Hi,

I just checked the install.txt within the skype zipfile and all template edits seem to be for xfire?! Is this right?

Tobi

aaaahhhh crap i'm reuploading them right now with the correct install file sorry about this i was changing them so fast i screwed up sorry

it's an easy fix for skype where it says xfire just replace it with skype

for example:

HTML Code:

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

HTML Code:

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

Hawkbizkit · #26 10-19-2005, 03:38 PM

Quote:

Originally Posted by WNxWakko

When i click the xfire image icon in a post which does show up as xfire, I get this,

Send Message Via MSN to WNxWakko (wnxwakko@hotmail.com)
Add wnxwakko@hotmail.com to your contact list
Send wnxwakko@hotmail.com a message
Please note that these functions require that you to be logged into either MSN Messenger or Windows Messenger. You will not be able to send messages to the email address that you are logged into MSN/Windows Messenger with.

---------------

The other issue is google image icon not showing up,

as for your xfire install error i can't seem to find the bug finally setup a localhost on my laptop and did 3 test installs and it seems to be working just like it should...

also for googletalk not showing up do this...

HTML Code:

******************************************
*////////////////////////////////////////*
*//////TEMPLATE EDIT: MEMBERINFO/////////*
*////////////////////////////////////////*
******************************************

-- Find --

<if condition="$userinfo['showgoogletalk']">
				<tr>
					<td>$userinfo[gticon]</td>
					<td><a href="#" onclick="gtwindow('$userinfo[userid]', 400, 200); return false;">$userinfo[googletalk]</a></td>
				</tr>
</if>

-- Replace With --

<if condition="$userinfo['showgt']">
				<tr>
					<td>$userinfo[gticon]</td>
					<td><a href="#" onclick="gtwindow('$userinfo[userid]', 400, 200); return false;">$userinfo[googletalk]</a></td>
				</tr>
</if>

Chris M · #27 10-19-2005, 03:38 PM

Quote:

Originally Posted by jugo

Dude...if thi is not your hack ..SHUT UP!!

If the question didn't start with "Tyler ".....SHUT UP!!

If you're breathing....STOP!!!

PS: I have seen hacks released as FULL VERSIONS and not in beta...so.....SHUT UP!!!

jugo, please calm down :ermm:

Tyler, please do not continue this in this thread...

If you want to tear each other's throats out, please take it off this site

Chris

Hawkbizkit · #28 10-19-2005, 06:26 PM

Released updated version and hopefully fixed the bugs and then added the Triple Pack (Google Talk/Xfire/Skype All In One)

WNxWakko · #29 10-19-2005, 09:27 PM

Thanks for the google fix. I did figure out my xfire problem. Was nothing you did, I had an old template for xfire back in beta when I was trying dupe msn for it. All I had to do was revert the template.

I do however notice, you cant search from the advanced memberlist for any of these messangers. Any chance of adding that?

Snake · #30 10-19-2005, 09:50 PM

Thanks for the update. I think the hack's working just fine so I'm wondering why it is still in beta stages?

Hawkbizkit · #31 10-19-2005, 10:20 PM

just making sure everyones bugs where fixed before i went outta the beta stage...next release will be the gold version then i will start adding features as needed or requested if i think they apply

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07210 seconds Memory Usage 2,358KB 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 (5)bbcode_html (5)bbcode_php (4)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 (4)pagenav_pagelink (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!