AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Ask questions about errors and problems related to the amxbans project.
The more details you give, the better answer you will receive, READ the sticky topics before posting!

Be sure to post in the right sub forum: Bugs and Security
thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 11 Mar 2020, 16:50

I am having a hard time getting amxbans to work. It doesn't seem to be connecting the game server to where the web folder where amxbans is located. Thank you in advance for any help to resolve this.

AMXBans Website Version 6.14.4
Webserver Apache
PHP Version 7.1.14
MySQL Version 5.6.41-84.1


======= CONFIGs & INIs =================================

/dod/addons/amxmodx/configs/amxbans.cfg
// AMXBans Configuration File
// File location: $moddir/addons/amxmodx/configs/amxbans.cfg
echo [AMXBans] is starting to execute amxbans.cfg

// Your SQL database prefix
// NOTE: The Prefix defined in your sql.cfg is NOT used for AMXBans anymore!!!
amx_sql_prefix "thescary_"

// How AMXBans should handle the admins
// 0 = SQL, 1 = users.ini, 2 = load no admins
// SHOULD THIS BE SQL or USERS.INI
amxbans_use_admins_file 0

// AMXBans tries to get the address from the server automatically.
// You can set a different one here - ex. "<ip>:<port>"
amxbans_server_address "108.167.161.99:27015"


// Number of players in the Disconnected Menu
amxbans_discon_players_saved 10

// Bantime to use for custom banreasons, if a user has static bantime <minutes>
// -1 to disable custom reasons
amxbans_custom_statictime 1440

// Set this cvar to what the adminname should be on the webpages, if the server make the ban.
// Ie. amxbans_servernick "My Great server"
// Leave emty if you want to use the default hostname from server.cfg
amxbans_servernick ""

// Set this to 1 / 2 / 3 to enable debug messages from amxbans to amxx logs.
// with debug 3 you get the most output, but a bug can flood your logs. 2 should be ok normally
amxbans_debug 3

// Don't use http:// in this cvar. The url will be shown to banned players in the console.
amxbans_complain_url "tekservers.net/forums/viewforum.php?f=9"

// Set this to 1 if you want the map name to show in the DB.
amxbans_add_mapname_in_servername 1

// If you want to see ban announcments in the HLSW chat, set this to 1
amxbans_show_in_hlsw 1

// Print green hudmessages on the top left when banning
amxbans_show_hud_messages 1

// What flag should admins have to get the high ban times.
amxbans_higher_ban_time_admin "n"

// What flag should admins have to NOT get their Nick printed when banning/Unbanning
amxbans_admin_mole_access "r"

// If an admin has the admin_mole_access, should his name be shown when he bans?
amxbans_show_name_evenif_mole 1

// Show if a player has been banned before as amx_chat to admins. 0 to disable
amxbans_show_prebanned 1

// How many previous offences does the player needs, to be notified in the amx_chat?
amxbans_show_prebanned_num 2

// Currently not known
amxbans_default_ban_reason TKing

// To be able to ban players not in the server. 1 enabled and 0 disabled.
amxbans_ban_evenif_disconnected 1

// Flagtimes, like the bantimes below
amx_setflagtimes "1 h" "4 h" "10 h" "1 d" "1 w" "4 w" "12 w"

// Ban times for admins with d-flag, set the highest time in minutes they can ban with "amx_ban"
// IMPORTANT: Put the lowest value first and the highest value last. You can have 1 to 14 values
// "0 m" = permanent ban!
// Values you can use:
// 1 - 59 with the flag m is for minutes
// 1 - 23 with the flag h is for hours
// 1 - 6 with the flag d is for days
// The w flag is for weeks

// Example:
// "5 m" is 5 minutes
// "1 h" is 1 hour
// "1 d" is 1 day
// "1 w" is 1 week

amx_setlowbantimes "5 m" "30 m" "1 h" "3 h" "10 h" "1 d"

// Ban times for admin with n-flag and d-flag
// IMPORTANT: Put the lowest value first and the highest value last. You can have 1 to 14 values
// "0 m" = permanent ban!
// Values you can use:
// 1 - 59 with the flag m is for minutes
// 1 - 23 with the flag h is for hours
// 1 - 6 with the flag d is for days
// The w flag is for weeks
//
// Example:
// "5 m" is 5 minutes
// "1 h" is 1 hour
// "1 d" is 1 day
// "1 w" is 1 week

amx_sethighbantimes "5 m" "30 m" "1 h" "3 h" "1 d" "1 w" "0 m"

/*********************************************************************************/

// 3rd party amxbans plugins
// needs the amxbans_freeze plugin
//
// "a" = freeze
// "b" = strip weapons
// "c" = block chat
// "d" = player glow red (not tested)
amxbans_freeze_mode "abc"

// Use the flagging only for this Server, or for all servers?
// needs the amxbans_flagged plugin
amxbans_flagged_all_server 1

/*********************************************************************************/

// AMXBans configuration file echo
echo [AMXBans] amxbans.cfg is fully executed


/dod/addons/amxmodx/configs/plugins.ini
; AMX Mod X plugins

; Admin Base - Always one has to be activated
amxbans_core.amxx
amxbans_main.amxx debug
admin_amxbans.amxx ;admin_amxbans.amxx SHOULD THIS BE ON??? <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
;amxbans.amxx ;amxbans SHOULD THIS BE ON??? <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
;admin.amxx ; admin base (required for any admin-related)
;admin_sql.amxx ; admin base - SQL version (comment admin.amxx)

; Basic
admincmd.amxx ; basic admin console commands
adminhelp.amxx ; help command for admin console commands
;adminslots.amxx ; slot reservation
multilingual.amxx ; Multi-Lingual management

; Menus
menufront.amxx ; front-end for admin menus
cmdmenu.amxx ; command menu (speech, settings)
plmenu.amxx ; players menu (kick, ban, client cmds.)
;telemenu.amxx ; teleport menu (Fun Module required!)
mapsmenu.amxx ; maps menu (vote, changelevel)
pluginmenu.amxx ; Menus for commands/cvars organized by plugin

; Chat / Messages
adminchat.amxx ; console chat commands
antiflood.amxx ; prevent clients from chat-flooding the server
scrollmsg.amxx ; displays a scrolling message
;imessage.amxx ; displays information messages
adminvote.amxx ; vote commands

; Map related
nextmap.amxx ; displays next map in mapcycle
:mapchooser.amxx ; allows to vote for next map
timeleft.amxx ; displays time left on map

; Configuration
pausecfg.amxx ; allows to pause and unpause some plugins
statscfg.amxx ; allows to manage stats plugins via menu and commands

; Day of Defeat
stats.amxx ; stats on death or round end (DoD Module required!)
statssounds.amxx ; precache plugin for stats plugins
;stats_logging.amxx ; weapons stats logging (DoD Module required!)

; Enable to use AMX Mod plugins
amxmod_compat.amxx ; AMX Mod backwards compatibility layer


; Custom - Add 3rd party plugins here
galileo.amxx
dod_fieldmedic.amxx
;dod_shellshock.amxx
dodx_tk_manager.amxx debug
simple_redirect.amxx
mespec.amxx
;players_name_fix.amxx
amx_parachute.amxx
;dod_tk_nodeath.amxx
amx_tk_subtract_kills.amxx
;dod_rocketclass.amxx
dod_steamidmsg.amxx
dod_respawnctrl.amxx
tekbotsonly.amxx
;dod_walk.amxx
;dod_deathnades_H.amxx
;ps_spatialstats(OLD-v1.1.2).amxx
ps_heatmaps.amxx
gameme_dod.amxx
;dod_nonades.amxx
dod_eviladmin.amxx
high_ping_kicker.amxx


/dod/addons/amxmodx/configs/sql.cfg
// SQL configuration file
// File location: $moddir/addons/amxmodx/configs/sql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

// *NOTE* amx_sql_type specifies the DEFAULT database type which admin.sma will use.

amx_sql_host "108.167.161.99:27015"

amx_sql_user "thescary_tek"
//amx_sql_user "tek"

amx_sql_pass "the_password"

amx_sql_db "thescary_amxbans"
//amx_sql_db "amxbans"

// or should it be amx_sql_table: "admins" OR "amx" OR "bans"
amx_sql_table "admins"
amx_sql_type "mysql"




======= LOGS ===========================
/dod/addons/amxmodx/logs/L20200311.log
L 03/11/2020 - 09:22:06: [amxbans_main.amxx] [AMXBans] Connection failed!
L 03/11/2020 - 09:22:06: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 17
L 03/11/2020 - 09:22:06: [amxbans_main.amxx] [AMXBans] Message: Can't connect to MySQL server on '108.167.161.99' (10061) (2003)



