Subversion Repositories mdb

Rev

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

Rev 14 Rev 18
Line 164... Line 164...
164 
		return FALSE;
 164 
		return FALSE;
165 
	}
 165 
	}
166 
 
 166 
 
167 
	deleteUser();
 167 
	deleteUser();
168 
	/* First count the future result set */
 168 
	/* First count the future result set */
169 
	sprintf (query, "select count(*) as cnt from musicdb where uname = \"%s\"", user);
 169 
	sprintf (query, "select count(*) as cnt from users where uname = \"%s\"", user);
170
170
171 
	if (sqlite3_prepare(db, query, -1, &res, NULL) != SQLITE_OK)
 171 
	if (sqlite3_prepare(db, query, -1, &res, NULL) != SQLITE_OK)
172 
	{
 172 
	{
173 
		syslog(LOG_DAEMON, "Error preparing SQL statement [%s]: %s", query, sqlite3_errmsg(db));
 173 
		syslog(LOG_DAEMON, "Error preparing SQL statement [%s]: %s", query, sqlite3_errmsg(db));
174 
		strcpy(query, "ERROR:USER:Error preparing a SQL statement;");
 174 
		strcpy(query, "ERROR:USER:Error preparing a SQL statement;");
175 
		write(s1, query, strlen(query));
 175 
		write(s1, query, strlen(query));
176 
		return FALSE;
 176 
		total = 0;
177 
	}
 177 
	}
178
- 
 
179 
	if (sqlite3_step(res) == SQLITE_ROW)
 178 
	else if (sqlite3_step(res) == SQLITE_ROW)
180 
		total = sqlite3_column_int(res, 0);
 179 
		total = sqlite3_column_int(res, 0);
181 
	else
 180 
	else
182 
		total = 0;
 181 
		total = 0;
183
182
184 
	sprintf(hv0, "USER:%s;TOTAL:%d;", user, total);
 183 
	sprintf(hv0, "USER:%s;TOTAL:%d;", user, total);