Subversion Repositories mdb

Rev

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

Rev 29 Rev 31
Line 571... Line 571...
571 
		strcpy(hv0, "ERROR:PLAYLIST:No user selected;");
 571 
		strcpy(hv0, "ERROR:PLAYLIST:No user selected;");
572 
		write(s1, hv0, strlen(hv0));
 572 
		write(s1, hv0, strlen(hv0));
573 
		return FALSE;
 573 
		return FALSE;
574 
	}
 574 
	}
575 
 
 575 
 
- 
 
 576 
	strcpy(hv0, "PAGE:PLAYLIST;");
- 
 
 577 
	write(s1, hv0, strlen(hv0));
- 
 
 578 
 
576 
	act = userchain;
 579 
	act = userchain;
577 
	pos = line = 1;
 580 
	pos = line = 1;
578 
 
 581 
 
579 
	while (act)
 582 
	while (act)
580 
	{
 583 
	{
Line 662... Line 665...
662 
		strcpy(query, "ERROR:USER:Error opening database;");
 665 
		strcpy(query, "ERROR:USER:Error opening database;");
663 
		write (s1, query, strlen(query));
 666 
		write (s1, query, strlen(query));
664 
		return FALSE;
 667 
		return FALSE;
665 
	}
 668 
	}
666 
 
 669 
 
- 
 
 670 
	strcpy(hv0, "PAGE:PLAYLIST;");
- 
 
 671 
	write(s1, hv0, strlen(hv0));
- 
 
 672 
 
667 
	sprintf(query, "select count(*) from \"main\".\"playlists\" where userid = %d", act->id);
 673 
	sprintf(query, "select count(*) from \"main\".\"playlists\" where userid = %d", act->id);
668 
 
 674 
 
669 
	if (sqlite3_prepare(db, query, -1, &res, NULL) != SQLITE_OK)
 675 
	if (sqlite3_prepare(db, query, -1, &res, NULL) != SQLITE_OK)
670 
	{
 676 
	{
671 
		syslog(LOG_DAEMON, "Error preparing SQL statement [%s]: %s", query, sqlite3_errmsg(db));
 677 
		syslog(LOG_DAEMON, "Error preparing SQL statement [%s]: %s", query, sqlite3_errmsg(db));