Hello, I have a Av Arcade website. Based on (avscripts.net) Version 5.8!
I will need you to tweak my website and add a lot of new features... You will need to understand the system.
I will list the following features i want added:
1) User Chat System... once they are logged in they can chat with there username and guests can join chat should be next to the game or underneath the game depending on how big the game is. If you can make it where someone clicks on the username it will bring them to there profile. Like Kongregate!
2) Store - users can redeem there coins (by playing games) so they can win prizes and cool stuff
3) Lottery - users can buy a lottery ticket and win
4) Login Popup - users can login faster instead of loading the login.php. Pop up that logins them in
5) Level System - Once users has reached a certain amount of points they will rank up, max rank 50. 1k = 1 rank
6) Moderator Panel - Admins will be able to create normal users moderators who can view the reports and ban users
7) Online/Offline - Users will be able to see if they are online when they go to their profile (green dot)
8) Premium Users - Users will pay $10 to become a PRO user and they will get NO ads and a special icon on there profile and in the chat rooms
9) Developers - if a user has uploaded a game they will receive a specail icon on there profile and in the chat rooms
10) Show Friends on Profile - When user goes to profile of someone they will be able to see the avatars of there friends
11) Avatar gallery - Users will be able to choose a certain avatar to use instead of everyone using the default
12) Improve Template - Make better add a couple features 
13) Infractions/Bans - Instead of Perma Ban which is now i want the option to ban for 1 day, 1 week, 1 month or forever
14) Only Allow users to click max of 2 ads per day... (Click Bombing)
15) Username Colors - Make Admins - Red, Moderators - Orange, Premium - Blue, Member of Week - Gold, Member (normal) - Black, Banned is borwn
16) Username - Allow users to add a glow(green/pink) to there user name for $5/year - free if you are pro user
17) Member of the week - most active user/most game plays - can only be won once every 3 months! {makes username title gold}
18) INSTALL ^^^ ON MY WEBSITE AND RUN SMOOTHLY!
IF YOU CAN DO 12/18 OF THESE MESSAGE ME STILL!
We will discuss each mod into further detail. Must blend into my template!Skills required:
Complete all 18 tasks!
i will do your job eaisly bcz i saw your site all things its no problem for me
i have pp account only if you pay me in my paypel 120usd so after one day i start your work and finish soon
my seo payment system its too delay to withdraw so its take 8 days that is why i need pp payment to work frst
hope you understand
experienced over php database driven programming and web application development ..expertise on writing code for plugin development ,module development and implement perfect design pattern..
| Match | Count | SQL | Script |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='17536' 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='17536'
AND A.category=B.CATID AND A.USERID=C.USERID | /opt/clerks-staging/docroot/viewwant.php 163 () () |
| SELECT * FROM ratings_buyer WHERE USERID=102677 | 1 | SELECT sum(good) as thumbup, sum(bad) as thumbdown
FROM ratings_buyer WHERE USERID=102677 | /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 17536 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Html Ajax Javascript Mysql Database Css%' ) 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 != 17536
AND A.category=B.CATID
AND A.active=1
AND (A.tags like '%Php Html Ajax Javascript Mysql Database Css%' ) LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 551 () () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 17536 AND A.category=B.CATID AND A.active=1 AND A.USERID=102677 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 != 17536
AND A.category=B.CATID
AND A.active=1
AND A.USERID=102677
LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 568 () () |
| SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='17536' 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='17536' 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='17536' | 1 | UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='17536' | /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='17536' 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='17536'
ORDER BY w.bidid ASC
| /opt/clerks-staging/docroot/viewwant.php 1192 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=211889 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=211889 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=222441 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=222441 | /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=102677 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=102677 | /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='211889' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='211889' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='222441' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='222441' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='102677' | 1 | SELECT profile_data FROM seoclerks.members WHERE USERID='102677' | /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
