FM5280 ~ Smooth Jazz
I have one in my house and it works!! Buy this product from FM5280
Listen to FM5280   
   
Click Here to Listen to FM5280 Smooth Jazz


 

Main Menu   
   
HomeHome
    Home
Navigation
    Getting Started
    Playlist Schedule
    Listener Graphs
Discussions
    Forums
    Private Messages
    Shout Box
    Polls/Surveys
News
    News
    Stories Archive
    Submit News
    Reviews
Information
    Feedback
    Recommend Us
    Calendar
    Search
    Your Account
    Groups
    Profile
    Request Policy
    Docs
    I Like Tunes Stations
Advertising
    Advertising
    Statistics
Files & Links
    Web Links

 

Shout Box   
   

Only registered users can shout. Please login or create an account.

 

Google Ads   
   

 


Search for at
FM5280 Smooth Jazz Advanced Search

Search found 257 matches
FM5280 Smooth Jazz Forum Index
Author Message
  Topic: Calling on DJCassio for some help
GoreApostle

Replies: 83
Views: 4602

PostForum: Web Site & Listen Issues   Posted: Mon Aug 23, 2010 1:02 am   Subject: Re: Calling on DJCassio for some help
If I wanted to result different results on say Sunday so that it only displayed certain artists how would I use the "if" statement.  I am doing a search for it now but thought I would post here as well.  Sorry to hear about your station.  I wish the best for you and hope to still see you on SA forums.

Would this work?

Code:
if ((date('l') == 'Sunday'))
        $result = mysql_query( "select distinct artist, fhr_artistid as artist_id from songlist where upper(artist) " . $the_regex . " and (mood like '%classic%' or mood like '%hard%' or mood like '%thrash%' or mood like '%progressive%' or mood like '%punk%' or mood like '%rock%') order by artist", $samDB );
      else
      $result = mysql_query( "select distinct artist, fhr_artistid as artist_id from songlist where upper(artist) " . $the_regex . " and (mood like '%heavy%' or mood like '%metal%' or mood like '%thrash%' or mood like '%progressive%' or mood like '%punk%' or mood like '%hard%') order by artist", $samDB );


*THIS WORKED FOR ME*  Cool!!
  Topic: SQL Question
GoreApostle

Replies: 1
Views: 42

PostForum: Web Site & Listen Issues   Posted: Thu Aug 19, 2010 10:57 pm   Subject: SQL Question
DJ, if I had an artist in SAM but weren't all spelled the same is there a sql statement that I can run to correct an artist to have only one name.  EX.:

Ronnie Milsapp (the misspelled version)
Ronnie Milsap (correct name)

I was wondering if there was a sql statement I could run to change Ronnie Milsapp to Ronnie Milsap in one swoosh.
  Topic: Calling on DJCassio for some help
GoreApostle

Replies: 83
Views: 4602

PostForum: Web Site & Listen Issues   Posted: Thu Aug 19, 2010 2:04 am   Subject: Re: Calling on DJCassio for some help
No errors just doesn't return any results. :shock:

*CORRECTION*  I didn't have it in the correct place in the statement.  I put it in like you posted and it worked just fine.  Thank you so much.
  Topic: Calling on DJCassio for some help
GoreApostle

Replies: 83
Views: 4602

PostForum: Web Site & Listen Issues   Posted: Wed Aug 18, 2010 1:07 pm   Subject: Re: Calling on DJCassio for some help
DJ, I hope I am not abusing by posting this.  This is a SQL call in Festerhead's FEASST.  I am trying to do what we were working on above.  I am trying to get this statement to only display artist from preselected moods.  Here is Festerhead's statement:

Code:
$result = mysql_query( "select distinct artist, fhr_artistid as artist_id from songlist where upper(artist) " . $the_regex . " order by artist", $samDB );


I am trying to work this into the above statement:

Code:
$SAMdb->open("SELECT distinct album, artist, picture from songlist $where and (mood like '%Heavy%' or mood like '%metal%' or mood like '%Thrash%' or mood like '%progressive%') group by artist order by artist asc");


I want to be able to insert the mood calls into Festerhead's statement.  I have tried several ways of doing it but it doesn't display the artists.
  Topic: FEASST 2.0 SQL question
GoreApostle

Replies: 2
Views: 43

PostForum: Web Site & Listen Issues   Posted: Tue Aug 17, 2010 2:08 pm   Subject: Re: FEASST 2.0 SQL question
Thank you.  That fixed it right up. Very Happy
  Topic: FEASST 2.0 SQL question
GoreApostle

Replies: 2
Views: 43

PostForum: Web Site & Listen Issues   Posted: Tue Aug 17, 2010 1:32 pm   Subject: FEASST 2.0 SQL question
Hey DJ, I know this is a little off course but was wondering if you could help me find out why this SQL statement is not adhering to the album years.  Here is the script:

Code:
CREATE OR REPLACE VIEW fhr_sunday_flashback_show_view AS
  SELECT DISTINCT id
  FROM songlist
  WHERE albumyear > 1960
  AND albumyear < 1989
  AND mood LIKE 'classic%'
  OR mood LIKE 'new wave%'
  OR mood LIKE 'rock%';


