|
You last visited: Today at 07:04
Advertisement
Item Mall Dc Bug
Discussion on Item Mall Dc Bug within the SRO Private Server forum part of the Silkroad Online category.
10/02/2012, 15:14
|
#1
|
elite*gold: 45
Join Date: Nov 2010
Posts: 411
Received Thanks: 112
|
Item Mall Dc Bug
yo , i had this prob before , but when i made a new server , i got this , last time i fixed it by renaming dbs , but now its not working , wht can i do ?
btw the error is u buy something from item mall u get dc , when u login u find the item in ur inv and the silks are not removed .
|
|
|
10/02/2012, 17:50
|
#2
|
elite*gold: 0
Join Date: Aug 2012
Posts: 570
Received Thanks: 192
|
Make sure to:
Names of dbs/dbconnect.asp
Media+db to be the same
.ini files from certification
Clean db
Bye
|
|
|
10/04/2012, 20:08
|
#3
|
elite*gold: 0
Join Date: Jan 2011
Posts: 293
Received Thanks: 46
|
mm checked everything . still not working , all configs are correct
|
|
|
10/04/2012, 23:45
|
#4
|
elite*gold: 0
Join Date: Aug 2012
Posts: 26
Received Thanks: 5
|
easy fix.. i cant understand why no one can just use the SEARCH BUTTON --> here is the fix..
CHANGE THE RED PART INTO YOUR NEW DB NAME..
If you rlly cant find where this is = shard, stored produced and search for update_cost. ENJOY!
Quote:
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
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
|
|
|
|
10/06/2012, 00:12
|
#5
|
elite*gold: 0
Join Date: Oct 2008
Posts: 58
Received Thanks: 4
|
Quote:
Originally Posted by fantasiaroad
easy fix.. i cant understand why no one can just use the SEARCH BUTTON --> here is the fix..
CHANGE THE RED PART INTO YOUR NEW DB NAME..
If you rlly cant find where this is = shard, stored produced and search for update_cost. ENJOY!
|
Oh, **** .. now I get dc at every time I try to buy any item from the item mall ..
Disconnect message .. not even a crash -.-
|
|
|
09/24/2019, 23:06
|
#6
|
elite*gold: 0
Join Date: Sep 2019
Posts: 12
Received Thanks: 0
|
alguem ajuda com dc da loja item mall ep 6.4?
|
|
|
09/25/2019, 07:07
|
#7
|
elite*gold: 0
Join Date: Jul 2019
Posts: 89
Received Thanks: 22
|
ur problem in _UPDATE_COST change it for another one
|
|
|
10/10/2019, 17:05
|
#8
|
elite*gold: 22
Join Date: Feb 2011
Posts: 612
Received Thanks: 388
|
Quote:
Originally Posted by Desquarede
check your iis dbconnect.asp
Media+db to be the same
check .ini files from certification
|
10/02/2012
is seriously ? or are you spamming
|
|
|
|
Similar Threads
|
Item mall dc
09/22/2013 - Shaiya Private Server - 6 Replies
Moin,
also zurzeit läuft alles super auser die item mall.
Immer wenn ich einen gegenstand kaufen will, bekomme ich ein dc.
Ich habe auch schon das hier versucht:
http://www.elitepvpers.com/forum/shaiya-pserver-de velopment/1030923-mini-guide-fixing-item-mall-cras h-5-minutes.html
und das:
http://www.elitepvpers.com/forum/shaiya/444339-rel ease-fixing-shopmall.html
|
Web Item Mall!
04/01/2012 - Shaiya Private Server - 2 Replies
Hi all, bin auf der suche nach einem web item Mall Script, wen jemand mir helfen kan oder will das wäre sehr nett und hilfreich,danke :)
Hi all, I'm looking for a web item mall script who kan someone help me or wants that would be very nice and helpful, thank you :):handsdown:
|
[REQUEST] Item mall item for 0 silk
12/02/2011 - SRO Private Server - 11 Replies
Hello ,
I am trying to make some item mall items to 0 silk but there is a problem when i put the cost to 0 silk the users can not purchase the items.
Only cost to 1 or more is working ...
Any idea where is the restriction about this ( maybe a stored procedure ? )
Cordialy,
|
ITEM MALL
09/30/2011 - SRO Private Server - 5 Replies
i need item mall where add avatars ?
|
Cannot buy item at mall
02/06/2011 - EO PServer Hosting - 19 Replies
I've added 4 summonstone to the mall ... buy i cannot buy it from there . why ? anything that i missing to edit ?:(
|
All times are GMT +2. The time now is 07:04.
|
|