[RELEASE] Upgrade System

[Syloxx]

Procedure:

/**
version : 1
author : syloxx
created date : 2015-03-23
description : upgrade your items.
return value :
0 = There is no error.
-1 = The transaction is in an uncommittable state. Rolling back transaction.
-2 = Slot 13 is emptry.
-3 = Item in slot 13 is not in upgrade table.
**/

CREATE PROCEDURE dbo._UpgradeItem
      @CharID int
    , @Scroll varchar(129)
AS
SET NOCOUNT ON;
SET XACT_ABORT ON;

DECLARE @ReturnValue int
    , @ItemID bigint
    , @BeforeRefID int
    , @BeforeOptLevel tinyint
    , @UpgradeRefID int
    , @UpgradeOptLevel tinyint;

IF XACT_STATE() = -1
BEGIN
    SET @ReturnValue = -1;
    GOTO ErrorHandler;
END

BEGIN TRY
    /**_# Get ItemID of item in slot 13.*/
    SELECT @ItemID = ItemID
    FROM dbo._Inventory WITH (NOLOCK)
    WHERE CharID = @CharID
    AND Slot = 13;

    /**_# Check if slot 13 is empty.*/
    IF @ItemID IS NULL OR @ItemID = 0
    BEGIN
        SET @ReturnValue = -2;
        GOTO ErrorHandler;
    END

    /**_# Get RefID and OptLevel of item in slot 13.*/
    SELECT @BeforeRefID = RefItemID
        , @BeforeOptLevel = OptLevel
    FROM dbo._Items WITH (NOLOCK)
    WHERE ID64 = @ItemID;

    /**_# Get all required informations to upgrade the item.*/
    SELECT TOP 1 @UpgradeRefID = UpgradeRefID
        , @UpgradeOptLevel = UpgradeOptLevel
    FROM _RefUpgradeConfig WITH (NOLOCK)
    WHERE Service = 1
    AND BeforeRefID = @BeforeRefID
    AND BeforeOptLevel <= @BeforeOptLevel
    ORDER BY BeforeOptLevel DESC;

    /**_# Check if item in slot 13 exsits in upgrade table.*/
    IF @UpgradeRefID IS NULL OR @UpgradeRefID = 0
    BEGIN
        SET @ReturnValue = -3;
        GOTO ErrorHandler;
    END

    BEGIN TRANSACTION;

    /**_# Upgrade your item.*/
    UPDATE _Items
    SET RefItemID = @UpgradeRefID
        , OptLevel = @UpgradeOptLevel
    WHERE ID64 = @ItemID;

    COMMIT TRANSACTION;
END TRY
BEGIN CATCH
    GOTO ErrorHandler;
END CATCH;

RETURN 0;

ErrorHandler:
IF XACT_STATE() <> 0
    ROLLBACK TRANSACTION;

DECLARE @CharName varchar(16);

SELECT @CharName = CharName16
FROM _Char WITH (NOLOCK)
WHERE CharID = @CharID;

EXEC _ADD_ITEM_EXTERN @CharName, @Scroll, 1, 0;

RETURN @ReturnValue;

Table:

CREATE TABLE _RefUpgradeConfig
(
  Service bit NOT NULL
, BeforeRefID int NOT NULL
, BeforeOptLevel tinyint NOT NULL
, UpgradeRefID int NOT NULL
, UpgradeOptLevel tinyint NOT NULL
);

i didn't tested this system so if something is wrong please lemme know.

TUTORIAL
you have to config the upgrade system first.
means you have to insert stuff in the _RefUpgradeConfig table in following format:

Service, BeforeRefID (olditem), BeforeOptLevel (required plus), UpgradeRefID (new item), UpgradeOptLevel (new plus)

the rest should be self explain

[DeaDeployment]

tkz men pt wh pen en azs sw mne

[CrystalCoder]

Great Job Syloxx

[DeaDeployment]

Hacker

[Syloxx]

Originally Posted by Exo

Don't use Codes or ObjCommon for such stuff. Just don't!

why? its a one time use and only _RefObjCommon know the CodeName?

[Aaron*]

Originally Posted by Exo

dafuq, that was a query to fill yo ur table my bad then..

Read the query before you post..

[_Miss_AngeL_]

Originally Posted by Exo

dafuq, that was a query to fill yo ur table my bad then..

hahahaha. can you tell me who explained for you that this query will fill the table and it's not a procedure for upgrade ?
don't try to lie. i knew that you don't have any idea about sql coding.

[Crue*]

Originally Posted by Exo

We're talking about the procedure Aeron posted

btw, do I know you? I never saw you or heard about you before, can you stop acting like if you know me?

know you ? who are you i didn't hear about you also lel

[Eslam Galull]

why every dam thread turning to a fight thread .. can you calm down ppl !! #Please !!

[AhmedKasin]

one thing to say i like your work good luck in that you do and we wait for you all new..

[terawly]

Great Job Syloxx

[X-Vortex]

Nice

[TheRunner]

useful thanks bro

[raptter]

added procedure succ + config table and i fill it with items codes + OPT level
now could anyone tell me how to use it to upgrade my weapons anyone answer please cuze i don't know how to do it

[Syloxx]

place the item you wanna uprade on slot 13 (1 in inventory).
Execute the procedure (can be executed by a scroll aswell).
Teleport!

I won't explain you how to execute this procedure by scroll.