Rotation querys

[Jhonny]

If you have no knowledge of sql, it might be difficult to make a rotation query with the rotation query maker in radio dj.

I tried to make a script to make this a little easier.
I placed it in a small web server if you don't have a server.
Let it know if it's useful.
Download

Main screen.

[chebaev]

I tried to use this, but when i write MySQL information and click the button "Save configuration settings" is nothing is happening. Just the page is reloaded.

[Jhonny]

It should just work on this way.

Video

[Jhonny]

I tried to use this, but when i write MySQL information and click the button "Save configuration settings" is nothing is happening. Just the page is reloaded.

So sorry! the download link ref to a other script     it's fix now.

[FreerunMedia]

NICE! I didn't understand it but thats me  I am searching for something else though. So i will ask the SQL guru Jhonny

The thing i would love to have is automatic change from normal rotation to christmas rotation and back So let's say when events are running and the timeslot is over, give it a +1 year to prepair it for the upcoming year. Same for the "dodenherdenking" that is started every year on one day. I can't find it in the forum for the only reason, it's sooooooo much topics 

Can you help me out or point me to the part of the forum that i need?

[Jhonny]

This can be done with the events and some sql script that runs on 1- Jan every  year the sql file is used to reset the date for Christmas / dode herdenking (all  WWII victims)  etc when there date to play and from disabled to anabled (for the requests option).
I have to look in to it how to make the sql file work best.

[EmmaSts]

This can be done with the events and some sql script that runs on 1- Jan every  year the sql file is used to reset the date for Christmas / dode herdenking (all  WWII victims)  etc when there date to play and from disabled to anabled (for the requests option).
I have to look in to it how to make the sql file work best.

Just a note Jhonny
Don't do the SQL as a Day or Yearly rotation Query as over time it go out of align... do it by day / month of todays date (Plus easier to add to)

for eg:
editted as thinking about it you'd need a query to return to normal.....

Code Select Expand

$date = date("d/m");
if($date == '4/7'){
$sqlquery //run query
}elseif($date == '5/7'){
$sqlquery //run return to normal query
}elseif($date == '1/12'){
$sqlquery //run query
}elseif($date == '1/1'){
$sqlquery //run return to normal query
}else{
// Do nothing
}

[Jhonny]

I was thinking, if the special tracks where in a special folder (most time there are), just disable or enable is simplest. as for Halloween ect. to.then only tho euery's are needed
it's just the id_subcat to selectlike:
UPDATE SONGS
SET enabled = O (-1)
WHERE id_subcat = (christmas ID)  And id_subcat =  (WW2 ID) AND id_subcat = (whatever ;
And opposed is
UPDATE SONGS
SET enabled = 1
WHERE id_subcat = (christmas ID)  And id_subcat =  (WW2 ID) AND id_subcat = (whatever ;
And of course you can use something like this on date for certain periods of time. (shortly before and shortly after) with events.

[Jhonny]

Em updating (expanding) the script.
Like select between bpm's
any other ideas or improvements?