• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

TrinityCore 3.3.5 NPC-ITEMS Mysql Queries Generator

xtrem

New member
Hellllooo :")
I worked on my shop today and i saw we can't choose the slot with .npc add item #id
I didn't try to modify the core, i just created a mysql generator which increments the slot automatly, generating mysql requests.
I have created a SET_MODE which makes you able to add sorted sets. I mean a specifiate set by column (unpeer/peer slots)

Normal Mode

First put the npc_entry you want to add items.
Then you can add items basically with ; like 1;2;3;4;5;6;7;8;9 and it will keep the order, and generate.

f942a6b6d0.png


One click on the mysql queries, and it will automatically copy the content !
You can add data after this, just dont forget to remove the current Item Data, or it will add it 2 times ;')
You can change the NpcId too and it will add a new request after the last one.

5b0bc4d097.png


Also, you can add custom slots using "," for each item. For example write: 1,3;2,5;3,10 and generate!

Set Mode

44cfde1794.jpg


This picture shows slots of a npc vendor. a,b,c,d,e = set 1 f,g,h,i,j = set 2
This mode is only for multi-talents sets! This will add set column by column, sorted.
Dont forget to change the starting Slot if your npc already has sloted items!

7771d9e0ec.png


Generated:
INSERT INTO `world`.`npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES
('99', '0', '1', '0', '0', '0', '0'),
('99', '2', '2', '0', '0', '0', '0'),
('99', '4', '3', '0', '0', '0', '0'),
('99', '6', '4', '0', '0', '0', '0'),
('99', '8', '5', '0', '0', '0', '0'),
('99', '1', '6', '0', '0', '0', '0'),
('99', '3', '7', '0', '0', '0', '0'),
('99', '5', '8', '0', '0', '0', '0'),
('99', '7', '9', '0', '0', '0', '0'),
('99', '9', '10', '0', '0', '0', '0');

This will auto special-incremente your items (same as normal mode: 10,0;11,2;12,4;13,6;14,8;15,1;16,3;17,5;18,7;19,9)
SET-MODE just make your job more simple :D
I hope this software will be appreciate for some users :D !

Sources: http://github.com/romain-p/SortItem
Download Compiled: http://puu.sh/qcfLS/e1307fec75.jar
 

Attachments

  • Numérisation_20160721.jpg
    Numérisation_20160721.jpg
    8.6 KB · Views: 31
Last edited:
Top