AzurysCO - Maybe something different?

07/28/2008 14:09 KraHen#1

pie

07/28/2008 14:22 scottdavey#2

No point starting work unless you solved crashes and login freeze.

PS.

Quote:

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /.

Reason: Error reading from remote server

Thats your website for me.

07/28/2008 15:15 KraHen#3

That`s something to do with DOT.TK, try [Only registered and activated users can see links. Click Here To Register...]

07/28/2008 16:20 scottdavey#4

No offence but it will fail unless the problems are fixed

07/28/2008 16:29 nTL3fTy#5

I was looking at the top players page and noticed a GM was accounted for most CPs. I don't see that being too fair, but maybe an error on your part. You can use this SQL query to select, order, and limit the results to normal players only.

Silvers ordered from greatest to least, with 20 maximum results:

Code:

SELECT `CharName`,`Money` FROM `characters` WHERE (`Account` NOT IN(SELECT `AccountID` FROM `accounts` WHERE `Status`=8) AND `Money` > 0) ORDER BY `Money` DESC LIMIT 20;

CPs ordered from greatest to least, with 20 maximum results:

Code:

SELECT `CharName`,`CPs` FROM `characters` WHERE (`Account` NOT IN(SELECT `AccountID` FROM `accounts` WHERE `Status`=8) AND `CPs` > 0) ORDER BY `CPs` DESC LIMIT 20;

Very easy query, can be suited to fit your needs/wants easily.

07/28/2008 16:39 KraHen#6

lol