Looks good. I took a look at most of the code and it looks nicely structured. You said it wasn't laid out well, but I think you did a great job with it.
I am never happy with anything I design. I always feel there could be something slightly better.
Also, I like the dom parsing class that you use, but I don't like that it hasn't been updated in a long time. I generally end up using Curl and Regex when I want to do parsing scripts.
The issue with regex is it is far harder to put together robust parsers. It does have the advantage of being far less memory intensive (regex that is). You can make Zend_HTTP use cURL but given that I didn't need any of the advanced features that cURL offers I just left it so it used the default adapter (which uses fsockopen())
This looks really good. So what areas could I help with to start. Any specificicbugs/issues/errors that your having that perhaps I can take a crack at, or did you want me to write up a few parsers that you can hook into it?
Code wise, top of my mental list would be to implement some so mechanism for parsing a standard form of xml listing the mods on a site. Fliggerty has a example http://www.fliggerty.com/ghf_hosted_mods.xml and I was planning to find a way to parse that every now and again and ensure the mods are in the database. They harder bit is finding a nice way of deleting mods that no longer appear on the list but appear in the database. I was also planning to allow the above to work on local xml files in the same format to allow manual adding of mods on sites that are too difficult to parse.
The two main sites that need parsers for them are:
http://theelderscrolls.info/
http://tesalliance.org/forums/index.php?/files/
There were some vague other thoughts about things I could/should do here:
http://code.google.com/p/es-search/issues/list
Also, the layout itself is kind of basic. I have about 5 graphics designers. You interested in giving this thing a custom design? I could have one of my graphic designers work up some brand new custom designs from scratch and you could do approval on one of them. Luckily a few of my graphic designers owe me favors, so I can have them do it as a favor. We can get something that "looks" a lot better, a lot more user friendly (as far as design). And either you could do the xhtml/css for it, or I could do that for you. Let me know what you think.
A custom design would be amazing. I am not that great at designing sites (although html+css I can do).
The one thing I would point out is that the reason the mod details page has the design it does is because it is sometimes offers more than one download location (http://search.yacoby.net/mods/4905/Swimming-Realism), so that may have to be factored into a design.
What about hosting..I see you have this setup at Google Host, but are you using a standard web host for your domain name and files? What host is powering http://search.yacoby.net/. How are you covering server costs.
This site seems like it's a high traffic site, so it might be resource intensive. So how is the host your currently using handle the user load, and bandwidth?
The host is a standard fairly cheap one. They don't seem to be complaining about the load it is putting on the server at the moment, however this doesn't have traffic that previous versions had yet.