Thread: New loot system
View Single Post
  #77  
Old 12-15-2012, 02:24 AM
Secrets's Avatar
Secrets
Demi-God
 
Join Date: May 2007
Location: b
Posts: 1,450
Default

You are dropping probability and then re-adding it. Meaning you have a 100% chance to get every single loot drop.

Simply do not run the last two queries:

Quote:
alter table loottable_entries drop `probability`;
Affected rows: 23935
Time: 0.040ms

[SQL] ALTER TABLE `loottable_entries` ADD `probability` FLOAT NOT NULL DEFAULT '100';
Affected rows: 23935
Time: 0.050ms
It's causing them to be fubared as a result.

edit: read cavedude's post. it will fix things!

Last edited by Secrets; 12-15-2012 at 02:29 AM.. Reason: read cavedude's post
Reply With Quote