<?php
require_once("authenticate.php");
if (mysql_connect(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD) === false)
	die(mysql_error());
if (mysql_select_db(DATABASE_NAME) === false)
	die(mysql_error());
function nullString($string)
{
	if($string == "")
	{
		return "NULL";
	}
	return "'".mysql_real_escape_string($string)."'";
}
function nullInt($int)
{
	if($int <= 0)
	{
		return "NULL";
	}
	return $int;
}
function sqlBool($bool)
{
	return $bool ? "1" : "0";
}
function getPrettyFilename($row)
{
	$filename = "";
	if(strlen($row["artist"]) > 0)
	{
		$filename .= $row["artist"];
	}
	else
	{
		$filename .= "(No Artist)";
	}
	if(strlen($row["album"]) > 0)
	{
		$filename .= " - ".$row["album"];
	}
	if((strlen($row["track"]) > 0 && intval($row["track"]) > 0) || strlen($row["title"]) > 0)
	{
		$filename .= " - ";
	}
	if(strlen($row["track"]) > 0 && intval($row["track"]) > 0)
	{
		if(intval($row["track"]) < 10)
		{
			$filename .= "0";
		}
		$filename .= $row["track"];
	}
	if(strlen($row["track"]) > 0 && intval($row["track"]) > 0 && strlen($row["title"]) > 0)
	{
		$filename .= " ";
	}
	if(strlen($row["title"]) > 0)
	{
		$filename .= $row["title"];
	}
	else
	{
		$filename .= " (No Title)";
	}
	$filename .= ".".$row["format"];
	return str_replace("/", "_", $filename);
}
?>