【10/2】リリース手順書 #301

【9/24】新大陸イベント #243

• [x] 新大陸から追い出し

SELECT * FROM `user_mission` WHERE `stage_type` IN (10,11,12);
UPDATE `user_mission` SET `stage_click` = 0,`stage_type` = 1 WHERE `stage_type` IN (10,11,12);
SELECT * FROM `user_mission` WHERE `stage_type` IN (10,11,12);

• [x] 新大陸イベントの報酬配布

# 報酬
夕闇のアリス・ストレガ(card_no = 410)
# 報酬配布詳細
1~30位:3枚
31~100位:2枚
101~500位:1枚
501位~:参加賞(500ベル)
# 報酬配布実行
cd /jr-yamada/lib/exec/
vi tool_event_newisland_present.inc($debug_flgを0に)
ENVIRONMENT=production PF=yamada php ./tool_event_newisland_present.inc
# ポイント集計
ENVIRONMENT=production PF=yamada php ./tool_event_newisland_point.inc

【10/2】レイドイベント #267

• [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] logの移動

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

• [x] RaidBossの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

#本番
ssh jr-adm
deploy db

• [x] 本番環境更新

#本番環境に反映
ssh jr-adm
update web
deploy web

#バッチファイルの設定
crontab -e
#RaidMonsterEventAnalytics
10 10 * * * ENVIRONMENT=${JR_ENV} PF=yamada ${JR_DIR}/lib/exec/user_event_raid_analytics.sh

RaidBossのMaster更新-完了

logの移動 - 完了

新大陸から追い出し - 完了

DB初期化 -完了