Today we introduce you Ticketmaster 1.7.1, we have added some nice features and did some critical fixes to this 2nd release of the Joomla 1.7 version. Installation will be done by the Joomla installer. During the previous installation, the component was not properly registred in the database. so we have to add the database changes ourself as Joomla cannot do this for you. It's pretty easy. For new installations, you don't have any problems. What have been fixed and what is the addon:

• Fixed the registrations problems when you have user registraion turned on.
  User get an email with activation code, it needs to be activated before they can proceed.
• Added a native captcha to the registration form.
• Fixed months display, changed dutch words into English.
• Fixed export problems, now everything will be exported. (including not paid orders)
• Fixed position of the registration button
• Added mailchimp integration for news letters management.
• Google info was not saved and PDF euro sign was not saved properly.

For those people who are upgrading from the 1.7.0 version you need to add some tables to the database. This is pretty easy to do.
Open your PHP MyAdmin and go to the button SQL, it's in the top menu in most cases.Then you have to know what your Joomla prefix is.
Then run the next queries:

ALTER TABLE `#__ticketmaster_config`
ADD `show_mailchimp_signup` TINYINT( 1 ) NOT NULL ,
ADD `mailchimp_api` VARCHAR( 50 ) NOT NULL ,
ADD `mailchimp_listid` VARCHAR( 50 ) NOT NULL,
ADD `activation_email` TINYINT (1) NOT NULL;

You need to fill those fields in the configuration of Ticketmaster afterwards. Create a new message that will be sent for the activation.
You can use the next parameters (replacers in this email) :

• %%NAME%%
• %%ACTIVATION_CODE%%
• %%EMAIL%%

Or just run this in your PHP MyAdmin.

INSERT INTO `iqftu_ticketmaster_emails` (`emailid`, `template_type`, `mailbody`, `secured`, `userid`, `approved`, `mailsubject`, `lastchange`, `description`, `from_email`, `from_name`, `receive_bcc`, `reply_to_email`, `reply_to_name`, `published`) VALUES
(NULL, 0, '<p>Please activate your account before you can proceed.<br />Activation code: %%ACTIVATION_CODE%% Enter this activation code at our checkout site and proceed with your order. </p>\r\n<p>%%NAME%% -- Naam</p>\r\n<p>%%EMAIL%% -- Email</p>', 0, 0, 0, 'Sitename - Please activate your account.', '2012-01-13 23:53:42', 'Customers will receive an email with activation code to confirm the email address.', ' This e-mail address is being protected from spambots. You need JavaScript enabled to view it ', 'RD-Media Webservices', 1, ' This e-mail address is being protected from spambots. You need JavaScript enabled to view it ', 'RD-Media Webservices', 1);