Most recent edit on 2006-05-09 19:05:51 by SesmarAlaharnok
Additions:
Categories
CategoryDatabaseSchema
Edited on 2006-05-09 18:55:15 by SesmarAlaharnok
Additions:
A master list of all loot tables in the game. A loot table has information that dictates how much coin to drop, and what items have a chance to drop (as well as what that chance is). A mob is then assigned to a loot table thru its npc_types record.
Edited on 2006-05-09 18:54:30 by SesmarAlaharnok
Additions:
loottable
Schema as of 0.7.0
CREATE TABLE `loottable` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`mincash` int(11) UNSIGNED NOT NULL DEFAULT '0',
`maxcash` int(11) UNSIGNED NOT NULL DEFAULT '0',
`avgcoin` smallint(4) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
Edited on 2005-11-01 22:35:46 by FatherNitwit
Additions:
This field makes very little sense and prolly should not be used... it basically gives you between + and - 25% `avgcoin` number of each type of coins except plat if its greater than 0. Dont use it.
Deletions:
No one seems to know what this field does, and there are actually 0 loottables in the ProjectEQ database that use this field. Leave it set to 0 if you want a normal "pick an amount between mincash and maxcash" cash drop for your mob, as changing it from 0 will cause erratic results.
Edited on 2005-10-31 15:44:44 by Mystic414
Additions:
The minimum amount of cash the mob will drop when killed. An entry of "1" would set 1 copper as the minimum cash drop. An entry of "54321" would set 54 plat, 3 gold, 2 silver, 1 copper as the minimum cash drop. As far as I know, there currently is no way to make a mob drop more than 9 copper, silver, or gold at a time.
Deletions:
The minimum about of cash the mob will drop when killed. An entry of "1" would set 1 copper as the minimum cash drop. An entry of "54321" would set 54 plat, 3 gold, 2 silver, 1 copper as the minimum cash drop. As far as I know, there currently is no way to make a mob drop more than 9 copper, silver, or gold at a time.
Edited on 2005-10-30 23:18:04 by Mystic414
Additions:
The maximum amount of cash the mob will drop when killed. The format is the same as for mincash. When the mob spawns, the server generates a random value between the mincash and maxcash, and that random value is assigned to the mob's loot.
Deletions:
The maximum amount of cash the mob will drop when killed. The format is the same as for mincash. When the mob spawns, the server generates a random value between the mincash and maxcash, and the random value is assigned to the mob's loot.
Edited on 2005-10-30 23:17:14 by Mystic414
Additions:
This is not used in the server any place; it's just there to make the database more human-readable. Usually the loottable name is the same as the name of the npc(s) with the loottable, but it doesn't have to be.
Deletions:
This is not used in the server any place; it's just there to make the database more human-readable. Usually the loottable name is the same as the name of the npc with the loottable, but it doesn't have to be.
Oldest known version of this page was edited on 2005-10-30 23:16:04 by Mystic414 []
Page view:
ID:
The unique identifier for the loottable
Name:
This is not used in the server any place; it's just there to make the database more human-readable. Usually the loottable name is the same as the name of the npc with the loottable, but it doesn't have to be.
mincash:
The minimum about of cash the mob will drop when killed. An entry of "1" would set 1 copper as the minimum cash drop. An entry of "54321" would set 54 plat, 3 gold, 2 silver, 1 copper as the minimum cash drop. As far as I know, there currently is no way to make a mob drop more than 9 copper, silver, or gold at a time.
maxcash:
The maximum amount of cash the mob will drop when killed. The format is the same as for mincash. When the mob spawns, the server generates a random value between the mincash and maxcash, and the random value is assigned to the mob's loot.
avgcoin:
No one seems to know what this field does, and there are actually 0 loottables in the
ProjectEQ database that use this field. Leave it set to 0 if you want a normal "pick an amount between mincash and maxcash" cash drop for your mob, as changing it from 0 will cause erratic results.
