(Question)Ban command

04/30/2013 00:03 PlayPVP#1

Hello guys,

Does anyone know how ban(DC) command working?

/ban Playername

I want to know how such commands working.

Can someone please provide me any sql query to make dc for character?? or can tell me the procedures that Execute those commands?

Thanks a lot.

04/30/2013 00:22 Kape7#2

its all executed on the code, db procedures are not related, you send the command and the gameserver kicks the player, thats all.

04/30/2013 00:32 PlayPVP#3

Hey Synx7 Thanks for answering me but i did not get it.

There is no any method to edit such commands?

Where can try to find them?

Thanks for your help.

04/30/2013 00:42 Kape7#4

Quote:

Originally Posted by PlayPVP

Hey Synx7 Thanks for answering me but i did not get it.

There is no any method to edit such commands?

Where can try to find them?

Thanks for your help.

Well, yes and no.
You can't edit what the command does, that is hardcoded on the gameserver.
It doens't execute an specific stored procedure. You could try to parse the log that is generated when you ban someone with that command, but that's all. (make a trigger on the _SMCLog table)
This is what is executed when you use the /ban command:

Code:

insert _SMCLog values ('<GMAccount name>', 1, 'BanPlayer: <kicked char name>', default)

04/30/2013 02:04 Qynchou#5

Quote:
Originally Posted by Synx7
Well, yes and no.
You can't edit what the command does, that is hardcoded on the gameserver.
It doens't execute an specific stored procedure. You could try to parse the log that is generated when you ban someone with that command, but that's all. (make a trigger on the _SMCLog table)
This is what is executed when you use the /ban command:
Code:
insert _SMCLog values ('<GMAccount name>', 1, 'BanPlayer: <kicked char name>', default)

Possible to make custom commands that would execute custom procedures?

04/30/2013 02:15 Kape7#6

Quote:

Originally Posted by Qynchou

Possible to make custom commands that would execute custom procedures?

I made some, but there are many limits about it.

04/30/2013 02:34 Qynchou#7

Quote:

Originally Posted by Synx7

I made some, but there are many limits about it.

Nothing new, just something simple for convenience.

04/30/2013 10:50 IceAmStiel#8

Quote:

Originally Posted by Qynchou

Nothing new, just something simple for convenience.

Use the ingame mailing to execute procedures on command

04/30/2013 12:34 PlayPVP#9

Quote:
Originally Posted by Synx7
Well, yes and no.
You can't edit what the command does, that is hardcoded on the gameserver.
It doens't execute an specific stored procedure. You could try to parse the log that is generated when you ban someone with that command, but that's all. (make a trigger on the _SMCLog table)
This is what is executed when you use the /ban command:
Code:
insert _SMCLog values ('<GMAccount name>', 1, 'BanPlayer: <kicked char name>', default)

unfortunately after executing the query it doesn't do any effect in game, but logically it must work.