Raised This Month: $ Target: $400
 0% 

Server Redirect 1.1 [Last update: Februari 7, 2009]


Post New Thread Reply   
 
Thread Tools Display Modes
Author
zerak
Senior Member
Join Date: Feb 2008
Plugin ID:
697
Plugin Version:
1.1
Plugin Category:
General Purpose
Plugin Game:
Any
Plugin Dependencies:
    Servers with this Plugin:
    19 
    Plugin Description:
    Used to redirect players to other servers.
    Old 01-01-2009 , 20:26   Re: Server Redirect
    Reply With Quote #1

    [req] sort them by their id instead of by there names when displaying to clients in the menu
    edit: nvm will change sql query to sort tomorrow

    Last edited by zerak; 01-01-2009 at 21:04.
    zerak is offline
    wolf_cci
    Junior Member
    Join Date: Oct 2008
    Old 06-05-2009 , 23:26   Re: Server Redirect 1.1 [Last update: Februari 7, 2009]
    Reply With Quote #2

    getting this error when i try to import the tables

    SQL query:
    --
    -- Database: `serverredirect`
    --
    - - CREATE DATABASE `serverredirect` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


    MySQL said:
    #1064 - 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 '--CREATE DATABASE `serverredirect` DEFAULT CHARACTER SET latin1 COLLATE latin1_s' at line 1
    __________________
    wolf_cci is offline
    Richard.UK
    Junior Member
    Join Date: Jul 2009
    Old 07-26-2009 , 00:29   Re: Server Redirect 1.1 [Last update: Februari 7, 2009]
    Reply With Quote #3

    OK any help would be appreciated as to why my Gameserver will not communicate with my MYSQL server?

    Basically i've tried fo hours trying to figure this out and still no joy...I really hope someone understands what is incorrect here:

    Used PHPMY Admin to create the "Server" Table. running the query obviously very quick to create, then the additional server rows (I have 4) using the following command:
    Code:
    INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
    (1, '217.163.31.207:27015', 1, '2008-12-31 00:00:00', 'TF2 UK | {MAP} | {CURR}/{MAX}', 'TF2 UK | OFFLINE', 0, 0, '[no map]');
    INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
    (2, '216.245.211.61:27015', 1, '2008-12-31 00:00:00', 'TF2 US | {MAP} | {CURR}/{MAX}', 'TF2 US | OFFLINE', 0, 0, '[no map]');
    INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
    (3, '212.187.209.75:27015', 2, '2008-12-31 00:00:00', 'CSS UK | {MAP} | {CURR}/{MAX}', 'CSS UK | OFFLINE', 0, 0, '[no map]');
    INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
    (4, '85.234.148.165:27055', 2, '2008-12-31 00:00:00', 'CSS WCS | {MAP} | {CURR}/{MAX}', 'CSS WCS | OFFLINE', 0, 0, '[no map]');
    Databases Config File:
    Code:
    {
                "driver"               "mysql"
                "host"                 "http://*****.****.***"
                "database"           "serverredirect" <--- created via control panel
                "user"                  "**********" <--- created via control panel
                "pass"                  "**********" <--- created via control panel
                //"timeout"                "0"
                "port"                "2082"
            }
    User access given:
    Code:
    FULL CONTROL
    Remote MYSQL has my server IP added to Allow:
    Code:
    217.163.31.207
    Added databases.cfg to whitelist.cfg using the following:
    Code:
    "add"        "addons/sourcemod/configs/databases.cfg"
    When reloading the server I have followed this process:
    Code:
    Log onto Gameserver control Panel > STOP SERVER > START SERVER
    When I type !server, the horrible statement of sorry can not find the servers appears. I would highly value anybodies help in correcting this problem with communication between MYSQL and sourcemod...Although please bear in mind I am not an idiot hence why I have taken 6 hour and more to post here. This is probably as usual something simple which I am missing out

    All the Very Best,
    Richard

    Last edited by Richard.UK; 07-26-2009 at 00:41.
    Richard.UK is offline
    Sexual Harassment Panda
    Veteran Member
    Join Date: Dec 2008
    Location: San Diego, CA
    Old 07-26-2009 , 00:34   Re: Server Redirect 1.1 [Last update: Februari 7, 2009]
    Reply With Quote #4

    did you connect your user to your database and give it full access?
    __________________
    Sexual Harassment Panda is offline
    Kenny Loggins
    SourceMod Donor
    Join Date: Jun 2008
    Location: Rochester, MN
    Old 07-30-2009 , 00:03   Re: Server Redirect 1.1 [Last update: Februari 7, 2009]
    Reply With Quote #5

    Code:
    {
                "driver"               "mysql"
                "host"                 "http://*****.****.***"
                "database"              "serverredirect" <--- created via control panel
                "user"                  "**********" <--- created via control panel
                "pass"                  "**********" <--- created via control panel
                //"timeout"           "0"
                "port"                   "2082"
            }
    User access given:

    you should not have the http:// or the port in the "host" line just the IP address of your MySql server

    Code:
     
            "serverredirect"
            {
                "driver"               "mysql"
                "host"                 "66.99.66.99"
                "database"             "serverredirect"
                "user"                  "**********"
                "pass"                  "**********"
                //"timeout"          "0"
                "port"                  "2082"
            }
    Code:
    Added databases.cfg to whitelist.cfg using the following:
    "add"        "addons/sourcemod/configs/databases.cfg"
    You don't need this in your whitelist at all

    Try that and let me know.
    __________________

    Server Admin / Leader
    ClanAO.com

    Last edited by Kenny Loggins; 07-30-2009 at 00:08.
    Kenny Loggins is offline
    HiddenConn1
    AlliedModders Donor
    Join Date: Aug 2009
    Location: Cambridge, UK
    Old 09-22-2009 , 21:12   Re: Server Redirect 1.1 [Last update: Februari 7, 2009]
    Reply With Quote #6

    How many fields in the new DB?
    __________________
    HiddenConn1 is offline
    olsesacl
    Junior Member
    Join Date: Mar 2009
    Old 10-08-2009 , 21:10   Re: Server Redirect 1.1 [Last update: Februari 7, 2009]
    Reply With Quote #7

    This is a great plugin, I can now use it on L4D.

    modified to work with L4D right:

    Original
    PHP Code:
    if (itemCount 0)
            {
                
    DisplayMenu(hRedirMenuclient30);
            }
            else
            {
                
    CloseHandle(hRedirMenu);
                
    PrintToChat(client"%T""redir no servers"clientCHAT_COLOR);
            } 
    Mod:
    PHP Code:
    if (itemCount 0)
            {
                
    DisplayMenu(hRedirMenuclient30);
                
    ClientCommand(client"bind F4 \"askconnect_accept\"");
            }
            else
            {
                
    CloseHandle(hRedirMenu);
                
    PrintToChat(client"%T""redir no servers"clientCHAT_COLOR);
            } 
    Sorry for my bad English
    Attached Files
    File Type: sp Get Plugin or Get Source (serverredirect.sp - 97 views - 18.8 KB)
    File Type: smx serverredirect.smx (10.3 KB, 108 views)

    Last edited by olsesacl; 10-09-2009 at 09:10.
    olsesacl is offline
    BlastaMasta
    New Member
    Join Date: Aug 2015
    Old 08-16-2015 , 02:45   Re: Server Redirect 1.1 [Last update: Februari 7, 2009]
    Reply With Quote #8

    Where the config? I cant find it.
    BlastaMasta is offline
    Reply


    Thread Tools
    Display Modes

    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 21:40.


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