views
Level 3
Write the reason you're deleting this FAQ
Hi,
We want to suggest that, Close the services of those users who are not active there are many service which come higher in searches but users have not logged in for over 1 month.
It just the suggestion rest if upto JORDAN.
Thanks
Yeah, I think something would be good to help the more active sellers and member's gigs stand out more. I think closing the services of a member due to one month absence is a bit too strict, but still do like your suggestion.Maybe a warning to the member after a month saying that their service is a rick of being marked as "Inactive Seller" or something like that, then after another set period of time, if the member still doesn't log in, then the service is removed from the market place and put as paused in their account.
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Yeah, suspending them is a much better idea than deleting them all together, that said, I just also had a thought that would make doing this a bad idea. Search engines will have those older services index and lots of them will be receiving traffic, if a new feature like this was added today, in one month time, a lot of service will suddenly be remove of the pages not longer viewable do to them being suspended / removed, this would then most like bring a large drop in traffic?
Are you sure you want to delete this post?
What you mean?
Are you sure you want to delete this post?
Another thought there.. Did we not get banned from Google anyways?
Yeah, and if the services (web-pages) are mad in-active, the search engines will drop the pages, this meaning the visitors to on them will stop, that's what I mean. :P Another thought there.. Did we not get banned from Google anyways? :P
Are you sure you want to delete this post?
Yeah, and if the services (web-pages) are mad in-active, the search engines will drop the pages, this meaning the visitors to on them will stop, that's what I mean.
[quote]Yeah, and if the services (web-pages) are mad in-active, the search engines will drop the pages, this meaning the visitors to on them will stop, that's what I mean. :p Another thought there.. Did we not get banned from Google anyways? :p[/quote]
No I think, why we get banned ? Currently seoclerks is suffering from google penalty that's why we moved to seoclerk, but there is no reason now for google to ban us :)
Are you sure you want to delete this post?
thats why I opened this thread.
hey,
There is not need to banned them just suspend there services because many buyers will order and just wait and wait.
that happen to me also I order some one and I am still waiting :P thats why I opened this thread.
Are you sure you want to delete this post?
hey,
There is not need to banned them just suspend there services because many buyers will order and just wait and wait.
that happen to me also I order some one and I am still waiting
[quote]hey,
There is not need to banned them just suspend there services because many buyers will order and just wait and wait.
that happen to me also I order some one and I am still waiting :p thats why I opened this thread.[/quote]
Ya, I agree with you views! :D
Are you sure you want to delete this post?
Are you sure you want to delete this post?
I think the listing should be suspended from getting new orders, but not removed. That way the organic traffic will continue, but then they will move on to someone else's active listing :)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
But, what about the situation where a reputable seller on SEOClerks with a high ranking could not be on the site for awhile due to prolonged or grave illness? The situation would not be their fault but they could easily get their listings deleted or closed. If they had spent a very long time building credibility, that could be a devastating blow.
Another scenario is when a seller has many instant downloads available. They don't really have to log in in order to make sales or collect money as this is taken care of automatically by the SEOClerks system.
For those people, they would just need to put up the items for instant download and drive traffic to the pages. They could make sales and be 'active' even if they never logged in, but once or twice a year to cash out.
Those people who make sales often in this way but just don't login a lot should not be penalized.
Are you sure you want to delete this post?
We can suspend the services! When the user come online he can re activate them, but it's also not a good idea to leave such services open because if any seller is not available due to grave illness then what about the order? Does it remain open for 10-15 days (Till the seller login back)?
But, what about the situation where a reputable seller on SEOClerks with a high ranking could not be on the site for awhile due to prolonged or grave illness? The situation would not be their fault but they could easily get their listings deleted or closed. If they had spent a very long time building credibility, that could be a devastating blow.
Another scenario is when a seller has many instant downloads available. They don't really have to log in in order to make sales or collect money as this is taken care of automatically by the SEOClerks system.
For those people, they would just need to put up the items for instant download and drive traffic to the pages. They could make sales and be 'active' even if they never logged in, but once or twice a year to cash out.
Those people who make sales often in this way but just don't login a lot should not be penalized.
[quote]We can suspend the services! When the user come online he can re activate them, but it's also not a good idea to leave such services open because if any seller is not available due to grave illness then what about the order? Does it remain open for 10-15 days (Till the seller login back)?[/quote]
Exactly. The buyer is the one being punished if the seller is not available to fulfill a service that is still listed in the marketplace.
[quote]But, what about the situation where a reputable seller on SEOClerks with a high ranking could not be on the site for awhile due to prolonged or grave illness? The situation would not be their fault but they could easily get their listings deleted or closed. If they had spent a very long time building credibility, that could be a devastating blow.
Another scenario is when a seller has many instant downloads available. They don't really have to log in in order to make sales or collect money as this is taken care of automatically by the SEOClerks system.
For those people, they would just need to put up the items for instant download and drive traffic to the pages. They could make sales and be 'active' even if they never logged in, but once or twice a year to cash out.
Those people who make sales often in this way but just don't login a lot should not be penalized.[/quote]
They would already be penalized by losing their seller level, as one of the criteria is to login at least once every 7 days. :)
Are you sure you want to delete this post?
| 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='12548' | 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='12548' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='25995' | 1 | SELECT * FROM seoclerks.members WHERE USERID='25995' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='39' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='39' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=25995 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=25995 | /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=12548 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=12548
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12548' 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='12548' 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=59692 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=59692
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=59693 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=59693
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=59694 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=59694
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=59695 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=59695
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=59696 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=59696
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=59697 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=59697
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=59698 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=59698
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=59699 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=59699
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=59700 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=59700
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=59701 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=59701
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=59702 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=59702
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=59705 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=59705
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=59706 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=59706
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=59707 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=59707
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=59708 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=59708
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=59709 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=59709
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=59710 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=59710
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='12548' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='12548' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='12548' AND status='1' AND (question like '%Close services users active%' OR question like '%Close%' OR question like '%services%' OR question like '%users%' OR question like '%active%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='12548' AND status='1'
AND (question like '%Close services users active%' OR question like '%Close%' OR question like '%services%' OR question like '%users%' OR question like '%active%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='3046' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3046' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9874' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9874' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9399' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9399' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='134' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='134' 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=12548%' 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=12548%'
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='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='23112.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='23112.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='25995.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='25995.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='40054.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='40054.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='3881.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3881.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='167023.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='167023.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='20625.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='20625.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='168430.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='168430.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='147.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147.jpg' | /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 |
| Avg Time | Count | SQL | Max | Min |
| 0.107992 | 1 | SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%intro%') ORDER BY total_recommendations desc LIMIT 0,40 | 0.107992 | 0.107992 |
Sean101
Are you sure you want to delete this post?