[Release] Upgrade Scroll/Message

Exo · 09/04/2014, 02:13

Since everyone acted like a pro.. and started commenting on the old ****..here's the Ready To Use Lines...
Simply this **** will get the RefID Of the items and compare them to a table if the ID exists it will change it to another one..
Table name in this example is Upgrade columns Are Req/Up

Code:

--Upgrade By #Khaled# --
DECLARE  @WepRefID INT,
         @ArenaRefID INT,
         @OptLevel INT,
         @Data INT,
         @UP INT,
         @WepRefID2 INT
         
         
         
         
         SELECT @WepRefID = I.RefItemID
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=13
         
         SELECT @WepRefID2 = I.ID64
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=13
         
         
         SELECT @ArenaRefID = I.RefItemID
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=15
         
         SELECT @OptLevel = I.OptLevel
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=13
         
         SELECT @Data = I.Data
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON Inv.ItemID = I.ID64
         WHERE CharID = @CharID AND Inv.Slot=15
         
         SET @UP = (SELECT UP FROM Upgrade Where Req =@WepRefID)

IF EXISTS (SELECT * FROM SRO_VT_SHARD..Upgrade WHERE Req =@WepRefID)
BEGIN
If ( @OptLevel =8 And @Gold >=50000000000 AND @ArenaRefID='25834' AND @Data>=100)--Staff
BEGIN
UPDATE _Items SET RefItemID = @Up ,OptLevel=0 WHERE ID64=@WepRefID2
UPDATE _Char SET RemainGold =RemainGold-50000000000 WHERE CharID=@CharID
EXEC SRO_VT_SHARD.._STRG_DEL_ITEM_NoTX 1,@CharID,15
END
END

Edit this to match how you will use it.. but i guess you got the point..

Syloxx · 09/04/2014, 08:45

Hints:

-custom table
-TIDs

this query is a pain

and btw this is an better version of your variables:

PHP Code:



DECLARE @Arena        INT,  
        @RefID        INT,  
        @Data         INT,  
        @Opt          INT  
          
        SELECT        @RefID = I.RefItemID,  
                      @Opt = I.OptLevel  
        FROM          _Inventory INV  
        INNER JOIN    _Items I  
        ON            INV.ItemID = I.ID64  
        WHERE         INV.CharID = @CharID  
        AND           INV.Slot = 13  
          
        SELECT        @Arena = I.RefItemID,  
                      @Data = I.Data  
        FROM          _Inventory INV  
        INNER JOIN    _Items I  
        ON            INV.ItemID = I.ID64  
        WHERE         INV.CharID = @CharID  
        AND           INV.Slot = 14

@CharID will be declared / set by the procedure

anyway at least u used else if

btw, if someone wanna buy some professional queries / procedures let me know

IceAmStiel · 09/04/2014, 10:33

If it's a teleport scroll you intend to use for it:

Use the scroll -> cancel the scroll -> drop one gold -> teleport -> the 50B weren't removed

Also, please don't delete the entry from _Inventory unless you're sure that your players won't mind the disconnects occuring whenever an item is being put into their second inventory slot

EDIT: Did you test this query? You'd normally encounter a foreign key violation by trying to delete an _Items entry that still exists at _ItemPool.

(You should use _STRG_DEL_ITEM_NoTX or an equivalent procedure)

Syloxx · 09/04/2014, 12:21

@IceAmStiel

how can you read this, I stoped after I have seen 3x IF clauses

about the scroll, if u set the Param1 = 0 u wont have this problem

anyway you are correct, rows from _Items can only be removed if the ID64 isnt existing in _Inventory and _ItemPool

@xExorcist

i didnt read your query but IceAmStiel is right

NEVER Delete something from _Inventory if u wanna remove a item you have to update the ItemID = 0

after u did that u dont have to remove the item from _Items everything is what you can still make is set item on unused in _ItemPool

just ask me how u came to the idea to release this

Exo · 09/04/2014, 13:59

Quote:

Originally Posted by IceAmStiel

If it's a teleport scroll you intend to use for it:

Use the scroll -> cancel the scroll -> drop one gold -> teleport -> the 50B weren't removed

Also, please don't delete the entry from _Inventory unless you're sure that your players won't mind the disconnects occuring whenever an item is being put into their second inventory slot

EDIT: Did you test this query? You'd normally encounter a foreign key violation by trying to delete an _Items entry that still exists at _ItemPool.

(You should use _STRG_DEL_ITEM_NoTX or an equivalent procedure)

you don't have to say everything...it was meant to be a hint to how it should work ...

Syloxx · 09/04/2014, 14:03

Quote:

Originally Posted by xExorcist

you don't have to say everything...it was meant to be a hint to how it should work ...

a hint? this query is completely useless what is the hint for the people here

how to use IF clauses ?

Exo · 09/04/2014, 14:06

Quote:

Originally Posted by IceAmStiel

If it's a teleport scroll you intend to use for it:

Use the scroll -> cancel the scroll -> drop one gold -> teleport -> the 50B weren't removed

Also, please don't delete the entry from _Inventory unless you're sure that your players won't mind the disconnects occuring whenever an item is being put into their second inventory slot

EDIT: Did you test this query? You'd normally encounter a foreign key violation by trying to delete an _Items entry that still exists at _ItemPool.

(You should use _STRG_DEL_ITEM_NoTX or an equivalent procedure)

Quote:

