Subversion Repositories mdb

Rev

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

Rev 14 Rev 18
Line 652... Line 652...
652 
		strcpy(query, "ERROR:USER:Error opening database;");
 652 
		strcpy(query, "ERROR:USER:Error opening database;");
653 
		write (s1, query, strlen(query));
 653 
		write (s1, query, strlen(query));
654 
		return FALSE;
 654 
		return FALSE;
655 
	}
 655 
	}
656 
 
 656 
 
657 
	sprintf(query, "select count(*) from musicdb as a where (select musicid from playlist as b where a.id = b.musicid and b.userid = %d)", act->id);
 657 
	sprintf(query, "select count(*) from musicdb as a where (select musicid from playlists as b where a.id = b.musicid and b.userid = %d)", act->id);
658
658
659 
	if (sqlite3_prepare(db, query, -1, &res, NULL) != SQLITE_OK)
 659 
	if (sqlite3_prepare(db, query, -1, &res, NULL) != SQLITE_OK)
660 
	{
 660 
	{
661 
		syslog(LOG_DAEMON, "Error preparing SQL statement [%s]: %s", query, sqlite3_errmsg(db));
 661 
		syslog(LOG_DAEMON, "Error preparing SQL statement [%s]: %s", query, sqlite3_errmsg(db));
662 
		strcpy(hv0, "ERROR:USER:Error preparing a SQL statement;");
 662 
		strcpy(hv0, "ERROR:USER:Error preparing a SQL statement;");