Advanced Slot Reservation 2.2.0

[Ant1Lamer]

Nice before 1.5.0 update servers show 33 slots now after update 32 did you work ? I use amxbans. evrything is last update in console plugin works no errors

 

[Shadows Adi]

Nice before 1.5.0 update servers show 33 slots now after update 32 did you work ? I use amxbans. evrything is last update in console plugin works no errors

It will show 33 slots only if VGUI_SUPPORT is 1 and the server is full.

 

[Ant1Lamer]

VGUI is 1 but show 32 or need to be full 32/32 to show 32/33 ?

 

[Shadows Adi]

VGUI is 1 but show 32 or need to be full 32/32 to show 32/33 ?

yes, it needs to be 32/32 and it will show 32/33.

 

[Ant1Lamer]

aaa okay thanks

 

[Ayk]

Shadows Adi, https://dev-cs.ru/threads/89/#Update

 

[Ant1Lamer]

I put plugin from server now server is 32/32 but cant show 32/33 for one moment show 32/33 i try to connect and Server is full VGUI is 1 ADMIN_SUPPORT is 2

I remove old(basic) adminslots and up plugin from plugins.ini now show 32/33 but when try to connect says Server is full try and in consosle with connect but same

 

[Shadows Adi]

Resource [ReAPI] Advanced Slot Reservation has been updated:

Updated to version 1.6.0!

Click on this link for update details

 

[Ant1Lamer]

Not work... show 32/33 but when try to connect Server is full

 

[Shadows Adi]

Not work... show 32/33 but when try to connect Server is full

Post the configuration file.

 

[Ant1Lamer]

Post the configuration file.

[Settings]
; Should kick algorithm include administrators?
; 0 - No // 1 - Yes
INCLUDE_ADMINS = 0

; Should kick algorithm include bots or hltv proxies?
; 0 - No // 1 - Yes
INCLUDE_BOTS = 1

; Kick a spectator player?
; If there is no spectator, take the next filter.
KICK_SPECTATOR = 1

; Kick a player by played time.
; 0 - No player played time check || 1 - Check for oldest player || 2 - Check for newest player
KICK_PLAYER_BY_PLAYTIME = 2

; Access flag which an administrator should have in order to reload configuration file.
RELOAD_FILE_ACCESS = a

; Admin immunity flag which won't be included in kick algorithm and which will be reserved if dynamic admin storage is used.
ADMIN_IMMUNITY_FLAG = b

; Kick message. Maximum lenght is 241.
KICK_MESSAGE = Kicked due reserved slot!

; Setinfo field required by a player to parse the password.
; setinfo _pw "password"
USERINFO_PASSWORD_FIELD = _pw

; Valve GUI support.
; 0 - disabled || 1 enabled
; If enabled, when server is full, it will show in server queries maxplayers + 1, to let players try to connect from GUI ( Double click in server list ).
; If disabled, reserved players should type in their console "connect SERVERIP:PORT" to connect on server and free a player slot for them.
VGUI_SUPPORT = 1

; Support for dynamically stored admins
; 0 - Disabled ( Takes data from [Reserved Slots] of this file ) || 1 - Enable ( Takes data from dynamic storage; users.ini or SQL Database Admins )
; || 2 - Same behaviour as (1) value but it also refreshes admin list when file is loaded / reloaded
; || 3 - Same behaviour as (1) value but it also keep the data from [Reserved Slots] section
ADMIN_SUPPORT = 2

[Reserved Slots]
; Here you can insert Reserved player data which you want to connect on server if the server is full.
; First parameter contains player's name or IP address which should be reserver. Second paramter can be only "Name", "IP" or "Password"
;
; Note 1! Password field will be checked for every player connecting when the server it's "full", if a player has in the setinfo field a password which is reserved, he will connect!
; Note 2! Checking for reservation info will be in the next order: First will be checked the Name, then the Password and finally IP address.
; Examples:
; "Adi" "Name"
; "192.168.100.201" "IP"
; "cool_thing" "Password"

I used amxbans 1.5.1

 

[Shadows Adi]

I used amxbans 1.5.1

How do you save your admins? If by SteamID, the plugin will skip players which have steamid as authentification data. Only Name / Password / IP authentification are loaded.

 

[Ant1Lamer]

Name and password i check the log and found this its possible that the problem and plugin not work ?

L 01/22/2022 - 01:59:53: [MySQL] Invalid info tuple handle: 0
L 01/22/2022 - 01:59:53: [AMXX] Displaying debug trace (plugin "amxbans_core.amxx", version "Gm 1.5.1")
L 01/22/2022 - 01:59:53: [AMXX] Run time error 10: native error (native "SQL_Connect")
L 01/22/2022 - 01:59:53: [AMXX] [0] amxbans_core.sma::adminSql (line 305)
L 01/22/2022 - 01:59:53: [AMXX] [1] amxbans_core.sma::cmdReload (line 410)

 

[Ant1Lamer]

When change map and make this error see the sma

 

[Shadows Adi]

When change map and make this error see the sma

Maybe you reload admins using a task which occurs at a short time after plugin_end() / in plugin_end(). In plugin_end() the tuple handle is freed

public plugin_end() {
    if(info != Empty_Handle) SQL_FreeHandle(info)
}

 

[Ant1Lamer]

its possible plugin not works for that or not ? And did you tested plugin with amxbans sql ? I tests plugin with ini file and work but with sql amxbans not work. I used 1.10 mod no errors nothing evrything is lasp update

 

[Shadows Adi]

its possible plugin not works for that or not ? And did you tested plugin with amxbans sql ? I tests plugin with ini file and work but with sql amxbans not work. I used 1.10 mod no errors nothing evrything is lasp update

I tested official AmxBans and it worked. It seems in this version of AmxBans ( Gm 1.5.1 ) it store admin's steamid not name. I attached the modified version of that. Changes made:

Line 323: formatex(temp,1023,"SELECT aa.steamid,aa.password,aa.access,aa.flags,aa.nickname,ads.custom_flags,ads.use_static_bantime \
            FROM PREFIX_amxadmins as aa, PREFIX_admins_servers as ads, PREFIX_serverinfo as si \
            WHERE ((ads.admin_id=aa.id) AND (ads.server_id=si.id) AND \
            ((aa.days=0) OR (aa.expired>UNIX_TIMESTAMP(NOW()))) AND (si.address='%s'))",g_ServerAddr)
            
->>

formatex(temp,1023,"SELECT aa.username,aa.password,aa.access,aa.flags,aa.nickname,ads.custom_flags,ads.use_static_bantime \
            FROM PREFIX_amxadmins as aa, PREFIX_admins_servers as ads, PREFIX_serverinfo as si \
            WHERE ((ads.admin_id=aa.id) AND (ads.server_id=si.id) AND \
            ((aa.days=0) OR (aa.expired>UNIX_TIMESTAMP(NOW()))) AND (si.address='%s'))",g_ServerAddr)


Line 337: new qcolAuth = SQL_FieldNameToNum(query, "steamid")

->>

new qcolAuth = SQL_FieldNameToNum(query, "username")

 

[Ant1Lamer]

aaaa... thanks apologize my mistake a from this task can you help where and how to make

 

[Shadows Adi]

aaaa... thanks apologize my mistake a from this task can you help where and how to make

Seems that the md5 hashing is deprecated, let me update the script above.

 

[Ant1Lamer]

okayy now i no have access i not admin :D