burnist
07-18-2005, 10:00 PM
This is my First vB 3.5 mod so it may be a little rusty :)
Title: Add Skype Handle to vBullein
Function: Adds a listings for Skype VoIP 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 plugin manager
- Run The Query
- Upload im_skype.gif to images/misc
- Add new Templates
- Do Template Edits
Notes: - Phrases not used at this time, possibly in a newer version.
- 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 beta 4
Author: Stewart Ritchie (acid burn/burnist)
Date: Tuesday July 16th
Version: 1.00
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.
The following will add Skype 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.
#########
## WOL ###
#########
Open online.php and find
$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
$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
");
Save and close online.php
Open The template 'whosonlinebit'
Find
$userinfo[yahooicon]
Add under this
$userinfo[skypeicon]
#############
### /WOL #####
#############
If you install this please click "Install" :)
Title: Add Skype Handle to vBullein
Function: Adds a listings for Skype VoIP 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 plugin manager
- Run The Query
- Upload im_skype.gif to images/misc
- Add new Templates
- Do Template Edits
Notes: - Phrases not used at this time, possibly in a newer version.
- 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 beta 4
Author: Stewart Ritchie (acid burn/burnist)
Date: Tuesday July 16th
Version: 1.00
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.
The following will add Skype 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.
#########
## WOL ###
#########
Open online.php and find
$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
$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
");
Save and close online.php
Open The template 'whosonlinebit'
Find
$userinfo[yahooicon]
Add under this
$userinfo[skypeicon]
#############
### /WOL #####
#############
If you install this please click "Install" :)