[DiscordArchive] What exactly do you want to select? The item ids or the name of the item or what?
[DiscordArchive] What exactly do you want to select? The item ids or the name of the item or what?
Original source
What exactly do you want to select? The item ids or the name of the item or what?
rektbyfaith
01-14-2023, 11:12 PM #1Archived author: Revision • Posted: 2023-01-14T23:12:03.382000+00:00
Original source
What exactly do you want to select? The item ids or the name of the item or what?
Original source
I need a SQL that will look for the Prize Item in the Quest template table and at the same time will open a Tab by selecting the Quest Item in the Item_template table
rektbyfaith
01-14-2023, 11:13 PM #2Archived author: Marcelo • Posted: 2023-01-14T23:13:16.553000+00:00
Original source
I need a SQL that will look for the Prize Item in the Quest template table and at the same time will open a Tab by selecting the Quest Item in the Item_template table
Original source
One way that probably isn't very performance-friendly would be
```
SET @QuestID := 38;
SELECT * FROM `item_template` WHERE `entry` IN (SELECT `RewardItem1` FROM `quest_template` WHERE `ID`=@QuestID) OR `entry` IN (SELECT `RewardItem2` FROM `quest_template` WHERE `ID`=@QuestID) OR `entry` IN (SELECT `RewardItem3` FROM `quest_template` WHERE `ID`=@QuestID) OR `entry` IN (SELECT `RewardItem4` FROM `quest_template` WHERE `ID`=@QuestID);
```
rektbyfaith
01-14-2023, 11:18 PM #3Archived author: Revision • Posted: 2023-01-14T23:18:57.599000+00:00
Original source
One way that probably isn't very performance-friendly would be
```
SET @QuestID := 38;
SELECT * FROM `item_template` WHERE `entry` IN (SELECT `RewardItem1` FROM `quest_template` WHERE `ID`=@QuestID) OR `entry` IN (SELECT `RewardItem2` FROM `quest_template` WHERE `ID`=@QuestID) OR `entry` IN (SELECT `RewardItem3` FROM `quest_template` WHERE `ID`=@QuestID) OR `entry` IN (SELECT `RewardItem4` FROM `quest_template` WHERE `ID`=@QuestID);
```
Original source
Tkanks..I'll try
rektbyfaith
01-14-2023, 11:20 PM #4Archived author: Marcelo • Posted: 2023-01-14T23:20:34.346000+00:00
Original source
Tkanks..I'll try
Original source
simple selects are pretty good for performance
rektbyfaith
01-14-2023, 11:21 PM #5Archived author: Rymercyble • Posted: 2023-01-14T23:21:20.488000+00:00
Original source
simple selects are pretty good for performance
Original source
![[Image: image.png?ex=690bdbf6&is=690a8a76&hm=143...d98cc35af&]](https://cdn.discordapp.com/attachments/284406375495368704/1063961068365422662/image.png?ex=690bdbf6&is=690a8a76&hm=14381460b0ec4037c6d835c72dbfdfb59cdfe32ec5a84df6951733bd98cc35af&)
rektbyfaith
01-14-2023, 11:21 PM #6Archived author: Marcelo • Posted: 2023-01-14T23:21:26.180000+00:00
Original source
Original source
thanks
rektbyfaith
01-14-2023, 11:21 PM #7Archived author: Marcelo • Posted: 2023-01-14T23:21:31.505000+00:00
Original source
thanks
Original source
Why did it select the item of the same entry? Is that set?
rektbyfaith
01-14-2023, 11:22 PM #8Archived author: Revision • Posted: 2023-01-14T23:22:05.854000+00:00
Original source
Why did it select the item of the same entry? Is that set?
Original source
yes..I found a database with good quests..I'm going to use the quests..but I need to get the items
rektbyfaith
01-14-2023, 11:22 PM #9Archived author: Marcelo • Posted: 2023-01-14T23:22:15.494000+00:00
Original source
yes..I found a database with good quests..I'm going to use the quests..but I need to get the items
Original source
I see, okay
rektbyfaith
01-14-2023, 11:22 PM #10Archived author: Revision • Posted: 2023-01-14T23:22:21.248000+00:00
Original source
I see, okay
1 Guest(s)
1 Guest(s)