PR WORKLIST: 27 hours overall Breakdown below.
Database schema modifications (extract from email message) - 7 hours
Creation of "tags" table, consisting of:
tag_id, int(10), auto_increment
tag_name, varchar(128), not null
Creation of "tags_videos_map" table, consisting of:
map_id, int(10), auto_increment
tag_id, int(10), not null
video_id, int(10) <- Subject to change, based on how video id is stored in the existing database.
A side-benefit of the db schema changes above is a significant reduction in resource usage and page load times (for search, videos, etc), as integer-based searching is many, many, many times faster than fulltext searching. - Inclusive in above
Related to the proposed database schema changes, I will modify all php functions that interact with these tags (keywords), including, but not limited to: searches, video display, front page. - 2 hours
Search queries in general will be optimized, if db schema changes are not sufficient on their own. - 1 hour
Cross-browser work for wheel on front page ([url removed, login to view]). With no tags, match all, and match any. - 3 hours
Provide sql query modifications for spiders, to reflect changes made to database (i.e. tags, tags_videos_map) - 4 hours
Troubleshoot bug that exists where a Safari user is shown the same video (i.e. not randomizing). I believe this to be due to caching of the $rcode variable (fed by time()), which is resulting in caching of data within Safari. Experimentation will reveal whether that is the case. Upon some experimentation, I am 99% sure this is a result of browser caching. I intend to attempt to rectify this with a combination of cache expiry, and if that fails, through appending of microtime(), rather than time(). - 8 hours, including troubleshooting and testing.
Integrating PSD design (provided) into the AVS system with the wheel functionality. For index, header, footer, categories, pornstars. - 4 hours
Integrate a “Report” button to report broken videos, missing thumbnails or inappropriate content (which automatically pulls vid ID and stores it on a page or text file, we can discuss this later) - 2 hours, tentative, pending discussion.
Integrate advertisements only when a user is not registered or not logged in. - 2 hours