User Tag List

Results 1 to 2 of 2

Thread: NPC-ITEMS Mysql Queries Generator

  1. #1
    Lurking Member xtrem's Avatar
    Join Date
    Jul 2016
    Location
    France
    Posts
    22
    XP
    106
    Level
    1
    Thanks
    10
    Thanked 9 Times in 4 Posts

    NPC-ITEMS Mysql Queries Generator

    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:
    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
    Attached Images Attached Images
    Last edited by xtrem; 07-24-2016 at 10:50 AM.
    Achievements:
    Level I Member 7 days registered
    I would appreciate any user who add me on skype
    Check my profile

  2. The Following 3 Users Say Thank You to xtrem For This Useful Post:


  3. #2
    Original Poster
    Lurking Member xtrem's Avatar
    Join Date
    Jul 2016
    Location
    France
    Posts
    22
    XP
    106
    Level
    1
    Thanks
    10
    Thanked 9 Times in 4 Posts
    Demo:
    Achievements:
    Level I Member 7 days registered
    I would appreciate any user who add me on skype
    Check my profile

  4. The Following 3 Users Say Thank You to xtrem For This Useful Post:


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •