Checking from DB
How to check if a player has registered his steamid or ip in mysql.
Lets say that i own a site and there you can enter your steamid or ip.My question is how to check if there is such information written. If there is any to give him some privilege if not to return "you are not signed" or smth like that. |
Re: Checking from DB
Post your database layout (if any).
And read this: http://forums.alliedmods.net/showpos...18&postcount=5 |
Re: Checking from DB
Quote:
I've decided to check for steamid from DB and check session for nonsteam users,because some ppl have dynamic IPs. Here is the DB Code:
CREATE TABLE IF NOT EXISTS `users` (Code:
$session=session_id();I will give more additional info if needed. |
Re: Checking from DB
Non-Steam users have STEAM_ID_LAN / STEAM_ID_PENDING as their authids.
Use SQLx to query your database. I'm not coding it for you, this is Scripting Help, not Suggestions / Requests. |
Re: Checking from DB
SELECT id FROM users WHERE steamid='here steam id' OR ip='here ip' LIMIT 1;
then check row num or nextrow... Just read the SQLx Tutorial. |
| All times are GMT -4. The time now is 08:40. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.