Planar Protector
Join Date: Jun 2010
Location: Auburn, AL
Posts: 2,470
|
|
Quote:
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:
Code:
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)
__________________
Quote:
Originally Posted by Sirken
I like to ninja edit people's Sigs.
|
|