Universal & RadioDJ-Specific Helper Tools

[EmmaS]

Helper Tools Overview

Below is a complete list of all helper tools available,
grouped into Universal Tools and RadioDJ-Specific Tools.

------------------------------------------------------------
Universal Helper Tools
------------------------------------------------------------

• Database & Port Check
Tests MySQL/MariaDB connectivity, port availability, firewall restrictions,
and login credentials.

• Charset & Collation Check
Identifies mixed or incorrect collations/charsets and suggests fixes.

• User Permission Tester
Checks which SQL permissions a MySQL user has (SELECT/INSERT/UPDATE/etc).

• Database Integrity Checker
Verifies tables, structure, missing columns, and potential corruption.

• Slow Query Tester
Finds which SQL queries are slow and provides profiling data.

• Index / Query Plan Helper
Analyses EXPLAIN output and suggests index improvements.

------------------------------------------------------------
RadioDJ-Specific Tools
------------------------------------------------------------

• Commercial Insight Tool
Analyse how RadioDJ handles your commercials, advertisers, rotations and events and suggests a few different ways to structure commercials properly.

• Table Validator
Confirms all RadioDJ tables exist and have correct schema.

• Rotation Debugger
Shows which track would be picked, rotation folder logic, weights, etc.

• Duplicate Song Scanner
Detects duplicate songs by metadata or filename hashing.

• Event Scheduler Validator
Converts day masks to real weekdays, detects overlapping events,
groups events (Daily / Specific Date), and shows the
human-readable action (Load Playlist, AutoDJ Enable, Start Recording, etc).

• Rotation Builder
Generates SQL-based rotations and full PHP rotation engines.
Automatically saves the rotation to the SCS forums.


------------------------------------------------------------
If there's anything you'd like to see added, just let me know - I'm always open to new feature ideas.

[Vanlen]

WOW!  Wonderful set of useful Tools.

Thanks for sharing.

[EmmaS]

About the StreamCode Studio Helper Tools

A lot of the helper tools you'll find on StreamCode Studio didn't appear overnight. Some of them I originally built many years ago to solve real-world RadioDJ and streaming headaches - and over time, I've been carefully revisiting them, cleaning up, and modernising.

Today, every tool has been fully updated to run on PHP 8+ and uses PDO for secure, modern database handling. No legacy shortcuts, no outdated methods - just clean, reliable code designed to work with current systems.

One thing that's really important to say clearly:

Nothing you enter is logged, saved, or recorded.

Any connection details or inputs you provide are used only in that moment, purely so the tool can read your setup and explain what's happening. There's no tracking, no hidden storage, and no background logging. Close the page, and it's gone.

All of the helper tools are completely free to use, and that won't change. They were built to help the RadioDJ community understand their systems better - not to upsell you into paid software but to provide you with the knowledge to do it yourself.

Every tool is also 100% read-only.

That means:

• They only read data from your database
• They do not write to it
• They do not modify settings
• They do not enable, disable, delete, or move anything

Think of them as a diagnostic window - a way to see how RadioDJ is behaving under the hood, without touching anything.

Some tools include helper advice, explanations, or example SQL queries.
These are provided as optional guidance for users who want to take the next step themselves. If you ever choose to run SQL manually, please make sure you back up your database first - that advice applies anywhere, not just here.

The overall goal of these tools is simple:
To remove confusion, reduce guesswork, and give you the confidence to understand and manage your own setup - without needing extra software or paid add-ons.

If something doesn't make sense, or if a tool feels unclear, that's not on you - it just means it can be explained better. Feedback and improvements are always welcome

[EmmaS]

I've put together a Tool Helpers & Diagnostic Utilities page showing all available tools, with names, descriptions, and clear indicators on the right for read-only status and whether each tool is Universal or RadioDJ-specific.

Visit page at https://www.streamcodestudio.com/helper-tools.php