56,679
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
DROP PROCEDURE IF EXISTS `db_sgws_1001000`.`N_ActivityGetRankingList`$$
CREATE DEFINER=`dbwrit`@`%` PROCEDURE `N_ActivityGetRankingList`(_serverid int, _aid int, _roleid int(10) UNSIGNED, _getlist int, out _ranking int)
SQL SECURITY INVOKER
BEGIN
select ranking into _ranking from activityranking where aid=_aid and roleid=_roleid;
if _getlist=1 then
select a.rolename,ifnull(r.school,'0') from activityranking a left join rolerankinginfo r on a.roleid=r.roleid where aid=_aid order by ranking asc;
end if;
if _ranking is null then
set _ranking=0;
end if;
END$$
DELIMITER ;