Questions:
Which technology you will use ? WordPress / PHP / .NET ?
If you will not use word-press then do you have a very good front-end designer and it must be Responsive
Price
Time Line
Front End
1. Main Design
2. Company Logo
3. Some other companies logos with links as advertisement in square boxes (6 or 8)
4. Some text / message / instructions
5. Start Button -> then Next Page
6. 30 Second Video (once played, can’t be stopped / fast forward. Replay button)
7. 3 – 4 multiple choice questions
8. Next Button for next page (Upper portion Logo / advertisement logo remain same)
9. 30 Second Video (once played, can’t be stopped / fast forward. Replay button)
10. 3 – 4 multiple choice questions
11. Next Button for next page (Upper portion Logo / advertisement logo remain same)
12. 30 Second Video (once played, can’t be stopped / fast forward. Replay button)
13. 3 – 4 multiple choice questions
14. Next Button
15. Details Input Form : Name, Email, Cell, City | Submit button
[User can be get registered first to skip this form]
16. Result announced i.e. All Answers Correct or Wrong (%)
17. If correct : A message appear & Inform last winner name / city / Total number of winners since test started
18. If wrong: A message appear
One can’t retake the test with same cell / email for 3 or 5 or 7 days
If he tries then don’t submit the form and inform the next date / time to avail this opportunity
In a complete test, there will be minimum 3 videos and maximum 6
Back-end
Upload Videos + Question + Correct Answer + Video Publish Limit (numerical input)
Input : After how many days a user can retake the test 3 / 5 / 7
Details Report | No of submission of competed tests
Details Report of each video | completed no, start date, end date, no of days to complete 100 tests etc
Details Report of each video with each user time stamp with answers %
There are chances that we have more than 3 videos + question | In that case every user get different videos from available stock of videos otherwise 3 main videos always available
All reports should be with export option as well
Chose a Winner Option in :
Select test name / date
Select: Randomly select a winner from successful candidate
This name will be publish on winner page (Front end ) with name & city
Questions:
Which technology you will use ? WordPress / PHP / .NET ?
If you will not use word-press then do you have a very good front end designer and it must be Responsive
Price
Time Line
Programming Programmer Coding Website Developer Wordpress Designer Design Development Video
create 145+ do-follow high pr and da google penguin safe seo backlinks for extra ranking
most powerful niche relevant wikipedia seo backlinks
| Match | Count | SQL | Script |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='65288' AND A.category=B.CATID AND A.USERID=C.USERID | 1 | SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating,
C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime
FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C
WHERE A.wantid='65288'
AND A.category=B.CATID AND A.USERID=C.USERID | /opt/clerks-staging/docroot/viewwant.php 163 () () |
| SELECT * FROM seoclerks.members_recommendations WHERE USERID=705761 AND status=1 ORDER BY MRID DESC limit 1 | 1 | SELECT recommendation_text, FROMID, time_added FROM seoclerks.members_recommendations
WHERE USERID=705761 AND status=1
ORDER BY MRID DESC limit 1 | /opt/clerks-staging/docroot/include/functions/main.php 21955 getLastRecommendation() () |
| SELECT * FROM seoclerks.members WHERE USERID='977552' | 1 | SELECT username FROM seoclerks.members WHERE USERID='977552' | /opt/clerks-staging/docroot/include/functions/main.php 1577 insert_get_username_from_userid() () |
| SELECT * FROM ratings_buyer WHERE USERID=705761 | 1 | SELECT sum(good) as thumbup, sum(bad) as thumbdown
FROM ratings_buyer WHERE USERID=705761 | /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 65288 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Programming Programmer Coding Website Developer Wordpress Designer Design Development Video%' ) LIMIT 4 | 1 | SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo
FROM wanttobuy A,
categories_wanttobuy B
WHERE A.wantid != 65288
AND A.category=B.CATID
AND A.active=1
AND (A.tags like '%Programming Programmer Coding Website Developer Wordpress Designer Design Development Video%' ) LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 551 () () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 65288 AND A.category=B.CATID AND A.active=1 AND A.USERID=705761 LIMIT 4 | 1 | SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo
FROM wanttobuy A, categories_wanttobuy B
WHERE A.wantid != 65288
AND A.category=B.CATID
AND A.active=1
AND A.USERID=705761
LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 568 () () |
| SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='65288' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc | 1 | SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture
FROM wantcomments a, seoclerks.members b
WHERE a.PID='65288' AND a.USERID=b.USERID and b.status='1' AND a.status=1
order by a.CID asc | /opt/clerks-staging/docroot/viewwant.php 835 () () |
| UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='65288' | 1 | UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='65288' | /opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() () |
| SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='65288' ORDER BY w.bidid ASC | 1 | SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture
FROM wantbids as w,
seoclerks.members AS m
WHERE w.active=1
AND m.USERID=w.USERID
AND m.status=1
AND w.USERID>0
AND w.wantid='65288'
ORDER BY w.bidid ASC
| /opt/clerks-staging/docroot/viewwant.php 1192 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=684591 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=684591 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=562715 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=562715 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=590334 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=590334 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM categories_wanttobuy | 1 | SELECT * FROM categories_wanttobuy | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| SELECT * FROM posts WHERE USERID=705761 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=705761 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal() |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='684591' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='684591' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='562715' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='562715' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='590334' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='590334' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='705761' | 1 | SELECT profile_data FROM seoclerks.members WHERE USERID='705761' | /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