/dod/addons/amxmodx/logs/error_20200311.log:
L 03/11/2020 - 09:05:12: Start of error session.
L 03/11/2020 - 09:05:12: Info (map "dod_flash_us") (file "addons/amxmodx/logs/error_20200311.log")
L 03/11/2020 - 09:05:12: [MySQL] Invalid handle: 0
L 03/11/2020 - 09:05:12: [AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
L 03/11/2020 - 09:05:12: [AMXX] Run time error 10: native error (native "SQL_FreeHandle")
L 03/11/2020 - 09:05:12: [AMXX] [0] amxbans_main.sma::sql_init (line 183)


/dod/logs/L0311055.log
L 03/11/2020 - 09:05:09: Log file started (file "logs\L0311055.log") (game "dod") (version "48/1.1.2.6/8308")
L 03/11/2020 - 09:05:09: Loading map "dod_flash_us"
L 03/11/2020 - 09:05:09: Server cvars start
L 03/11/2020 - 09:05:09: Server cvar "amx_client_languages" = "1"
L 03/11/2020 - 09:05:09: Server cvar "amx_language" = "en"
L 03/11/2020 - 09:05:09: Server cvar "amx_nextmap" = "dod_flash_us"
L 03/11/2020 - 09:05:09: Server cvar "amx_timeleft" = "15:31"
L 03/11/2020 - 09:05:09: Server cvar "amx_tk_subtract_kills_stats" = "v1.3 - by diamond-optic (http://www.AvaMods.com)"
L 03/11/2020 - 09:05:09: Server cvar "amxbans_version" = "6.13"
L 03/11/2020 - 09:05:09: Server cvar "amxmodx_version" = "1.8.3-dev"
L 03/11/2020 - 09:05:09: Server cvar "coop" = "0"
L 03/11/2020 - 09:05:09: Server cvar "deathmatch" = "1"
L 03/11/2020 - 09:05:09: Server cvar "DOD_FieldMedic" = "v2.0 by Vet(3TT3V)"
L 03/11/2020 - 09:05:09: Server cvar "DOD_RespawnCtrl" = "v1.6 by Vet(3TT3V)"
L 03/11/2020 - 09:05:09: Server cvar "edgefriction" = "2"
L 03/11/2020 - 09:05:09: Server cvar "gal_version" = "1.1.290"
L 03/11/2020 - 09:05:09: Server cvar "gameme_plugin_version" = "2.0 (HL1)"
L 03/11/2020 - 09:05:09: Server cvar "gameme_webpage" = "http://www.gameme.com"
L 03/11/2020 - 09:05:09: Server cvar "max_queries_sec" = "3"
L 03/11/2020 - 09:05:09: Server cvar "max_queries_sec_global" = "100"
L 03/11/2020 - 09:05:09: Server cvar "max_queries_window" = "60"
L 03/11/2020 - 09:05:09: Server cvar "MESPEC" = "Version 3.0 BY Blobby & Feuersturm"
L 03/11/2020 - 09:05:09: Server cvar "metamod_version" = "1.21p37"
L 03/11/2020 - 09:05:09: Server cvar "mp_balancealliedheavy" = "20"
L 03/11/2020 - 09:05:09: Server cvar "mp_balancealliedmedium" = "25"
L 03/11/2020 - 09:05:09: Server cvar "mp_balancealliedmg" = "15"
L 03/11/2020 - 09:05:09: Server cvar "mp_balancealliedrifle" = "30"
L 03/11/2020 - 09:05:09: Server cvar "mp_balancealliedsniper" = "10"
L 03/11/2020 - 09:05:09: Server cvar "mp_balanceaxisheavy" = "20"
L 03/11/2020 - 09:05:09: Server cvar "mp_balanceaxismedium" = "25"
L 03/11/2020 - 09:05:09: Server cvar "mp_balanceaxismg" = "15"
L 03/11/2020 - 09:05:09: Server cvar "mp_balanceaxisrifle" = "30"
L 03/11/2020 - 09:05:09: Server cvar "mp_balanceaxissniper" = "10"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_match" = "0"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_match_warmup" = "0"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_ready_signal" = "ready"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_readyrestart" = "0"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_respawntime" = "0"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_restartround" = "0"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_scoring" = "0"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_scoring_bonus_allies" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_scoring_bonus_axis" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_scoring_delay" = "60"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_scoring_values_allies" = "111111"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_scoring_values_axis" = "111111"
L 03/11/2020 - 09:05:09: Server cvar "mp_clan_timer" = "20"
L 03/11/2020 - 09:05:09: Server cvar "mp_consistency" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_fadetoblack" = "0"
L 03/11/2020 - 09:05:09: Server cvar "mp_falldamage" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_flashlight" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_footsteps" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_forcecamera" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_forcechasecam" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_friendlyfire" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitallies30cal" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitalliesbar" = "6"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitalliesbazooka" = "2"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitalliescarbine" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitalliesgarand" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitalliesgreasegun" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitalliesmortar" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitalliesspring" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitalliesthompson" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxisfg42" = "2"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxisfg42s" = "2"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxisk43" = "2"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxiskar" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxismg34" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxismg42" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxismortar" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxismp40" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxismp44" = "6"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxispschreck" = "2"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitaxisscopedkar" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitbritassault" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitbritlight" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitbritmg" = "2"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitbritmortar" = "-1"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitbritpiat" = "2"
L 03/11/2020 - 09:05:09: Server cvar "mp_limitbritsniper" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_logfile" = "1"
L 03/11/2020 - 09:05:09: Server cvar "mp_timelimit" = "25.000000"
L 03/11/2020 - 09:05:09: Server cvar "pausable" = "0"
L 03/11/2020 - 09:05:09: Server cvar "sturmbot" = ""
L 03/11/2020 - 09:05:09: Server cvar "sturmbot_version" = "1.8"
L 03/11/2020 - 09:05:09: Server cvar "sv_accelerate" = "10"
L 03/11/2020 - 09:05:09: Server cvar "sv_aim" = "0"
L 03/11/2020 - 09:05:09: Server cvar "sv_airaccelerate" = "10"
L 03/11/2020 - 09:05:09: Server cvar "sv_allowupload" = "1"
L 03/11/2020 - 09:05:09: Server cvar "sv_alltalk" = "1"
L 03/11/2020 - 09:05:09: Server cvar "sv_bounce" = "1"
L 03/11/2020 - 09:05:09: Server cvar "sv_cheats" = "0"
L 03/11/2020 - 09:05:09: Server cvar "sv_clienttrace" = "3.5"
L 03/11/2020 - 09:05:09: Server cvar "sv_contact" = ""
L 03/11/2020 - 09:05:09: Server cvar "sv_friction" = "4"
L 03/11/2020 - 09:05:09: Server cvar "sv_gravity" = "800"
L 03/11/2020 - 09:05:09: Server cvar "sv_logblocks" = "0"
L 03/11/2020 - 09:05:09: Server cvar "sv_maxrate" = "0"
L 03/11/2020 - 09:05:09: Server cvar "sv_maxspeed" = "500"
L 03/11/2020 - 09:05:09: Server cvar "sv_minrate" = "100000"
L 03/11/2020 - 09:05:09: Server cvar "sv_password" = ""
L 03/11/2020 - 09:05:09: Server cvar "sv_proxies" = "1"
L 03/11/2020 - 09:05:09: Server cvar "sv_stepsize" = "18"
L 03/11/2020 - 09:05:09: Server cvar "sv_stopspeed" = "100"
L 03/11/2020 - 09:05:09: Server cvar "sv_uploadmax" = "0.5"
L 03/11/2020 - 09:05:09: Server cvar "sv_voiceenable" = "1"
L 03/11/2020 - 09:05:09: Server cvar "sv_wateraccelerate" = "10"
L 03/11/2020 - 09:05:09: Server cvar "sv_waterfriction" = "1"
L 03/11/2020 - 09:05:09: Server cvars end
L 03/11/2020 - 09:05:10: Server cvar "amx_nextmap" = "ae_black2"
L 03/11/2020 - 09:05:10: [AMXX] DOD FieldMedic - Plugin Initialized
L 03/11/2020 - 09:05:10: [AMXX] DOD RespawnCtrl - Respawn factors set. Allies = 0.1; Axis = 0.1
L 03/11/2020 - 09:05:10: Started map "dod_flash_us" (CRC "-1850901306")
L 03/11/2020 - 09:05:10: Server cvar "mp_timelimit" = "25"
L 03/11/2020 - 09:05:10: Server say "Server powered by TEK Gaming Community" "
L 03/11/2020 - 09:05:10: Log file closed


======= SQL SYNTAX ERROR =========================
While testing amxbans web admin, tyring to ban a player, I get this error:

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 'ing',UNIX_TIMESTAMP(),'60','website')' at line 4


Information entered:
Nickname: wreck
SteamID: STEAM_0:0:2982012
IP address:
Ban type: SteamID
Reason: TK'ing
Ban length: 60

User avatar
indianiso1
Posts: 163
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby indianiso1 » 13 Mar 2020, 10:37

Some mistakes in these:

thescaryguy wrote:/dod/addons/amxmodx/configs/amxbans.cfg
amx_sql_prefix "thescary_"
amxbans_server_address "108.167.161.99:27015"

1. Make sure you have the same prefix as it was provided when installing AMXBans.
2. Firstly try to leave empty server address, if you have some problems of not diagnosing itself then You should provide it.


thescaryguy wrote:/dod/addons/amxmodx/configs/plugins.ini
amxbans_core.amxx
amxbans_main.amxx debug
;admin.amxx ; admin base (required for any admin-related)
;admin_sql.amxx ; admin base - SQL version (comment admin.amxx)

3. It should look like that in the beginning.


thescaryguy wrote:/dod/addons/amxmodx/configs/sql.cfg
amx_sql_host "108.167.161.99:27015"
amx_sql_db "thescary_amxbans"
//amx_sql_db "amxbans"

4. Host is just plain IP address with NO port (27015) and this host should point to your sql server - if it is at the same host, use 127.0.0.1;
5. Leave db to amxbans with NO prefix (thescary_) since you define prefix already in amxbans.cfg


======= LOGS ===========================
thescaryguy wrote:/dod/addons/amxmodx/logs/L20200311.log
L 03/11/2020 - 09:22:06: [amxbans_main.amxx] [AMXBans] Connection failed!
L 03/11/2020 - 09:22:06: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 17
L 03/11/2020 - 09:22:06: [amxbans_main.amxx] [AMXBans] Message: Can't connect to MySQL server on '108.167.161.99' (10061) (2003)

/dod/addons/amxmodx/logs/error_20200311.log:
L 03/11/2020 - 09:05:12: Start of error session.
L 03/11/2020 - 09:05:12: Info (map "dod_flash_us") (file "addons/amxmodx/logs/error_20200311.log")
L 03/11/2020 - 09:05:12: [MySQL] Invalid handle: 0
L 03/11/2020 - 09:05:12: [AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
L 03/11/2020 - 09:05:12: [AMXX] Run time error 10: native error (native "SQL_FreeHandle")
L 03/11/2020 - 09:05:12: [AMXX] [0] amxbans_main.sma::sql_init (line 183)

6. All the errors are pointing of 4th of my point.


thescaryguy wrote:======= SQL SYNTAX ERROR =========================
While testing amxbans web admin, tyring to ban a player, I get this error:
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 'ing',UNIX_TIMESTAMP(),'60','website')' at line 4


Information entered:
Nickname: wreck
SteamID: STEAM_0:0:2982012
IP address:
Ban type: SteamID
Reason: TK'ing
Ban length: 60

This is because you try to use ' symbol in ban reason. This will be fixed in next release tho.

thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 14 Mar 2020, 00:29

Thanks! I'll give it a try :)

thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 15 Mar 2020, 23:33

Almost there... I think. So close. It feels like we are missing just one more piece of the puzzle to make it work... with a few minor problems that can wait until later. The amxbans web portion is connecting to the game server.

In the game, I am getting "You have no access to that command" when I use any commands now... NOBODY had admin - not even the bots.

Server Information
AMXBans Website Version 6.14.4
Webserver Apache
PHP Version 7.1.14
MySQL Version 5.6.41-84.1



While in Server settings, Reload admins, I get this:
[AMXBans] Loaded 0 admins from database


In HLSW, using amx_who in the console tab, I get this:
amx_who

Clients on server:
# nick authid userid imm res access
1 Gen. Mark Wahlb BOT 45 No No z
2 *={TEK}=* TheSc STEAM_0:0:499588638 2 No No z
3 Gen. Crappy Fra BOT 49 No No z
4 Gen. Gottlieb D BOT 50 No No z
5 Gen. Adolphus B BOT 51 No No z
6 Gen. Albert Ein BOT 52 No No z
7 Gen. Ferdinand BOT 53 No No z
8 Gen. Adolph Coo BOT 54 No No z
9 Miss pea pie STEAM_0:0:163777331 39 No No z
10 Gen. Joseph Goe BOT 55 No No z
12 Gen. Mercedes B BOT 57 No No z
13 Gen. Ferdinand BOT 58 No No z
14 Gen. Ludwig Bee BOT 59 No No z
16 Gen. Oscar Maye BOT 61 No No z
17 melvin-UK STEAM_0:1:11973431 47 No No z
18 Gen. Rudolf Die BOT 62 No No z
19 Gen. Levi Strau BOT 63 No No z
20 Mustang SalLYII STEAM_0:0:26391711 66 No No z
21 Gen. Wiener Sch BOT 65 No No z
22 Bullhead STEAM_0:0:20633454 44 No No z
23 Dead Meat STEAM_0:0:2223707 23 No No z
24 Tuge_ STEAM_0:1:513310301 24 No No z
25 -=|TEK|=- fIREs STEAM_0:0:1930487 79 No No z
26 war, huh, what STEAM_0:1:4339584 76 No No z
27 <TEK> DOGS GO M STEAM_0:0:11846252 70 No No z
28 {DFH} SupRFreQ STEAM_0:0:3591301 43 No No z
29 Sgt_B STEAM_0:1:2329567 78 No No z
30 -={TEK}=- Sad S STEAM_0:1:8748445 34 No No z
32 Phreak STEAM_0:1:3255175 74 No No z
Total 29

AMX Mod X admin administration
All the full admins have access flags set: (abcdefghijklmnopqustu)
All lower admins have normal access flags set: (acju)

amxx.cfg
// AMX Mod X Configuration File
echo Executing AMX Mod X Configuration File

// Default access for all non admin players (see users.ini for access details)
//
// Default value: "z"
amx_default_access "z"

// Name of setinfo which should store a password on a client (you should change this)
// Note: Always prefix the field with an underscore (aka: "_")
// (Example: setinfo _pw "password")
//
// Default value: "_pw"
amx_password_field "_pw"

// Mode of logging to a server
// 0 - disable logging, players won't be checked (and access won't be set)
// 1 - normal mode which obey flags set in accounts
// 2 - kick all players not on list
//
// Default value: 1
amx_mode 1

// Show admins activity
// 0 - disabled
// 1 - show without admin name
// 2 - show with name
//
// Default value: 2
amx_show_activity 2

// Frequency in seconds and text of scrolling message
//
Default value: "Welcome To The Elite Klan Axis Bot Server (Modified Maps)" 600
//amx_scrollmsg "All TEK Servers will be shut down for maintenance for 2 to 4 hrs. at 2:00 a.m. CDT 10/21/13"
amx_scrollmsg "Thanks For Playing At TEK Community Axis Bot Server (Modified Maps), Please Visit Our Forums At https://www.tekservers.net/forums" 900
// Center typed colored messages (last parameter is a color in RRRGGGBBB format)
//
Default values: "Welcome To The The Elite Klan Axis Bot Server (Modified Maps)" "000255100"
"The Elite Klan Is Recruiting Please Visit Our Forums At https://www.tekservers.net/forums" "000100255"
// Frequency in seconds of colored messages
//
// Default value: 180
amx_freq_imessage 180

// Ban times for the main ban menu (amx_banmenu)
// Use 0 for permanent ban.
// Default values: 0 5 10 15 30 45 60
amx_plmenu_bantimes 0 5 10 15 30 45 60

// Slap damage amounts for the main slap menu (amx_slapmenu)
// Slay is automatically inserted as the first option.
// Default values: 0 1 5
amx_plmenu_slapdmg 0 1 5

// Set in seconds how fast players can chat (chat-flood protection)
//
// Default value: 0.75
amx_flood_time 0.75

// Amount of slots to reserve.
//
// Default value: 0
amx_reservation 0

// If you set this to 1, you can hide slots on your server.
// If server "full" of public slots and slots hidden, you must manually connect with connect console command
//
// Default value: 0
amx_hideslots 0

// Displaying of time remaining
// a - display white text on bottom
// b - use voice
// c - don't add "remaining" (only in voice)
// d - don't add "hours/minutes/seconds" (only in voice)
// e - show/speak if current time is less than this set in parameter
//
// Default value: "ab 1200" "ab 600" "ab 300" "ab 180" "ab 60" "bcde 11"
amx_time_display "ab 1200" "ab 600" "ab 300" "ab 180" "ab 60" "bcde 11"

// Announce "say thetime" and "say timeleft" with voice, set to 0 to disable.
//
// Default value: 1
amx_time_voice 1

// Minimum delay in seconds between two voting sessions
//
// Default value: 10
amx_vote_delay 10

// How long voting session goes on
//
// Default value: 10
amx_vote_time 20

// Display who votes for what option, set to 0 to disable, 1 to enable.
//
// Default value: 1
amx_vote_answers 1

// Some ratios for voting success

// Default value: 0.40
amx_votekick_ratio 0.40

// Default value: 0.40
amx_voteban_ratio 0.40

// Default value: 0.40
amx_votemap_ratio 0.40

// Default value: 0.02
amx_vote_ratio 0.02

// Max. time to which map can be extended
//
// Default value: 90
amx_extendmap_max 15

// Step for each extending
//
// Default value: 15
amx_extendmap_step 15

// If you set this to 0, clients cannot chose their language, instead they use
// whatever language the server is configured to use.
//
// Default value: 1
amx_client_languages 1

// Plugin Debug mode
// 0 - No debugging (garbage line numbers)
// 1 - Plugins with "debug" option in plugins.ini are put into debug mode
// 2 - All plugins are put in debug mode
// Note - debug mode will affect JIT performance
//
// Default value: 1
amx_debug 1

// Plugin MultiLingual Debug
// To debug a language put its 2 letter code between quotes ("en", "de", etc)
// "" means disabled
//
// Default value: ""
amx_mldebug ""

amx_tk_limit 3
amx_tk_bantime 60
amx_tk_adminimmunity 1
amx_tk_forgivetype 2
amx_tk_usemapmemory 1
amx_tk_infomessages 1
amx_tk_usehostname 1

