[DiscordArchive] can anyone help me with the following SQL?
[DiscordArchive] can anyone help me with the following SQL?
Original source
can anyone help me with the following SQL?
rektbyfaith
06-05-2023, 10:29 AM #1Archived author: Lonk • Posted: 2023-06-05T10:29:55.625000+00:00
Original source
can anyone help me with the following SQL?
Original source
```
USE acore_world;
UPDATE creature_loot_template SET Chance=100,GroupId=0 WHERE QuestRequired=1;
```
rektbyfaith
06-05-2023, 10:31 AM #2Archived author: Lonk • Posted: 2023-06-05T10:31:18.827000+00:00
Original source
```
USE acore_world;
UPDATE creature_loot_template SET Chance=100,GroupId=0 WHERE QuestRequired=1;
```
Original source
trying to set the drop chance to 100% for quest items
rektbyfaith
06-05-2023, 10:32 AM #3Archived author: Lonk • Posted: 2023-06-05T10:32:34.568000+00:00
Original source
trying to set the drop chance to 100% for quest items
Original source
but getting error:
rektbyfaith
06-05-2023, 10:33 AM #4Archived author: Lonk • Posted: 2023-06-05T10:33:53.788000+00:00
Original source
but getting error:
Original source
```Error occurred during SQL query execution
Reason:
SQL Error [1062] [23000]: Duplicate entry '1111-6838-0-0' for key 'creature_loot_template.PRIMARY'```
rektbyfaith
06-05-2023, 10:33 AM #5Archived author: Lonk • Posted: 2023-06-05T10:33:58.535000+00:00
Original source
```Error occurred during SQL query execution
Reason:
SQL Error [1062] [23000]: Duplicate entry '1111-6838-0-0' for key 'creature_loot_template.PRIMARY'```
Original source
Oo, the 50/50 of 1 or 2 items was done with 2 records in the table
rektbyfaith
06-05-2023, 10:38 AM #6Archived author: Tereneckla • Posted: 2023-06-05T10:38:34.289000+00:00
Original source
Oo, the 50/50 of 1 or 2 items was done with 2 records in the table
Original source
come again?
rektbyfaith
06-05-2023, 10:39 AM #7Archived author: Lonk • Posted: 2023-06-05T10:39:47.973000+00:00
Original source
come again?
Original source
Oh, a drop with a 50/50 chance of being either 1 item OR another item was implemented using duplicated records?
rektbyfaith
06-05-2023, 10:40 AM #8Archived author: Lonk • Posted: 2023-06-05T10:40:53.561000+00:00
Original source
Oh, a drop with a 50/50 chance of being either 1 item OR another item was implemented using duplicated records?
Original source
50/50 of 1 questitem or 2 questitems was done with 2 records
rektbyfaith
06-05-2023, 10:42 AM #9Archived author: Tereneckla • Posted: 2023-06-05T10:42:29.322000+00:00
Original source
50/50 of 1 questitem or 2 questitems was done with 2 records
Original source
Just don't change the groupid
rektbyfaith
06-05-2023, 10:42 AM #10Archived author: Tereneckla • Posted: 2023-06-05T10:42:33.990000+00:00
Original source
Just don't change the groupid
1 Guest(s)
1 Guest(s)