Execute("SELECT configuration_group_id FROM ". TABLE_CONFIGURATION ." WHERE configuration_key = 'GOOGLE_ANALYTICS_VERSION' LIMIT 1;"); $config_group_id = $group_query->fields['configuration_group_id']; $db->Execute("UPDATE " . TABLE_CONFIGURATION . " SET configuration_value = '2.1.0' WHERE configuration_key = 'GOOGLE_ANALYTICS_VERSION' LIMIT 1;"); $db->Execute("INSERT INTO " . TABLE_CONFIGURATION . " (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Google Conversion Label', 'GOOGLE_CONVERSION_LABEL', 'purchase', 'Enter your Google Conversion Label (can be generated in Google Adwords or you can create a custom label for tracking elsewhere)', ".$config_group_id.", 12, NULL, now(), NULL, NULL) "); $messageStack->add('Upgraded Easy Google Analytics to v2.1.0', 'success');