【8/11】覇戦 予選 #86

仕様
https://docs.google.com/spreadsheets/d/18Jjth65eydWz07EKbkPi1GJt-1stPBgaAwgbGOViNFU/edit#gid=692811196

集計

• [x] team_battle_ranking_event.inc
• [x] event_war_spirit_point_present_1.inc

本戦報酬の再表示

覇気の獲得数を間違えていたため修正
負けた時のptが10ptずつ低かった
teamWar_info.jackpot, team_data.spirit_ptをそれぞれ10加算

# jackpot:10を+10
SELECT * FROM teamWar_info WHERE jackpot = 10 AND year_mon_day = 2020081121;
UPDATE teamWar_info SET jackpot = 20 WHERE jackpot = 10 AND year_mon_day = 2020081121;

# jackpot:0を+10
SELECT * FROM teamWar_info WHERE jackpot = 0 AND year_mon_day = 2020081121;
UPDATE teamWar_info SET jackpot = 10 WHERE jackpot = 0 AND year_mon_day = 2020081121;

# team_data.spirit_pt:0を+10
SELECT * FROM team_data WHERE war_id > 0 AND spirit_pt = 10;
UPDATE team_data SET spirit_pt = 20 WHERE war_id > 0 AND spirit_pt = 10;

# team_data.spirit_pt:0を+10
SELECT * FROM team_data WHERE war_id > 0 AND spirit_pt = 0 AND team_no IN(SELECT team_no FROM jrye_teamWar.teamWar_info WHERE jackpot = 10 AND year_mon_day = 2020081121)
UPDATE team_data SET spirit_pt = 10 WHERE war_id > 0 AND spirit_pt = 0 AND team_no IN(SELECT team_no FROM jrye_teamWar.teamWar_info WHERE jackpot = 10 AND year_mon_day = 2020081121);

@wada
問題ないと思いますが、
event_war_spirit_point_present_1 の debug_flg = 0 になってましたのでご注意を…

他pr送られていた分確認できました、OKです

@iwamoto
ありがとうございます。
debug_flg=0は問題ありますね。直します。