Originally Posted by Syloxx

a hint? this query is completely useless what is the hint for the people here

how to use IF clauses ?

Lets count how many member here know how this shit works..
40? it's for learning purposes.
Never said it's a ready to use query it was old so i though about sharing since lot of ppl asked for it
And lets face it it's better sharing something that maybe is useless for you but useful for others than not sharing anything...(you simply sell work you don't give anything for this community and ye you can judge if i had a title like "KRALL RELEASE Or shit its just a simple old stuff for learning purposes)

Syloxx · 09/04/2014, 14:40

[Release] Upgrade Scroll/Message

means a ready 2 use query and btw

IceAmStiel · 09/04/2014, 14:45

**** I was just trying to help, apologies ;D
(I'm 100% sure that you weren't aware of the flaws)

And how is this supposed to be something to learn from? You're using improperly choosen datatypes that should actually be based on the table columns you're referencing; you're querying tables more often than necessarily needed and you're using questionable implicit conversions which can lead to a huge performance impact for certain datatypes regarding indexes - let's not talk about readability.
Not to mention that it has logical flaws that will most likely ruin someones database.

That's just another reason why threads should be reviewed and approved my mods, preferably by mods that are familiar with the subject of the releases..

gigola123 · 09/04/2014, 15:20

Quote:

Originally Posted by xExorcist

Lets count how many member here know how this **** works..
40? it's for learning purposes.
Never said it's a ready to use query it was old so i though about sharing since lot of ppl asked for it
And lets face it it's better sharing something that maybe is useless for you but useful for others than not sharing anything...(you simply sell work you don't give anything for this community and ye you can judge if i had a title like "KRALL RELEASE Or **** its just a simple old stuff for learning purposes)

I think there is more than 40 members which can do that, also don't release something if it's buggued or unfinished. There is not any purpose in this release ^^'.

InPanic Kev · 09/04/2014, 15:32

SQL SkillzZz -100

Exo · 09/04/2014, 16:33

I wish i didn't stop proofing shits to people then i would release the ready one but simply i don't care..
Specially when people who are complaining are just some random people who are not releasing a shit (Exception Caipi)

What learning purposes i meant was how to change the Item.. it wasn't meant for all of you..[People with skills it was for beginners who don't know how to do so]

Anyway since everyone is acting cool i will add the ready one..

Okay here you got...

PHP Code:




DECLARE  @WepRefID INT,
         @ArenaRefID INT,
         @OptLevel INT,
         @Data INT,
         @UP INT,
         @WepRefID2 INT
         
         
         
         
         SELECT @WepRefID = I.RefItemID
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=13
         
         SELECT @WepRefID2 = I.ID64
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=13
         
         
         SELECT @ArenaRefID = I.RefItemID
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=15
         
         SELECT @OptLevel = I.OptLevel
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=13
         
         SELECT @Data = I.Data
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON Inv.ItemID = I.ID64
         WHERE CharID = @CharID AND Inv.Slot=15
         
         SET @UP = (SELECT UP FROM Upgrade Where Req =@WepRefID)

IF EXISTS (SELECT * FROM SRO_VT_SHARD..Upgrade WHERE Req =@WepRefID)
BEGIN
If ( @OptLevel =8 And @Gold >=50000000000 AND @ArenaRefID='25834' AND @Data>=100)--Staff
BEGIN
UPDATE _Items SET RefItemID = @Up ,OptLevel=0 WHERE ID64=@WepRefID2
UPDATE _Char SET RemainGold =RemainGold-50000000000 WHERE CharID=@CharID
EXEC SRO_VT_SHARD.._STRG_DEL_ITEM_NoTX 1,@CharID,15
END
END

Just Create a Table Here it was called Upgrade 2 Columns Req/Up ..
Thanks for ruining it..

Quote:

Originally Posted by Syloxx

Hints:

-custom table
-TIDs

this query is a pain

and btw this is an better version of your variables:

PHP Code:

DECLARE @Arena INT, @RefID INT, @Data INT, @Opt INT SELECT @RefID = I.RefItemID, @Opt = I.OptLevel FROM _Inventory INV INNER JOIN _Items I ON INV.ItemID = I.ID64 WHERE INV.CharID = @CharID AND INV.Slot = 13 SELECT @Arena = I.RefItemID, @Data = I.Data FROM _Inventory INV INNER JOIN _Items I ON INV.ItemID = I.ID64 WHERE INV.CharID = @CharID AND INV.Slot = 14

@CharID will be declared / set by the procedure

anyway at least u used else if

btw, if someone wanna buy some professional queries / procedures let me know

Just to make somethings clear [i dont have to but ye why not]
Mine had a table the ready to use one shared now..
The CharID and the gold were at the first version cuz i was testing it w/o implementing it at a procedure ..

鳳凰城 · 09/04/2014, 21:49

Hey mr electronic enginner

He's helping out. instead of blaming him move your kral hand and release something.

Syloxx · 09/04/2014, 22:25

i released now..

1 Admin Query
1 Feature
1 Fix

i guess thats enougt

Example how a Professional Query looks like

Exo · 09/05/2014, 00:23

Quote:

Originally Posted by Syloxx

i released now..

1 Admin Query
1 Feature
1 Fix

i guess thats enougt

Example how a Professional Query looks like

I don't really believe there's a ' Prof.Query' Check mine.. it does the same function.. you just made a procedure and i didn't ..