diypublic
Level 3
Write the reason you're deleting this FAQ
If you know how I can add "Promote this service" on my listings, Please share it.
I'm a Level 3 seller.
I'm looking for affiliates to share the income from my Gigs.
Les...
re: 'How do I add " Promote this service" on my listings' is ranked 5 out of 5. Based on 1 user reviews.
Thank you, great advice here. Can't thank you enough...:)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
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='9438' | 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='9438' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='225184' | 1 | SELECT * FROM seoclerks.members WHERE USERID='225184' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=225184 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=225184 | /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=9438 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=9438
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='9438' 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='9438' 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=38833 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=38833
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=38839 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=38839
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=38163 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=38163
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=38164 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=38164
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='9438' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='9438' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='9438' AND status='1' AND (question like '%How I add "Promote service" listings?%' OR question like '%"Promote%' OR question like '%service"%' OR question like '%listings?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='9438' AND status='1'
AND (question like '%How I add "Promote service" listings?%' OR question like '%"Promote%' OR question like '%service"%' OR question like '%listings?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='60265' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='60265' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='16706' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='16706' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='22718' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='22718' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='77394' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='77394' 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=9438%' 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=9438%'
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='6160.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6160.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='225184.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='225184.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='29365.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='29365.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 |
hitmeasap
I suppose you're talking about how you can promote your services using your Affiliate ID to gain affiliates and earn a passive income? -Here's how you add your Affiliate ID to any service you'd like.
First of all, you'll need to locate your Affiliate ID. Your Affiliate ID can be found on your balance page: https://www.seoclerks.com/balance/ click on "Affiliate Sales". Below the "Awaiting Clearance"? and "Revenue Purchases" you'll find your ID.?
As you can see below my Affiliate ID is: /linkin/6160/
In the screenshot below you can see an ordinary service url on SEOClerks.
If I want to include my Affiliate ID onto this url, I do it like this:
See how the url has changed? It now says "a.seoclerks.com/linkin/XXXX" after I added my Affiliate ID onto this url.
To make it even easier to understand. Here it is in writing:
The regular url:
https://www.seoclerk.com/Other/439146/FiverrClerks-Review-Copy-23-750-BANKED
The url including my affiliate id:
https://www.seoclerk.com/linkin/6160/Other/439146/FiverrClerks-Review-Copy-23-750-BANKED
When using the link that includes my Affiliate ID, the url will end up like this:
http://a.seoclerks.com/linkin/6160/Other/439146/FiverrClerks-Review-Copy-23-750-BANKED
Inserting your Affiliate ID onto your service urls will make it easy for you to gain affiliates. Welcome on board the SEOClerks Affiliate Program and Good luck!
Best Regards,
hitmeasap Hello, I suppose you're talking about how you can promote your services using your Affiliate ID to gain affiliates and earn a passive income? -Here's how you add your Affiliate ID to any service you'd like. First of all, you'll need to locate your Affiliate ID. [b]Your Affiliate ID can be found on your balance page: [/b]https://www.seoclerks.com/balance/ click on [i]"Affiliate Sales"[/i]. Below the [i]"Awaiting Clearance"[/i]? and [i]"Revenue Purchases"[/i] you'll find your ID.? [b]As you can see below my Affiliate ID is:[i] ?[/i][/b][i]/linkin/6160/[/i][url=https://www.seoclerk.com/files/user/images/affid.jpg][img]https://www.seoclerk.com/files/user/images/affid.jpg[/img][/url] [b]In the screenshot below you can see an ordinary service url on SEOClerks.[/b] [url=https://www.seoclerk.com/files/user/images/url(32).jpg][img]https://www.seoclerk.com/files/user/images/url(32).jpg[/img][/url] [b]If I want to include my Affiliate ID onto this url, I do it like this:[/b] [url=https://www.seoclerk.com/files/user/images/affidinservice.jpg][img]https://www.seoclerk.com/files/user/images/affidinservice.jpg[/img][/url] [b]See how the url has changed?[/b] It now says "a.seoclerks.com/linkin/XXXX" after I added my Affiliate ID onto this url. To make it even easier to understand. Here it is in writing: [b]The regular url:[/b] https://www.seoclerk.com/Other/439146/FiverrClerks-Review-Copy-23-750-BANKED [b]The url including my affiliate id:[/b] https://www.seoclerk.com[b][color=#FF0000]/linkin/6160/[/color][/b]Other/439146/FiverrClerks-Review-Copy-23-750-BANKED [b]When using the link that includes my Affiliate ID, the url will end up like this:[/b] [color=#FF0000][b]http://a.seoclerks.com/linkin/6160[/b][/color]/Other/439146/FiverrClerks-Review-Copy-23-750-BANKED Inserting your Affiliate ID onto your service urls will make it easy for you to gain affiliates. Welcome on board the SEOClerks Affiliate Program and Good luck! Best Regards, hitmeasap
Are you sure you want to delete this post?