Scroll to Upgrade +1 Weapon per 30 Minutes

[MGProjects]

RefObjCommon

1    43602    ITEM_MALL_UPGRAD_UP    ???? ???? ??? (???)    xxx    SN_ITEM_MALL_UPGRAD_UP    SN_ITEM_MALL_UPGRAD_UP_TT_DESC    1    0    3    3    13    14    180000    3    0    1    1    1    255    0    1    0    0    129    0    0    0    0    0    0    0    -1    0    -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    Premium\etc\upgradeup.ddj    xxx    xxx    22002 

RefObjItem

22002    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    1000    ????(?)    1    [USU1:SKILL_MALL_UPGRAD_UP]                                                                                                          1000    ????(?)    1    [USU1:SKILL_MALL_UPGRAD_DOWN]                                                                                                        -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

1    34001    1013    SKILL_MALL_UPGRAD_UP    ???? ????    SKILL_MALL_UPGRAD_UP    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\mall_optlevel_upgrade_scroll_1.ddj    SN_SKILL_MALL_UPGRAD_UP    xxx    SN_SKILL_MALL_UPGRAD_UP_TT_DESC    xxx    0    0    3    1667396966    1851946342    1685418593    1500    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
1    34002    1013    SKILL_MALL_UPGRAD_DOWN    ???? ????    SKILL_MALL_UPGRAD_DOWN    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\mall_optlevel_upgrade_scroll_1.ddj    SN_SKILL_MALL_UPGRAD_DOWN    xxx    SN_SKILL_MALL_UPGRAD_DOWN_TT_DESC    xxx    0    0    3    1667396966    1851946342    1685418593    120000    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

                  if(@JobID = '34001') -- Upgrade Weapon adicionar

      if(@JobID = '34002') -- Upgrade Weapon remover
        begin
declare @ItemID int
declare @RefItemID int
declare @OptLevel int
DECLARE @DataAtual DATETIME
DECLARE @DataAtual2 DATETIME
SET @DataAtual = DATEADD(MINUTE,3,getdate())
SET @DataAtual2 = DATEADD(MINUTE,0,getdate())
                        SELECT @ItemID=ItemID from _Inventory where CharID = @CharID AND Slot = '13'
                        SELECT @OptLevel=OptLevel from _Items where ID64 = @ItemID
                        SELECT @RefItemID=RefItemID from _Items where ID64 = @ItemID
                        insert into _RegistationUpgradeItem(CharID,ItemID,TimeStar,TimeFin) values(@CharID, @ItemID, @DataAtual2,@DataAtual)
                         If (@RefItemID >='71' AND @RefItemID <='1906')
                          begin
                         insert into _RegistationUpgradeItem(CharID,ItemID,TimeStar,TimeFin) values(@CharID, @ItemID, @DataAtual2,@DataAtual)
                        UPDATE _Items Set OptLevel = @OptLevel +1 where ID64 = @ItemID
                        end
                        Else
                       If (@RefItemID >='3632' AND @RefItemID <='5849')
                         begin
                        insert into _RegistationUpgradeItem(CharID,ItemID,TimeStar,TimeFin) values(@CharID, @ItemID, @DataAtual2,@DataAtual)
                       UPDATE _Items Set OptLevel = @OptLevel +1 where ID64 = @ItemID
                      end
                        Else
                        If (@RefItemID >='19687' AND @RefItemID <='19716')
                          begin
                         insert into _RegistationUpgradeItem(CharID,ItemID,TimeStar,TimeFin) values(@CharID, @ItemID, @DataAtual2,@DataAtual)
                        UPDATE _Items Set OptLevel = @OptLevel +1 where ID64 = @ItemID
                       end
                        Else
                        If (@RefItemID >='24176' AND @RefItemID <='24686')
                          begin
                         insert into _RegistationUpgradeItem(CharID,ItemID,TimeStar,TimeFin) values(@CharID, @ItemID, @DataAtual2,@DataAtual)
                        UPDATE _Items Set OptLevel = @OptLevel +1 where ID64 = @ItemID
                       end
                        Else
                        If (@RefItemID >='25423' AND @RefItemID <='25726')
                          begin
                         insert into _RegistationUpgradeItem(CharID,ItemID,TimeStar,TimeFin) values(@CharID, @ItemID, @DataAtual2,@DataAtual)
                        UPDATE _Items Set OptLevel = @OptLevel +1 where ID64 = @ItemID
                       end
                        Else
                        If (@RefItemID >='10887' AND @RefItemID <='14874')
                          begin
                         insert into _RegistationUpgradeItem(CharID,ItemID,TimeStar,TimeFin) values(@CharID, @ItemID, @DataAtual2,@DataAtual)
                        UPDATE _Items Set OptLevel = @OptLevel +1 where ID64 = @ItemID
                       end
                        Else
                        If (@RefItemID >='23372' AND @RefItemID <='24259')
                          begin
                         insert into _RegistationUpgradeItem(CharID,ItemID,TimeStar,TimeFin) values(@CharID, @ItemID, @DataAtual2,@DataAtual)
                        UPDATE _Items Set OptLevel = @OptLevel +1 where ID64 = @ItemID
                       end
                        Else
                        If (@RefItemID >='25432' AND @RefItemID <='25798')
                          begin
                         insert into _RegistationUpgradeItem(CharID,ItemID,TimeStar,TimeFin) values(@CharID, @ItemID, @DataAtual2,@DataAtual)
                        UPDATE _Items Set OptLevel = @OptLevel +1 where ID64 = @ItemID
                       end
            return -3
        end 

[MentaL]

[lemoniscool]

does this work on vsro v1.188 servers? because i do not have the _RegistrationUpgradeItem table in my db ..

[thundersky]

Where Files Media.Pk2 ?

[Caosfox]

i think that table is not really needed. in fact looks like only adds a +1, i dont see any code to remove it later

[Bocc]

where is _RegistationUpgradeItem

[ilowe]

yes _RegistationUpgradeItem where ?

[Madelyn]

@MGProjects do 2 tables:
1º for Items that can be Upgraded in list by ID.
2º For the items that are upgradedand with time begin and time ends (if @timeend = @eventtime
begin

check if my item can be upgraded
insert and update my item.
when getdate()= datetime
delete my plus
(if is a scroll that need teleported the player will have +1 all day or when is dced.)

(rename the scroll to upgrade +1 to when logout, if this guy have bad lucky will lose the item by be dced xD)

end)

the query is longer and not see noting compact.

[bestprem]

http://goo.gl/b5zKZa it's working