My NEW Affiliate Store!

Everett Level X⁴

April 3, 2013, 11:43 am

Write the reason you're deleting this FAQ

My NEW Affiliate Store!

Hello Clerks,

I'm creating an affiliate store with SEOclerks Affiliate Store v.1 Script!

I would like some ideas for my affiliate store, care to give any ideas?!

My affiliate store can be found here.

PS: This script is REALLY amazing.

Comments

Please login or sign up to leave a comment

Join

robertman11

Whoa! That is awesome! $1 seo services is an amazing idea too. You'll get all kinds of sales with some promotion.

13 years ago

Are you sure you want to delete this post?

Everett

oops, you double posted xD

I hope to get a lot of affiliate sales, and new affiliates!

Future Additions:
Search Feature
"Order By" Feature
Different Prices
Sidebar Navigation
Social Share Buttons in Bootstrap Modal (buttons conflict with twitter bootstrap div classes need to find a way around that..)

Any other suggestions?!

13 years ago

Are you sure you want to delete this post?

ionicware

I am amazed, simply fantastic! This was why the API was created. You've done an excellent job and I love the popup with more details, very cool.

How do you intend on getting sales/conversions?

What about moving to the next page (pagination)?

The left column looks bare, how about the categories there or perhaps something else (discussion topics?).

Otherwise, simply amazing.

13 years ago

Are you sure you want to delete this post?

Everett

Yes, the API is fantastic!

I intend on promoting the page, and hopefully getting a good result on google xD (have not yet thought about exposure, will do so when site is completely finished)

You suggested pagination... hm.. maybe when more $1 services are available?

The left column is gonna have a search feature, and the categories under neath the search

13 years ago

Are you sure you want to delete this post?

Sean101

This is an excellent idea and yours in looks quality

I saw the gig the other day for this and its good to see it and how it looks

13 years ago

Are you sure you want to delete this post?

Everett

This is an excellent idea and yours in looks quality
I saw the gig the other day for this and its good to see it and how it looks

Yes, I love this script it's very awesome!

I've made a lot of changes to script:

- Added Twitter Bootstrap Modal
- Added Twitter Bootstrap Menu
- Added a loop 'page' so i can call from 1 loop page.
- Added a few functions 'under the hood'
- and a couple more additions..

Seriously thinking about using pagination(thanks Jordan again for the idea), however, I'm pretty new to the RAIN Template Engine... Going over the codes to include a pagination...

For example:
{function="pagination($selected_page)"}

Just gotta figure how to use the tags and I'll be good.. hahaha.

13 years ago

Are you sure you want to delete this post?

Sean101

What does Pagination mean?

When you say, added .. "Added Twitter Bootstrap Modal & "Added Twitter Bootstrap Menu" Where did you get the edits / models? or did you or someone you know just code from sctrach onto the affiliate store script / software?

13 years ago

Are you sure you want to delete this post?

Everett

Jordan suggested pagination so you can view more services after about 10 services and go to the next page, etc etc.

I'm currently in the process of adding this to my script. .

Pagination Example:

<< 1 2 3 4 5 6 7 8 9 10 >>
^ different pages, such as on SEOclerks index page... and your profile page if you have more than 1 page of services.

I coded little tweaks into the script I use on ServiceClerks.com, however you can find the codes on Twitter Bootstrap documentation page and add your own

13 years ago

Are you sure you want to delete this post?

Sean101

Jordan suggested pagination so you can view more services after about 10 services and go to the next page, etc etc.

I'm currently in the process of adding this to my script. .

Pagination Example:

<< 1 2 3 4 5 6 7 8 9 10 >
^ different pages, such as on SEOclerks index page... and your profile page if you have more than 1 page of services.

I coded little tweaks into the script I use on ServiceClerks.com, however you can find the codes on Twitter Bootstrap documentation page and add your own

Yes, im definetly going to do this, i didnt know thats what it was called, lol

13 years ago

