Track/Directory import


 ☰  menu

Short course to understand better.

Make your own query.

All posted information is not stored in any way!

Your port number must not be blocked for a connection!
(in win firewall or your Router/Modem)

SQL-Server address: SQL-Database name: SQL-User name: SQL-Password: SQL-Port number:

Make your own query
Pre RadioDJ variable listPresent query's made by visitors for download
Use save link as....
Name your query:
(.sql will be set to it like my-own-rotation.sql)

Your name:

  1. $ForceRepeatRules$
  2. $SweeperOnStart$
  3. $SweeperOnIntro$
  4. $SweeperOnEnd$

Important Column names.

  • ID
  • enabled
  • song_type
  • id_subcat
  • id_genre

Very simple start of a query.

SELECT * FROM songs WHERE enabled = 1 AND song_type = 0 AND enabled=1 AND id_subcat = 4 LIMIT 3
* ⇔ from all columns.

instead of the *, you can use ID, artist and title, so the list to show will not be so with.
(the most important thing is that the ID become obtained, else RadioDJ can't find the track)

songs ⇔ the table name.
enabled = 1 ⇔ only enabled tracks.
song_type = 0 ⇔ just songs no sweeper or jingle or stations id's.
id_subcat = 4 ⇔ In my case 4 is tracks from the subcategory 80s.
LIMIT 3 ⇔ setting how many tracks to select.

Before the LIMIT 3 (and also before, ORDER BY, GROEP BY, DESC and ASC), you can use the:
  • $ForceRepeatRules$
  • $SweeperOnStart$
  • $SweeperOnIntro$
  • $SweeperOnEnd$

The important commands are:

  • FROM
  • AND

  • ASC
  • DESC

I have copy the line in the rotation from query screen

Clicking on Run Query shows:

You can see in the list there are two ABBA tracks in it.

  • $ForceRepeatRules$
  • $SweeperOnStart$
  • $SweeperOnIntro$
  • $SweeperOnEnd$

Come in handy now, there are pre divined by Marius.

Puting in $ForceRepeatRules$ and a bit more what i will explan.

Using the line:
SELECT `ID`, `artist`, `title` FROM `songs` WHERE `song_type`=0 AND `enabled`=1 AND $ForceRepeatRules$ ORDER BY `count_played` DESC LIMIT 3;

    Splitting it up a bit.

  • SELECT ID, artist, title
    (information from 3 colomns)
  • FROM songs
  • WHERE enabled = 1
  • AND song_type = 0
  • AND id_subcat =
  • AND $ForceRepeatRules$
    Pre divined to the radiodj settings

  • ORDER BY `count_played`
    Put them in order of times played.
  • LIMIT 3
    Just 3 tracks no more.

  • All COUNT() prevents double selection of a Artist, Title or Album name.

    You can us ASC or DESC to in the line.
    ASC low to hight, DESC hight to low.

The line looks then as:
SELECT `ID`, `artist`, `title` FROM `songs` WHERE `song_type`=0 AND `enabled`=1 AND $ForceRepeatRules$ ORDER BY `count_played` DESC LIMIT 3;

Clicking on Run Query shows now:

For a start making a query, this explanation will do!

To top
This page was last modified on April 06 2020 7:11 am (CET)