[Consolidated] Selling Quest Loot Yields No Coin

[Chanus]

It seems there are several threads popping up about what appears to be the same issue:

http://www.project1999.org/forums/showthread.php?t=24053

http://www.project1999.org/forums/showthread.php?t=24112

http://www.project1999.org/forums/showthread.php?t=23998

http://www.project1999.org/forums/showthread.php?t=24029


Apparently if you receive items from a Quest turn in and try to sell them to a vendor, you get the "You receive X monies for your Y" message but you don't actually get any of the coin. Apparently zoning does not make the coin appear in your inventory either.

As I haven't noticed an official response in any of the threads yet, I figured consolidating them and making one thread to follow might be easier.

[Chanus]

Specific Reported Instances:


* Bronze weapons returned from handing in Bandit Sashes in South Qeynos (Chesgard Sydwen : -297, -493?)
* Armor and Items received from turning in Aviak Chick Talons in North Kaladim (Bumle Reminjar : 1389, 133)
* Armor and Items received from turning in Bone Chips in North Kaladim (Gunlok Jure : 1312, 157)
* Armor and Items received from turning in Crushbone Belts in South Kaladim (Canloe Nusback : -22, 534)
* Cash from handing in Concordance of Research in North Karana (Myrsila : 2095, -1200)
* Cash from handing in Concordance of Research in South Ro (Smith Tv'Ysa : 100, 500)
* Rusty Two-Handed Sword from turning in Lizard Meat in Oggok (Soonog : loc? Shadowknight GM)

[Uthgaard]

This is already fixed, just wait for the update.

[Chanus]

Oh, okay. Thanks :)

[Rynada]

I will wait for the update to fix this issue, however I have another issue that may or may not be related to this. I have also had the issue that I purchased an item and didn't receive that item but instead received a different item in its place. Such as purchasing a ring mail bracer and getting a cloth bracer instead.

[dreco]

When is the update?

[Timzilla]

When is the update?

Hopefully soon. This is game breaking for us noobis.

[Siledan]

Didn't read all the posts in all the threads, so this might have been mentioned already...
The bug also seems to apply to anything purchased from a vendor. Didn't test it a lot, but did buy a smattering of random things and try to sell them back, with no coin increase.

[Fohsap]

