[DiscordArchive] ```@startweap = SELECT item FROM npc_vendor WHERE npc_vendor = 500000
[DiscordArchive] ```@startweap = SELECT item FROM npc_vendor WHERE npc_vendor = 500000
Original source
```@startweap = SELECT item FROM npc_vendor WHERE npc_vendor = 500000
UPDATE item_template SET buyprice = 0 WHERE entry = @startweap```
whats the right way to do this in sql?
rektbyfaith
06-23-2022, 05:35 AM #1Archived author: Crow • Posted: 2022-06-23T05:35:17.074000+00:00
Original source
```@startweap = SELECT item FROM npc_vendor WHERE npc_vendor = 500000
UPDATE item_template SET buyprice = 0 WHERE entry = @startweap```
whats the right way to do this in sql?
Original source
nvm, found out.
```UPDATE item_template, npc_vendor SET item_template.buyprice = 0 WHERE npc_vendor.item = item_template.entry AND npc_vendor.entry = 500000;```
rektbyfaith
06-23-2022, 05:48 AM #2Archived author: Crow • Posted: 2022-06-23T05:48:06.498000+00:00
Original source
nvm, found out.
```UPDATE item_template, npc_vendor SET item_template.buyprice = 0 WHERE npc_vendor.item = item_template.entry AND npc_vendor.entry = 500000;```
Original source
Hello! what would be the steps to retroport a map, lets see a map from pandaria, just the map, no minimap no logginscreen, no areas inside the map, as I understood the maps have many .adts and these contain .wmo, .blp, .m2, so I would need to port them too, and add them to the patch or I'm totally wrong xD ❓
rektbyfaith
06-23-2022, 05:54 AM #3Archived author: Robinson Leo • Posted: 2022-06-23T05:54:47.414000+00:00
Original source
Hello! what would be the steps to retroport a map, lets see a map from pandaria, just the map, no minimap no logginscreen, no areas inside the map, as I understood the maps have many .adts and these contain .wmo, .blp, .m2, so I would need to port them too, and add them to the patch or I'm totally wrong xD ❓
Original source
The problem is items in the list can be removed without the iterators knowledge. For example, a hook can trigger a separate on-aura-remove effect that removes all auras that you can't track or pass the iterator to. With the vector variant it's the only solution I think would work.
rektbyfaith
06-23-2022, 05:59 AM #4Archived author: whatwere • Posted: 2022-06-23T05:59:19.161000+00:00
Original source
The problem is items in the list can be removed without the iterators knowledge. For example, a hook can trigger a separate on-aura-remove effect that removes all auras that you can't track or pass the iterator to. With the vector variant it's the only solution I think would work.
1 Guest(s)
1 Guest(s)