I am using a affilaite plugin software to manage our affiliate programed at our website.
We need some modification to it so if any developer is there and want to
do the change let us know . Our budget it also limited and if this work
seem work , we will like to hire on monthly basis for small small
correction also,
Changes required is
When open affilaite link page at member panel it showed as below
Your affiliate ID is: 79ef8f27273a0f33cb95892143d8c0a5
Your referral URL is: https://www.udyamjob.com/?ref=79ef8f27273a0f33cb95892143d8c0a5
1. Affiliate id need to replace by user name which use at the time of registration by form filling or auto login using google, twitter, facebook etc
2. And referral url need to appear as https://www.udyamjob.com/?ref=username
3. After that need to add a social share button and a copy url option
using which user can copy the referral url to share somewhere or can
share the individual url to social media( easy social share plugin is compatible with our script for social share )
We will share plugin to make the correction with the page where to make the changes
budget will be within $20
i hope i can complete your work. i already check requirements, if you really interested then contact with me. i need to see the plugin.
you should pay me $30 for the work.
| Match | Count | SQL | Script |
| SELECT * FROM wanttotrade A, categories_wanttotrade B, seoclerks.members C WHERE A.tradeid='5494' 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.ip,
C.lastlogin, C.addtime
FROM wanttotrade A, categories_wanttotrade B, seoclerks.members C
WHERE A.tradeid='5494' AND A.category=B.CATID AND A.USERID=C.USERID | /opt/clerks-staging/docroot/viewtrade.php 165 () () |
| SELECT * FROM seoclerks.members_recommendations WHERE USERID=181149 AND status=1 ORDER BY MRID DESC limit 1 | 1 | SELECT recommendation_text, FROMID, time_added FROM seoclerks.members_recommendations
WHERE USERID=181149 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='934093' | 1 | SELECT username FROM seoclerks.members WHERE USERID='934093' | /opt/clerks-staging/docroot/include/functions/main.php 1577 insert_get_username_from_userid() () |
| SELECT * FROM ratings_buyer WHERE USERID=181149 | 1 | SELECT sum(good) as thumbup, sum(bad) as thumbdown
FROM ratings_buyer WHERE USERID=181149 | /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() () |
| SELECT * FROM wanttotrade A, categories_wanttotrade B WHERE A.tradeid!='5494' AND A.category=B.CATID and A.active='1' AND (A.tags like '%Php Plugin%' OR A.tags like '%Php%' OR A.tags like '%Plugin%') limit 4 | 1 | SELECT A.tradeid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttotrade A, categories_wanttotrade B WHERE A.tradeid!='5494' AND A.category=B.CATID and A.active='1' AND (A.tags like '%Php Plugin%' OR A.tags like '%Php%' OR A.tags like '%Plugin%') limit 4 | /opt/clerks-staging/docroot/viewtrade.php 474 () () |
| SELECT * FROM wanttotrade A, categories_wanttotrade B WHERE A.tradeid!='5494' AND A.category=B.CATID and A.active='1' AND A.USERID='181149' limit 4 | 1 | SELECT A.tradeid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttotrade A, categories_wanttotrade B WHERE A.tradeid!='5494' AND A.category=B.CATID and A.active='1' AND A.USERID='181149' limit 4 | /opt/clerks-staging/docroot/viewtrade.php 486 () () |
| SELECT * FROM tradecomments a, seoclerks.members b WHERE a.PID='5494' 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 tradecomments a, seoclerks.members b
WHERE a.PID='5494' AND a.USERID=b.USERID and b.status='1' AND a.status=1
order by a.CID asc | /opt/clerks-staging/docroot/viewtrade.php 749 () () |
| UPDATE wanttotrade SET viewcount = viewcount + 1 WHERE tradeid='5494' | 1 | UPDATE wanttotrade SET viewcount = viewcount + 1 WHERE tradeid='5494' | /opt/clerks-staging/docroot/include/functions/main.php 1741 update_tradeviewcount() () |
| SELECT * FROM tradebids 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.tradeid='5494' ORDER BY w.bidid ASC | 1 | SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, m.profilepicture, w.ip
FROM tradebids 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.tradeid='5494'
ORDER BY w.bidid ASC
| /opt/clerks-staging/docroot/viewtrade.php 1035 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=572568 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=572568 | /opt/clerks-staging/docroot/viewtrade.php 1099 () () |
| SELECT * FROM categories_wanttotrade | 1 | SELECT * FROM categories_wanttotrade | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| SELECT * FROM posts WHERE USERID=181149 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=181149 | /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='572568' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='572568' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='181149' | 1 | SELECT profile_data FROM seoclerks.members WHERE USERID='181149' | /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include() |
| SELECT * FROM seoclerks.members WHERE USERID='181149' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='181149' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
