The Daily Click ::. Forums ::. Daily Click ::. gotta ask the little question ;)
 

Post Reply  Post Oekaki 
 

Posted By Message

ShadowCaster

Possibly Insane

Registered
  02/01/2002
Points
  2203
4th June, 2004 at 22:29:01 -

That's harder to come up with because the size field in the database is text, not numerical. So, for example, 4, 40, 400, 4000 are all displayed together because they order logically when they are sorted as text.

I could do it with a script, but I cant be bothered

Mike

 
"Now I guess we're... 'Path-E-Tech Management'" -Dilbert

Buster

BLING COMMANDER

Registered
  03/06/2002
Points
  1545

VIP Member
4th June, 2004 at 23:30:41 -

whats the biggest game?

 

Tigerworks

Klik Legend

Registered
  15/01/2002
Points
  3882
5th June, 2004 at 06:36:17 -

Can't SQL order by the longest length of string?
Or alternatively you could write a quick script to get the size as number off each download to find the biggest.

 
- Tigerworks

ChrisB

Crazy?

Registered
  16/08/2002
Points
  5457
5th June, 2004 at 07:52:30 -

Can't you do

SELECT id, name, blah FROM tdcdownload ORDER BY CAST(downloadsize AS SIGNED) ASC LIMIT 100

Or something similar?

 
n/a

Kris

Possibly Insane

Registered
  17/05/2002
Points
  2017
5th June, 2004 at 08:15:10 -

or you could change the database

also you can probably get the minimum size of the exe below 300kb if you use UPX or something

Image Edited by the Author.

 
"Say you're hanging from a huge cliff at the top of mt. everest and a guy comes along and says he'll save you, and proceeds to throw religious pamphlets at you while simultaniously giving a sermon." - Dustin G

Tigerworks

Klik Legend

Registered
  15/01/2002
Points
  3882
5th June, 2004 at 11:54:04 -

SQL might give an error trying to cast the string "100kb" to a number as it has non-numerical characters, but it depends how SQL and the DC database work. Worth a try.

 
- Tigerworks

Joe.H

Evil Faker

Registered
  19/08/2002
Points
  3305
5th June, 2004 at 13:52:23 -

make an array using the string length of each size, then re-order it.

I'd say one of the biggest games would be The Last Resurrection, seeing as it is/was around 40MB i think.

 
My signature is never too big!!!

juraj or



Registered
  21/05/2004
Points
  107
6th June, 2004 at 04:29:22 -

no!

I think there was a kung fu game (or something like that, I know it's fight) where guy recorded his friend doing some moves, and then he implemented them in his game.

the game was about 50 megs(not smaller, I think it's a bit larger than 50mb)

 
-

AsparagusTrevor

Mine's a pint of the black stuff

Registered
  20/08/2002
Points
  2364

Game of the Week WinnerHas Donated, Thank You!VIP MemberEvil kliker
6th June, 2004 at 13:33:07 -

Deadly Tournament?

 
Image

Keatonian



Registered
  15/07/2002
Points
  571
6th June, 2004 at 16:54:02 -

I'm just curious:
"gotta ask the little question"

Are you implying you ask this often or are
you implying the question is about being little?

Image Edited by the Author.

 
-Above post is ancient and probably irrelevant-

An old account of mine, recently cleared out. It's a blast to the past, the age was marked as 14 when I found it. If you know where to look, you can track me. Au revoir.

juraj or



Registered
  21/05/2004
Points
  107
7th June, 2004 at 11:51:41 -

"Are you implying you ask this often or are
you implying the question is about being little?"
(I'm lazy, I can't press quote )

f*ck it, I just put that word because I was drugged

kidding, I don't know why I've put it.




 
-
   

Post Reply



 



Advertisement

Worth A Click