PDA

View Full Version : TrinityCore 3.3.5 NPC-ITEMS Mysql Queries Generator



xtrem
07-24-2016, 01:53 AM
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.

http://puu.sh/qceUM/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.

http://puu.sh/qcf7z/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

http://puu.sh/qcfSN/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!

http://puu.sh/qcftN/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

xtrem
07-24-2016, 01:12 PM
Demo: http://puu.sh/qcGGE/5b5202e41d.jpg