Old 12-7-2010, 04:01 AM   #1
lxDestinyxl
FFR Player
FFR Veteran
 
Join Date: Mar 2006
Posts: 3,247
Send a message via AIM to lxDestinyxl
Default Column title sorting

Is it too much to ask to allow the FFR Song List page to sort by 'style'?
http://www.flashflashrevolution.com/...s/FFRSongs.php

It will help immensely.
Thanks.
__________________
lxDestinyxl is offline   Reply With Quote
Old 02-19-2011, 12:48 AM   #2
Sprite-
HAVE ME WITH VODKA
Retired StaffFFR Simfile AuthorFFR Veteran
 
Sprite-'s Avatar
 
Join Date: Aug 2005
Location: Long Island, New York
Age: 35
Posts: 7,316
Default Re: Column title sorting

Done. Sort by date can also be done now.
Sprite- is offline   Reply With Quote
Old 02-19-2011, 12:56 AM   #3
duddychuck@yahoo.com
Retired
FFR Veteran
 
duddychuck@yahoo.com's Avatar
 
Join Date: Sep 2009
Posts: 1,111
Send a message via AIM to duddychuck@yahoo.com Send a message via MSN to duddychuck@yahoo.com Send a message via Yahoo to duddychuck@yahoo.com Send a message via Skype™ to duddychuck@yahoo.com
Default Re: Column title sorting

Could sorting by Author be possible?
__________________
duddychuck@yahoo.com is offline   Reply With Quote
Old 02-19-2011, 12:57 AM   #4
Sprite-
HAVE ME WITH VODKA
Retired StaffFFR Simfile AuthorFFR Veteran
 
Sprite-'s Avatar
 
Join Date: Aug 2005
Location: Long Island, New York
Age: 35
Posts: 7,316
Default Re: Column title sorting

author is already sortable...
Sprite- is offline   Reply With Quote
Old 02-19-2011, 12:58 AM   #5
duddychuck@yahoo.com
Retired
FFR Veteran
 
duddychuck@yahoo.com's Avatar
 
Join Date: Sep 2009
Posts: 1,111
Send a message via AIM to duddychuck@yahoo.com Send a message via MSN to duddychuck@yahoo.com Send a message via Yahoo to duddychuck@yahoo.com Send a message via Skype™ to duddychuck@yahoo.com
Default Re: Column title sorting

Oops, my bad xD
__________________
duddychuck@yahoo.com is offline   Reply With Quote
Old 02-19-2011, 01:04 AM   #6
Plan_Bsk81127
snooches
FFR Simfile AuthorFFR Veteran
 
Plan_Bsk81127's Avatar
 
Join Date: Aug 2007
Age: 32
Posts: 6,420
Send a message via AIM to Plan_Bsk81127 Send a message via Skype™ to Plan_Bsk81127
Default Re: Column title sorting

Might as well add to be sorted by length while you're at it, only on that isnt sortable. lol.
Plan_Bsk81127 is offline   Reply With Quote
Old 02-19-2011, 01:27 AM   #7
Sprite-
HAVE ME WITH VODKA
Retired StaffFFR Simfile AuthorFFR Veteran
 
Sprite-'s Avatar
 
Join Date: Aug 2005
Location: Long Island, New York
Age: 35
Posts: 7,316
Default Re: Column title sorting

Well it can't sort by length because it's not stored as seconds like it should have been. It wouldn't know how to sort it.
Sprite- is offline   Reply With Quote
Old 02-19-2011, 01:54 AM   #8
jimerax
Retired StaffFFR Simfile AuthorFFR Music ProducerFFR Veteran
 
jimerax's Avatar
 
Join Date: Nov 2003
Location: Tokyo
Posts: 8,185
Send a message via AIM to jimerax Send a message via MSN to jimerax Send a message via Skype™ to jimerax
Default Re: Column title sorting

Yeah song length is just written as X:XX, and it's just a character string.

If they are written as xxx seconds, it will be sortable.
jimerax is offline   Reply With Quote
Old 02-19-2011, 09:40 AM   #9
I like it
Housekeeper
FFR Simfile AuthorFFR Veteran
 
I like it's Avatar
 
Join Date: Jan 2007
Posts: 2,119
Default Re: Column title sorting

Just a question, Why are some songs released on 12-31-69? And why are the old songs all released on 3-3-05? I assume that some songs just messed up, and that their was some sort of update on 3-3-05?
I like it is offline   Reply With Quote
Old 02-19-2011, 10:36 AM   #10
Sprite-
HAVE ME WITH VODKA
Retired StaffFFR Simfile AuthorFFR Veteran
 
Sprite-'s Avatar
 
Join Date: Aug 2005
Location: Long Island, New York
Age: 35
Posts: 7,316
Default Re: Column title sorting

I think the dates weren't stored until 05. Jimerax is going to update all the old dates I believe.
Sprite- is offline   Reply With Quote
Old 02-19-2011, 11:03 AM   #11
rushyrulz
Digital Dancing!
Retired StaffFFR Simfile AuthorFFR Music ProducerD7 Elite KeysmasherFFR Veteran
 
rushyrulz's Avatar
 
Join Date: Feb 2006
Location: 80 billion club, NE
Age: 31
Posts: 12,979
Default Re: Column title sorting

Quote:
Originally Posted by jimerax View Post
Yeah song length is just written as X:XX, and it's just a character string.

If they are written as xxx seconds, it will be sortable.
convert to double?.?
__________________


rushyrulz is offline   Reply With Quote
Old 02-19-2011, 02:36 PM   #12
Sprite-
HAVE ME WITH VODKA
Retired StaffFFR Simfile AuthorFFR Veteran
 
Sprite-'s Avatar
 
Join Date: Aug 2005
Location: Long Island, New York
Age: 35
Posts: 7,316
Default Re: Column title sorting

mysql won't do that. It can't convert a varchar x:xx to a double
Sprite- is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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 -5. The time now is 03:11 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright FlashFlashRevolution