[DiscordArchive] does any1 know place where i could see example of query which is joining tables from different datab
[DiscordArchive] does any1 know place where i could see example of query which is joining tables from different datab
Original source
does any1 know place where i could see example of query which is joining tables from different databases ?
rektbyfaith
02-05-2023, 03:50 AM #1Archived author: Rymercyble • Posted: 2023-02-05T03:50:38.305000+00:00
Original source
does any1 know place where i could see example of query which is joining tables from different databases ?
Original source
Just use
```
`database_name`.`table_name`
```
rektbyfaith
02-05-2023, 03:54 AM #2Archived author: Revision • Posted: 2023-02-05T03:54:48.085000+00:00
Original source
Just use
```
`database_name`.`table_name`
```
Original source
will that work when doing query against specific db for example `LoginDatabase.Query()` ?
rektbyfaith
02-05-2023, 03:56 AM #3Archived author: Rymercyble • Posted: 2023-02-05T03:56:13.407000+00:00
Original source
will that work when doing query against specific db for example `LoginDatabase.Query()` ?
Original source
Yes but obviously the query will fail if the database doesn't exist.
rektbyfaith
02-05-2023, 03:56 AM #4Archived author: Revision • Posted: 2023-02-05T03:56:30.987000+00:00
Original source
Yes but obviously the query will fail if the database doesn't exist.
Original source
If anyone uses mod-assistant module (https://www.azerothcore.org/catalogue.ht.../413914328)
Where can I find the NPC or how can I spawn the NPC?
Thank you in advance
[Embed: AzerothCore]
AzerothCore, the open source MMORPG server application
https://www.azerothcore.org/catalogue.html
rektbyfaith
02-05-2023, 03:57 AM #5Archived author: xiiihearts • Posted: 2023-02-05T03:57:26.961000+00:00
Original source
If anyone uses mod-assistant module (https://www.azerothcore.org/catalogue.ht.../413914328)
Where can I find the NPC or how can I spawn the NPC?
Thank you in advance
[Embed: AzerothCore]
AzerothCore, the open source MMORPG server application
https://www.azerothcore.org/catalogue.html
Original source
Well, by default she's spawned in every major city but if you want to add your own delete all spawns from the creature table with id1 of 9000000 and spawn it by using `.npc add 9000000`
rektbyfaith
02-05-2023, 03:58 AM #6Archived author: Revision • Posted: 2023-02-05T03:58:29.565000+00:00
Original source
Well, by default she's spawned in every major city but if you want to add your own delete all spawns from the creature table with id1 of 9000000 and spawn it by using `.npc add 9000000`
Original source
I see, I was having trouble finding the npc location while I was in Dalaran.
rektbyfaith
02-05-2023, 03:59 AM #7Archived author: xiiihearts • Posted: 2023-02-05T03:59:43.916000+00:00
Original source
I see, I was having trouble finding the npc location while I was in Dalaran.
Original source
She's near the fountain
rektbyfaith
02-05-2023, 03:59 AM #8Archived author: Revision • Posted: 2023-02-05T03:59:51.604000+00:00
Original source
She's near the fountain
Original source
thanks again
rektbyfaith
02-05-2023, 04:00 AM #9Archived author: xiiihearts • Posted: 2023-02-05T04:00:29.311000+00:00
Original source
thanks again
Original source
I just added her in random spots that suits me but you are of course able to change it to wherever you like!
rektbyfaith
02-05-2023, 04:00 AM #10Archived author: Revision • Posted: 2023-02-05T04:00:39.512000+00:00
Original source
I just added her in random spots that suits me but you are of course able to change it to wherever you like!