So, is there any place to apply for reimbursement? :( When's the patch? This post is over a week old, you know?

[Rubyt]

hey that happened to me yesterday buying from a vendor...I thought I had hit the wrong item so had to buy it again...it took the same amount twice so had hit the right one. nothing else around it was the same price.

[Rynada]

Tried to purchase a rusty Rapier at the highpass merchant today and I got ripped off for 75pp and did not even receive the item. This BUG has to be fixed. New people can NOT afford to lose money. I sent a petition hopefully I can get reimbursed before i hit the level to buy spells, cause now that the game ripped me off I can't afford to buy them.

[Fohsap]

It seems, thus far, that reimbursement is anything but important. One of my guildees has been waiting for the GM's to credit him with a response for a very long time. As for me, it's been several days. It also destroys the quest. By the time it's REALLY fixed, I'll be out of the range for which the quest is even useful.

Well, someone once told me it helped to bump a post every day. I'll do that and see if it works. That 250 plat was my life's savings on two of my other characters. :-/

[Chanus]

Yesterday, I sold backpacks to a merchant and didn't receive coin. These weren't items I had received from a quest turn-in, though I did acquire them by the old find a quiet corner and drop, then log on the other character and retrieve method. If it would be helpful, it's the two characters in my sig. Faeala bought the backpacks, Aurean sold them.

Just making sure this is all part of the same bug (since the source of the items was different than before), and not some new problem.

Also, hoping against hope for an ETA on the fix update. :P

[Uthgaard]

Updates are generally unannounced. It's really a combination of having enough worth patching onto the main server, and Rogean having the time to patch it. I'm sure he makes it look easy since there's never more than 20 mins of downtime, but it takes him a lot more time than that to get everything ready and do it.

[Chanus]

Makes sense. Thanks for the response!

[Fohsap]

Well, it's really some bullshit, man. Me and three of my friends quit playing because of the loss. Totally screwed us and our guild over and left us very frustrated. It's supposed to be a fun fantasy game, but the in-game GM's are apparently too lazy to reimburse, and the forum GM's don't even respond. No one repays what the glitches take, and there's no warning other than reading every bug in the forum, apparently. How hard would it be to change the NPC text to say: "Warning: quest items will not be resold," I wonder? I bet it's actually not a lot more work than most of us think. I bet it's a matter of changing the NPC's text. And there's nothing classic about getting ripped off at every damned quest merchant. I played classic for years on live and never had it happen even once. I'd think a game-wide ERROR/'huge fucking glitch' causing a gigantic fucking in the economy would be a PRIORITY. If it's already in the next patch... seal the freegin deal, man! And start reimbursing people for God's sake!!!!

[Uthgaard]

Yeah man, it's some total fucking bullshit!

Because it's not like I already said this:

It shows up in the logs when an item is sold for no money. I've got a query prepared to run during the next patch that will take everyone who has sold an item for no value, total up the amount lost, and add that to your bank's copper slot.

And didn't go out of my way to do this:


CREATE TABLE bugfix as
SELECT
character_.id AS CharID,
eventlog.charname AS Charname,
(ascii(mid(profile, 4749, 1)))+(ascii(mid(profile, 4750, 1))*256)+(ascii(mid(profile, 4751, 1))*65536)+(ascii(mid(profile, 4752, 1))*16777216) as bankcopper,
SUM((SUBSTRING(description, 7, 2)*items.price)) AS TotalLost,
REVERSE(CHAR(((ascii(mid(profile, 4749, 1)))+(ascii(mid(profile, 4750, 1))*256)+(ascii(mid(profile, 4751, 1))*65536)+(ascii(mid(profile, 4752, 1))*16777216)+SUM((SUBSTRING(description, 7, 2)*items.price))))) as newstring,
LENGTH(REVERSE(CHAR(((ascii(mid(profile, 4749, 1)))+(ascii(mid(profile, 4750, 1))*256)+(ascii(mid(profile, 4751, 1))*65536)+(ascii(mid(profile, 4752, 1))*16777216)+SUM((SUBSTRING(description, 7, 2)*items.price)))))) as strlength
FROM
eventlog
Inner Join character_ ON eventlog.charname = character_.name
Inner Join items ON LTRIM(SUBSTRING(description, 40, 8))= items.id
WHERE `event_nid` = '3' AND LTRIM(SUBSTRING(description, 29, 3)) = '0'
GROUP BY CharID

UPDATE
`character_`
INNER JOIN `bugfix` ON `character_`.`id` = `bugfix`.`CharID`
SET `character_`.`profile` = REPLACE(`character_`.`profile`, mid(profile, 4749, `bugfix`.`strlength`), `bugfix`.`newstring`)


[09:48] {Rogean} It's in the character blob, not easily extracted and almost impossible to edit from mysql directly
[15:30] {Rogean} I told you.. getting the variables formatted and extracted was the easy part.. its probably impossible to actually modify the values in the binary blob without corrupting the character
[15:30] {Rogean} you need a program to do it

You're damn lucky anyone was even willing to try to do it.

For the record, it's easier to pretend you left the server in a fit of erroneous self-righteous retardation if you actually leave. More than happy to assist you with that if you can't figure it out. Server runs much smoother without prima donnas prancing around being bitches like this is Walmart's Customer Service Department.

[Fohsap]

Look at my account. I did leave the server. No self-righteous bullshit. Also, my friends left it. We're all butthurt about it, and it's totally understandable. Someone responded to this thread recently, so I submitted an additional response. This has got to be the worst bug I've ever seen in any game, ever, Uthgarr.

And as for your already having said it: I'm not stalking you. Do some PR to cool the heads. You let people get pissed off and stay pissed off for months at a time. That shit ain't right. I don't know what you said when and where and whatever, and it's not my responsibility to. I'm trying to relax. I just feel like..., if it's patched already..., then upload the patch already! Because the coding must be very complex..., but come on.... Is uploading the patch really all that difficult? My programming experience tells me that that must be the easiest part. It's got to be 1 to 4 lines of code that you've done 10,000 times. Whatever whatever. The point is: this is a very important patch.

[Fohsap]

And hey man, what about interest?

[Fohsap]

Server runs much smoother without prima donnas prancing around being bitches like this is Walmart's Customer Service Department.

Here's the thing.... It's a fantasy game, but when I log on I have to deal with non-fictional problems: a fucked up economy, asshole support guys who bitch about work and have no people skills, fighting, the IT industry prioritizing feedback and design, the lack of community. The entertainment industry in America sucks and where I live 90% of the people are crack heads. Every one of my coworkers does meth on their break, and I end up carrying the load for my entire company. Log in and my guild wants me to do all the trade skills with no money and no quest loot. You guys are fucking assholes, dude. You don't deserve any praise. You've got a fucking 15-line script that you haven't applied... That probably took you an hour to write! You could have paid an Indian or a Middle Easterner or an African to do it for 5 bucks, or you could have done in the good old fashion US way for 35. Big deal. We're splitting pennies, and your user base is being owned in the meantime. You could have put a message out to prevent people from walking into the kind of traps that cost them everything they own, but apparently you never played the game to the extent that you understood what people invested in. Don't call me a fucking prima dona because I'm doing you a huge favor by sending feedback to YOUR COMPANY. This is my free time, and you're at work on an investment, bro. In other words, I'm paying you. You know, when someone steps into my cab and says: "Hey, it's a little dirty back here," I don't say: "Fuck you, you self-righteous prick." I say, "Thank you, sir." And I get a tip from them, then I clean my cab and get a tip from the next guy. It's not about whose insult is the best. I'm trying to help you out. Why did I uninstall? Because you fucking take 3 months to write 15 lines of code. Why did my friends uninstall? Because you take 3 months to write 15 lines of code. If you know about a major bug that's fucking up the whole economy and destroying major sections of the game, broadcast a daily message! Fix it! Make it a sticky post! Put it in the MOTD on IRC! Do something to prevent people from slitting their own throats again and again and again! Realize that you've got 20 different threads, several posts each, with the same issue... PROBLEM! And 20 DEDICATED customers is better than 500 hit-and-miss customers. 20 people who think you suck and don't know how an issue tracker works and are going to insult them every time they submit feedback are going to be nothing but poison. You should be kissing my fucking short and curlies, man. This is good shit, and you really need to figure it out at some point.

[Chanus]

It's not an investment, dipshit. It's a volunteer hobby.

[Gorgetrapper]

Here's the thing.... It's a fantasy game, but when I log on I have to deal with non-fictional problems: a fucked up economy, asshole support guys who bitch about work and have no people skills, fighting, the IT industry prioritizing feedback and design, the lack of community. The entertainment industry in America sucks and where I live 90% of the people are crack heads. Every one of my coworkers does meth on their break, and I end up carrying the load for my entire company. Log in and my guild wants me to do all the trade skills with no money and no quest loot. You guys are fucking assholes, dude. You don't deserve any praise. You've got a fucking 15-line script that you haven't applied... That probably took you an hour to write! You could have paid an Indian or a Middle Easterner or an African to do it for 5 bucks, or you could have done in the good old fashion US way for 35. Big deal. We're splitting pennies, and your user base is being owned in the meantime. You could have put a message out to prevent people from walking into the kind of traps that cost them everything they own, but apparently you never played the game to the extent that you understood what people invested in. Don't call me a fucking prima dona because I'm doing you a huge favor by sending feedback to YOUR COMPANY. This is my free time, and you're at work on an investment, bro. In other words, I'm paying you. You know, when someone steps into my cab and says: "Hey, it's a little dirty back here," I don't say: "Fuck you, you self-righteous prick." I say, "Thank you, sir." And I get a tip from them, then I clean my cab and get a tip from the next guy. It's not about whose insult is the best. I'm trying to help you out. Why did I uninstall? Because you fucking take 3 months to write 15 lines of code. Why did my friends uninstall? Because you take 3 months to write 15 lines of code. If you know about a major bug that's fucking up the whole economy and destroying major sections of the game, broadcast a daily message! Fix it! Make it a sticky post! Put it in the MOTD on IRC! Do something to prevent people from slitting their own throats again and again and again! Realize that you've got 20 different threads, several posts each, with the same issue... PROBLEM! And 20 DEDICATED customers is better than 500 hit-and-miss customers. 20 people who think you suck and don't know how an issue tracker works and are going to insult them every time they submit feedback are going to be nothing but poison. You should be kissing my fucking short and curlies, man. This is good shit, and you really need to figure it out at some point.

You should ask for your monthly subscription back bro.

[Slugga]

Shady Swashbuckler ====> brutechopper
Boomba the Big ====> Large round Shield looted from troll guards.

[AQuebman]

While I like everybody else hope to see a fix implemented soon you need to relax. This is free if you didnt expect bugsmyour an idiot. I have seen worse from dumbshits at SoE and they get $15 a month for their garbage. Just enjoy the game it effects everyone therefore the economy will fluctuate equally. Its not like they cock blocked you specifically from selling your loot.

Go play WoW and cry in Barrens chat about the free emulated eq server.

[Mazoku]

Today (Wednesday February 2nd) at approximately 12pm, I lost about 5 plat in gold to Handaaf Orcslicer in Kaladim. He did not give any money for any of the 7 bags of tattered armor I sold to him after turning in some belts. Please fix this bug asap. I have also lost about 40 plat from Chesgard in Qeynos when I was turning in sashes and selling the bronze weapons.

Thanks

[h0tr0d (shaere)]

I sold normal loot to Shady today, and received no coin in return.

[Dylanesis]

My first post on these forums, just popping in to say that this bug is still happening. I sold all my loot from turning in Gnoll Fangs in Halas and received no coin at all.

It's kind of annoying since those sales add up and are part of the value of the quest. Any word on the "update" that is mentioned on the first page of this thread?

[Bilderan]

Sold Spirit of the Bear Spell after turning Barbarian head into Margyn McCann in Halas. Says I got 1p 8g, but never received it.

[Bilderan]

Sold Concordance of Research for what says 9p 4g 1s 3c but am not receiving money.

[Gorgetrapper]

Everyone will be reimbursed when the patch goes in, just keep on selling.

[Bilderan]

Really, just poof money is there?

[Gorgetrapper]

http://www.project1999.org/forums/showpost.php?p=202200&postcount=7

[Autotune]

Yeah man, it's some total fucking bullshit!

Because it's not like I already said this:



And didn't go out of my way to do this:


CREATE TABLE bugfix as
SELECT
character_.id AS CharID,
eventlog.charname AS Charname,
(ascii(mid(profile, 4749, 1)))+(ascii(mid(profile, 4750, 1))*256)+(ascii(mid(profile, 4751, 1))*65536)+(ascii(mid(profile, 4752, 1))*16777216) as bankcopper,
SUM((SUBSTRING(description, 7, 2)*items.price)) AS TotalLost,
REVERSE(CHAR(((ascii(mid(profile, 4749, 1)))+(ascii(mid(profile, 4750, 1))*256)+(ascii(mid(profile, 4751, 1))*65536)+(ascii(mid(profile, 4752, 1))*16777216)+SUM((SUBSTRING(description, 7, 2)*items.price))))) as newstring,
LENGTH(REVERSE(CHAR(((ascii(mid(profile, 4749, 1)))+(ascii(mid(profile, 4750, 1))*256)+(ascii(mid(profile, 4751, 1))*65536)+(ascii(mid(profile, 4752, 1))*16777216)+SUM((SUBSTRING(description, 7, 2)*items.price)))))) as strlength
FROM
eventlog
Inner Join character_ ON eventlog.charname = character_.name
Inner Join items ON LTRIM(SUBSTRING(description, 40, 8))= items.id
WHERE `event_nid` = '3' AND LTRIM(SUBSTRING(description, 29, 3)) = '0'
GROUP BY CharID

UPDATE
`character_`
INNER JOIN `bugfix` ON `character_`.`id` = `bugfix`.`CharID`
SET `character_`.`profile` = REPLACE(`character_`.`profile`, mid(profile, 4749, `bugfix`.`strlength`), `bugfix`.`newstring`)




You're damn lucky anyone was even willing to try to do it.

For the record, it's easier to pretend you left the server in a fit of erroneous self-righteous retardation if you actually leave. More than happy to assist you with that if you can't figure it out. Server runs much smoother without prima donnas prancing around being bitches like this is Walmart's Customer Service Department.


You know... I really think i have a crush on Uthgaard sometimes... (borderline homo)

[Frako]

I hate to nag especially cause its a free server and you guys did such good work tough will the patch come anytime soon its hard for us newbies to get any decent gear if half of our money goes poof.

I must have at least 500 plats missing and waiting to be returned from all the rewards from the gnoll fangs and the chain male and bronze weapons i sold.

[CanadianTSi]

I hate to nag especially cause its a free server and you guys did such good work tough will the patch come anytime soon its hard for us newbies to get any decent gear if half of our money goes poof.

I must have at least 500 plats missing and waiting to be returned from all the rewards from the gnoll fangs and the chain male and bronze weapons i sold.

x2

[Frako]

I was under the impression that when this gets fixed we get our money back, the bug seems fixed tough im still as poor as a curch mouse.

[Uthgaard]

Remind Rogean to run the query while the server is down next time.

[parlay1]

Ya, the bug is fixed but no plat reimbursed.

[Uthgaard]

Everyone should have their coin now. Rogean and I worked very hard on making sure this went in correctly while people threw fits about the server not being up at their expected time (http://www.project1999.org/forums/showthread.php?t=29246&page=2). You're welcome.