Bug 148: (zippyzee) Coin Required on Free Items

[BugTracker]

Bug ID       : 148 - Coin Required on Free Items 
Bug Date     : 2015/03/18 02:29:32
Assigned To  : zippyzee
Priority     : Low

Category     : VGClient
Sub-Category : Gameplay: Other
Severity     : Minor (e.g. Cosmetic)
Reproducible : Every time

Details:
I can't buy some of the items on the brokers even though they are listed a 0cp. I gave myself some money and was able to buy the items, even though they were 0cp. My finances didn't change after buying these items.

Originated From World: New Telon (1)
Chunk                : Khal (85)
Location             : 1605 -51836 1278

[John Adams]

This one kind of appeared out of nowhere. Did we start checking available coin? I know Trainers deduct coin, but Broker items never did. And, broker items are 0cp anyway, so that's a double whammy.

(btw, I don't like the term "money", just bothers me hah so I'll probably change all references to "coin")

[Xinux]

What items could not be bought i just bought about 30 items with no issues.

[Moldew]

I don't remember exactly which ones they were, but I suspect the swampphibian, maybe red riding leopard. When searching for mounts right now, many are missing - it only shows up to lvl 50 mounts, swampphibian is lvl 55. Some of the lvl 50 mounts are missing as well.

Searching for leopard for instance on exchange gives no results.

The swampphibian and red riding leaopard I have in my inventory right now show durabilities of -2147483648%!

[Xinux]

Ok so right now level is being sorted by required level is it suppose to be required level of the item or the item level itself?

Most of the 50+ mounts are required level 40 so for level they would be listed in the level 40 range.

[Moldew]

Hmm...swampphibian is a lvl 55 item, and requires lvl 55 to equip. Searching for lvl 55 mounts comes up with nothing, as well as searching for "swampphibian."

For that matter, just search for lvl 50-60 mounts, and you only come up with 3 items.

[Apaelias]

Also cannot get any of the normal griffons from the vendor. Only the Shimmer and the store bought/crate one.

[Xinux]

Not sure why on NT you are only getting 3 when i do the same query on my local box i get 64 results.

[John Adams]

Weird since we're using the same code, and far as I know your Items table data is from NT (vgo_world.sql)