// Simple Redirect Cvars
//amx_rd_maxplayers 16 // - begin redirection when more the x ppl connected ( 0 = redirect all players )
//amx_rd_server 162.248.90.10 // - redirect to this server 127.0.0.1
//amx_rd_serverport 27015 // - redirect server port
//amx_rd_maxppl 16
//amx_rd_serverpw <password> // - password for the amx_rd_server (if needed)
amx_imessage "" "000255100"


amxbans.cfg
// AMXBans Configuration File
// File location: $moddir/addons/amxmodx/configs/amxbans.cfg
echo [AMXBans] is starting to execute amxbans.cfg

// Your SQL database prefix
// NOTE: The Prefix defined in your sql.cfg is NOT used for AMXBans anymore!!!
// SHOULD THIS BE "thescary_" OR "amx" ??? <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
amx_sql_prefix "amx"

// How AMXBans should handle the admins
// 0 = SQL, 1 = users.ini, 2 = load no admins
// SHOULD THIS BE SQL or USERS.INI
amxbans_use_admins_file 0

// AMXBans tries to get the address from the server automatically.
// You can set a different one here - ex. "<ip>:<port>"
amxbans_server_address "108.167.161.64"


// Number of players in the Disconnected Menu
amxbans_discon_players_saved 10

// Bantime to use for custom banreasons, if a user has static bantime <minutes>
// -1 to disable custom reasons
amxbans_custom_statictime 1440

// Set this cvar to what the adminname should be on the webpages, if the server make the ban.
// Ie. amxbans_servernick "My Great server"
// Leave emty if you want to use the default hostname from server.cfg
amxbans_servernick ""

// Set this to 1 / 2 / 3 to enable debug messages from amxbans to amxx logs.
// with debug 3 you get the most output, but a bug can flood your logs. 2 should be ok normally
amxbans_debug 3

// Don't use http:// in this cvar. The url will be shown to banned players in the console.
amxbans_complain_url "tekservers.net/forums/viewforum.php?f=9"

// Set this to 1 if you want the map name to show in the DB.
amxbans_add_mapname_in_servername 1

// If you want to see ban announcments in the HLSW chat, set this to 1
amxbans_show_in_hlsw 1

// Print green hudmessages on the top left when banning
amxbans_show_hud_messages 1

// What flag should admins have to get the high ban times.
amxbans_higher_ban_time_admin "n"

// What flag should admins have to NOT get their Nick printed when banning/Unbanning
amxbans_admin_mole_access "r"

// If an admin has the admin_mole_access, should his name be shown when he bans?
amxbans_show_name_evenif_mole 1

// Show if a player has been banned before as amx_chat to admins. 0 to disable
amxbans_show_prebanned 1

// How many previous offences does the player needs, to be notified in the amx_chat?
amxbans_show_prebanned_num 2

// Currently not known
amxbans_default_ban_reason "Too Many TKs"

// To be able to ban players not in the server. 1 enabled and 0 disabled.
amxbans_ban_evenif_disconnected 1

// Flagtimes, like the bantimes below
amx_setflagtimes "1 h" "4 h" "10 h" "1 d" "1 w" "4 w" "12 w"

// Ban times for admins with d-flag, set the highest time in minutes they can ban with "amx_ban"
// IMPORTANT: Put the lowest value first and the highest value last. You can have 1 to 14 values
// "0 m" = permanent ban!
// Values you can use:
// 1 - 59 with the flag m is for minutes
// 1 - 23 with the flag h is for hours
// 1 - 6 with the flag d is for days
// The w flag is for weeks

// Example:
// "5 m" is 5 minutes
// "1 h" is 1 hour
// "1 d" is 1 day
// "1 w" is 1 week

amx_setlowbantimes "5 m" "30 m" "1 h" "3 h" "10 h" "1 d"

// Ban times for admin with n-flag and d-flag
// IMPORTANT: Put the lowest value first and the highest value last. You can have 1 to 14 values
// "0 m" = permanent ban!
// Values you can use:
// 1 - 59 with the flag m is for minutes
// 1 - 23 with the flag h is for hours
// 1 - 6 with the flag d is for days
// The w flag is for weeks
//
// Example:
// "5 m" is 5 minutes
// "1 h" is 1 hour
// "1 d" is 1 day
// "1 w" is 1 week

amx_sethighbantimes "5 m" "30 m" "1 h" "3 h" "1 d" "1 w" "0 m"

/*********************************************************************************/

// 3rd party amxbans plugins
// needs the amxbans_freeze plugin
//
// "a" = freeze
// "b" = strip weapons
// "c" = block chat
// "d" = player glow red (not tested)
amxbans_freeze_mode "abc"

// Use the flagging only for this Server, or for all servers?
// needs the amxbans_flagged plugin
amxbans_flagged_all_server 1

/*********************************************************************************/

// AMXBans configuration file echo
echo [AMXBans] amxbans.cfg is fully executed


sql.cfg
// SQL configuration file
// File location: $moddir/addons/amxmodx/configs/sql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

// *NOTE* amx_sql_type specifies the DEFAULT database type which admin.sma will use.

amx_sql_host "108.167.161.99"
amx_sql_user "thescary_tek"
amx_sql_pass "NOT_THE_PASSWORD"
amx_sql_db "thescary_amxbans"

// or should it be amx_sql_table: "admins" OR "amx" OR "bans"
amx_sql_table "admins"
amx_sql_type "mysql"


modules.ini
;;;
; To enable a module, remove the semi-colon (;) in front of its name.
; If it's not here, simply add it its name, one per line.
; You don't need to write the _amxx part or the file extension.
;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time. Use ;;
;; amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

mysql
;sqlite

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; Put third party modules below here. ;;
;; You can just list their names, without the _amxx ;;
;; or file extension. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;



;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; These modules will be auto-detected and loaded ;;
;; as needed. You do not need to enable them here ;;
;; unless you have problems. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

fun
;engine
;fakemeta
;geoip
;sockets
;regex
;nvault
dodfun
dodx
hamsandwich


users.ini has permissions correct (set to use sql, not users.ini)

dod/addons/amxmodx/logs/error_2020315.log
L 03/15/2020 - 16:03:05: Start of error session.
L 03/15/2020 - 16:03:05: Info (map "cottoncandy_mtek") (file "addons/amxmodx/logs/error_20200315.log")
L 03/15/2020 - 16:03:05: Couldn't create temp file
L 03/15/2020 - 16:03:05: [AMXX] Displaying debug trace (plugin "dodx_tk_manager.amxx", version "1.0.0")
L 03/15/2020 - 16:03:05: [AMXX] Run time error 10: native error (native "write_file")
L 03/15/2020 - 16:03:05: [AMXX] [0] 1549.attach::client_disconnect (line 163)


dod/addons/amxmodx/logs/L20200315.log
L 03/15/2020 - 16:06:10: -------- Mapchange to dod_flash_us_mtek --------
L 03/15/2020 - 16:06:11: [amxbans_main.amxx] [AMXBans] The server IP:PORT is: 74.91.115.106:27015
L 03/15/2020 - 16:06:11: [amxbans_main.amxx] [AMXBANS DEBUG] UPDATE `amx_serverinfo` SET timestamp=1584306371,hostname='TEK Community Axis Bot Server (Modified Maps)',gametype='dod',amxban_version='6.13', amxban_menu=1 WHERE address = '74.91.115.106:27015'
L 03/15/2020 - 16:06:11: [amxbans_main.amxx] [AMXBans] AMXBans 6.13 is online
L 03/15/2020 - 16:06:11: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.


