[DiscordArchive] Hey guys. I'm troubleshooting some npc_vendor issues. Seeing where the in-game inventory from certai
[DiscordArchive] Hey guys. I'm troubleshooting some npc_vendor issues. Seeing where the in-game inventory from certai
Original source
Hey guys. I'm troubleshooting some npc_vendor issues. Seeing where the in-game inventory from certain vendors (ones that I created or changed) not lining up with what is in the npc_vendor table. Aside from the 150 item limit, is there anything I'm missing on what could explain these inventories not lining up? Something with item_template flags that might prevent a vendor from selling something? Or maybe the npcflag in creature_template?
rektbyfaith
02-27-2023, 04:42 PM #1Archived author: Derk • Posted: 2023-02-27T16:42:43.213000+00:00
Original source
Hey guys. I'm troubleshooting some npc_vendor issues. Seeing where the in-game inventory from certain vendors (ones that I created or changed) not lining up with what is in the npc_vendor table. Aside from the 150 item limit, is there anything I'm missing on what could explain these inventories not lining up? Something with item_template flags that might prevent a vendor from selling something? Or maybe the npcflag in creature_template?
Original source
".mmap path" targeting an npc with ".gm on" is the test I suggested to do
rektbyfaith
02-27-2023, 04:49 PM #2Archived author: jackpoz • Posted: 2023-02-27T16:49:43.625000+00:00
Original source
".mmap path" targeting an npc with ".gm on" is the test I suggested to do
Original source
there is no pathfinding for spells, lul, only vmap LoS checks (so make sure to have vmaps)
rektbyfaith
02-27-2023, 04:50 PM #3Archived author: jackpoz • Posted: 2023-02-27T16:50:22.963000+00:00
Original source
there is no pathfinding for spells, lul, only vmap LoS checks (so make sure to have vmaps)
Original source
vmaps I already own
rektbyfaith
02-27-2023, 04:51 PM #4Archived author: Naxgal • Posted: 2023-02-27T16:51:54.958000+00:00
Original source
vmaps I already own
Original source
Looking to make my first sql query to swap some level ranges around but I have some questions.
First: Does this look correct?
UPDATE `creature_template` SET `minlevel`=61 WHERE `minlevel`=64;
Secondly and rather importantly, How do I add additional level entries for the WHERE statement? Say I want to make every level 64 65 and 70 mob to level 61. Example would be greatly appreciated.
Thanks in advance for any help.
rektbyfaith
02-27-2023, 05:01 PM #5Archived author: Goatrek • Posted: 2023-02-27T17:01:44.615000+00:00
Original source
Looking to make my first sql query to swap some level ranges around but I have some questions.
First: Does this look correct?
UPDATE `creature_template` SET `minlevel`=61 WHERE `minlevel`=64;
Secondly and rather importantly, How do I add additional level entries for the WHERE statement? Say I want to make every level 64 65 and 70 mob to level 61. Example would be greatly appreciated.
Thanks in advance for any help.
Original source
WHERE minlevel IN (64,65)
rektbyfaith
02-27-2023, 05:04 PM #6Archived author: jackpoz • Posted: 2023-02-27T17:04:21.804000+00:00
Original source
WHERE minlevel IN (64,65)
Original source
and do a SELECT with the WHERE condition before firing the UPDATE, so you know what you are going to modify
rektbyfaith
02-27-2023, 05:04 PM #7Archived author: jackpoz • Posted: 2023-02-27T17:04:45.482000+00:00
Original source
and do a SELECT with the WHERE condition before firing the UPDATE, so you know what you are going to modify
Original source
The first part will take any creature whose minlevel is 64 and change it to 61. If that is what you are trying to do then it's right. For = more than one entry, you can use "in"
```
UPDATE creature_template
SET minlevel=61
WHERE minlevel in (64,65,70);
```
You can also use operators like: > 61
or : Between 61 and 70.
etc google up "mariadb where" for some more info
rektbyfaith
02-27-2023, 05:05 PM #8Archived author: Derk • Posted: 2023-02-27T17:05:04.210000+00:00
Original source
The first part will take any creature whose minlevel is 64 and change it to 61. If that is what you are trying to do then it's right. For = more than one entry, you can use "in"
```
UPDATE creature_template
SET minlevel=61
WHERE minlevel in (64,65,70);
```
You can also use operators like: > 61
or : Between 61 and 70.
etc google up "mariadb where" for some more info
Original source
Great answers. thanks
rektbyfaith
02-27-2023, 05:05 PM #9Archived author: Goatrek • Posted: 2023-02-27T17:05:41.291000+00:00
Original source
Great answers. thanks
Original source
I don't suppose anyone has any ideas on my question a few lines up? I'm spinning my wheels
rektbyfaith
02-27-2023, 05:11 PM #10Archived author: Derk • Posted: 2023-02-27T17:11:20.113000+00:00
Original source
I don't suppose anyone has any ideas on my question a few lines up? I'm spinning my wheels