Release:LoveMachine v1.12

Release v1.12
Admin v213 2011-04-08, Login v116 - 2010-12-08, Tools v67 - 2011-03-31, Trial v71 - 2011-04-14, Sales v64 - 2011-04-14, Contrib v34 - 2010-12-07, Review v410 - 2011-04-14, Love v833 - 2011-04-13,

Admin: v212: #13691 - admin passing 'Loading...' from broken cache

Trial: v71: #13299 - add 'Name' filter to signup form

Sales: v64: Store tenant database name so reports don't have to guess

Review: v410: sync from deployed changes, add support for template to specify which mail queue to use

Love: v829: #13377 - add LinkedIn Oauth to settings v830: #13377 - add missing logo v831: #13492 - Improve session checks and add more input filtering v832: #13658 - use LinkedIn OAuth connector to post weekly stats updates v833: #13800 - add revoke option to LinkedIn settings page option

Schema Changes: love_users: alter table love_users add column `access_token` varchar(100) default NULL; alter table love_users add column `access_token_secret` varchar(100) default NULL; alter table love_users add column `request_token` varchar(100) default NULL; alter table love_users add column `request_token_secret` varchar(100) default NULL; alter table love_users add column `linkedin_share` tinyint(1) NOT NULL default '0';

redeem: -- -- Temporary table structure for view `redeem` --

DROP TABLE IF EXISTS `redeem`; /*!50001 DROP VIEW IF EXISTS `redeem`*/; /*!50001 CREATE TABLE `redeem` ( `id` int(11),  `title` text,  `start_date` timestamp,  `end_date` timestamp,  `budget` double,  `budget_validated` char(1),  `paid_amount` double,  `sent_by_receiver` timestamp,  `periodStatus` tinyint(1),  `manager` varchar(40),  `managerUsername` varchar(255),  `owner` varchar(40),  `ownerUsername` varchar(255),  `idowner` int(11),  `rewarded_percentage` double,  `paid` tinyint(1) ) */; -- -- Final view structure for view `redeem` --

/*!50001 DROP TABLE IF EXISTS `redeem`*/; /*!50001 DROP VIEW IF EXISTS `redeem`*/; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50001 VIEW `redeem` AS select `review_periods`.`id` AS `id`,`review_periods`.`title` AS `title`,`review_periods`.`start_date` AS `start_date`,`review_periods`.`end_date` AS `end_date`,`review_periods`.`budget` AS `budget`,`review_periods`.`budget_validated` AS `budget_validated`,`review_rewarder_distribution`.`paid_amount` AS `paid_amount`,`review_rewarder_distribution`.`sent_by_receiver` AS `sent_by_receiver`,`review_periods`.`status` AS `periodStatus`,`um`.`nickname` AS `manager`,`um`.`username` AS `managerUsername`,`uo`.`nickname` AS `owner`,`uo`.`username` AS `ownerUsername`,`uo`.`id` AS `idowner`,`review_rewarder_distribution`.`rewarded_percentage` AS `rewarded_percentage`,`review_rewarder_distribution`.`paid` AS `paid` from ((((`review_periods` left join `review_user_reviews` on((`review_user_reviews`.`period_id` = `review_periods`.`id`))) left join `review_rewarder_distribution` on((`review_rewarder_distribution`.`period_id` = `review_periods`.`id`))) join `love_users` `um` on((`review_rewarder_distribution`.`giver_id` = `um`.`id`))) join `love_users` `uo` on((`review_rewarder_distribution`.`receiver_id` = `uo`.`id`))) where (`review_periods`.`typeRC` = _latin1'C') */;