# Topic SQL Script

**Category:** mIRC_Addon
**Original Author:** Unknown

## Description
This script is designed to capture topic changes in an IRC channel and store them into a MySQL database.

## Key Features
- Captures new topics set by users in the "#ginklai" channel.
- Connects to a local MySQL server using specified credentials.
- Inserts captured topic data into a `irc_topics` table.
- Logs successful insertions.

## File Analysis
- **topic_sql.tcl** — Contains the script logic for capturing and storing IRC topics.
  - Binds the `-` event in the `topc` namespace to execute the `catch_topic` procedure when a new topic is set.
  - Uses the `sql` package to connect, query, and disconnect from the MySQL server.
- **descr.txt** — Documentation describing the script's purpose of inserting changing topics into a MySQL database. Required package: tcl-sql.
- **sql_structure.sql** — SQL script defining the structure of the `irc_topics` table in the MySQL database.