Main hand sword to one handed

[Aolelon]

How would you change a main handed sword to one handed?
currently i am trying to get the Thunderfury from Mainhand to One hand (dont know why its mainhand still) the sql code is

('19019', '0', '2', '7', 'Thunderfury, Blessed Blade of the Windseeker', 'Thunderfury, Blessed Blade of the Windseeker', 'Thunderfury, Blessed Blade of the Windseeker', 'Thunderfury, Blessed Blade of the Windseeker', '30606', '5', '0', '255355', '1276777', '21', '-1', '-1', '80', '60', '0', '0', '0', '0', '0', '0', '1', '0', '3', '5', '7', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44', '115', '0', '16', '30', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '9', '0', '0', '0', '1900', '0', '21992', '2', '0', '-1', '0', '-1', '0', '2', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '125', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');

just wondering what i should edit

[muyloukis]

o.O

[Caimbeul]

I would like to know this, too.

How to change a main-handed weapon into a one-handed weapon?

Thanks

[Thoz]

change slot to 13 :technolog

[Caimbeul]

I changed "inventorytype" to 13 but with no effect, even after i restarted sql and the server (kobold). Do i have to use some ingame command to renew the item or did i miss something in the sql database?

Greetz

[Esqo]

Search for a one handed sword, And change the name and models on it, and it'll be one handed xD

good luck