Witam, mam problem z wczytaniem adminów z sql.
Nie działa admin na serwerze jak jest amxbans_use_admins_file 0 jak ustawie na 1 z users.ini tak to działa.
Proszę o pomoc!
error_20140111.log
L 01/11/2014 - 11:01:52: Start of error session. L 01/11/2014 - 11:01:52: Info (map "de_dust") (file "addons/amxmodx/logs/error_20140111.log") L 01/11/2014 - 11:01:52: [MySQL] Invalid info tuple handle: 0 L 01/11/2014 - 11:01:52: [AMXX] Run time error 10 (plugin "amxbans_core.amxx") (native "SQL_Connect") - debug not enabled! L 01/11/2014 - 11:01:52: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).
L20140111.log
L 01/11/2014 - 10:21:46: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:30:24: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:30:25: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 10:30:26: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 10:31:39: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:31:40: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 10:31:40: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 10:35:17: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:35:18: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 10:35:18: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 10:36:12: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:36:13: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 10:36:13: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 10:39:37: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:39:38: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 10:39:38: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 10:43:17: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:43:18: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 10:43:18: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 10:46:52: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:46:52: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 10:46:53: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 10:47:26: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:47:27: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 10:47:27: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 10:58:10: -------- Mapchange to de_dust -------- L 01/11/2014 - 10:58:11: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 10:58:12: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:00:58: -------- Mapchange to de_dust -------- L 01/11/2014 - 11:00:59: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 11:00:59: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:01:51: -------- Mapchange to de_dust -------- L 01/11/2014 - 11:01:52: [amxbans_core.amxx] [AMXBans] WARNING: admin_sql.amxx plugin running! stopped. L 01/11/2014 - 11:01:52: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 11:01:52: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:21:35: -------- Mapchange to de_dust -------- L 01/11/2014 - 11:21:36: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 11:21:36: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:21:41: [amxbans_core.amxx] Login: "FirebladeR<1><STEAM_0:0:51275077><>" became an admin (account "FirebladeR") (access "abcdefghijklmnopqrstu") (address "212.106.4.146") (nick ";") (static 0) L 01/11/2014 - 11:22:21: -------- Mapchange to de_dust -------- L 01/11/2014 - 11:22:22: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 11:22:23: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:22:34: [amxbans_core.amxx] Login: "FirebladeR<1><STEAM_0:0:51275077><>" became an admin (account "FirebladeR") (access "bcdefghijklmnopqrstu") (address "212.106.4.146") (nick ";") (static 0) L 01/11/2014 - 11:22:50: [amxbans_main.amxx] FirebladeR<1><STEAM_0:0:51275077><TERRORIST> banned FirebladeR<STEAM_0:0:51275077> Duration: PERMANENT. Reason: Test. L 01/11/2014 - 11:24:08: -------- Mapchange to de_dust -------- L 01/11/2014 - 11:24:09: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 11:24:09: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:24:21: [amxbans_main.amxx] [AMXBans] [AMXBans]<FirebladeR> 212.106.4.146 has been banned 83 times before. L 01/11/2014 - 11:25:20: -------- Mapchange to de_dust -------- L 01/11/2014 - 11:25:21: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 11:25:22: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:25:32: [amxbans_main.amxx] [AMXBans] [AMXBans]<FirebladeR> 212.106.4.146 has been banned 83 times before. L 01/11/2014 - 11:26:17: -------- Mapchange to de_dust -------- L 01/11/2014 - 11:26:17: [amxbans_core.amxx] Failed to set affinity from sqlite to mysql. L 01/11/2014 - 11:26:18: [amxbans_main.amxx] [AMXBans] Query failed! L 01/11/2014 - 11:26:18: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5 L 01/11/2014 - 11:26:18: [amxbans_main.amxx] [AMXBans] Message: no such table: amx_reasons (1) L 01/11/2014 - 11:26:18: [amxbans_main.amxx] [AMXBans] Query statement: L 01/11/2014 - 11:26:18: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:26:18: [amxbans_main.amxx] [AMXBans] Query failed! L 01/11/2014 - 11:26:18: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1 L 01/11/2014 - 11:26:18: [amxbans_main.amxx] [AMXBans] Message: no such table: amx_serverinfo (1) L 01/11/2014 - 11:26:18: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '213.192.104.195:27071' L 01/11/2014 - 11:26:25: [amxbans_main.amxx] [AMXBans] Query failed! L 01/11/2014 - 11:26:25: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 17 L 01/11/2014 - 11:26:25: [amxbans_main.amxx] [AMXBans] Message: no such table: amx_bans (1) L 01/11/2014 - 11:26:25: [amxbans_main.amxx] [AMXBans] Query statement: L 01/11/2014 - 11:26:28: [amxbans_main.amxx] [AMXBans] Query failed! L 01/11/2014 - 11:26:28: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 16 L 01/11/2014 - 11:26:28: [amxbans_main.amxx] [AMXBans] Message: no such table: amx_bans (1) L 01/11/2014 - 11:26:28: [amxbans_main.amxx] [AMXBans] Query statement: L 01/11/2014 - 11:26:51: -------- Mapchange to de_dust -------- L 01/11/2014 - 11:26:52: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 11:26:52: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:27:01: [amxbans_main.amxx] [AMXBans] [AMXBans]<FirebladeR> 212.106.4.146 has been banned 83 times before. L 01/11/2014 - 11:27:45: -------- Mapchange to de_dust -------- L 01/11/2014 - 11:27:46: [amxbans_main.amxx] [AMXBans] AMXBans Gm 1.5.1 is online, date: 20:31 07.03.2011 L 01/11/2014 - 11:27:46: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead. L 01/11/2014 - 11:27:55: [amxbans_main.amxx] [AMXBans] [AMXBans]<FirebladeR> 212.106.4.146 has been banned 83 times before.
amxbans.cfg
// Plik Konfiguracyjny AMXBans echo [AMXBans] laduje plik amxbans.cfg // Prefix bazy // Nota: Prefiks wpisany w sql.cfg nie jest już używany przez AMXBans amx_sql_prefix "amx" //Używanie oznaczeń gracza na tym serwerze czy na wszystkich? amxbans_flagged_all_server 1 // Wczytywanie adminów // 0 z bazy SQL, 1 = z pliku users.ini, 2 = nie ładuje adminów amxbans_use_admins_file 0 // AMXBans próbuje pobierać Ip automatycznie (Tak, widać ;/) // Możesz ustawić inne iP -np. "<ip>:<port>" amxbans_server_address "213.192.104.195:27071" // Tak naprawdę ten cvar jest niezle pomylony niby chodzi o czas a ustawia własny powód bana // -1 aby wyłaczyć, 0 aby właczyć własny powód bana amxbans_custom_statictime 0 // Wpisz jaka ma byc wyświetlana nazwa serwera na stronie gdy gracz dostanie bana . // np. amxbans_servernick "Mój za***isty serwer" // Pozostaw puste aby czytało domyślna nazwe hosta z server.cfg amxbans_servernick "" // Ustaw 1 / 2 / 3 aby włączyć powiadomienia o debugach w logach. // nie ustawiaj na 3 bo Ci konsole zaspamuje, ustaw 2 bedzie normal amxbans_debug 0 // Nie wpisuj "http://". Plugin sam sobie to wpisze amxbans_complain_url "www.fireblader.unixstorm.org" // Ustaw na 1 aby mapa była pokazywana w nazwie serwera amxbans_add_mapname_in_servername 1 // Ustaw na 1 aby w czacie HLSW był pokazywany komunikat o banie amxbans_show_in_hlsw 1 // Pokazuje zielony napis w hud, w lewym górnym rogu, w przypadku bana amxbans_show_hud_messages 1 // Ustawia jaka flaga odpowiada za najwyższy czas bana jaki może ustawić admina. amxbans_higher_ban_time_admin "n" // Ustawia jaka flaga odpowiada za to aby nie był pokazywany nick admina który zbanował gracza amxbans_admin_mole_access "r" // Jeśli admin ma ustawiony admin_mole_access, ma pokazywać jego nick przy zbanowanym graczu? amxbans_show_name_evenif_mole 1 // Pokazuje adminowi w chacie czy gracz był wczesniej zbanowany, 0 aby wyłączyć amxbans_show_prebanned 1 // Ile razy powiadamia admina o wcześniejszym banie gracza amxbans_show_prebanned_num 2 // Obecnie nie wiadomo // Tak napisali w oryginale :D amxbans_default_ban_reason unknown // Czy można banować w przypadku gdy gracz się rozłaczy . 1 aby właczyć 0 aby wyłaczyc // Jest to na koncu menu admina, Menu Rozłączeń amxbans_ban_evenif_disconnected 1 // Czasy oznakowan w menu amx_setflagtimes "1 h" "4 h" "10 h" "1 d" "1 w" "4 w" "12 w" "0" // Długości banów dla adminów z flagą -d, ustaw najwieksze jakie mają byc przy komendzie "amxbans_consolebanmax" // UWAGA: ustawiaj wartosci od NAJMNIEJSZEJ do NAJWIĘKSZEJ . Mozesz wybrac 14 wartości // "0 m" = PERM // Wartosci jakich mozesz użyć : // 1 - 59 dla flagi m to minuty // 1 - 23 dla flagi h to godziny // 1 - 6 dla flagi d to dni // dla flagi w sa tygodnie // Przykłady: // "5 m" to 5 minut // "1 h" to 1 godzina // "1 d" to 1 dzień // "1 w" to 1 tydzień amx_setlowbantimes "5 m" "30 m" "1 h" "3 h" "10 h" "1 d" // Długości banów dla adminów z flagą -n i -d // UWAGA:ustawiaj wartosci od NAJMNIEJSZEJ do NAJWIĘKSZEJ . Mozesz wybrac 14 wartości // "0 m" = PERM // Wartosci jakich mozesz użyć : // 1 - 59 dla flagi m to minuty // 1 - 23 dla flagi h to godziny // 1 - 6 dla flagi d to dni // dla flagi w sa tygodnie // Przykłady: // "5 m" to 5 minut // "1 h" to 1 godzina // "1 d" to 1 dzień // "1 w" to 1 tydzień amx_sethighbantimes "5 m" "30 m" "1 h" "3 h" "1 d" "1 w" "0 m" /********************AMXBans: Freeze ****************************************/ // plugin amxbans_freeze (tzw. Zamrażający) // "a" = zamraża (nie możesz się ruszyć) // "b" = nie mozesz uzyc broni // "c" = blokuje czat // "d" = gracz swieci na czerwono amxbans_freeze_mode "abcd" // Czas pomiedzy serwerem gry a baza danych // Moze byc ujemny // Jezeli 0 ustawia automatycznie amxbans_time_offset "0" // [En] Automatycznie robi screena przy banie amxbans_snapshot "1" // Typ Bana // "0" - wybiera automatycznie // "1" - na IP // "2" - na SteamID amxbans_bantype "0" // Definiuje czy sprawdzać graczy po flagach // Włącza - "1" / Wyłącza - "0" amxbans_check_flag "1" // Włącza - 1 / wyłącza - 0 historie banow amxbans_history "1" // Plik konfiguracyjny - ECHO echo [AMXBans] amxbans.cfg zostal zaladowany | AMXX.PL | Wersja PL - Szyfrant i MisieQ
plugins.ini
; AMX Mod X plugins amxbans_core.amxx ; amxbans amxbans_main.amxx debug ; amxbans m_tfix.amxx noflood.amxx ; Admin Base - Always one has to be activated ;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 ; Counter-Strike ;restmenu.amxx ; restrict weapons menu statsx.amxx ; stats on death or round end (CSX Module required!) ;miscstats.amxx ; bunch of events announcement for Counter-Strike ;stats_logging.amxx ; weapons stats logging (CSX Module required!) ; Enable to use AMX Mod plugins ;amxmod_compat.amxx ; AMX Mod backwards compatibility layer ; TUTAJ dopisuj samodzielnie zainstalowane pluginy:
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 "www.fireblader.unixstorm.org" amx_sql_user "fireblader_bany" amx_sql_pass "****" amx_sql_db "fireblader_bany" 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 cstrike csx ;hamsandwich
Banowanie graczy działa z amxbans na serwer.
Za pomoc z góry dziękuje!
Użytkownik glut edytował ten post 11.01.2014 22:03
Ukrycie hasła użytkownika do bazy danych.