|
You last visited: Today at 22:05
Advertisement
[GUIDE]5/5 Pet inventory
Discussion on [GUIDE]5/5 Pet inventory within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
02/11/2012, 08:15
|
#1
|
elite*gold: 179
Join Date: Dec 2010
Posts: 931
Received Thanks: 311
|
[GUIDE]5/5 Pet inventory
Go to _AddNewCOS SP under SRO_SHARD modify and replace with this below.
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddNewCOS]
@OwnerCharID int,
@RefObjID int,
@Level int,
@HP int,
@MP int,
@HGP int,
@KeeperNPC int,
@State int,
@InventorySize int,
@itemID int,
@PickItemConfig tinyint,
@RentEndTime smalldatetime
as
begin tran
declare @COS_ID int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @MaxInventorySize tinyint
select @MaxInventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
begin
rollback tran
return -5
end
insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @COS_ID = @@identity
if (@COS_ID = 0 OR @@error <> 0)
begin
rollback tran
return -1
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
rollback tran
return -2
end
set @Slot = @Slot + 1
end
end
/* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @COS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 1 MONTH
declare @Serial64 bigint
select @Serial64 = Serial64 from _Items where Data = @COS_ID
exec _AddTimedJobForPet @COS_ID,5,22926,1331260204,1111708465,1,112,0,0,0,0,0,@Serial64
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 1 MONTH
end
commit tran
return @COS_ID
Copied from ********
|
|
|
02/20/2012, 23:35
|
#2
|
elite*gold: 0
Join Date: Nov 2011
Posts: 93
Received Thanks: 16
|
Quote:
Originally Posted by ermvrs
Go to _AddNewCOS SP under SRO_SHARD modify and replace with this below.
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddNewCOS]
@OwnerCharID int,
@RefObjID int,
@Level int,
@HP int,
@MP int,
@HGP int,
@KeeperNPC int,
@State int,
@InventorySize int,
@itemID int,
@PickItemConfig tinyint,
@RentEndTime smalldatetime
as
begin tran
declare @COS_ID int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @MaxInventorySize tinyint
select @MaxInventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
begin
rollback tran
return -5
end
insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @COS_ID = @@identity
if (@COS_ID = 0 OR @@error <> 0)
begin
rollback tran
return -1
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
rollback tran
return -2
end
set @Slot = @Slot + 1
end
end
/* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @COS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 1 MONTH
declare @Serial64 bigint
select @Serial64 = Serial64 from _Items where Data = @COS_ID
exec _AddTimedJobForPet @COS_ID,5,22926,1331260204,1111708465,1,112,0,0,0,0,0,@Serial64
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 1 MONTH
end
commit tran
return @COS_ID
Copied from R a g e z o n e . c o m
|
So...
|
|
|
02/23/2012, 21:33
|
#3
|
elite*gold: 179
Join Date: Dec 2010
Posts: 931
Received Thanks: 311
|
?
|
|
|
03/04/2012, 13:26
|
#4
|
elite*gold: 0
Join Date: Jun 2010
Posts: 53
Received Thanks: 17
|
Thanks Bro i will try and tell u hope that works ^^
|
|
|
03/06/2012, 14:28
|
#5
|
elite*gold: 0
Join Date: Jun 2011
Posts: 802
Received Thanks: 393
|
Quote:
Originally Posted by Avalance Danger
So...
|
rage_zone *** licker ?
|
|
|
03/07/2012, 10:38
|
#6
|
elite*gold: 0
Join Date: Apr 2009
Posts: 1,353
Received Thanks: 279
|
Nvm useful guide =)
|
|
|
03/09/2012, 19:21
|
#7
|
elite*gold: 104
Join Date: Feb 2010
Posts: 1,024
Received Thanks: 268
|
thanks. dc
|
|
|
06/28/2012, 19:12
|
#8
|
elite*gold: 0
Join Date: Feb 2008
Posts: 32
Received Thanks: 0
|
works?
|
|
|
06/28/2012, 19:31
|
#9
|
elite*gold: 0
Join Date: Sep 2009
Posts: 520
Received Thanks: 435
|
Somebody success that in old chinese files, there is no _AddTimedJobForPet in old files.
|
|
|
|
Similar Threads
|
[Guide]Spawn Newbie Gift on newcomer inventory(replace method)!
08/24/2013 - EO PServer Guides & Releases - 11 Replies
Hello again, i want to show you how to add the newbie gift to the inventory of a new user without adding any npc or add the item to any shop.
Ok let's start.
When u login for the first time you will see in your inventory two not needed items:
Shelley's Letter
Queen`sLetter
Those two items are totally useless so we are gonna to replace them with the newbie gift. Newbie Gift item id is 729012
|
Inventory Breaking/Cleanup Guide -Breaking Any Item Without Guilt
08/24/2011 - Grand Chase Philippines - 12 Replies
For those who are still having problems on inventory spaces, being unable to add any items in their inventory because it is already full or nearly full, here is a guide to free up a lot of space. There are items which could be sold, items which could be broken or both. Sell those unuseful items or break them as you wish to free up your inventory space. Item breaking, of course is thru the use of DK-P Type 0812 or more commonly known as the crafting/breaking machine on your grand chase Menu tab...
|
[GUIDE] Item Filter Guide | Cabal Crafting & Dungeon Guide by Dewa Gempak.
06/15/2008 - Cabal Guides & Templates - 5 Replies
Since its his work, just SHARING it here, i just gonna link his URL from his work. because i dont like copy and pasting other ppl's guides:
http://119.110.98.150:90/ipb/index.php?showtopic= 1145
Q#1: Does it work with CabalRider (PH)?
A#1: Yes, it works, i tried it personally myself.
Q#2: I'm too dumb to understand it, how to make it work.
A#2: Try reading it again and again, if u still don't know how, don't use it then sleep.gif
|
All times are GMT +2. The time now is 22:05.
|
|