Description
【1/20】島テーマ #550
【1/20】島テーマ #550
#既存データの削除
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;
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;
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`;
#更新
#master_object _data.bonus_time
UPDATE master_object_data SET bonus_time = '1612537200' where object_no = 6188;
#master_object_data_lv.bonus_ratio
UPDATE master_object_data_lv set bonus_ratio = 3 where object_no = 6188;@wada
お手すきの際にレビューをお願いします。
@iwamoto
レビューしました。OKです。
| base | b8ea417a0c7a337d21489b7c5487419be043259b |
|---|---|
| head | 736ac34ccfc16df577b2ba40cc8694c91686b6e0 |
| base branch | jolly/jr-web:develop |
| head branch | jolly/jr-web:event_build_island_550 |
| status | file |
|---|---|
| modified | lib/SubFunc.inc |
| modified | lib/conf/class/BuildEventItemConfig.class.php |
| modified | lib/conf/define_y.inc |
| modified | public_html/template/Main.tpl |
| added | tool/event/test_build_event.php |