Raised This Month: $ Target: $400
 0% 

Amxbans 6.x


Post New Thread Reply   
 
Thread Tools Display Modes
Kensai
Veteran Member
Join Date: Aug 2005
Location: San Diego, California
Old 07-12-2006 , 22:20   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #561

Quote:
Originally Posted by Dzyzus
What i must change that amx_ban command will also ban player by IP adress ?
amx_banip
Kensai is offline
Send a message via AIM to Kensai Send a message via MSN to Kensai
Dzyzus
Senior Member
Join Date: Mar 2004
Location: Lithuania
Old 07-13-2006 , 09:40   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #562

I know I need that amx_ban will be the same as amx_banip
__________________
Dzyzus is offline
neggard
Member
Join Date: Mar 2004
Location: Sweden
Old 07-13-2006 , 16:52   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #563

[amxbans.amxx] [AMXBANS] SQL error: can't connect: 'Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111)

What is 111?

L 07/13/2006 - 00:10:13: [MySQL] Invalid DBI handle 0
L 07/13/2006 - 00:10:13: [AMXX] Displaying debug trace (plugin "amxbans.amxx")
L 07/13/2006 - 00:10:13: [AMXX] Run time error 10: native error (native "dbi_query")
L 07/13/2006 - 00:10:13: [AMXX] [0] amxbans.sma::banmod_online (line 391)
L 07/13/2006 - 00:10:13: [AMXX] [1] amxbans.sma::init_function (line 285)

I dont know if the server success to conect and then dont find the table or if it dont connect at all. How could I test that?

I am using amxbans 4.4b10

Last edited by neggard; 07-13-2006 at 17:07.
neggard is offline
Send a message via MSN to neggard
neggard
Member
Join Date: Mar 2004
Location: Sweden
Old 07-14-2006 , 05:33   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #564

Solve the problem.
I had wrong bind-address in my.cnf
neggard is offline
Send a message via MSN to neggard
DrO
Junior Member
Join Date: Jan 2006
Old 07-16-2006 , 00:31   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #565

I get this error in my logs every once in awhile with the current beta.

Quote:
L 07/14/2006 - 00:05:09: Invalid player id -1
L 07/14/2006 - 00:05:09: [AMXX] Displaying debug trace (plugin "amxbans.amxx")
L 07/14/2006 - 00:05:09: [AMXX] Run time error 10: native error (native "client_print")
L 07/14/2006 - 00:05:09: [AMXX] [0] amxbans.sma::cmdBan (line 1215)
__________________
cs.mi6-clan.net:27015
DrO is offline
lantz69
AMX Mod X Beta Tester
Join Date: Mar 2004
Location: Sweden, Skåne
Old 07-16-2006 , 04:33   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #566

Quote:
Originally Posted by DrO
I get this error in my logs every once in awhile with the current beta.
Current beta ??
PLease be specific.
Somone could mean 4.4b9 and som could mean 4.4b10
And it seem you are using b9 as line 1215 is
Code:
client_print(player,print_console,"[AMXBANS] ===============================================")
And beta10 dont have client_print on that line

SO update your plugin to amxbans-4.4b10
You will find a download for it some post ago.

I urge everyone that uses b9 to upgrade to b10 as it fixes 4 stupid bugs.



Code:
 
4.4b10 NOT RELEASED - Fixed: Multiple bantimes on the same steamID
- Fixed: If a ban is done by the ATAC plugin, the adminNick will be [ATAC] (No need to edit the atac plugins code) - Fixed: Banning admin with immunity or a bot from console generated wrong output - Fixed: motd showing only 0 when a user is banned


__________________
Using: Amxmodx 1.8.1.xxxx, cstrike
http://www.vanilla.se/
lantz69 is offline
rhin0
New Member
Join Date: Apr 2006
Old 07-16-2006 , 06:32   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #567

I would like to post my observation when using amxbans on LAN server.

