SEOClerks

Create an online affiliate referral website

Create an online affiliate referral website

This is a half way work from a web designer and now I need an online website designer can continue this project which is a referral can log in and enter in website system online, which admins can see at the back too, i think like, i think you can design by yourself as long the below have make it for their requirements :

(1) first all, members sign up and log in and go in the password

(2) and they all have their own referral code number so they can either type in themselves or give their referral number to their down line register

(3) and every members have two lines of referral , example if i intro you and i will get the commissions and also if you intro the other new customers, and i will get the percentage of commissions as well too , so is two level of percentage of earning

(4) every customers must state out need to pay soon, expired, paid when and start when they make the payment, must set as in reminders for them, automatically to remind each members for payment due and their downline cancel or didnt make the payment yet

(5) every members can see their own first line name, email, phone number and address, only one line

(6) must be simple and easy to understand to look on it for every members

i will try my best get more info, do you have anything you want to ask from me so i can get more details ? and the budget from my friend for this $123 and already we already have hosting and domain ready.


Requirements

This is a half way work from a web designer and now I need an online website designer can continue this project which is a referral can log in and enter in website system online, which admins can see at the back too, i think like, i think you can design by yourself as long the below have make it for their requirements :

(1) first all, members sign up and log in and go in the password

(2) and they all have their own referral code number so they can either type in themselves or give their referral number to their down line register

(3) and every members have two lines of referral , example if i intro you and i will get the commissions and also if you intro the other new customers, and i will get the percentage of commissions as well too , so is two level of percentage of earning

(4) every customers must state out need to pay soon, expired, paid when and start when they make the payment, must set as in reminders for them, automatically to remind each members for payment due and their downline cancel or didnt make the payment yet

(5) every members can see their own first line name, email, phone number and address, only one line

(6) must be simple and easy to understand to look on it for every members

i will try my best get more info, do you have anything you want to ask from me so i can get more details ? and the budget from my friend for this $123 and already we already have hosting and domain ready.


Skills Required

programm designer website link referral affliate

Bids

hi sir i have 2 years experience for web development i interested your job i can do this project please order me

hello, i can do this job inbox me. thanks &

dear,at first take my sincere respect.i have read your description very carefully.i will love to have the opportunity to fulfill your job.my goal is to earn positive review from you and i believe that i can do it in the best way than others.i am professional wordpress website developer and designer. i am professionally trained by the top rated sell

1000 web 2.0 backlink creations and high quality original spun content for better seo promotions for

Bid On Listing Created 7 years ago in Other

Other jobs by daisy777

Order Now
Process Time: 0.69636416435242

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

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

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

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

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 69062 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%programm designer website link referral affliate%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 69062 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%programm designer website link referral affliate%' ) LIMIT 4

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

/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.1028411SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 69062 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%programm designer website link referral affliate%' ) LIMIT 40.1028410.102841