<commit_before>MySQL-TSDNS
===========
A TSDNS-Server for Teamspeak 3, that uses MySQL for configuration.

Requirements
------------
 - [nodejs](http://nodejs.org/)
 - [npm](https://npmjs.org)


Installation
------------
 1. Download the Git-Repo (we recommend stable) into a directory of your choice
 2. Run "`npm install`" to install the dependencies
 3. Copy the `config.dist.json`-file to ``config.json``
 and change it, as your needs
 4. Import the `init.sql` into your database (structure + testdata). Ensure that you selected a target scheme first.
 5. Change the settings in the db, as your needs. (see [**Configuration**](#configuration) for more)
 6. Run "`./mysql_tsdns_startscript start`" to start the MySQL-TSDNS-Server and your are ready. :D

Configuration
-------------
MySQL-TSDNS stores all data in the db (name would be silly otherwise).  
As a domain is requested, MySQL-TSDNS first read all available tables to look the teamspeak-servers up from the `serverTables`-Table, then it goes throw every table and searches for the requested domain. If it found something, it gives back the destination and closes the request. If nothing is found, it tries to get a default-server from the `serverDefault`-Table, if one is specified and active.

An example setup is shipped with the import of the `init.sql`-file, which will fit the most usages (just add more servers to the `basic`-table).

### A note to the `additionalColumns`-Column in the `serverTables`-Table
This field is used, to tell the programm, that there are special columns in the specified serverTable.
At the moment, the only usable special column is `lastLokkup`, which should be an integer as type.
If you specified this column, MySQL-TSDNS will save a timestamp in this field, everytime the domain is requested.

License
-------
This software is licensed under the [Mozilla Public License v. 2.0](http://mozilla.org/MPL/2.0/). For more information, read the file `LICENSE`.<commit_msg>Added notice "For more information..."<commit_after>MySQL-TSDNS
===========
A TSDNS-Server for Teamspeak 3, that uses MySQL for configuration.  
For more information how it works, look at [**Configuration**](#configuration).

Requirements
------------
 - [nodejs](http://nodejs.org/)
 - [npm](https://npmjs.org)


Installation
------------
 1. Download the Git-Repo (we recommend stable) into a directory of your choice
 2. Run "`npm install`" to install the dependencies
 3. Copy the `config.dist.json`-file to ``config.json``
 and change it, as your needs
 4. Import the `init.sql` into your database (structure + testdata). Ensure that you selected a target scheme first.
 5. Change the settings in the db, as your needs. (see [**Configuration**](#configuration) for more)
 6. Run "`./mysql_tsdns_startscript start`" to start the MySQL-TSDNS-Server and your are ready. :D

Configuration
-------------
MySQL-TSDNS stores all data in the db (name would be silly otherwise).  
As a domain is requested, MySQL-TSDNS first read all available tables to look the teamspeak-servers up from the `serverTables`-Table, then it goes throw every table and searches for the requested domain. If it found something, it gives back the destination and closes the request. If nothing is found, it tries to get a default-server from the `serverDefault`-Table, if one is specified and active.

An example setup is shipped with the import of the `init.sql`-file, which will fit the most usages (just add more servers to the `basic`-table).

### A note to the `additionalColumns`-Column in the `serverTables`-Table
This field is used, to tell the programm, that there are special columns in the specified serverTable.
At the moment, the only usable special column is `lastLokkup`, which should be an integer as type.
If you specified this column, MySQL-TSDNS will save a timestamp in this field, everytime the domain is requested.

License
-------
This software is licensed under the [Mozilla Public License v. 2.0](http://mozilla.org/MPL/2.0/). For more information, read the file `LICENSE`.
{'fraction_non_alphanumeric': 0.10695716761574647, 'fraction_numerical': 0.005446892795246348, 'mean_word_length': 3.8792270531400965, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5336328', 'n_tokens_mistral': 1124, 'n_tokens_neox': 1060, 'n_words': 554}