[DiscordArchive] is there an easy way to find the list of the enchanting matts and there ids so i can remove them all
[DiscordArchive] is there an easy way to find the list of the enchanting matts and there ids so i can remove them all
Original source
is there an easy way to find the list of the enchanting matts and there ids so i can remove them all?
rektbyfaith
08-05-2022, 04:17 PM #1Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2022-08-05T16:17:28.400000+00:00
Original source
is there an easy way to find the list of the enchanting matts and there ids so i can remove them all?
Original source
or am i jsut doomed to open like 100 pages of wowhead
rektbyfaith
08-05-2022, 04:18 PM #2Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2022-08-05T16:18:48.281000+00:00
Original source
or am i jsut doomed to open like 100 pages of wowhead
Original source
```
SELECT mad.item, it.`name` FROM mod_auctionhousebot_disabled_items mad LEFT OUTER JOIN item_template it ON it.entry=mad.item;
```
That'll list all items with names, it would be easy enough to just add a where clause for item class or the like.
rektbyfaith
08-05-2022, 04:19 PM #3Archived author: Revision • Posted: 2022-08-05T16:19:05.134000+00:00
Original source
```
SELECT mad.item, it.`name` FROM mod_auctionhousebot_disabled_items mad LEFT OUTER JOIN item_template it ON it.entry=mad.item;
```
That'll list all items with names, it would be easy enough to just add a where clause for item class or the like.
Original source
Like this:
```
SELECT mad.item, it.`name` FROM mod_auctionhousebot_disabled_items mad LEFT OUTER JOIN item_template it ON it.entry=mad.item WHERE it.class=7 AND it.subclass=12;
```
rektbyfaith
08-05-2022, 04:20 PM #4Archived author: Revision • Posted: 2022-08-05T16:20:04.505000+00:00
Original source
Like this:
```
SELECT mad.item, it.`name` FROM mod_auctionhousebot_disabled_items mad LEFT OUTER JOIN item_template it ON it.entry=mad.item WHERE it.class=7 AND it.subclass=12;
```
Original source
i did select * from disabled items, so wouldnt that pul lall columns?
rektbyfaith
08-05-2022, 04:23 PM #5Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2022-08-05T16:23:35.562000+00:00
Original source
i did select * from disabled items, so wouldnt that pul lall columns?
Original source
because it only showed id lists
rektbyfaith
08-05-2022, 04:23 PM #6Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2022-08-05T16:23:39.970000+00:00
Original source
because it only showed id lists
Original source
disabled items only have ids
rektbyfaith
08-05-2022, 04:23 PM #7Archived author: Revision • Posted: 2022-08-05T16:23:58.344000+00:00
Original source
disabled items only have ids
Original source
which is why you use a join statement to get the names from the item template, and other things if needed.
rektbyfaith
08-05-2022, 04:24 PM #8Archived author: Revision • Posted: 2022-08-05T16:24:12.571000+00:00
Original source
which is why you use a join statement to get the names from the item template, and other things if needed.
Original source
ah ok
rektbyfaith
08-05-2022, 04:24 PM #9Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2022-08-05T16:24:58.902000+00:00
Original source
ah ok
Original source
If you use the last SQL query I sent it will list all disabled items that are enchanting trade goods (class 7 and subclass 12)
rektbyfaith
08-05-2022, 04:29 PM #10Archived author: Revision • Posted: 2022-08-05T16:29:05.162000+00:00
Original source
If you use the last SQL query I sent it will list all disabled items that are enchanting trade goods (class 7 and subclass 12)
1 Guest(s)
1 Guest(s)