Example:
Code: Select all
...
$query->update('#__users AS u');
$query->join('LEFT', '`#__temp_users_check` AS fmt ON u.username = fmt.name');
$query->join('LEFT', '`#__tracker_users_level` AS ul ON ul.id = fmt.ugroup');
$query->set('u.id_level = fmt.ugroup');
$query->set('u.wait_time = ul.wait_time');
$query->where('u.id IN ( '.$uids.' )');
...
Code: Select all
UPDATE #__users AS u LEFT JOIN #__temp_users_check AS fmt ON u.username = fmt.name LEFT JOIN #__tracker_users_level AS ul ON ul.id = fmt.ugroup SET u.id_level = fmt.ugroup , u.wait_time = ul.wait_time WHERE u.id IN ( 3,4,6,8 )
Code: Select all
UPDATE #__users AS u SET u.id_level = fmt.ugroup , u.wait_time = ul.wait_time WHERE u.id IN ( 3,4,6,8 )
Note: Just opened a tracker issue.