vb.org Archive - Integration with vBulletin - Steam Connect - Sign in with your Steam Account! [RC3]

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Integration with vBulletin - Steam Connect - Sign in with your Steam Account! [RC3] (https://vborg.vbsupport.ru/showthread.php?t=266883)

Disaster this is what i get when i have the issue

Code:

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

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.

Quote:

Originally Posted by Disasterpiece (Post 2378826)

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 :D

Quote:

Originally Posted by iSins (Post 2378899)

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.

Quote:

Originally Posted by x3evolution (Post 2378911)

Disaster this is what i get when i have the issue

Code:

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.

Quote:

Originally Posted by jldrake (Post 2378914)

I'll look into it.

Another Update Time!

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

Code:

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.

Updated no problems :)

Quote:

Originally Posted by Disasterpiece (Post 2379231)

- 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

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

Quote:

Originally Posted by Drunken F00l (Post 2379244)

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

Quote:

Originally Posted by CoZmicShReddeR (Post 2379327)

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

Quote:

Originally Posted by Disasterpiece (Post 2379470)

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.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01515 seconds Memory Usage 1,762KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: