SCRIPTS Scripts simples para MuEmu

[Louis]

Borrar VIPs:
Update memb_info set AccountLevel = 0

Colocar X dias VIP para todos:
Update memb_info set AccountLevel = TIPOVIP, AccountExpireDate = getdate()+DIAS

Borrar cash(WC,WP,GP) de todos (Season 6+)
Delete from CashShopData

Borrar Master Skill Tree de todas las cuentas (debe ser ejecutado con el servidor Offline)
Delete from MasterSkillTreeData

Borrar todos los Items del Baul (debe ser ejecutado con el servidor Offline)
Delete from Warehouse
Delete from ExtWarehouse
Delete from WarehouseGuild (Si usa louis emulator update 11+)

Borrar todas las guilds (debe ser ejecutado con el servidor Offline):
Delete from GuildMember
Delete from Guild

Resetar el Inventory (debe ser ejecutado con el servidor Offline):
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 0) where Character.Class = 0 or Character.Class = 1 or Character.Class = 2
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 16) where Character.Class = 16 or Character.Class = 17 or Character.Class = 18
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 32) where Character.Class = 32 or Character.Class = 33 or Character.Class = 34
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 48) where Character.Class = 48 or Character.Class = 49 or Character.Class = 50
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 64) where Character.Class = 64 or Character.Class = 65 or Character.Class = 66
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 80) where Character.Class = 80 or Character.Class = 81 or Character.Class = 82
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 96) where Character.Class = 96 or Character.Class = 97 or Character.Class = 98

Si necesitas algo más, sólo tienes que pedir.

besos
Louis

[=Hacker=]

Aporte para bloquear el Chat a un personaje OFFLINE:

UPDATE Character set
ChatLimitTime=minbloqueo where Name='nombrepj'

[baiduyys]

Give ZEN to every new account instead of new characters Inventory

[Nykiyo]

Se puede agregar una Script que de zen a los personajes recién creados ?

Gracias esta buenísimo el aporte !

[akoshio]

please add script add vip for newly created account

thank you

[Louis]

Se puede agregar una Script que de zen a los personajes recién creados ?

Gracias esta buenísimo el aporte !

Coloca o valor en la tabla DefaultClasstype

please add script add vip for newly created account

thank you

In the table memb_info set the default value to AccountLevel = 1 2 3

And

AccountExpireDate = (getdate()+days)

Example

(getdate()+10)

[akoshio]

Do i have to add procedure or trigger to make it automated?

[Louis]

Do i have to add procedure or trigger to make it automated?

follows this images
https://imgur.com/a/F5mlCUr

save at the end..

[near929]

Hola sabes algun scrip me descargue unos files louis 19 me parece
pero al crear un personaje me sale con un set de inicio no exe+7
Alguna query para eliminar el set de inicio que le da a los pjs ?
intente yo darle el set que yo quiero darle al inicio, y lo que pasa es que se combina los 2 sets, sigue apareciendo el de los files

[criptomu]

Un Scripto que no elimine cuentas pero que deje a todos con los stats iniciales de cada PJ y en Nivel 1 ?

[MuDarkAge97D]

@Louis o script Redefinir o inventário, qual seria sua funcionalidade?

[saul]

Borrar VIPs:
Update memb_info set AccountLevel = 0

Colocar X dias VIP para todos:
Update memb_info set AccountLevel = TIPOVIP, AccountExpireDate = getdate()+DIAS

Borrar cash(WC,WP,GP) de todos (Season 6+)
Delete from CashShopData

Borrar Master Skill Tree de todas las cuentas (debe ser ejecutado con el servidor Offline)
Delete from MasterSkillTreeData

Borrar todos los Items del Baul (debe ser ejecutado con el servidor Offline)
Delete from Warehouse
Delete from ExtWarehouse
Delete from WarehouseGuild (Si usa louis emulator update 11+)

Borrar todas las guilds (debe ser ejecutado con el servidor Offline):
Delete from GuildMember
Delete from Guild

Resetar el Inventory (debe ser ejecutado con el servidor Offline):
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 0) where Character.Class = 0 or Character.Class = 1 or Character.Class = 2
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 16) where Character.Class = 16 or Character.Class = 17 or Character.Class = 18
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 32) where Character.Class = 32 or Character.Class = 33 or Character.Class = 34
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 48) where Character.Class = 48 or Character.Class = 49 or Character.Class = 50
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 64) where Character.Class = 64 or Character.Class = 65 or Character.Class = 66
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 80) where Character.Class = 80 or Character.Class = 81 or Character.Class = 82
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 96) where Character.Class = 96 or Character.Class = 97 or Character.Class = 98

Si necesitas algo más, sólo tienes que pedir.

besos
Louis

y para borrar todo los personajes UP 34 -> 36?