Pet Pages

[devdash]

my server is pluse server with huge amounts of drops so 1 page for pet is not fair at all, i want to make all the pets have 7 pages with no items, like its the basic thing, players buy the pet with 7 pages , how can i do that ?

[loader8]

Execute this Query

 Spoiler

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJobForPet] Script Date: 02/24/2013 12:26:27 ******/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- Edited by Mixizi Ethereal Online
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

ALTER PROCEDURE [dbo].[_AddTimedJobForPet]
@CharID int,
@Category tinyint,
@D int,
@Keep int,
@Data1 int,
@Data2 int,
@Data3 int,
@Data4 int,
@ int,
@Data6 int,
@Data7 int,
@Data8 int,
@64 bigint
as
if (not exists (select ID from _CharCOS with (nolock) where ID = @CharID))
return -1

declare @JobID int
set @JobID = 0

insert into _TimedJobForPet values(@CharID, @Category, @D, 1992999999, @Data1, @Data2, 112, @Data4, @, @Data6, @Data7, @Data8, @64, 0)
set @JobID = @@identity

if (@@error <> 0 or @@rowcount = 0)
return -2

return @JobID

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Credis to gigola123

[HECKT0R]

increasing your pet pages may lead for future bugs incase if you got many players .

[devdash]

Originally Posted by loader8

Execute this Query

 Spoiler

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJobForPet] Script Date: 02/24/2013 12:26:27 ******/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- Edited by Mixizi Ethereal Online
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

ALTER PROCEDURE [dbo].[_AddTimedJobForPet]
@CharID int,
@Category tinyint,
@D int,
@Keep int,
@Data1 int,
@Data2 int,
@Data3 int,
@Data4 int,
@ int,
@Data6 int,
@Data7 int,
@Data8 int,
@64 bigint
as
if (not exists (select ID from _CharCOS with (nolock) where ID = @CharID))
return -1

declare @JobID int
set @JobID = 0

insert into _TimedJobForPet values(@CharID, @Category, @D, 1992999999, @Data1, @Data2, 112, @Data4, @, @Data6, @Data7, @Data8, @64, 0)
set @JobID = @@identity

if (@@error <> 0 or @@rowcount = 0)
return -2

return @JobID

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Credis to gigola123

thanks i will try it and i will be back with the results

Originally Posted by msbmohamed

increasing your pet pages may lead for future bugs incase if you got many players .

you mean bugs like crash,dc,hiden items, etc or u mean lag ?

[HECKT0R]

Originally Posted by alydandy

thanks i will try it and i will be back with the results



you mean bugs like crash,dc,hiden items, etc or u mean lag ?

ye all of those things you have mentioned may occur anytime .

[devdash]

Originally Posted by msbmohamed

ye all of those things you have mentioned may occur anytime .

Oh , so i will keep it as one, thanks mate i really appreciate ur help <3 and i did thank you in all your usefull comments <3

[Spidy.]

#Closed