You last visited: Today at 12:39
Advertisement
[VSRO] HOW TO FIX ITEM MALL CRASH ??
Discussion on [VSRO] HOW TO FIX ITEM MALL CRASH ?? within the SRO Private Server forum part of the Silkroad Online category.
03/28/2012, 06:29
#1
elite*gold: 0
Join Date: May 2008
Posts: 167
Received Thanks: 2
[VSRO] HOW TO FIX ITEM MALL CRASH ??
how to fix the item mall crash ?
when i want to buy anything from item mall i get dc'ed when i press Buy putton
i made sure of the ODBC , DB Connect and ini Certificate folder
they all have the same name of account db
if someone knows whats wrong please share
03/28/2012, 09:32
#2
elite*gold: 0
Join Date: Jun 2011
Posts: 802
Received Thanks: 396
try this query :
Code:
Item mall fix :
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_UPDATE_COST] Script Date: 02/02/2012 16:10:45 ******/
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¿¡ µû¶ó¼* À¯Àú ij¸¯ÅÍ ¾ÆÀ̵𰡠³Ñ¾î ¿Ã¼öµµ ÀÖ°í, cos ¾ÆÀ̵𰡠³Ñ¾î ¿Ã ¼öµµ ÀÖ´Ù.
-- ij¸¯ÅÍ ¾ÆÀ̵𸦠¾î¶´ø ¾Ë¾Æ³»¾ß ÇÏ°Ú´Ù.
----------------------------------------------------------
if (@Operation = 19)
begin
-- COS ¿ë ¹°Ç°À» ±¸ÀÔÇѰŴϱñ... ij¸¯ ã¾Æ¼* µ· »©Áà¾ßÁö...
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 & (2 | 4 | 16 )) > 0)
begin
-- ½ÇÅ©, ¼±¹°½ÇÅ©, ¸¶Àϸ®Áö¸¦ ±î¾ß Çϴ±¸¸¸.
-- ´Ü, ¸¶Àϸ®Áö´Â ¿É¼ÇÀÌ´Ù.
-- ij¸¯ÅÍÀÇ 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 & 8) > 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
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Close GameServer and use this query and open service SR_GameServer
If the query doesn't help the problem is from ODBC or DBConnect.asp
Check again ODBC and DBConnect.asp
03/28/2012, 10:23
#3
elite*gold: 0
Join Date: May 2008
Posts: 167
Received Thanks: 2
Quote:
Originally Posted by
H34D_B4NG3R
try this query :
Code:
Item mall fix :
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_UPDATE_COST] Script Date: 02/02/2012 16:10:45 ******/
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¿¡ µû¶ó¼* À¯Àú ij¸¯ÅÍ ¾ÆÀ̵𰡠³Ñ¾î ¿Ã¼öµµ ÀÖ°í, cos ¾ÆÀ̵𰡠³Ñ¾î ¿Ã ¼öµµ ÀÖ´Ù.
-- ij¸¯ÅÍ ¾ÆÀ̵𸦠¾î¶´ø ¾Ë¾Æ³»¾ß ÇÏ°Ú´Ù.
----------------------------------------------------------
if (@Operation = 19)
begin
-- COS ¿ë ¹°Ç°À» ±¸ÀÔÇѰŴϱñ... ij¸¯ ã¾Æ¼* µ· »©Áà¾ßÁö...
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 & (2 | 4 | 16 )) > 0)
begin
-- ½ÇÅ©, ¼±¹°½ÇÅ©, ¸¶Àϸ®Áö¸¦ ±î¾ß Çϴ±¸¸¸.
-- ´Ü, ¸¶Àϸ®Áö´Â ¿É¼ÇÀÌ´Ù.
-- ij¸¯ÅÍÀÇ 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 & 8) > 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
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Close GameServer and use this query and open service SR_GameServer
If the query doesn't help the problem is from ODBC or DBConnect.asp
Check again ODBC and DBConnect.asp
GRRRRRRRR
still have the same problem
is it required SQL 2005 only
im using 2008..
or just im wrong setting it up ?
could u help me through teamviewer ?
ill be glad , if u dont mind =D
03/28/2012, 18:57
#4
elite*gold: 0
Join Date: Jun 2011
Posts: 802
Received Thanks: 396
Pm me i'll try to help you through teamviewer
08/10/2012, 08:58
#5
elite*gold: 0
Join Date: Apr 2008
Posts: 154
Received Thanks: 13
Quote:
Originally Posted by
H34D_B4NG3R
Pm me i'll try to help you through teamviewer
can u help me too i have this Problem ???
[VSRO] Item Mall (Avatar)
05/27/2013 - SRO Private Server - 15 Replies
Hey guys,
i tried to add all avatar in the Item Mall, i found a Guide which said i must change in refpackageitem the saletag to 0 in the media.pk2 and in SRO_VT_SHARD so no problem i changed it without any problems.
So when i login and open the Item Mall and click on Dresses i only see this:
http://img80.imageshack.us/img80/3491/sro20120122 01551647.jpg
in Hat is nothing
there must be Dresses and Attachment too or?
what is wrong?
VSRO ITEM MALL NO IMAGE HELP!!
10/22/2011 - SRO Private Server - 3 Replies
NEED A LITTLE HELP FRIENDS
http://img69.imageshack.us/img69/5537/sadlha.png
http://img695.imageshack.us/img695/2520/sro201110 2122260788.jpg
WHY HELP:handsdown:
[vSRO] Item Mall
10/09/2011 - SRO Private Server - 5 Replies
How can I change the price of the items of item mall in media.pk2?
Class 1 Item mall Crash Help PLz
09/19/2011 - SRO Private Server - 2 Replies
iv been getting this crash for the last 2 days know GM dont help-----------Iv re-installed the client have done system restore and re installed windows 7 and still getting the stupid item mall crash cant click on buy or i get crash can some one help me out i have 600silk on account and cant use it....? do i have to make charge back or what??
All times are GMT +2. The time now is 12:41 .
![[VSRO] HOW TO FIX ITEM MALL CRASH ??](https://www.elitepvpers.com/forum/iconimages/sro-private-server/vsro-how-fix-item-mall-crash_ltr.gif){kind=small}
