Releases page
- pavero
- Dynamite Dan
- Posts: 1607
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Releases page
It seems this page is frozen. The content is still same for last several weeks/months.
https://spectrumcomputing.co.uk/index.php?cat=301
https://spectrumcomputing.co.uk/index.php?cat=301
Re: Releases page
Everyone just thought you were doing sod-all Pavpavero wrote: ↑Sun Oct 31, 2021 10:40 pm It seems this page is frozen. The content is still same for last several weeks/months.
https://spectrumcomputing.co.uk/index.php?cat=301
I noticed that today too. I checked that and 'UPDATES' to see if I'd done things on Pav's form correctly. [mention]PeterJ[/mention] - what's the difference between UPDATES and RELEASES, and how are they updated?
Re: Releases page
Hi [mention]R-Tape[/mention],
I think this one was a creation from [mention]Einar Saukas[/mention].
I think this one was a creation from [mention]Einar Saukas[/mention].
- Einar Saukas
- Bugaboo
- Posts: 3214
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Releases page
I don't even remember creating this page but it should be working now
- pavero
- Dynamite Dan
- Posts: 1607
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Re: Releases page
I don't think so. It was one of the first pages at SC site and Einar couldn't program web pages yet in that time.
- pavero
- Dynamite Dan
- Posts: 1607
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Re: Releases page
BTW, what is the sorting now? I can see titles from 2021 on pages 1&2 only. And it is still quite small number.Einar Saukas wrote: ↑Mon Nov 01, 2021 2:52 pm I don't even remember creating this page but it should be working now
Last edited by pavero on Mon Nov 01, 2021 7:49 pm, edited 1 time in total.
Re: Releases page
Sorry [mention]pavero[/mention] and [mention]Einar Saukas[/mention],
Maybe it was me. I can't always remember what happened yesterday, let alone 3+ years ago!
Sorry
Maybe it was me. I can't always remember what happened yesterday, let alone 3+ years ago!
Sorry
- pavero
- Dynamite Dan
- Posts: 1607
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Re: Releases page
There is no need to sorry, because Einar doesn't protest.
- Einar Saukas
- Bugaboo
- Posts: 3214
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Releases page
I still don't...
See?
- Einar Saukas
- Bugaboo
- Posts: 3214
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Releases page
If you put the blame on me, I will end up rewriting the entire site
Anyway I improved the query so it should show all entries now. Please take a look.
- pavero
- Dynamite Dan
- Posts: 1607
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Re: Releases page
Much better. Thanks!Einar Saukas wrote: ↑Mon Nov 01, 2021 8:52 pmIf you put the blame on me, I will end up rewriting the entire site
Anyway I improved the query so it should show all entries now. Please take a look.
- pavero
- Dynamite Dan
- Posts: 1607
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Re: Releases page
Just a thought ...
If we have not defined DATEINSERT attribute in the Entries table, it doesn't exist an easy way how to filter/sort new added entries in ZXDB. Am I right [mention]Einar Saukas[/mention]?
I guess it was the original purpose of UPDATES page:
https://spectrumcomputing.co.uk/index.php?cat=100
(release_year can be different, it can't be used for sorting)
(entry_id can't be used too, because we have 4 different sets, some IDs are reserved for Preservation tools, etc.)
If we have not defined DATEINSERT attribute in the Entries table, it doesn't exist an easy way how to filter/sort new added entries in ZXDB. Am I right [mention]Einar Saukas[/mention]?
I guess it was the original purpose of UPDATES page:
https://spectrumcomputing.co.uk/index.php?cat=100
(release_year can be different, it can't be used for sorting)
(entry_id can't be used too, because we have 4 different sets, some IDs are reserved for Preservation tools, etc.)
- Einar Saukas
- Bugaboo
- Posts: 3214
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Releases page
Fixed!
New entries are created in numeric order so it's easy to sort by new entries. Except this sequence was changed when everyone started using your online form, but now I modified the queries to take this into account.
Everything should be working properly now.
- pavero
- Dynamite Dan
- Posts: 1607
- Joined: Sat Dec 09, 2017 11:49 pm
- Location: The Czech Republic
- Contact:
Re: Releases page
You have added this sorting condition:Einar Saukas wrote: ↑Mon Nov 01, 2021 10:55 pmFixed!
New entries are created in numeric order so it's easy to sort by new entries. Except this sequence was changed when everyone started using your online form, but now I modified the queries to take this into account.
Everything should be working properly now.
IF(e.id between 36699 and 37607,0,1)
Yes, it will be working if every new entry will be added via online form. But if you or Dave will use another way (ID >37607), these entries will be "deeply" in the list.
- Einar Saukas
- Bugaboo
- Posts: 3214
- Joined: Wed Nov 15, 2017 2:48 pm
Re: Releases page
We are both exclusively using the online form to add new entries now.