[DiscordArchive] Anyone know how to insert these values into npc_vendor without setting entry of vendor every time ?
[DiscordArchive] Anyone know how to insert these values into npc_vendor without setting entry of vendor every time ?
Archived author: hguy • Posted: 2020-03-09T22:55:21.377000+00:00
Original source
Anyone know how to insert these values into npc_vendor without setting entry of vendor every time ?
Archived author: hguy • Posted: 2020-03-09T22:55:40.318000+00:00
Original source
Like onetime INSERT INTO npc_vendor (entry, item) SET entry for all item
![[Image: Screenshot_5.png?ex=690c7eb2&is=690b2d32...e6c001d58&]](https://cdn.discordapp.com/attachments/369084351129845760/686708841143861261/Screenshot_5.png?ex=690c7eb2&is=690b2d32&hm=e6a37bfbbc51f2fe8ca4af582e43f1282727550325444a3342ffa18e6c001d58&)
Archived author: hguy • Posted: 2020-03-09T22:55:46.264000+00:00
Original source
![[Image: Screenshot_5.png?ex=690c7eb2&is=690b2d32...e6c001d58&]](https://cdn.discordapp.com/attachments/369084351129845760/686708841143861261/Screenshot_5.png?ex=690c7eb2&is=690b2d32&hm=e6a37bfbbc51f2fe8ca4af582e43f1282727550325444a3342ffa18e6c001d58&)
Archived author: Barbz • Posted: 2020-03-09T23:16:25.256000+00:00
Original source
you can make a stored procedure for that and add a loop inside it but not sure it's worth it
Archived author: Barbz • Posted: 2020-03-09T23:17:00.047000+00:00
Original source
else you just do (@entry, 145), and you duplicate this many times and u replace the items
Archived author: Barbz • Posted: 2020-03-09T23:17:09.364000+00:00
Original source
and u set @entry value ofc