[Aporte] Script para banear usuarios molestos

hola bueno aki les traigo un aporte para aquellos usuarios q se ponen a molestar en el server y no dejan de joder a uno

Con esto, le borraran todos los personajes que se hayan conectado desde esa IP y/o que esten conectados

Solo tienen que pasar este script en el analizador de servicios, teniendo seleccionada la DB MuOnline

UPDATE MEMB_STAT
SET MEMB_STAT.ConnectStat = 0
WHERE (MEMB_STAT.IP LIKE 'xxx.xxx.%')

DELETE Character
FROM Character JOIN VI_CURR_INFO ON Character.AccountID = VI_CURR_INFO.memb___id COLLATE latin1_general_ci_as
DELETE VI_CURR_INFO
FROM VI_CURR_INFO JOIN MEMB_INFO ON VI_CURR_INFO.memb___id = MEMB_INFO.memb___id COLLATE latin1_general_ci_as
DELETE MEMB_INFO
FROM MEMB_INFO JOIN AccountCharacter ON MEMB_INFO.memb___id = AccountCharacter.ID COLLATE latin1_general_ci_as
DELETE AccountCharacter
FROM AccountCharacter JOIN MEMB_STAT ON AccountCharacter.ID = MEMB_STAT.memb___id COLLATE latin1_general_ci_as
DELETE MEMB_STAT
WHERE (MEMB_STAT.IP LIKE 'xxx.xxx.%')

ojo: solo cambien la xxx.xxx por la ip que quieran

SUERTE