Archive / jolly / jr-rzst
Issue

覇戦の宝箱システム #2

wada opened this at 2020-08-31T20:03:24; closed

Description

opened by wada at 2020-08-31T20:03:24; updated 2026-02-03T14:27:25

【7/3】覇戦結果ページの改修
ac3db8f6b9d9b189b3900895efdcf30c5d6702eb
d9440c31512836ad02d3940952d85ae4615d5324
8b731a20fb394d93d03adde7823434fe131c5b6e
72d93c3e2824bb0c01c63e1cfa51beaa5ba486cf
270e6e4c0799049f887a3881ee2cc1c29c05742e
63cfc4c83b87305236ca4218d6051f3164d27016
3a0cac493a9e12db1ace1087d1491d38afeb834e
d5e66d4d56e33110a5ffea2bf53c7be259e3a868
3d770cdf57a0564d955950b068a5ca36b680289e
c6dbeb4086a41b6f5d85736392137a90789747ef
a98856a88be9be586d052b5deb90bcb8462b5b7b
ab8e3f9e7a454c968865028ed1e24ece2ee5a306
5e4696667ae6afc28ecadd69368429f7fa87a019
bdeb9a532d3020ac41594fdc64af4e7e453f772b
86d018e9b7fbdf0c0041b05fc1ae2e837b9b8048
d0c9787ff914ea01be43279b6a1142cb11959a93
6e32a3e5b155e13ba55c1d2f808cb66e3e628a41
e1a804b5b9f7b55137584c6a23d577d36122bd98
f6cdf5a6dfb497dd4e01a526fd065f0df94318f8
1bccb6a5a90e45c4834798627ab1fb541c53164e
fa5b11df56a9be8b75e6f540ee460b463e72b594
3c2ff34d19b8b28512d9c150f2fd5c0c82d39287
32bef827047272ea22e04aa36e3359e55775995c
a75fa987c04c52da7e4da92afb5cef67f59c1555
8ce2db53e306909e035bf444af3ac24667616614

Comment

#6733 by hisai at 2020-09-01T13:56:31; updated 2020-09-01T13:56:31

建材の個数を修正
80fb0b93b1551a0e9d98598873f5c9a1e4545d7d

Comment

#6751 by hisai at 2020-09-01T15:38:59; updated 2020-09-01T15:38:59

