Project 1999

Go Back   Project 1999 > Server Issues > Resolved Issues

Closed Thread
 
Thread Tools Display Modes
  #31  
Old 02-08-2011, 03:04 AM
Bilderan Bilderan is offline
Large Bat


Join Date: Jan 2011
Posts: 11
Default

Really, just poof money is there?
  #32  
Old 02-08-2011, 08:23 AM
Gorgetrapper Gorgetrapper is offline
Fire Giant


Join Date: Mar 2010
Posts: 703
Default

http://www.project1999.org/forums/sh...00&postcount=7
__________________
Quote:
Originally Posted by Rogean View Post
WOW GUYS THATS A HARD CONCEPT BUT NO I'M TOO FUCKING SELFISH AND NEEDY AND I NEED TO FIND A WAY AROUND THE RULES TO MAKE MYSELF FEEL BETTER

Seriously, every time I see a fucking thread like this OH MYGOD THEY HAD 14 PEOPLE ITS OUR MOB LOL OURS OURS OURS YESSS I just want to fucking deathtouch the entire guild and despawn the mob.
  #33  
Old 02-10-2011, 08:14 AM
Autotune Autotune is offline
Planar Protector

Autotune's Avatar

Join Date: Jun 2010
Location: Auburn, AL
Posts: 2,470
Default

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.
  #34  
Old 02-12-2011, 07:36 PM
Frako Frako is offline
Large Rat


Join Date: Feb 2011
Posts: 5
Default

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.
  #35  
Old 02-15-2011, 12:55 PM
CanadianTSi CanadianTSi is offline
Aviak


Join Date: Feb 2011
Posts: 78
Default

Quote:
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
  #36  
Old 02-21-2011, 01:50 PM
Frako Frako is offline
Large Rat


Join Date: Feb 2011
Posts: 5
Default

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.
  #37  
Old 02-26-2011, 01:18 AM
Uthgaard Uthgaard is offline
VIP / Contributor

Uthgaard's Avatar

Join Date: Aug 2010
Posts: 5,446
Default

Remind Rogean to run the query while the server is down next time.
  #38  
Old 02-26-2011, 04:45 AM
parlay1 parlay1 is offline
Kobold


Join Date: Jul 2010
Posts: 142
Default

Ya, the bug is fixed but no plat reimbursed.
  #39  
Old 03-13-2011, 06:41 AM
Uthgaard Uthgaard is offline
VIP / Contributor

Uthgaard's Avatar

Join Date: Aug 2010
Posts: 5,446
Default

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. You're welcome.
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:17 AM.


Everquest is a registered trademark of Daybreak Game Company LLC.
Project 1999 is not associated or affiliated in any way with Daybreak Game Company LLC.
Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.