[Release]Lottery Gold

Results 1 to 4 of 4
  1. #1
    Member bestprem is offline
    MemberRank
    Jul 2012 Join Date
    Hurghada, EgyptLocation
    94Posts

    [Release]Lottery Gold

    #Random Gold Scroll By Kiro!!

    Download

    #*Media Section*

    #itemdata_50000 .txt
    Code:
    1	180295	ITEM_KIRO_RANDOM_GOLD	???? ???? ??? (???)	xxx	SN_ITEM_KIRO_RANDOM_GOLD	SN_ITEM_KIRO_RANDOM_GOLD_TT_DESC	1	0	3	3	3	1	180000	3	2	0	1	0	3	0	1	0	0	129	0	0	0	0	0	0	0	1	1	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	comatose\uniq_point_scroll.ddj	xxx	xxx	1	2	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1500	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
    #textdata_object .txt
    Code:
    1	SN_ITEM_KIRO_RANDOM_GOLD								Gold Lottery(Kiro)
    1	SN_ITEM_KIRO_RANDOM_GOLD_TT_DESC								Gold Lottery(Kiro)

    #*Database Section*

    #Tables

    #_RefObjCommon
    Code:
    1	180295	ITEM_KIRO_RANDOM_GOLD	???? ???? ??? (???)	xxx	SN_ITEM_KIRO_RANDOM_GOLD	SN_ITEM_KIRO_RANDOM_GOLD_TT_DESC	1	0	3	3	3	1	180000	3	2	0	1	0	3	0	1	0	0	129	0	0	0	0	0	0	0	1	1	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	comatose\uniq_point_scroll.ddj	xxx	xxx 99999
    #_RefObjItem
    Code:
    99999	1	2	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1500	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
    #Procedures
    SRO_VT_SHARDLOG >>>> [_AddLogItem]

    add that query at Addlogitem

    Code:
    IF (@Operation = 41) -- If item used!
    BEGIN
        IF (@ItemRefID = 180295) -- RefObjCommon ID (Scroll) (By Kiro)
        BEGIN
        declare    @Charname varchar(128)
    declare    @Upper_kiro int = '100000000' declare    @Lower_kiro int = '10000000'
     declare    @random_kiro int = ROUND((    @Upper_kiro -    @Lower_kiro -1) * RAND() +    @Lower_kiro), 0)
     set    @Charname = (select CharName16  from sro_vt_shard.dbo._Char where CharID    @CharID)
    Update SRO_VT_SHARD.dbo._Char set RemainGold = RemainGold +    @random_kiro  where CharName16 =    @Charname      
    end
    end
    Thx to Serag and Sa3id


  2. #2
    Xeulin™ Showtek is offline
    MemberRank
    Nov 2011 Join Date
    UKLocation
    264Posts

    Re: [Release]Lottery Gold

    Errors:
    Code:
    Msg 189, Level 15, State 1, Procedure _AddLogItem, Line 52
    The round function requires 2 to 3 arguments.
    Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 53
    Incorrect syntax near '@CharID'.
    Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 54
    Must declare the scalar variable "@random_kiro".

  3. #3
    Proficient Member lewy1000 is offline
    MemberRank
    Apr 2008 Join Date
    P(r)olandLocation
    150Posts

    Re: [Release]Lottery Gold

    After TP i dont get gold :(
    Code:
     IF (@ItemRefID = 180295) -- RefObjCommon ID (Scroll) (By Kiro)
    BEGIN
    declare @Charname varchar(128)
    declare @Upper_kiro int 
    SET @Upper_kiro = '100000000' 
    declare @Lower_kiro int 
    SET @Lower_kiro = '1000000'
    declare @random_kiro int 
    SET @random_kiro = ROUND(( @Upper_kiro - @Lower_kiro -1) * RAND() + @Lower_kiro), 0)
    set @Charname = (select CharName16  from sro_vt_shard_init.dbo._Char where CharID = @CharID)
    Update SRO_VT_SHARD_INIT.dbo._Char set RemainGold = RemainGold + @random_kiro  where CharName16 = @Charname      
    end

  4. #4
    Apprentice che9299 is offline
    MemberRank
    Mar 2014 Join Date
    8Posts

    Re: [Release]Lottery Gold

    Old but ty



Advertisement