Are you sure you want to delete this post?

Everett

Yes, it's much better than loading many results on one page, that will take forever.. for instance I loaded 100000 results or so.. nearly 100000, and it crashed my browser LOL o_O

13 years ago

Are you sure you want to delete this post?

Sean101

lol.

Yeah, i have it up to 40 gigs per page

13 years ago

Are you sure you want to delete this post?

exjordanary

Whoa! That is awesome! $1 seo services is an amazing idea too. You'll get all kinds of sales with some promotion.

*lol* - I remember back in the olden days when I used to have to make Banners of EVERY Single $1 Dollar Service, then Link them to the Proper Gig with my Affiliate Link embedded - only to have the Seller change their Gig on me.

So I had to always make manual changes. Then I had to convert it all from BBCode when I had it here in SEOClerks, to HTML when I transferred it over to CommunityClerks.

Is it just the story of my life? Or do I always feel like I'm always doing things the hard way?

13 years ago

Are you sure you want to delete this post?

Everett

*lol* - I remember back in the olden days when I used to have to make Banners of EVERY Single $1 Dollar Service, then Link them to the Proper Gig with my Affiliate Link embedded - only to have the Seller change their Gig on me.

So I had to always make manual changes. Then I had to convert it all from BBCode when I had it here in SEOClerks, to HTML when I transferred it over to CommunityClerks.

Is it just the story of my life? Or do I always feel like I'm always doing things the hard way?

Haha.. I remember.. xD I do wonder how much time you spent on that.. taking a screenshot of every gig, resizing it, uploading it, than shortening the link with Goo.gl, and adding it.. whoa! o_O

13 years ago

Are you sure you want to delete this post?

exjordanary

oops, you double posted xD

I hope to get a lot of affiliate sales, and new affiliates!

Future Additions:
Search Feature
"Order By" Feature
Different Prices
Sidebar Navigation
Social Share Buttons in Bootstrap Modal (buttons conflict with twitter bootstrap div classes need to find a way around that..)

Any other suggestions?!

Yes...RSS - I know people can choose to create an RSS from their own Sites, but I was just wanting one of ServiceClerks so I can add it to CommunityClerks (without having to use Yahoo Pipes).

Let me know when you've got a Feed for me.

I'm hungry! :mad:

That goes for ALL Affiliate/API Stores, that are Clerks Related. Please submit them to me on CommunityClerks so I can announce them, review them, and Link to them on the Site.

Thanks!!

13 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.179220	1	SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (42,64,90) AND gtags like'%Beautifuldesig%' AND type !=99	0.179220	0.179220

SEOClerks

My NEW Affiliate Store!

My NEW Affiliate Store!

Comments

Please login or sign up to leave a comment

robertman11

Everett

ionicware

Everett

Sean101

Everett

Sean101

Everett

Sean101

Everett

Sean101

exjordanary

Everett

exjordanary

Invalid SQL

Expensive SQL

Suspicious SQL

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='13666'	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='13666'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='2951'	1	SELECT * FROM seoclerks.members WHERE USERID='2951'	/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=2951	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=2951	/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=13666 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=13666 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13666' 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='13666' 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=70243 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=70243 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=70244 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=70244 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=70245 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=70245 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=70246 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=70246 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=70247 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=70247 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=70248 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=70248 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=70249 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=70249 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=70250 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=70250 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=70251 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=70251 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=70252 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=70252 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=70253 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=70253 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=70254 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=70254 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=70255 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=70255 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=70256 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=70256 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='13666'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='13666'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='13666' AND status='1' AND (question like '%My Affiliate Store!%' OR question like '%Affiliate%' OR question like '%Store!%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='13666' AND status='1' AND (question like '%My Affiliate Store!%' 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='3764' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3764' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='2044' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2044' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1856' limit 1	1	SELECT 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='1490' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1643' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1643' 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=13666%' 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=13666%' 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='9.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='9.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='2951.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='1.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
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 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()