Private project for awrotech

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

NDA agreement.

MySQL PHP

Proje NO: #934473

Proje hakkında