Sort notes by age

[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.

[Andu]

I think it's already that way with the inventory.

[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."

[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.

[Doug R.]

I could update them to null.

If you could, that would be great.

[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?

[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.

[Doug R.]

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?

[Doug R.]

Actually, every new note I make is sorting at the bottom of the note list.

[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.

[Doug R.]

Can it be fixed? I've never had a problem before the conversion to UTF-8.

[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?

[AlchemicRaker]

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

[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.