In this Watch Me Work Live Stream, I work on removing some 30,000+ spam comments placed by bots using through the comment form in Preachit Joomla extension. I then set up Google's RECAPTCHA on that site to prevent more spam messages.
I also use some crazy regular expressions in Regular Labs ReReplacer to add Google ads right in my articles based on how many /p paragraph closing tags there are as well as placing an author's footer at the end of each of his articles.
Interspersed in the video is some setting up of StreamLabs OBS, some reflections on perfectionism, and some twitch heads drop in to "chat" right at the end of the stream.
00:00:00 โ Intro & Sponsors
00:01:27 โ Delete 32,000 Spam Comments in Joomla
00:13:29 โ Joomla Security: Setup Google reCAPTCHA
00:22:46 โ Joomla ReReplacer: Regular Expressions for Ad Placement
00:36:11 โ Insert Google Ads After 400 Characters in Joomla Articles
00:41:14 โ Auto-Insert Read More Tags in Joomla with ReReplacer
00:47:58 โ Duplicate ReReplacer Settings for Multiple Ad Positions
00:58:26 โ Add Footer Signature to Joomla Articles Using Regex
01:03:17 โ DB Replacer: Remove Old Tags from 500+ Joomla Articles
01:11:37 โ Test Google Ads Placement on Long Joomla Articles
01:18:39 โ StreamLabs OBS Chat Setup & Nightbot Moderation
01:26:05 โ Life Lesson: Overcoming Perfectionism | Wrap-Up
Summary
1. Intro & Sponsors
Tim opens the stream, thanks the sponsors, and introduces the day's focus: cleaning up spam and automating content placement across Joomla sites.
2. Delete 32,000 Spam Comments in Joomla
Tim demonstrates how to bulk delete tens of thousands of spam comments using database tools, showing a massive cleanup operation on a neglected site.
3. Joomla Security: Setup Google reCAPTCHA
To prevent future spam, Tim walks through setting up Google reCAPTCHA on Joomla forms, adding a critical layer of protection against bots.
4. Joomla ReReplacer: Regular Expressions for Ad Placement
A powerful technique is introduced: using Regular Expressions in ReReplacer to find specific positions within article content for dynamic insertions.
5. Insert Google Ads After 400 Characters in Joomla Articles
Tim demonstrates a practical use case: automatically placing Google AdSense code exactly 400 characters into every article, regardless of length.
6. Auto-Insert Read More Tags in Joomla with ReReplacer
Another automation trick is shownโusing ReReplacer to insert "Read More" tags automatically, creating blog-style previews without manual editing.
7. Duplicate ReReplacer Settings for Multiple Ad Positions
Tim shows how to duplicate ReReplacer configurations, allowing multiple ad placements (after 400 chars, after 800 chars, etc.) with just a few clicks.
8. Add Footer Signature to Joomla Articles Using Regex
Using Regular Expressions, Tim demonstrates how to append a consistent author signature or footer to every article sitewide.
9. DB Replacer: Remove Old Tags from 500+ Joomla Articles
A cleanup task is performedโremoving outdated HTML tags from over 500 articles using DB Replacer, with the critical reminder to backup first.
10. Test Google Ads Placement, Chat Setup & Wrap-Up
Tim tests the ad placements on long articles to verify they work, sets up StreamLabs OBS chat with Nightbot moderation, shares a life lesson about overcoming perfectionism, and wraps up the stream.
Please send any feedback or bug reports or queries to;
Contact Tim Davis โบ
Joomla Training Cohort โบ https://cybersalt.com/jtc
Add comment