オリジナル海賊旗機能 #1

693f81c3c0f36fc633fe9d17a655bdb096e369e1
5bd36e71a92120ec4f3a0a218c5aab4b8803e43c
95d1f08dd6e83abfdbdd790ac650e5735d5ce680
678d978a8f719db4e5096bbd921f3e36c9094d66
4c3889088e119a93866159d3a85dc5ac02510367
d337e88d3945c1bc986d6b967ab713ad8c546a15
c90f40d10202e537431c3419b8e25fcf0608fe4b
f30eb998ba87b221dbc278ac516365a0aa59b7dd
4f0f9203a8625cce8bb83514a3e7179d962d1946
90289d3b3990b696f1620d6da56791553409c396
afa16d91e5e4d1b3734d5d72808311061f614f03
935efc47bff4b0283026bdac7c240f3955b28bdd
e47de89b8244f9b817353c421b0c097c3b9e9ea9
167ac335f46439de5c20a904db8380f7016cf7f7
9deffbabce7e4aadb44cfa4b596f304de3647b83
c298c04e5b396c95ce000e5da85d8f4dfe0e7026
f7569487413818c32d9ac75c177ae98f6719ce5e
18ed659003be82bd7f3c70faf4cf3a0b6f1291df
bc33e118a96dc1c1fdbce0448ba330e4d96a5f2e
dfc79926e8fe10c899ca5cb3214636e69c79b368
bb22d1ef532439171d1df9840595781965317db5
ca4bdbc041505850978cdb7b11d423dac975bc06
abca11fe512ba1396b94a8a6488a905b35b6b79b
9d57794d77228d122452df12529ecb3e4870e520
63a175caef796ae24c96bd8db94c5cd94965f119
44e66bfa668ecc129ca5222ec37984338fbacf25
a68e868cdfc9e996cb3558b4753565d722a04792
14b58c947d5fa65ae9be327c258f8ed0e19fb6a9
6a9746a3f65afb1b795ebd099ed81dde66492457
a387d3e6781d56bcb069e5d628b31d15279bab02
7a341b372cac1e34ded1d417c12e9dac64431a97
0cbb0ba04b3c77d308a47a774ba79cb4935c0b10
4e21a15d79fc1c9a04e40da76cf65718e1fb16ec
ad030826fba8a35c8df5aeda2a8bb428f8cc2b41
2a34822ab0289411c683a9921f553b12b2f1e430
95b9fb123d080eb98fb70b7e786b0cf04f1b51c7
11a025c310a1e915bdf499892c1dff843e12cfe8
9b5d8e8ea26e794d092804b57cec1e0e53ef7540
ec7622b4b7c866f152f03688adde5de7530d633f
5d3d7dac737bd1da006f2d2cdb112b7db2244a6e
cd30e366af63ae9bf24f31279a682a2f0093dcaf

多いね

■マスターデータ
CREATE TABLE master_pirate_flag (
img_type tinyint(4) NOT NULL,
img_no int(11) NOT NULL,
attribute tinyint(4) NOT NULL COMMENT '属性'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='海賊旗マスター';
ALTER TABLE master_pirate_flag
ADD PRIMARY KEY (img_type,img_no);

■チームデータ
CREATE TABLE team_pirate_flag (
team_no int(11) NOT NULL,
json char(255) NOT NULL COMMENT '画像の組み合わせ',
reg_date datetime NOT NULL COMMENT '設定時間'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='海賊旗の設定';
ALTER TABLE team_pirate_flag
ADD PRIMARY KEY (team_no);

■ログ
CREATE TABLE log_team_pirate_flag (
id int(11) NOT NULL,
team_no int(11) NOT NULL COMMENT 'チームNo',
set_user_no bigint(20) NOT NULL COMMENT '設定したユーザーNo',
json_before char(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '画像の組み合わせ',
json_after char(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '画像の組み合わせ',
reg_date datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='海賊旗の設定ログ';

ALTER TABLE log_team_pirate_flag
ADD PRIMARY KEY (id),
ADD KEY reg_date (reg_date,team_no);

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

【5/14】海賊旗の表示置き換え対応

38627f900c8b6b3a097302169ad06f4edc4d33ff
220c352fd7be8fa9d2bcbb63c5835df4c8f883cb
2b86e4f065bfc1d325c86eaf354dd025cec64f73
95849d68d9dc364257eb66a7bba178cc5a560a76

【8/14】トップページに海賊旗を表示する
a78bbf676327578566b14f59660af8ad8efebd40
1c363d6474278465c38f0831633a999f211df890

【8/7】メンバー募集掲示板に海賊旗の表示
52f5e748a57d5d5e5a728d01cb3f8edece73e8b6
db9971f303546e066eb6f8ea7014de252b1530b0
e7255286bd78a8e687e8970def96080619486258
52d44ea9fa3a140ff3134c0238ae7f417793cf66
195d04ffa8b4ddda651d0f5e92d8b57deee9761d
f24710358a77804aedaac93024ae415a8e5a52f6

【6/25】海戦の記憶 海賊旗に対応
dbf019e4bd7c776a8b06adc84012a6eac65d5b80

【画像】海賊旗と海賊団ページ
af39dc78a0887fa6bda74adb7e771b8bb4568e95
c4d75e63cf9bca85fd91a2a41b1a4756c5937271
1106508fa658976e62092759b6319a1f43808e7e

【画像】海賊旗の実装予告
296706c79c5ab435761ec2fa71d78c93dc129847

【画像】6/17海賊旗が作れるように 告知の画像です
0860788c12dd089bb76efb64f5a2e6a6c3767aa7