Complete 120 Cap + 13D Database Running in Mssql 2005

[kitez]

use this query

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

ok, thx but that will reduce the mob spawn right?

[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

[BlackRoseGaming]

i download the (Complete_120Cap+D13_v6.3) and have this error
some one help me plz

you put data in server fileS?

[skerdikas]

Item mall fix :

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

[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

[skerdikas]

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



Uploaded with ImageShack.us

[intime]

Npc hp mp universal pill

faulty

NPC DEN POT ALAMIYORUM 50 LIK POT VERMIYOR CTRL ILE .COZUMU NEDIR.TEMIZ MPK2 GEREKLI

[grayfox]

you put data in server fileS?

i have ksro data (v1.770)

[BlackRoseGaming]

Server files?

[ahmedelgend]

help help how to fix Item Mail

[skerdikas]

i have ksro data (v1.770)

latest ksro is v1.800 or something
update urs v.1.770

[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?

[serseri1453]

helpmeeeeeeeeeeeeee

open f10 press 'e' shut down gameeeee helpme plsssss statiic...

[Frezze1]

I wonder how manny noobs are here and got Problems. Everything works good on my (Statiic's) db ;)

[skerdikas]

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

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