Pet Pages

03/08/2018 13:55 devdash#1

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 ?

03/09/2018 17:14 loader8#2

Execute this Query

Spoiler

Credis to gigola123

03/10/2018 23:42 HECKT0R#3

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

03/11/2018 00:27 devdash#4

Quote:

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,
@[Only registered and activated users can see links. Click Here To Register...]D int,
@[Only registered and activated users can see links. Click Here To Register...]Keep int,
@Data1 int,
@Data2 int,
@Data3 int,
@Data4 int,
@[Only registered and activated users can see links. Click Here To Register...] int,
@Data6 int,
@Data7 int,
@Data8 int,
@[Only registered and activated users can see links. Click Here To Register...]64 bigint
as
if (not exists (select ID from _CharCOS with (nolock) where ID = @CharID))
return -1

declare @[Only registered and activated users can see links. Click Here To Register...]JobID int
set @[Only registered and activated users can see links. Click Here To Register...]JobID = 0

insert into _TimedJobForPet values(@CharID, @Category, @[Only registered and activated users can see links. Click Here To Register...]D, 1992999999, @Data1, @Data2, 112, @Data4, @[Only registered and activated users can see links. Click Here To Register...], @Data6, @Data7, @Data8, @[Only registered and activated users can see links. Click Here To Register...]64, 0)
set @[Only registered and activated users can see links. Click Here To Register...]JobID = @@identity

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

return @[Only registered and activated users can see links. Click Here To Register...]JobID

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

Credis to gigola123

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

Quote:

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 ?

03/11/2018 00:33 HECKT0R#5

Quote:

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 .

03/11/2018 03:36 devdash#6

Quote:

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

03/11/2018 19:51 Spidy.#7

#Closed