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

eljeffe · #12 10-18-2005, 08:03 PM

Quote:

Originally Posted by Hawkbizkit

Taking first post for updates.... :banana: Enjoy and i hope it works lol

Hey Hawkbizkit,

Any chance we can talk you into creating this same hack for 3.0.x? I know I'd be willing to toss you a few bucks for beer if you did.

BLazeD1 · #13 10-18-2005, 10:56 PM

I get this - Uncached templates: im_gt (1)

jugo · #14 10-19-2005, 01:13 AM

Quote:

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]

Please read the filenames before giving such answers:

Quote:

googletalk 0.1Beta.zip
skype 0.1beta.zip
xfire 0.1beta.zip

TyleR · #15 10-19-2005, 02:44 AM

Quote:

Originally Posted by jugo

Please read the filenames before giving such answers:

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:

WNxWakko · #16 10-19-2005, 03:43 AM

When you click the Xfire icon from a post, the popup window refers to MSN.

Also with the code inserted to the templates, the Google info doesnt show up in a members profile or memberinfo page.

Hawkbizkit · #17 10-19-2005, 04:09 AM

Quote:

Originally Posted by WNxWakko

When you click the Xfire icon from a post, the popup window refers to MSN.

Also with the code inserted to the templates, the Google info doesnt show up in a members profile or memberinfo page.

does it display the Xfire info at all or is it really just the MSN info i can't check this on my own server since my host is currently down.... ggggrrrrr but i checked the code and it doesn't say seem to be messed up. a screenshot would also help but i guess i will test this on a local machine.

WNxWakko · #18 10-19-2005, 04:12 AM

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,

Hawkbizkit · #19 10-19-2005, 04:14 AM

hmmmm...... into the code i must go brb with a fix

edit: well i plan as soon as these bugs are fixed to release a version with all 3 in one plugin/zip file

BLazeD1 · #20 10-19-2005, 04:24 AM

How do I cache the im_gt template?

I currently get this error at the bottom of my forums:

Quote:

Uncached templates: im_gt (1)

Hawkbizkit · #21 10-19-2005, 04:32 AM

Quote:

Originally Posted by BLazeD1

How do I cache the im_gt template?

I currently get this error at the bottom of my forums:

well thats not an error it's just that a i did not cache the templates in this version because it's still a beta and that was the last thing i wanted to worry about but if you wait till these bug fix's i will cache the templetes and update all the hacks and add the 4th one

btw since my host is down and my linux box is down i am installing apache and mysql and setting up a local test bed for debuging again... so this will take like 30 minutes but i will get this updated tonight.

Update: well my HDD just died on me so i'm SOL all got left is my laptop. so i will try and setup my linux box again....

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