Scripts Simples para MuEmu

[louis]

Zerar todos os vips:
Update memb_info set AccountLevel = 0


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


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


Zerar Master Skill Tree de todas as contas(deve ser executado com o servidor Offline)
Delete from MasterSkillTreeData


Excluir itens do báu(deve ser executado com o servidor Offline)
Delete from Warehouse
Delete from ExtWarehouse
Delete from WarehouseGuild (Se usa louis emulator update 11+)


Excluir todas as guilds(deve ser executado com o servidor Offline):
Delete from GuildMember
Delete from Guild


Resetar o Inventory(deve ser executado com o 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


Se precisarem de mais algo é só pedir.


Bjos
Louis

[ganka]

Can you give me script count how many item in our server ?

Example: Wings of Conqueror ( 15 accounts )

[louis]

Can you give me script count how many item in our server ?

Example: Wings of Conqueror ( 15 accounts )

This query search all itens in all accounts...but no count.



DECLARE
@acid varchar(10),
@name varchar(10),
@inv_data binary(3792),
@ware_data binary(3840),
@type binary(1),
@group binary(1),
@grupo int,
@item int,
@count int


-- Coloque o grupo e número do item que deseja procura
[Only registered and activated users can see links]
[Only registered and activated users can see links]


print '-------------------------';
print 'ENCONTRADO NO INVENTORIO:';
print '-------------------------';


DECLARE LISTA CURSOR LOCAL FOR
SELECT inventory, name, AccountID FROM Character
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
BEGIN


[Only registered and activated users can see links]


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END


[Only registered and activated users can see links]


END


[Only registered and activated users can see links]
END
CLOSE LISTA
DEALLOCATE LISTA


print '------------------';
print 'ENCONTRADO NO BAU:';
print '------------------';


DECLARE LISTA CURSOR LOCAL FOR
SELECT items, AccountID FROM warehouse
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
BEGIN


[Only registered and activated users can see links]


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END


[Only registered and activated users can see links]


END


[Only registered and activated users can see links]
END
CLOSE LISTA
DEALLOCATE LISTA

[ZoneX]

Louis, teria uma query de deletar um item de todas contas?
Por exemplo, quero deletar as Wing of Dragon das contas dos jogadores, de todas contas, você teria essa query?

[ganka]

This query search all itens in all accounts...but no count.



DECLARE
@acid varchar(10),
@name varchar(10),
@inv_data binary(3792),
@ware_data binary(3840),
@type binary(1),
@group binary(1),
@grupo int,
@item int,
@count int


-- Coloque o grupo e número do item que deseja procura
[Only registered and activated users can see links]
[Only registered and activated users can see links]


print '-------------------------';
print 'ENCONTRADO NO INVENTORIO:';
print '-------------------------';


DECLARE LISTA CURSOR LOCAL FOR
SELECT inventory, name, AccountID FROM Character
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
BEGIN


[Only registered and activated users can see links]


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END


[Only registered and activated users can see links]


END


[Only registered and activated users can see links]
END
CLOSE LISTA
DEALLOCATE LISTA


print '------------------';
print 'ENCONTRADO NO BAU:';
print '------------------';


DECLARE LISTA CURSOR LOCAL FOR
SELECT items, AccountID FROM warehouse
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
BEGIN


[Only registered and activated users can see links]


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]


[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END


[Only registered and activated users can see links]


END


[Only registered and activated users can see links]
END
CLOSE LISTA
DEALLOCATE LISTA


This code only give accounts id and name character . but it not count total they have in their inventory and warehouse . Can you recode it can count all total ? from inventory and warehouse ?

[AlanHenrique]

Louis pode me ajuda preciso sincronizar moedas do servidor com as da web ferrarezi

[caiojuan92]

Está query: Colocar X dias vip para todos:
Update memb_info set AccountLevel = TIPOVIP, AccountExpireDate = getdate()+DIAS

Me ajudou muito, porém se eu quiser determinar uma unica conta, como eu faria?

[Denis Alves]

Está query: Colocar X dias vip para todos:
Update memb_info set AccountLevel = TIPOVIP, AccountExpireDate = getdate()+DIAS

Me ajudou muito, porém se eu quiser determinar uma unica conta, como eu faria?


Update memb_info set AccountLevel = TIPOVIP, AccountExpireDate = getdate()+DIAS where memb___id='LOGIN'

[caiojuan92]

Update memb_info set AccountLevel = TIPOVIP, AccountExpireDate = getdate()+DIAS where memb___id='LOGIN'

Obrigado denizinhu!!

[MuDarkAge97D]

Teria alguma query que adicionaria um item em um personagem?
Queria para adicionar o item quando o personagem desse o Master Reset.