[wAyz]

Originally Posted by wickedd PHP Code: ColorChat(id, RED, "Your message")  You will need colorchat.inc. ^1 = Normal color ^3 = Red color ^4 = Green color

Thought so. The line is here but I don't really know how to put it without compile errors. Can you help me?

	PrintActivity(admin_name, "^x04[AdvancedBans] $name^x01 :^x03  banned %s. Reason: %s. Ban Length: %s", target_name, arg, unban_time);

[WaSaAa1]

Amx_voteban command does not work, while confirming the vote, the player is not banned

[CMY]

If a player is dropped due slot reservation, the reason is currently just "Client sent drop" like it is when he actually just disconnects. Would it be possible to make the plugin print the actual reason which is "Dropped due slot reservation" so that admins wouldn't have to check what was the real reason if the server is full ?

Because on some deathrun servers for example you get punished with a ban for leaving as a Terrorist. So lets say the server is full already, and then a player with a slot joins, then the kick happens to fall onto the current Terrorist, making him leave the game. Then admins might ban him for this reason without knowing he was dropped due slot reservation because the reason was simply "Client sent drop". This issue might cause some false bans ?

Did I make any sense ?

[Veggetta]

Element, man i read the whole thread to page 97...

I put the plugin working fine, cause your version have some erros, but wheres one a can't figure it out..

The plugin create the table perfectly, but when it comes to ban someone, it don't update, delete, nothing.. It's dead.. Do you have the solution for this ?

EDIT: Sorry my friend, i saw the problem and a stupid one, forgot to put the line "advanced_bans_sql.amxx" on the top >.< ..

[alexinno]

if there is anybody using this php script https://forums.alliedmods.net/showpo...&postcount=392 to display the bans on a webpage they should download it again (update) because it was vulnerable to sql injection , i've uploaded it again with the fixes and some general cleanup

[alexinno]

Originally Posted by Exolent[jNr] I may be posting an update which includes ban date for all bans (and also instructions to update old non-permanent bans with ban dates) some time soon.

still waiting

[sylar02]

hey guys, i am currently using advanced bans sql version for quite some time on 6 servers. i never had any lag issues, and has about 600 bans currently. today i wrote a small php script which imported all the bans from esea for cheating (about 5000 records) and inserted those records in my db. so i had about 5600 bans. after doing that, every few seconds, it would freeze up for a second or two and get back to normal. it kept doing for a while, i restarted my servers and everything. still wouldnt fix it. so i finally gave in and remove those records, and server went back to normal.

so can anybody tell me what would be causing it? i do understand that everytime a player connects, plugin sends a query and it has to look through 5000 records, but this should be in milliseconds and shouldnt affect the server.

btw
my servers are in nyc
and webserver is in la, usa.

also, its jsut a 3$ hosting, so not the best one, but they use internap for their bandwidth.

any tips/suggestions would be appreciated.

edit v.1 would it help if i create an index on victim_steamid?

[alexinno]

yes and index should help , since mysql server caches this values and it finds them faster ... i don't know if Exolent is reading this reply's maybe he can add another column to the table like banid, auto increment, primary key

i also have two index's defined one PRIMARY , unique (victim_steamid) , and the admin_steamid which is not unique because an admin can ban multiple players , currently i have 1900+ banned players in my db from two servers and no freezes have been reported.

hope this helps

[sylar02]

alright, i will try that tonight when servers are empty. but i still have my doubts. i was looking at advanced_bans_sql code and here is waht i found

PHP Code:

public LoadBans()
{
    if( g_total_bans )
    {
        #if MAX_BANS <= 0
        TrieClear(g_trie);
        ArrayClear(g_array);
        #endif
        
        g_total_bans = 0;
    }
    
    #if defined USING_SQL
    static query[128];
    formatex(query, sizeof(query) - 1,\
        "SELECT * FROM `%s`;",\
        TABLE_NAME
        );
    
    SQL_ThreadQuery(g_sql_tuple, "QueryLoadBans", query);


SOME MORE CODE....... 


PHP Code:

set_task(RELOAD_BANS_INTERVAL, "LoadBans"); 


RELOAD_BANS_INTERVAL is set to 60 seconds. i am not very good with mysql, but doesnt indexes only speed up "where clause" and if u look at the function, i think it creates an array which is saved in game of all the ban records which simple has a single select * statement.

[alexinno]

you don't need to modify anything in the plugin , just modify your victim_steamid column from the mysql table , it's very easy to do this from phpmyadmin or from mysql command line

ALTER TABLE advanced_bans ADD PRIMARY KEY (`victim_steamid`);