Looking for help on several puzzles. 50% complete, and now I'm completely stumped.

[Speady]

Need some assistance on a handful of puzzles that I'm having trouble on. At a little over 50% game completion. Not sure if it's too early to do some of these, but I'm asking all of them now just to minimize this to a single post (and because there are barely any walkthroughs/guides online). I'm hoping any of these help get me going a bit quicker, as I was doing prior.

Any hints and/or solutions are welcome. Puzzle descriptions given vaguely, with spoiler tags covering more details.

1) Wine Cellar
Trying to access a hidden horse statue within the cellar. There's a false wall with red spots on it, and various wine bottles I can pull from.

2) Coffee Door
Door with coffee smells coming from it. How do I get past it?

3) Bug Reports
I found and completed Bug Report 2. How do I find the other ones?

4) Game Debug Console
Game console I found in the cellar area. I was able to access it with the debug code hint, but I'm not exactly sure what to do with the built-in video game next. Only found the dollars scattered within it.

5) Crypt in Forest
Gravestones and a crypt in the forest before the hotel. I'm at a loss here. Is there a key that I need?

6) Bookcase Room
A small room upstairs with a bunch of books with years that I can pull. There's also a notebook with a lunar cycle lock. Which book do I pull? (Most of the common years I've been finding aren't on any of the shelves.)

7) Center of Red Maze
Red maze accessed from upstairs mirror. Is this tied to the bug reports?

8) Puzzle Boxes and Year Doors
I noticed some of the doors later on with years on them have similar patterns to puzzles found in some of the boxes. Are they connected somehow?

9) Messages from the Past
Earlier on, I accessed the disks found in the safes. When solved in order, it spells out "R-I-O-L-E". Haven't found any use for this since. Am I reading too much into this?

10) Patterns on Posters
Another set of pieces uncovered earlier on, when fixing the torn posters. Are these patterns related to the supercomputer? And if so, how do I know the order of the sequence?

11) Hole in the Statue ("The Third Eye"?)
That statue in the hotel with a hole in its forehead. I've seen several references to a story involving "The Third Eye", which I assume is connected to that statue. Any idea where to find this object? Is it in the crypt outside of the hotel?

[Derriere]

Regarding #8: Yes the puzzle boxes are related to the doors with the years that have decorations on the door that match the puzzle boxes. Keep in mind that not all year doors have the box puzzle decorations. I have only just started picking these apart so I can't give the whole answer, but I point you in the right direction.
Hint A: You will (probably) open the doors before you open the boxes.
Hint B: You can find keys in a particular version of the maze.

[theyrewatching]

1) I believe there is a clue somewhere for which bottle you need to pull, but you can also just brute force it and pull all of them.

2) the key to the coffee room is in an area you haven't opened yet. once you solve one of the other puzzles you listed below you will get a key for it

3 + 4) the game consoles and debug reports are connected. there are three of each.

5) there is a key you need here. try looking around the chapel

6) is there anything unusual you can see about any of the shelves? how about on the other side of the room? for the journal here, that and the astrological clock are both late game puzzles you can ignore for now

7) you're on the right track with the maze and bug reports. worry about 3+4 above first

8) yes they are connected. as for the way into those rooms, have you found a clue from the tv monitor near the phone and a door that matches that clue?

9) reread exactly what was said when you were given those letters in the disc game. there's a hint about what the letters go with. this is something you need for a very late puzzle so you have some time to think about it

10) these are related to the supercomputer and there is something else you already have that may give you a little more info on them. hint: i know you already have the other thing because of information you provided in this post

11) this might be a good thing to look into first. is there a puzzle or door somewhere you haven't figured out yet that references the third eye? (you already have access to it). hint for that puzzle when you find it: all you need to solve it is very close by

hope that helps and I'm happy to give more clues or actual solutions if you need!

[Derriere]

Regarding #1: I'm still working on this one, too, but I do think an important document for this one can be found back upstairs in the restaurant you passed on your way down, you will find a hotel menu on a table near the knocked over chair. The wine selection matches what's in the cellar and includes years/prices/names. Three of the wine racks have a bottle that is part of the mechanism, they reset once you pull three. I pulled them in every order I could think of in case I could solve it by force, no luck there. I don't know the answer to this one yet, but maybe the info I give will help you.

[theyrewatching]

Originally posted by Derriere:

Regarding #1: I'm still working on this one, too, but I do think an important document for this one can be found back upstairs in the restaurant you passed on your way down, you will find a hotel menu on a table near the knocked over chair. The wine selection matches what's in the cellar and includes years/prices/names. Three of the wine racks have a bottle that is part of the mechanism, they reset once you pull three. I pulled them in every order I could think of in case I could solve it by force, no luck there. I don't know the answer to this one yet, but maybe the info I give will help you. :stimulation:

this is really interesting because i just pulled every wine bottle one by one looking for dollars and it opened the door for me somewhere along the way. i saw someone else on the forums had done the same. so either we both got lucky on the order or it's one bottle you need to pull and you can just try em all

[Spy and The Holograms]

#1: There are three wine bottles that open the door, when you fail they will slot back in place in the order that they should be pulled out.

#2: You need access to the West Wing past the astrological clock to get the key for that room. (You do not need to solve the clock puzzle to access the west wing.)

#3: The clues for the bug reports are in the same room as the typewriters, as you progress through the game you will find them. They should have icons on the maps you've unlocked.

#4: You need to complete the bug reports and read them in order to do what you need with the game consoles.

#5: Graveyard key is in the mansion. Inside of the hidden cathedral on the first floor in front of the alter with the crucified man.

#6: The book you need is on the left side of the room. You can only access that side of the room after being able to access the elevator and going left on the second floor and pulling the upside down lantern on the wall to reveal a hidden door.

#7: You need to complete both the bug reports and game consoles to go further.

#8: The doors and boxes are connected but they will be some of the last puzzles you do, so don't worry about them quite yet.

#9: You won't have use for these letters yet, but it's not just the letters that are important in those messages from the past. Each message also contains an item, some of which you've seen on paper in the hotel before.

#10: The supercomputer tells you what you need to input for each sequence, the puzzle is figuring out the sequence of all 3 sets of commands. The first prompt is for the User.

#11: It is inside the hotel. You need to use the elevator to find it.

Elevator Hint: The notice beside the elevator has the phone number scratched out, so use the phonebook to find the number.