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.
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.
Also, you can add custom slots using "," for each item. For example write: 1,3;2,5;3,10 and generate!
Set Mode
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!
Generated:
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
I hope this software will be appreciate for some users !
Sources: http://github.com/romain-p/SortItem
Download Compiled: http://puu.sh/qcfLS/e1307fec75.jar
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.
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.
Also, you can add custom slots using "," for each item. For example write: 1,3;2,5;3,10 and generate!
Set Mode
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!
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
I hope this software will be appreciate for some users !
Sources: http://github.com/romain-p/SortItem
Download Compiled: http://puu.sh/qcfLS/e1307fec75.jar
Attachments
Last edited: