[DiscordArchive] ye but that's the guid of the items, is there a way to get the entryid?
[DiscordArchive] ye but that's the guid of the items, is there a way to get the entryid?
Original source
ye but that's the guid of the items, is there a way to get the entryid?
rektbyfaith
11-04-2021, 11:24 PM #1Archived author: Yukki • Posted: 2021-11-04T23:24:16.412000+00:00
Original source
ye but that's the guid of the items, is there a way to get the entryid?
Original source
of the equiped items
rektbyfaith
11-04-2021, 11:24 PM #2Archived author: Yukki • Posted: 2021-11-04T23:24:21.443000+00:00
Original source
of the equiped items
Original source
```sql
SELECT ci.*, ii.itementry FROM character_inventory ci LEFT JOIN item_instance ii ON ci.item = ii.guid;
```
rektbyfaith
11-04-2021, 11:29 PM #3Archived author: Nyeriah • Posted: 2021-11-04T23:29:36.862000+00:00
Original source
```sql
SELECT ci.*, ii.itementry FROM character_inventory ci LEFT JOIN item_instance ii ON ci.item = ii.guid;
```
Original source
edit it to suit your needs
rektbyfaith
11-04-2021, 11:29 PM #4Archived author: Nyeriah • Posted: 2021-11-04T23:29:42.256000+00:00
Original source
edit it to suit your needs
Original source
I have to run that in a query?
rektbyfaith
11-04-2021, 11:34 PM #5Archived author: Yukki • Posted: 2021-11-04T23:34:08.539000+00:00
Original source
I have to run that in a query?
Original source
<@!251803844307189761> I got a new row with what i actually need but I created a new row in character_inventory called `itementry` and i want o sync it with `itementry` from item_instance
rektbyfaith
11-05-2021, 12:03 AM #6Archived author: Yukki • Posted: 2021-11-05T00:03:30.633000+00:00
Original source
<@!251803844307189761> I got a new row with what i actually need but I created a new row in character_inventory called `itementry` and i want o sync it with `itementry` from item_instance
Original source
is that possible?
rektbyfaith
11-05-2021, 12:03 AM #7Archived author: Yukki • Posted: 2021-11-05T00:03:34.871000+00:00
Original source
is that possible?
Original source
I've seen something on youtube about foreign keys but i dont think that syncs 2 rows
rektbyfaith
11-05-2021, 12:04 AM #8Archived author: Yukki • Posted: 2021-11-05T00:04:09.128000+00:00
Original source
I've seen something on youtube about foreign keys but i dont think that syncs 2 rows
Original source
I'm sorry, I don't understand what you're trying to do
rektbyfaith
11-05-2021, 12:05 AM #9Archived author: Nyeriah • Posted: 2021-11-05T00:05:20.984000+00:00
Original source
I'm sorry, I don't understand what you're trying to do
Original source
I'm working on an armory and i need the entryid of the items for the tooltip to how up correctly
rektbyfaith
11-05-2021, 12:06 AM #10Archived author: Yukki • Posted: 2021-11-05T00:06:30.429000+00:00
Original source
I'm working on an armory and i need the entryid of the items for the tooltip to how up correctly
1 Guest(s)
1 Guest(s)