| 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='20856' | 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='20856'
| /opt/clerks-staging/docroot/viewfaq.php 496 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='37890' | 1 | SELECT * FROM seoclerks.members WHERE USERID='37890'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM seoclerks.members WHERE USERID=37890 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=37890
| /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=20856 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=20856
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20856' 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='20856' 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=113473 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=113473
LIMIT 5
| /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
|
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='20856' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='20856'
| /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
|
| SELECT * FROM questions WHERE quesid!='20856' AND status='1' AND (question like '%How block traffic specific country Google analytics?%' OR question like '%block%' OR question like '%traffic%' OR question like '%specific%' OR question like '%country%' OR question like '%Google%' OR question like '%analytics?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='20856' AND status='1'
AND (question like '%How block traffic specific country Google analytics?%' OR question like '%block%' OR question like '%traffic%' OR question like '%specific%' OR question like '%country%' OR question like '%Google%' OR question like '%analytics?%')
-- ORDER BY RAND()
LIMIT 15
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='318' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='318' limit 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
|
| SELECT * FROM seoclerks.members WHERE USERID='498' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='498' 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=20856%' 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=20856%'
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 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()
|
virusblock
Calling a remote service to return the country code for an IP-Address is far too slow for a web-page on the server side and the size of data-table needed to resolve addresses needs only to be about 50 megs in size, nothing today
Google was very nice to me, they annomalized the 5000 functions in the ga.js spyware script so no one could understand the javascript but that made it simpler for code to tweek the function because they all start with A,B,C,D,E instead of something like function GetUserAgent() so they shot themselves in the foot in that respect
Do not trust google when it comes to telling you who's real and who's not and put a bit of javascript in your pages so you can decide for yourself because few bots if any will execute the code and even less will request images or style sheets unless the bots are automating a browser instead of just using win-socket
The internet is alive, alive with spiders and bots, it's getting worse. Google analytics is a pile of crap and most people block it anyway and bots love it to death but you could try using a XML table that contains Whois address ranges on your server to not embed the GA.js and code into the page needed for GA or to just block the user/web-bots based on the country code. Calling a remote service to return the country code for an IP-Address is far too slow for a web-page on the server side and the size of data-table needed to resolve addresses needs only to be about 50 megs in size, nothing today Google was very nice to me, they annomalized the 5000 functions in the ga.js spyware script so no one could understand the javascript but that made it simpler for code to tweek the function because they all start with A,B,C,D,E instead of something like function GetUserAgent() so they shot themselves in the foot in that respect Do not trust google when it comes to telling you who's real and who's not and put a bit of javascript in your pages so you can decide for yourself because few bots if any will execute the code and even less will request images or style sheets unless the bots are automating a browser instead of just using win-socket The internet is alive, alive with spiders and bots, it's getting worse.
Are you sure you want to delete this post?