I am attempting to build a Rap Battle website and need the following Plugin Developed, AS WELL AS other help.
1. Timed Blog Posts
I need a page where users can click on other users, thus sending them a challenge. Once the challenger accepts, they are both thrown into a rap battle. Sort of like a chat room. But just for the two of them. There will be a timer that will time everything somewhere noticeable on the page.
There will be a brief description on how the battle works that'll last 20 seconds. Out of the two rappers, the challenger will select who goes first. The opponent who goes first will then see a short description of their enemy that'll last 20 seconds. At ten seconds left, I would like for a "Get Ready" alert to pop up.
After those 20 seconds, the rap battle will begin. The first rapper will have 90 seconds to write a diss about their opponent based on the short description they saw beforehand. There will be no character limit, so they can write as much as they want in 90 seconds. They can hit enter and send what they have written so far whenever they choose. Their turn will only end once the 90 seconds are up.
After those 90 seconds are up, there will be a brief 30 second intermission. This is where the second rapper would read the diss and start coming up with ideas to respond. I would like for an alert to pop up saying "Intermission". Then, the second rapper will be given the same 20 seconds with the description of the first rapper. And at 10 seconds, the alert for "Get Ready" will go off again. Just some text that pops up would do perfect.
Then they will have 90 seconds to spit their diss back. Same rules apply.
After the 90 seconds, an alert will pop up saying "The Battle is Over".
There will be a 30 second wait, and then both users will be redirected to the Rap Battle page on my website. Users can than vote on the battle, giving it thumbs up or thumbs down, and be able to comment on it.
Other help developing website explained upon messaging.
1. Timed Blog Posts
I need a page where users can click on other users, thus sending them a challenge. Once the challenger accepts, they are both thrown into a rap battle. Sort of like a chat room. But just for the two of them. There will be a timer that will time everything somewhere noticeable on the page.
There will be a brief description on how the battle works that'll last 20 seconds. Out of the two rappers, the challenger will select who goes first. The opponent who goes first will then see a short description of their enemy that'll last 20 seconds. At ten seconds left, I would like for a "Get Ready" alert to pop up.
After those 20 seconds, the rap battle will begin. The first rapper will have 90 seconds to write a diss about their opponent based on the short description they saw beforehand. There will be no character limit, so they can write as much as they want in 90 seconds. They can hit enter and send what they have written so far whenever they choose. Their turn will only end once the 90 seconds are up.
After those 90 seconds are up, there will be a brief 30 second intermission. This is where the second rapper would read the diss and start coming up with ideas to respond. I would like for an alert to pop up saying "Intermission". Then, the second rapper will be given the same 20 seconds with the description of the first rapper. And at 10 seconds, the alert for "Get Ready" will go off again. Just some text that pops up would do perfect.
Then they will have 90 seconds to spit their diss back. Same rules apply.
After the 90 seconds, an alert will pop up saying "The Battle is Over".
There will be a 30 second wait, and then both users will be redirected to the Rap Battle page on my website. Users can than vote on the battle, giving it thumbs up or thumbs down, and be able to comment on it.
hello sir,
i am ready for works.
thanks
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='20409' 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='20409'
AND A.category=B.CATID AND A.USERID=C.USERID | /opt/clerks-staging/docroot/viewwant.php 163 () () |
| SELECT * FROM seoclerks.members_recommendations WHERE USERID=51299 AND status=1 ORDER BY MRID DESC limit 1 | 1 | SELECT recommendation_text, FROMID, time_added FROM seoclerks.members_recommendations
WHERE USERID=51299 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='142916' | 1 | SELECT username FROM seoclerks.members WHERE USERID='142916' | /opt/clerks-staging/docroot/include/functions/main.php 1577 insert_get_username_from_userid() () |
| SELECT * FROM ratings_buyer WHERE USERID=51299 | 1 | SELECT sum(good) as thumbup, sum(bad) as thumbdown
FROM ratings_buyer WHERE USERID=51299 | /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 20409 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Programming Coding Godaddy Wordpress Plugins%' ) 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 != 20409
AND A.category=B.CATID
AND A.active=1
AND (A.tags like '%Programming Coding Godaddy Wordpress Plugins%' ) LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 551 () () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 20409 AND A.category=B.CATID AND A.active=1 AND A.USERID=51299 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 != 20409
AND A.category=B.CATID
AND A.active=1
AND A.USERID=51299
LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 568 () () |
| SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='20409' 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='20409' 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='20409' | 1 | UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='20409' | /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='20409' 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='20409'
ORDER BY w.bidid ASC
| /opt/clerks-staging/docroot/viewwant.php 1192 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=48545 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=48545 | /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=51299 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=51299 | /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='48545' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='48545' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='51299' | 1 | SELECT profile_data FROM seoclerks.members WHERE USERID='51299' | /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |