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

Parture · #52 10-27-2005, 11:17 PM

The other instant messaging icons show up in the user profile and the member list, but not under "View Forum Leaders", only the 4 basic ones show up there, MSN, Yahoo, AIM and ICQ.

What do we do to include them?

Parture · #53 11-01-2005, 10:39 AM

<a href="http://biblocality.com/forums/showthread.php?t=31" target="_blank">http://biblocality.com/forums/showthread.php?t=31</a>

Two improvements needed:

1) Even though you made the changes to see all the IM icons in the useronline.php, only Admins for some reason can see them. This problem seems to have existed in version 3.5 for all IM icons in the useronline.php.

2) I wish non-users could not see the other 3 IM icons when they are restricted from viewing user's information: Can View Member Info = No.

ROTPAR · #54 11-02-2005, 12:03 PM

right now I get this error message...what should I do ? I also can?t install the plugin new.....yesterday all worked, after I imported some Users I get always this error:

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE vb3_user SET
parentemail = '',
icq = '',
msn = '',
aim = '',
yahoo = '',
homepage = 'http://www.xxxx.com',
birthday_search = '',
birthday = '',
showbirthday = 2,
usertitle = 'blabla',
customtitle = 2,
googletalk = 'xxxexample',
xfire = '',
skype = ''
WHERE userid = 1003;

MySQL Error : Unknown column 'googletalk' in 'field list'
Error Number : 1054
Date : Wednesday, November 2nd 2005 @ 02:49:09 PM
Script : http://www.
Referrer : http://www.
IP Address : 84.
Username : R*
Classname : vb_database

Hawkbizkit · #55 11-02-2005, 04:21 PM

Quote:

Originally Posted by ROTPAR

right now I get this error message...what should I do ? I also can?t install the plugin new.....yesterday all worked, after I imported some Users I get always this error:

try reimporting the product via the product manager.

ROTPAR · #56 11-02-2005, 05:06 PM

I can import it again, but the error seems to be the same

Hawkbizkit · #57 11-02-2005, 09:58 PM

what are you trying to do when you get that error? import users, update your profile, or what?

ROTPAR · #58 11-02-2005, 11:16 PM

Quote:

Originally Posted by Hawkbizkit

what are you trying to do when you get that error? import users, update your profile, or what?

I try to update my profile...so I want to put my xfire ID in there or my google talk ID.

Hawkbizkit · #59 11-03-2005, 04:18 PM

so you have installed the hack and it wont let up update your profile and gives you that error. just trying to make sure i know whats going on.... if thats the case it looks as if the database has not been updated with the new colums for xfire/google talk/skype you can try to manually try and run the queries

Also what happens when you try to uninstall the product?

ROTPAR · #60 11-03-2005, 05:15 PM

Quote:

Originally Posted by Hawkbizkit

so you have installed the hack and it wont let up update your profile and gives you that error. just trying to make sure i know whats going on.... if thats the case it looks as if the database has not been updated with the new colums for xfire/google talk/skype you can try to manually try and run the queries

Also what happens when you try to uninstall the product?

that?s right. If I try to uninstall the product I can?t because it does not finde the needed things in the database (google etc.)

Joshua5692 · #61 11-03-2005, 05:36 PM

Great work, thank you for the mod!

My problem I think is somewhere in the headinclude...

When I click the MSN icon, I get the popup and it is perfect. When I click the Skype however it merely refreshes the page, no popup at all.

Any help would be appreciated.

PHP Code:


			
<meta http-equiv="Content-Type" content="text/html; charset=$stylevar[charset]" />

<meta name="generator" content="vBulletin $vboptions[templateversion]" />

<if condition="$show['threadinfo']">

<meta name="keywords" content="$threadinfo[title], $vboptions[keywords]" />

<meta name="description" content="<if condition="$pagenumber>1"><phrase 1="$pagenumber">$vbphrase[page_x]</phrase>-</if>$threadinfo[title] $foruminfo[title_clean]" />

<else />

    <if condition="$show['foruminfo']">

<meta name="keywords" content="$foruminfo[title_clean], $vboptions[keywords]" />

<meta name="description" content="<if condition="$pagenumber>1"><phrase 1="$pagenumber">$vbphrase[page_x]</phrase>-</if>$foruminfo[description_clean]" />

    <else />

<meta name="keywords" content="$vboptions[keywords]" />

<meta name="description" content="$vboptions[description]" />

    </if>

</if>



<!-- CSS Stylesheet -->

$style[css]

<if condition="is_browser('opera') AND !is_browser('opera', '8.0.1')">

<style type="text/css">

ul, ol { padding-left:20px; }

</style>

</if>

<!-- / CSS Stylesheet -->



<script type="text/javascript">

<!--

var SESSIONURL = "$session[sessionurl_js]";

var IMGDIR_MISC = "$stylevar[imgdir_misc]";



{

    return openWindow(

        'sendmessage.php?' + SESSIONURL + 'do=googletalk&u=' + userid,

        width, height

    );

}

function xfirewindow(userid, width, height)

{

    return openWindow(

        'sendmessage.php?' + SESSIONURL + 'do=xfire&u=' + userid,

        width, height

    );

}

function skypewindow(userid, width, height)

{

    return openWindow(

        'sendmessage.php?' + SESSIONURL + 'do=skype&u=' + userid,

        width, height

    );

}

</script>



<script type="text/javascript" src="clientscript/vbulletin_global.js"></script>

<if condition="$show['popups']"><script type="text/javascript" src="clientscript/vbulletin_menu.js"></script></if>

<if condition="$vboptions['externalrss']"><link rel="alternate" type="application/rss+xml" title="$vboptions[bbtitle] RSS Feed" href="external.php?type=RSS" /></if>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04805 seconds Memory Usage 2,382KB 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 (6)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!