Did You know: RadioDJ has the ability to take online listener requests? Well it does …
We thought we would do a short tutorial on how to setup RadioDJ Online Requests.
To get the request system working with RadioDJ you need to do the following.
1) Create a new MySQL user that isn’t “root” You can find out how to do that HERE
“TIP: When setting MariaDB up choose a strong password with lots of number and symbols WRITE IT DOWN!”
2) Make sure you have RadioDJ installed and port 3306 unblocked on your router, firewall or even antivirus etc..
3) Place the Plugin_Requests.dll file in the plugin folder within RadioDJ. (This file can be found in the disabled plugins folder)
“Please Note: The RadioDJ WordPress plugin may not function properly with the new v2.0.0 database as columns have been changed in the database with the upgrade”
5) Upload the demo script file to your web-server via FTP or upload the WordPress plugin to your WP installation.
Then edit the details in the config.php file so it points to your MySQL database and also points to Your external IP address.
(In the WordPress plugin activate and then click on RadioDJ settings from the settings menu)
In config.php in the website template you need to complete these details:
########### edit settings ######### $dataip = "127.0.0.1"; // External IP address http://www.whatsmyip.org/ $database = "admin_radiodj"; // Your Database name $username = "admin_radiodj"; // Your Database user name $userpass = "MySuperSecretPassword"; // Your Database password $dataport = "3306"; // Database port number $timezone = "Europe/London"; // http://php.net/manual/en/timezones.php $reqLimit = "100"; // Request limit per day $req_wait = "5"; // Waiting minutes between requests $req_event = "0"; // Minutes between requests in event 0 = don't show $reqsubcat = "1,2,3"; // Subcategories to exclude use ID numbers like 1,2,3 Empty for show all $page_limit = "50"; // How many tracks showing in the page $track_repeat = "1450"; // Same track can't play in minutes $artist_repeat = "300"; // Same artist can't play in minutes $random_seed = rand(1,100000); // Generate random number (Used in combo with SQL Rand) / Edge fix $random_limit = "20"; //Sets the limit and button
Please don’t copy the example code from this page make sure you enter you server information in config.php between the ” ” marks.
Important: You can change the MySQL ports at your own risk! Be warned some website hosting providers may ban you if you use an alternative port.
Subcategory numbers can be found in the Database Subcategory table use HeidiSQL or other SQL editing tools to find out this information.
6) Make sure your web host/server host allows connections on the port you want to use (Usually the same port as SQL 3306). Any good web-host will have these ports available. Ask before you sign up to any service.
“Companies such as GoDaddy/Hostgator block the required ports and will not open them no matter how much you ask you will have to shop around for a provider who does, any reputable company will answer your questions before you sign up.”
7) If you Opened the SQL port 3306 on your broadband router. Make sure that it points to the internal IP of the computer of the machine running RadioDJ (e.g 192.168.0.3) and the MySQL server.
If you have done all the above and configured everything properly, You should now be able to take online requests from your website.
Support for this web script isn’t available AFAIK, Its a basic starting point for you to code a website around.
“This script is for entertainment purposes only, Use/modify at own risk”
The RadioDJ request demo has been tested on PHP 7.2 and Apache 2.2 July 2018
Last updated on: 19th July 2018
at 18:45 PM Europe/London