ty91M2qg

1$filename(sql)
2DROP TABLE IF EXISTS `meinealben`;
3CREATE TABLE `meinealben`
4(
5  `id` int(5) NOT NULL auto_increment,
6  `artist` varchar(255) NOT NULL default '''',
7  `title` varchar(255) NOT NULL default '''',
8  `album` varchar(255) NOT NULL default '''',
9  `track` varchar(255) NOT NULL default '''',
10  `genre` varchar(255) NOT NULL default '''',
11  `year` varchar(255) NOT NULL default '''',
12  `comment` varchar(255) NOT NULL default '''',
13  `duration` varchar(255) NOT NULL default '''',
14  `codec` varchar(255) NOT NULL default '''',
15  `bitrate` varchar(255) NOT NULL default '''',
16  `samplerate` varchar(255) NOT NULL default '''',
17  `vbr` varchar(255) NOT NULL default '''',
18  `tag` varchar(255) NOT NULL default '''',
19  `path` varchar(255) NOT NULL default '''',
20  `file_name` varchar(255) NOT NULL default '''',
21  `file_size` varchar(255) NOT NULL default '''',
22  `file_mod_date` varchar(255) NOT NULL default '''',
23  `crc` varchar(255) NOT NULL default '''',
24  PRIMARY KEY  (`id`)
25);
26
27$loop(%_path%)INSERT INTO `meinealben` ( `id`, `artist`, `title`, `album`, `track`, 
28`genre`, `year`, `comment`, `duration`, `codec`, `bitrate`, `samplerate`, 
29`vbr`, `tag`, `path`, `file_name`, `file_size`, `file_mod_date`, `crc`) 
30
31VALUES (%_counter%, ''$replace(%artist%,'',\'')'', ''$replace(%title%,'',\'')'', 
32''$replace(%album%,'',\'')'', ''%track%'', ''%genre%'',''%year%'', ''$replace(%comment%,'',\'')'', 
33''%_length_seconds%'', ''%_codec%'', ''%_bitrate%'', ''%_samplerate%'', ''%_vbr%'', 
34''%_tag%'', ''$replace($replace(%_folderpath%,\,/),'',\'')'', 
35''$replace(%_filename_ext%,'',\'')'', ''%_file_size_bytes%'', ''%_file_mod_date%'', ''%_crc%'');
36
37$loopend()