SEOClerks

Jamroom Scrip Php Coder (Some fixes)

Jamroom Scrip Php Coder (Some fixes)

Hello guys,
I'm looking for someone who first off all will check my needs and then can say if he can complete or not. I do not want someone as i had already that in the middle of job he just not answering me and not taking calls so i think he just find something he can not made so I really need PHP EXCELLENT coder who can fix and create codes as well.
The script i am talking about is Jamroom version 4. There is need many fixes and work i wish but for this price you have to do follow:

1) Copy Artist Quota and Name it Producer and make different upload page
(i already describe how it should be looking, not design but adding more upload options and changing the names and replacing ets.. as artist quota has SONG upload and Producers needs BEAT upload. and so on, easy for php coder job done in 4-5h)

2) Using all needed info from upload pages and add it some of them not all, in the audio player (html5 this is already done only need to add new statistic like tags, duration etc.. that will be from new upload page)
3) Adding audio player button that other programmer forgot to one modul which displays some audios


This is pretty much enough for this price, i have more work on this once this is done. If i will be satisfied you will be also, as i know what means coding and how hard job sometimes is it, all i ask is that you WILL BE ABLE to create and modify php codes if needed.
Thanks everyone for bids but pls do not bid only because you think you can do it, you will have to have experience and proof me before i choose you.

PS: Also note if you are from 3rd parts of the world countries pls be sure you can have internet connection always 24/7 as i do not accept someone i had before that from 14days he was 8 off because as he told me shut down internet in his country (Egypt)

Regards


Requirements

You need to know very well Php, MySQL, HTML5 and all what it goes with it.
- Not only modify or finding errors but also create own code if needed.
Thank you for your time to read this.
Regards


Skills Required

Php Mysql Html5 Programming

Bids

i will work with you.

hello sir,

i am ready for work.

thanks

i work with the php/mysql/html5 additionally jquery and other latest web frameworks and have developed numerous scripts/sites for clients here at seoclerks and around the web. i can :

  • fix bugs
  • modify scripts
  • develop new features
  • provide support

hi

plese contact me for a list of references.

thank you
gašper

check my gigs for more details

Bid On Listing Created 12 years ago in Programming

Other jobs by branoko

Order Now
Process Time: 0.22012782096863

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='9980' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT 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='9980' AND A.category=B.CATID AND A.USERID=C.USERID

/opt/clerks-staging/docroot/viewwant.php 163 () ()

SELECT * FROM ratings_buyer WHERE USERID=1235331SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=123533

/opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9980 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Mysql Html5 Programming%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9980 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Mysql Html5 Programming%' ) LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 551 () ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9980 AND A.category=B.CATID AND A.active=1 AND A.USERID=123533 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9980 AND A.category=B.CATID AND A.active=1 AND A.USERID=123533 LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 568 () ()

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='9980' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT 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='9980' 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='9980'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='9980'

/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='9980' ORDER BY w.bidid ASC 1SELECT 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='9980' ORDER BY w.bidid ASC

/opt/clerks-staging/docroot/viewwant.php 1192 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=866131SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=86613

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=485451SELECT 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 seoclerks.members as m WHERE m.USERID=256651SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=25665

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=74531SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=7453

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=60701SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=6070

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

SELECT * FROM posts WHERE USERID=1235331SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=123533

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='86613'1SELECT profilepicture FROM seoclerks.members WHERE USERID='86613'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='48545'1SELECT 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='25665'1SELECT profilepicture FROM seoclerks.members WHERE USERID='25665'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='7453'1SELECT profilepicture FROM seoclerks.members WHERE USERID='7453'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='6070'1SELECT profilepicture FROM seoclerks.members WHERE USERID='6070'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='123533'1SELECT profile_data FROM seoclerks.members WHERE USERID='123533'

/opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.1701071SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Buiness%' OR A.skills LIKE '%Buiness%') ORDER BY A.lastgigedit desc LIMIT 0,400.1701070.170107
0.1261471SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9980 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Mysql Html5 Programming%' ) LIMIT 40.1261470.126147
0.1164901SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Englishproficien%') ORDER BY total_recommendations desc LIMIT 0,400.1164900.116490
0.1126281SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%seooffpage%') ORDER BY total_recommendations desc LIMIT 0,400.1126280.112628
0.0718681SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Englishproficien%') 0.0718680.071868