/dod/logs/L0315102.log
L 03/15/2020 - 16:06:10: Log file started (file "logs\L0315102.log") (game "dod") (version "48/1.1.2.6/8308")
L 03/15/2020 - 16:06:10: Loading map "dod_flash_us_mtek"
L 03/15/2020 - 16:06:10: Server cvars start
L 03/15/2020 - 16:06:10: Server cvar "amx_client_languages" = ""
L 03/15/2020 - 16:06:10: Server cvar "amxmodx_version" = ""
L 03/15/2020 - 16:06:10: Server cvar "coop" = "0"
L 03/15/2020 - 16:06:10: Server cvar "deathmatch" = "1"
L 03/15/2020 - 16:06:10: Server cvar "edgefriction" = "2"
L 03/15/2020 - 16:06:10: Server cvar "max_queries_sec" = "3.0"
L 03/15/2020 - 16:06:10: Server cvar "max_queries_sec_global" = "30"
L 03/15/2020 - 16:06:10: Server cvar "max_queries_window" = "60"
L 03/15/2020 - 16:06:10: Server cvar "metamod_version" = "1.21p37"
L 03/15/2020 - 16:06:10: Server cvar "mp_balancealliedheavy" = "20"
L 03/15/2020 - 16:06:10: Server cvar "mp_balancealliedmedium" = "25"
L 03/15/2020 - 16:06:10: Server cvar "mp_balancealliedmg" = "15"
L 03/15/2020 - 16:06:10: Server cvar "mp_balancealliedrifle" = "30"
L 03/15/2020 - 16:06:10: Server cvar "mp_balancealliedsniper" = "10"
L 03/15/2020 - 16:06:10: Server cvar "mp_balanceaxisheavy" = "20"
L 03/15/2020 - 16:06:10: Server cvar "mp_balanceaxismedium" = "25"
L 03/15/2020 - 16:06:10: Server cvar "mp_balanceaxismg" = "15"
L 03/15/2020 - 16:06:10: Server cvar "mp_balanceaxisrifle" = "30"
L 03/15/2020 - 16:06:10: Server cvar "mp_balanceaxissniper" = "10"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_match" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_match_warmup" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_ready_signal" = "ready"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_readyrestart" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_respawntime" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_restartround" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_scoring" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_scoring_bonus_allies" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_scoring_bonus_axis" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_scoring_delay" = "60"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_scoring_values_allies" = "111111"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_scoring_values_axis" = "111111"
L 03/15/2020 - 16:06:10: Server cvar "mp_clan_timer" = "20"
L 03/15/2020 - 16:06:10: Server cvar "mp_consistency" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_fadetoblack" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_falldamage" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_flashlight" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_footsteps" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_forcecamera" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_forcechasecam" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_friendlyfire" = "0"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitallies30cal" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesbar" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesbazooka" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliescarbine" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesgarand" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesgreasegun" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesmortar" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesspring" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesthompson" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxisfg42" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxisfg42s" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxisk43" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxiskar" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxismg34" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxismg42" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxismortar" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxismp40" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxismp44" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxispschreck" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxisscopedkar" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitbritassault" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitbritlight" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitbritmg" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitbritmortar" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitbritpiat" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitbritsniper" = "-1"
L 03/15/2020 - 16:06:10: Server cvar "mp_logfile" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_timelimit" = "0"
L 03/15/2020 - 16:06:10: Server cvar "pausable" = "1"
L 03/15/2020 - 16:06:10: Server cvar "sturmbot" = ""
L 03/15/2020 - 16:06:10: Server cvar "sturmbot_version" = "1.8"
L 03/15/2020 - 16:06:10: Server cvar "sv_accelerate" = "10"
L 03/15/2020 - 16:06:10: Server cvar "sv_aim" = "1"
L 03/15/2020 - 16:06:10: Server cvar "sv_airaccelerate" = "10"
L 03/15/2020 - 16:06:10: Server cvar "sv_allowupload" = "1"
L 03/15/2020 - 16:06:10: Server cvar "sv_bounce" = "1"
L 03/15/2020 - 16:06:10: Server cvar "sv_cheats" = "0"
L 03/15/2020 - 16:06:10: Server cvar "sv_clienttrace" = "1"
L 03/15/2020 - 16:06:10: Server cvar "sv_contact" = ""
L 03/15/2020 - 16:06:10: Server cvar "sv_friction" = "4"
L 03/15/2020 - 16:06:10: Server cvar "sv_gravity" = "800"
L 03/15/2020 - 16:06:10: Server cvar "sv_logblocks" = "0"
L 03/15/2020 - 16:06:10: Server cvar "sv_maxrate" = "0"
L 03/15/2020 - 16:06:10: Server cvar "sv_maxspeed" = "500"
L 03/15/2020 - 16:06:10: Server cvar "sv_minrate" = "0"
L 03/15/2020 - 16:06:10: Server cvar "sv_password" = ""
L 03/15/2020 - 16:06:10: Server cvar "sv_proxies" = "1"
L 03/15/2020 - 16:06:10: Server cvar "sv_stepsize" = "18"
L 03/15/2020 - 16:06:10: Server cvar "sv_stopspeed" = "100"
L 03/15/2020 - 16:06:10: Server cvar "sv_uploadmax" = "0.5"
L 03/15/2020 - 16:06:10: Server cvar "sv_voiceenable" = "1"
L 03/15/2020 - 16:06:10: Server cvar "sv_wateraccelerate" = "10"
L 03/15/2020 - 16:06:10: Server cvar "sv_waterfriction" = "1"
L 03/15/2020 - 16:06:10: Server cvars end
L 03/15/2020 - 16:06:10: [META] dll: Loaded plugin 'Engine': Engine v1.8.3-dev Sep 10 2013, AMX Mod X Dev Team
L 03/15/2020 - 16:06:10: [META] dll: Loaded plugin 'FakeMeta': FakeMeta v1.8.3-dev Sep 10 2013, AMX Mod X Dev Team
L 03/15/2020 - 16:06:10: Server cvar "amxmodx_version" = "1.8.3-dev"
L 03/15/2020 - 16:06:10: Server cvar "amx_language" = "en"
L 03/15/2020 - 16:06:10: Server cvar "amx_client_languages" = "1"
L 03/15/2020 - 16:06:10: Server cvar "amx_nextmap" = "2010_casino_v1"
L 03/15/2020 - 16:06:10: Server cvar "gal_version" = "1.1.290"
L 03/15/2020 - 16:06:10: Server cvar "DOD_FieldMedic" = "v2.0 by Vet(3TT3V)"
L 03/15/2020 - 16:06:10: [AMXX] DOD FieldMedic - Plugin Initialized
L 03/15/2020 - 16:06:10: Server cvar "MESPEC" = "Version 3.0 BY Blobby & Feuersturm"
L 03/15/2020 - 16:06:10: Server cvar "amx_tk_subtract_kills_stats" = "v1.3 - by diamond-optic (http://www.AvaMods.com)"
L 03/15/2020 - 16:06:10: Server cvar "DOD_RespawnCtrl" = "v1.6 by Vet(3TT3V)"
L 03/15/2020 - 16:06:10: [AMXX] DOD RespawnCtrl - Respawn factors set. Allies = 0.1; Axis = 0.1
L 03/15/2020 - 16:06:10: Server cvar "gameme_plugin_version" = "2.0 (HL1)"
L 03/15/2020 - 16:06:10: Server cvar "gameme_webpage" = "http://www.gameme.com"
L 03/15/2020 - 16:06:10: Started map "dod_flash_us_mtek" (CRC "-1850901306")
L 03/15/2020 - 16:06:10: Server cvar "mp_flashlight" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_friendlyfire" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_timelimit" = "25"
L 03/15/2020 - 16:06:10: Server cvar "sv_alltalk" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesspring" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesbar" = "6"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitallies30cal" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitalliesbazooka" = "2"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxisk43" = "2"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxismp44" = "6"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxisfg42" = "2"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxisfg42s" = "2"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxismg34" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxismg42" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitaxispschreck" = "2"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitbritsniper" = "1"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitbritmg" = "2"
L 03/15/2020 - 16:06:10: Server cvar "mp_limitbritpiat" = "2"
L 03/15/2020 - 16:06:10: Server cvar "pausable" = "0"
L 03/15/2020 - 16:06:10: Server cvar "sv_aim" = "0"
L 03/15/2020 - 16:06:10: Server cvar "sv_clienttrace" = "3.5"
L 03/15/2020 - 16:06:10: Server cvar "mp_falldamage" = "1"
L 03/15/2020 - 16:06:10: Server say "Server powered by TEK Gaming Community" "
L 03/15/2020 - 16:06:10: Server cvar "max_queries_sec_global" = "***PROTECTED***"
L 03/15/2020 - 16:06:10: Server cvar "max_queries_sec" = "***PROTECTED***"
L 03/15/2020 - 16:06:10: Server cvar "sv_minrate" = "100000"
L 03/15/2020 - 16:06:10: Log file closed


After changing amxbans.ini to use amxbans_use_admins_file 1 (use users.ini instead of sql),
when using amx_who in the game,
I get this:

Clients on server:
# nick authid userid imm res access
1 Gen. Gottlieb D BOT 44 Yes Yes a
2 *={TEK}=* TheSc STEAM_0:0:499588638 34 Yes Yes abcdefghijklmnopqrstu


And when using amxbans_use_admins_file 0 (use sql instead of users.ini) in the game,
using amx_who in the game console I get this:
Clients on server:
# nick authid userid imm res access
1 Gen. Gottlieb D BOT 44 No No z
2 *={TEK}=* TheSc STEAM_0:0:499588638 34 No No z

The 'z' access flag means no admin / regular user

Any suggestions?

All help is appreciated and I thank you in advance :)

User avatar
indianiso1
Posts: 163
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby indianiso1 » 16 Mar 2020, 00:57

Did you provide any admin in database in web?
Adding admins to server:
- Navigate to admin area, server, admins;
- Add admin;
- Navigate to Admin area, Server, assign admins;
- Open server you need, add admin

thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 16 Mar 2020, 03:31

indianiso1 wrote:Did you provide any admin in database in web?
Adding admins to server:
- Navigate to admin area, server, admins;
- Add admin;
- Navigate to Admin area, Server, assign admins;
- Open server you need, add admin


I have added admins to the Admin area/Server/Admins
and assigned admins to the Admin/Server/Assign Admin areas.

All the static ban time are NO
All the active were NO, and I changed them to YES

On a side note, another thing I noticed after switching back to users.ini, is that all the bots had all the access flags set (abcdefghijklmnopqustu) instead of just (a).

Also, medic is not working :(
The log shows that it is disabled (/dod/logs/L0315129.log)
L 03/15/2020 - 20:25:33: [AMXX] DOD FieldMedic - Plugin Disabled
and it is loaded according to (Admin area/Server/Server/[click on server]/Show list of amxx plugins [from dropdown menu])
[ 24] DOD_FieldMedic 2.0 Vet(3TT3V) dod_fieldmedic. running
FIELDMEDIC NOW FIXED - I had put "dod_fieldmedic #" in the console earlier, which disabled it. Putting "dod_fieldmedic 1" in console turned it on again :)

