BEGIN
set @uid = ( select id from tbl_member where card_id=new.card_id );
if @uid>0 then
set @school = (select school from tbl_member where id=@uid );
insert into tbl_rank_total_score (game_id,uid,school,game_scores,card_id) values ( new.game_id,@uid,@school,new.game_score,new.card_id);
else
set @newuid = (select uid from tbl_card_repair where card_id=new.card_id);
set @school = (select school from tbl_member where id=@newuid );
insert into tbl_rank_total_score (game_id,uid,school,game_scores,card_id) values ( new.game_id,@newuid,@school,new.game_score,new.card_id);
end if;
END
