|
You last visited: Today at 20:58
Advertisement
small problem
Discussion on small problem within the SRO Private Server forum part of the Silkroad Online category.
01/26/2015, 23:46
|
#1
|
elite*gold: 0 
Join Date: Jun 2013
Posts: 145
Received Thanks: 15
|
small problem
i have problem with my game when i buy new attack pets from npc i got dc and when i open again i found it in my invintory but when i get dc i get new line in sr game server
AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18]
and thx 
|
|
|
|
01/27/2015, 05:37
|
#2
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
Your payment devices are ****** and probably has silks.
|
|
|
|
|
01/27/2015, 06:48
|
#3
|
elite*gold: 50
Join Date: Mar 2013
Posts: 1,153
Received Thanks: 412
|
Your db has different lines than your client..
use this query.
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_UPDATE_COST] Script Date: 26.02.2012 14:03:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- »َء،°³ئي (أض¼±ب£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
ALTER PROCEDURE [dbo].[_UPDATE_COST]
@Operation tinyint,
@CharID int,
@PaymentDevice int,
@PackageItemCodeName varchar(129),
@RemainGold bigint,
@OwnSilkToPay int,
@GiftSilkToPay int,
@OffsetOptionalPoint int,
@MileageToPay int
AS
SET NOCOUNT ON
declare @PaymentDeviceTemp int
declare @RemainOwnSilk int
declare @RemainGiftSilk int
declare @RemainMileage int
declare @Result int
set @RemainOwnSilk = 0
set @RemainGiftSilk = 0
set @RemainMileage = 0
IF (@RemainGold < 0 or @MileageToPay < 0 or @OwnSilkToPay < 0 or @GiftSilkToPay < 0 or @OffsetOptionalPoint < 0)
BEGIN
RETURN -2001
END
DECLARE @PC_ID INT
set @PC_ID = @CharID
----------------------------------------------------------
-- Operation؟، µû¶َ¼* ہ¯ہْ ؤ³¸¯إح ¾ئہجµً°، ³ر¾î ؟أ¼ِµµ ہض°ي, cos ¾ئہجµً°، ³ر¾î ؟أ ¼ِµµ ہض´ظ.
-- ؤ³¸¯إح ¾ئہجµً¸¦ ¾îآ¶´ّ ¾ث¾ئ³»¾ك اد°ع´ظ.
----------------------------------------------------------
if (@Operation = 19)
begin
-- COS ؟ë ¹°ا°ہ» ±¸ہشار°إ´د±ٌ... ؤ³¸¯ أ£¾ئ¼* µ· »©ءà¾كءِ...
SELECT @PC_ID = OwnerCharID FROM _CharCOS WHERE ID = @PC_ID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2002
END
end
/*
#define EXPAND_DEVICE_GOLDPRICE 1
#define EXPAND_DEVICE_SILKPRICE 2
#define EXPAND_DEVICE_GIFTSILKPRICE 4
#define EXPAND_DEVICE_GUILDPOINT 8
#define EXPAND_DEVICE_MILEAGE 16
*/
if ((@PaymentDevice & 8) > 0)
begin
-- ½اإ©, ¼±¹°½اإ©, ¸¶ہد¸®ءِ¸¦ ±î¾ك اد´آ±¸¸¸.
-- ´ـ, ¸¶ہد¸®ءِ´آ ؟ة¼اہج´ظ.
-- ؤ³¸¯إحہا JID¸¦ ¾ٍ¾î؟ہ³ت¶َ.
declare @JID int
select top 1 @JID = UserJID from _User
where CharID = @PC_ID
IF (@@ROWCOUNT = 0 OR @@ERROR <> 0)
BEGIN
RETURN -2006
END
DECLARE @PackageItemID int
select @PackageItemID = ID from dbo._RefPackageItem where codename128 = @PackageItemCodeName
DECLARE @rvalue int
-- EXEC @rvalue = SRO_VT_ACCOUNT.DBO._ConsumeSilkByGameServer @JID, @OwnSilkToPay OUTPUT, @GiftSilkToPay OUTPUT, @MileageToPay output, 1, @CharID
EXEC @rvalue = SRO_VT_ACCOUNT.DBO._ConsumeSilkByGameServer @JID, @OwnSilkToPay OUTPUT, @GiftSilkToPay OUTPUT, @MileageToPay output, 0, @CharID, @PackageItemID , 0
IF (@rvalue < 0 OR @@ERROR <> 0)
BEGIN
RETURN -2012
END
--------------------------
--<< 1. ¼ِء¤ ہü ؤعµه >> -- ءضب*
--------------------------
-- -- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 255, @OwnSilkToPay, 2, 0, 1)
--
-- if (@@ERROR <> 0 or @@ROWCOUNT = 0)
-- begin
-- return -2007
-- end
--
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 254,@GiftSilkToPay, 4, 0, 1)
--
-- if (@@ERROR <> 0 or @@ROWCOUNT = 0)
-- begin
-- return -2007
-- end
--
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 253,@MileageToPay, 16, 0, 1)
--------------------------
--<< 1. ¼ِء¤ بؤ ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 255, @OwnSilkToPay, 2, 0, 1, 0)
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 254,@GiftSilkToPay, 4, 0, 1, 0)
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 253,@MileageToPay, 16, 0, 1, 0)
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
end
-- gold
if ((@PaymentDevice & 1) > 0)
begin
UPDATE _Char SET RemainGold = @RemainGold WHERE CharID = @PC_ID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2003
END
end
-- guildpoint
if ((@PaymentDevice & > 0)
BEGIN
-- ±وµه¸¦ ¾ث¾ئ؟ح¶َ.
declare @GuildID int
select @GuildID = GuildID from _GuildMember
where CharID = @PC_ID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2004
END
-- ±وµه ئ÷ہخئ® ±î¶َ.
update _Guild set GatheredSP = GatheredSP - @OffsetOptionalPoint
where GatheredSP >= @OffsetOptionalPoint and ID = @GuildID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
/*
-- ¾ّہ»¼ِµµ ہض´آ°إ´ظ.
-- by novice. 2010-01-15 ؟،·¯ؤعµه µ¥ہجإحاü ب®ہه
-- ؟ّ·، ءض¼®µا¾î ہض´ّ ؤعµهہجءِ¸¸, أكبؤ °³¹كاد´آ »ç¶÷µéہج
-- ¼ِء¤µاءِ ¾تہ؛ ³»؟ëہ» ؛¸°ي ب¥¶ُ½؛·¯؟ِ از ¼ِ ہض¾î¼*
-- ہج ؛خ؛ذ±îءِ ¼ِء¤اط¹ِ¸²!
-- declare @Slot tinyint
declare @Slot int
declare @RefItemSerial64 bigint
declare @RefItemDBID bigint
declare @RefItemID int
declare @Type tinyint
-- by novice. 2010-01-15 ؟،·¯ؤعµه µ¥ہجإحاü ب®ہه
-- set @Slot = 0xd0 -- error_num ¼*¹ِ؟،¼* »ç؟ëاد´آ ؟،·¯
-- MAKE_SRO_SP_ERR_TYPE( _UPDATE_COST, 0x0004);
-- DEFINE_SRO_SP_ERR( SRO_SP_ERR_NOT_ENOUGH_GUILD_POINT, _UPDATE_COST, 0x8001 ); // ==> 0x80010004
-- BIND_SRO_SP_ERR_TO_SRO_ERR( SRO_SP_ERR_NOT_ENOUGH_GUILD_POINT, STRGERR_NOT_ENOUGH_GUILDPOINT );
set @Slot = 0x80010004 -- error_num ¼*¹ِ؟،¼* »ç؟ëاد´آ ؟،·¯
set @RefItemSerial64 = 0
set @RefItemDBID = 0
set @RefItemID = 0
set @Type = 2
select @Operation, @Slot, @RefItemSerial64, @RefItemDBID, @RefItemID, @Type
*/
RETURN -2005
END
--------------------------
--<< 2. ¼ِء¤ ہü ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 252, @OffsetOptionalPoint, 8, 0, 1)
--------------------------
--<< 2. ¼ِء¤ بؤ ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 252, @OffsetOptionalPoint, 8, 0, 1, 0)
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
end
-- honorpoint
else if ((@PaymentDevice & 32) > 0)
begin
-- honorpoint ±î¶َ.
update _TrainingCampMember set HonorPoint = HonorPoint - @OffsetOptionalPoint
where HonorPoint >= @OffsetOptionalPoint and CharID = @PC_ID
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2006
end
--------------------------
--<< 3. ¼ِء¤ ہü ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 252, @OffsetOptionalPoint, 32, 0, 1)
--------------------------
--<< 3. ¼ِء¤ بؤ ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 252, @OffsetOptionalPoint, 32, 0, 1, 0)
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
end
SET NOCOUNT OFF
return 1
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
|
|
|
|
|
01/27/2015, 10:22
|
#4
|
elite*gold: 0
Join Date: Jun 2013
Posts: 145
Received Thanks: 15
|
|
|
|
|
|
01/27/2015, 11:54
|
#5
|
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,439
|
Add a new line for each pet in the _RefPricePolicyOfItems with service off cost 1 silk
Code:
select * from _RefPricePolicyOfItem where RefPackageItemCodeName like '%ITEM_YOUR_ITEM%'
Change YOUR_ITEM with one of the pet names.
|
|
|
|
|
01/27/2015, 13:01
|
#6
|
elite*gold: 0
Join Date: Jun 2013
Posts: 145
Received Thanks: 15
|
i dont need make this item for silk 
|
|
|
|
|
01/27/2015, 13:04
|
#7
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
Quote:
Originally Posted by unlimited2311
i dont need make this item for silk |
Service = 0 xD
|
|
|
|
|
01/27/2015, 13:22
|
#8
|
elite*gold: 0
Join Date: Jun 2013
Posts: 145
Received Thanks: 15
|
(Y) thx
|
|
|
|
|
01/27/2015, 13:32
|
#9
|
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,439
|
So? This works?
|
|
|
|
|
01/27/2015, 13:40
|
#10
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
If it doesn't work then,
Code:
SELECT * FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName LIKE '%ITEM_YOUR_ITEM%'
and show us the result
|
|
|
|
|
01/27/2015, 14:53
|
#11
|
elite*gold: 0
Join Date: Jun 2013
Posts: 145
Received Thanks: 15
|
its not work
any other answer
|
|
|
|
|
01/28/2015, 00:10
|
#12
|
elite*gold: 50
Join Date: Mar 2013
Posts: 1,153
Received Thanks: 412
|
but this should helped?
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_UPDATE_COST] Script Date: 26.02.2012 14:03:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- »َء،°³ئي (أض¼±ب£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
ALTER PROCEDURE [dbo].[_UPDATE_COST]
@Operation tinyint,
@CharID int,
@PaymentDevice int,
@PackageItemCodeName varchar(129),
@RemainGold bigint,
@OwnSilkToPay int,
@GiftSilkToPay int,
@OffsetOptionalPoint int,
@MileageToPay int
AS
SET NOCOUNT ON
declare @PaymentDeviceTemp int
declare @RemainOwnSilk int
declare @RemainGiftSilk int
declare @RemainMileage int
declare @Result int
set @RemainOwnSilk = 0
set @RemainGiftSilk = 0
set @RemainMileage = 0
IF (@RemainGold < 0 or @MileageToPay < 0 or @OwnSilkToPay < 0 or @GiftSilkToPay < 0 or @OffsetOptionalPoint < 0)
BEGIN
RETURN -2001
END
DECLARE @PC_ID INT
set @PC_ID = @CharID
----------------------------------------------------------
-- Operation؟، µû¶َ¼* ہ¯ہْ ؤ³¸¯إح ¾ئہجµً°، ³ر¾î ؟أ¼ِµµ ہض°ي, cos ¾ئہجµً°، ³ر¾î ؟أ ¼ِµµ ہض´ظ.
-- ؤ³¸¯إح ¾ئہجµً¸¦ ¾îآ¶´ّ ¾ث¾ئ³»¾ك اد°ع´ظ.
----------------------------------------------------------
if (@Operation = 19)
begin
-- COS ؟ë ¹°ا°ہ» ±¸ہشار°إ´د±ٌ... ؤ³¸¯ أ£¾ئ¼* µ· »©ءà¾كءِ...
SELECT @PC_ID = OwnerCharID FROM _CharCOS WHERE ID = @PC_ID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2002
END
end
/*
#define EXPAND_DEVICE_GOLDPRICE 1
#define EXPAND_DEVICE_SILKPRICE 2
#define EXPAND_DEVICE_GIFTSILKPRICE 4
#define EXPAND_DEVICE_GUILDPOINT 8
#define EXPAND_DEVICE_MILEAGE 16
*/
if ((@PaymentDevice & 8) > 0)
begin
-- ½اإ©, ¼±¹°½اإ©, ¸¶ہد¸®ءِ¸¦ ±î¾ك اد´آ±¸¸¸.
-- ´ـ, ¸¶ہد¸®ءِ´آ ؟ة¼اہج´ظ.
-- ؤ³¸¯إحہا JID¸¦ ¾ٍ¾î؟ہ³ت¶َ.
declare @JID int
select top 1 @JID = UserJID from _User
where CharID = @PC_ID
IF (@@ROWCOUNT = 0 OR @@ERROR <> 0)
BEGIN
RETURN -2006
END
DECLARE @PackageItemID int
select @PackageItemID = ID from dbo._RefPackageItem where codename128 = @PackageItemCodeName
DECLARE @rvalue int
-- EXEC @rvalue = SRO_VT_ACCOUNT.DBO._ConsumeSilkByGameServer @JID, @OwnSilkToPay OUTPUT, @GiftSilkToPay OUTPUT, @MileageToPay output, 1, @CharID
EXEC @rvalue = SRO_VT_ACCOUNT.DBO._ConsumeSilkByGameServer @JID, @OwnSilkToPay OUTPUT, @GiftSilkToPay OUTPUT, @MileageToPay output, 0, @CharID, @PackageItemID , 0
IF (@rvalue < 0 OR @@ERROR <> 0)
BEGIN
RETURN -2012
END
--------------------------
--<< 1. ¼ِء¤ ہü ؤعµه >> -- ءضب*
--------------------------
-- -- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 255, @OwnSilkToPay, 2, 0, 1)
--
-- if (@@ERROR <> 0 or @@ROWCOUNT = 0)
-- begin
-- return -2007
-- end
--
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 254,@GiftSilkToPay, 4, 0, 1)
--
-- if (@@ERROR <> 0 or @@ROWCOUNT = 0)
-- begin
-- return -2007
-- end
--
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 253,@MileageToPay, 16, 0, 1)
--------------------------
--<< 1. ¼ِء¤ بؤ ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 255, @OwnSilkToPay, 2, 0, 1, 0)
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 254,@GiftSilkToPay, 4, 0, 1, 0)
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 253,@MileageToPay, 16, 0, 1, 0)
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
end
-- gold
if ((@PaymentDevice & 1) > 0)
begin
UPDATE _Char SET RemainGold = @RemainGold WHERE CharID = @PC_ID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2003
END
end
-- guildpoint
if ((@PaymentDevice & > 0)
BEGIN
-- ±وµه¸¦ ¾ث¾ئ؟ح¶َ.
declare @GuildID int
select @GuildID = GuildID from _GuildMember
where CharID = @PC_ID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
RETURN -2004
END
-- ±وµه ئ÷ہخئ® ±î¶َ.
update _Guild set GatheredSP = GatheredSP - @OffsetOptionalPoint
where GatheredSP >= @OffsetOptionalPoint and ID = @GuildID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
/*
-- ¾ّہ»¼ِµµ ہض´آ°إ´ظ.
-- by novice. 2010-01-15 ؟،·¯ؤعµه µ¥ہجإحاü ب®ہه
-- ؟ّ·، ءض¼®µا¾î ہض´ّ ؤعµهہجءِ¸¸, أكبؤ °³¹كاد´آ »ç¶÷µéہج
-- ¼ِء¤µاءِ ¾تہ؛ ³»؟ëہ» ؛¸°ي ب¥¶ُ½؛·¯؟ِ از ¼ِ ہض¾î¼*
-- ہج ؛خ؛ذ±îءِ ¼ِء¤اط¹ِ¸²!
-- declare @Slot tinyint
declare @Slot int
declare @RefItemSerial64 bigint
declare @RefItemDBID bigint
declare @RefItemID int
declare @Type tinyint
-- by novice. 2010-01-15 ؟،·¯ؤعµه µ¥ہجإحاü ب®ہه
-- set @Slot = 0xd0 -- error_num ¼*¹ِ؟،¼* »ç؟ëاد´آ ؟،·¯
-- MAKE_SRO_SP_ERR_TYPE( _UPDATE_COST, 0x0004);
-- DEFINE_SRO_SP_ERR( SRO_SP_ERR_NOT_ENOUGH_GUILD_POINT, _UPDATE_COST, 0x8001 ); // ==> 0x80010004
-- BIND_SRO_SP_ERR_TO_SRO_ERR( SRO_SP_ERR_NOT_ENOUGH_GUILD_POINT, STRGERR_NOT_ENOUGH_GUILDPOINT );
set @Slot = 0x80010004 -- error_num ¼*¹ِ؟،¼* »ç؟ëاد´آ ؟،·¯
set @RefItemSerial64 = 0
set @RefItemDBID = 0
set @RefItemID = 0
set @Type = 2
select @Operation, @Slot, @RefItemSerial64, @RefItemDBID, @RefItemID, @Type
*/
RETURN -2005
END
--------------------------
--<< 2. ¼ِء¤ ہü ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 252, @OffsetOptionalPoint, 8, 0, 1)
--------------------------
--<< 2. ¼ِء¤ بؤ ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 252, @OffsetOptionalPoint, 8, 0, 1, 0)
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
end
-- honorpoint
else if ((@PaymentDevice & 32) > 0)
begin
-- honorpoint ±î¶َ.
update _TrainingCampMember set HonorPoint = HonorPoint - @OffsetOptionalPoint
where HonorPoint >= @OffsetOptionalPoint and CharID = @PC_ID
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2006
end
--------------------------
--<< 3. ¼ِء¤ ہü ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
-- insert into _ResultOfPackageItemToMappingWithServerSide
-- values (@Operation, @CharID, 252, @OffsetOptionalPoint, 32, 0, 1)
--------------------------
--<< 3. ¼ِء¤ بؤ ؤعµه >> --
--------------------------
-- °شہس ¼*¹ِآت؟،¼* °»½إ ¹ق±â ہ§اط cost °ھہ» °ل°ْ إ×ہج؛ي؟، ³ض¾îµذ´ظ.
insert into _ResultOfPackageItemToMappingWithServerSide
values (@Operation, @CharID, 252, @OffsetOptionalPoint, 32, 0, 1, 0)
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
if (@@ERROR <> 0 or @@ROWCOUNT = 0)
begin
return -2007
end
end
SET NOCOUNT OFF
return 1
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
|
|
|
|
|
01/28/2015, 09:06
|
#13
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
Quote:
Originally Posted by xExorcist
If it doesn't work then,
Code:
SELECT * FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName LIKE '%ITEM_YOUR_ITEM%'
and show us the result |
Just show the result...
|
|
|
|
|
01/30/2015, 22:40
|
#14
|
elite*gold: 0
Join Date: Jun 2013
Posts: 145
Received Thanks: 15
|
now i get more problem when i buy any item from npc like .... egy a staff or any item i get crach and when i open again i find 2 from this item
i must get 1 no i get 2 and crach
|
|
|
|
 |
