View Single Post
  #1  
Old 07-18-2010, 12:07 PM
Irreverent
The Solo Server
 
Join Date: May 2007
Posts: 416
Default FIXED: Forage issues

As a result of changes done awhile ago in the forum logic, you need to have the sum of your forage per zone be <= 100. Current database loads all chances at 100% on each item. So you will only get the first rare ever from a forage attempt.

Here is the code to check and make sure nothing is > 100% for an entire zone:
Code:
select * from forage where zoneid in (select zoneid from forage group by zoneid having sum(chance) > 100) order by zoneid
You'll need to then adjust them accordingly so that they sum up to <= 100
__________________
OP of Irreverent Server (The Solo Server)
Our Forums
Reply With Quote