User avatar
indianiso1
Posts: 163
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby indianiso1 » 16 Mar 2020, 21:49

And what does server respond when you send "Reload admins" from Admin area/Server/Server/[click on server]?

thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 17 Mar 2020, 02:19

indianiso1 wrote:And what does server respond when you send "Reload admins" from Admin area/Server/Server/[click on server]?


Right now, I have it configured to use the "users.ini" file, instead of SQL. The results are below.

In Admin area/Server/Server/[Click on Server], it has this output:
[AMXBans] Loaded 77 admins from file
L 03/16/2020 - 19:13:01: [amxbans_core.amxx] Login: "Gen. Mark Wahlberg<916><BOT><>" became an admin (account "127.0.0.1") (access "abcdefghijklmnopqrstu") (address "127.0.0.1") (nick ";loopback") (static 0)
L 03/16/2020 - 19:13:01: [amxbans_core.amxx] Login: "Gen. Crappy Frappy<918><BOT><>" became an admin (account "127.0.0.1") (access "abcdefghijklmnopqrstu") (address "127.0.0.1") (nick ";loopback") (static 0)
L 03/16/2020 - 19:13:01: [amxbans_core.amxx] Login: "Gen. Gottlieb Daimler<919><BOT><>" became an admin (account "127.0.0.1") (access "abcdefghijklmnopqrstu") (address "127.0.0.1") (nick ";loopback") (static 0)
L 03/16/2020 - 19:13:01: [amxbans_core.amxx] Login: "Gen. Adolphus Busch<920><BOT><>" became an admin (account "127.0.0.1") (access "abcdefghijklmnopqrstu") (address "127.0.0.1") (nick ";loopback") (static 0)
L 03/16/2020 - 19:13:01: [amxbans_core.amxx] Login: "Gen. Albert Einstein<921><BOT><>" became an admin (account "127.0.0.1") (access "abcdefghijklmnopqrstu") (address "127.0.0.1") (nick ";loopback") (static 0)
L 03/16/2020 - 19:13:01: [amxbans_core.amxx] Login: "Gen. Ferdinand Porsche<922><BOT><>" became an admin (account "127.0.0.1") (access "abcdefghijklmnopqrstu") (address "127.0.0.1") (nick ";loopback") (static 0)

The bots should only have "a" access.



In HLSW console, "reload admins"
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
[MySQL] Thread worker was unable to start.
[AMXX] Displaying debug trace (plugin "amxbans_main.amxx", version "6.13")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] check_flag.inl::check_flagged (line 64)
[AMXX] [1] check_player.inl::check_player_ (line 128)
Skipping reconnect on <== B A L I W ==>, no pvPrivateData
Skipping reconnect on Brettarsle, no pvPrivateData
Skipping reconnect on -=TEK=-Suicidal-Blonde, no pvPrivateData
Skipping reconnect on .:| Juninh0 |:., no pvPrivateData
Server logging data to file logs\L0316112.log
-------- Mapchange to dod_flash_us_mtek --------
Message name too long: ScoreInfoLong
couldn't exec dod_flash_us_mtek.cfg
Executing AMX Mod X Configuration File
Scrolling message displaying frequency: 15:00 minutes
[AMXBans] is starting to execute amxbans.cfg
[AMXBans] amxbans.cfg is fully executed
Executing AMX Mod X Configuration File
Scrolling message displaying frequency: 15:00 minutes
Executing Galileo ( GAL ) Configuration File

User avatar
indianiso1
Posts: 163
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby indianiso1 » 17 Mar 2020, 10:20

You should change amxbans.cfg to get admins from sql and then watch console for errors.

thescaryguy
Posts: 18
Joined: 19 Feb 2020, 20:37

Re: AMXBANS not connecting game server to amxbans web & SQL Syntax Error

Postby thescaryguy » 17 Mar 2020, 18:22

indianiso1 wrote:You should change amxbans.cfg to get admins from sql and then watch console for errors.

Changed amxbans.cfg to use SQL, in Admin area/Server/Server/[Click on Server], here are the results:
[AMXBans] Loaded 0 admins from database


