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)