Mini Mods - Steam IM Card v4.x (now with Steam Profile Tab)

This adds the ability of having for each user of your board to enter their Steam ID like the MSN, ICQ, AOL, Yahoo and Skype Messenger contact cards.

Users can enter their steam id in the following forms:

• steam id: STEAM_0:X:XXXX
• http://steamcommunity.com/profiles/7656119XXXXXXXXXX (profile page url)
• steam community id: 7656119XXXXXXXXXX

This hack also integrates itself into the AdminCP User editor and the User Control Panel when its enabled.

A profile tab with the steam profile information is also implemented. (optional - can be disabled)

Permission granted for port of this hack to vB v3.8 (and now to vB 4.x). Originally developed by Kalle Sommer Nielsen (c) 2007

Installation

1. upload im_steam.gif to images/misc/
2. import product

[thisgeek]

Originally Posted by luckid

With vb 4.1.3 is ok but with the VB 4.1.4 plugin error when you go to "connected users"

PHP Code:

Database error in vBulletin 4.1.4:

Invalid SQL:

    SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
    , user.steam
    FROM session as session
    
    WHERE session.lastactivity > 1308709383
    
    
    
    GROUP BY isuser;

MySQL Error   : Unknown column 'user.steam' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, June 21st 2011 @ 10:38:03 PM
Error Date    : Tuesday, June 21st 2011 @ 10:38:04 PM
Script        : http://***********/forum/online.php
Referrer      : http://**********/forum/forum.php
IP Address    : **********
Username      : *****
Classname     : vB_Database
MySQL Version : 5.0.77 


Getting the same problem. Disabling the product fixes the error. I'll leave it disabled until this mod is updated.

Thanks

[luckid]

Originally Posted by thisgeek

Getting the same problem. Disabling the product fixes the error. I'll leave it disabled until this mod is updated.

Thanks

I had to disable it ... I hope in a fix as soon as possible

[Gerdeman]

Definitely update this mod, great feature to have.

[techanalyst]

Possible etas for 4.1.1 users

[kardac.stenfot]

Originally Posted by luckid

With vb 4.1.3 is ok but with the VB 4.1.4 plugin error when you go to "connected users"

PHP Code:

Database error in vBulletin 4.1.4:

Invalid SQL:

    SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
    , user.steam
    FROM session as session
    
    WHERE session.lastactivity > 1308709383
    
    
    
    GROUP BY isuser;

MySQL Error   : Unknown column 'user.steam' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, June 21st 2011 @ 10:38:03 PM
Error Date    : Tuesday, June 21st 2011 @ 10:38:04 PM
Script        : http://***********/forum/online.php
Referrer      : http://**********/forum/forum.php
IP Address    : **********
Username      : *****
Classname     : vB_Database
MySQL Version : 5.0.77 


Tnx in advance for this fix :-)

Confirming that I have the same problem. Disable this plugin until update is posted.

[Skyrider]

No updates on this?

[chamoul]

I didn't really managed to make it properly, but my hack made this add-ons work for vBulletin 4.1.5 Patch Level 1


in product-imsteamv4.0.2.xml
remove or put in comment (<!-- -->) the code below

<plugin active="1" executionorder="5">
			<title>add online bit</title>
			<hookname>online_query</hookname>
			<phpcode><![CDATA[$hook_query_fields .= ", user.steam";]]></phpcode>
</plugin>

and if you want to display the steam icon in the online.php

you need to change this

$globaltemplates = array(
	'forumdisplay_sortarrow',
	'im_aim',
	'im_icq',
	'im_msn',
	'im_yahoo',
	'im_skype',
	'WHOSONLINE',
	'whosonlinebit'
);

by

$globaltemplates = array(
	'forumdisplay_sortarrow',
	'im_aim',
	'im_icq',
	'im_msn',
	'im_yahoo',
	'im_skype',
	'im_steam',
	'WHOSONLINE',
	'whosonlinebit'
);

and at line 263 you need to change the sql query

SELECT user.username, session.useragent, session.location, session.lastactivity, 
		user.userid, user.options, 
		session.host, session.badlocation, session.incalendar, session.inthread,  
		user.aim, user.icq, user.msn, user.yahoo, user.skype,

by

SELECT user.username, session.useragent, session.location, session.lastactivity, 
		user.userid, user.options, 
		session.host, session.badlocation, session.incalendar, session.inthread,  
		user.aim, user.icq, user.msn, user.yahoo, user.skype, user.steam,

This is just a hack until maybe to author find a solution to the problem

[FTG LIQUID CL]

anyway to make this work with 4.1.12

[Pictureclass]

wow, great Plugin. Thank you very very much. Works great with 4.2.1

[ruger]

Working fine on 4.2.2PL1