ban player from events

[luizinhomt]

Good evening everyone, does anyone know a way to ban players from server events only? if he is banned when he clicks on some event e.g. bg or events that require interaction with an NPC and he cannot enter the map and the message appears that he has been banned and needs to wait so many minutes to be able to participate. thank you all
 

[sfj209jfo-p]

create a column in account table named 'event_ban' or something.

create a @eventban command that will receive a character name and a number of days as parameter, find the account and update the event_ban column inserting that number of days

create a trigger in the database to decrease all event_ban by -1 at midnight, limit to 0 so it wont get a negative number.

create a check on your NPC events to see if user event_ban > 0, close the dialog.

[luizinhomt]

Hi, the database part can be done, but I'm not able to create an NPC to do the banning function and also the condition to put in the event NPCs to search the bank, could you be so kind and share an example of how I can do it?

Edited February 14 by luizinhomt
edit

[luizinhomt]

@sfj209jfo-p Can you give an example of how I can do it, thank you very much

Edited March 2 by luizinhomt
Edit

[sfj209jfo-p]

sorry i dont know how.

[Rynbef]

Here is an example. I haven't tested.

EventBan.txt

U can use a command to ban player from event in minutes. Different events can have different IDs. And u have a function u can call to check if player is banned or not.

 

Rynbef~

[luizinhomt]

@Rynbef Thank you very much, I will test

[luizinhomt]

@Rynbef please know how to solve this problem 

[Rynbef]

Im sorry. My mistake. I declared a atcommand but just call it and don't bind it and get arg just works for functions for atcommands we do need .@atcmd_parameters$[]

Pls try again.

EventBan.txt

 

Maybe use dispbottom instead of mes. But I forget changed yet.

 

Rynbef~

Edited March 4 by Rynbef

[Rynbef]

I've updated to make more comfortable.

I added an unban command and changed to dispbottom.

EventBan.txt

 

Rynbef~

[luizinhomt]

It's perfect, very good friend, my only problem now is that even though the character is banned, it appears that he is not banned

[Rynbef]

I'll check the SQL query later. Have to sleep now.

 

Rynbef~

[luizinhomt]

thank you very much have a good rest

[Rynbef]

Okay I ve cleaned up the code a bit and add additional checks and returns. Idk if rA able to use big integer in SQL. So changed everything to use Integer. When the time is over and the function CheckEventBan is called it will deleted directly now. To cleanup the database.

Pls delete the database and add the new with normal integer. If u ban a player check if they added to the database.

EventBan.txt

 

Rynbef~

Edited March 5 by Rynbef
Structure

[luizinhomt]

Hi @Rynbef , thank you very much for responding, I'm still having the same problem, even though the banned character doesn't appear to be banned, I looked, the database is saving correctly and this error is appearing in the console

Is it possible to place a dispbottom for the player who was banned warning that he was banned for a certain event time? Thank you very much in advance