Integration with vBulletin - Steam Connect - Sign in with your Steam Account! [RC3]

Steam Connect

INFO

-- Steam Connect Addon for vBulletin 4.2.x;
Development Platform := vBulletin 4.1.3 - 4.2.0, Debian Linux, PHP5, MySQL5, apache2;
Dependencies := lib cUrl (PHP), openid (included);
Author := Andreas "Radon" Rudolph, Disasterpiece;
Contact := radon@purgatory-labs.de, https://vborg.vbsupport.ru/member.php?u=198844
Homepage := http://purgatory-labs.de


WHAT YOU SHOULD KNOW BEFORE INSTALLING

This addon is Unsupported as of 2015 until further notice. I have not enough time or interest in vbulletin to keep this alive.

This addon provides a framework for future extensions which make use of the Steam API.
It helps to determine the SteamID of an user. Unless older methods of inserting the steam
id into a user field, the addon lets the user authenticate with Steam OpenID, therefore
you can trust 100%, that this particular user is the same user as the Steam-ID provided.

Users can link their Steam ID to their forum account or they can create a new account
using details pulled from their Steam Profile.
Like the Facebook connect plugin, it allows users to quickly set up a forum account without
having to define a password or an email address. This option can be disabled in the AdminCP,
however it is encouraged to allow users to use this quick-register feature, since they
already authenticated themselves through steam, so any additional password or email
authentication is just unnecessary.

If the user decides to un-link his forum account with his steam-profile, he has to set up
a password and email first, so the forum account remains usable after this.

At the moment, the addon is in its second RC state, which means that the current versions contain mostly bugfixes and are candidates for a full release.
Until now, the product worked without major problems in productive environments. Although it is stable as is, the author doesn't provide any guarantee.
Due to the nature of the addon and how vBulletin manages 3rd party code inclusion, additional
login and register methods have been provided by the plugin. It is discouraged to use the
plugin on high profile communities in this early development state.

If you have any further questions, feel free to post in this thread.


F.A.Q. / General Issues / Error Messages

"There has been a problem with the OpenID libary: No OpenID Server found at http://steamcommunity.com/openid"
- Additionally, a 503 HTTP error is thrown. Simple solution: Wait. Steam Community servers are overloaded/down right now, there's nothing you can do about it

Do NOT uninstall the mod if you want to keep the linked users records. Upgrading means uploading the new product xml file for the new version and choose "overwrite" in the upload dialog.
The Installer will handle the update process by its own. Uninstalling the product will erase all the table fields which contain the steam link data.


STEAM CONNECT ADDONS

- Steam Mini Profiles


INSTALL HOWTO

[x3evolution]

Disaster this is what i get when i have the issue

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT title, usergroupid FROM usergroup WHERE usergroupid IN (6,,37) ORDER BY title;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '37) ORDER BY title' at line 1
Error Number  : 1064
Request Date  : Tuesday, November 6th 2012 @ 11:58:15 AM
Error Date    : Tuesday, November 6th 2012 @ 11:58:17 AM
Script        : http://*****.org/admincp/user.php?do=edit&u=1
Referrer      : http://*****.org/admincp/index.php?l...3Dedit%26u%3D1
IP Address    : **.**.**.**
Username      : Ryan
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.27-cll

[jldrake]

Can you add a steam connect option to set the size of the avatar in the profile. Right now its way to big on full. It would be nice to have a drop down setting to change everybody on the websites steam avatar size.

It would also be nice to haven an option to turn that off/on.

[Blackglade]

Originally Posted by Disasterpiece

I suggest you send me a pm with your forum details and an administrative account, also include a detailed description how you want it to appear, then I'll take a look myself.

OK i sent you the information, once again thanks a lot

[Disasterpiece]

Originally Posted by iSins

Is there away to make it so people who haven't linked there steam account to have a button saying "Link your steam account now" instead it saying "Sign in using steam"?

You could modify the graphic to say what you want it to say if you like.

Originally Posted by x3evolution

Disaster this is what i get when i have the issue

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT title, usergroupid FROM usergroup WHERE usergroupid IN (6,,37) ORDER BY title;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '37) ORDER BY title' at line 1
Error Number  : 1064
Request Date  : Tuesday, November 6th 2012 @ 11:58:15 AM
Error Date    : Tuesday, November 6th 2012 @ 11:58:17 AM
Script        : http://*****.org/admincp/user.php?do=edit&u=1
Referrer      : http://*****.org/admincp/index.php?l...3Dedit%26u%3D1
IP Address    : **.**.**.**
Username      : Ryan
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.27-cll

That must be related to the membergroup format issue I discussed a few posts earlier. Do you need immediate help with this? If so, please contact me with access to your database (phpmyadmin) or send me a PM, I'll explain you how to fix this by yourself if you prefer.

Originally Posted by jldrake

Can you add a steam connect option to set the size of the avatar in the profile. Right now its way to big on full. It would be nice to have a drop down setting to change everybody on the websites steam avatar size.

It would also be nice to haven an option to turn that off/on.

I'll look into it.

[Disasterpiece]

Another Update Time!

Today I included a bunch of fixes for functionalities and a critical bugfix which caused database errors in some cases.

v1.4.5rc3

- Fixed rare error with secondary usergroups being stored in the wrong format causing a Database Error
	(When updating the plugin file, a function repairs all existing database entries once)
- Fixed new user sometimes not being assigned the correct usergroups when registering/linking/unlinking
- Fixed scheduled/maintenance tasks not updating steam user's usergroups correctly
- Fixed stc_cache using object references instead of the actual values
- Fixed the user's display group sometimes not updating correctly
- Fixed scheduled/maintenance tasks clearing the cache, even if memcached system is used
- Fixed scheduled/maintenance tasks sometimes not writing their output into the logfile
- Fixed some typos/errors in the options description text
- Added the option to force an email address in quick register
- Added the option to force the primary steam usergroup as the display group
- Added the option to immediately check if the user is member of the specified steamgroup. This should be disabled if the steam
	group is too huge, (remember that for each page the script needs to query, the registration process is delayed 1 second)
	in which case the correct steamgroup dependant usergroup is assigned the next time the scheduled task runs.

You'll find a small patch process when updating the plugin file. Older versions of the mod just appended additional usergroups to the existing ones, this could lead to invalid strings like ,1 or 5,,6 which would cause database errors if they appeared. The patcher fixes those entries and the updated addon will make sure that this won't happen again.

Next are a few new options, the important ones being that you now can force steam users to enter an email address. At the beginning I thought that new users shouldn't be bothered with having to enter an email address but I respect many forum owners want to be able to send those users emails nontheless, so you're now able to turn on quick registration but have the user to enter an email address. This of course doesn't affect existing users which didn't enter one.

Next is the improved update functionality for handling with additional usergroups when a user registers with steam connect and is in the specified steam group. Last time this didn't work quite well, so now everything revolving about those groups and linking/unlinking forum accounts should work as intended.
Additionally, the scheduled job which keeps those associations updated runs every day at 4:00 am. If you want to increase the interval or change the time, you may do so in the scheduled task section of the admincp.

What you'll notice is a linkback at the footer of your forum to this vb.org mod page and to steam. Reason is, that steam does actually require a linkback to appear on any sites which use their API. This change follows the requirement and appends a linkback to this mod if someone is curious where to find this addon. This doesn't give me any benefits like revenue other than more popularity for the mod which again doesn't generate any money for me directly. You are welcome to donate a small amount if you really want to remove the backlink to this mod page, the steam backlink however must remain because I don't have any power over their rules.

As always, backup your forum before updating, download the newest archive file, upload all contents inside "upload" into your forum overwriting existing ones, then upload the new xml plugin file in your admincp choosing to update existing products.

Let me know if any issues come up.

[jaffaman]

Updated no problems

[Drunken F00l]

Originally Posted by Disasterpiece

- Added the option to immediately check if the user is member of the specified steamgroup. This should be disabled if the steam
group is too huge, (remember that for each page the script needs to query, the registration process is delayed 1 second)
in which case the correct steamgroup dependant usergroup is assigned the next time the scheduled task runs.

Why does this check need to take so long? I think you could use the ISteamUser/GetUserGroupList API. Ex:
http://api.steampowered.com/ISteamUser/GetUserGroupList/v0001/?key=<redacted>&format=xml&steamid=765611979684594 73

[CoZmicShReddeR]

I had to update mine twice to get it to show in admincp settings

FROM
product-steamconnect_1_4_4rc3.zip
TO
product-steamconnect_1_4_5rc3.zip

And the API and group settings was removed as well

Not complaining just might be my hosting...

[Disasterpiece]

Originally Posted by Drunken F00l

Why does this check need to take so long? I think you could use the ISteamUser/GetUserGroupList API. Ex:
http://api.steampowered.com/ISteamUser/GetUserGroupList/v0001/?key=<redacted>&format=xml&steamid=765611979684594 73

Thanks, wasn't aware I can use this too. I'll check if I can improve the function.

Originally Posted by CoZmicShReddeR

I had to update mine twice to get it to show in admincp settings

FROM
product-steamconnect_1_4_4rc3.zip
TO
product-steamconnect_1_4_5rc3.zip

And the API and group settings was removed as well

Not complaining just might be my hosting...

I re-arranged the settings, maybe that's why. But it shouldn't be a problem I hope.

[Drunken F00l]

Originally Posted by Disasterpiece

Thanks, wasn't aware I can use this too.

You can have a look at the ISteamWebAPIUtil/GetSupportedAPIList API to see all the APIs available. Just make sure to give it an API key like the other APIs otherwise you'll only see APIs available without an API key.