Custom GM Command Logs!?

[Jangan]

Well, idk, this might be helpful, i dont really want to go into too much details since i have no use for it. But PvE Server owners should probably customize this even furthur xD


My query pretty much just gives me the GM logs of items created! you can customize this even more.


Open SMC logs and you might understand what i mean :P Sorry if this is too confusing, just wanted to show where people can find the gm logs!

USE [SRO_VT_ACCOUNT]
GO
/****** BY Jangan ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_GetSMLog]
    @nCatagory    tinyint,
    @szUserID    varchar(128),
    @szBeginDate    datetime,
    @szEndDate    datetime
as
    IF LEN(@szUserID) > 0
    BEGIN
        IF @nCatagory = 0 
        BEGIN
            select * from _SMCLog with (nolock) 
            where dLogDate 
                between @szBeginDate and @szEndDate  
                and szUserID = @szUserID 
                and szLog like 'DropItem:%%' --## Custom Addon
                order by dLogDate
        END
        ELSE
        BEGIN
            select * from _SMCLog with (nolock) 
            where dLogDate between @szBeginDate and @szEndDate 
                and szUserID = @szUserID and Catagory = @nCatagory and szUserID = @szUserID  
                and szLog like 'DropItem:%%' --## Custom Addon
                order by dLogDate
        END
    END
    ELSE
    BEGIN
        IF @nCatagory = 0
        BEGIN
            select * from _SMCLog with (nolock) 
            where dLogDate between @szBeginDate and @szEndDate 
            and szLog like 'DropItem:%%' --## Custom Addon
            order by dLogDate
        END
        ELSE
        BEGIN
            select * from _SMCLog with (nolock) 
            where dLogDate between @szBeginDate and @szEndDate  and Catagory = @nCatagory 
            and szLog like 'DropItem:%%' --## Custom Addon
            order by dLogDate
        END
    END 

[MentaL]

[mytzanujrboss]

Thank you for this querry :)

[ferpa125]

woooow very usefull, thanks :)

[asd234]

i dont get it.. can u please go into more details? XD

[HusseinAlor]

Good Job ، Thanks <3