exjordanary
Level X5
Write the reason you're deleting this FAQ
The Single Ad HTML API Function is where you can use the API to display Single TEXT LINKS of Services you Specify to Display in the API Settings HERE.
Be sure to Set the "Order By" (How this data is ordered) to "Randomly"
and the "Output Type" (How you would like the data presented to you) to "Single Ad HTML"
Then, simply Copy and Paste the Same Code Multiple times (per line) on your Site, and a different Service will show up per Link. You will NEVER need to Update it because it will always display CURRENT Data from SEOClerk's Servers.
For example, I wanted to show $5 Services only in the Social Networks Category for THIS PAGE (bottom)
So I simply Pasted this Code below over and over (per link displayed):
[HTML]<div align="center"><span style="font-size: 15px;"><span style="color: #3366ff;"><em>THIS Seller will</em></span> <strong><span style="color: #ff0000;">---></span></strong>[iframe src="https://www.seoclerks.com/api?type=inlinead&s=&aff=3764&by=&mp=5&p=5&c=23&ul=1&am=40&ins=0&g=0&sub=0&os=0&sp=0&oby=&oh=&f=singlehtml" get_params_from_url="1" style="span-font: bold;" height="24" width="600"]</span></div>[/HTML]
(Since I use Wordpress, I use THIS Plugin for using iFrames - so the usual <iframe> Open/Close Tags in this Code has been changed to the Plugin's Shortcode)
For NON Wordpress:
[HTML]<div align="center"><span style="font-size: 15px;"><span style="color: #3366ff;"><em>THIS Seller will</em></span> <strong><span style="color: #ff0000;">---></span></strong><iframe src="https://www.seoclerks.com/api?type=inlinead&s=&aff=3764&by=&mp=5&p=5&c=23&ul=1&am=40&ins=0&g=0&sub=0&os=0&sp=0&oby=&oh=&f=singlehtml" get_params_from_url="1" style="span-font: bold;" height="24" width="600"</iframe></span></div>[/HTML]
RESULTS LOOK LIKE THIS:
[Making Use of "Single Ad HTML" API Function & RSS Feeds]
Also, if you're interested in seeing what's Possible using your Affiliate ID in RSS Feeds from SEOClerks,
Check out our New WP Blog called SocialCurrency which runs on COMPLETE Auto-Pilot using Affiliate RSS Feeds from SEOClerks, ListingDock, AND CodeClerk's via WTT, WTB, AND Standard Service Feeds -What's cool is, not only is your Affiliate ID is embedded into ALL Content Links Published on the site, but every Post ALSO get's Shared to Twitter, Facebook, Tumblr, Google+, Linkedin, & Pocket - ALL on COMPLETE 100% Auto-Pilot !!!.
If you're interested in having me create a Similar Auto-Pilot Affiliate Blog for you too- Please PM me
SocialCurrency.pw
Or, to learn more about making the most use of your Affiliate ID, please see our TUTORIAL HERE
See our Affiliate Store....
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='13826' | 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='13826' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='3764' | 1 | SELECT * FROM seoclerks.members WHERE USERID='3764' | /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=3764 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=3764 | /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=13826 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=13826
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13826' 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='13826' 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=71165 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=71165
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=71166 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=71166
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=71167 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=71167
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=71168 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=71168
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='13826' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='13826' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='13826' AND status='1' AND (question like '%Making %' OR question like '%Making%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='13826' AND status='1'
AND (question like '%Making %' OR question like '%Making%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='41128' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='41128' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='43' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='43' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='13366' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='13366' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='5234' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='5234' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='59606' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='59606' 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=13826%' 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=13826%'
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='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='58499.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='58499.png' | /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 |
exjordanary
Are you sure you want to delete this post?