CREATE TABLE user_war_win_reward (
user_no bigint(20) NOT NULL,
reward_type tinyint(4) NOT NULL COMMENT '宝箱の種類',
star_need tinyint(4) NOT NULL,
star_stock tinyint(4) NOT NULL,
star_total int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE user_war_win_reward
ADD PRIMARY KEY (user_no) USING BTREE;

■星と宝箱ログ
CREATE TABLE log_war_win_reward (
id int(11) NOT NULL,
user_no bigint(20) NOT NULL,
type tinyint(4) NOT NULL COMMENT '11:宝箱取得、21:星ストック取得、22：星ストック消費',
count tinyint(4) NOT NULL,
after_count int(11) NOT NULL,
reg_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE log_war_win_reward
ADD PRIMARY KEY (id) USING BTREE,
ADD KEY type (type,reg_date),
ADD KEY user_no (user_no,reg_date);

ALTER TABLE log_war_win_reward
MODIFY id int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

Comment

#6752 by hisai at 2020-09-01T15:42:52; updated 2020-09-01T15:42:52

【5/19本番UP】覇戦リワードページ対応
CREATE TABLE log_teamwar_reward_gold (
user_no bigint(20) NOT NULL,
year_mon_day int(11) NOT NULL,
result_type int(11) NOT NULL,
team_no int(11) NOT NULL,
reg_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE log_teamwar_reward_gold
ADD PRIMARY KEY (user_no,year_mon_day,result_type),
ADD KEY year_mon_day (year_mon_day,team_no) USING BTREE;
COMMIT;

7be67910111016fa8a498e032704cb7ece0c46d2
5af941b323599721563e7c6dc946531264bfaa6f
4946cae45fe6f6dff55054e7c91cabca1fc3ba85
16594b2288c88792c43bdf873c7a7ce3984dd2d7
184c22480caa6588001728a1f2dea98ff7430a91
cc12c88c1f9d8155c1f1ad10070354b562159fc4
9113b51ee1a61fda9b1ff4ca477189f3db1f3b19
a003df19f807a601aedd7175858afc8919e11382
9e5b927e53a6f346bc305e1533453d50635df276
d814cf5b85999dcad5dc301b3f76a24c739a294a
e75b50a2a662cd06681101f9ce6d540b9219cb4c
5daa3d81039e98a02c279a154c8dcdb5aa8b94d4
a9af20e337ee67c76152da724167e6b014ad1abf
4b8a9a18329a7ee18e9cf02c36b9ea948afb8f2a
55f50954720184995c17065f9e6bc41e55c99579
9e2b097f869794e06f7e1b23fe551a27f1207a9c
f4da962f48ebd0f2476578e093b44709568f450c
1162f27aa13ab5d26d6b1c2bd68f8cf53e25cfba
eaa0ec1d18ecd9379be5aa89b3139f59a91e4fcc
83f3d03fa1e511057486d294d43b3849c17c95d6
8d8698b7bf84ac45e8b73032f5c7e104842997de
02401a3e516920100079930acb611dc6ffc60646
5da97033d2ff27b4909d72966441252aa92f73d2
227fc21ce05a3b31c17510bfc4bfbbbbe75999c7
4c0e9566b2cf59ffac70d144e8e02e98a460cebf
b64bd5aebb4d8ac7aee2c06e074a6fbddcdc6739
38eaaac6ac96b26602eac565d9fe15fcaf07ac8d
0a395be1440b6aa954254414c907f30ff6c64507
c83e2f41dca8df1682ebeef7bda0b2d56163931a
43b7fb456ddfd45af4f9e66edb56c9a3b8f5bf14
919073ccadfab901de63ee3d375358bc64c8301f
f5293ac3cafb07698275f07084b3dcf4e6642af1
9012f892a9b18ef5c3868942ff7c37822f96c5d5
4788d5237ba4204fe2df21eb82b387c88ad81f1c
5ed634c44b686c737d595ae82d91a87a423f6dab
a5ef104202dbfb2680e9ac4901124a0682b178bf
960a3bd0279fa2913717426f54aecb4a513800b3
f330831ddc4ec4f33b993bf78899aa4430eddf10
71a1e43901efa78063f8e6d13ef545e3101736e0
328d61dd133b4a6c1b94c227d520e26b646487c8
89eaeb8181645dbafb6846fdeac6615922cbfee9
886fdea0015524b8be799c6b4eb24b909e8e0c2b
d8cbf6004b222e1e00c320351f865210d9f91373
71da45d9b996448043bf0ab9a9ca49c3d3f523f2
04498b5522bf740004829438541ed6b794f3173b
262ca9f1d49b51e5331edee8d8f31d8bdf3eab34
80c81edfa589ad72a39ebe6b4cf1f74d15df634e
087b5ec8ab2a490c2f34a5c30416d1044b2126dd

Comment

#6753 by hisai at 2020-09-01T15:44:10; updated 2020-09-01T15:44:10

【7/9】覇戦宝箱の個数修正
80fb0b93b1551a0e9d98598873f5c9a1e4545d7d

Comment

#6754 by hisai at 2020-09-01T15:45:01; updated 2020-09-01T15:45:01

【7/28】【管理】ユーザー検索・覇戦宝箱
dd3edabfc94009ac362e9ed97019069cd12edc3e
b24799c777701045c677b1a95afde24d5cb9886b
10b86a362c86f1dd7a9a90e8384635a914cccbf0
914fce760413cdfabdb02b0692cc9fdf54a3e2bb
05b686e49d07492f865d642adfad36f24cae7a03
1f328282e1b7ad867ffe85749a843a2cba949156
7835eca8b12b5527ff14cf37b7e316d26dab8bb6
b9abe3c125c96a94c9eb52204cde0f6c845f0c77

Comment

#7201 by hisai at 2020-09-17T19:08:05; updated 2020-09-17T19:08:05

CREATE TABLE teamWar_userDetail (
user_no bigint(20) NOT NULL,
team_no int(11) NOT NULL,
year_mon_day int(11) NOT NULL,
user_pt int(11) NOT NULL,
pt_time int(11) NOT NULL,
sink_ship int(11) NOT NULL,
sink_time int(11) NOT NULL,
win int(11) NOT NULL,
max_win int(11) NOT NULL,
attack int(11) NOT NULL,
attack_time int(11) NOT NULL,
defense int(11) NOT NULL,
defense_time int(11) NOT NULL,
inspire int(11) NOT NULL,
inspire_time int(11) NOT NULL,
goal_flag int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE teamWar_userDetail
ADD PRIMARY KEY (user_no,team_no,year_mon_day),
ADD KEY team_no (team_no,year_mon_day,user_pt,pt_time);

CREATE TABLE teamWar_combat (
year_mon_day int(11) NOT NULL,
team_no1 int(11) NOT NULL,
team_no2 int(11) NOT NULL,
combat_no int(11) NOT NULL,
user_no1 bigint(20) NOT NULL,
card_no1_1 int(11) NOT NULL,
card_no1_2 int(11) NOT NULL,
card_no1_3 int(11) NOT NULL,
user_no2 bigint(20) NOT NULL,
card_no2_1 int(11) NOT NULL,
card_no2_2 int(11) NOT NULL,
card_no2_3 int(11) NOT NULL,
key char(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE teamWar_combat
ADD PRIMARY KEY (year_mon_day,team_no1,team_no2,combat_no);

Comment

#7202 by hisai at 2020-09-17T19:10:10; updated 2020-09-17T19:10:10

60ca2312c60fd7499c9a87937a3e163d62a866ba
1faf6686326924aff59440bcf7ed73ef1595db2e
710d8943b1e981659960889d32589faa4a1c1bee
d2ab567181e7b3eca091ae142f0ee59b96c9defb
7be6771835f1f04170900283e21c55bc722d645f
bbe1c7ddbaa52060d363290b610913d416400d2e
9f00ae208d525a0aee3b31a37e94af3f3857ad87
368cd6803add2db691fde2c3871f3097dc88adca

Comment

#7507 by hisai at 2020-10-02T12:22:16; updated 2020-10-02T12:22:16

【即日】直前の戦争結果の判定修正
570fa4ab9fbf7d6ce927071dfcb82febd481bda5

【すぐ】覇戦結果ページのバグ修正
feda4890ed79a23ef2b56c413d087534f65ca82b

wada close at 2020-10-02T16:18:49: Close