This select is not good on LAN server, because everybody have steamid equal to STEAM_ID_LAN, so it keeps saying PLAYER_BANNED_BEFORE all the time:
Code:
format(query_bancount,4096,"SELECT * FROM `%s` WHERE ((player_id='%s') and ((ban_type='S') or (ban_type='SI'))) or ((player_ip='%s') and (ban_type='SI'))",tbl_banhist,player_steamid,player_ip)
I think, IF clause would do the right job.

I also don't understand why in select few lines lower is not checked every line in amxx_bans table for IP and also for STEAM_ID:
Code:
format(query,4096,"SELECT bid,ban_created,ban_length,ban_reason,admin_nick,admin_id,player_nick,server_name,server_ip,ban_type FROM `%s` WHERE ((player_id='%s') and ((ban_type='S') or (ban_type='SI'))) or ((player_ip='%s') and (ban_type='SI'))",tbl_bans,player_steamid,player_ip)
New select can look like this:
Code:
format(query,4096,"SELECT bid,ban_created,ban_length,ban_reason,admin_nick,admin_id,player_nick,server_name,server_ip,ban_type FROM `%s` WHERE player_id='%s' or player_ip='%s'",tbl_bans,player_steamid,player_ip)
But the worst think I discovered is SQL update which updates all IP address based on users steamid. Once again, all players on LAN has variable player_steamid = "", so anytime this update do the job, I get all IP address in amxx_bans table overwritten:
Code:
Retval = dbi_query(sql,"UPDATE `%s` SET player_ip='%s' WHERE player_id='%s'", tbl_bans, player_ip, player_steamid)
I also fix this with IF clause.
Code:
if (equal(ban_type, "S"))
{
	Retval = dbi_query(sql,"UPDATE `%s` SET player_ip='%s' WHERE player_id='%s'", tbl_bans, player_ip, player_steamid)
}
else
{
	Retval = dbi_query(sql,"UPDATE `%s` SET player_id='%s' WHERE player_ip='%s'", tbl_bans, player_steamid, player_ip)
}
Any comments would be appreciated
__________________
shit happens
rhin0 is offline
Send a message via ICQ to rhin0
-=STN=- MaGe
Veteran Member
Join Date: Apr 2004
Location: Asault World
Old 07-16-2006 , 09:29   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #568

do i need to edit this to connect to my website?
register_cvar("amx_sql_host", "127.0.0.1")
register_cvar("amx_sql_user", "root")
register_cvar("amx_sql_pass", "")
register_cvar("amx_sql_db", "amx")
also im using steambans, do these plugins work together?
__________________



-=STN=- MaGe is offline
Send a message via Yahoo to -=STN=- MaGe
Mordekay
Squirrel of Fortune
Join Date: Apr 2006
Location: Germany
Old 07-16-2006 , 10:07   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #569

@-=STN=- MaGe
no, the only thing you have to edit is in the sql.cfg

The steambans plugin has a feature to check your amx-database for allready banned id's, but only if you have advanced or higher license there. Steambans-bans are not added to your amx-bans database.
So you can say it only works in one direction: amx-bans database-->steambansplugin
__________________

Mordekay is offline
-=STN=- MaGe
Veteran Member
Join Date: Apr 2004
Location: Asault World
Old 07-16-2006 , 10:14   Re: Amxbans 4.3 (YoMama/Lux) [Updated 051028]
Reply With Quote #570

so does my slq.cfg need to look like this?
Code:
amx_sql_host	"http://www.gateway-gaming.com/assault"
amx_sql_user	"gateway_assault"
amx_sql_pass	"*********"
amx_sql_db		"amx"
amx_sql_table	"admins"
amx_sql_type	"mysql"
__________________




Last edited by -=STN=- MaGe; 07-16-2006 at 10:18.
-=STN=- MaGe is offline
Send a message via Yahoo to -=STN=- MaGe
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:16.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode