Skip to Content
It is currently February 25th, 2021, 11:43 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 29 posts ]  Go to page 1, 2  Next
Author Message
PostPosted: March 16th, 2012, 7:45 am 
Offline
Senior User
Senior User

Joined: March 16th, 2012, 7:15 am
Posts: 75
I've made a site and I've uploaded the files but the Current Playing and Recently Played boxes doesn't work and how to do the countdown song?

http://jazzfm.site50.net/playing.html

Do I need to set up a MySQL database? I will be using HTML and I'm requested on Audiorealm.com


Top
 Profile  
Reply with quote  
PostPosted: March 16th, 2012, 8:13 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10524
Location: Denver, CO
I was able to make a request, seems to be working.

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
PostPosted: March 16th, 2012, 8:23 am 
Offline
Senior User
Senior User

Joined: March 16th, 2012, 7:15 am
Posts: 75
but the the status of the current song and recently songs doesn't update :( and the countdown until the next song?

I know the request works and I have not set up a database ;) people requests through audiorealm or do I need to setup a database to get the countdown?
like this: http://www.lahotcountry.com/


Top
 Profile  
Reply with quote  
PostPosted: March 16th, 2012, 9:13 am 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8152
Location: Cologne (Germany)
All you need to do to make this work properly is allow javascript in the browser and configure the HTML Output in SAM properly.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode


Top
 Profile  
Reply with quote  
PostPosted: March 16th, 2012, 9:18 am 
Offline
Senior User
Senior User

Joined: March 16th, 2012, 7:15 am
Posts: 75
I have cofigure the HTML Output in Sam but it is just that the song title never updates :/


Top
 Profile  
Reply with quote  
PostPosted: March 16th, 2012, 9:19 am 
Offline
Senior User
Senior User

Joined: March 16th, 2012, 7:15 am
Posts: 75
also it says

Loop error: Dynamic SQL Error SQL error code = -104 Token unknown - line 7, char 4 LIMIT


Top
 Profile  
Reply with quote  
PostPosted: March 16th, 2012, 11:16 am 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8152
Location: Cologne (Germany)
The HTML templates are obviously not designed to work with the special SQL syntax of Firebird.
You need to check all the SQL statements in the templates for compatibility.
They are obviously designed with MySQL in mind.
Firebird doesn't know the LIMIT clause, the syntax used in Firebird to achieve the same is FIRST ... SKIP ...
Example:
MySQL:
Code:
SELECT column1, column2, column3 FROM foo LIMIT 10, 20

Firebird:
Code:
SELECT FIRST 10 SKIP 20 column1, column2, column3 FROM foo

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode


Top
 Profile  
Reply with quote  
PostPosted: March 16th, 2012, 12:08 pm 
Offline
Senior User
Senior User

Joined: March 16th, 2012, 7:15 am
Posts: 75
Code:
<html>

<head>
<title>Jazz FM</title>
<LINK REL=STYLESHEET HREF="style.css" TYPE="text/css">
<script language='JavaScript1.2' src='http://www.audiorealm.com/player/player.js.html?srefID=349575&subscription=no'></script>
<script language='JavaScript1.2' src='java/request.js'></script>
<script language='JavaScript1.2' src='java/songinfo.js'></script>
</head>

<body>

<table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td width="1%" align="center"><a href="playing.php"><img border="0" src="images/logo.gif"></a><br>
      <img border="0" src="images/spacer.gif" width="15" height="13"></td>
    <td width="99%" valign="middle" align="left"><b><font size="5"> &nbsp; Jazz FM</font></b></td>
  </tr>
  <tr>
    <td width="100%" colspan="2" bgcolor="#000080"><img border="0" src="images/spacer.gif" width="1" height="1"></td>
  </tr>
</table>

<br>

<table border=0 cellspacing=5 cellpadding=5>
<tr>
 <td align="center" valign="top" width="1%">
<table border="0" cellspacing="0" cellpadding="2" bgcolor="#EEEEEE">
  <tr>
    <td nowrap colspan="2" bgcolor="#C0C0C0" align="center"><b>Navigation</b></td>
  </tr>
  <tr>
    <td nowrap align="center"><img border="0" src="images/speaker.gif"></td>
    <td nowrap><a href="javascript:player(176657,-1)">Click to Listen</a> </td>
  </tr>
  <tr>
    <td nowrap align="center"><img border="0" src="images/play.gif"></td>
    <td nowrap><a href="playing.html">Now playing</a></td>
  </tr>
  <tr>
    <td nowrap align="center"><img border="0" src="images/tb-file-list.gif"></td>
    <td nowrap><a href="playlistA.html">Playlist &amp; Requests</a></td>
  </tr>
  <tr>
    <td nowrap align="center"><img border="0" src="images/chat.gif"></td>
    <td nowrap><a href="http://xat.com/web_gear/chat/go_large.php?id=169036695">Chat online</a></td>
  </tr>
  <tr>
    <td nowrap align="center"><img border="0" src="images/email.gif"></td>
    <td nowrap><a href="mailto:jekvall95@gmail.com">Email us!</a></td>
  </tr>
</table>

 <br>
 <br>
<a href="http://www.audiorealm.com" target="_blank"><img src="images/ar120x60b.gif" width="120" height="60" border="0" alt="AudioRealm.com - Your source for music on the web!">
<br>
<br>
<a href="http://www.spacialaudio.com" target="_blank"><img src="images/sam120x60.gif" width="120" height="60" border="0" alt="Powered by SAM2 technology">
 </td>
 <td align="left" valign="top" width="99%">

<SCRIPT LANGUAGE="JavaScript">
<!---
 var refreshID = "";
 refreshID = setTimeout("DoRefresh()", 90000);
 
function DoRefresh()
{
  var buster = Math.random();
  document.location.href = 'playing.html?buster='+buster;
}
//--->
</SCRIPT>

There are currently 1 listeners tuned into this station!<br><br>

<table border="0" width="98%" cellspacing="0" cellpadding="4">
  <tr bgcolor="#002E5B">
    <td colspan="1" nowrap align="left">
      <p><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"><b>Currently Playing</b></font>
    </td>
   <td colspan="3" nowrap align="center">
      <p><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"><b>Links</b></font>
    </td>
    <td nowrap align="left">
      <p><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"><b>Album</b></font>
    </td>
   <td nowrap align="Right">
      <p><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#FFFFFF"><b>Time</b></font>
    </td>
  </tr>

  <tr bgcolor="#dadada">
 

    <td><font size="2" color="#003366"><small>Nervous Charlie and the Panic Orchestra - If I can't have you</small></font></td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findcd.html?artist=Nervous%20Charlie%20and%20the%20Panic%20Orchestra&title=If%20I%20can't%20have%20you&album=Ok%E4nt%20album%20(2011-09-01%2022:39:40)" target="_blank"><img
    src="images/buy.gif" alt="Buy this CD now!" border="0"></a></font>
    </td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findwebsite.html?artist=Nervous%20Charlie%20and%20the%20Panic%20Orchestra&title=If%20I%20can't%20have%20you&album=Ok%E4nt%20album%20(2011-09-01%2022:39:40)" target="_blank"><img
    src="images/home.gif" alt="Artist homepage" border="0"></a></font>
    </td>
   
   <td nowrap align="center" nowrap width="1%">
      <font size="2" color="#003366"><a href="javascript:songinfo(791)"><img
    src="images/info.gif" alt="Song information" border="0"></a></font>
    </td>
   
    <td nowrap><font color="#003366" size="2"><small>Okänt album (2011-09-01 22:39:40)</small></font></td>
    <td nowrap>
      <p align="right"><font color="#003366" size="2"><small><strong>3:53</strong></small></font>
    </td>
  </tr>
 


<tr bgcolor="#F6F6F6"><td colspan="6">
<b><font size="2" color="#777777">Coming up:</font></b>
<font size="2" color="003366"><b>

AlfEverGreenBand&nbsp;

Original Dixieland Jazz Band&nbsp;

</b></font></td></tr>

 
  <tr bgcolor="#002E5B">
    <td colspan="6" nowrap>
      <p align="left"><b><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF">Recently
        played songs</font></b>
    </td>
  </tr>
 


<tr bgcolor="#dadada">
    <td><font size="2" color="#003366"><small>Red Nichols AND HIS BAND - Deep Summer Music</small></font></td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findcd.html?artist=Red%20Nichols%20AND%20HIS%20BAND&title=Deep%20Summer%20Music&album=Syncopated%20Chamber%20Music" target="_blank"><img
    src="images/buy.gif" alt="Buy this CD now!" border="0"></a></font>
    </td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findwebsite.html?artist=Red%20Nichols%20AND%20HIS%20BAND&title=Deep%20Summer%20Music&album=Syncopated%20Chamber%20Music" target="_blank"><img
    src="images/home.gif" alt="Artist homepage" border="0"></a></font>
    </td>
   
   <td nowrap align="center" nowrap width="1%"></td>
   
    <td nowrap><font color="#003366" size="2"><small>Syncopated Chamber Music</small></font></td>
    <td nowrap>
      <p align="right"><font color="#003366" size="2"><small><strong>2:50</strong></small></font>
    </td>
  </tr>


<tr bgcolor="#dadada">
    <td><font size="2" color="#003366"><small>Carling Big Band - Dromedar</small></font></td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findcd.html?artist=Carling%20Big%20Band&title=Dromedar&album=Gunhild%20Carling%20Big%20Band" target="_blank"><img
    src="images/buy.gif" alt="Buy this CD now!" border="0"></a></font>
    </td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findwebsite.html?artist=Carling%20Big%20Band&title=Dromedar&album=Gunhild%20Carling%20Big%20Band" target="_blank"><img
    src="images/home.gif" alt="Artist homepage" border="0"></a></font>
    </td>
   
   <td nowrap align="center" nowrap width="1%"></td>
   
    <td nowrap><font color="#003366" size="2"><small>Gunhild Carling Big Band</small></font></td>
    <td nowrap>
      <p align="right"><font color="#003366" size="2"><small><strong>3:27</strong></small></font>
    </td>
  </tr>


<tr bgcolor="#dadada">
    <td><font size="2" color="#003366"><small>Original India Five - Deep Henderson</small></font></td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findcd.html?artist=Original%20India%20Five&title=Deep%20Henderson&album=Ok%E4nt%20album%20(2011-08-16%2022:38:50)" target="_blank"><img
    src="images/buy.gif" alt="Buy this CD now!" border="0"></a></font>
    </td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findwebsite.html?artist=Original%20India%20Five&title=Deep%20Henderson&album=Ok%E4nt%20album%20(2011-08-16%2022:38:50)" target="_blank"><img
    src="images/home.gif" alt="Artist homepage" border="0"></a></font>
    </td>
   
   <td nowrap align="center" nowrap width="1%"></td>
   
    <td nowrap><font color="#003366" size="2"><small>Okänt album (2011-08-16 22:38:50)</small></font></td>
    <td nowrap>
      <p align="right"><font color="#003366" size="2"><small><strong>3:00</strong></small></font>
    </td>
  </tr>


<tr bgcolor="#dadada">
    <td><font size="2" color="#003366"><small>Ethel Waters - Guess Who's In Town</small></font></td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findcd.html?artist=Ethel%20Waters&title=Guess%20Who's%20In%20Town&album=" target="_blank"><img
    src="images/buy.gif" alt="Buy this CD now!" border="0"></a></font>
    </td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findwebsite.html?artist=Ethel%20Waters&title=Guess%20Who's%20In%20Town&album=" target="_blank"><img
    src="images/home.gif" alt="Artist homepage" border="0"></a></font>
    </td>
   
   <td nowrap align="center" nowrap width="1%"></td>
   
    <td nowrap><font color="#003366" size="2"><small></small></font></td>
    <td nowrap>
      <p align="right"><font color="#003366" size="2"><small><strong>3:02</strong></small></font>
    </td>
  </tr>


