private void requestsSeen() {
SQLiteConnection sql = new SQLiteConnection(this);
sql.executeQuery("UPDATE " + SQLiteConnection.TABLE_REQUESTS + " SET seen=1");
sql.close();
}
public boolean saveDataFromMyContact() {
// speichere Daten von der UI
try {
SQLiteConnection db_conn = new SQLiteConnection(this);
String[][] ui_data = getMyContactObjects();
if ((!myContactIsLoaded) || (ui_data == null)) {
db_conn.close();
return false;
}
Cursor data =
db_conn.query("SELECT entrynames_id,value FROM " + SQLiteConnection.TABLE_USER_DATA);
String[][] data_edit = new String[data.getCount()][];
for (int i = 0; i < data.getCount(); i++) {
data.moveToPosition(i);
data_edit[i] = new String[] {String.valueOf(data.getInt(0)), data.getString(1)};
}
if (!Functions.equalsArray(ui_data, data_edit)) {
// Mein Kontakt in lokale db schreiben
db_conn.executeQuery("DELETE FROM " + SQLiteConnection.TABLE_USER_DATA);
for (int i = 0; i < ui_data.length; i++) {
String[] str_tmp = ui_data[i];
ContentValues values = new ContentValues();
values.put("id", i);
values.put("entrynames_id", Integer.parseInt(str_tmp[0]));
values.put("value", str_tmp[1]);
db_conn.insert(SQLiteConnection.TABLE_USER_DATA, values);
}
db_conn.executeQuery(
"UPDATE " + SQLiteConnection.TABLE_USER + " SET change_date=CURRENT_TIMESTAMP");
String checksums = db_conn.getChecksums();
db_conn.setChecksums(
checksums.replace(checksums.substring(32, 64), "00000000000000000000000000000000"));
try {
if (thread_sync != null) thread_sync.interrupt();
} finally {
}
thread_sync =
new Thread(
new Runnable() {
public void run() {
new UserFunctions(getApplicationContext()).sync();
}
});
thread_sync.start();
}
data.close();
db_conn.close();
} catch (Exception ex) {
ex.printStackTrace();
return false;
}
return true;
}
