Subversion Repositories mdb

Rev

Rev 10 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 10 Rev 14
Line 35... Line 35...
35 
int searchTerm(int s1, const char *type, const char *term, int start, int length)
 35 
int searchTerm(int s1, const char *type, const char *term, int start, int length)
36 
{
 36 
{
37 
	char query[1024], hv0[128], buffer[8192];
 37 
	char query[1024], hv0[128], buffer[8192];
38 
	char fname[256];
 38 
	char fname[256];
39 
	sqlite3 *db;
 39 
	sqlite3 *db;
40 
	char *zErrMsg = 0;
 - 
 
41 
	int rc, id, total, pos;
 40 
	int rc, id, total, pos;
42 
	sqlite3_stmt *res;
 41 
	sqlite3_stmt *res;
43 
	char id3_title[256], id3_artist[256], id3_album[256], id3_genre[256];
 42 
	char id3_title[256], id3_artist[256], id3_album[256], id3_genre[256];
44 
	char *title, *artist, *album, *t;
 43 
	char *title, *artist, *album;
45 
 
 44 
 
46 
	strcpy(fname, configs.home);
 45 
	strcpy(fname, configs.home);
47 
	strcat(fname, MUSICDB);
 46 
	strcat(fname, MUSICDB);
48
47
49 
	rc = sqlite3_open(fname, &db);
 48 
	rc = sqlite3_open(fname, &db);