[Request] Query to exchange an item for another

[drakoo]

Greetings folks.

 

I come here asking for something that I could not create with my basic knowledge in SQL.

 

Let me explain my case before.

 

Currently I have my server in the Set Vesper that everyone already knows.

(Interlude Version).

 

But I do not want it more like the "Top Set" from the server.

I want to change the Set Top Grad S Vesper for the retail Interlude (Draconic, Major and Imperial).

 

With my basic knowledge in sql  I could do

 

I created a query, replacing for example:

 

Replace all Vesper Gloves Heavy for  Imperial Heavy Gloves

Managed successfully.

 

So I came here two errors.

 

Error Number 01: The Set Vesper has only one Helmo

This Helmo is the same as in Set: Heavy / Light / Robe.

 

But the Draconic has a Helmo.

The Imperial has one another.

And Major is another.

 

Here comes my problem:

How to distinguish the query if the Player Helmo Vesper is using is: Set a Vesper Heavy / Vesper Robe / Heavy?.

 

Now Doubts Number 02: How to change the query SET BREAST From Epic (For he is pants and chest in just one part) in breast and pants Dynasty (which are two separate parts?)

 

Well I look forward to your help on this problem.

Thanks.

Excuse-me for my bad english

[Bleadd]

Why you don't go in the client. Itemname-e.dat (or not -e with interlude?).

 

Rename draconic Major & IC

[Hellish]

Why you don't go in the client. Itemname-e.dat (or not -e with interlude?).

 

Rename draconic Major & IC

Just loled, don't reply if you have no idea wtf is going on.

 

The easier way would be to delete those vespers from every character, and add them adena, coins or whatever you have there equivalent to the vesper's price.

[drakoo]

And the number of sets to enchant? 25 +10 +?

The query would need to update.

But still I do not have this knowledge in SQL.

[drakoo]

up ?

[drakoo]

upx2 ?  :/

[Boorinio]

upx2 ?  :/

 

it would be something like REPLACE INTO items (etc,etc,etc)

give me some minutes nad i might be able to help you...

 

[Boorinio]

REPLACE items WHERE item_id IN (SELECT item_id FROM armor);

 

i think this is stupid but it might work forgive me i don't have any knowledge in sql but i'm trying to help....Good Luck