The best classic Speccy game beginning with E: discussion

General software. From trouble with the Banyan Tree to OCP Art Studio, post any general software chat here. Could include game challenges...
Ralf
Rick Dangerous
Posts: 2279
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: The best classic Speccy game beginning with E: discussion

Post by Ralf »

A bit offtopic, I noticed that you are listing here things that begin with "el" in Spanish like "El Cid" or "El Hobbit".

This is a different philosophy than used in WOS. Things like a, the, el, la, der, die in different languages were ignored as part of the title.

So for example "The Happiest Days of Your Life" belonged to H not T.

Are you changing this rule here?
User avatar
PeterJ
Site Admin
Posts: 6854
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: The best classic Speccy game beginning with E: discussion

Post by PeterJ »

Hi [mention]Ralf[/mention] at the moment this is how it will work. I will look in ZXDB to see if titles are stored in any other way and change it if I can.

We could also possibly use string manipulation but no promises.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: The best classic Speccy game beginning with E: discussion

Post by Einar Saukas »

PeterJ wrote: Mon Feb 12, 2018 12:59 pmHi @Ralph at the moment this is how it will work. I will look in ZXDB to see if titles are stored in any other way and change it if I can.
You just need to use "library_title" instead of title. Kinda like this:

Code: Select all

SELECT id, title FROM entries
WHERE UPPER(library_title) LIKE 'E%'
ORDER BY UPPER(library_title)
User avatar
PeterJ
Site Admin
Posts: 6854
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: The best classic Speccy game beginning with E: discussion

Post by PeterJ »

Super, I will try and update tonight.
User avatar
Stefan
Manic Miner
Posts: 792
Joined: Mon Nov 13, 2017 9:51 pm
Location: Belgium
Contact:

Re: The best classic Speccy game beginning with E: discussion

Post by Stefan »

Joefish wrote: Mon Feb 12, 2018 11:12 am Enduro Racer was a good conversion.
Enduro Racer was the first racer I saw that moved the horizon to indicate vertical movement - I can still feel the excitement / anxiety when going over that first hill. Wow!
Ralf
Rick Dangerous
Posts: 2279
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: The best classic Speccy game beginning with E: discussion

Post by Ralf »

Enduro Racer was the first racer I saw that moved the horizon to indicate vertical movement - I can still feel the excitement / anxiety when going over that first hill. Wow!
Yes, Enduro Racer is very good. At the almost equal level with Chase HQ, I would say.
User avatar
PeterJ
Site Admin
Posts: 6854
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: The best classic Speccy game beginning with E: discussion

Post by PeterJ »

[mention]Ralf[/mention] and [mention]Einar Saukas[/mention]

The page should work better now:

https://spectrumcomputing.co.uk/index.php?cat=52
User avatar
PeterJ
Site Admin
Posts: 6854
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: The best classic Speccy game beginning with E: discussion

Post by PeterJ »

Ralf
Rick Dangerous
Posts: 2279
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: The best classic Speccy game beginning with E: discussion

Post by Ralf »

Any love for 'Edd the Duck'!
It's a decent game. A bit like a poorer cousin of Rainbow Islands but definitely on the good side.
User avatar
Blerkotron
Dizzy
Posts: 90
Joined: Mon Nov 13, 2017 12:36 pm

Re: The best classic Speccy game beginning with E: discussion

Post by Blerkotron »

If we're discounting 'the' from titles then I'd like to suggest "The Eidolon", which I spent many a happy hour playing back in the day.

Otherwise I'll wait for 'T'. :)
User avatar
PeterJ
Site Admin
Posts: 6854
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: The best classic Speccy game beginning with E: discussion

Post by PeterJ »

Blerkotron wrote: Mon Feb 12, 2018 10:12 pm If we're discounting 'the' from titles then I'd like to suggest "The Eidolon", which I spent many a happy hour playing back in the day.

