How to fix 5page pet crash permanently.

[Shevo Manser]

http://www12.0zz0.com/2013/10/22/08/724487457.png (http://www.0zz0.com)

اليوم جايب لى اللى عاوز البت 5page و يما بيعملها بيجيله كراش دلواقتى انا جايب حل علشان نتخلص من المشكلة ديه خالص نخش فى الموضوع على طول

http://www12.0zz0.com/2013/10/22/08/859624173.gif (http://www.0zz0.com)

1-Query
USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_Exceptionz] Script Date: 07/29/2012 02:54:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_Exceptionz](
[ID] [int] NULL
) ON [PRIMARY]

GO

http://www12.0zz0.com/2013/10/22/08/859624173.gif (http://www.0zz0.com)

2-Query
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_MYOWON%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_SEOWON%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_RABBIT%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_SPOT_RABBIT%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_RABBIT_SILK%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_GOLDPIG%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_PINKPIG%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_GGLIDER%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_CAT%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_RACCOONDOG%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_BROWNIE%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_WINTER_SNOWMAN%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_GHOST%'))
insert into _Exceptionz (ID) values ((select ID from _RefObjCommon where CodeName128 like 'COS_P_CIRCUSBEAR%'))

3-Query
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 07/29/2012 02:35:06 ******/
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 (AÖ1±EL)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

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 (AÖ1±EL)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (AÖ1±EL)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- AÎoYA丮 »ý1o 1ÇA?!
rollback tran
return -2
end

set @Slot = @Slot + 1
end
end

/* --´o AI»ó AI ÄA·3?!´Â µYAIA͸¦ 3ÖÁö 3E´Â´U!
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

if ((SELECT COUNT(*) FROM _Exceptionz where ID=@RefObjID) = 1)
begin
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
declare @Serial64 bigint
select @Serial64 = Serial64 from _Items where Data = @COS_ID
exec _AddTimedJobForPet @COS_ID,5,22926,1992999999,1111708465,1,112,0,0,0, 0,0,@Serial64
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
end
end

commit tran

return @COS_ID

4-Query
use SHARD
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_WOLF_01%'))
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_WOLF_02%'))
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_WOLF_03%'))
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_WOLF_04%'))
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_JINN%'))
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_RAVEN%'))
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_PENGUIN%'))
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_KANGAROO%'))
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_BEAR%'))
delete from _TimedJobForPet where CharID in (select ID from _CharCOS where RefCharID in (select ID from _RefObjCommon where codename128 like 'COS_P_FOX%'))

http://www12.0zz0.com/2013/10/22/08/103505552.gif (http://www.0zz0.com)

شكرا