một số Query thường sử dụng

[evilbaby1]

Cái này là những Query Evilbaby thường sử dụng , chủ yếu là sưu tầm vì trình độ query chưa đủ để viết ( nhưng đủ để edit )
Query tìm Character có đồ Full

select * from warehouse where (charindex (0xbf, items) %10=8) or (charindex (0xff, items) %10=8) or (charindex (0x7f, items) %10=8) or (charindex (0x3f, items) %10=8)
select * from character where (charindex (0xbf, inventory) %10=8) or (charindex (0xff, inventory) %10=8) or (charindex (0x7f, inventory) %10=8) or (charindex (0x3f, inventory) %10=8)

Query delete Account không sử dụng

DECLARE @Acc varchar(10), @Chars varchar(10)

DECLARE LISTA CURSOR LOCAL FOR
SELECT memb___id FROM MEMB_INFO
OPEN LISTA
FETCH NEXT FROM LISTA INTO @Acc
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE CHECKLISTA CURSOR LOCAL FOR
SELECT TOP 1 Name FROM Character WHERE (AccountID=@Acc)
OPEN CHECKLISTA
FETCH NEXT FROM CHECKLISTA INTO @Chars
IF @@ROWCOUNT = 0
begin
DELETE from MEMB_INFO where memb___id=@Acc
end
CLOSE CHECKLISTA
DEALLOCATE CHECKLISTA

FETCH NEXT FROM LISTA INTO @Acc
END
CLOSE LISTA
DEALLOCATE LISTA

Query nâng Class 3 cho các Character sử dụng khi char =400 và không online

Update c set
class=65
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=64

Update c set
class=34
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=33

Update c set
class=49
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=48

Update c set
class=2
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=1

Update c set
class=18
FROM Character c
left JOIN MEMB_STAT m ON c.AccountID = m.memb___id
COLLATE Latin1_general_CI_AI
WHERE c.cLevel>=400 and m.ConnectStat = 0 AND c.Class=17

query theo yêu cầu: có bạn hỏi xóa reset

UPDATE Character
SET Resets=('0')
WHERE Resets>0

Xóa Item đồ và Warehouse

UPDATE Character
SET Inventory=('')
UPDATE warehouse
SET Items=('')

Query hacker khoái sử dụng và mình cũng thích

DROP dbo.MuOnline

Còn đây là cái Query tạo ACCount tự động vào guild và cho tiền 50m , 150 point chỉ character đầu tiên , xóa cũng vậy , nhớ thêm cột counters trong Accountcharacter ( chỉ thêm tự vào guild còn cái khác người khác làm )

CREATE Procedure [dbo].[WZ_CreateCharacter] 
    @AccountID        varchar(10),
    @Name            varchar(10),
    @Class            tinyint
