Page 1 of 1

Sort notes by age

Posted: Mon Mar 29, 2010 12:07 pm
by Doug R.
I would like to see notes sorted by age again, with the oldest on the bottom, on both the inventory page and on the ground.

Re: Sort notes by age

Posted: Mon Mar 29, 2010 5:34 pm
by Andu
I think it's already that way with the inventory.

Re: Sort notes by age

Posted: Mon Mar 29, 2010 6:35 pm
by Doug R.
Not quite.

1) Older notes are at the top, not the bottom.
2) There's always approximately 4 notes in my inventory that are always last, even if I make a new note. They seem to be perpetually "newer."

Re: Sort notes by age

Posted: Mon Mar 29, 2010 7:45 pm
by SekoETC
Well, I implemented this for the objects page but on the inventory page, they already seem to be sorted that way. The only thing that could cause a difference is if some of the notes have specifics other than NULL. Edit: Yup, I checked and some notes have specifics (blank) instead of NULL. That would make them get bunched together. I could update them to null.

Re: Sort notes by age

Posted: Tue Mar 30, 2010 2:43 am
by Doug R.
SekoETC wrote: I could update them to null.


If you could, that would be great.

Re: Sort notes by age

Posted: Tue Mar 30, 2010 5:36 am
by kapasakius
This is great, especially notes on the ground, previously if someone died and there was hundreds of notes on the ground it was hell to tidy the place, pick up one note and the rest get randomly mixed up and you have to search all notes again. Brrrr. The same thing is with the resources, can this too be fixed, why resources are shuffled every time you pick one from the ground?

Re: Sort notes by age

Posted: Tue Mar 30, 2010 11:57 am
by SekoETC
Not anymore, or at least it shouldn't shuffle them anymore. I checked the objects page for one of my characters a few times but the order seemed to be the same. New piles and notes on top.

I also updated all note specifics from "" to NULL but new ones might get created.

Re: Sort notes by age

Posted: Tue Mar 30, 2010 2:24 pm
by Doug R.
SekoETC wrote:I also updated all note specifics from "" to NULL but new ones might get created.


I just apparently made one. How does this happen, and is there a way to prevent it?

Re: Sort notes by age

Posted: Tue Mar 30, 2010 6:34 pm
by Doug R.
Actually, every new note I make is sorting at the bottom of the note list.

Re: Sort notes by age

Posted: Tue Mar 30, 2010 6:59 pm
by SekoETC
I guess it might be something in the code. If the code for creating a new note enters "" for specifics instead of NULL or instead of leaving it unstated then it will become blank for all.

Re: Sort notes by age

Posted: Wed Mar 31, 2010 3:44 pm
by Doug R.
Can it be fixed? I've never had a problem before the conversion to UTF-8.

Re: Sort notes by age

Posted: Tue Apr 06, 2010 6:39 pm
by Doug R.
Since all the new notes I make seem to be missing NULL, would the simplest fix be to change the field in all existing notes to blank?

Re: Sort notes by age

Posted: Tue Apr 06, 2010 8:28 pm
by AlchemicRaker
Doug R. wrote:Since all the new notes I make seem to be missing NULL, would the simplest fix be to change the field in all existing notes to blank?

If only older notes are marked NULL, and no NULL's have been created recently, then thats what I would do (just change all the NULL's to blanks in the database and be done with it)

- Natso

Re: Sort notes by age

Posted: Tue Apr 06, 2010 8:30 pm
by Doug R.
Since I don't have DB access, I can't say for sure that this is the case, just that it seems to be the case.