Raduga (English)

User: Guest

Search

Please use the
Bug Report Form
if you think you found a software defect.

Use the Contact Form
to send a personal message to Wolfgang.

RSS Feed RSS Feed

Other boards:
Juke
QBrowser
Song Requester
SuperEdi

Current song - SQL

Posted on: Raduga (English)

From Message

Kma

2006-01-01 19:57:57

Current song - SQL

I whant uplaod the current song on mySQL whit an add-in (or update the javascript (upload on ftp) or vbs(current song.txt) addin)

Thank

ps: sorry for my bad english but i'm french

-- -- In french -- --

Je cherche a modifier le script present par defaut dans le pack VBS et JAVSCRIPT afin d'unploader le current song dans une table SQL

merci

Wolfgang Loch

2006-01-02 01:13:47

Re: Current song - SQL

Does the MySQL database run on the same computer as Raduga? Do you have Perl installed on this machine?

Alex

2006-01-02 09:18:21

Re: Current song - SQL

Actually, I have the same question as Kma.

I'm running on a distant mysql database, my databse is compatible with distant access.

Thx.
Alex.

Kma

2006-01-02 13:20:11

Re: Current song - SQL

I have the solution:

I modified the shoutcast plugin:

Modify the "var URLPrefix = "http://"+Server+":"+Port+"/admin.cgi?pass="+encodeURIComponent(Password)+"&mode=updinfo&song=";"
with "var URLPrefix = "http://yoursite/up-titre.php?titre=";"

the php code is :

<?PHP
include("conf.php");
$sql = "INSERT INTO Titre(titre)
VALUES('$titre')";
mysql_query($sql)
or die('Erreur SQL !'.$sql.'
'.mysql_error());
?>

Alex

2006-01-02 13:57:00

Re: Current song - SQL

Well done !

Thanks Kma !
Alex.

Post a reply to this message: