Trying to compare shoutcast now playing with mysql table entry

[Gordon_]

I posted this in another part but I think it was the wrong forum, mods could you close the other as I'm this should be here please?

 

 

I'm hoping someone can help, I'm currently working on adding some features to a Wordpress theme used on a local radio station. My query is with regards to displaying the current live show title, I have a written a php file that when processed by the title update form, updates a table in my db with the current show title (captured from the HTML form) but also captures the user id of whoever triggered the form, it then proceeds to update the Shoutcast server with the show title.

The idea behind this is to allow me to display dynamic wordpress content related to the current live DJ on the site - this works and has no issues, but what id like to do now is create a page that will check if the output of the Shoutcast server title matches the table in the db, if it does, then I'd like it to echo this output, if it is different I'd like it to use the output from the SC title instead.

 

I currently have 2 separate scripts that can output this info separately depending which is triggered but I need to combine these, (using an if / else command I'm assuming?) this is my current attempt but at the moment it doesn't seem to output the db fields and will only output the SC title from the server, regardless of the db title, it's almost as if it doesn't even acknowledge it and each time just outputs the shoutcast server info;

<?php
require_once('../../wp-config.php'); // open connection to WPdb
require_once('sc-config.php'); // open connection to Shoutcast Server

$query = "SELECT title, userID FROM sc_options where id = '0'";

$result = mysql_query($query);
while($row = mysql_fetch_row($result))
{
    $onAir_Title = $row[0];
    $onAir_IMG = $row[1];
}
$open = fsockopen("$ip","$port");
if ($open) {
fputs($open,"GET /7.html HTTP/1.1\nUser-Agent:Mozilla\n\n");
$read = fread($open,1000);
$text = explode(",",$read);
$text = $text[6];
} else { $text="connection refused."; }

$scast = $text;
$scdb = $onAir_Title;

if ($scdb == $scast)
{
echo $onAir_Title;
echo get_avatar( $onAir_IMG, 96);
}
else
{
echo $text;
}
?>

These are the original files, they work exactly as they should apart, but for the life of me I cannot get them to work as one

 

Shoutcast 

<?php
$open = fsockopen("198.154.106.116","6002");
if ($open) {
fputs($open,"GET /7.html HTTP/1.1\nUser-Agent:Mozilla\n\n");
$read = fread($open,1000);
$text = explode(",",$read);
$text = $text[6];
} else { $text="connection refused."; }
?>

<?php
echo $text;
?>

Wordpress db output

<?php
require_once('../../wp-config.php'); // open connection to WP

$query = "SELECT title, userID FROM sc_options where id= '0'";

$result = mysql_query($query);


while($row = mysql_fetch_row($result))
{
$onAir_Title = $row[0];
$onAir_IMG = $row[1];

// output
echo $onAir_Title;
echo get_avatar( $onAir_IMG, 96);
}

?>

Just to sum it up, would I'd like to happen, is have the file load, check the title in the database row, if that matches the title being displayed by shoutcast, echo the data from the table, if the output from shoutcast is different, then echo the output from shoutcast instead, the reason being when our Live DJ's are off air, our auto dj runs which populates the server directly, so my logic is if the Shoutcast server is different from the db, it must be Auto DJ running..