Otherwise I'll wait for 'T'. :)
Hi [mention]Blerkotron[/mention] , Eidolon now correctly appears in the 'E' list, so go for it.
User avatar
hitm4n
Manic Miner
Posts: 604
Joined: Fri Nov 17, 2017 12:56 pm

Re: The best classic Speccy game beginning with E: discussion

Post by hitm4n »

https://spectrumcomputing.co.uk/index.p ... 96&id=1621
Great game.

I like how each letter raises names of games we maybe didn't know, or have never tried. And on recommendation we might try some of these. I hope people will try this one, its really good. Well i liked it so there.... :)
I don't have anything cool to put here, so i'll just be off now to see a priest with yeast stuck between his teeth and his friend called Keith who's a hairpiece thief...
User avatar
PeteProdge
Bugaboo
Posts: 3521
Joined: Mon Nov 13, 2017 9:03 am

Re: The best classic Speccy game beginning with E: discussion

Post by PeteProdge »

Blerkotron wrote: Mon Feb 12, 2018 10:12 pm If we're discounting 'the' from titles then I'd like to suggest "The Eidolon", which I spent many a happy hour playing back in the day.

Otherwise I'll wait for 'T'. :)
We are indeed discounting 'stop words' like A, The, El, etc, which means The Eidolon definitely counts in this.
Reheated Pixels - a combination of retrogaming, comedy and factual musing, is here!
New video: Nine ZX Spectrum magazine controversies - How Crash, Your Sinclair and Sinclair User managed to offend the world!
User avatar
Juan F. Ramirez
Bugaboo
Posts: 5101
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: The best classic Speccy game beginning with E: discussion

Post by Juan F. Ramirez »

I'll vote for El Fred.

;)
User avatar
PeterJ
Site Admin
Posts: 6854
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: The best classic Speccy game beginning with E: discussion

Post by PeterJ »

[mention]PeteProdge[/mention] The link to the list I posted yesterday should now be accurate (It includes the year so you can tell if it's 'classic' or not. Please let me know if not. I'm keen to iron out issues before I start on the full A-Z.
User avatar
PeterJ
Site Admin
Posts: 6854
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: The best classic Speccy game beginning with E: discussion

Post by PeterJ »

Juan F. Ramirez wrote: Tue Feb 13, 2018 8:47 am I'll vote for El Fred.

;)
Troublemaker!
User avatar
PeteProdge
Bugaboo
Posts: 3521
Joined: Mon Nov 13, 2017 9:03 am

Re: The best classic Speccy game beginning with E: discussion

Post by PeteProdge »

