[DiscordArchive] if i delete some items from `item_instance` it will auto delete from `character_inventory`?
[DiscordArchive] if i delete some items from `item_instance` it will auto delete from `character_inventory`?
Original source
if i delete some items from `item_instance` it will auto delete from `character_inventory`?
rektbyfaith
02-26-2025, 04:00 PM #1Archived author: OUTRAKE • Posted: 2025-02-26T16:00:07.489000+00:00
Original source
if i delete some items from `item_instance` it will auto delete from `character_inventory`?
Original source
After a relog, yes
rektbyfaith
02-26-2025, 04:06 PM #2Archived author: metallinos • Posted: 2025-02-26T16:06:05.569000+00:00
Original source
After a relog, yes
Original source
```
DELETE FROM character_inventory
WHERE item IN (SELECT guid FROM item_instance WHERE itemEntry IN (50400, 50402, 50404, 50398, 52572));
DELETE FROM item_instance
WHERE itemEntry IN (50400, 50402, 50404, 50398, 52572);
```
rektbyfaith
02-26-2025, 04:06 PM #3Archived author: OUTRAKE • Posted: 2025-02-26T16:06:17.477000+00:00
Original source
```
DELETE FROM character_inventory
WHERE item IN (SELECT guid FROM item_instance WHERE itemEntry IN (50400, 50402, 50404, 50398, 52572));
DELETE FROM item_instance
WHERE itemEntry IN (50400, 50402, 50404, 50398, 52572);
```
Original source
thats better
rektbyfaith
02-26-2025, 04:06 PM #4Archived author: OUTRAKE • Posted: 2025-02-26T16:06:25.264000+00:00
Original source
thats better
Original source
This might be a silly question but have you tried relogging? Some people also run some macro to fix it
```
/run if( ChatFrame1.editBox.language==GetLanguageByIndex(1))then ChatFrame1.editBox.language=GetLanguageByIndex(2)else ChatFrame1.editBox.language=GetLanguageByIndex(1) end;
```
If the macro helps, you likely know inaccessible languages such as titan or draconian
rektbyfaith
02-26-2025, 04:07 PM #5Archived author: metallinos • Posted: 2025-02-26T16:07:55.850000+00:00
Original source
This might be a silly question but have you tried relogging? Some people also run some macro to fix it
```
/run if( ChatFrame1.editBox.language==GetLanguageByIndex(1))then ChatFrame1.editBox.language=GetLanguageByIndex(2)else ChatFrame1.editBox.language=GetLanguageByIndex(1) end;
```
If the macro helps, you likely know inaccessible languages such as titan or draconian
1 Guest(s)
1 Guest(s)