General software. From trouble with the Banyan Tree to OCP Art Studio, post any general software chat here. Could include game challenges...
Einar Saukas
Bugaboo
Posts: 3147 Joined: Wed Nov 15, 2017 2:48 pm
Quote
0
login to like this post
Post
by Einar Saukas » Sat Oct 10, 2020 3:41 pm
akeley wrote: ↑ Sat Oct 10, 2020 2:48 pm
I realise it'd be a mammoth task to add separate flags to all the entries.
Not really. All information is already organized in ZXDB. It's just a matter of deciding exactly what we want.
How about this?
Code: Select all
select * from entries e left join scores s on e.id = s.entry_id
-- exclude titles also available on other platforms
where e.id not in (select entry_id from ports)
-- exclude official coin-op conversions
and e.id not in (select r.entry_id from relatedlicenses r inner join licenses c
on r.license_id = c.id where r.is_official=1 and c.licensetype_id in ('a','o'))
-- exclude titles ported from ZX81, etc
and e.id not in (select entry_id from relations where relationtype_id='p')
-- games only
and e.genretype_id < 34
-- order by Martijn's WoS score
order by s.score desc, votes desc, e.library_title
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Sat Oct 10, 2020 4:01 pm
No 73 today and it's US Gold's conversion of Gauntlet
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Mon Oct 12, 2020 6:57 pm
Yesterday gave us no 72, the ultra fast shoot em up, Dark Star.
Today was another biggie, Jon Ritman and Ocean's Match Day
RWAC
Manic Miner
Posts: 702 Joined: Sun Aug 18, 2019 9:59 pm
Quote
0
login to like this post
Post
by RWAC » Mon Oct 12, 2020 7:18 pm
jdanddiet wrote: ↑ Mon Oct 12, 2020 6:57 pm
Yesterday gave us no 72, the ultra fast shoot em up, Dark Star.
Today was another biggie, Jon Ritman and Ocean's Match Day
It's no Emlyn Hughes International Soccer is it?
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Tue Oct 13, 2020 8:47 am
Maybe not. I never played emlyn on the Speccy though so dont expect to see it on this list. I do admire it though, as played it a lot on a mate's amstrad 6128
Morkin
Bugaboo
Posts: 3277 Joined: Mon Nov 13, 2017 8:50 am
Location: Bristol, UK
Quote
0
login to like this post
Post
by Morkin » Tue Oct 13, 2020 9:22 am
Not sure Match Day has aged that well really.
Match Day 2 is OK, but I found both of these games uber-clunky after playing Emlyn Hughes.
Ivanzx
Manic Miner
Posts: 736 Joined: Tue Nov 14, 2017 9:51 am
Quote
0
login to like this post
Post
by Ivanzx » Tue Oct 13, 2020 9:30 am
Any Homebrew in the list?
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Tue Oct 13, 2020 10:05 am
Ivanzx wrote: ↑ Tue Oct 13, 2020 9:30 am
Any Homebrew in the list?
No, I havent included homebrew in my list
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Wed Oct 14, 2020 8:32 pm
70 and 69 today
Avalon and Universal hero
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Fri Oct 16, 2020 9:41 am
68 yesterday was starstrike 2
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Fri Oct 16, 2020 2:17 pm
Friday update. Lots of big hitters next week!
100.Alchemist
99.Bumpy
98.Earthlight
97.Wizball
96.Marauder
95.Ghostbusters
94.Chronos
93.Secret Diary of Adrian Mole
92.Grumpy Gumphrey Supersleuth
91.Confuzion
90.Glass
89.Dan Dare
88.Gunrunner
87.Mikie
86.They Stole A Million
85.Nemesis The Warlock
84.Stonkers
83.Operation Wolf
82.Licence To Kill
81.Alien
80.International Cricket
79.Future Games
78.Target Renegade
77.Dandy
76.Zzoom
75.Avenger Way of the Tiger 2
74.Pippo
73.Gauntlet
72.Dark Star
71.Match Day
70.Avalon
69.Universal Hero
68.Starstrike II
67.Scuba Dive
RWAC
Manic Miner
Posts: 702 Joined: Sun Aug 18, 2019 9:59 pm
Quote
0
login to like this post
Post
by RWAC » Fri Oct 16, 2020 5:12 pm
Scuba Dive is a great game!
cmal
Manic Miner
Posts: 630 Joined: Fri Jun 05, 2020 1:05 am
Location: California
Quote
0
login to like this post
Post
by cmal » Sat Oct 17, 2020 9:09 am
Scuba Dive is a classic! I don't know why that game doesn't appear more often in top 100s.
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Mon Oct 19, 2020 9:00 am
66 Myth history in the making
65 180
Morkin
Bugaboo
Posts: 3277 Joined: Mon Nov 13, 2017 8:50 am
Location: Bristol, UK
Quote
0
login to like this post
Post
by Morkin » Mon Oct 19, 2020 9:36 am
"There's only one word for that: magic darts!"
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Mon Oct 19, 2020 10:17 am
Morkin wrote: ↑ Mon Oct 19, 2020 9:36 am
"There's only one word for that: magic darts!"
RWAC
Manic Miner
Posts: 702 Joined: Sun Aug 18, 2019 9:59 pm
Quote
0
login to like this post
Post
by RWAC » Mon Oct 19, 2020 10:22 am
jdanddiet wrote: ↑ Mon Oct 19, 2020 9:00 am
66 Myth history in the making
65 180
Oh man this kills me!
Myth is easily a top 20 game, and you've put it below a bloody darts game!
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Mon Oct 19, 2020 10:50 am
RWAC wrote: ↑ Mon Oct 19, 2020 10:22 am
jdanddiet wrote: ↑ Mon Oct 19, 2020 9:00 am
66 Myth history in the making
65 180
Oh man this kills me!
Myth is easily a top 20 game, and you've put it below a bloody darts game!
I look forward to seeing your list
stupidget
Dynamite Dan
Posts: 1644 Joined: Wed Jan 24, 2018 2:09 pm
Location: Sunny Wolverhampton
Quote
0
login to like this post
Post
by stupidget » Mon Oct 19, 2020 10:50 am
RWAC wrote: ↑ Mon Oct 19, 2020 10:22 am
jdanddiet wrote: ↑ Mon Oct 19, 2020 9:00 am
66 Myth history in the making
65 180
Oh man this kills me!
Myth is easily a top 20 game, and you've put it below a bloody darts game!
I must admit that my mate and I had far more fun playing 180 than we did with Myth.
RWAC
Manic Miner
Posts: 702 Joined: Sun Aug 18, 2019 9:59 pm
Quote
0
login to like this post
Post
by RWAC » Mon Oct 19, 2020 10:55 am
jdanddiet wrote: ↑ Mon Oct 19, 2020 10:50 am
RWAC wrote: ↑ Mon Oct 19, 2020 10:22 am
Oh man this kills me!
Myth is easily a top 20 game, and you've put it below a bloody darts game!
I look forward to seeing your list
When I post mine, you'll probably want to redo yours!
RWAC
Manic Miner
Posts: 702 Joined: Sun Aug 18, 2019 9:59 pm
Quote
0
login to like this post
Post
by RWAC » Mon Oct 19, 2020 10:57 am
stupidget wrote: ↑ Mon Oct 19, 2020 10:50 am
I must admit that my mate and I had far more fun playing 180 than we did with Myth.
C - Nonsense in BASIC
vanpeebles
Microbot
Posts: 152 Joined: Wed Jan 08, 2020 9:23 am
Location: UK
Contact:
Quote
0
login to like this post
Post
by vanpeebles » Mon Oct 19, 2020 10:58 am
I was never a Myth fan anarl. Might have to try it again one day.
jdanddiet
Manic Miner
Posts: 213 Joined: Tue Jun 23, 2020 1:11 pm
Quote
0
login to like this post
Post
by jdanddiet » Mon Oct 19, 2020 1:22 pm
I admit nostalgia is playing a big part in my list. And while I appreciate Myth and enjoyed it a lot, I played 180 a lot with my Dad and that brings some very happy memories.
Morkin
Bugaboo
Posts: 3277 Joined: Mon Nov 13, 2017 8:50 am
Location: Bristol, UK
Quote
0
login to like this post
Post
by Morkin » Mon Oct 19, 2020 4:58 pm
Heh - I was going to comment on the low placing of a couple of games, but I figured if a game I rated top 10 appeared at 60-something in someone else's list, it still means they rate it highly (just not as high as some others)..