+static gboolean
+query_read_events (RTComEl *el, const gchar *service, gint *events, gint *conversations)
+{
+ sqlite3 *db;
+ sqlite3_stmt *stmt;
+ int ret;
+ gboolean result = TRUE;
+
+ g_object_get (el, "db", &db, NULL);
+
+ if (sqlite3_prepare_v2 (db,
+ "SELECT SUM(total_events), COUNT(group_uid) FROM GroupCache, Services "
+ "WHERE GroupCache.service_id=Services.id AND Services.name=?;",
+ -1,
+ &stmt,
+ NULL) != SQLITE_OK) {
+ g_error ("%s: can't compile SQL", G_STRFUNC);
+ return FALSE;
+ }
+ if (sqlite3_bind_text (stmt, 1, service, -1, SQLITE_STATIC) != SQLITE_OK) {
+ g_error ("Failed to bind %s to SQL stmt", service);
+ result = FALSE;
+ goto DONE;
+ }
+
+ while (SQLITE_BUSY == (ret = sqlite3_step (stmt)));
+
+ if (ret == SQLITE_ROW) {
+ *events = sqlite3_column_int (stmt, 0);
+ *conversations = sqlite3_column_int (stmt, 1);
+ }
+ else {
+ g_error ("%s: error while executing SQL", G_STRFUNC);
+ result = FALSE;
+ goto DONE;
+ }
+
+ DONE:
+ sqlite3_finalize (stmt);
+
+ return result;
+}
+
+static void
+am_ready (OssoABookAccountManager *manager,
+ const GError *error,
+ gpointer user_data)
+{
+ ELHomeApplet *self = EL_HOME_APPLET (user_data);
+ ELHomeAppletPrivate *priv = self->priv;
+
+ if (!error &&
+ priv->local_id &&
+ !GTK_WIDGET_VISIBLE (priv->icon)) {
+ McAccount *account;
+
+ account = osso_abook_account_manager_lookup_by_name (NULL,
+ priv->local_id);
+ if (account) {
+ McProfile *profile = mc_profile_lookup (mc_account_compat_get_profile (account));
+ const gchar *icon_name = mc_profile_get_icon_name (profile);
+ if (icon_name) {
+ gtk_image_set_from_icon_name (GTK_IMAGE (priv->icon),
+ icon_name,
+ HILDON_ICON_SIZE_XSMALL);
+ gtk_widget_show (priv->icon);
+ }
+ }
+ }
+}
+