Active Threads | Active Posts | Unanswered Today | Since Yesterday | This Week
How Do I? Jump to new posts
Re: Bots Gizmo 04/14/2024 11:12 AM
Well, both methods display their .htaccess input code, the first would be (Blocking by user agent):
Code
# Block aggressive Chinese crawlers/scrapers/bots
# https://www.johnlarge.co.uk/blocking-aggressive-chinese-crawlers-scrapers-bots/
Options +FollowSymLinks
RewriteEngine On
RewriteBase /
RewriteCond %{HTTP_USER_AGENT} ahrefsbot|Baiduspider|BLEXBot|Bytespider|BuckyOHare|dotbot|exabot|gigabot|Goodzer|gsa-crawler|Kinza|LieBaoFast|LinkFeatureBot|MauiBot|Mb2345Browser|MicroMessenger|mj12bot|musobot|rogerbot|rushBot|semrushbot|serpstatbot|sitebot|Sogou|SputnikBot|VelenPublicWebCrawler|WBSearchBot|WPSpider|zh-CN|zh_CN [NC]
RewriteRule ^ - [F,L]


The second method (IP2Location Firewall List by Country) you'd take the .htaccess coding from their list for an Apache2 server and insert it as (the list is huge, I'm only including a couple of lines):
Code
<Limit GET HEAD POST>
order allow,deny
allow from all
deny from 1.0.1.0/24
deny from 1.0.2.0/23
deny from 1.0.8.0/21
deny from 1.0.32.0/19
deny from 1.1.0.0/24
deny from 1.1.2.0/23
deny from 1.1.4.0/22
deny from 1.1.8.0/21
deny from 1.1.16.0/20
deny from 1.1.32.0/19
...
deny from 223.252.168.0/21
deny from 223.252.177.0/24
deny from 223.252.178.0/23
deny from 223.252.180.0/22
deny from 223.252.184.0/21
deny from 223.252.192.0/18
deny from 223.254.0.0/16
deny from 223.255.0.0/17
deny from 223.255.236.0/22
deny from 223.255.252.0/23
</Limit>
6 267 Read More
How Do I? Jump to new posts
Re: Bots Outdoorking 04/14/2024 8:59 AM
Thanks Gizmo,

I would really like to know what code that I need to put into the htaccess file because it appears that what I have placed in the robot.txt file is not working unless I have to wait longer.
6 267 Read More
How Do I? Jump to new posts
Re: Bots Gizmo 04/14/2024 6:47 AM
If they respect the robots.txt standard they will check the robots.txt prior to any crawl.

There is also another method of blocking bots via your .htaccess, some reading on multiple methods:
https://www.johnlarge.co.uk/blocking-aggressive-chinese-crawlers-scrapers-bots/ (block by user agent)
https://www.ip2location.com/free/visitor-blocker (IP2Location Firewall List by Country)
6 267 Read More
How Do I? Jump to new posts
Re: Bots Outdoorking 04/14/2024 3:13 AM
Originally Posted by Ruben
If the bot honers it you can create a robots.txt file in your root folder and exclude by agent, ip etc
https://en.wikipedia.org/wiki/Robots.txt
https://ubbdev.com/wiki/view/7/ubb-sitemaps.html

If they do not honor the robots file you can ban them via the htaccess file or the UBB control panel using ip.

If it becomes a ddos attack you need to use something like cloudflare or ask your host about ddos protection.

Thanks for the reply. This is what I placed in the robot text file:

User-agent: Baiduspider
User-agent: 360Spider
User-agent: Yisouspider
User-agent: PetalBot
Disallow: /

User-agent: Bytespider
Disallow: /

User-agent: Sogou web spider
Disallow: /

User-agent: Sogou inst spider
Disallow: /

Does this look correct and how long would it take before it starts to work?
6 267 Read More
How Do I? Jump to new posts
Re: Bots Gizmo 04/13/2024 10:48 PM
FYI, if the bot visits the login page the Who's Online page will say that it's trying to login, since that's the wording for that system.
6 267 Read More
How Do I? Jump to new posts
Re: Bots Ruben 04/13/2024 9:43 PM
If the bot honers it you can create a robots.txt file in your root folder and exclude by agent, ip etc
https://en.wikipedia.org/wiki/Robots.txt
https://ubbdev.com/wiki/view/7/ubb-sitemaps.html

If they do not honor the robots file you can ban them via the htaccess file or the UBB control panel using ip.

If it becomes a ddos attack you need to use something like cloudflare or ask your host about ddos protection.
6 267 Read More
How Do I? Jump to new posts
Bots Outdoorking 04/13/2024 9:08 PM
Hi all,

I have noticed this in the Whos online Bytespider (bad_bot) has over 100 entries.

Another one is MJ12bot which is trying to login.

