Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
ahmed_ahmed9889
use this query
PHP Code:
update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 5 and dwMaxTotalCount <= 10
update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 10 and dwMaxTotalCount <= 15
update Tab_RefNest Set dwMaxTotalCount = 4 where dwMaxTotalCount >= 15
by kanift
and wait for items mall fix :ott1:
ok, thx but that will reduce the mob spawn right?
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
grayfox
game server close in (load real region : 90%) when i Enable JUPITER in _RefRegionBindAssocServer
but when i Disable JUPITER game server work fine
and this is my _RefRegionBindAssocServer
CHINA 1
TQ 1
West_China 1
Oasis_Kingdom 1
Thief Village 1
Roc 1
Eu 1
Am 1
Ca 1
SD 1
KingsValley 1
Pharaoh 1
DELTA 1
TEMPLE 1
FORT_JA_AREA 1
FORT_DW_AREA 1
FORT_HT_AREA 1
FORT_CT_AREA 1
FORT_SK_AREA 1
FORT_BJ_AREA 1
FORT_HM_AREA 1
FORT_ER_AREA 1
ARENA_OCCUPY 0
ARENA_FLAG 0
ARENA_SCORE 0
SIEGE_DUNGEON 0
ARENA_GNGWC 0
GOD_TOGUI 0
GOD_WRECK_IN 0
GOD_FLAME 0
GOD_WRECK_OUT 0
EVENT_GHOST 0
JUPITER 1
PRISON 0
GM_EVENT 0
help plz
i download the (Complete_120Cap+D13_v6.3) and have this error
some one help me plz
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
grayfox
i download the (Complete_120Cap+D13_v6.3) and have this error
some one help me plz
you put data in server fileS?
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
kanift
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
alright and doe's this fix it? gonna give a try with it b4 that ill gonna make back up of my db :P Query doesnt fix anything well if u run on 2 machine's it will be ok anyway
and its for grayfox u cant run Jupiter on 1st machine u have 2 run it on 2nd pc/machine
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Please AnyOne Help me I Installed Database V6.2 And Now When I Go lvl Up With /zoe MOB_RM_ROC 1 I Go To Lvl 140 :( i Changed The Sr_gameserver about 5 times and same happens PLEASE HELP
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
ahmedov
Please AnyOne Help me I Installed Database V6.2 And Now When I Go lvl Up With /zoe MOB_RM_ROC 1 I Go To Lvl 140 :( i Changed The Sr_gameserver about 5 times and same happens PLEASE HELP
exp rate is too hight in server.cfg make it like 100x or something
rofl
http://img196.imageshack.us/img196/8...0219322198.jpg
Uploaded with ImageShack.us
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Npc hp mp universal pill
faulty
NPC DEN POT ALAMIYORUM 50 LIK POT VERMIYOR CTRL ILE .COZUMU NEDIR.TEMIZ MPK2 GEREKLI
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
PlayCreeDSRO
you put data in server fileS?
i have ksro data (v1.770)
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
help help how to fix Item Mail
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
grayfox
i have ksro data (v1.770)
latest ksro is v1.800 or something
update urs v.1.770
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Does someone have the KSRO Client Link to download?
or know how to fix item mall bug, dc when try to buy anything?
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
helpmeeeeeeeeeeeeee
open f10 press 'e' shut down gameeeee helpme plsssss statiic...
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
I wonder how manny noobs are here and got Problems. Everything works good on my (Statiic's) db ;)
Re: [Release] Complete 120 Cap + 13D Database Running in Mssql 2005
Quote:
Originally Posted by
Frezze1
I wonder how manny noobs are here and got Problems. Everything works good on my (Statiic's) db ;)
many noobs have problems i had 2 but with mall stuff easy fix is run all areas wich are in client towns jupiter etc on 2 machine's and u wont have any problems this db was made for 1 machine's or more not for one ppl who know how run server but not fix server expect i download restore db's and all will run w/o problems and
to run any server even fixed one u need 2 know how fix edit stuff in db side and pk u dont know how do stuff like dont even download any db's no one will tell u or u even wont understan what ppl will tell u 2 do so if u have problems with db v6.3 ill give u advice
go to control panel find remove/add programs remove all sql stuff and delete all server files and db's u are player not server developer like some ppl here :cool:
Quote:
Originally Posted by
I_Satelite_I
Does someone have the KSRO Client Link to download?
or know how to fix item mall bug, dc when try to buy anything?
JOYMAX.COM - Global Hub of Fun :: Silkroad Online
