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

SteamID Restrict MySQL


Post New Thread Reply   
 
Thread Tools Display Modes
Author
sEbbo
Member
Join Date: May 2010
Plugin ID:
1830
Plugin Version:
1.0
Plugin Category:
General Purpose
Plugin Game:
Any
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    Kicks everyone who is not listed in the chosen MySQL-database.
    Unapprover:
    Reason for Unapproving:
    Doesn't work. SQL issues
    Old 07-27-2010 , 17:45   SteamID Restrict MySQL
    Reply With Quote #1

    Admin may remove this plugin now.
    Attached Files
    File Type: sp Get Plugin or Get Source (steamid-restrict-mysql.sp - 758 views - 1.2 KB)
    File Type: zip SteamID-Restrict-MySQL.zip (5.2 KB, 311 views)

    Last edited by sEbbo; 09-07-2012 at 07:24.
    sEbbo is offline
    PieOnEar
    Member
    Join Date: Jul 2010
    Old 07-28-2010 , 14:44   Re: SteamID Restrict MySQL
    Reply With Quote #2

    Would be useful for friends-only parties, or custom gamemode tests.
    PieOnEar is offline
    matrixmark
    Senior Member
    Join Date: Jun 2010
    Old 07-28-2010 , 15:01   Re: SteamID Restrict MySQL
    Reply With Quote #3

    I'm liking this thanks
    matrixmark is offline
    marvel
    BANNED
    Join Date: Dec 2009
    Old 07-28-2010 , 16:49   Re: SteamID Restrict MySQL
    Reply With Quote #4

    Very nice! Very usefull for VIP/donate/friends/test servers.

    Thanks a bunch!
    marvel is offline
    sEbbo
    Member
    Join Date: May 2010
    Old 07-28-2010 , 17:03   Re: SteamID Restrict MySQL
    Reply With Quote #5

    Yeah, also perfect for mix servers, like cssmixes.co.uk
    sEbbo is offline
    sEbbo
    Member
    Join Date: May 2010
    Old 07-31-2010 , 18:58   Re: SteamID Restrict MySQL
    Reply With Quote #6

    What edits should I do to make this plugin approved?
    sEbbo is offline
    Sillium
    AlliedModders Donor
    Join Date: Sep 2008
    Location: Germany
    Old 08-02-2010 , 07:01   Re: SteamID Restrict MySQL
    Reply With Quote #7

    How to get approved: http://forums.alliedmods.net/showthread.php?t=57142
    http://forums.alliedmods.net/showthread.php?t=119234
    Quote:
    Due to the amount of plugins in the New Plugins section a plugin review date has been setup. On the last Sunday of every month, plugins with a thread start date of over 60 days will either be approved or unapproved.
    __________________
    brb, dishes have developed their own language and are talking to the garbage about overthrowing me... i must correct this

    www.unterwasserpyromanen.de
    Sillium is offline
    duydangle
    Senior Member
    Join Date: May 2010
    Old 08-02-2010 , 20:55   Re: SteamID Restrict MySQL
    Reply With Quote #8

    Can you guys make another plugin like restrict registered user (through web and mysql), not steam ID?
    Everyone has to have these commands:
    setinfo _pw "pw"
    setinfo _name "registered name"

    Last edited by duydangle; 08-02-2010 at 20:57.
    duydangle is offline
    sEbbo
    Member
    Join Date: May 2010
    Old 08-02-2010 , 22:13   Re: SteamID Restrict MySQL
    Reply With Quote #9

    Quote:
    Originally Posted by duydangle View Post
    Can you guys make another plugin like restrict registered user (through web and mysql), not steam ID?
    Everyone has to have these commands:
    setinfo _pw "pw"
    setinfo _name "registered name"
    You could make a request at https://forums.alliedmods.net/forumdisplay.php?f=60
    sEbbo is offline
    Thrawn2
    Veteran Member
    Join Date: Apr 2009
    Old 08-03-2010 , 05:44   Re: SteamID Restrict MySQL
    Reply With Quote #10

    uhm, you should not fetch all data from your db and iterate over all rows
    take a look here.


    your sql query should rather look like this:
    PHP Code:
    hQuery SQL_Query(db,"SELECT steam-id FROM steamid_restrict where steam-id = '%s'"ClientAuth
    furthermore i encourage you to use #pragma semicolon 1
    you will write cleaner code ;)
    __________________
    einmal mit profis arbeiten. einmal.
    Thrawn2 is offline
    Reply



    Posting Rules
    You may not post new threads
    You may not post replies
    You may not post attachments
    You may not edit your posts

    BB code is On
    Smilies are On
    [IMG] code is On
    HTML code is Off

    Forum Jump


    All times are GMT -4. The time now is 10:20.


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