blob: 7ef4e17e7da1592f4b757025d7171c0fbbffb43d (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
<?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);
}
?>
|
