ShardManager process reduce + reduce log + delete logs

limanerg · 01/22/2012, 02:44

Hey all how r u?okey enough

GOAL
doesnt recording the database logs

EFFECT
* ShardManager msgCount values reduce 9000+ to 5-10
* youve got lower lag because we'll delete recording logs
* die for logs

DIFFICULTY
Easy

Read these to database

_AddLogChar

Code:

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 12/02/2011 11:35:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[_AddLogChar] 
@CharID int,
@EventID tinyint,
@Data1 int,
@Data2 int,
@strPos varchar(64),
@Desc varchar(128)
as
declare @len_pos int
declare @len_desc int
set @len_pos = len(@strPos)
set @len_desc = len(@Desc)
if (@len_pos > 0 and @len_desc > 0)
begin 
return -1
end
else if (@len_pos > 0 and @len_desc = 0)
begin 
return -2
end
else if (@len_pos = 0 and @len_desc > 0)
begin 
return -3
end
else
begin 
return -4
end

_AddLogItems

Code:

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 12/02/2011 11:37:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log 
ALTER procedure [dbo].[_AddLogItem] 
@CharID int, 
@ItemRefID int, 
@ItemSerial bigint, 
@dwData int, 
@TargetStorage tinyint, 
@Operation tinyint, 
@Slot_From tinyint, 
@Slot_To tinyint, 
@EventPos varchar(64), 
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ğÀÔ 
as 
declare @len_pos int 
declare @len_desc int 
set @len_pos = len(@EventPos) 
set @len_desc = len(@strDesc) 
if (@len_pos > 0 and @len_desc > 0) 
begin 
return -1
end 
else if (@len_pos > 0 and @len_desc = 0) 
begin 
return -1
end 
else if (@len_pos = 0 and @len_desc > 0) 
begin 
return -1
end 
else if (@len_pos = 0 and @len_desc = 0) 
begin 
return -1
end 
-- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀÌ¸é! 
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35 
if (@Operation = 35) 
begin 
return -1
end

_AddLogSchedule

Code:

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogSchedule] Script Date: 12/02/2011 11:38:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ·Î±× »ğÀÔ ÇÁ·Î½ÃÀú 
ALTER PROCEDURE [dbo].[_AddLogSchedule] 
@ServerType VARCHAR(124),
@ServerBodyID INT, 
@ScheduleDefine VARCHAR(124),
@ScheduleIdx INT,
@nType VARCHAR(10), 
@OccureTime DATETIME -- °¢°¢ÀÇ ¸Ó½ÅÀÇ ½Ã°£À» Àû¾îÁØ´Ù.
AS
return -1

_AddLogServerEvent

Code:

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogServerEvent] Script Date: 12/02/2011 11:39:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_AddLogServerEvent] 
@ServerEventID int,
@LogType tinyint,
@Desc varchar(128)
as
declare @len_desc int
set @len_desc = len(@Desc)
if ( @len_desc > 0)
begin 
return -1
end 
else
begin 
return -1
end

_AddLogSiegeFortress

Code:

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogSiegeFortress] Script Date: 12/02/2011 11:40:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_AddLogSiegeFortress] 
@FortressID int,
@EventID tinyint,
@CharID int,
@Data1 int,
@Data2 int,
@Desc varchar(128)
as
declare @len_desc int
set @len_desc = len(@Desc)
if ( @len_desc > 0)
begin 
return -1
end 
else
begin 
return -1
end

sincerly :P

Yo123 · 01/22/2012, 10:53

#approved.

limanerg · 01/22/2012, 11:40

Quote:

Originally Posted by Yo123

#approved.

Thanks

alexhun · 01/22/2012, 14:57

copy paste from another forum, atleast give credits

limanerg · 01/22/2012, 15:02

Quote:

Originally Posted by alexhun

copy paste from another forum, atleast give credits

idk from which forum.
I took these from my turkish forum.My moderator friend was open this thread n i share with you

_slimshady_ · 01/23/2012, 02:42

Taken from RaGE Zone - MMORPG server development forums posted by Jangan on 12-2-11

FoxRayz · 01/23/2012, 02:51

Quote:

Originally Posted by _slimshady_

Taken from RaGE Zone - MMORPG server development forums posted by Jangan on 12-2-11

First of all there's barely no first releases here anymore because of this unthankful community. So they'll release it somewhere else in the first place ofc. You shouldn't complain about a copy paste release, be happy that atleast some people are still struggling to hold up this section.

limanerg · 01/23/2012, 03:20

Quote:

Originally Posted by FoxRayz

First of all there's barely no first releases here anymore because of this unthankful community. So they'll release it somewhere else in the first place ofc. You shouldn't complain about a copy paste release, be happy that atleast some people are still struggling to hold up this section.

_slimshady_ · 01/23/2012, 03:51

Quote:

Originally Posted by FoxRayz

First of all there's barely no first releases here anymore because of this unthankful community. So they'll release it somewhere else in the first place ofc. You shouldn't complain about a copy paste release, be happy that atleast some people are still struggling to hold up this section.

The only time you see me complain about a copy + paste is when no credit is given to the original creator and people post someone else's work on another forum and claim it as their own to get thanks...in my opinion that's not right. 95% of members here have no respect for anyone's work. In my opinion, all threads on this forum should be moderator approved first...

~~HaGsTeR~~ · 01/23/2012, 12:14

Quote:

Originally Posted by FoxRayz

First of all there's barely no first releases here anymore because of this unthankful community. So they'll release it somewhere else in the first place ofc. You shouldn't complain about a copy paste release, be happy that atleast some people are still struggling to hold up this section.

thing is every forum is the same
its the people, the community, its not different
only reason people thinks R.agezone n **** has more "mature" and "better" People is because mods are more active there, ******* trolls up, removes spamms, their way more active, but the community aint different
if you think the epvp community is so special / unique / ****** then thats because you only hang around on epvp

this "lets post on r.agezone cuz everyone on epvp are kids and idiots" bullshit ****** me off badly

ontopic (i dont want an infraction) :
that **** in the code field r DB related
kthxbb

Dr.Abdelfattah · 01/23/2012, 12:34

that's useful but very dangerous , Cuz u are not able anymore to know what's ur players moves , for example if u execute that = no logs = u can't trace any exchange log or something ,
well u maybe it seems to u that's useless to trace someone , but in future it will safe you from many problems .

limanerg · 01/23/2012, 15:04

Quote:

Originally Posted by Dr.Abdelfattah

that's useful but very dangerous , Cuz u are not able anymore to know what's ur players moves , for example if u execute that = no logs = u can't trace any exchange log or something ,
well u maybe it seems to u that's useless to trace someone , but in future it will safe you from many problems .

yes i tried it

~~jangan322~~ · 01/25/2012, 10:28

Quote:

Originally Posted by Dr.Abdelfattah

that's useful but very dangerous , Cuz u are not able anymore to know what's ur players moves , for example if u execute that = no logs = u can't trace any exchange log or something ,
well u maybe it seems to u that's useless to trace someone , but in future it will safe you from many problems .

Not if you are the original coder who knows what the **** he is doing.

This is 100% stolen piece by piece code from me. Good job copy+pasting without credit.

This is def the biggest worthless forum that ever existed, especially filled with worthless leechers! Keep stealing my work losers.