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)

I get the following error:

Code:

Database error in vBulletin 4.1.11:



Invalid SQL:

ALTER TABLE `user` ADD `steam_link` VARCHAR( 128 ) NOT NULL ;;



MySQL Error   : Duplicate column name 'steam_link'

How would I fix this? Delete the column that already exists?

Quote:

Originally Posted by joshskeety (Post 2307719)

I can report that I receive the error

"Empty or invalid Steam ID transfered!" as well when trying to link the accounts. Here is what is generated in the log file:

Code:

[22:44, 8th Mar 2012] While transferring login process, the cached steam softlink seems to have vanished. Here's what we have:

[22:44, 8th Mar 2012] Array

(

    [51814c9c38be3da806fbacbe8267c9b7] => 76561198038410008

    [81bec68a9392a62de9963c4a0e43a546] => 76561198038410008

    [2cf580ab9d6b9afa65f0a84813fe7017] => 76561198045049347

    [cf2016a3fc0da59edaf7b8a33251628c] => 76561198045049347

    [e40f383a9e3053fb0688aaffaeafad5c] => 76561198038410008

    [5d4ed14e9738d8bb8b9591e2f190d766] => 76561198038410008

    [ede4133f444d574cb030126dae216614] => 76561198038410008

    [0879eed6a816bf46723639e75600cce7] => 76561198045049347

    [30d9bb09adcb6568767d396bebe3b0d3] => 76561198045049347

    [d71add05d151e77cb07d88dfaa271bdb] => 76561198045049347

    [dc738c27cebef09fb0e23c290f87a72c] => 76561198038410008

    [19619a6eca30f9acd8604763d9b36ffe] => 76561198038410008

)



[22:44, 8th Mar 2012] ---

Another thing I notice, is that if I simply register an account with quick register, it works but when I log in I return to the forum and I do not appear to be logged in at all.

The only ways when the softlink transfer may fail is if
a) the session id changes between clicking the "sign in through steam" button and the completion of the steam community sign-in. Which may happen once in a while but reproducable?
b) the datastore somehow doesn't save the softlink or can't fully retrieve all the data.

b is more likely but may be the case if you use non-standard mods or methods which interfere with the datastore.
Maybe you use memcached or xcache to speed-up the datastore? Is this the case?
Or do you use multiple master-master or master-slave database setups?

To explain a bit what causes this and how the process works:
if the user wants to register, he first gets directed to the steamcommunity to prove his steamid.
To avoid that the user changes the steamid in the last register step, the steamid is saved server-side as a softlink in the datastore, so we can set the user's steamid to the id which was retrieved through the steam openid-api in the first step.
It must be somehow related with vbulletin, as the script works on most other forums and configurations. But for me to help you I need to know what different settings/mods/whatever you use to a vanilla vb4/apache2/php setup.

Problem fixed. The person who setup the forum commented out the setting for caching method (Meaning datastore was also disabled).

So if anyone runs in to this issue, check that.

So right now this is what I have in my postbit_legacy:

PHP Code:


		
			
<img src="{vb:raw post.steamavatarmedium}" alt="{vb:rawphrase xs_avatar, {vb:raw post.username}}" title="{vb:rawphrase xs_avatar, {vb:raw post.username}}" />

However I notice the avatars will every once in a while display and then disappear and I'll be left with the alt text instead.

Question...

1. Will you be added SteamID connect to registration and the option to add it to a userfield

2. Will you allow users to use their Steam avatar as their forum avatar?

Quote:

Originally Posted by joshskeety (Post 2309350)

So right now this is what I have in my postbit_legacy:

PHP Code:


		
			
<img src="{vb:raw post.steamavatarmedium}" alt="{vb:rawphrase xs_avatar, {vb:raw post.username}}" title="{vb:rawphrase xs_avatar, {vb:raw post.username}}" />

However I notice the avatars will every once in a while display and then disappear and I'll be left with the alt text instead.

Appears that you have the same issue as mentioned by me here? :(

Quote:

Originally Posted by MadMakz (Post 2309903)

Appears that you have the same issue as mentioned by me here? :(

Appears so. I also get each avatar displayed fine by looking at their details page.

No solutions or possible ideas on why Avatars will show randomly or with certain users and not display with other users who are linked?

hm not really. The url should be correct but if the avatar just doesn't show up then somehow steam must be the cause.

In the next version which should be released somewhen around april-june there will be an optional caching for those steam avatars which should solve the problem.

Quote:

Originally Posted by Disasterpiece (Post 2312054)

Thanks man.

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 (2)bbcode_code_printable (2)bbcode_php_printable (4)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.01421 seconds Memory Usage 1,752KB 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 (2)bbcode_code_printable (2)bbcode_php_printable (4)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: