Go and play everything you can! I remember when I first started playing tournaments, I would enter around 15 events in a weekend...never winning a match, but having a great time and learning a ton! Eventually you start winning matches...and even events!
Don't worry about entering the DYP...people who enter that event do so knowing it is luck of the draw. You might draw another beginner or you might draw a World Champion!
You should definitely enter Open Singles, because that will give you the chance to play some of the better players at the tournament. You just have to set your ego aside and not get pissed off if you get whooped! Take it as a learning experience...as close up view of how the better players play.
As far as Open Doubles, it is really easy to find partners at tournaments. Ask at the registration desk when you get there. They may have a "partners needed" sheet started, or they can point you towards anyone they know of that is still looking. Worst case, you sit it out and watch the action!
Try emailing Phil for the foosballboard registration again. He was having some health issues and dealing with some other stuff. He really wants to include everyone he can! Just keep trying.
The New York players that I have met are just wonderful people! They will be welcoming and helpful...a great group to have around you at your first tournament!
I hope this helps, and please feel free to post any other questions!

Melissa