PeterJ wrote: Tue Feb 13, 2018 9:37 am @PeteProdge The link to the list I posted yesterday should now be accurate (It includes the year so you can tell if it's 'classic' or not. Please let me know if not. I'm keen to iron out issues before I start on the full A-Z.
Ah, it rightly ignores prefixes such as A/An/El/The/L'/Le/La/Los.

When I say 'classic', I'm referring to the period from 1982 to about 1993. I believe 1993 was the last year of the ZX Spectrum games market being commercially active (and this also includes magazines). You could still go into shops in high streets and shopping centres to buy games for your Speccy. It was pretty hard of course, and most of the stuff by this point were budget re-releases of full price games.

What isn't 'classic', is the homebrew stuff and other things made now the ZX Spectrum is a specialist interest. (Not that I'm putting it down, I'm a huge fan of Buzzsaw+.)

There is a bit of a grey area. Zenobi Software were selling new games (albeit via mail order) until 1997. I'm not sure how to class them. Then there's what was going in eastern Europe with all the Speccy clones and an apparently thriving games market..
Reheated Pixels - a combination of retrogaming, comedy and factual musing, is here!
New video: Nine ZX Spectrum magazine controversies - How Crash, Your Sinclair and Sinclair User managed to offend the world!
Ralf
Rick Dangerous
Posts: 2279
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: The best classic Speccy game beginning with E: discussion

Post by Ralf »

The link to the list I posted yesterday should now be accurate (It includes the year so you can tell if it's 'classic' or not. Please let me know if not. I'm keen to iron out issues before I start on the full A-Z.
It's better. Games like "The Eidolon" are visible now but personally I would yet change the sorting.

Instead of

Edd The Duck
Elite
Exolon
The Eidolon

I would do

Edd The Duck
The Eidolon
Elite
Exolon

Or even, as WOS does:

Edd The Duck
Eidolon, The
Elite
Exolon

If we ignore "the" then it shouldn't influence sorting as well.
But maybe other people could express their opinion too
User avatar
Juan F. Ramirez
Bugaboo
Posts: 5101
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: The best classic Speccy game beginning with E: discussion

Post by Juan F. Ramirez »

Ralf wrote: Tue Feb 13, 2018 10:50 am
Edd The Duck
Eidolon, The
Elite
Exolon
This should be the proper way to display, IMHO.
User avatar
PeterJ
Site Admin
Posts: 6854
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: The best classic Speccy game beginning with E: discussion

Post by PeterJ »

[mention]Ralf[/mention] & [mention]Juan F. Ramirez[/mention]

Try this!

https://spectrumcomputing.co.uk/index.php?cat=52
User avatar
Juan F. Ramirez
Bugaboo
Posts: 5101
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: The best classic Speccy game beginning with E: discussion

Post by Juan F. Ramirez »

Image
Ralf
Rick Dangerous
Posts: 2279
Joined: Mon Nov 13, 2017 11:59 am
Location: Poland

Re: The best classic Speccy game beginning with E: discussion

Post by Ralf »

Try this!
Great! Case closed!
User avatar
Juan F. Ramirez
Bugaboo
Posts: 5101
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: The best classic Speccy game beginning with E: discussion

Post by Juan F. Ramirez »

Blerkotron wrote: Mon Feb 12, 2018 10:12 pm If we're discounting 'the' from titles then I'd like to suggest "The Eidolon", which I spent many a happy hour playing back in the day.
Image

I've never played it and it seems interesting.

And it's got a high WoS score. I think I should give it a try.
User avatar
PeteProdge
Bugaboo
Posts: 3521
Joined: Mon Nov 13, 2017 9:03 am

Re: The best classic Speccy game beginning with E: discussion

Post by PeteProdge »

As it stands, the list will be...
  • Earth Shaker by Michael Batty/Your Sinclair
  • Edd The Duck by Impulze
  • Eddie Kidd Jump Challenge by Martech
  • Egg Head by Claire Tucker/Crash
  • Egghead To The Rescue by Grafix Wizards/Crash
  • Eidolon, The by Activision
  • Eliminator by Hewson
  • Elite by Firebird
  • Emilio Butragueño Futbol by Topo Soft/Ocean
  • Emlyn Hughes International Soccer by Audiogenic
  • Empire Fights Back, The by Mastertronic
  • E-Motion by US Gold
  • Enduro Racer by Activision
  • Enigma Force by Beyond
  • Equinox by Mikro-Gen
  • Eric & The Floaters by Sinclair Research
  • Escape From the Planet of the Robot Monsters by Domark
  • Eskimo Eddie by Ocean
  • Everyone's A Wally by Mikro-Gen
  • Exolon by Hewson
  • Extreme by Digital Integration
Still time to get your addition(s) in, so get replying here before Monday morning!
Reheated Pixels - a combination of retrogaming, comedy and factual musing, is here!
New video: Nine ZX Spectrum magazine controversies - How Crash, Your Sinclair and Sinclair User managed to offend the world!
User avatar
stupidget
Dynamite Dan
Posts: 1611
Joined: Wed Jan 24, 2018 2:09 pm
Location: Sunny Wolverhampton

Re: The best classic Speccy game beginning with E: discussion

Post by stupidget »

Apologies for throwing a proverbial spanner in the works, but, are we talking 'games' only or can we add Adventure Games? If so then I'd probably say Emerald Isle as I spent hours playing it 'back in the day'
Post Reply