Beverly
Level X3
Write the reason you're deleting this FAQ
Let's say you find a really good SEOClerks service advertised on someone's blog and it's linking to SEOClerks and you click through to place the order. Assuming you are already an SEOClerks member, does your original referrer get the credit for that sale or does the person who posted the new link (that you clicked on to get to that page) get the credit for the sale and earn commission?
Let's say you find a really good SEOClerks service advertised on someone's blog and it's linking to SEOClerks and you click through to place the order. Assuming you are already an SEOClerks member, does your original referrer get the credit for that sale or does the person who posted the new link (that you clicked on to get to that page) get the credit for the sale and earn commission?

Are you sure you want to delete this post?
To re-phrase Beverly's Question:
Let's says a NEW MEMBER Clicks on Affiliate Link #1 on a Facebook Page which brings that User to a Service for Youtube Views, but WITHIN that Service that same User Clicks on an Affiliate Signup Banner placed there by the Service Provider such as this:
Affiliate Link #2
WHO GETS THE AFFILIATE??
CLICK #1 or CLICK #2
I remember asking @jordan the same question long ago. Perhaps this might be a Question for him. Jordan?
[quote][U][B]To re-phrase [I]Beverly's[/I] Question[/B][/U]:
[SIZE=5]Let's says a [U]NEW MEMBER[/U] Clicks on [url=https://www.seoclerks.com/linkin/1234/youtube/19672/All-in-One-SEO-LAUNCH-Youtube-Video-to-TOP-of-Google-Searches-with-Social-Bookmarks-and][I][U][B][COLOR=rgb(0, 0, 255)]Affiliate Link #1[/COLOR][/B][/U][/I][/URL] on a Facebook Page which brings that User to a Service for [I]Youtube Views[/I], but [U][B][I]WITHIN[/I] that Service[/B][/U] that same User Clicks on an [I][B][COLOR=rgb(255, 0, 0)]Affiliate Signup Banner[/COLOR][/B][/I] placed there by the [I][B]Service Provider[/B][/I] such as this: [/SIZE]
[CENTER][U][I][B][COLOR=rgb(255, 0, 0)]Affiliate Link #2[/COLOR][/B][/I][/U]
[url=https://www.seoclerks.com/linkin/3764/signup][url=https://www.seoclerks.com/files/user/images/SC_Signup_Banner.jpg][IMG]https://www.seoclerks.com/files/user/images/SC_Signup_Banner.jpg[/IMG][/url][/URL]
[SIZE=7][B][U]WHO GETS THE AFFILIATE[/U]?? [/B][/SIZE]
[COLOR=rgb(0, 0, 255)][I][B]CLICK #1[/B][/I][/COLOR] or [I][B][COLOR=rgb(255, 0, 0)]CLICK #2
[/COLOR][/B][/I][/CENTER]
[B][SIZE=5][COLOR=rgb(0, 0, 0)]I remember asking @[USER=1]jordan[/USER] the same question long ago. Perhaps this might be a Question for him. Jordan?[/COLOR][/SIZE][/B][/quote]
Ah, I see, I can remember this question being asked somewhere a while ago too, I cant for certain remember the answer, but I think it is the most recent affiliate id attached to the sign up. So if I visit via Affiliate Link #1 but don't sign up yet, click on a different link with a different ID (Affiliate Link #2) then sign up, im sure I would be an affiliate under the account of Affiliate Link #2. :P
Are you sure you want to delete this post?
Are you sure you want to delete this post?
That affiliate is yours and you get all the commissions from them, doesn't matter if they keep visiting SEO Clerks through other Affiliate Links after they've already signed up under you, that is your affiliate(s).
ah, so your wanting to know if an affiliate you already have under you orders a service after visiting via someone else's link / ID.. :P That affiliate is yours and you get all the commissions from them, doesn't matter if they keep visiting SEO Clerks through other Affiliate Links after they've already signed up under you, that is your affiliate(s). :P
Are you sure you want to delete this post?
ah, so your wanting to know if an affiliate you already have under you orders a service after visiting via someone else's link / ID..That affiliate is yours and you get all the commissions from them, doesn't matter if they keep visiting SEO Clerks through other Affiliate Links after they've already signed up under you, that is your affiliate(s).
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='13766' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='13766' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='147' | 1 | SELECT * FROM seoclerks.members WHERE USERID='147' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='35' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='35' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=147 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=147 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=13766 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=13766
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13766' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='13766' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70773 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=70773
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70774 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=70774
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70775 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=70775
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70776 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=70776
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70777 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=70777
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70778 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=70778
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='13766' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='13766' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='13766' AND status='1' AND (question like '%A question ordering SEOClerks affiliate links%' OR question like '%question%' OR question like '%ordering%' OR question like '%SEOClerks%' OR question like '%affiliate%' OR question like '%links%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='13766' AND status='1'
AND (question like '%A question ordering SEOClerks affiliate links%' OR question like '%question%' OR question like '%ordering%' OR question like '%SEOClerks%' OR question like '%affiliate%' OR question like '%links%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='750' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='750' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=13766%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=13766%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='1856.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1856.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='3764.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3764.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='147.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
| 0.099260 | 1 | SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%softwere%') ORDER BY total_recommendations desc LIMIT 0,40 | 0.099260 | 0.099260 |
Sean101
Are you sure you want to delete this post?