Should I do something about these two and if so what code do I need to run and where please.

I have noticed that if you have a lot it can cause issues slowing the forum down.

Any assistance would be appreciated.
6 267 Read More
Suggestions and Feedback Jump to new posts
Re: This is not a bug, but a suggestion Ruben 04/08/2024 2:54 PM
1 293 Read More
Version 7 Support Jump to new posts
Re: Do I need to rebuild my database? Baldeagle 04/08/2024 6:52 AM
OK. I don't have phpmyadmin, so I'll have to do it manually. Thanks for your help.
6 304 Read More
Version 7 Support Jump to new posts
Re: Do I need to rebuild my database? Gizmo 04/08/2024 6:34 AM
You'll want to use PHPMyAdmin to insert the missing columns, theres also an option for moving columns if you want it to show in PHPMyAdmin the same as my screenshot.
6 304 Read More
Version 7 Support Jump to new posts
Re: Do I need to rebuild my database? Baldeagle 04/08/2024 6:31 AM
It doesn't.
6 304 Read More
Version 7 Support Jump to new posts
Re: Do I need to rebuild my database? Gizmo 04/08/2024 6:26 AM
It should look like my attachment
6 304 Read More
Version 7 Support Jump to new posts
Re: Do I need to rebuild my database? Baldeagle 04/08/2024 6:14 AM
I only have five: POST_ID, POSTER_ID, TOPIC_ID, USER_ID, TIMESTAMP. Looks like I'm missing LIKE_ID and TYPE. I'm running 7.7.5. Did I miss a step during an upgrade? If so, is there a way to fix it?
6 304 Read More
Version 7 Support Jump to new posts
Re: Can you add html to language files? Baldeagle 04/08/2024 6:10 AM
Thanks. I'll try that.
2 666 Read More
Version 7 Support Jump to new posts
Re: Do I need to rebuild my database? Gizmo 04/08/2024 4:33 AM
Do you have a _LIKES table? LIKE_ID is the row column; it should have been added as a part of the v7.7.4 install (step 6 of the alter table). It should have 7 columns, LIKE_ID TYPE POST_ID POSTER_ID TOPIC_ID USER_ID TIMESTAMP
6 304 Read More
Version 7 Support Jump to new posts
Re: Can you add html to language files? Gizmo 04/08/2024 4:19 AM
Some areas allow HTML and some don't, you'll need to comment out your code however:
Code
<a href=\"url\" target=\"_blank\">go here</a>
2 666 Read More
Version 7 Support Jump to new posts
Can you add html to language files? Baldeagle 04/07/2024 6:41 PM
The owners of the site have asked me to add a link to a specific page to the WEL_MSG of adduser.php. I noticed that the PM in my test account (which retained a copy of the welcome message) dispplays the <br> code (included in the language file) as plain text. This leads me to believe that the language file will ignore any html added to it.

IOW, I want to add
Code
<a href="url here">go here</a>
but I suspect that this will simply be displayed as plain text, which many new registratns will find confusing. (Our forum attracts a large number of retired folk that are not very computer savvy.)

Is there a way to add a viable link to a language file? Or do I have to do this some other way? (Or it's not even possible.)
2 666 Read More
Version 7 Support Jump to new posts
Do I need to rebuild my database? Baldeagle 04/07/2024 6:58 AM
I tried to prune orphaned likes and got this error:

Quote
Script: /var/www/html/ubbthreads/admin/dorebuildcontent.php
Line: 856
SQL Error: Unknown column 'LIKE_ID' in 'field list'
SQL Error: 1054

Query:

SELECT
COUNT(LIKE_ID) AS COUNT
FROM sbf_LIKES
GROUP BY
TYPE, POST_ID, POSTER_ID, TOPIC_ID, USER_ID
HAVING
COUNT(TYPE) > 1
AND COUNT(POST_ID) > 1
AND COUNT(POSTER_ID) > 1
AND COUNT(TOPIC_ID) > 1
AND COUNT(USER_ID) > 1
6 304 Read More
Suggestions and Feedback Jump to new posts
This is not a bug, but a suggestion Baldeagle 04/06/2024 3:25 AM
I noticed today that we have almost 57,000 attachments in our attachments folder. That number of files in a single folder can make for some interesting problems on unix. I'm wondering if it would be possible to program the attachment folder in such a way that the images placed in it would be in separate folders, perhaps by day, week, or month? It would make it easier to locate problem files and allow ls to work without complaining about too many files.

Just a thought. Certainly not a high priority item.
1 293 Read More
Pre-Sales Questions Jump to new posts
Re: Is UBB.threads still going? ahmed047 04/04/2024 9:40 PM
any updates regarding ubb8 release?
19 8,603 Read More
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
4 members (Nightcrawler, Outdoorking, Ruben, 1 invisible), 872 guests, and 274 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)