Similar Threads
|
Small Problem
03/30/2014 - SRO Private Server - 2 Replies
when i buy any item from shopping mall i get dc and error in Sr_GameServer
http://www9.0zz0.com/2014/03/29/13/714676260.png
how to fix?
TwSRO
|
a small problem
07/18/2013 - Rappelz Private Server - 7 Replies
so i went to the help thread and didnt really help that much my problem each time i login i cant make my char and if i mange to make my char and login into it i dont see any graphics i ju see a white space and cant move and thats a pic
the client i use is an AgeOfRappelz i guess its 6.2 i have 32bit and a slow internet So..
the server files(uploaded it if u want to check if it works or anything) :
RappelzServer_2.rar
|
Small Problem !
05/04/2013 - S4 League Hacks, Bots, Cheats & Exploits - 2 Replies
I have 1 x hack (working 100%) and i can enter, play 10 min and after is error:)))
I download xtrap bypass and now when i enter in game is this error:
i will add 1x photo:
http://tinypic.com/r/34nsity/5
I need help:(
My hack is: New Generation 0.3.1
:)
Link for Hack
|
Small problem
05/05/2012 - CO2 Private Server - 2 Replies
Hello, like you can see, if I ever worn any accessory and I want to remove them from character it works just fine, but from another character it shows that its still wearing an accessory on the left hand, the pictures tells you what I mean:
|
Small Problem i think
10/23/2008 - CO2 Private Server - 5 Replies
I got the problem that i cant change enything in some server sources it means
WelcomeMsg
Add enything new...like marriage or something like that....
what i can do to solve it?
thx further
|
All times are GMT +1. The time now is 20:59.
|
|
