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
set @grupo    = 0;
set @item    = 1;


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


DECLARE LISTA CURSOR LOCAL FOR
SELECT inventory, name, AccountID FROM Character
OPEN LISTA
FETCH NEXT FROM LISTA INTO @inv_data, @name, @acid
WHILE @@FETCH_STATUS = 0
BEGIN


SET @count=0


WHILE @count<237 AND @inv_data IS NOT NULL
BEGIN
SET @type    =SUBSTRING(@inv_data,@count*16+1,2)
SET @group    =SUBSTRING(@inv_data,@count*16+10,2)


IF (@type = (SELECT CONVERT(varbinary(1), @item)) AND @group = (SELECT CONVERT(varbinary(1), (@grupo*16))))
  BEGIN
    print 'Conta: ' + @acid + ' Personagem: ' +  @name;
    SET @count=237;
  END


SET @count=@count+1


END


FETCH NEXT FROM LISTA INTO @inv_data, @name, @acid
END
CLOSE LISTA
DEALLOCATE LISTA


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


DECLARE LISTA CURSOR LOCAL FOR
SELECT items, AccountID FROM warehouse
OPEN LISTA
FETCH NEXT FROM LISTA INTO @ware_data, @acid
WHILE @@FETCH_STATUS = 0
BEGIN


SET @count=0


WHILE @count<240 AND @ware_data IS NOT NULL
BEGIN
SET @type    =SUBSTRING(@ware_data,@count*16+1,2)
SET @group    =SUBSTRING(@ware_data,@count*16+10,2)


IF (@type = (SELECT CONVERT(varbinary(1), @item)) AND @group = (SELECT CONVERT(varbinary(1), (@grupo*16))))
  BEGIN
    print 'Conta: ' + @acid;
    SET @count=240;
  END


SET @count=@count+1


END


FETCH NEXT FROM LISTA INTO @ware_data, @acid
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
set @grupo    = 0;
set @item    = 1;


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


DECLARE LISTA CURSOR LOCAL FOR
SELECT inventory, name, AccountID FROM Character
OPEN LISTA
FETCH NEXT FROM LISTA INTO @inv_data, @name, @acid
WHILE @@FETCH_STATUS = 0
BEGIN


SET @count=0


WHILE @count<237 AND @inv_data IS NOT NULL
BEGIN
SET @type    =SUBSTRING(@inv_data,@count*16+1,2)
SET @group    =SUBSTRING(@inv_data,@count*16+10,2)


IF (@type = (SELECT CONVERT(varbinary(1), @item)) AND @group = (SELECT CONVERT(varbinary(1), (@grupo*16))))
  BEGIN
    print 'Conta: ' + @acid + ' Personagem: ' +  @name;
    SET @count=237;
  END


SET @count=@count+1


END


FETCH NEXT FROM LISTA INTO @inv_data, @name, @acid
END
CLOSE LISTA
DEALLOCATE LISTA


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


DECLARE LISTA CURSOR LOCAL FOR
SELECT items, AccountID FROM warehouse
OPEN LISTA
FETCH NEXT FROM LISTA INTO @ware_data, @acid
WHILE @@FETCH_STATUS = 0
BEGIN


SET @count=0


WHILE @count<240 AND @ware_data IS NOT NULL
BEGIN
SET @type    =SUBSTRING(@ware_data,@count*16+1,2)
SET @group    =SUBSTRING(@ware_data,@count*16+10,2)


IF (@type = (SELECT CONVERT(varbinary(1), @item)) AND @group = (SELECT CONVERT(varbinary(1), (@grupo*16))))
  BEGIN
    print 'Conta: ' + @acid;
    SET @count=240;
  END


SET @count=@count+1


END


FETCH NEXT FROM LISTA INTO @ware_data, @acid
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 @[Somente membros podem ver os links. ]!!

[MuDarkAge97D]

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