Single leg MLM Matrix Plan
UserSide:
Register:
ØRegister with ReferralSponsor ID
ØEnter the user details
ØEnter User’s Emailaddress and Mobile number
ØEnter nominee detail
Ø Register with Bitcoin (Block.io), Perfectmoney , Payeer, AdVCash, coinpayment Payment gateway
Login:
ØUser can log in with profile ID and Email address along with a password
ØUser have forget password option
ØUser can re-set password using Email
Commission Details:
ØAfter completing the user registration direct referral bonus will be sent to their sponsor
ØIf a new user the package at the time of registration, the commission will be credited.
Dashboard:
Ø Renewal user
§ User can view the downline user who renewal their plan
Ø Non-renewal
§ User can view the downline user who, not renewal their plan
Ø Downline list
§ User view their downline user in the table view
Ø Blank space
§ User can view their downline blank space in the table format
§ On those details, they can add a new user with details
Epin generator:
ØUser can use epin generator instead of taking membership
ØBy using epin generated from admin, user can be logged in
Profile:
ØView purchased package details
ØTotal earning of commission details
ØUser can view DownlineList
ØUser can view Overall Payout
My account:
ØView Downline user details
ØView Downline user registered date with detail
ØView Downline user details of below
§ Renewal users
§ Non-renewal users
§ Blankspace in their downline
Profile management:
ØUser can manage their profile picture
ØUser can update their password
ØUser can view their personal details
ØUser can view sponsor details
ØUser can view Nomineedetails
Plan details:
ØUser can view current plan details
ØUser can upgrade the plan
ØUser upgrade with payment gateway using either Bitcoin, Perfectmoney, AdVCash, Payeer or Epin
Payout Details:
ØView payout details of users by following
§ View bonus type (Referal Bonus)
§ View payout user details
§ View status of the payout
§ View amount and date added in payout
Single-leg Tree view (Genealogy):
ØUser view their downline user by tree view
ØTree will show the user details
ØTree will show downline user count
Send withdrawn request:
ØUser can request of their wallet amount
ØUser enter desired amount detail
ØUser enter amount with message
ØManage send withdrawn request detail
Cancel withdrawn request:
ØUser can cancel the withdrawn request
ØUser can manage the canceled withdrawn request details
TDS Deduction:
ØTDS will be deducted on every withdrawal.
ØTDS percentage can be managed by admin.
Reward:
ØUser will get a reward if they complete certain pair (managed by admin)
ØReward icon will be shown in their profile
Wallet Statement:
ØUser can view the wallet statement
ØUser can view the reason for credit and amount credited in their wallet
ØUser can view the status
Mail systems:
ØUser can view mail statistics of following
§ Send & Received
§ Read and Unread
ØUser can send a message to admin and users
ØUser view their received message details
ØView read and unread mails
Package:
ØUser can view available Package with detail at registration
ØUser can buy Package through the payment gateway
ØManage package purchased details in profile
News:
ØUser can view available news in the site
ØView detail with media
Events:
ØUser can view available event in the site
ØView detail with media
CMS pages:
ØAbout us
ØContact us
ØTerms & Condition
ØPrivacy policy
ØTestimonials
ØFAQ
ØSocial network connections
Admin inSide:
Menu Management:
Ø Admin can manage all the menus listed
Ø Admin can change the status of the menu
Ø Admin can delete the menu
Staff Management:
Ø Admin can manage all the staff (sub admin)
Ø Admin can change the status of the staff (sub admin)
User Management:
Ø Admin can manage all the users listed
Ø Admin can search the user using date, name, etc
Country:
Ø Admin can manage all the countries, cities, etc
Testimonials:
Ø Admin can manage all the Testimonials
Feedback:
Ø Admin can manage all the feedbacks
Ø Admin can give reply to the feedback
News Management:
Ø Admin can manage all the news listed
Event Management:
Ø Admin can manage all the events listed
Slider Management:
Ø Admincan manage all the sliders
Epin generator:
Ø Epinis generated by admin and can be given to the user
Ø Epingenerator is managed by admin
Membership Management:
Ø All memberships are managed by Admin
Ø Pricing and number of validation is managed in the admin side
Commission:
Ø SetReferral bonus: Admin can set referral bonus commission
Ø Generalplan details: Admin can set the minimum withdrawal amount and User Cashout commission percentage to pay Admin
Site setting pages:
Ø All site setting pages are managed by admin here
· CMS
· Slide settings
· Change password
· Change address
· General settings
· FAQ
· Help
· Upload document
Payout Management:
Ø All single leg Payouts like commission, referral bonus are managed by Admin
Genealogy:
Ø Singleleg tree structure is managed by Admin
Transaction Request:
Ø AllTransaction requests like withdrawal, cancel a withdrawal, withdrawal report are
managed by Admin
Support Statistics:
Ø All mail statistics, compose mail, inbox, outbox, forward, read, not read mails
are managed by Admin
Renewal:
Ø RenewalUsers: All Renewal Users are managed by Admin
Ø NonRenewal Users: All Non-Renewal Users are managed by Admin
I will show you a sample website to model.
Must be an Expert in either of the following and must have Matrix MLM Scripting pay plan understanding.
please order me 100% non drop granted fast delivery
please order me 100% non drop granted fast delivery
| Match | Count | SQL | Script |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='70280' 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='70280'
AND A.category=B.CATID AND A.USERID=C.USERID | /opt/clerks-staging/docroot/viewwant.php 163 () () |
| SELECT * FROM ratings_buyer WHERE USERID=845490 | 1 | SELECT sum(good) as thumbup, sum(bad) as thumbdown
FROM ratings_buyer WHERE USERID=845490 | /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 70280 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%PHP Larave JAVA C CSharp%' ) 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 != 70280
AND A.category=B.CATID
AND A.active=1
AND (A.tags like '%PHP Larave JAVA C CSharp%' ) LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 551 () () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 70280 AND A.category=B.CATID AND A.active=1 AND A.USERID=845490 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 != 70280
AND A.category=B.CATID
AND A.active=1
AND A.USERID=845490
LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 568 () () |
| SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='70280' 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='70280' 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='70280' | 1 | UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='70280' | /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='70280' 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='70280'
ORDER BY w.bidid ASC
| /opt/clerks-staging/docroot/viewwant.php 1192 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=480665 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=480665 | /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=845490 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=845490 | /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='480665' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='480665' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='845490' | 1 | SELECT profile_data FROM seoclerks.members WHERE USERID='845490' | /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
