SEOClerks

Clear
Sign In Join

Tutorials Section Thread: Tutorials, Updates, Feedback, and More!

  • kutzki Level 1
    • 21

    Write the reason you're deleting this FAQ

    Tutorials Section Thread: Tutorials, Updates, Feedback, and More!

    Hey guys! This is the main thread for the Tutorials section. It will contain a list of all the tutorials to date, all updates that you might want to know about, and much more.

    I'm Kutzki, and I run the Tutorials section. I need your help. I need your suggestions for new tutorials to make. I have plenty of ideas, but I want to know what YOU guys want to see. If you're having any trouble with something or have had trouble in the past, or even if there's just something you think people should know, post it below and I'll see it and reply to it. Feel free to leave feedback in this thread for me. I might release a poll eventually and pick the top 5 tutorials that people want to see so everyone can vote on them.


    Tutorials:

    How to Reject an Order as a Buyer: Click Here
    How to Reject an Order as a Seller: Click Here
    Coupons and How to Use Them: Click Here
    Guaranteed Services and How to Reject Them: Click Here

    # Tutorials & Guides
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    tangee

    tangee

    good tutorials that you have written. Will really help some out!
    12 years ago

    Are you sure you want to delete this post?

    clipping

    clipping

    I have seen your all tutorials. It's very nice. And it help's me a lot.
    12 years ago

    Are you sure you want to delete this post?

    wikicrunch

    wikicrunch

    Best Tutorials for seoclerks,keep going well.
    12 years ago

    Are you sure you want to delete this post?

    dragonhunter95

    dragonhunter95

    nice set of tutorials . Thank you for sharing with us.
    12 years ago

    Are you sure you want to delete this post?

    stevexavior

    stevexavior

    Very good tutorials .Keep it up
    12 years ago

    Are you sure you want to delete this post?

    rejvi

    rejvi

    Nice tutorials Tutorials Section Thread: Tutorials, Updates, Feedback, and More!
    12 years ago

    Are you sure you want to delete this post?

    William5

    William5

    Great! Thanks
    12 years ago

    Are you sure you want to delete this post?

    bSEO

    bSEO

    The tutorials are really useful! Thanks!
    12 years ago

    Are you sure you want to delete this post?

    sweetcupcake

    sweetcupcake

    thumbs up to you! Thanks so much for this useful info.
    12 years ago

    Are you sure you want to delete this post?

    twilight

    twilight

    Headed over to look at these tutorials right now. Thanks!
    11 years ago

    Are you sure you want to delete this post?

    andreasjordan

    andreasjordan

    Nice tutor Tutorials Section Thread: Tutorials, Updates, Feedback, and More!
    11 years ago

    Are you sure you want to delete this post?

    akhtaruzzamanbd

    akhtaruzzamanbd

    Hey guys! This is the main thread for the Tutorials section. It will contain a list of all the tutorials to date, all updates that you might want to know about, and much more.

    I'm Kutzki, and I run the Tutorials section. I need your help. I need your suggestions for new tutorials to make. I have plenty of ideas, but I want to know what YOU guys want to see. If you're having any trouble with something or have had trouble in the past, or even if there's just something you think people should know, post it below and I'll see it and reply to it. Feel free to leave feedback in this thread for me. I might release a poll eventually and pick the top 5 tutorials that people want to see so everyone can vote on them.


    Tutorials:

    How to Reject an Order as a Buyer: Click Here
    How to Reject an Order as a Seller: Click Here
    Coupons and How to Use Them: Click Here
    Guaranteed Services and How to Reject Them: Click Here

    Thanks.
    11 years ago

    Are you sure you want to delete this post?

    shamir88bds

    shamir88bds

    Wow! Its really helpful for me. Thanks
    11 years ago

    Are you sure you want to delete this post?

    kolala

    kolala

    awesome turtorial very helpful for everyone
    11 years ago

    Are you sure you want to delete this post?

    Promodrone

    Promodrone


    How about when members are allowed signatures. I've looked for that info since registration, and it's STILL not clear to me. Maybe I'm just not looking in the right place either.
    11 years ago

    Are you sure you want to delete this post?

    Promodrone

    Promodrone

    Another suggestion - I was trying to find out what types of products/services had the most purchases. But, when I click the button, I can't seem to find that statistic. This would be in the Marketplace listings - help(lol!)? [/font
    11 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.50499582290649

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=40221SELECT googleplus_profile FROM seoclerks.members WHERE USERID=4022

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12103' 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='12103' 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=56113 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=56113 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=56114 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=56114 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=56115 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=56115 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=56116 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=56116 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=56117 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=56117 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=56120 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=56120 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=56121 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=56121 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=56122 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=56122 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=56123 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=56123 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=56125 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=56125 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=56126 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=56126 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=56128 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=56128 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=56129 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=56129 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=56131 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=56131 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=56132 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=56132 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=56133 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=56133 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='12103' AND status='1' AND (question like '%Tutorials Section Thread: Tutorials, Updates, Feedback, More!%' OR question like '%Tutorials%' OR question like '%Section%' OR question like '%Thread:%' OR question like '%Tutorials,%' OR question like '%Updates,%' OR question like '%Feedback,%' OR question like '%More!%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12103' AND status='1' AND (question like '%Tutorials Section Thread: Tutorials, Updates, Feedback, More!%' OR question like '%Tutorials%' OR question like '%Section%' OR question like '%Thread:%' OR question like '%Tutorials,%' OR question like '%Updates,%' OR question like '%Feedback,%' OR question like '%More!%') -- ORDER BY RAND() LIMIT 15

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='62744' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='62744' 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 seoclerks.members WHERE USERID='43' limit 11SELECT 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12103%' 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=12103%' 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='182522.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='182522.jpg'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='287837.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='287837.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
    5.3263531SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (17,18,22,30,33,47,49,50,72,84) AND gtags like'%Guest%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 405.3263535.326353