All posts by kobaan

PK Trader hit by lightning stroke

Last night a lightning stroke killed my internet router,
I restored the connection using my old backup router.

Unfortunately the old router has no IPv6 capability,
which means the site is back on IPv4-only.

Since the IPv6 native router (Fritzbox 7390) was rather expensive,
donations are always welcome, please contact me if interested.

Yours,
Angry Minotaur.

PK Trader – only minor updates

Just a short note on a few PK Trader updates:

 

  • I try to keep track of city and kingdom development, but it turns out, that due to the fact that I can only lookup the published top ten, data will become more and more inaccurate over time. If you want to take a look yourself, see here: PK-Develop (this page might vanish, if no-one comes up with a brilliant idea)


  • a few more city additions from people who want the help me, thank you guys you do great.
  • new cities will be added on a weekly basis, feel free to download the spreadsheet with all known cities
  • the city directory now has a pager function, as tables got to long for some browsers, or mobile devices


  • we now have a Google+ and a Facebook like button on the right ==>


  • some forgotten swag weapons and armor finally found their way to the historic trading price search at Weapon and Armor

 

 

Gold price calculation fuzzy

Just a note, if you didn’t realize yet.

Don’t trust the gold price calculation on PK Trader for the moment since the latest PK update disabled the ability of cheap refined oil production.

Before the update, one could easily calculate the gold price from substracting the crude from the refined oil tradepostprice which gave you the value for one food.

1 food = (oilprice-crudeprice)-10% (TP tax) gold

Due to the fact that many cities are not yet able to produce refined oil (refineries need to be built now), the market price for refined oil runs away,
thus resulting in a unrealistic calculation of the real gold/food ratio.

I will not introduce a new gold/food calculation because I think we will be back to normal in a few weeks when refineries are rebuilt, and not so many product chains need gold/food prices for their calculation.

AND: There’s a new update to the city directory enabling you to quicksearch for a city.

Stay tuned,
AngryM.

Denial of Service against PK Trader

If you wonder why PK Trader gets so slow in the last 8 hours, that’s because someone from Olathe, Kansas, USA, is hitting the server with multiple requests per second, seems like a senseless denial of service. I thought that for such a game and all information provided for free on this site, I would not need to take counter measures.

I’m blocking this single IP for now, and will get some ratelimiters in place,
let’s see how it looks tomorrow.

Yours AngryMinotaur.

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.)

PK Emerald and Pearl Update

Finally, as mentioned in the latest update hut article, the 30 level cap has been increase to 35, there is a new water dungeon in sunken cities now,
and a few more new basic resources such as emeralds, khaos orb, pearls and more which can be used to craft some new products too.

New content has been added to PK Trader product chain browser already, actual prices and plots will take some time, as no trading prices are yet available to calculate with.

A few new items:
khaos_orb Khaos Orb
gravity_trap Gravity Trap
gillens_brew Gillen’s Brew
time_orb Time Orb
spatial_bubble Spatial Bubble

Tome of Oil + Reconstrcution
tome_of_oil tome_of_reconstruction

Pearl, Emerald and Gem Dust
pearl emeraldgem_dust

Emerald and Pearl Flag Decoration
flag_emerald flag_pearl

Emerald Tiki and Emerald Asscher – Exterior Decoration
gmo_ext_dec_emerald_courtyard gmo_ext_dec_emerald_outside


Pearl Beach Chair and Pearl Shell – Exterior Decoration
gmo_ext_dec_pearl_outdoor_chair gmo_ext_dec_pearl_shell


PK City Directory online

Finally a new addition to PK Trader has found its way to the website, the PK City Directory.

citydirectory
For those of you willing to help, please submit citycodes for yet unlisted cities with the form below of the PK City Directory subpage.

You can find the citycode when you visit PK’s official forum and by clicking on yours or other peoples profiles and selecting their cities.
Your browser then shows an URL link like: http://www.parallelkingdom.com/City.aspx?cityid=Cty11000000000172351
The latter part can be typed into the PK City Directory and SEND to be added instantly to the database.

Thanks for everybody who supports me getting as many city links as possible. Thank you.

Fixes and world time line

  • popeye hat resources fixed (amount calculation of wood and crude were swapped)
  • As you might have noticed there now is a world time line on the top of each page, maybe making it easier for all of you to check against PK Update Hut messages about when updates occur at your local timezone.
  • And finally another subpage was added which splits the original tradepost data table into a sortable gold/food and leveled/normal items table. Further on the sidebar of this new tradepost subpage, you can now find the most active tradeposts listed.


Top Tradeposts:

(USA)
(Others)
Happy Valley New York City Commerce West Hollywood Dowagiac Gulf Park Estates Chicago Pittsburgh Wekiwa Springs Detroit Grand Rapids
London (UK) Tokyo (Japan) Fort Erie (Canada) Köln (Germany) Dharan Bazar (Nepal) Gex (France) Darch (Australia) Luganville (Vanuatu)