SEOClerks

Clear
Sign In Join

Did you install your own SEOClerks affiliate store?

  • Dayton Level 1
    • 7

    Write the reason you're deleting this FAQ

    Did you install your own SEOClerks affiliate store?

    I'm considering an SEOClerks affiliate store but not exactly sure I have the right hosting requirements for the store. I want to consult with someone who knows about affiliate stores as to whether or not they are difficult to install.

    Did you install your own SEOClerks affiliate store or pay the seller to install for you?

    # Affiliate Marketing
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    jakemadness

    jakemadness

    Some affiliate stores are very straight forward to install, most affiliate stores should contain a read_me.txt file or some sort of documentation of how to install the store. SEOClerks affiliate stores are lightweight and powered by the SEOClerks API so they do not need a database, the only things that should be edited are configuration settings like the stores name and how many services to list.
    12 years ago

    Are you sure you want to delete this post?

    Samalan

    Samalan

    My affiliate store is simply a WordPress theme so all you need to do is upload the .zip file and you are done. The link the theme is here: https://www.seoclerks.com/wordpres...-Wordpress-Theme

    I also purchased ShadyX's affiliate store which is simple and all you need to do is upload it using File Manager in cPanel or through an FTP client so it isn't that hard. The link to the software is: https://www.seoclerks.com/PHP/7540...-affiliate-store

    As shown above, there are different affiliate stores which involve different installations however they don't get much harder than that. If you do need help, feel free to contact me and I can help you out.
    12 years ago

    Are you sure you want to delete this post?

    ultimate

    ultimate

    I did see few of my clients having trouble installing the scripts I wrote just because they were unaware of the technical lines, no matter how simple they were.
    That is what led to the birth of iOnCLERK.
    Some say its costly as a affiliate site. I agree but they don't see the fact that they get the hassle free installation & hosting.
    12 years ago

    Are you sure you want to delete this post?

    exjordanary

    exjordanary

    I have purchased Shady's Script. What part are you having trouble with?

    Who do you host with?
    Do you have perl active?
    What PHP Version?
    Do you have cPanel?

    What is your domain name?
    -ex
    12 years ago

    Are you sure you want to delete this post?

    sharpcoders

    sharpcoders

    I've my own SEOClerks Affiliate Store ( http://scriptclerks.com ) and there is no special requirements for hosting. Here is my service https://www.seoclerks.com/PHP/1847...Store-Responsive
    and No doubt ShadyX's affiliate store is also good and works fine.
    12 years ago

    Are you sure you want to delete this post?

    exjordanary

    exjordanary

    I'm considering an SEOClerks affiliate store but not exactly sure I have the right hosting requirements for the store. I want to consult with someone who knows about affiliate stores as to whether or not they are difficult to install.

    Did you install your own SEOClerks affiliate store or pay the seller to install for you?


    @Samalan - Read my Post above.

    @Dayton - I host with NameCheap and run Multiple Affiliate Scripts with multiple Domains with them and never had a problem. Including Shady's Script, Wordpress, and some of my Own.

    They are even Trusted by SEOClerks:
    Did you install your own SEOClerks affiliate store?


    You can See one of my Stores HERE (to see more, simply click on the ones listed in the Header or Footer)
    Or, for Wordpress, you can see an Auto-Post Site using multiple Affiliate RSS Feeds HERE
    I also run the SEOClerks Blog on WP, HERE



    Hope this helps,
    Did you install your own SEOClerks affiliate store?
    12 years ago

    Are you sure you want to delete this post?

    jakemadness

    jakemadness

    My affiliate store should be able to run on most hosts since it auto detects what request method can be used. It has multiple available methods to request the SEOClerks API with including the following: curl, file_get_contents, file, readfile, fopen and more.
    12 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.40833783149719

    Possible Duplicate queries found!
    MatchCountSQLScript
    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='13775'1SELECT 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='13775'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='35973'1SELECT * FROM seoclerks.members WHERE USERID='35973'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM categories_faq WHERE CATID='35'1SELECT 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=359731SELECT googleplus_profile FROM seoclerks.members WHERE USERID=35973

    		/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=13775 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=13775 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13775' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='13775' 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=70862 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70862 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=70863 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70863 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=70864 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70864 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=70865 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70865 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=70866 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70866 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=70867 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70867 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=70868 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=70868 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='13775'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='13775'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='13775' AND status='1' AND (question like '%Did install SEOClerks affiliate store?%' OR question like '%install%' OR question like '%SEOClerks%' OR question like '%affiliate%' OR question like '%store?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='13775' AND status='1' AND (question like '%Did install SEOClerks affiliate store?%' OR question like '%install%' OR question like '%SEOClerks%' OR question like '%affiliate%' OR question like '%store?%') -- ORDER BY RAND() LIMIT 15

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

    SELECT * FROM seoclerks.members WHERE USERID='750' limit 11SELECT 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 11SELECT 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 seoclerks.members WHERE USERID='2255' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2255' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='3160' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3160' 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=13775%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=13775%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='3764.png'1SELECT 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='20014.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='20014.jpg'

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

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

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

    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.1457861SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%salesup%' OR A.skills LIKE '%salesup%') ORDER BY A.lastgigedit desc LIMIT 0,400.1457860.145786
    0.1104091SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%salesup%' OR A.skills LIKE '%salesup%')0.1104090.110409