Raised This Month: $51 Target: $400
 12% 

Showing results 1 to 9 of 9
Search took 0.02 seconds. Search: Posts Made By: Scuzzy
Forum: Snippets and Tutorials 09-19-2008, 07:08
Replies: 358
Views: 550,331
Posted By Scuzzy
Re: Convert STEAMID to Steam Community ID

Atreus, use the SQL, mySQL will do the math just fine. (I'm the one who originally wrote the SQL) Get with me at the [o-t] if you need more help chief. Good to see ya.

Scuzzy
Forum: Snippets and Tutorials 02-04-2008, 18:14
Replies: 358
Views: 550,331
Posted By Scuzzy
Re: Convert STEAMID to Steam Community ID

We have something similar, but are the icons actually from the steam friends? If so, how'd you translate the steam_friends id into an avatar gif?

Thanks!
Scuzzy
Forum: Snippets and Tutorials 01-22-2008, 22:41
Replies: 358
Views: 550,331
Posted By Scuzzy
Re: Convert STEAMID to Steam Community ID

You didn't add the 1 to the second steam_id:

STEAM_0:0:123456 = 0 + 76561197960265728 + (123456*2)
STEAM_0:1:123456 = 1 + 76561197960265728 + (123456*2)

Scuzzy
Forum: Snippets and Tutorials 01-22-2008, 00:11
Replies: 358
Views: 550,331
Posted By Scuzzy
Re: Convert STEAMID to Steam Community ID

Done.
Forum: Snippets and Tutorials 01-19-2008, 21:42
Replies: 358
Views: 550,331
Posted By Scuzzy
Re: Convert STEAMID to Steam Community ID

BTW, for anyone interested in doing this strictly in mySQL, like a trigger to calculate this field when you create a player record... I found some issues getting mySQL to actually ADD the numbers...
Forum: Snippets and Tutorials 01-17-2008, 12:20
Replies: 358
Views: 550,331
Posted By Scuzzy
Re: Convert STEAMID to Steam Community ID

I understand the worry, but we've had the system for years and it's worked well. 99% of this type of ban are two people are playing from the same IP the same night. I'm not aware of how many people...
Forum: Snippets and Tutorials 01-16-2008, 22:05
Replies: 358
Views: 550,331
Posted By Scuzzy
Re: Convert STEAMID to Steam Community ID

You mean it one guy gets banned, gives up his IP addr and another guy with the same game gets that IP and trys to connect to our server? Yes. We did think of that, but considering the requirements...
Forum: Snippets and Tutorials 01-16-2008, 15:54
Replies: 358
Views: 550,331
Posted By Scuzzy
Re: Convert STEAMID to Steam Community ID

Thank you. We have a perl process that watches the database and server for bans. It executes the following process once an account has been perm banned:

1) Get all IPs registered for the account,...
Forum: Snippets and Tutorials 01-16-2008, 12:06
Replies: 358
Views: 550,331
Posted By Scuzzy
Re: Convert STEAMID to Steam Community ID

I just wanted to pay homage and say thanks to Voogru for posting this, it's come in EXTREMELY handy. We use in our server administration and it helps greatly. Thanks!
...
Showing results 1 to 9 of 9

 
Forum Jump

All times are GMT -4. The time now is 12:18.

DMCA - Archive - Top

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode