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

Hawkbizkit · #62 11-03-2005, 10:08 PM

Quote:

Originally Posted by Joshua5692

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>

well first off in your headinclude you are missing

function gtwindow(userid, width, height)

right below var IMGDIR_MISC = "$stylevar[imgdir_misc]";

so it should be like this

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]";
 function gtwindow(userid, width, height)
{
    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>

Hawkbizkit · #63 11-03-2005, 10:16 PM

Quote:

Originally Posted by ROTPAR

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.)

ok run these queries

[sql]ALTER TABLE user ADD googletalk VARCHAR( 250 ) AFTER msn

ALTER TABLE user ADD xfire VARCHAR( 250 ) AFTER msn

ALTER TABLE user ADD skype VARCHAR( 250 ) AFTER msn[/sql]

be sure to add your table prefix if you have one... you man only need to run 1 or all of these queries so try them all if you have all 3 installed if not just use the one needed

Joshua5692 · #64 11-03-2005, 11:03 PM

That was just too sexy! Thank you, it finally works the way you intended! Again thank you for the addition and the support for it.

If all you coders would put a little Paypal script in your entry submission, I am sure there are probably a few dozen like me that would be more than happy to donate for the time and effort you put into this stuff.

Joshua5692 · #65 11-04-2005, 01:22 PM

I spoke too soon. The code you gave worked great in Firefox. It took me a full day to get the complaints, but it is very bad for those who use IE. In Internet Explorer, with the Headinclude you gave it give many errors and some even in Firefox. The original code in the post I had does not give these errors, but your modification won't work unless I use yours.

The errors are when you reply to any message the drop down smilies (in advanced mode) and many of the code options stop working. The other major error is the style selection no longer functions, the language selection no longer functions.

I really am interested in making this work, if anyone has a suggested modification of the code above?

ROTPAR · #66 11-04-2005, 05:10 PM

Quote:

Originally Posted by Hawkbizkit

ok run these queries

[sql]ALTER TABLE user ADD googletalk VARCHAR( 250 ) AFTER msn

ALTER TABLE user ADD xfire VARCHAR( 250 ) AFTER msn

ALTER TABLE user ADD skype VARCHAR( 250 ) AFTER msn[/sql]

be sure to add your table prefix if you have one... you man only need to run 1 or all of these queries so try them all if you have all 3 installed if not just use the one needed

thank you very much..now it?s perfect

Hanif · #67 11-04-2005, 07:43 PM

Interesting to note that vbulletin.org will have an interesting feature added to 3.5.2 with regards, to Skype: http://www.vbulletin.com/forum/showthread.php?t=162169

Snake · #68 11-04-2005, 08:38 PM

That's good but what about Google Talk?

Hawkbizkit · #69 11-04-2005, 11:52 PM

Quote:

Originally Posted by Joshua5692

I spoke too soon. The code you gave worked great in Firefox. It took me a full day to get the complaints, but it is very bad for those who use IE. In Internet Explorer, with the Headinclude you gave it give many errors and some even in Firefox. The original code in the post I had does not give these errors, but your modification won't work unless I use yours.

The errors are when you reply to any message the drop down smilies (in advanced mode) and many of the code options stop working. The other major error is the style selection no longer functions, the language selection no longer functions.

I really am interested in making this work, if anyone has a suggested modification of the code above?

well i just tried editing your code here is my headinclude code from my personal board tell me it that works..

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]";
// -->
function gtwindow(userid, width, height)
{
    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>

Allan · #70 11-13-2005, 02:14 PM

Very Nice

Thanks, Click Install

File Attach: French Language for Skype

Joshua5692 · #71 11-13-2005, 03:41 PM

Quote:

Originally Posted by Hawkbizkit

well i just tried editing your code here is my headinclude code from my personal board tell me it that works..

I would love to tell you it works flawless and thank you very much, but....
as soon as I say that is when I get notified of board errors. So I will tell you thank you very much, it does not have the display or function problems that my old one had. It works perfectly from what I can see. Thanks for all your support.

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