It is pulling the moods but it is not only picking songs between 1960 - 1989.  It is picking songs from 2007, 2009, 2004 and so on.  Is there something that I didn't add to this script?  I am not getting any errors whatsoever.
  Topic: Points question
GoreApostle

Replies: 3
Views: 111

PostForum: Web Site & Listen Issues   Posted: Sun Jul 04, 2010 1:30 pm   Subject: Re: Points question
If I wanted to add a points value for people that rate songs where would I go in Nuke Evolution to set the value?  I remember in the older nuke versions I could set the values of points in the Admin.  I can't seem to find it in Nuke Evolution.
  Topic: Points question
GoreApostle

Replies: 3
Views: 111

PostForum: Web Site & Listen Issues   Posted: Fri Jul 02, 2010 12:32 pm   Subject: Points question
DJ,
where in Nuke Evolution would I go to alter or modify point values?  I can't seem to find it anywhere.
  Topic: New User Registration question
GoreApostle

Replies: 3
Views: 259

PostForum: Web Site & Listen Issues   Posted: Sun Jun 06, 2010 12:16 pm   Subject: Re: New User Registration question
Cool.  I can do that.  Thanks DJ.  Just seemed weird.  All my settings in Your_Account seem to be correct.  I will keep an eye on it and see what happens.
  Topic: New User Registration question
GoreApostle

Replies: 3
Views: 259

PostForum: Web Site & Listen Issues   Posted: Thu Jun 03, 2010 10:39 am   Subject: Re: New User Registration question
Correction!

What is actually happening is when a new user registers it is automatically throwing them into the suspended status.  How can I correct this?  Thanks DJ.
  Topic: New User Registration question
GoreApostle

Replies: 3
Views: 259

PostForum: Web Site & Listen Issues   Posted: Thu Jun 03, 2010 10:30 am   Subject: New User Registration question
DJ,
is there a setting in Sentinel that would prevent users from signing up and then logging in?  I just tried to register a username myself and it sent me the activation link and when I click on it it took me to the User Account page and it does in fact show up.  However, when I tried to login using the login info it doesn't find the username I registered.  What do you think could be the problem?
  Topic: Old PHP Nuke users question
GoreApostle

Replies: 1
Views: 420

PostForum: Web Site & Listen Issues   Posted: Fri May 07, 2010 1:44 pm   Subject: Old PHP Nuke users question
DJ,
is there a way to pull all of my users from my old PHP Nuke site over to my new Nuke Evolution site?
  Topic: Nuke Evolution right block question
GoreApostle

Replies: 3
Views: 226

PostForum: Web Site & Listen Issues   Posted: Fri May 07, 2010 12:33 pm   Subject: Re: Nuke Evolution right block question
My Now Playing page is a module.  I don't have any other problem with the user login check except for the Ratings and the Add Comment.  It tells me to Please Login.  I am going to be upgrading to Xtreme soon.  I left the cookies settings in Perference the way they were when installing.  Here are my settings as they were on install:

Code:
Cookie domain  onlinemetalradio.com
Cookie name   nukeevo
Cookie path   /


Should I use the SSL feature?  Should any of the above info be changed?

Thanks DJ.
  Topic: Nuke Evolution right block question
GoreApostle

Replies: 3
Views: 226

PostForum: Web Site & Listen Issues   Posted: Wed May 05, 2010 4:24 pm   Subject: Nuke Evolution right block question
DJ,
how would I turn the right blocks off in Evolution on the Now Playing page?  I have read what I could find and it tells me to selection those options on the Modules setting in admin.  I made changes but the right blocks on the Now Playing page still show up.

Also, I know that I asked you this before but I have moved over to Nuke Evolution myself and I am having a problem with it telling me to please login to see Recently Played and Ratings on my Now Playing page.  I am logged in but it is still seeing me as not with those two things.
  Topic: Nuke Sentinal possible issue
GoreApostle

Replies: 1
Views: 118

PostForum: Web Site & Listen Issues   Posted: Mon Apr 26, 2010 12:23 pm   Subject: Nuke Sentinal possible issue
Is it possible that Sentinel is preventing me from seeing Recently Played songs?  I am logged in and I am able to request songs but it doesn't show me Recently Played tracks on Coming Up queue.  Can you think of anything that it could be?
 
Page 1 of 18 Goto page : 1, 2, 3 ... 16, 17, 18  Next
All times are UTC - 5 Hours
Jump to:  




Powered by phpBB © 2001, 2006 phpBB Group

chromo Theme by effectica ©
Forums ©
Powered by Nuke Evolution theme designed by effectica.com

FM5280~Smooth Jazz is part of the LoudCity network,
which provides blanket license coverage for FM5280~Smooth Jazz to
 ASCAP, BMI, SESAC and SoundExchange.

Spambot Killer
Site Map

[News Feed] [Forums Feed] Powered by HTML Purifier[Validate robots.txt]


PHP-Nuke Copyright © 2006 by Francisco Burzi.
All logos, trademarks and posts in this site are property of their respective owners, all the rest © 2006 by the site owner.
Powered by Nuke Evolution 2.0.7 - Nuke-Evolution Xtreme 2.0 Edition.

This site is cached. Click here to update the cache.
[ Page Generation: 0.28 Seconds | Memory Usage: 10.88 MB ]

Do Not Click