This is the output from HLSW when I use the command:
reload admins
Rcon: "rcon 1024702571 "NOT_THE_PASSWORD" reload admins" from "73.160.162.99:7130"
"Gen. Mark Wahlberg<1><BOT><Axis>" disconnected
"Gen. Crappy Frappy<2><BOT><Axis>" disconnected
"Gen. Gottlieb Daimler<3><BOT><Axis>" disconnected
"Gen. Adolphus Busch<4><BOT><Axis>" disconnected
"Gen. Albert Einstein<5><BOT><Axis>" disconnected
"Gen. Ferdinand Porsche<6><BOT><Axis>" disconnected
"Gen. Adolph Coors<7><BOT><Axis>" disconnected
"Gen. Joseph Goebbels<8><BOT><Axis>" disconnected
"Gen. Mercedes Benz<9><BOT><Axis>" disconnected
"Gen. Ferdinand Zeppelin<10><BOT><Axis>" disconnected
"Gen. Ludwig Beethoven<11><BOT><Axis>" disconnected
"Gen. Heidi Klum<12><BOT><Axis>" disconnected
"Gen. Oscar Mayer<13><BOT><Axis>" disconnected
"Gen. Rudolf Diesel<14><BOT><Axis>" disconnected
"Gen. Levi Strauss<15><BOT><Axis>" disconnected
"Gen. Wiener Schnitzel<16><BOT><Axis>" disconnected
Server cvar "mp_timelimit" = "25.000000"
[META] ini: Begin re-reading plugins list: c:/servers/tek/dod/addons/metamod/plugins.ini
[META] ini: Read plugin config for: AMX Mod X
[META] ini: Finished reading plugins list: c:/servers/tek/dod/addons/metamod/plugins.ini; Found 1 plugins
[META] dll: Updating plugins...
[META] dll: Finished updating 8 plugins; kept 1, loaded 0, unloaded 0, reloaded 0, delayed 0
Log file closed
Log file started (file "logs\L0317063.log") (game "dod") (version "48/1.1.2.6/8308")
Loading map "dod_flash_us_mtek"
Server cvars start
Server cvar "amx_client_languages" = "1"
Server cvar "amx_language" = "en"
Server cvar "amx_nextmap" = "[not yet voted on]"
Server cvar "amx_timeleft" = "20:31"
Server cvar "amx_tk_subtract_kills_stats" = "v1.3 - by diamond-optic (http://www.AvaMods.com)"
Server cvar "amxbans_version" = "6.13"
Server cvar "amxmodx_version" = "1.8.3-dev"
Server cvar "coop" = "0"
Server cvar "deathmatch" = "1"
Server cvar "DOD_FieldMedic" = "v2.0 by Vet(3TT3V)"
Server cvar "DOD_RespawnCtrl" = "v1.6 by Vet(3TT3V)"
Server cvar "edgefriction" = "2"
Server cvar "gal_version" = "1.1.290"
Server cvar "gameme_plugin_version" = "2.0 (HL1)"
Server cvar "gameme_webpage" = "http://www.gameme.com"
Server cvar "max_queries_sec" = "3"
Server cvar "max_queries_sec_global" = "100"
Server cvar "max_queries_window" = "60"
Server cvar "MESPEC" = "Version 3.0 BY Blobby & Feuersturm"
Server cvar "metamod_version" = "1.21p37"
Server cvar "mp_balancealliedheavy" = "20"
Server cvar "mp_balancealliedmedium" = "25"
Server cvar "mp_balancealliedmg" = "15"
Server cvar "mp_balancealliedrifle" = "30"
Server cvar "mp_balancealliedsniper" = "10"
Server cvar "mp_balanceaxisheavy" = "20"
Server cvar "mp_balanceaxismedium" = "25"
Server cvar "mp_balanceaxismg" = "15"
Server cvar "mp_balanceaxisrifle" = "30"
Server cvar "mp_balanceaxissniper" = "10"
Server cvar "mp_clan_match" = "0"
Server cvar "mp_clan_match_warmup" = "0"
Server cvar "mp_clan_ready_signal" = "ready"
Server cvar "mp_clan_readyrestart" = "0"
Server cvar "mp_clan_respawntime" = "0"
Server cvar "mp_clan_restartround" = "0"
Server cvar "mp_clan_scoring" = "0"
Server cvar "mp_clan_scoring_bonus_allies" = "-1"
Server cvar "mp_clan_scoring_bonus_axis" = "-1"
Server cvar "mp_clan_scoring_delay" = "60"
Server cvar "mp_clan_scoring_values_allies" = "111111"
Server cvar "mp_clan_scoring_values_axis" = "111111"
Server cvar "mp_clan_timer" = "20"
Server cvar "mp_consistency" = "1"
Server cvar "mp_fadetoblack" = "0"
Server cvar "mp_falldamage" = "1"
Server cvar "mp_flashlight" = "1"
Server cvar "mp_footsteps" = "1"
Server cvar "mp_forcecamera" = "1"
Server cvar "mp_forcechasecam" = "1"
Server cvar "mp_friendlyfire" = "1"
Server cvar "mp_limitallies30cal" = "1"
Server cvar "mp_limitalliesbar" = "6"
Server cvar "mp_limitalliesbazooka" = "2"
Server cvar "mp_limitalliescarbine" = "-1"
Server cvar "mp_limitalliesgarand" = "-1"
Server cvar "mp_limitalliesgreasegun" = "-1"
Server cvar "mp_limitalliesmortar" = "-1"
Server cvar "mp_limitalliesspring" = "1"
Server cvar "mp_limitalliesthompson" = "-1"
Server cvar "mp_limitaxisfg42" = "2"
Server cvar "mp_limitaxisfg42s" = "2"
Server cvar "mp_limitaxisk43" = "2"
Server cvar "mp_limitaxiskar" = "-1"
Server cvar "mp_limitaxismg34" = "1"
Server cvar "mp_limitaxismg42" = "1"
Server cvar "mp_limitaxismortar" = "-1"
Server cvar "mp_limitaxismp40" = "-1"
Server cvar "mp_limitaxismp44" = "6"
Server cvar "mp_limitaxispschreck" = "2"
Server cvar "mp_limitaxisscopedkar" = "-1"
Server cvar "mp_limitbritassault" = "-1"
Server cvar "mp_limitbritlight" = "-1"
Server cvar "mp_limitbritmg" = "2"
Server cvar "mp_limitbritmortar" = "-1"
Server cvar "mp_limitbritpiat" = "2"
Server cvar "mp_limitbritsniper" = "1"
Server cvar "mp_logfile" = "1"
Server cvar "mp_timelimit" = "25.000000"
Server cvar "pausable" = "0"
Server cvar "sturmbot" = ""
Server cvar "sturmbot_version" = "1.8"
Server cvar "sv_accelerate" = "10"
Server cvar "sv_aim" = "0"
Server cvar "sv_airaccelerate" = "10"
Server cvar "sv_allowupload" = "1"
Server cvar "sv_alltalk" = "1"
Server cvar "sv_bounce" = "1"
Server cvar "sv_cheats" = "0"
Server cvar "sv_clienttrace" = "3.5"
Server cvar "sv_contact" = ""
Server cvar "sv_friction" = "4"
Server cvar "sv_gravity" = "800"
Server cvar "sv_logblocks" = "0"
Server cvar "sv_maxrate" = "0"
Server cvar "sv_maxspeed" = "500"
Server cvar "sv_minrate" = "100000"
Server cvar "sv_password" = ""
Server cvar "sv_proxies" = "1"
Server cvar "sv_stepsize" = "18"
Server cvar "sv_stopspeed" = "100"
Server cvar "sv_uploadmax" = "0.5"
Server cvar "sv_voiceenable" = "1"
Server cvar "sv_wateraccelerate" = "10"
Server cvar "sv_waterfriction" = "1"
Server cvars end
Server cvar "amx_nextmap" = "2010_hothworld"
[AMXX] DOD FieldMedic - Plugin Initialized
[AMXX] DOD RespawnCtrl - Respawn factors set. Allies = 0.1; Axis = 0.1
logaddress_add 73.160.162.99 7130
Started map "dod_flash_us_mtek" (CRC "-1850901306")
Server logging data to file logs\L0317063.log
-------- Mapchange to dod_flash_us_mtek --------
Message name too long: ScoreInfoLong
couldn't exec dod_flash_us_mtek.cfg
Executing AMX Mod X Configuration File
Scrolling message displaying frequency: 15:00 minutes
[AMXBans] is starting to execute amxbans.cfg
[AMXBans] amxbans.cfg is fully executed
Executing AMX Mod X Configuration File
Scrolling message displaying frequency: 15:00 minutes
Executing Galileo ( GAL ) Configuration File
Server cvar "mp_timelimit" = "25"
Server say "Server powered by TEK Gaming Community" "
Log file closed
Log file started (file "logs\L0317064.log") (game "dod") (version "48/1.1.2.6/8308")
Rcon: "rcon 1024702571 "NOT_THE_PASSWORD" logaddress_add 73.160.162.99 7130" from "73.160.162.99:7130"
logaddress_add: 73.160.162.99:7130
"Gen. Mark Wahlberg<17><BOT><>" entered the game
"Gen. Mark Wahlberg<17><BOT><>" entered the game
"Gen. Mark Wahlberg<17><BOT><>" joined team "Axis"
"Gen. Mark Wahlberg<17><BOT><>" joined team "Axis"
"Gen. Crappy Frappy<18><BOT><>" entered the game
"Gen. Crappy Frappy<18><BOT><>" entered the game
"Gen. Crappy Frappy<18><BOT><>" joined team "Axis"
"Gen. Crappy Frappy<18><BOT><>" joined team "Axis"
"Gen. Gottlieb Daimler<19><BOT><>" entered the game
"Gen. Gottlieb Daimler<19><BOT><>" entered the game
Server cvar "amx_nextmap" = "[not yet voted on]"
Server cvar "amx_nextmap" = "[not yet voted on]"
"Gen. Adolphus Busch<20><BOT><>" entered the game
"Gen. Adolphus Busch<20><BOT><>" entered the game
"Gen. Albert Einstein<21><BOT><>" entered the game
"Gen. Albert Einstein<21><BOT><>" entered the game
"Gen. Mark Wahlberg<17><BOT><Axis>" changed role to "#class_axis_k43"
"Gen. Mark Wahlberg<17><BOT><Axis>" changed role to "#class_axis_k43"
"Gen. Ferdinand Porsche<22><BOT><>" entered the game
"Gen. Ferdinand Porsche<22><BOT><>" entered the game
"Gen. Crappy Frappy<18><BOT><Axis>" changed role to "#class_axis_kar98"
"Gen. Crappy Frappy<18><BOT><Axis>" changed role to "#class_axis_kar98"
"Gen. Adolph Coors<23><BOT><>" entered the game
"Gen. Adolph Coors<23><BOT><>" entered the game
"Gen. Joseph Goebbels<24><BOT><>" entered the game
"Gen. Joseph Goebbels<24><BOT><>" entered the game
"Gen. Mercedes Benz<25><BOT><>" entered the game
"Gen. Mercedes Benz<25><BOT><>" entered the game
"Gen. Ferdinand Zeppelin<26><BOT><>" entered the game
"Gen. Ferdinand Zeppelin<26><BOT><>" entered the game
"Gen. Ludwig Beethoven<27><BOT><>" entered the game
"Gen. Ludwig Beethoven<27><BOT><>" entered the game
"Gen. Heidi Klum<28><BOT><>" entered the game
"Gen. Heidi Klum<28><BOT><>" entered the game
"Gen. Oscar Mayer<29><BOT><>" entered the game
"Gen. Oscar Mayer<29><BOT><>" entered the game
"Gen. Rudolf Diesel<30><BOT><>" entered the game
"Gen. Rudolf Diesel<30><BOT><>" entered the game
"Gen. Levi Strauss<31><BOT><>" entered the game
"Gen. Levi Strauss<31><BOT><>" entered the game
"Gen. Wiener Schnitzel<32><BOT><>" entered the game
"Gen. Wiener Schnitzel<32><BOT><>" entered the game
"Gen. Crappy Frappy<18><BOT><Axis>" triggered a "dod_control_point" - "POINT_FLASH_FLASHVILLESTREET"
"Gen. Crappy Frappy<18><BOT><Axis>" triggered a "dod_control_point" - "POINT_FLASH_FLASHVILLESTREET"



From /dod/addons/amxmodx/logs/L20200316.log
L 03/17/2020 - 11:17:46: -------- Mapchange to dod_flash_us_mtek --------
L 03/17/2020 - 11:17:47: [amxbans_main.amxx] [AMXBans] The server IP:PORT is: 74.91.115.106:27015
L 03/17/2020 - 11:17:47: [amxbans_main.amxx] [AMXBANS DEBUG] UPDATE `amx_serverinfo` SET timestamp=1584461867,hostname='TEK Community Axis Bot Server (Modified Maps)',gametype='dod',amxban_version='6.13', amxban_menu=1 WHERE address = '74.91.115.106:27015'
L 03/17/2020 - 11:17:47: [amxbans_main.amxx] [AMXBans] AMXBans 6.13 is online
L 03/17/2020 - 11:17:47: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.
L 03/17/2020 - 11:23:45: -------- Mapchange to dod_flash_us --------
L 03/17/2020 - 11:23:46: [amxbans_main.amxx] [AMXBans] The server IP:PORT is: 74.91.115.106:27015
L 03/17/2020 - 11:23:47: [amxbans_main.amxx] [AMXBANS DEBUG] UPDATE `amx_serverinfo` SET timestamp=1584462227,hostname='TEK Community Axis Bot Server (Modified Maps)',gametype='dod',amxban_version='6.13', amxban_menu=1 WHERE address = '74.91.115.106:27015'
L 03/17/2020 - 11:23:47: [amxbans_main.amxx] [AMXBans] AMXBans 6.13 is online
L 03/17/2020 - 11:23:47: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.



From /dod/addons/amxmodx/logs/error_L20200316.log
L 03/17/2020 - 10:08:39: Start of error session.
L 03/17/2020 - 10:08:39: Info (map "dod_orange_bridge_mtek") (file "addons/amxmodx/logs/error_20200317.log")
L 03/17/2020 - 10:08:39: [AMXX] Run time error 4 (plugin "galileo.amxx") - debug not enabled!
L 03/17/2020 - 10:08:39: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).



