1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61
62. 62
63. 63
64. 64
65. 65
66. 66
67. 67
68. 68
69. 69
70. 70
71. 71
72. 72
73. 73

<?php
  $br="
";
  include "functions.php";
  mconnect();
  $result=mysql_query("TRUNCATE base");  
  $tags=file_get_contents("tag_cache");

  $tags=str_replace("'","\'",$tags);
  $tags=explode("songList begin",$tags);
  $j=0;
  for($i=1; $i<count($tags); $i++)
  {
    $tmp=explode("songList end",$tags[$i]);
    $tbase[$j++]=$tmp[0];
  }
  $j=0;
  for($i=0; $i<count($tbase); $i++)
  {
    $tmp=explode("key: ", $tbase[$i]);
    for($i2=1; $i2<count($tmp); $i2++)
	$element[$j++]=$tmp[$i2];
  }
  for($i=0; $i<count($element); $i++)
  {
    $tmp=explode($br."file: ",$element[$i]);
    $track[$i]['key']=$tmp[0];

    $tmp=explode($br."Time: ",$tmp[1]);
    $track[$i]['file']=$tmp[0];
   
    $tmp=explode($br."Artist: ",$tmp[1]);
    $track[$i]['Time']=$tmp[0];

    $tmp=explode($br."Title: ", $tmp[1]);
    $track[$i]['Artist']=$tmp[0];

    $tmp=explode($br."Album: ", $tmp[1]);
    $track[$i]['Title']=$tmp[0];

    $tmp=explode($br."Track: ", $tmp[1]);
    $track[$i]['Album']=$tmp[0];

    $tmp=explode($br."Date: ", $tmp[1]);
    $track[$i]['Track']=$tmp[0];

    $tmp=explode($br."Genre: ", $tmp[1]);
    $track[$i]['Date']=$tmp[0];

    $tmp=explode($br."mtime: ", $tmp[1]);
    $track[$i]['Genre']=$tmp[0];
    $track[$i]['mtime']=$tmp[1];
	$track[$i]['Size']=filesize(str_replace("\'","'", $track[$i]['file']));
  }
  for($i=0; $i<count($track); $i++)
  {
    //	echo $track[$i]['Artist']." -  ".$track[$i]['Album'].": ".$track[$i]['Title']."; " . round($track[$i]['Time']/60) . "m " .$track[$i]['Time']%60 . "s<hr>";
    $request="INSERT INTO base (file, Time, Artist, Title, Album, Track, Date, Genre, mtime, Size) VALUES ('".
$track[$i]['file']."', '"
.$track[$i]['Time']."', '"
.$track[$i]['Artist']."', '"
.$track[$i]['Title']."', '"
.$track[$i]['Album']."', '"
.$track[$i]['Track']."', '"
.$track[$i]['Date']."', '"
.$track[$i]['Genre']."', '"
.$track[$i]['mtime']."', '"
.$track[$i]['Size']."')";

  echo $request."<hr>";
  $result=mysql_query($request) or die(mysql_error().$i.";(");
  }
?>