As QUERYS mais procuradas pelos Admins !

[daniellk]

Olá Galera, estou postando as query mais procuradas pelos Admnistradores de Mu Online, sempre vem alguem no msn perguntando se sei query tal, etc.
Então está ae algumas que sei !

Execute no Query Analyzer > Mu Online

DELETAR LOG DA DB
Citar
USE MUONLINE

GO
DUMP TRANSACTION MUONLINE WITH NO_LOG
GO

--ZERA ARQUIVO DE LOG
DBCC SHRINKFILE(MUONLINE_LOG, EMPTYFILE)

--REINDEXA A BASE DE DADOS
DBCC SHRINKDATABASE (MUONLINE,10)

GO

--------------------------------------------------------------------------------------------

DELETAR ACC, GUILDS ETC
Citar
DELETE MEMB_INFO
DELETE CHARACTER
DELETE MEMB_STAT
DELETE warehouse
DELETE WZ_CW_INFO
DELETE GuildMember
DELETE Guild
DELETE AccountCharacter
DELETE ExtWareHouse
DELETE AccountCharacter

--------------------------------------------------------------------------------------------

BACKUP DATA BASE AUTOMATICO
Citar
[Only registered and activated users can see links]
[Only registered and activated users can see links]
@database = 'muonline', -- BANCO DE DADOS AQUI
[Only registered and activated users can see links]
[Only registered and activated users can see links]

--------------------------------------------------------------------------------------------

BONUS DE RESETES+PONTOS+ZEN AO CRIAR ACC
Citar
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO

CREATE TRIGGER MUC_BONUS ON Dbo.Character FOR INSERT
AS
BEGIN

DECLARE
@Resets INT,
@Pontos INT,
@Dinheiro INT,
@Char varchar(10)
[Only registered and activated users can see links]

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

UPDATE Dbo.Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END

ps: é só editar a quantidade de resetes, pontos e zen que você quer onde está em negrito !

Para retirar esse Bonus Execute:

Citar
USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO

--------------------------------------------------------------------------------------------

EDITAR RESETES DE ALGUM CHAR
Citar
UPDATE Character SET Resets=Numero de resets WHERE name ='Nome do char'

--------------------------------------------------------------------------------------------

VIP + GOLDS PARA TODAS ACCS : OBS SHOP DA DARK TEAM

Citar
update memb_info set creditos = creditos+3
update memb_info set vip = 1 where vip = 0

update DT_SHOP_CREDITS set credits=credits+20

[Agathos]

--------------------------------------------------------------------------------------------

DELETAR ACC, GUILDS ETC
Citar
DELETE MEMB_INFO
DELETE CHARACTER
DELETE MEMB_STAT
DELETE warehouse
DELETE WZ_CW_INFO
DELETE GuildMember
DELETE Guild
DELETE AccountCharacter
DELETE ExtWareHouse
DELETE AccountCharacter

--------------------------------------------------------------------------------------------
Recomento cautela ao executar os comandos citados acima. No caso ai eles apagariam a tabela inteira com todas as colunas e não só uma Guild ou Conta.
Em todo caso, um backup na database antes de começar a mexer não faz mal. ^^