Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: DF_rslots_slots

  1. #1
    JaySingh's Avatar



    Join Date
    Feb 17, 2010
    Last Online
    Oct 02, 2011
    Posts
    50
    Threads
    17



    DF_rslots_slots


    I won't be needing SourceMod anymore, so it looks like I'll be using SourceOP only from now on. As a result of this, I'll have to use reserved slots as a way to support my servers. So a couple of questions regarding reserved slots and MySQL.

    - what the hell is DF_rslots_slots?
    - how do reserved slots work? does it kick players with the lowest kpdr?
    - does reloading the reserved slot database at a set interval cause the server to lag?
    - does DF_sql_playerdatabase 1 log everyone's name and steam id to the database?
    - do all the tables and what not get generated by SourceOP?

    Oh, and how would I get the hlx / gameME plugin for SourceOP to work?

  2. #2
    Drunken F00l's Avatar



    Join Date
    Dec 11, 2004
    Last Online
    Jun 11, 2019
    Posts
    5,874
    Threads
    182
    Reputation
    SourceOP Thread


        
    Steam: 76561197968459473 
    Steam join date: Aug 23, 2004
    Steam Level: 56
    Profile Status: Public



    DF_rslots_slots controls the maximum number of players allowed to connect using their reserved slot. For example, if set to 16, once there are 16 players on the server with reserved slots, no more players can use their reserved slot to kick someone off. This ensures you maintain at least a few new or non-paying members. Just set it to the number of maxplayers if you don't want the limit.

    It kicks based on points per death.

    Yes, DF_sql_playerdatabase will log names and connections.

    SourceOP doesn't generate the tables. You'll need this sql file.

    The hlx/gameME stuff should just work if you have lua enabled. There should be some lua scripts included for the hlx_ commands. This is the same as the "Beetlesmod" option in the gameME control panel.

  3. #3
    JaySingh's Avatar



    Join Date
    Feb 17, 2010
    Last Online
    Oct 02, 2011
    Posts
    50
    Threads
    17




    Quote Originally Posted by Drunken_F00l
    SourceOP doesn't generate the tables. You'll need this sql file.
    #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 '' at line 23

  4. #4
    JaySingh's Avatar



    Join Date
    Feb 17, 2010
    Last Online
    Oct 02, 2011
    Posts
    50
    Threads
    17




    Well, what I did was manually copy and paste each section of the SQL file. Hopefully that works.

    EDIT: Yup, looks like it did.

  5. #5
    JaySingh's Avatar



    Join Date
    Feb 17, 2010
    Last Online
    Oct 02, 2011
    Posts
    50
    Threads
    17




    Alright so I got the database to connect to the server (bans work and what not), but I'm having trouble getting reserved slots to work.

    I hooked up the database and what not with my donate page so here's what the tables are at the moment.

    id - 1
    steamid - my steamid
    name - my in-game name
    ip1, ip2, ip3 - 00000000
    donated - tested $5, $15, $200, $2000, non worked
    time stamp / last update - 0
    expiration - 1311627531
    profileid - 0

    We tested on a 4 slot server. We had 4 people connect to the server and the guy who was added to the database tried to connect. It said the server was full. We have sv_visiblemaxplayers set to 4 as well.

  6. #6
    Drunken F00l's Avatar



    Join Date
    Dec 11, 2004
    Last Online
    Jun 11, 2019
    Posts
    5,874
    Threads
    182
    Reputation
    SourceOP Thread


        
    Steam: 76561197968459473 
    Steam join date: Aug 23, 2004
    Steam Level: 56
    Profile Status: Public



    Is DF_rslots_enabled 1

  7. #7
    zachcheatham's Avatar



    Join Date
    Jan 27, 2011
    Last Online
    Jul 16, 2011
    Posts
    4
    Threads
    2




    How is the expiration field used in the rslots table?

  8. #8
    Drunken F00l's Avatar



    Join Date
    Dec 11, 2004
    Last Online
    Jun 11, 2019
    Posts
    5,874
    Threads
    182
    Reputation
    SourceOP Thread


        
    Steam: 76561197968459473 
    Steam join date: Aug 23, 2004
    Steam Level: 56
    Profile Status: Public



    It's for when the slot expires. If the expiration time passes the slot is expired and the table row is deleted eventually.

  9. #9
    JaySingh's Avatar



    Join Date
    Feb 17, 2010
    Last Online
    Oct 02, 2011
    Posts
    50
    Threads
    17




    Well, I got reserved slots working. My problem was not entering the profile ID of the user. Looks like I'll have to grab that from the database as well.

    I got another problem :-/.

    Is there any reason why the gameME plugin doesn't display any in-game chat text information?

    Here's my situation.

    Server A - works as it should (rank displays the rank menu, the points gained and lost are displayed in chat, place displays your rank to the entire server in chat)

    Server B - has the same settings in the gameME panel as Server A, has SourceOP installed / same server-side settings as server A, but only the rank command works. The points gained and lost are NOT displayed in chat, and place displays nothing. In other words, anything dealing with the chat that gameME is supposed to output doesn't work.

    Here's a random part of the console of the server that isn't working:

    Code:
    22:18:12 "PolecatEZ<926><STEAM_0><Red>" triggered "kill assist" against "MoTh??La?dâ„¢<960><STEAM_0><Blue>" (assister_position "487 -761 3") (attacker_position "-78 -153 12") (victim_position "-307 -686 4")
    22:18:13 
    
    rcon from "85.214.223.36:56973": command "hlx_psay "ARRAY(0xc5ba560)" 1 "GEPs are FOREVER (2,723) got 5 points for Built Object - Sentrygun""
    22:18:13 
    
    rcon from "85.214.223.36:56973": command "hlx_psay "ARRAY(0xa550880)" 1 "P. Jacob (2,163) got 7 points [-2] for killing MoTh??La?dâ„¢ (3,704)""
    22:18:13 
    
    rcon from "85.214.223.36:56973": command "hlx_psay "ARRAY(0xb5df0a0)" 1 "PolecatEZ (21,083) got 2 points for Kill Assist""
    It looks like it should be working, but it just won't display for some odd reason.

  10. #10
    Drunken F00l's Avatar



    Join Date
    Dec 11, 2004
    Last Online
    Jun 11, 2019
    Posts
    5,874
    Threads
    182
    Reputation
    SourceOP Thread


        
    Steam: 76561197968459473 
    Steam join date: Aug 23, 2004
    Steam Level: 56
    Profile Status: Public



    Ya something is definitely wrong on their end. Check out that command they're sending you. hlx_psay ARRAY(0xbleh). Wtf is that?

Page 1 of 2 12 LastLast

Tags for this Thread