<tr bgcolor="#dadada">
    <td><font size="2" color="#003366"><small>Ethel Waters - True Blue Lou</small></font></td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findcd.html?artist=Ethel%20Waters&title=True%20Blue%20Lou&album=" target="_blank"><img
    src="images/buy.gif" alt="Buy this CD now!" border="0"></a></font>
    </td>
    <td nowrap width="1%">
      <p align="center"><font size="2" color="#003366"><a href="http://www.audiorealm.com/findwebsite.html?artist=Ethel%20Waters&title=True%20Blue%20Lou&album=" target="_blank"><img
    src="images/home.gif" alt="Artist homepage" border="0"></a></font>
    </td>
   
   <td nowrap align="center" nowrap width="1%"></td>
   
    <td nowrap><font color="#003366" size="2"><small></small></font></td>
    <td nowrap>
      <p align="right"><font color="#003366" size="2"><small><strong>3:02</strong></small></font>
    </td>
  </tr>
 
 
</table>

</td><td valign='top' align='center'>
Loop error:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 7, char 4
LIMIT
 



   


</td>   

   </td>
  </tr>
 </table>

<br>
<table cellpadding=2 cellspacing=2 border=0 width="100%">
<tr><td align="center"><hr width="80%" size="1" color="#00005E"></td></tr>
<tr><td align="center">

<p><font size="1">This station is part of the <a href="http://www.audiorealm.com">AudioRealm</a>
network.<br>
This page was produced using <a target="_blank" href="http://www.spacialaudio.com">SAM<sup>2</sup>
(Streaming Audio Manager)</a>. © Copyright <a target="_blank" href="http://www.spacialaudio.com">Spacial Audio
Solutions, LLC</a> 1999 - 2003.</font></p>

</td></tr>
</table>

</body>
</html>


Last edited by Mastacheata on March 16th, 2012, 2:26 pm, edited 1 time in total.
Pleas use code tags for code, this makes it easier to read


Top
 Profile  
Reply with quote  
PostPosted: March 16th, 2012, 12:09 pm 
Offline
Senior User
Senior User

Joined: March 16th, 2012, 7:15 am
Posts: 75
it is the "playing.html" code what should I change`?


Top
 Profile  
Reply with quote  
PostPosted: March 16th, 2012, 2:28 pm 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8152
Location: Cologne (Germany)
Nope, playing.html is what comes out after SAM evaluated the template _playing.html and put in all the current information.
So you need to modify at least the _playing.html
You'll probably need to edit all the other _something.html files too.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode


Top
 Profile  
Reply with quote  
PostPosted: March 17th, 2012, 5:52 am 
Offline
Senior User
Senior User

Joined: March 16th, 2012, 7:15 am
Posts: 75
Idk what I should change :/ but I would need countrywesterndj's help


Top
 Profile  
Reply with quote  
PostPosted: March 17th, 2012, 5:52 am 
Offline
Senior User
Senior User

Joined: March 16th, 2012, 7:15 am
Posts: 75
He seemse to know much about sam broadcaster


Top
 Profile  
Reply with quote  
PostPosted: March 17th, 2012, 7:50 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10524
Location: Denver, CO
JazzFM wrote:
but the the status of the current song and recently songs doesn't update :( and the countdown until the next song?

I know the request works and I have not set up a database ;) people requests through audiorealm or do I need to setup a database to get the countdown?
like this: http://www.lahotcountry.com/

Sorry misunderstood your question then. The countdown for the current track displayed on cwdj site is not done with HTML and is not done with the newly designed zend enabled web site. it is done with php and javascript and would require custom programming for the new SAM templates and I know that no one has published it yet on the new php pages.

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
PostPosted: March 17th, 2012, 11:09 am 
Offline
Senior User
Senior User

Joined: March 16th, 2012, 7:15 am
Posts: 75
So it is not possible to do it for me?


Top
 Profile  
Reply with quote  
PostPosted: March 17th, 2012, 4:01 pm 
Offline
SVS Member
SVS Member

Joined: October 15th, 2003, 11:59 pm
Posts: 4743
Location: Los Angeles - A Little West Of Nashville
The countdown times does not work in HTML, only works in PHP.

Re-programming it for HTML would take forever.

_________________
- DJ Dee
- Spacial Volunteer Support (SVS)
- Custom PAL services: www.palscripts.com
- http://www.AlternativeHD.com
- http://www.lahotcountry.com


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 29 posts ]  Go to page 1, 2  Next

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 20 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group