| Author |
Message |
Topic: Calling on DJCassio for some help |
GoreApostle
Replies: 83
Views: 4602
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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.  |
Topic: FEASST 2.0 SQL question |
GoreApostle
Replies: 2
Views: 43
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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? |
| |