New Upgrade System Vsro S4A

[Power Road]

niceeeeeeeeeeeeeeeeeeee

[StayAlive-Online]

this code you can use it with any thing in game to change x item to y item with option or not

i thing this is good idea to make some special change in your server

[ahmed4ever2u]

lol . ?
NetWork you know that i'm going to **** you so hard.

[Timlock]

Not to be picky... but this piece of code could have potentially horrible side effects on your server especially considering you dont even remove the old item completely, just un-link it from the characters inventory. Also, you have it coded to only work with 14th degree blade and no indication on how to modify that... whether it should convert all inventory items +7 to the next degree or only the ones you choose. You also did not take into account an inventory that is full or if the items are equiped, again more potential bugs and/or lost items.

[StayAlive-Online]

Originally Posted by ahmed4ever2u

lol . ?
NetWork you know that i'm going to **** you so hard.

r u talk yo me ?

[SupremeSRO]

so this is working ?..

[Timlock]

Originally Posted by SupremeSRO

so this is working ?..

its not a complete system, just part of one... a very small part, which only works with 14d blade...

[StayAlive-Online]

Originally Posted by Timlock

its not a complete system, just part of one... a very small part, which only works with 14d blade...

bro here i made 1 code to d14 but you can change it to any D with any +

[focus2525]

not work for me i want guide

[Yousefayyoub]

okay i can do the degree change side ( i mean change the code for the degree i want)
but please can you provide us with the scroll code, am a sort of new in the SQL/Pk2 editing ... so if you please help me

[hancook1st]

when make this code this happen what this

Msg 137, Level 15, State 1, Procedure _AddTimedJob, Line 61
Must declare the scalar variable "@CharName16".
Msg 137, Level 15, State 2, Procedure _AddTimedJob, Line 62
Must declare the scalar variable "@CharName16".

[Syloxx]

PHP Code:

 if (@JobID = SKILL_ID)
    BEGIN
        DECLARE @OldItemCodeName VARCHAR(128) = 'ITEM_EU_TSWORD_14_B_RARE',
                @OldItemPlus INT = 7,
                @NewItemCodeName VARCHAR(128) = 'ITEM_EU_TSWORD_15_A_RARE',
                @NewItemPlus INT = 0,
                @ReplaceID INT,
                @CharName16 VARCHAR(16)

        SELECT @ReplaceID = TOP 1 ItemID FROM _Inventory IV
        INNER JOIN _Items I
        ON I.ID64 = IV.ItemID
        INNER JOIN _RefObjCommon ROC
        ON ROC.ID = I.RefItemID
        WHERE IV.CharID=CharID AND ROC.CodeName128=@OldItemCodeName AND I.OptLevel = @OldItemPlus

        SELECT @CharName16 = FROM _Char WHERE CharID = @CharID

        IF (@ReplaceID IS NOT NULL)
        BEGIN
            UPDATE _Inventory SET ItemID = 0 WHERE ItemID = @ReplaceID AND CharID = @CharID
            EXEC _ADD_ITEM_EXTERN @CharName16 , @NewItemCodeName , 1 , @NewItemPlus
        RETURN -3
        END
    END 


fixed and rewrote it but I dont recommend it

Want a better and full version? just pm me, then we can negotiate the price

[Eslam Galull]

did you ever test this before release ! ?

[clbgms]

Msg 137, Level 15, State 2, Procedure _AddTimedJob, Line 67
Must declare the scalar variable "@olditemCodeName".
Msg 137, Level 15, State 1, Procedure _AddTimedJob, Line 71
Must declare the scalar variable "@CharName16".
Msg 137, Level 15, State 2, Procedure _AddTimedJob, Line 72
Must declare the scalar variable "@CharName16".
help me pls