Friday, September 18, 2015

Mailvox: question format

Shadow #342 had a good question:
Question, VD: what is the file format (eg Excel, Word, etc.) do you want?
Text is fine, but Excel (or to be more precise, .xls or .ods) would be much preferred if you put each element in its own cell, one line per game. That would speed things up considerably. I don't need the game data formatted this way, just the 10 questions themselves.

[difficulty][question number][question][answer][multiple choice options][correct multiple choice answer]

For example:

[easy][1][On which planet is the game set?][Chiron][1=Hermes;2=Vesta;3=Chiron;4=Eunomia][3]

[easy][2][How many factions were added in Alien Crossfire?][7][1=5;2=6;3=7;4=8][3]

And so forth, where each set of brackets [] indicates a spreadsheet cell.

Please also provide the following information, either in the spreadsheet or in the email to which it is attached:

Game name
Genre: (action, adventure, strategy, rpg, sim)
Decade: (1980, 1990, 2000, 2010)
Designer name (if known)

UPDATE: Jay sent in a set for Civilization II that worked beautifully. Definitely send them in using spreadsheet format. It's just as easy to make them that way and a lot easier to put them in the database.

We need 10 questions per game, 4 Easy, 3 Medium, 2 Hard, 1 Expert. Easy questions means anyone who has played the game should be able to get them right. The list of games for which we already have the questions is after the jump.

Age of Empires II: The Age of Kings
Agent U.S.A.
Akalabeth: World of Doom
Annals of Rome
Baldur's Gate 2
Bomberman 64
Civilization II
Civilization IV
Civilization V
Command & Conquer
Command & Conquer: Red Alert
Conquest of the New World
Counter-strike: Global Offensive
Covert Action
Dark Souls II
Destiny of an Empire
Dominions 4
Donkey Kong
Doom II: Hell on Earth
Dragon Quest VIII
Dragon Warrior
Dwarf Fortress
Elevator Action
Elite Dangerous
Empire of the Fading Suns
Europa Universalis IV
EVE Online
Executive Suite
Fable: The Lost Chapters
Fallout 3
Fallout: New Vegas
Fantasy General
Galactic Civilizations 2
Grand Theft Auto V
Grand Theft Auto: The Ballad of Gay Tony
HALO: Combat Evolved
Halo 2
Halo 3
Halo 3: ODST
Halo: Reach
Halo 4
Halo: The Master Chief Collection
Heroes of Might and Magic III
King of Dragon Pass
L.A. Noire
Long Live the Queen
Master of Magic
Mechcommander 2
Metal Gear Solid
Metal Gear Solid 2: Sons of Liberty
Phantasy Star Online
Phoenix Wright Ace Attorney
Pick Axe Pete!
Planescape: Torment
Postal 2
Rebel Assault
Robot Odyssey
Romance of the Three Kingdoms X
Shin Megami Tensei: Persona 3
Sid Meier's Pirates!
Sid Meier's Alpha Centauri
Sid Meier's Alpha Centauri: Alien Crossfire
Space Quest 3
Sonic the Hedgehog 2
Star Control II: The Ur-Quan Masters
Super Mario RPG: Legend of the Seven Stars
Swords and Serpents
System Shock 2
Team Fortress 2
The Bard's Tale
The Elder Scrolls II: Daggerfall
The Elder Scrolls III: Morrowind
The Legend of Zelda: A Link to the Past
The Legend of Zelda: Majora's Mask
The Legend of Zelda: Ocarina of Time
Thief 2
Thief Gold
Tomb Raider
Tomb Raider 2013
Turok: Dinosaur Hunter
Typhoon Thompson and the Quest for the Sea Child
UFO: Enemy Unknown
Ultima V
Ultima VI: The False Prophet
Ultima VII: The Black Gate
Ultima Online
Vampire: The Masquerade: Bloodlines
Warcraft III
Warcraft III: The Frozen Throne
Wasteland 2
Wipeout 2097
Worlds of Ultima: Savage Empire
Worlds of Ultima 2: Martian Dreams
World of Warcraft
World of Warcraft: The Burning Crusade
World of Warcraft: Wrath of the Lich King
X-COM: Terror From the Deep
X-COM: Enemy Unknown



Blogger Zaklog the Great September 18, 2015 10:52 AM  

Here's a challenge: Can anyone here get 10 questions out of You Have to Burn the Rope?

Blogger WATYF #0222 September 18, 2015 11:06 AM  

Any chance you need a macro written to compile all the data?


Blogger VD September 18, 2015 11:39 AM  

Any chance you need a macro written to compile all the data?

Thanks, but we've already got the code set up to read it once it's in that spreadsheet format.

Blogger maniacprovost September 18, 2015 1:18 PM  

At some point in the distant future, will questions be submitted to by in-game form, or generated by expert systems crawling gamefaqs, and rated by players? Perhaps by facial recognition that can tell when people are disgusted, and assigning the highest scores when P1 is laughing and pointing at P2, who just got it wrong? The difficulty levels can be defined in terms of % of correct responses?

Just kidding.

Blogger Were-Puppy September 18, 2015 1:28 PM  

I've another question regarding the year.
The games I am looking at have different release dates for US, EU, and JP. Is there one we should stick with, or do you want all of those years?

Blogger David-2 September 18, 2015 6:04 PM  

OT ... way way OT ... but this post is about games ... so consider this VW cheats on diesel emissions - and remember the history of PC video card benchmarks ... do you think VW hired some refugee programmer from AMD/NVidia/Intel and he said to them "Say, you know our EPA emissions testing problem? I've got an idea ..."??

Blogger Bill September 19, 2015 12:39 AM  

Before I put in the 20 minutes necessary... Has anyone else done Depression Quest?

Blogger Zaklog the Great September 20, 2015 5:23 PM  

I was thinking about questions for Ultima VII Part 2: Serpent Isle. The game has an alternate intro that you can access when opening it from the command line. Would the content of this intro be a good subject for an expert level question, or would that be too obscure?

Post a Comment

Rules of the blog
Please do not comment as "Anonymous". Comments by "Anonymous" will be spammed.

<< Home

Newer Posts Older Posts