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 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

 

[mytzanujrboss]

Re: [TuT] - Custom GM Command Logs!?

Thank you for this querry

 

[ferpa125]

Re: [TuT] - Custom GM Command Logs!?

woooow very usefull, thanks

 

[asd234]

Re: [TuT] - Custom GM Command Logs!?

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

 

[HusseinAlor]

Re: [TuT] - Custom GM Command Logs!?

Good Job ، Thanks <3