Lines Matching refs:pStmt
39 sqlite3_stmt *pStmt; in sqlite3UserAuthPrepare() local
50 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in sqlite3UserAuthPrepare()
54 sqlite3_finalize(pStmt); in sqlite3UserAuthPrepare()
55 pStmt = 0; in sqlite3UserAuthPrepare()
57 return pStmt; in sqlite3UserAuthPrepare()
89 sqlite3_stmt *pStmt; in userAuthCheckLogin() local
101 pStmt = sqlite3UserAuthPrepare(db, in userAuthCheckLogin()
104 if( pStmt==0 ) return SQLITE_NOMEM; in userAuthCheckLogin()
105 sqlite3_bind_blob(pStmt, 1, db->auth.zAuthPW, db->auth.nAuthPW,SQLITE_STATIC); in userAuthCheckLogin()
106 sqlite3_bind_text(pStmt, 2, db->auth.zAuthUser, -1, SQLITE_STATIC); in userAuthCheckLogin()
107 rc = sqlite3_step(pStmt); in userAuthCheckLogin()
108 if( rc==SQLITE_ROW && sqlite3_column_int(pStmt,0) ){ in userAuthCheckLogin()
109 *peAuth = sqlite3_column_int(pStmt, 1) + UAUTH_User; in userAuthCheckLogin()
113 return sqlite3_finalize(pStmt); in userAuthCheckLogin()
240 sqlite3_stmt *pStmt; in sqlite3_user_add() local
246 pStmt = sqlite3UserAuthPrepare(db, in sqlite3_user_add()
252 if( pStmt==0 ) return SQLITE_NOMEM; in sqlite3_user_add()
253 sqlite3_step(pStmt); in sqlite3_user_add()
254 rc = sqlite3_finalize(pStmt); in sqlite3_user_add()
257 pStmt = sqlite3UserAuthPrepare(db, in sqlite3_user_add()
261 if( pStmt==0 ) return SQLITE_NOMEM; in sqlite3_user_add()
262 sqlite3_bind_blob(pStmt, 1, aPW, nPW, SQLITE_STATIC); in sqlite3_user_add()
263 sqlite3_step(pStmt); in sqlite3_user_add()
264 rc = sqlite3_finalize(pStmt); in sqlite3_user_add()
287 sqlite3_stmt *pStmt; in sqlite3_user_change() local
309 pStmt = sqlite3UserAuthPrepare(db, in sqlite3_user_change()
312 if( pStmt==0 ){ in sqlite3_user_change()
315 sqlite3_bind_blob(pStmt, 1, aPW, nPW, SQLITE_STATIC); in sqlite3_user_change()
316 sqlite3_step(pStmt); in sqlite3_user_change()
317 rc = sqlite3_finalize(pStmt); in sqlite3_user_change()
335 sqlite3_stmt *pStmt; in sqlite3_user_delete() local
348 pStmt = sqlite3UserAuthPrepare(db, in sqlite3_user_delete()
350 if( pStmt==0 ) return SQLITE_NOMEM; in sqlite3_user_delete()
351 sqlite3_step(pStmt); in sqlite3_user_delete()
352 return sqlite3_finalize(pStmt); in sqlite3_user_delete()