global $title;
$title=eregi_replace(" ", " - ", $title);
$info=explode(" - ", $title);
$last=count($info)-1;
$title=$info[$last];
$artist=$info[0];
for($b=1;$b<(count($info)-1);$b++){
if(!eregi("([0-9]{2})", $info[$b])){
$artist .= " - $info[$b]";
} else {
$track=$info[$b];
}
}
$artist=explode(" - ", $artist);
$last=count($artist)-1;
$artist=$artist[$last];
if($info[1] == $artist){
$artist = "$info[0] -$artist";
}
$sql="select * from winamp order by date DESC, time DESC limit 0,1";
$result = mysql_query($sql);
$row=mysql_fetch_array($result);
$time=strtotime($row[time]);
$now=time();
$today=date("Y-m-d");
if ((($now - $time) < 30) || ($today != $row[date])){
$sql="delete from winamp where id=$row[id]";
mysql_query($sql);
$sql="update songs set count=count-1 where id=$row[title] and artistid=$row[artist]";
mysql_query($sql);
$sql="update artists set count=count-1 where id=$row[artist]";
mysql_query($sql);
}
$sql="select * from artists where name='$artist'";
$result=mysql_query($sql);
$artinfo=mysql_fetch_array($result);
$artcount=mysql_num_rows($result);
$sql="select * from songs where name='$title' and artistid=$artinfo[id]";
echo $sql."<br>";
$result=mysql_query($sql);
$songinfo=mysql_fetch_array($result);
$songcount=mysql_num_rows($result);
if($artcount > 0){
$artistid=$artinfo[id];
$artcounter=$artinfo[count]+1;
$sql="update artists set count=$artcounter where id=$artinfo[id]";
mysql_query($sql);
} else {
$sql="insert into artists(name, count) values ('$artist', '1')";
mysql_query($sql);
$sql="select * from artists where name='$artist'";
$result=mysql_query($sql);
$artinfo=mysql_fetch_array($result);
$artistid=$artinfo[id];
}
echo "song count $songcount";
if($songcount > 0){
$songid=$songinfo[id];
$songcounter=$songinfo[count]+1;
$sql="update songs set count=$songcounter where id=$songinfo[id] and artistid=$artinfo[id]";
mysql_query($sql);
} else {
$sql="insert into songs(name, count, artistid) values ('$title', '1', '$artinfo[id]')";
mysql_query($sql);
$sql="select * from songs where name='$title' and artistid=$artinfo[id]";
$result=mysql_query($sql);
$songinfo=mysql_fetch_array($result);
$songid=$songinfo[id];
}
echo "Curr album: $curralbum:";
mysql_query("insert into winamp(artist, title, date, time, track, songlength) values('$artistid', '$songid', now(), now(), '$track', '$length')");
