[DiscordArchive] Is there an easy way to add an item that all creatures in the game can drop?
[DiscordArchive] Is there an easy way to add an item that all creatures in the game can drop?
Original source
Is there an easy way to add an item that all creatures in the game can drop?
rektbyfaith
08-24-2023, 05:55 AM #1Archived author: z3rodown • Posted: 2023-08-24T05:55:44.799000+00:00
Original source
Is there an easy way to add an item that all creatures in the game can drop?
Original source
youd have to modify the creature_loot_template database
rektbyfaith
08-24-2023, 06:21 AM #2Archived author: thebigclamp • Posted: 2023-08-24T06:21:23.224000+00:00
Original source
youd have to modify the creature_loot_template database
Original source
this is the name in your databse editor of choice. in the entry column you select the lootID of the creature you want to add the item to, the lootID is typicall the same as the creatures ID but doublecheck if it doesnt work, the lootID can be found increature_template database shown in the second screenshot.
second column is what item you want it to drop denoted with its itemID such as "1" for martin fury.
third column is the reference to a item pool where it is found in, i dont know how that works so leave it as a zero.
fourth column is the % chance to drop (so the number 40 = 40% chance and the number 0.1 = 0.1% chance to drop)
quest required should be left at 0 unless you want it to only drop when a player has a specific quest
lootmode leave it at 1
groupID leave it at 1
the two columns after is variance of items dropped. between the first and second column of items can drop in this case
last column is a comment to explain what you added (for example the third image)
![[Image: image.png?ex=690c4014&is=690aee94&hm=0d5...c856a2233&]](https://cdn.discordapp.com/attachments/284406375495368704/1144156290164195360/image.png?ex=690c4014&is=690aee94&hm=0d5a62e14b354098fc3aeb9a22d1e7f346ac166398da7e5cd9f8571c856a2233&)
![[Image: image.png?ex=690c4015&is=690aee95&hm=831...4d4c27aeb&]](https://cdn.discordapp.com/attachments/284406375495368704/1144156290432638976/image.png?ex=690c4015&is=690aee95&hm=83188469f354e3f2a0899660dbe298ae206da895bff839e5538cb244d4c27aeb&)
![[Image: image.png?ex=690c4015&is=690aee95&hm=75b...3d7e1a8cd&]](https://cdn.discordapp.com/attachments/284406375495368704/1144156290751397929/image.png?ex=690c4015&is=690aee95&hm=75b5a84676f260efe91a897204ba27e3cae92deb58ed6819ec29b353d7e1a8cd&)
rektbyfaith
08-24-2023, 06:28 AM #3Archived author: thebigclamp • Posted: 2023-08-24T06:28:37.177000+00:00
Original source
this is the name in your databse editor of choice. in the entry column you select the lootID of the creature you want to add the item to, the lootID is typicall the same as the creatures ID but doublecheck if it doesnt work, the lootID can be found increature_template database shown in the second screenshot.
second column is what item you want it to drop denoted with its itemID such as "1" for martin fury.
third column is the reference to a item pool where it is found in, i dont know how that works so leave it as a zero.
fourth column is the % chance to drop (so the number 40 = 40% chance and the number 0.1 = 0.1% chance to drop)
quest required should be left at 0 unless you want it to only drop when a player has a specific quest
lootmode leave it at 1
groupID leave it at 1
the two columns after is variance of items dropped. between the first and second column of items can drop in this case
last column is a comment to explain what you added (for example the third image)
Original source
so you can just make a simple script to programmatically add a new row for each creatures lootID with say (lootID, [item number], 0, 100, 0, 1, 0, 1, 1, test)
so itd look something like
INSERT INTO creature_loot_template (Entry, Item, Reference, Chance, QueatRquired, LootMode, GroupId, MinCount, MaxCount, Comment)
Values (VariableCreatureID[i], '37401', '0', '1', '0', '1', '1', 'Red sword of curage for creatureID')
and loop this query for each valid creatures lootID and i variable here would be the loop iterator of a array with all lootIDs that you queried earlier
rektbyfaith
08-24-2023, 06:37 AM #4Archived author: thebigclamp • Posted: 2023-08-24T06:37:32.368000+00:00
Original source
so you can just make a simple script to programmatically add a new row for each creatures lootID with say (lootID, [item number], 0, 100, 0, 1, 0, 1, 1, test)
so itd look something like
INSERT INTO creature_loot_template (Entry, Item, Reference, Chance, QueatRquired, LootMode, GroupId, MinCount, MaxCount, Comment)
Values (VariableCreatureID[i], '37401', '0', '1', '0', '1', '1', 'Red sword of curage for creatureID')
and loop this query for each valid creatures lootID and i variable here would be the loop iterator of a array with all lootIDs that you queried earlier
Original source
i do have a question about realms. how do i change the realmtime? ive chagned the databases realmtime from 1 to 9 but it doesnt actually change the time neither live nor on restart. when restarted the default value of 1 for timezone is set again
rektbyfaith
08-24-2023, 06:51 AM #5Archived author: thebigclamp • Posted: 2023-08-24T06:51:42.642000+00:00
Original source
i do have a question about realms. how do i change the realmtime? ive chagned the databases realmtime from 1 to 9 but it doesnt actually change the time neither live nor on restart. when restarted the default value of 1 for timezone is set again
1 Guest(s)
1 Guest(s)