SEOClerks

What would you like to see as widgets on affiliate stores?



Write the reason you're deleting this FAQ

What would you like to see as widgets on affiliate stores?

Hello viewers, I would like to know what you would like to see in an affiliate store I will be realising soon, The store already has lots of unique never been done features such as seller profiles, individual pages, level x feed, sort by basely anything that is possible to sort by sorters etc etc etc. . .

List of already created features!

  • listings
  • category's
  • sort by
  • search
  • share icons in convenient place
  • javascript disabled functionality
  • all major browser support IE7+
  • profile pages with new functions that don't exist on the official seoclerks
  • out of the way ad spots
  • individual service pages
  • awesome jquery effects
  • awesome css transitions
  • fast loading
  • use minimum images
  • w3 mark up valid
  • switch api request method from config "curl", "file_get_contents", etc
  • the ability to turn off seller profiles from config (changes the links to seoclerks with affiliate id)
  • the ability to switch off individual pages from config (changes to the official service page with affiliate id)
  • the ability to tidy the description and title from config(removes special chars)
  • the ability to turn off staff selected, on sale and guaranteed ribbons from config
  • if a seller doesn't have a avatar set the default one from config
  • change your site name from config (appears in logo and titles)
  • select the amount of services listed per listings
  • level x seller feed in sidebar(rotates level x profile links every 5 seconds)
  • and others


Under dev!
  • pagination
  • start up page for installation
  • licence keys(only can be used once to activate store)
  • Tab appears with services you viewed lately

I'm a stubborn programmer / coder as @ShadyX tells me, That means I don't like using any frameworks pre created templates etc I code all from a blank notepad and enjoy doing so because I learn a lot of new things and improve my skills. If you would like to add anything to the dev list please tell me since I'm running low on things to code and the realise date will be sometime next week hopefully after I have checked all my functions and code to make sure everything is good.

Any ideas are appreciated What would you like to see as widgets on affiliate stores?

Once realised I would like the ideas to keep coming to improve the store more.
I would also like to say since the seoclerks api has been created many awesome affiliate stores have been created @ShadyX created the first awesome affiliate store what can be seen here and the first affiliate store to have pagination by @Everett what can be seen here and many more.

Comments

Please login or sign up to leave a comment

Join
gamer
Which affiliate store are you guys talking about? I would like to browse through it. Can somebody share the url with us? What would you like to see as widgets on affiliate stores?



Are you sure you want to delete this post?

jakemadness
Which affiliate store are you guys talking about? I would like to browse through it. Can somebody share the url with us? What would you like to see as widgets on affiliate stores?

Here is a unfinished version of my script => http://www.seoclerks.me/
If you think or feel anything can be improved please share.



Are you sure you want to delete this post?

Sean101
Have you released this affiliate store software for sale yet? What would you like to see as widgets on affiliate stores?



Are you sure you want to delete this post?

jakemadness
Have you released this affiliate store software for sale yet? What would you like to see as widgets on affiliate stores?

I started creating a newer affiliate software yesterday it uses rain tpl template system and a lot of very cool features, it is currently unavailable for purchase since I only started making it yesterday but it will be released soon. The rough marketplace price will be from $40.00 to $50.00 What would you like to see as widgets on affiliate stores?



Are you sure you want to delete this post?

Sean101
I started creating a newer affiliate software yesterday it uses rain tpl template system and a lot of very cool features, it is currently unavailable for purchase since I only started making it yesterday but it will be released soon. The rough marketplace price will be from $40.00 to $50.00 What would you like to see as widgets on affiliate stores?

Cool. What would you like to see as widgets on affiliate stores? So have you stopped work on the first one you where making then?



Are you sure you want to delete this post?

jakemadness
Cool. What would you like to see as widgets on affiliate stores? So have you stopped work on the first one you where making then?

I lost all files from the older version What would you like to see as widgets on affiliate stores? on the good side the new version has all the features from the older version What would you like to see as widgets on affiliate stores?.



Are you sure you want to delete this post?

Sean101
I lost all files from the older version What would you like to see as widgets on affiliate stores? on the good side the new version has all the features from the older version What would you like to see as widgets on affiliate stores?.

Cool, cool, let me know once your all done with it and selling it. What would you like to see as widgets on affiliate stores?



Are you sure you want to delete this post?

jakemadness
Cool, cool, let me know once your all done with it and selling it. What would you like to see as widgets on affiliate stores?

Sure What would you like to see as widgets on affiliate stores?



Are you sure you want to delete this post?

Sean101
Sure What would you like to see as widgets on affiliate stores?

Thanks.
What would you like to see as widgets on affiliate stores?



Are you sure you want to delete this post?

Order Now
Process Time: 3.2668018341064

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='13759'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='13759'

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

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

/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=330151SELECT googleplus_profile FROM seoclerks.members WHERE USERID=33015

/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=13759 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=13759 LIMIT 5

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13759' 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='13759' 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=70736 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=70736 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=70737 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=70737 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=70738 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=70738 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=70739 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=70739 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=70740 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=70740 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=70741 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=70741 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=70742 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=70742 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=70743 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=70743 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=70744 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=70744 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='13759' AND status='1' AND (question like '% widgets affiliate stores?%' OR question like '%widgets%' OR question like '%affiliate%' OR question like '%stores?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='13759' AND status='1' AND (question like '% widgets affiliate stores?%' OR question like '%widgets%' OR question like '%affiliate%' OR question like '%stores?%') -- ORDER BY RAND() LIMIT 15

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

SELECT * FROM seoclerks.members WHERE USERID='1856' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1856' limit 1

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

SELECT * FROM seoclerks.members WHERE USERID='1576' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1576' limit 1

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

SELECT * FROM seoclerks.members WHERE USERID='3738' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3738' limit 1

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

SELECT * FROM seoclerks.members WHERE USERID='11030' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='11030' 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=13759%' 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=13759%' 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='1856.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1856.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