Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - save_new_session_data
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

save_new_session_data
 Post Reply Post Reply Page  <1234>
Author
  Topic Search Topic Search  Topic Options Topic Options
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 277 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 12 December 2023 at 4:23pm
ok, anyway I will publish my progress in this post by adding bots (in case someone doesn't have it).
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 277 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 12 December 2023 at 8:20pm
Well, I have found some more IPs that generate duplicity in the session. I have also searched and put all the ones on Google:


inStr(1, strUserAgent, "Twitter", 1) OR inStr(1, strUserAgent, "Semrush", 1) OR inStr(1, strUserAgent, "Petal", 1) OR inStr(1, strUserAgent, "GrapeshotCrawler", 1) OR inStr(1, strUserAgent, "omgili", 1) OR inStr(1, strUserAgent, "MuckRackFeedParser", 1) OR inStr(1, strUserAgent, "semantic-visions", 1) OR inStr(1, strUserAgent, "Buck", 1) OR inStr(1, strUserAgent, "proximic", 1) OR inStr(1, strUserAgent, "GoogleProducer", 1) OR inStr(1, strUserAgent, "CensysInspect", 1) OR inStr(1, strUserAgent, "Criteo", 1) OR inStr(1, strUserAgent, "MuckRack", 1) OR inStr(1, strUserAgent, "SentiBot", 1) OR inStr(1, strUserAgent, "Beloud", 1) OR inStr(1, strUserAgent, "Feedly", 1) OR inStr(1, strUserAgent, "Feedfetcher-Google", 1) OR inStr(1, strUserAgent, "Storebot-Google", 1) OR inStr(1, strUserAgent, "Google-InspectionTool", 1) OR inStr(1, strUserAgent, "GoogleOther", 1) OR inStr(1, strUserAgent, "Google-Extended", 1) OR inStr(1, strUserAgent, "APIs-Google", 1) OR inStr(1, strUserAgent, "AdsBot-Google-Mobile", 1) OR inStr(1, strUserAgent, "AdsBot-Google", 1) OR inStr(1, strUserAgent, "FeedFetcher-Google", 1)

I think putting more is bad for performance and I think I should stop.
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 13 December 2023 at 7:34am
I have a list of 123 bots, and that's a tiny percentage of what's out there. You can also get bot software that allows you to set your own bot name, so the list could be endless. You may want to just cover the most popular bots rather than trying to add them all.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 277 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 13 December 2023 at 5:15pm
With these three sections they do filter many bots:

inStr(1, strUserAgent, "bot", 1) OR inStr(1, strUserAgent, "crawler", 1) OR inStr(1, strUserAgent, "spider", 1)
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2023 at 7:06am
That looks good.

Edited by WebWiz-Bruce - 14 December 2023 at 8:07am
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 277 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2023 at 7:49am
I am reviewing the generated log every day.

As a test, I created a connection before recording the IP in the sessions table, which checks if the session exists and if it exists, it creates a new session code.

Today when I checked the log file I saw that there are still errors due to duplicity (which is impossible because I have put a connection before the connection to record the session so that it can verify if it exists).

Checking the log I have seen that at the same time (hour, minute and second) there are more than 10 duplicity and database blocking errors with the same IP. In milliseconds they have tried to access.


2023-12-14 03:53:12 - 49.12.9.78 - Invitado - ERROR - File: database_connection.asp - Error Details: err_SQLServer_db_connection - Microsoft OLE DB Driver for SQL Server - Invalid connection string attribute (this same line more than 10 times)

2023-12-14 04:04:00 - 49.12.9.78 - Invitado - ERROR - File: functions_session_data.asp - Error Details: err_SQLServer_save_new_session_data - Microsoft OLE DB Driver for SQL Server - Violation of PRIMARY KEY constraint 'PK__tblNPSes__E9CBB3125D6845C6'. Cannot insert duplicate key in object 'dbo.tblNPSession'. The duplicate key value is (6500-c4dcdz172ad65951111f1694444444). (this same line more than 10 times)


My last action has been to block these IPs that are "bombing" my forum.


Edited by Roberto Randall - 14 December 2023 at 9:46am
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2023 at 8:21am
Its quite complicated but due to Classic ASP not being able to generate true random numbers.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 277 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2023 at 2:44pm
I have attached a screenshot of the connection I created so that you can verify that the session code does not exist. To ensure that it is not duplicated again, I add three new random digits.

With this code we can ensure that a user (not a machine) if they open the forum in two browsers (or more) at the same time and have the same session code, a different one will be created without duplication.

I hope it helps you (if you don't want the image that I have inserted of the code in this forum to remain, delete it (in any case, I will delete it from my domain after a few days). This is just for you, to help you) .
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
 Post Reply Post Reply Page  <1234>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.