mertvn / emq

Eroge Music Quiz

Eroge Music Quiz

EMQ is an AMQ-like quiz game for eroge/visual novel songs.

Currently running at https://erogemusicquiz.com.

Steps to import data

Vocals

1. Create a new postgres database, set the DATABASE_URL environment variable to its connection URI. Example: postgresql://postgres:postgres@localhost:5432/EMQ
2. Run the project (EMQ.Server) once in order for the database migrations to run. Terminate it after it's done.
3. Go to https://query.vndb.org and run all of the queries located in Queries/VNDB, download the results as json and put them where they belong (check EMQ/Server/DB/Imports/VNDB/VndbImporter.cs for the correct filenames and where to put them).
4. Run test VNDBStaffNotesParserTests.Test_Batch() (~2 seconds).
5. Run test EntryPoints.ImportVndbData() (~3.5 minutes) in order to import everything but the song links.
6. (Optional) Run test EntryPoints.ImportSongLite() (~30 seconds) in order to import the song links if you have a SongLite.json file from before. You may encounter exceptions on this step if VNDB data has been modified since you last imported data. Manually edit your SongLite.json file to fix any discrepancies.
7. (Optional) Run the EGS query and run test EntryPoints.ImportEgsData() (~2 minutes) in order to import Japanese song titles.

Also see EntryPoints.FreshSetup() for a method that automates most of these steps. Using this method requires a local postgres server running, along with some other things. Also it's likely that you'll encounter an error somewhere along the way when running it for the first time, so you should familiarize yourself with all of the steps first.

BGM

Requires VNDB data to be already imported.

1. TODO (it's like 17 steps right now :/)

Credits

rampaa: Help with the database schema and VNDB queries

hslead: Avatar "Auu" and favicon "Love"

Burnal: Motivational support

Thanks to anyone that uploads new song links.

Thanks to VNDB, EGS, and MusicBrainz administration and editors for providing the necessary data.

emq's Issues

VN name frame overlaps with room buttons on wider screens

On higher-width screens, the top-left buttons are unclickable due to being hidden behind the visual novel name viewport even while a name is not being displayed

Fixable by setting the z-index of the buttons to force them to be above.

Library: Count shows 0 after searching by VN

The other search types work correctly.

Don't use constant sizes for HTML elements

Especially affected areas:

• the entirety of the looting page
• quiz page video player

Implement spectating

requires #9

Disable Backspace navigation on quiz pages

Let room owners change room passwords

Add filters for the room listing

• IsPrivate
• QuizStatus
• Player count (Range slider)
• QuizSettings (NumSongs, SongSelectionKind, Lives, guess & result times)

Light/Dark themes

Coop: team answers should be determined by count

Check if users are still active

#9 should be implemented first

Preload songs partially rather than completely

@rampaa

Add emoji support to chat

@rampaa

Looting: Inventory display should be toggle-able

Disconnect previous EMQ tabs if a new EMQ tab is opened

Add a return to room button

Coop: ability to click a teammate's answer to switch to it

Make password inputs hidden by default, with an option to unhide

Calculate the progress bar deterministically rather than incrementing a value each timer tick

Client-side freezes or switching tabs can cause the progress bar to get desynchronized.

More player preferences

• #3

• #19

• #21

• Auto skip Guess phase

• Auto skip Results phase

More song filters for the quiz settings

• Tag

• Artist

• VN Date

• Duration

• OP/ED/Insert

• Difficulty (#48)

• VN Popularity

• VN Vote Count

• VN Average Rating

• VN Bayesian Rating

• VNDB VN search

Import and accept aliases as correct answers

Should be a quiz setting. Maybe allow unofficial titles too.
DB: is_main_title needs to repurposed carefully.

Library: Stats for the My List tab

Display the correct answer titles nicely

The Player object should be split into User and QuizPlayer

Looting: Room change arrows should be bigger

requires #16

Looting: Better placement of treasures

Currently they can spawn inside each other which is not desirable.

Clean up pages properly

Timers and other resources are not cleaned up properly when leaving pages which can cause huge issues.

Implement persistent user accounts

requires #9

MediaAnalyser: Detect fake videos

Restart songs on results phase option

either as a player preference or as a room setting

Make certain text fit in their containers by getting smaller automatically

Especially the guess text that shows up above player avatars on the quiz page.

Make the site look better

Related issues:

• #16
• #17
• #24
• #30
• #35
• #36
• #42
• #45
• #47
• #49

Use modals instead of window.prompt() and window.confirm()

Wishlist VNs are not included in EMQ

I have tried a couple of times in EMQ looting with my VNDB id to test this out but it doesn't seem to include any wishlist VN unless they did not play/vote on vn to begin with like u236125.

Language preferences

Method for sorting/selecting Title objects

somewhat related issue: #21

VNDBStaffNotesParser: Parse songs with Oxford commas correctly

See method: Test_MultipleWithDifferentSongTypesOxfordCommaAmpersandDelimiter

Library: Ability to click on displayed artists or VNs to search by them

Support team sizes other than 1 and MAX

Send guess after guess phase ends even if Enter key is not pressed

Implement an ACK system for SignalR messages and resend messages that weren't acknowledged

Missing certain messages is devastating for client-side consistency.

Trim guesses before searching autocomplete

Track song stats

• Difficulty (% correct)

• Average guess time (first guess)

Fix text underlines stretching under parentheses

Example:

Allow users to change room settings before creating rooms

Volume control

Implement a confirmation screen when leaving the site during quizzes

https://developer.mozilla.org/en-US/docs/Web/API/Window/beforeunload_event

Remove rooms if there are no active players left

requires #10

Clean up quizzes properly after they end (on the server-side)

Implement readying up in rooms