Few days ago I finally got done with last enhancements on new site commisioned by US SEO guys. It is about MLB baseball tickets. Main features:
- harvests baseball tickets data from several sources. Harvest tooks about 3,5 hours which is kind of too much but I hope that when new dedicated server is up and running we will lower the harvest time (altough tickets count is reached 600K+ and soon we will have to switch to more powerful RDBMS like PostgreSQL);
- detects visitors' country and state by IP and shows appropriate content targeted at that area (i.e. shows events and tickets for teams from that state);
- have "special" treatment toward googlebot -- it is more friendly, i.e. for usual visitors content on index.php is changing each time (if bot is detected). For googlebot we made friendly 1 hour cache, so it will not see changed content all the time (but once per hour);
- it has extensive control panel that allows import from different CSV files with venues, events, genres, etc items maintaning in the same time DB integrity and eliminating duplicate data;
- sitemap.xml is generated automatically for all semidynamic pages;
- site is built using Tangra PHP framework;
We still have a lot of work to do on this site but State 1 is completed and site is now released and online.
В последните дни за занимавах да направя user registration модул за моя 
