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

[Uthgaard]

Yeah man, it's some total fucking bullshit!

Because it's not like I already said this:

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

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]

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

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.

[Gorgetrapper]

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

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.

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