Quest Issue: [Consolidated] Selling Quest Loot Yields No Coin

[Autotune]

Originally Posted by Uthgaard [You must be logged in to view images. Log in or Register.]

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]

Originally Posted by Frako [You must be logged in to view images. Log in or Register.]

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.

[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?

[Chanus]

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

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