Hello Clerks Nation, We are going to give away a $100 gift card to the user that purchases the 400,000th service. We are currently at 399,105 so we are very close. You can see how close we are by looking at the order ...
Hey Clerks Nation, It's time for the Fun Friday Contest! This week you need to submit a link and Screenshot of the main page of your affiliate website. Submissions will be judged based on appearance and design. The...
Hey Clerks Nation, Me and Jordan were talking about doing a new contest for ListingDock. It would involve developing and submitting a video that promotes the site. If we had enough submissions we would have a 1st, 2nd...
If you go to your Contact Details page within your account, you can now add your SEO Clerks, Code Clerks & Listing Dock Marketplace profiles (Just after Facebook, Twitter, etc..). This will show your marketplace prof...
Hey Clerks Nation, It's time again for our Fun Friday Contest. This week I want you to submit a screenshot of your own personal SEOClerks FaceBook fan page including the cover photo. Again, we will be looking for g...
Hello Clerks Nation, We have now added a shipping module to the SEOClerks and LisitngDock platform. This should make it easier for both buyers and sellers if you sell an item that has to be shipped. Here is a couple o...
Hey Clerks Nation, It's time for the Fun Friday contest again. This weeks contest will involve you posting a screenshot and Url of your best designed service you sell on SEOClerks. We will be looking for services th...
Hey Clerks Nation, It time once again for our Fun Friday contest! This week we want to see who has the most unique profile avatar or picture. You must submit the avatar or profile pic you are currently using and not o...
Hey Clerks Nation, The Fun Friday contest this week will involve your desktop. We want to see who has the coolest looking desktop for you PC or laptop that you use for SEOClerks, ListingDock or CodeClerks. To enter in...
Hello Clerks Nation, Check out the updates we made to the ionicware website at https://www.ionicware.com. This website will link all of our websites together. Please visit the site and tell us what you think.
Each Friday SEOClerks will be doing a contest on the SEOClerks FaceBook fan page and will give away free money. We want to get everyone involved in this so please Like and Share our posts (this could increase your chanc...
Orders are just like a private messages, so we've made them function the same as the inbox. When a user updates an order, it becomes "unread" to the other party. This will result in a bolded title in the manage orders/sh...
Several of you have requested the ability to buy gift cards (or coupons) to give them to your affiliates, friends, etc. Exjordanary suggested it here recently. Additionally, he has been asking for/suggesting it for about...
We've been toying with the idea of 100% from the affiliates you refer who order your own service/listing on SEOClerks, CodeClerks and ListingDock. This would allow sellers to spend money advertising their own profiles/se...
First and foremost, Merry Christmas to those celebrating! I've spent a portion of today updating our user profiles. Services have been moved to the top, under the map so that they are more easily accessed by users who ...
We'd like to see more Level X users and our current selection criteria is a bit strict. We've removed the FAQ Requirement from leveling up so more users should be able to reach Level 3 without any issues. First and fo...
Answering or asking questions in the FAQ is no longer a requirement for leveling up your account. This means your level is entirely based on order statistics.
I just wanted to update you all and let you know that Payza is currently denying all US citizens access to their Payza accounts. This includes corporations (Ionicware Inc). If you have a Payza withdraw request, it will b...
Anyone that LIKES and SHARES our cyber Monday buy 3 get %20 back post will receive a free $10 dollar coupon. https://www.facebook.com/SeoClerks/posts/473276849447868 To receive your coupon please post your public shar...
First and foremost, Happy Thanksgiving for those of you that are celebrating it. It has been a wonderful year and we at Ionicware Inc. have a lot of things to be thankful for, namely you the community. In celebration o...
Steven has now been promoted to level X by the staff. Steven was noticed by staff because of his amazing amount of orders delivered on time and in progress. Obviously, he takes providing social media services seriou...
The Hendersonville Times-News did a story about Ionicware, SEOClerks and the launch of the new site, ListingDock. They interviewed us yesterday (11/13/2013) and took a picture in our Biz611 office. I'm the one on the ...
Some of you relied on Western Union to get your earnings. This was recently disabled as they were less than ideal and very painful to work with. We understand this was critical for some sellers in order to receive their ...
Ahove asked to be able to link directly to the free money section using an affiliate link, and it made sense. You can now link directly to the free money using your affiliate link. https://www.seoclerks.com/linkin/<R...
You may have seen the "Report" button that has popped up on just about everything, just like the report button on inbox messages. The above image is from a service listing, in the left hand column. Clicking this b...
All service types now have the ability to generate coupons, guarantees and place their item on sale. Previously, this was only valid for service items but now includes Software, Themes, Tweets, Articles, eBooks and Blog ...
Our first go with Credit Cards ended badly with a lot of profit loss. We learned though, and we grew (and I personally suffered a bit). In spite of all that, Credit Card payment is back. It now goes through a 2-phase fra...
You can now add Vimeo and Screenr videos using the video tags on any text input that supports the video icon. Simply paste your Vimeo or Screenr video URL between the video tags (where you would put the YouTube URL) and ...
The RSS feed now supports both the WTB and WTT sections as well as the normal service listings. You can access each one at the footer of each section. https://www.seoclerks.com/rss/wtb https://www.seoclerks.com/rss/wtt...
Congratulations winners of the 3rd SEOClerks affiliate contest! If you are a winner, the funds have already been added to your account. Here are the winners of this contest: exjordanary (from 814 affiliates with 413 ...
In order to allow buyers and sellers to manage their subscriptions better, a new section has been added in Manage Shopping and Sales. Buyers: https://www.seoclerks.com/orders?s=subscriptions Sellers: https://www.seo...
If you mouse over the "Community" tab on the main menu (of the main site), you'll see a new link called "Freelancers". This will take you to a listing of all members on the site who choose to be listed. The purpose of th...
Check out the really cool infographic made by Jaan Porkon for the new SEOClerks:
You may have received multiple emails for the Buy 3, Get 20% promo announcement this morning. This was due to a glitch which spawned several instances of the script to initiate at the same time. We are very sorry for thi...
In celebration of launching the new SEOClerks (more details here), we are starting the third affiliate contest. We are giving away a total of $1,000 to winners of this contest with first place receiving $500 (all withdr...
As part of the celebration of the new SEOClerks, we are giving out $5 coupons. Code: TheNewSEOClerks! Apply the code here: https://www.seoclerks.com/balance Feel free to share it with any potential affiliates (...
The new SEOClerks is now live! It took a long time and a lot of code to get to this point - we have finally arrived at a new, improved SEOClerks. Before we begin, a special thanks should be giving to you, the user. Than...
The new version of SEOClerks will be completed today and open for beta testing. If you are interested in beta testing, please let us know by responding here. We'll convert your account over and you'll be able to use the ...
On the current version of SEOClerks, if you force cancel then you receive a negative rating. You had no other option to force a cancellation if you couldn't do the work. You could mutual cancel, but it may have been reje...
We've added new data to the service page for the new SEOClerks only in order to help buyers find sellers who are more responsive. This will hopefully encourage sellers to be more responsive as well although looking at ou...
| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.114' | 1 | SELECT count(id) as total FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.114' | /opt/clerks-staging/docroot/include/functions/includes/security.php 1090 IsIPBannedBot() include_once() |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| SELECT * FROM categories_faq WHERE seo=? | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE seo=? | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategoryInfoFromTypeSeo() |
| SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='announcements' LIMIT 1 | 1 | SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C
where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='announcements' LIMIT 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='announcements' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 80, 40 | 1 | SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C
where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='announcements'
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 80, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * from questions as A where A.status='1' AND CATID=48 | 1 | SELECT count(A.quesid) as total from questions as A
where A.status='1' AND CATID=48 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=48 | 1 | SELECT count(A.ansid) as total
FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=48 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE (script='/opt/clerks-staging/docroot/faq.php'
OR script='/opt/clerks-staging/docroot/viewfaq.php')
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='42124' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='42124' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='1856' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1856' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='1' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1' | /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 |
