| 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='29264' | 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='29264'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='857029' | 1 | SELECT * FROM seoclerks.members WHERE USERID='857029'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=857029 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=857029
| /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=29264 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=29264
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29264' 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='29264' 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=188590 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=188590
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29264' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29264'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='29264' AND status='1' AND (question like '%Sell service%' OR question like '%Sell%' OR question like '%service%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29264' AND status='1'
AND (question like '%Sell service%' OR question like '%Sell%' OR question like '%service%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='3644' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3644' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='3250' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='1159' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1159' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='5262' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='5262' 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=29264%' 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=29264%'
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='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.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()
|
TommyCarey
Go through and make sure everything is filled out correctly within your service.
Are you getting any sort of error messages that are preventing you from making your service go live?
Sometimes people will get an error, something simply usually, and they'll need to go through and edit a line or two in order to get their service out of draft mode.
Did you actually submit the service or was it really stuck in "draft" mode?
Sometimes people's internet connections go out while submitting their services, which will result in showing your services still as a draft, so you might need to resubmit it for acceptance.
Is your account restricted?
Have you done anything that could get your account restricted which would remove the option of submitting new services? This happens sometimes and people don't even think about it. They will spam users with "Hey, check out my service!" and they will get their account restricted for doing so. I hope this isn't the case, because you might not be able to submit new services if it is, but you can always contact support about this one.
Have you contacted support about this?
Like I mentioned just above this, have you tried to contact support about the problem? You won't want to contact them unless you've tried to troubleshoot everything yourself. Try to resubmit the service to see if it goes through, try to fix any errors that might pop up, and I really hope you don't have a restricted account because that would mean you need to wait a certain amount of days before you can re-submit your service for approval.
Was this the service you're talking about?
https://www.seoclerks.com/director...R4-PR7-Backlinks
If that's the service you're referring to, it doesn't seem to be in "Draft" mode anymore
Thanks,
Tommy Hey Joseph, Go through and make sure everything is filled out correctly within your service. [b]Are you getting any sort of error messages that are preventing you from making your service go live? [/b] Sometimes people will get an error, something simply usually, and they'll need to go through and edit a line or two in order to get their service out of draft mode. [b]Did you actually submit the service or was it really stuck in "draft" mode?[/b] Sometimes people's internet connections go out while submitting their services, which will result in showing your services still as a draft, so you might need to resubmit it for acceptance. [b]Is your account restricted?[/b] Have you done anything that could get your account restricted which would remove the option of submitting new services? This happens sometimes and people don't even think about it. They will spam users with "Hey, check out my service!" and they will get their account restricted for doing so. I hope this isn't the case, because you might not be able to submit new services if it is, but you can always contact support about this one. [b]Have you contacted support about this?[/b] Like I mentioned just above this, have you tried to contact support about the problem? You won't want to contact them unless you've tried to troubleshoot everything yourself. Try to resubmit the service to see if it goes through, try to fix any errors that might pop up, and I really hope you don't have a restricted account because that would mean you need to wait a certain amount of days before you can re-submit your service for approval. [b]Was this the service you're talking about? [/b] [url=https://www.seoclerks.com/directory-submission/705919/I-will-do-500-Do-follow-High-PR4-PR7-Backlinks]https://www.seoclerks.com/directory-submission/705919/I-will-do-500-Do-follow-High-PR4-PR7-Backlinks[/url] If that's the service you're referring to, it doesn't seem to be in "Draft" mode anymore :) Thanks, Tommy
Are you sure you want to delete this post?