Scroll gift coin for ItemMall

RefObjCommon

PHP Code:

---

1    43615    ITEM_MALL_GIFTCOINS_50    ???? ????    xxx    SN_ITEM_MALL_GIFTCOINS_50    SN_ITEM_MALL_GIFTCOINS_50_TT_DESC    0    0    3    3    13    1    180000    3    0    1    1    1    255    3    1    0    0    1    0    0    0    0    0    0    1    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_ch_eventbox.bsr    item\etc\giftcoins_50.ddj    xxx    xxx    22015 


---

RefObjItem

PHP Code:

---

22015    1    2    0    0    1    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    0    SKILL_MALL_GIFTCOINS_50    -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    -1    xxx    -1    xxx    0    0    0 


---

RefSkill

PHP Code:

---

1    34020    1011    SKILL_MALL_GIFTCOINS_50    ???? ????    SKILL_MALL_GIFTCOINS_50    0    1    1    0    0    0    0    0    1000    0    0    0    3599    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    3    0    0    255    255    0    0    0    0    0    255    255    255    255    item\etc\giftcoins_50.ddj    SN_ITEM_MALL_GIFTCOINS_50    xxx    SN_ITEM_MALL_GIFTCOINS_50_TT_DESC    xxx    0    0    3    1667396966    1851946342    1685418593    6000    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 


---

Procedure

_TimedJob

PHP Code:

---

 if(@JobID= '34020')
        begin
            EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @NewUserID, @PkgID = NULL, @NumSilk = 50, @Price = NULL
            set @NewJobID = @@identity
            return @NewJobID
        end 


---

Msg 137, Level 15, State 2, Procedure _AddTimedJob, Line 77
Must declare the scalar variable "@NewUserID".
error plzz help us to do this

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@JobID".
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@NewUserID".
Msg 137, Level 15, State 1, Line 4
Must declare the scalar variable "@NewJobID".
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@NewJobID".
>.<

NOt understand what u say ... Scroll Gift for ?

Quote:

---

Originally Posted by SuperHer0

NOt understand what u say ... Scroll Gift for ?

---

Coin= silk

anyone have test it works ?

Did not work for me. Try several times and nothing so far. -.-

i have error Say ;Must declare the scalar variable "@NewUserID"; How to fix this ?