[DiscordArchive] isn't TC SOAP doing that already ?
[DiscordArchive] isn't TC SOAP doing that already ?
Original source
isn't TC SOAP doing that already ?
rektbyfaith
09-26-2022, 06:59 AM #1Archived author: jackpoz • Posted: 2022-09-26T06:59:45.861000+00:00
Original source
isn't TC SOAP doing that already ?
Original source
How would you personally go about using join? I've done inner and outer join before but not often enough to know how to use it in this scenario
rektbyfaith
09-26-2022, 07:06 AM #2Archived author: Quantum • Posted: 2022-09-26T07:06:09.935000+00:00
Original source
How would you personally go about using join? I've done inner and outer join before but not often enough to know how to use it in this scenario
Original source
I'm basically making a query to make creating custom instances a breeze
rektbyfaith
09-26-2022, 07:06 AM #3Archived author: Quantum • Posted: 2022-09-26T07:06:37.089000+00:00
Original source
I'm basically making a query to make creating custom instances a breeze
Original source
start with a select on creature_loot_template with inner join on the other tables
rektbyfaith
09-26-2022, 07:07 AM #4Archived author: jackpoz • Posted: 2022-09-26T07:07:19.339000+00:00
Original source
start with a select on creature_loot_template with inner join on the other tables
Original source
instead of WHERE entry IN ()
rektbyfaith
09-26-2022, 07:07 AM #5Archived author: jackpoz • Posted: 2022-09-26T07:07:39.123000+00:00
Original source
instead of WHERE entry IN ()
Original source
like SELECT entry from creature_loot_template CLT INNER JOIN creature_template CT on CLT.entry = CT.lootid etc (assuming you picked the correct relationship between tables)
rektbyfaith
09-26-2022, 07:08 AM #6Archived author: jackpoz • Posted: 2022-09-26T07:08:40.548000+00:00
Original source
like SELECT entry from creature_loot_template CLT INNER JOIN creature_template CT on CLT.entry = CT.lootid etc (assuming you picked the correct relationship between tables)
Original source
compare the performances of the WHERE entry IN () and the JOIN one and see which is faster
rektbyfaith
09-26-2022, 07:09 AM #7Archived author: jackpoz • Posted: 2022-09-26T07:09:24.434000+00:00
Original source
compare the performances of the WHERE entry IN () and the JOIN one and see which is faster
Original source
you can use SAI to morph an npc into another model. Can you also scale the size? because when I let the npc spawn temporarily, it's smaller the way I want it, but when morphing, it suddenly becomes much larger
rektbyfaith
09-26-2022, 07:12 AM #8Archived author: Krutok • Posted: 2022-09-26T07:12:58.650000+00:00
Original source
you can use SAI to morph an npc into another model. Can you also scale the size? because when I let the npc spawn temporarily, it's smaller the way I want it, but when morphing, it suddenly becomes much larger
Original source
```sql
SET @MapID := 389;
DELETE clt FROM creature_loot_template clt
INNER JOIN creature_template ct ON ct.lootid = clt.entry
INNER JOIN creature c ON c.id = ct.entry
WHERE c.map = @MapID AND ct.minlevel > 1 AND (ct.faction_A != 35 OR ct.faction_H != 35);
```
So somewhat like this?
Edit: Worked wonders jackpoz, thanks a bunch
rektbyfaith
09-26-2022, 07:15 AM #9Archived author: Quantum • Posted: 2022-09-26T07:15:42.654000+00:00
Original source
```sql
SET @MapID := 389;
DELETE clt FROM creature_loot_template clt
INNER JOIN creature_template ct ON ct.lootid = clt.entry
INNER JOIN creature c ON c.id = ct.entry
WHERE c.map = @MapID AND ct.minlevel > 1 AND (ct.faction_A != 35 OR ct.faction_H != 35);
```
So somewhat like this?
Edit: Worked wonders jackpoz, thanks a bunch
Original source
Going to play it safe and back up my world db before running it lol
rektbyfaith
09-26-2022, 07:16 AM #10Archived author: Quantum • Posted: 2022-09-26T07:16:33.731000+00:00
Original source
Going to play it safe and back up my world db before running it lol