I gang

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.

Evner: MySQL, PHP

Se mere: within subject design, user testing video, searching index of, safari search page, it project agreement, how to design a front page of project, front page design of project, front page design for project report, design of project front page, design of front page of project report, c for int, 24 hour bug, database caching, id design psd, video pr, rectify, query creation, private video, private message, null, email appending, button to load data from, avs, appending, php mysql display existing table

Om arbejdsgiveren:
( 6 bedømmelser ) Mont-Royal, Canada

Projekt ID: #934473

1 freelancer is bidding on average $800 for this job


I look forward to working with you.

$800 USD in 6 dage
(0 bedømmelser)