Nielaczy z mysql
Rakom111
07.08.2011
- Wersję AMXBansa: Gm 1.5.1
- Wersję AMXMODX 1.8.2
- Wersję serwera: dproto
- Logi
- plugins.ini
- sql.cfg
Użytkownik Rakom111 edytował ten post 10.08.2011 21:35
- Wersję AMXMODX 1.8.2
- Wersję serwera: dproto
- Logi
L 08/07/2011 - 09:52:40: [amxbans_core.amxx] [AMXBans] WARNING: admin.amxx plugin running! stopped. L 08/07/2011 - 09:52:40: [amxbans_main.amxx] [AMXBans] Connection failed! L 08/07/2011 - 09:52:40: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 1 L 08/07/2011 - 09:52:40: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'hnsev_hnsev'@'****' (using password: YES) (1045) L 08/07/2011 - 09:52:40: [amxbans_main.amxx] [AMXBans] Query statement: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '********' L 08/07/2011 - 09:52:40: [amxbans_main.amxx] [AMXBans] Connection failed! L 08/07/2011 - 09:52:40: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 5 L 08/07/2011 - 09:52:40: [amxbans_main.amxx] [AMXBans] Message: Access denied for user 'hnsev_hnsev'@'****' (using password: YES) (1045) L 08/07/2011 - 09:52:40: [amxbans_main.amxx] [AMXBans] Query statement: L 08/07/2011 - 09:52:40: [amxbans_main.amxx] [AMXBans] No Reasons found in Database. Static reasons were loaded instead.- 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 "amx" // How AMXBans should handle the admins // 0 = SQL, 1 = users.ini, 2 = load no admins 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 "" // 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 "HnS" // 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 0 // Don't use http:// in this cvar. The url will be shown to banned players in the console. amxbans_complain_url "www.HnS4Ev.xaa.pl" // 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 unknown // 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" "0" // 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
- plugins.ini
amxbans_core.amxx amxbans_main.amxx ;admin.amxx ; admin base (required for any admin-related) ;admin_sql.amxx ; admin base - SQL version (comment admin.amxx)- modules.ini
;;; ; To enable a module, remove the semi-colon (<img src='http://img.amxx.pl/public/style_emoticons/<#EMO_DIR#>/wink.gif' class='bbc_emoticon' alt=';)' /> 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
- sql.cfg
amx_sql_host "hns4ev.xaa.pl" amx_sql_user "hnsev_hnsev" amx_sql_pass "******" amx_sql_db "hnsev_klen" amx_sql_table "admins" amx_sql_type "mysql"+ Dodane ip do Menadżera zdalnego połączenia MySQL
Użytkownik Rakom111 edytował ten post 10.08.2011 21:35
Hiroshima
07.08.2011
+ Dodane ip do Menadżera zdalnego połączenia MySQL
masz tam wpisac znak % i sprawdz czy user posiada wszystkie uprawnienia do bazy
Rakom111
07.08.2011
nie działa
ma wszystkie uprawnienia bo na stronie tez instalowałem tak
ma wszystkie uprawnienia bo na stronie tez instalowałem tak
Rakom111
10.08.2011
Pisałem do kolesia u ktorego mam serwer i mowi ze zle haslo jest albo nie mam uprawnien...
Sprawdzilem wszystlko 2 razy i jest w porzadku i dostarczam nowe logi (nie wiem czy sa nowe moze tylko po polku)
+ zmienilem na gm 1.5.1
Użytkownik Rakom111 edytował ten post 11.08.2011 08:33
Sprawdzilem wszystlko 2 razy i jest w porzadku i dostarczam nowe logi (nie wiem czy sa nowe moze tylko po polku)
L 08/09/2011 - 13:45:48: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie! L 08/09/2011 - 13:45:48: [amxbans_main.amxx] [AMXBans] Blad zapytania , Miejsce: 1 L 08/09/2011 - 13:45:48: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'hnsev_amxbans '@'*******' (using password: YES) (1045) L 08/09/2011 - 13:45:48: [amxbans_main.amxx] [AMXBans] Raport zapytania: SELECT `motd_delay` FROM `amx_serverinfo` WHERE address = '**********' L 08/09/2011 - 13:45:48: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie! L 08/09/2011 - 13:45:48: [amxbans_main.amxx] [AMXBans] Blad zapytania , Miejsce: 5 L 08/09/2011 - 13:45:48: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'hnsev_amxbans '@'********' (using password: YES) (1045) L 08/09/2011 - 13:45:48: [amxbans_main.amxx] [AMXBans] Raport zapytania: L 08/09/2011 - 13:45:48: [amxbans_main.amxx] [AMXBans] Nie znaleziono powodow banow w bazie danych. Zaladowano standardowe. L 08/09/2011 - 13:45:53: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie! L 08/09/2011 - 13:45:53: [amxbans_main.amxx] [AMXBans] Blad zapytania , Miejsce: 17 L 08/09/2011 - 13:45:53: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'hnsev_amxbans '@'********' (using password: YES) (1045) L 08/09/2011 - 13:45:53: [amxbans_main.amxx] [AMXBans] Raport zapytania: L 08/09/2011 - 13:45:57: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie! L 08/09/2011 - 13:45:57: [amxbans_main.amxx] [AMXBans] Blad zapytania , Miejsce: 17 L 08/09/2011 - 13:45:57: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'hnsev_amxbans '@'**********' (using password: YES) (1045) L 08/09/2011 - 13:45:57: [amxbans_main.amxx] [AMXBans] Raport zapytania: L 08/09/2011 - 13:45:58: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie! L 08/09/2011 - 13:45:58: [amxbans_main.amxx] [AMXBans] Blad zapytania , Miejsce: 16 L 08/09/2011 - 13:45:58: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'hnsev_amxbans '@'********' (using password: YES) (1045) L 08/09/2011 - 13:45:58: [amxbans_main.amxx] [AMXBans] Raport zapytania: L 08/09/2011 - 13:46:07: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie! L 08/09/2011 - 13:46:07: [amxbans_main.amxx] [AMXBans] Blad zapytania , Miejsce: 17 L 08/09/2011 - 13:46:07: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'hnsev_amxbans '@'*******' (using password: YES) (1045) L 08/09/2011 - 13:46:07: [amxbans_main.amxx] [AMXBans] Raport zapytania: L 08/09/2011 - 13:46:09: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie! L 08/09/2011 - 13:46:09: [amxbans_main.amxx] [AMXBans] Blad zapytania , Miejsce: 16 L 08/09/2011 - 13:46:09: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'hnsev_amxbans '@'********' (using password: YES) (1045) L 08/09/2011 - 13:46:09: [amxbans_main.amxx] [AMXBans] Raport zapytania: L 08/09/2011 - 13:46:19: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie! L 08/09/2011 - 13:46:19: [amxbans_main.amxx] [AMXBans] Blad zapytania , Miejsce: 17 L 08/09/2011 - 13:46:19: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'hnsev_amxbans '@'91.210.128.55' (using password: YES) (1045) L 08/09/2011 - 13:46:19: [amxbans_main.amxx] [AMXBans] Raport zapytania: L 08/09/2011 - 13:46:22: [amxbans_main.amxx] [AMXBans] Polaczenie nie powiodlo sie! L 08/09/2011 - 13:46:22: [amxbans_main.amxx] [AMXBans] Blad zapytania , Miejsce: 16 L 08/09/2011 - 13:46:22: [amxbans_main.amxx] [AMXBans] Wiadomosc: Access denied for user 'hnsev_amxbans '@'********' (using password: YES) (1045) L 08/09/2011 - 13:46:22: [amxbans_main.amxx] [AMXBans] Raport zapytania:
+ zmienilem na gm 1.5.1
Użytkownik Rakom111 edytował ten post 11.08.2011 08:33
Kamil0
21.08.2011
ja Ci mogę pomóc ale na gg bo potrzebowałem bym paru danych - gg w profilu