| 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='19203' | 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='19203'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='225689' | 1 | SELECT * FROM seoclerks.members WHERE USERID='225689'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=225689 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=225689
| /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=19203 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=19203
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19203' 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='19203' 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=105718 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=105718
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='19203' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='19203'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='19203' AND status='1' AND (question like '%I access balance %' OR question like '%access%' OR question like '%balance%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='19203' AND status='1'
AND (question like '%I access balance %' OR question like '%access%' OR question like '%balance%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='4434' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4434' 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='8929' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='8929' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='9329' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9329' 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=19203%' 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=19203%'
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='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()
|
Beverly
Also, if this concerns private information about your account, you are best to submit a support ticket here: https://SEOLads.zendesk.com
Of some concern, is how your flag shows GB and yet on staff check, the last IP accessing your account was Nigeria. I'm assuming Nigeria is your actual location as that IP is persistent for over a week on this account.
If this IP location is not familiar to you, then you need to contact the support as soon as possible.
Also, you can take a few steps to secure your account now:
If someone has gained unauthorized accessed your account please follow these steps:
1) Change your password immediately. You can change your password from within your settings area (click on your name, settings in the upper right).
2) Remove the users device which will destroy their session and log them out. You can view your devices from the device tab (left hand menu) in the settings area (click on your name, settings in the upper right).
3) Add additional security items to your account. We highly recommend adding a phone number for phone verification. You can access the security tab by clicking on your name (upper right) and then selecting security.
Adding additional security also enables two-factor authentication which requires an additional step when a new device logs into your account.
4) (Optional) Lock your account. After you have made any settings changes and if you do not frequently need to change your settings data, you can lock your account. This will prevent any additional changes to your account (it does not prevent orders). Lock your account by going to your settings area, scrolling down to the bottom and clicking "Lock this account". Your account can only be unlocked by a staff member, you must create a helpdesk ticket where we will identify you as the account owner in order to unlock the account. Hi - Can you be a little more specific? Your title indicates you can't access your balance. But I have checked and your account is not in any way restricted from making purchases. Possibly you meant something else as your discussion body is about your account security. And, anyway it seems you are already on your account. Can you describe more about the error message, if any that you are receiving? Or, what was it you were trying to do, that you feel you are being prevented from doing? Also, if this concerns private information about your account, you are best to submit a support ticket here: https://SEOLads.zendesk.com Of some concern, is how your flag shows GB and yet on staff check, the last IP accessing your account was Nigeria. I'm assuming Nigeria is your actual location as that IP is persistent for over a week on this account. If this IP location is not familiar to you, then you need to contact the support as soon as possible. Also, you can take a few steps to secure your account now: If someone has gained unauthorized accessed your account please follow these steps: 1) Change your password immediately. You can change your password from within your settings area (click on your name, settings in the upper right). 2) Remove the users device which will destroy their session and log them out. You can view your devices from the device tab (left hand menu) in the settings area (click on your name, settings in the upper right). 3) Add additional security items to your account. We highly recommend adding a phone number for phone verification. You can access the security tab by clicking on your name (upper right) and then selecting security. Adding additional security also enables two-factor authentication which requires an additional step when a new device logs into your account. 4) (Optional) Lock your account. After you have made any settings changes and if you do not frequently need to change your settings data, you can lock your account. This will prevent any additional changes to your account (it does not prevent orders). Lock your account by going to your settings area, scrolling down to the bottom and clicking "Lock this account". Your account can only be unlocked by a staff member, you must create a helpdesk ticket where we will identify you as the account owner in order to unlock the account.
Are you sure you want to delete this post?