【10/20】リリース手順書(レイド&島建築) #358

天下無双イベントの報酬配布

• [x] 報酬配布

# 報酬配布
（実行前に$debug_flgを0に設定）
cd /jr-yamada/lib/exec/
vi tool_event_battle_present.inc
ENVIRONMENT=production PF=yamada php ./tool_event_battle_present.inc

リリース作業(レイド)

• [x] logの移動

#log移動
cd jr-admin
git pull
cd lib/exec/
vi tool_delete_raid_log.inc (event_no = 6 へ変更)
ENVIRONMENT=production PF=yamada php tool_delete_raid_log.inc

• [x] DBの初期化

#更新
UPDATE `user_mission` SET `raid_point`=0,`raid_point2`=0,`total_raid_point`=0,`m_event_limit`=0;

UPDATE `team_data` SET `raid_stamina`=0,`raid_monster`=0,`raid_monster_vs`=0,`raid_lv`=0,`raid_count`=0,`total_raid_count`=0,`event_raid_count`=0,`war_bonus_time`=0,`event_prize`=0,`raid_vs_end_time`=0;

#確認用
SELECT `user_no`,`raid_point`,`raid_point2`,`total_raid_point`,`m_event_limit` FROM `user_mission` ORDER BY `m_event_limit` DESC

SELECT `raid_stamina`,`raid_monster`,`raid_monster_vs`,`raid_lv`,`raid_count`,`total_raid_count`,`event_raid_count`,`war_bonus_time`,`event_prize`,`raid_vs_end_time` FROM `team_data` WHERE del_flg=0 ORDER BY `raid_stamina` DESC

• [x] RaidBossData更新

Master更新
#開発
ssh jr-dev
cd jrye-db/bin
php mysql2csv.php db名 table名
php mysql2csv.php jrye master_raid_monster_data

php csv2xls.php csv名
php csv2xls.php ../csv/master_raid_monster_data.csv
- master_raid_monster_data
- master_raid_monster_data_lvtype_defense_set
- master_raid_monster_data_skill
- master_raid_monster_data_skill_set

git add .
git commit -m ""

#local環境(jrey-db develop)にて
git pull
git checkout master
git merge develop
git push 

#本番
ssh jr-adm
deploy db

リリース作業(建築島)

• [x] DBの初期化

#DBの初期化
1.`user_build_stack`
2.`user_object`
3.`user_build_event_bonus`
4.`user_build_event_bonus_daily`
5.`log_build_event_bonus_time`
6.`log_build_event_bonus_time_main`
7.`log_build_event_bonus_time_use`
1 & 2
 初期化(前回のイベント建物だけ消す)
 - DELETE FROM `user_build_stack` WHERE `build_x` = 99 AND `build_y` = 99
 - DELETE FROM `user_object` WHERE `build_x` =99 AND `build_y` =99

 確認
 - SELECT * FROM `user_build_stack` WHERE `build_x` = 99 AND `build_y` = 99
 - SELECT * FROM `user_object` WHERE `build_x` =99 AND `build_y` =99
3 ~ 7
 念のため、TRUNCATE前にバックアップを取得しておく
  TRUNCATE TABLE `user_build_event_bonus`
  TRUNCATE TABLE `user_build_event_bonus_daily`
  TRUNCATE TABLE `log_build_event_bonus_time`
  TRUNCATE TABLE `log_build_event_bonus_time_main`
  TRUNCATE TABLE `log_build_event_bonus_time_use`
  TRUNCATE TABLE `log_user_build_bonus_ranking`

• [x] 新規SP建物追加

#SP建物 INSERT
SP効果期限 	2020/11/07 0:00:00(1604674800)
master_object_data
master_object_data_detail
master_object_data_lv

ヤマダ運動会報酬配布

#配布対象ユーザの登録
insert user_yamada_campaign_reward

#報酬配布
ssh jr-adm
cd jr-web/lib/exec
#dry_run
ENVIRONMENT=production PF=yamada DRY_RUN=1 php tool_send_yamada_rewards.php

ENVIRONMENT=production PF=yamada DRY_RUN=0 php tool_send_yamada_rewards.php

#配布ユーザ
SELECT * FROM user_yamada_campaign_reward WHERE reward_id >= 22 AND receive_flg = 1;