AS
BEGIN
    SET NOCOUNT ON
    SET    XACT_ABORT ON
    DECLARE        @Result        tinyint
    DECLARE @iGUID int
    DECLARE @BonusMoney int
    DECLARE @Counter int
    DECLARE @Phe int
    SET @Result = 0x00    
    SELECT @iGUID = memb_guid FROM MEMB_INFO WHERE memb___id = @AccountID
    IF EXISTS ( SELECT Name FROM Character WHERE Name = @Name )
    BEGIN
        SET @Result    = 0x01
        GOTO ProcEnd                        
    END
    BEGIN TRAN
    IF NOT EXISTS ( SELECT Id FROM  AccountCharacter WHERE Id = @AccountID )
        BEGIN
            INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC) 
            VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL)
            SET @Result  = @@Error
        END
    ELSE
        BEGIN
            Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)                     
            SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5, @Counter=Counter FROM dbo.AccountCharacter Where Id = @AccountID             
           IF(@Counter Is NULL OR @Counter = 0)
                BEGIN
                    UPDATE AccountCharacter SET  GameID1 = @Name
                    WHERE Id = @AccountID
                    
                    SET @BonusMoney = 50000000
                    SET @Result  = @@Error
                    UPDATE AccountCharacter SET  Counter = 1
                    WHERE Id = @AccountID
                END
            ELSE IF( @g1 Is NULL OR Len(@g1) = 0)
                BEGIN
                    UPDATE AccountCharacter SET  GameID1 = @Name
                    WHERE Id = @AccountID
                    
                    SET @Result  = @@Error
                END
            ELSE IF( @g2  Is NULL OR Len(@g2) = 0)
                BEGIN
                    UPDATE AccountCharacter SET  GameID2 = @Name
                    WHERE Id = @AccountID
                    SET @Result  = @@Error
                END
            ELSE IF( @g3  Is NULL OR Len(@g3) = 0)
                BEGIN    
                    UPDATE AccountCharacter SET  GameID3 = @Name
                    WHERE Id = @AccountID
                    SET @Result  = @@Error
                END
            ELSE IF( @g4 Is NULL OR Len(@g4) = 0)
                BEGIN
                    UPDATE AccountCharacter SET  GameID4 = @Name
                    WHERE Id = @AccountID
                    SET @Result  = @@Error
                END
            ELSE IF( @g5 Is NULL OR Len(@g5) = 0)
                BEGIN
                    UPDATE AccountCharacter SET  GameID5 = @Name
                    WHERE Id = @AccountID
                    SET @Result  = @@Error
                END    
            ELSE
                BEGIN        
                    SET @Result    = 0x03                            
                    GOTO TranProcEnd                                
                END     
        END
    IF( @Result <> 0 )
        BEGIN
            GOTO TranProcEnd        
        END
    ELSE
        BEGIN          
		SELECT @Phe=Phe FROM dbo.MEMB_INFO Where ID = @AccountID    
           		If (@Phe = 0)
        BEGIN  
 	 INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList, 
                    Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,  MDate, LDate, Quest, DbVersion, Leadership, Money )
               
            SELECT @AccountID As AccountID, @Name As Name, Level, 200, @Class As Class, 
                Strength, Dexterity, Vitality, Energy, Inventory,MagicList,  Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
                getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership, @BonusMoney As Money
	INSERT INTO dbo.GuildMember(Name, G_Name, G_Level, G_Status) 
            SELECT @Name as Name, Thien, G_Level, G_Status
            FROM  DefaultClassType WHERE Class = @Class
            SET @Result  = @@Error
	End
        ELSE
        INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList, 
                    Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,  MDate, LDate, Quest, DbVersion, Leadership, Money )
            SELECT @AccountID As AccountID, @Name As Name, Level, 200, @Class As Class, 
                Strength, Dexterity, Vitality, Energy, Inventory,MagicList,  Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
                getdate() As MDate, getdate() As LDate, Quest, DbVersion, Leadership, @BonusMoney As Money
        INSERT INTO dbo.GuildMember(Name, G_Name, G_Level, G_Status) 
            SELECT @Name as Name, Ac, G_Level, G_Status
            FROM  DefaultClassType WHERE Class = @Class
            SET @Result  = @@Error
	
        END
TranProcEnd:
    IF ( @Result  <> 0 )
        ROLLBACK TRAN
    ELSE
        COMMIT TRAN
ProcEnd:
    SET NOCOUNT OFF
    SET XACT_ABORT OFF
    SELECT
       CASE @Result
          WHEN 0x00 THEN 0x01
          WHEN 0x01 THEN 0x00
          WHEN 0x03 THEN 0x03
          ELSE 0x02
       END AS Result 
END
GO

Nói thêm vì sao có query này , vì Evilbaby tạo server mu PVP ( player VS Player ) và muốn khi tao nhân vật chia 2 phe , khi vào game , 2 phe gặp nhau đánh nhau không có tội . Muốn làm được vậy các bạn phải thêm cột phe ở Mem_info và trang web đăng ký thêm lựa chọn Phe .

[viethungpc]

DECLARE @Acc varchar(10), @Chars varchar(10)

DECLARE LISTA CURSOR LOCAL FOR
SELECT memb___id FROM MEMB_INFO
OPEN LISTA
FETCH NEXT FROM LISTA INTO @Acc
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE CHECKLISTA CURSOR LOCAL FOR
SELECT TOP 1 Name FROM Character WHERE (AccountID=@Acc)
OPEN CHECKLISTA
FETCH NEXT FROM CHECKLISTA INTO @Chars
IF @@ROWCOUNT = 0
begin
DELETE from MEMB_INFO where memb___id=@Acc
end
CLOSE CHECKLISTA
DEALLOCATE CHECKLISTA

FETCH NEXT FROM LISTA INTO @Acc
END
CLOSE LISTA
DEALLOCATE LISTA


mọi người cho mình hỏi code này để xóa acc không sử dụng cụ thể là những acc nào được không.