DB fixes ongoing (UPDATE)

Thanks to a lot of changes to the PK website, a lot of my background scripts inserted a lot of wrong values into the database, and as usual for swag items, those names change periodically which needs to be fixed manually to be able to present a long term plot for an item.

Also the hat statistics stopped a few days ago, all the tables are a mess now, although the scripts are already fixed. Lets see tomorrows values.

Another fix has been done to the dungeons subpage, which now calculates with actual refined oil prices, instead of “old” oil prices, as this item was renamed long time ago.

Hopefully all will be fine soon, and I got another page coming soon. This time for kingdoms.

UPDATE:
Matrix Calculator did show slightly wrong values compared to the front page, due to out of order database updates in a background job.

(moved back from PHP to Perl in these jobs, as PHP has trouble getting the correct SQL order (Command out of sync), don’t know why (Yes I do free results correctly). If you are an SQL expert, please contact me on how to get multiple queries which I do in scripts, into a single database procedure. Basically it’s: For all unique items get actual food and gold price and amounts, and the same of 24hours before and store all together in its own table, add or update if exists. Sounds easy.)