From /dod/logs/L0317065.log:
L 03/17/2020 - 11:23:45: Log file started (file "logs\L0317065.log") (game "dod") (version "48/1.1.2.6/8308")
L 03/17/2020 - 11:23:45: Loading map "dod_flash_us"
L 03/17/2020 - 11:23:45: Server cvars start
L 03/17/2020 - 11:23:45: Server cvar "amx_client_languages" = "1"
L 03/17/2020 - 11:23:45: Server cvar "amx_language" = "en"
L 03/17/2020 - 11:23:45: Server cvar "amx_nextmap" = "dod_flash_us"
L 03/17/2020 - 11:23:45: Server cvar "amx_timeleft" = "18:59"
L 03/17/2020 - 11:23:45: Server cvar "amx_tk_subtract_kills_stats" = "v1.3 - by diamond-optic (www.AvaMods.com)"
L 03/17/2020 - 11:23:45: Server cvar "amxbans_version" = "6.13"
L 03/17/2020 - 11:23:45: Server cvar "amxmodx_version" = "1.8.3-dev"
L 03/17/2020 - 11:23:45: Server cvar "coop" = "0"
L 03/17/2020 - 11:23:45: Server cvar "deathmatch" = "1"
L 03/17/2020 - 11:23:45: Server cvar "DOD_FieldMedic" = "v2.0 by Vet(3TT3V)"
L 03/17/2020 - 11:23:45: Server cvar "DOD_RespawnCtrl" = "v1.6 by Vet(3TT3V)"
L 03/17/2020 - 11:23:45: Server cvar "edgefriction" = "2"
L 03/17/2020 - 11:23:45: Server cvar "gal_version" = "1.1.290"
L 03/17/2020 - 11:23:45: Server cvar "gameme_plugin_version" = "2.0 (HL1)"
L 03/17/2020 - 11:23:45: Server cvar "gameme_webpage" = "http://www.gameme.com"
L 03/17/2020 - 11:23:45: Server cvar "max_queries_sec" = "3"
L 03/17/2020 - 11:23:45: Server cvar "max_queries_sec_global" = "100"
L 03/17/2020 - 11:23:45: Server cvar "max_queries_window" = "60"
L 03/17/2020 - 11:23:45: Server cvar "MESPEC" = "Version 3.0 BY Blobby & Feuersturm"
L 03/17/2020 - 11:23:45: Server cvar "metamod_version" = "1.21p37"
L 03/17/2020 - 11:23:45: Server cvar "mp_balancealliedheavy" = "20"
L 03/17/2020 - 11:23:45: Server cvar "mp_balancealliedmedium" = "25"
L 03/17/2020 - 11:23:45: Server cvar "mp_balancealliedmg" = "15"
L 03/17/2020 - 11:23:45: Server cvar "mp_balancealliedrifle" = "30"
L 03/17/2020 - 11:23:45: Server cvar "mp_balancealliedsniper" = "10"
L 03/17/2020 - 11:23:45: Server cvar "mp_balanceaxisheavy" = "20"
L 03/17/2020 - 11:23:45: Server cvar "mp_balanceaxismedium" = "25"
L 03/17/2020 - 11:23:45: Server cvar "mp_balanceaxismg" = "15"
L 03/17/2020 - 11:23:45: Server cvar "mp_balanceaxisrifle" = "30"
L 03/17/2020 - 11:23:45: Server cvar "mp_balanceaxissniper" = "10"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_match" = "0"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_match_warmup" = "0"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_ready_signal" = "ready"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_readyrestart" = "0"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_respawntime" = "0"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_restartround" = "0"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_scoring" = "0"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_scoring_bonus_allies" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_scoring_bonus_axis" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_scoring_delay" = "60"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_scoring_values_allies" = "111111"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_scoring_values_axis" = "111111"
L 03/17/2020 - 11:23:45: Server cvar "mp_clan_timer" = "20"
L 03/17/2020 - 11:23:45: Server cvar "mp_consistency" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_fadetoblack" = "0"
L 03/17/2020 - 11:23:45: Server cvar "mp_falldamage" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_flashlight" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_footsteps" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_forcecamera" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_forcechasecam" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_friendlyfire" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitallies30cal" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitalliesbar" = "6"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitalliesbazooka" = "2"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitalliescarbine" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitalliesgarand" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitalliesgreasegun" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitalliesmortar" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitalliesspring" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitalliesthompson" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxisfg42" = "2"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxisfg42s" = "2"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxisk43" = "2"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxiskar" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxismg34" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxismg42" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxismortar" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxismp40" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxismp44" = "6"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxispschreck" = "2"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitaxisscopedkar" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitbritassault" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitbritlight" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitbritmg" = "2"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitbritmortar" = "-1"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitbritpiat" = "2"
L 03/17/2020 - 11:23:45: Server cvar "mp_limitbritsniper" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_logfile" = "1"
L 03/17/2020 - 11:23:45: Server cvar "mp_timelimit" = "25.000000"
L 03/17/2020 - 11:23:45: Server cvar "pausable" = "0"
L 03/17/2020 - 11:23:45: Server cvar "sturmbot" = ""
L 03/17/2020 - 11:23:45: Server cvar "sturmbot_version" = "1.8"
L 03/17/2020 - 11:23:45: Server cvar "sv_accelerate" = "10"
L 03/17/2020 - 11:23:45: Server cvar "sv_aim" = "0"
L 03/17/2020 - 11:23:45: Server cvar "sv_airaccelerate" = "10"
L 03/17/2020 - 11:23:45: Server cvar "sv_allowupload" = "1"
L 03/17/2020 - 11:23:45: Server cvar "sv_alltalk" = "1"
L 03/17/2020 - 11:23:45: Server cvar "sv_bounce" = "1"
L 03/17/2020 - 11:23:45: Server cvar "sv_cheats" = "0"
L 03/17/2020 - 11:23:45: Server cvar "sv_clienttrace" = "3.5"
L 03/17/2020 - 11:23:45: Server cvar "sv_contact" = ""
L 03/17/2020 - 11:23:45: Server cvar "sv_friction" = "4"
L 03/17/2020 - 11:23:45: Server cvar "sv_gravity" = "800"
L 03/17/2020 - 11:23:45: Server cvar "sv_logblocks" = "0"
L 03/17/2020 - 11:23:45: Server cvar "sv_maxrate" = "0"
L 03/17/2020 - 11:23:45: Server cvar "sv_maxspeed" = "500"
L 03/17/2020 - 11:23:45: Server cvar "sv_minrate" = "100000"
L 03/17/2020 - 11:23:45: Server cvar "sv_password" = ""
L 03/17/2020 - 11:23:45: Server cvar "sv_proxies" = "1"
L 03/17/2020 - 11:23:45: Server cvar "sv_stepsize" = "18"
L 03/17/2020 - 11:23:45: Server cvar "sv_stopspeed" = "100"
L 03/17/2020 - 11:23:45: Server cvar "sv_uploadmax" = "0.5"
L 03/17/2020 - 11:23:45: Server cvar "sv_voiceenable" = "1"
L 03/17/2020 - 11:23:45: Server cvar "sv_wateraccelerate" = "10"
L 03/17/2020 - 11:23:45: Server cvar "sv_waterfriction" = "1"
L 03/17/2020 - 11:23:45: Server cvars end
L 03/17/2020 - 11:23:46: Server cvar "amx_nextmap" = "aac_mclane_bot"
L 03/17/2020 - 11:23:46: [AMXX] DOD FieldMedic - Plugin Initialized
L 03/17/2020 - 11:23:46: [AMXX] DOD RespawnCtrl - Respawn factors set. Allies = 0.1; Axis = 0.1
L 03/17/2020 - 11:23:46: Started map "dod_flash_us" (CRC "-1850901306")
L 03/17/2020 - 11:23:46: Server cvar "mp_timelimit" = "25"
L 03/17/2020 - 11:23:46: Server say "Server powered by TEK Gaming Community" "
L 03/17/2020 - 11:23:46: Log file closed


From /dod/logs/L03170166.log:
L 03/17/2020 - 11:23:46: Log file started (file "logs\L0317066.log") (game "dod") (version "48/1.1.2.6/8308")
L 03/17/2020 - 11:23:46: Rcon: "rcon 1024702571 "NOT_THE_PASSWORD" logaddress_add 73.160.162.24 7130" from "73.160.162.24:7130"
L 03/17/2020 - 11:23:46: Rcon: "rcon 1024702571 "NOT_THE_PASSWORD" logaddress_add 73.160.162.24 7130" from "73.160.162.24:7130"
L 03/17/2020 - 11:23:50: "Gen. Mark Wahlberg<33><BOT><>" entered the game
L 03/17/2020 - 11:23:50: "Gen. Mark Wahlberg<33><BOT><>" joined team "Axis"
L 03/17/2020 - 11:23:52: "Gen. Crappy Frappy<34><BOT><>" entered the game
L 03/17/2020 - 11:23:52: "Gen. Crappy Frappy<34><BOT><>" joined team "Axis"
L 03/17/2020 - 11:23:54: "Gen. Gottlieb Daimler<35><BOT><>" entered the game
L 03/17/2020 - 11:23:55: Server cvar "amx_nextmap" = "[not yet voted on]"
...


Return to “Support and Help”

Who is online

Users browsing this forum: Bing [Bot] and 7 guests