Hello! Here is the store procedure:
DELIMITER $$ > > >> DROP PROCEDURE IF EXISTS `hcn`.`distribuirMedicos`$$ > > CREATE definer=`ro...@`localhost` PROCEDURE `distribuirMedicos`() > > BEGIN > > DECLARE medico int; > > >> set @medico=(select distinct(sg.group_id) from sf_guard_user_group sg >> inner join sf_guard_user s on sg.user_id=s.id where sg.group_id=1 and >> s.id = (select MAX(s.id) from sf_guard_user)); > > IF (@medico=1) then > > >> INSERT INTO credibilidad_medico (medico, credibilidad) > > SELECT MAX(s.id), 0 FROM sf_guard_user s > > INNER JOIN sf_guard_user_group sg ON s.id = sg.user_id WHERE sg.group_id >> =1; > > >> >> INSERT INTO ranking_medicos (medico, ranking) > > SELECT MAX(s.id), 0 FROM sf_guard_user s > > INNER JOIN sf_guard_user_group sg ON s.id = sg.user_id WHERE sg.group_id >> =1; > > >> end if; > > >> END$$ > > >> DELIMITER ; > > > -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
