Opinions given: sort by date modified

This forum is for site announcements. Please go here to read the SITE & FORUM RULES.

Opinions given: sort by date modified

Postby AbsoluteDestiny » Tue Mar 22, 2005 3:02 am

Hi all,

in my first attempt at doing some coding for the site I've modified the Opinions Given page to allow people to order the list by Date Modified instead of Score. You can also reverse the order of either list now too.

Let me know if there are any bugs with the new code.

Enjoy

AD
User avatar
AbsoluteDestiny
 
Joined: 15 Aug 2001
Location: Oxford, UK

Postby Maverick-Rubik » Tue Mar 22, 2005 6:17 am

I knew something happend to the Opinions Given page...

The tables for Opinions Given looks much more squished towards the center now, and I was looking at an opinion that I haven't touched for a while but said was Updated March 11. This could very well be a glitch since I recall its last update was October 11.

Here's the vid I was talking about.
User avatar
Maverick-Rubik
The Eye of a Lynx
 
Joined: 12 May 2003

Postby AbsoluteDestiny » Tue Mar 22, 2005 8:13 am

The updated date is not necessarily updated by you. Unfortuantely the date that the org stores is just the last time someone wrote the table again in the database - this could be the creator or the opinion leaver. They also don't even need to change anything, they just need to have clicked edit, not modified anything and submitted. This is a flaw in the original design of the table and one that is hard to reverse now.
User avatar
AbsoluteDestiny
 
Joined: 15 Aug 2001
Location: Oxford, UK

Postby Maverick-Rubik » Tue Mar 22, 2005 4:09 pm

Oh, alright. Then I guess the only flaw I see is that the tables are a bit squished on the video choosing page. :wink:
User avatar
Maverick-Rubik
The Eye of a Lynx
 
Joined: 12 May 2003

Postby AbsoluteDestiny » Tue Mar 22, 2005 6:38 pm

OK I've modified so there's one less column, which should ease things a little.
User avatar
AbsoluteDestiny
 
Joined: 15 Aug 2001
Location: Oxford, UK

Postby LCY84 » Wed Mar 23, 2005 11:56 am

too bad, we can't see now the numbers of op each amv we have opped has :?
ImageImage
ImageImage
User avatar
LCY84
 
Joined: 13 Sep 2003
Location: Montpellier, FRANCE

Postby AbsoluteDestiny » Wed Mar 23, 2005 12:03 pm

LCY84 wrote:too bad, we can't see now the numbers of op each amv we have opped has :?


Yeah there wasnt really enough space and the calculation for that was confusing the modified date.
User avatar
AbsoluteDestiny
 
Joined: 15 Aug 2001
Location: Oxford, UK

Postby LCY84 » Wed Mar 23, 2005 12:18 pm

Ok, not really a problem; good job on it anyway ;)
ImageImage
ImageImage
User avatar
LCY84
 
Joined: 13 Sep 2003
Location: Montpellier, FRANCE

Postby downwithpants » Thu Mar 24, 2005 10:41 pm

is that how europeans read dates?
:cross-eyed:
helpful addition though
maskandlayer()|My Guide to WMM 2.x
a-m-v.org Last.fm|<a href="http://www.frappr.com/animemusicvideosdotorg">Animemusicvideos.org Frappr</a>|<a href="http://tinyurl.com/2lryta"> Editors and fans against the misattribution of AMVs</a>
User avatar
downwithpants
BIG PICTURE person
 
Joined: 03 Dec 2002
Location: storrs, ct
Status: out of service

Postby Arigatomina » Thu Mar 24, 2005 10:47 pm

I love it. ^_^ Thank you.
User avatar
Arigatomina
 
Joined: 03 Apr 2003

Postby greenjinjo » Tue Mar 29, 2005 10:41 am

Yay!!!

Thanks a ton, now just need to sort by "most recent response to opinion given" and we'll all be happy :lol:
godix wrote:Free sausage. No conditions. No tricks. To the best of my ability I will give anyone a sausage on anything they ask for. I'm not kidding here, I'll do as many sausage as I can.
Check out my deviantART!
User avatar
greenjinjo
 
Joined: 03 Jul 2003
Location: I was awesome, you loved it.

Postby AbsoluteDestiny » Tue Mar 29, 2005 11:25 am

greenjinjo wrote:Thanks a ton, now just need to sort by "most recent response to opinion given" and we'll all be happy :lol:


Unfortunately that can't happen. The "last modified" date is for both opinionator and creator so it doesn't distinguish as to who last updated this opinion. Bad database design, I'm afraid.
User avatar
AbsoluteDestiny
 
Joined: 15 Aug 2001
Location: Oxford, UK


Return to Site Announcements

Who is online

Users browsing this forum: No registered users and 1 guest