SEOClerks

need a developper help

need a developper help

hello i have a payment processor script that i get it from internet called solarpay need some updates and error fixes and add some missing pages to that page and make a newer database because the current one is too old and contain some error so its not easy to dumb it to the database

also i want an added feature for an extra price will be paid separateley for the developper who will accept my offer to fix this script errors

the feature is to add a new payment gateway module for deposit option to the script and that it's to use prepaid cards to recharge user account as cell phones unit recharge cards

people buy a card scratch the card to reveal the code and insert the code to fund their account with the specified card code amount

features of this modules:

  • the system will generates cards codes with specified amount choosed by the admin its mean that i want want to generate 1000 card of 10$ it done within a click the system will generate it
  • generate also a serial number for every card code generated
  • ability to recover the recharge card through card serial number search
  • every code recharged will be deleted and out of stock
  • this used code cannot be re-generated by the system when creating new recharge cards numbers

i will pay for this module 50$

Redesign the home page look with a responsive design 20$

thats mean in generally i will pay 100$ for all of this


Requirements

a well talent developper:

i will send you the script and you install it on your server and browse the site for errors

  1. ?fix the script error and make it related to my domain because its too much realted to solarpay.com so it need to browse the site to see errors
  2. rewrite the database
  3. add missing pages in admin panel ( write new ones).
  4. add the new module to the script and match it with deposit options


Skills Required

Php Ajax Html Database Mysql

Bids

i can do this for you

hey there,

it will be our pleasure to work with you on this project. i am a php web developer with 8+ years of experience. i have worked on integrating various apis like paypal, google maps, facebook api, twitter api, instagram api etc.i possess the following skillsets which are required for your project

skills: html, css, php, mysql, twitter

hi sir, i am willing to fix errors for you for just $5 at a low price, please pm me if interested.

Bid On Listing Created 10 years ago in Programming

Other jobs by rabih4483

Order Now
Process Time: 0.16641211509705

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

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

SELECT * FROM seoclerks.members_recommendations WHERE USERID=53451 AND status=1 ORDER BY MRID DESC limit 11SELECT recommendation_text, FROMID, time_added FROM seoclerks.members_recommendations WHERE USERID=53451 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='29934'1SELECT username FROM seoclerks.members WHERE USERID='29934'

/opt/clerks-staging/docroot/include/functions/main.php 1577 insert_get_username_from_userid() ()

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

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

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

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

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

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

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='38082' 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='38082' 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='38082'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='38082'

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

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

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

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

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

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

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

/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=534511SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=53451

/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='18839'1SELECT profilepicture FROM seoclerks.members WHERE USERID='18839'

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

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

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

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

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

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

/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.1105161SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 38082 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Ajax Html Database Mysql%' ) LIMIT 40.1105160.110516