[DiscordArchive] The first SQL queries on that link is that how you do it?
[DiscordArchive] The first SQL queries on that link is that how you do it?
Original source
The first SQL queries on that link is that how you do it?
rektbyfaith
08-05-2023, 09:13 PM #1Archived author: Roddan • Posted: 2023-08-05T21:13:46.863000+00:00
Original source
The first SQL queries on that link is that how you do it?
Original source
Let's say this one ```GOSSIP_USE_OUTHOUSE``` I don't see any ID for it in the C++
rektbyfaith
08-05-2023, 09:14 PM #2Archived author: Roddan • Posted: 2023-08-05T21:14:51.402000+00:00
Original source
Let's say this one ```GOSSIP_USE_OUTHOUSE``` I don't see any ID for it in the C++
Original source
yep.
`gossip_menu` adds the menu page.
`gossip_menu_options` the clickable options, like "Use the book!"
If the gossip is added through C++ you only need this and reference it in `AddGossipItemFor()`
If you do it all in DB, aka convert the C++ script to DB. You will need to update `creature_template`.`gossip_menu_id` to `gossip_menu`.`MenuID`
iirc MenuID is a sniffed field though
rektbyfaith
08-05-2023, 09:18 PM #3Archived author: Kitzunu • Posted: 2023-08-05T21:18:05.583000+00:00
Original source
yep.
`gossip_menu` adds the menu page.
`gossip_menu_options` the clickable options, like "Use the book!"
If the gossip is added through C++ you only need this and reference it in `AddGossipItemFor()`
If you do it all in DB, aka convert the C++ script to DB. You will need to update `creature_template`.`gossip_menu_id` to `gossip_menu`.`MenuID`
iirc MenuID is a sniffed field though
Original source
I have it sniffed from retail
rektbyfaith
08-05-2023, 09:18 PM #4Archived author: Roddan • Posted: 2023-08-05T21:18:47.513000+00:00
Original source
I have it sniffed from retail
Original source
awesome
rektbyfaith
08-05-2023, 09:18 PM #5Archived author: Kitzunu • Posted: 2023-08-05T21:18:58.406000+00:00
Original source
awesome
Original source
also for your question about GOSSIP_USE_OUTHOUSE
rektbyfaith
08-05-2023, 09:19 PM #6Archived author: Kitzunu • Posted: 2023-08-05T21:19:11.530000+00:00
Original source
also for your question about GOSSIP_USE_OUTHOUSE
Original source
you have
rektbyfaith
08-05-2023, 09:19 PM #7Archived author: Kitzunu • Posted: 2023-08-05T21:19:19.486000+00:00
Original source
you have
Original source
Do you have to know what it's called in the Sniff when it comes to MenuID?
rektbyfaith
08-05-2023, 09:20 PM #8Archived author: Roddan • Posted: 2023-08-05T21:20:02.414000+00:00
Original source
Do you have to know what it's called in the Sniff when it comes to MenuID?
Original source
```cpp
#define GOSSIP_USE_OUTHOUSE "Use the outhouse."
// Using provided text, not from DB
void AddGossipItemFor(Player* player, uint32 icon, std:
tring const& text, uint32 sender, uint32 action);// Using provided texts, not from DB
void AddGossipItemFor(Player* player, uint32 icon, std:
tring const& text, uint32 sender, uint32 action, std:tring const& popupText, uint32 popupMoney, bool coded);// Uses gossip item info from DB
void AddGossipItemFor(Player* player, uint32 gossipMenuID, uint32 gossipMenuItemID, uint32 sender, uint32 action, uint32 boxMoney = 0);
```
which is used in the AddGossipItemFor().
AddGossipItemFor() can take both string input, and gossipMenuID input from DB
rektbyfaith
08-05-2023, 09:20 PM #9Archived author: Kitzunu • Posted: 2023-08-05T21:20:23.975000+00:00
Original source
```cpp
#define GOSSIP_USE_OUTHOUSE "Use the outhouse."
// Using provided text, not from DB
void AddGossipItemFor(Player* player, uint32 icon, std:tring const& text, uint32 sender, uint32 action);
// Using provided texts, not from DB
void AddGossipItemFor(Player* player, uint32 icon, std:tring const& text, uint32 sender, uint32 action, std:tring const& popupText, uint32 popupMoney, bool coded);
// Uses gossip item info from DB
void AddGossipItemFor(Player* player, uint32 gossipMenuID, uint32 gossipMenuItemID, uint32 sender, uint32 action, uint32 boxMoney = 0);
```
which is used in the AddGossipItemFor().
AddGossipItemFor() can take both string input, and gossipMenuID input from DB
Original source
I am not good with sniffs... I will do a scarry thing and ping <@546729924874993665> and hope I dont get murdered x)
rektbyfaith
08-05-2023, 09:20 PM #10Archived author: Kitzunu • Posted: 2023-08-05T21:20:53.581000+00:00
Original source
I am not good with sniffs... I will do a scarry thing and ping <@546729924874993665> and hope I dont get murdered x)
1 Guest(s)
1 Guest(s)