Author Topic: Online Requests - Same artist  (Read 243 times)

urayoan

  • New User

  • Offline
  • *
  • 10
Online Requests - Same artist
« on: August 10, 2018, 03:40:22 PM »
Hi:
  First of all. Thank you to the developers an people who works with RadioDJ. It is an amazing piece of software. Lots of flexibility and features that makes endless possibilities to work and make the thing we want in a efficient way.

  Right now, we are using the software, and with some programming in our end, we were able to make requests from our station app and even send push notifications to the user who requested the song within RadioDJ, when the track is starting to play. (did i tell, endless possibilities?)

  So here is my question, when he user add a track to the request, the rule does not let the user add the same song again but, if they want, they can add the same artists to the requests queue. There is a way to check if the artist exists in the requests queue, similar to the song.

  Any suggestions will be appreciated, i am pretty sure i am missing something.

Thanks again
@ Urayoán Miranda

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 3589
  • Personal Text
    I do NOT compile code for RadioDJ I'm just a USER!
    • DJ Garybaldy
Re: Online Requests - Same artist
« Reply #1 on: August 10, 2018, 03:47:45 PM »
Quote
So here is my question, when he user add a track to the request, the rule does not let the user add the same song again but, if they want, they can add the same artists to the requests queue. There is a way to check if the artist exists in the requests queue, similar to the song.

Currently looking for an answer on this one with our request script, There's a few anomalies somewhere which we can't seem to fathom out.
Its also letting people search for disabled track titles too which is bamboozling us. We're going to look at it when we get chance to get our coding heads together.
Someone may come up with a fix before us so its best to check back on the forums.
Proud USER of RadioDJ since 2011

https://djgarybaldy.co.uk/maria-db-radiodj/
https://djgarybaldy.co.uk/help-cant-install-radiodj/
https://djgarybaldy.co.uk/radiodj-php-request-script-basic/
https://www.facebook.com/DJGarybaldy/

Currently Beta Testing 2.0.1.4

urayoan

  • New User

  • Offline
  • *
  • 10
Re: Online Requests - Same artist
« Reply #2 on: August 10, 2018, 03:55:11 PM »
Currently looking for an answer on this one with our request script, There's a few anomalies somewhere which we can't seem to fathom out.
Its also letting people search for disabled track titles too which is bamboozling us. We're going to look at it when we get chance to get our coding heads together.
Someone may come up with a fix before us so its best to check back on the forums.

Thank you DJ Garybaldy. I will check regularly if someone else come with more ideas.

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3252
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: Online Requests - Same artist
« Reply #3 on: August 10, 2018, 04:53:26 PM »
My small question to understand the question  :hihi:

When a request is in the request and not played or in the plylist the requester cant request the artist?

R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Testing 2.0.1.4

PROducer

  • Sr. Member

  • Offline
  • ****
  • 433
  • Personal Text
    Long Time Radio Guy
    • The Rooster
Re: Online Requests - Same artist
« Reply #4 on: August 10, 2018, 06:05:48 PM »
When the user add a track to the request, the rule does not let the user add the same song again but, if they want, they can add the same artists to the requests queue. There is a way to check if the artist exists in the requests queue, similar to the song?
In the database, there is a table for `requests`.  The table only contains the song ID, not the artist or title so you would need to gather, also the info from the `songs` table.


urayoan

  • New User

  • Offline
  • *
  • 10
Re: Online Requests - Same artist
« Reply #5 on: August 10, 2018, 07:18:59 PM »
My small question to understand the question  :hihi:

When a request is in the request and not played or in the plylist the requester cant request the artist?

Good question Jhonny, with the requests file first, i can use similar logic to check in the playlist_list too. Right now the scripts only check for the song but not the artists. I want to prevent the listeners to put the same artist in the hour if i already have a requested song with the artist in requests or even playlist_list queue

urayoan

  • New User

  • Offline
  • *
  • 10
Re: Online Requests - Same artist
« Reply #6 on: August 10, 2018, 07:21:27 PM »
In the database, there is a table for `requests`.  The table only contains the song ID, not the artist or title so you would need to gather, also the info from the `songs` table.

Yes i am aware of that. One way i was thinking is running for every song that hasn't been played and compare, but to be honest i think this is not gonna be efficient for the service.

stevewa

  • Sr. Member

  • Offline
  • ****
  • 258
Re: Online Requests - Same artist
« Reply #7 on: August 17, 2018, 02:40:42 PM »
research sql joins using NOT IN (1, 2, 3, etc)

populate the numbers inside the parenthesis with the track ids that are in the requests table.
that will ignore any tracks in the request table, so they won't be show in the list of tracks to request.

urayoan

  • New User

  • Offline
  • *
  • 10
Re: Online Requests - Same artist
« Reply #8 on: August 20, 2018, 04:13:53 PM »
research sql joins using NOT IN (1, 2, 3, etc)

populate the numbers inside the parenthesis with the track ids that are in the requests table.
that will ignore any tracks in the request table, so they won't be show in the list of tracks to request.

I will try that. Thank you stevewa!