SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra,
IF(rate.count IS NULL, 0, rate.count) AS thread_rate_count, IF(rate.sum IS NULL, 0, rate.sum) AS thread_rate_sum, IF(rate.avg IS NULL, 0, rate.avg) AS thread_rate_avg
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN ns_threadrating_rate AS rate ON (rate.thread_id = thread.thread_id)
WHERE thread.thread_id = ?
Params: 22471
Run Time: 0.000865
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | rate | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 45
Run Time: 0.000418
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT post.*
,
bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 20)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 22471
Run Time: 0.004250
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 20 | Using index condition; Using where; Using filesort |
SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,user_nextstagerussia.post.post_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | user_nextstagerussia.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | user_nextstagerussia.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | user_nextstagerussia.post.user_id | 1 | |
SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,user_nextstagerussia.post.user_id | 1 | Using where |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | user_nextstagerussia.post.user_id,func | 1 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 22471
Run Time: 0.000363
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XenForo_ControllerPublic_Thread, Index, valid, thread_id=22471, 1716165181,
Run Time: 0.000341
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644292, a:2:{i:0;s:29:"Зельда Басара :)
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[media=youtube]";i:1;s:8:"[/media]";}s:8:"children";a:1:{i:0;s:11:"BtelgRzc3IU";}}}, 1701116101, 1716165181
Run Time: 0.006034
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: signature, 4, a:2:{i:0;s:58:"vova: Versatile Online Violence Android
SW 6368 9221 0229
";i:1;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:45:"https://card.psnprofiles.com/1/Wiizardwii.png";}}}, 1701116101, 1716165181
Run Time: 0.000851
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644297, a:1:{i:0;s:27:"грёбанный стыд";}, 1701116101, 1716165181
Run Time: 0.000271
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: signature, 45, a:1:{i:0;s:35:"Wii|Wii U|NSW
FC: SW-2066-2225-7236";}, 1701116101, 1716165181
Run Time: 0.000262
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644300, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:32:"Mustik, post: 644297, member: 45";s:8:"original";a:2:{i:0;s:42:"[quote="Mustik, post: 644297, member: 45"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:27:"грёбанный стыд";}}i:1;s:290:"
А мне понравилось. В Японии жанр популярный, почему бы не сделать. Думаю Нин должна всех переплюнуть и показать как надо. А то в жанре образовался некий застой.";}, 1701116101, 1716165181
Run Time: 0.000283
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644301, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:32:"Mustik, post: 644297, member: 45";s:8:"original";a:2:{i:0;s:42:"[quote="Mustik, post: 644297, member: 45"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:27:"грёбанный стыд";}}i:1;s:64:"
А что, династи вариорс по мотивам :)";}, 1701116101, 1716165181
Run Time: 0.000443
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644302, a:1:{i:0;s:199:"графон позапршлого поколения + 100500-ая версия династивариорс, кому это надо? В европе продадут 50 тыщ? напаркуа?";}, 1701116101, 1716165181
Run Time: 0.000613
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644303, a:1:{i:0;s:71:"Бедные нинтенд(о...вцы), или как вас там=)";}, 1701116101, 1716165181
Run Time: 0.000272
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: signature, 7071, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:32:"https://psnprofiles.com/YOURASHA";s:8:"original";a:2:{i:0;s:38:"[URL=https://psnprofiles.com/YOURASHA]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:43:"https://card.psnprofiles.com/2/YOURASHA.png";}}}}}, 1701116101, 1716165181
Run Time: 0.000247
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644307, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:32:"Mustik, post: 644302, member: 45";s:8:"original";a:2:{i:0;s:42:"[quote="Mustik, post: 644302, member: 45"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:43:"В европе продадут 50 тыщ?";}}i:1;s:283:"
Думаю такие продажи отобьют бюджет игры :) Впрочем узнаваемый перс и вселенная могут сделать своё дело.
Осталось дождаться Гаунтлет по мотивам Метроида :)";}, 1701116101, 1716165181
Run Time: 0.000259
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644312, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"vova, post: 644307, member: 4";s:8:"original";a:2:{i:0;s:39:"[quote="vova, post: 644307, member: 4"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:281:"Думаю такие продажи отобьют бюджет игры :) Впрочем узнаваемый перс и вселенная могут сделать своё дело.
Осталось дождаться Гаунтлет по мотивам Метроида :)";}}i:1;s:192:"
потом отсосин будет с Линком в главных ролях, начнут пихать своих персов куда ни попадя
плохая тенденция";}, 1701116101, 1716165181
Run Time: 0.000452
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644321, a:1:{i:0;s:71:"Это поколение нужно заполнять играми :)";}, 1701116101, 1716165181
Run Time: 0.000605
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 644327, a:1:{i:0;s:337:"На Вие была временная эсклюзивность Самурай Вэрриорс 3. На Ви Ю, будет это. Не вижу особой разницы =). Я бы предпочел поиграть в это, особенно если Нинтендо принимает участие в разработке.";}, 1701116101, 1716165181
Run Time: 0.000314
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 660508, a:1:{i:0;s:47:"В Японии выйдет 14 августа.";}, 1701116101, 1716165181
Run Time: 0.001014
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 660591, a:4:{i:0;s:35:"И еще немного инфы:
";i:1;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:32:"http://i.imgur.com/72ApJTO.jpg?1";}}i:2;s:419:"
- Premium box will be available for at least 10,000 yen
- Producers: Hisashi Koinuma, Yosuke Hayashi
- Supervisor: Eiji Aonuma
- Developers: ω-Force / Team NINJA
- Link sets off to rescue Princess Zelda
- Zelda has been kidnapped by the evil witch Shia
- Link, Impa, Shia introduced in the magazine
- Some of Shia’s minions shown as well
- Locations include Hyrule Field
- Will have unexpected playable characters
";i:3;a:4:{s:3:"tag";s:7:"spoiler";s:6:"option";N;s:8:"original";a:2:{i:0;s:9:"[SPOILER]";i:1;s:10:"[/SPOILER]";}s:8:"children";a:3:{i:0;s:1:"
";i:1;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:112:"https://fbcdn-sphotos-a-a.akamaihd.net/hphotos-ak-prn2/t1.0-9/10390193_705471436184372_2964711063526844760_n.jpg";}}i:2;s:2:"
";}}}, 1701116101, 1716165181
Run Time: 0.000880
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: signature, 3212, a:1:{i:0;s:17:"There only be ONE";}, 1701116101, 1716165181
Run Time: 0.000318
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 660600, a:1:{i:0;s:184:"Имхо самая нормальная в этом жанре была Kingdoms under fire, очень жаль что ничего не слышно от разработчиков.";}, 1701116101, 1716165181
Run Time: 0.000394
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 660718, a:17:{i:0;a:4:{s:3:"tag";s:7:"spoiler";s:6:"option";s:10:"Герои";s:8:"original";a:2:{i:0;s:22:"[SPOILER="Герои"]";i:1;s:10:"[/SPOILER]";}s:8:"children";a:21:{i:0;s:1:"
";i:1;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:60:"http://www.gamecity.ne.jp/zelda/character/character_link.jpg";}}i:2;s:1:"
";i:3;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:55:"http://www.gamecity.ne.jp/zelda/character/link_ss01.jpg";}}i:4;s:1:"
";i:5;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:60:"http://www.gamecity.ne.jp/zelda/character/character_inpa.jpg";}}i:6;s:1:"
";i:7;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:55:"http://www.gamecity.ne.jp/zelda/character/inpa_ss01.jpg";}}i:8;s:1:"
";i:9;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:60:"http://www.gamecity.ne.jp/zelda/character/character_shia.jpg";}}i:10;s:1:"
";i:11;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:55:"http://www.gamecity.ne.jp/zelda/character/shia_ss01.jpg";}}i:12;s:1:"
";i:13;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:59:"http://www.gamecity.ne.jp/zelda/character/character_wiz.jpg";}}i:14;s:1:"
";i:15;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:54:"http://www.gamecity.ne.jp/zelda/character/wiz_ss01.jpg";}}i:16;s:1:"
";i:17;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:61:"http://www.gamecity.ne.jp/zelda/character/character_valga.jpg";}}i:18;s:1:"
";i:19;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:56:"http://www.gamecity.ne.jp/zelda/character/valga_ss01.jpg";}}i:20;s:1:"
";}}i:1;s:2:"
";i:2;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"http://www.gamecity.ne.jp/zelda/stage/01_01.jpg";}}i:3;s:1:"
";i:4;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"http://www.gamecity.ne.jp/zelda/stage/01_02.jpg";}}i:5;s:1:"
";i:6;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"http://www.gamecity.ne.jp/zelda/stage/01_03.jpg";}}i:7;s:1:"
";i:8;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"http://www.gamecity.ne.jp/zelda/stage/02_01.jpg";}}i:9;s:1:"
";i:10;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"http://www.gamecity.ne.jp/zelda/stage/02_02.jpg";}}i:11;s:1:"
";i:12;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"http://www.gamecity.ne.jp/zelda/stage/02_03.jpg";}}i:13;s:99:"
И немного инфы (часть статьи перевели на английский):
";i:14;a:4:{s:3:"tag";s:7:"spoiler";s:6:"option";N;s:8:"original";a:2:{i:0;s:9:"[SPOILER]";i:1;s:10:"[/SPOILER]";}s:8:"children";a:1:{i:0;s:3520:"
This week’s issue of Famitsu magazine has a lot to share about Tecmo Koei and Nintendo’s upcoming collaboration, Hyrule Warriors. The game, known as “Zelda Musou” in Japan, is part of Tecmo Koei’s Warriors series of games, which employ the concept of a single character doing battle against dozens of enemies as once.
In Japan, the Warriors—or “Musou” games, as they’re referred to there—encompass a wide range of franchises, ranging from Tecmo Koei’s own Dynasty Warriors to collaborations with other companies, such as One Piece: Pirate Warriors or Dynasty Warriors: Gundam. This week’s Famitsu features an interview with three key developers working on Hyrule Warriors, including Eiji Aonuma, known for directing and producing several Zelda games.
Aonuma, who is currently taking on the role of Hyrule Warriors’ supervisor, is joined by general producer Hisashi Koinuma and producer Yosuke Hayashi, both from Tecmo Koei. Famitsu starts out the interview by expressing their surprise upon first hearing about a collaboration between The Legend of Zelda and the Warriors series. They ask how it all began.
“Warriors has teamed up with series such as Gundam, Fist of the North Star and One Piece, and I thought about doing something with Nintendo,” explains Koinuma. “While thinking about what would make for a good collaboration, it was Hayashi that proposed [the idea] by saying, ‘Wouldn’t it be interesting to do a collaboration with The Legend of Zelda?’”
Koinuma explains that it was from there that they eventually spoke with Eiji Aonuma and Shigeru Miyamoto from Nintendo, who agreed on the collaboration to create Hyrule Warriors.
“This presentation was actually from several years ago, when they showed us One Piece: Pirate Warriors,” says Aonuma. “At first, when they said that One Piece would become a Warriors [game], I wondered, ‘How will that turn out?’ but once I actually played it, I felt that they did a good job of implementing the Warriors system.”
“So, it sparked my interest when I thought: ‘I wonder what a collaboration with The Legend of Zelda would be like.’ Shortly afterwards, Miyamoto told me, ‘The folks at Tecmo Koei are talking about a Zelda Musou. Are you interested?’ and I responded with ‘definitely!’”
Famitsu mentions that it seems like Nintendo were being very forward-looking about the entire affair
“Yes, given Tecmo Koei and their ability to plan things out, along with many other titles they’ve shaped into the form of a Warriors game, when thinking about how The Legend of Zelda could be reborn [in such a way], we had far more expectations than uncertainties.”
Next, they ask Tecmo Koei how they decided on a Zelda collaboration, when considering the numerous titles Nintendo have.
“With Koinuma and myself included, we have many fans of The Legend of Zelda in our company, and that would be the ultimate reason,” replies Hayashi. “The basic fights in The Legend of Zelda series involve one-on-one fights, so ‘having over 100 enemies like the Musou games would surely make things interesting,’ was something we discussed among the staff.”
“You can say that luck also played a role,” adds Koinuma. “The title that our company wanted to do a Musou game collaboration with the most just so happened to be the one title that the folks at Nintendo said ‘we can entrust them with this one’ to, so we were both able to come to an agreement regarding The Legend of Zelda.”
";}}i:15;s:1:"
";i:16;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:183:"http://www.siliconera.com/2014/05/22/nintendo-tecmo-koei-discuss-hyrule-warriors-came/?utm_source=feedburner&utm_medium=twitter&utm_campaign=Feed%3A+siliconera%2FMkOc+%28Siliconera%29";}}}, 1701116101, 1716165181
Run Time: 0.000548
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 660914, a:8:{i:0;s:92:"Hyrule Warriors так и осталась Hyrule Warriors в English варианте =)
";i:1;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:113:"https://fbcdn-sphotos-f-a.akamaihd.net/hphotos-ak-frc3/t31.0-8/10380075_794902700529093_8794812446108169751_o.png";}}i:2;s:2:"
";i:3;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[QUOTE]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:1551:"Hyrule Warriors, the imaginative upcoming game for the Wii U console, combines the action-packed game play of Tecmo Koei’s Dynasty Warriors series with the iconic characters and worlds from The Legend of Zelda series. In addition to the focused action game play of leading one soldier against a massive horde of enemies, the Dynasty Warriors series is also known for its epic storyline. In this game, players control Link as he faces a powerful new enemy – the evil sorceress Cia – and her army to rescue the captive Princess Zelda. For the first time ever, Princess Zelda’s loyal Hyrulean Captain Impa makes her debut as a playable character. Impa equips a huge sword and can perform powerful combos to defeat enemies. Many other surprising playable characters make appearances in Hyrule Warriors, and each playable character will have signature weapons and action animations.
The first stage of the game takes place in Hyrule Field, a location that will be very familiar to fans of The Legend of Zelda series. The game-play structure of most of the stages bears a close resemblance to the Dynasty Warrior games, so Hyrule Warriors is a game that can truly be enjoyed by fans of both The Legend of Zelda and the Dynasty Warrior series. Players must defend or reclaim areas by fighting against hordes of enemies and using different types of flashy and powerful moves. Players will encounter new enemies such as Sorceress Cia, but some familiar enemies like Bokoblins and Lizalfos from The Legend of Zelda series will also appear in the game.";}}i:4;s:2:"
";i:5;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[QUOTE]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:1337:"Cut down entire legions of enemies as Link™, Impa and other Legend of Zelda™ characters using over-the-top powerful Dynasty-Warriors-style moves. This tour de force through the beloved locales of Hyrule will have you battling the fiercest enemies in Zelda history. Think tactically and conquer missions in the most efficient way you can to save Hyrule!
The delicate balance of the Triforce has been disrupted, and Hyrule Kingdom is once again being torn apart by a dark power, this time lead by Sorceress Cia. Now it’s up to the legendary hero Link to face hordes of enemies and find the missing Princess Zelda™. Advance the story to unlock new playable characters with unique moves and weapon types. Collect Rupees and other useful items to upgrade weapons and craft badges, which you can use to bolster each warrior’s abilities. Then unleash the full power of your attacks with intense combos to clear wave after wave of Bokoblin hordes. You’ll have to get your gloves dirty to save Hyrule this time.
Play as fan-favorite characters like Link and Impa for the first time in the series!
Battle the fiercest Legend of Zelda enemies across Hyrule’s most famous locales.
Lay waste to your opponents with brutally efficient attacks and intense combos
Think tactically and complete missions in the most efficient way possible";}}i:6;s:5:"
OS: ";i:7;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:69:"http://www.nintendo.com/games/detail/8yAfhMHGxHAyS8paJmVjQVK0mI9BUl-G";}}}, 1701116101, 1716165181
Run Time: 0.002755
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 663497, a:1:{i:0;s:122:"Princess Zelda, Midna и Impa играбельные персы. Выход в Европе и США 26 сентября.";}, 1701116101, 1716165181
Run Time: 0.012097
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 663507, a:1:{i:0;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[MEDIA=youtube]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:11:"z107NbGUIOk";}}}, 1701116101, 1716165181
Run Time: 0.005609
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 663555, a:3:{i:0;s:24:"Геймплейчик:
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[MEDIA=youtube]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:11:"WhYI0qeh1UE";}}i:2;s:59:"
Блин, чо еще эту покупать што ле?";}, 1701116101, 1716165181
Run Time: 0.007639
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 663558, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:32:"dimm, post: 663555, member: 3212";s:8:"original";a:2:{i:0;s:42:"[QUOTE="dimm, post: 663555, member: 3212"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:3:{i:0;s:24:"Геймплейчик:
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[MEDIA=youtube]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:11:"WhYI0qeh1UE";}}i:2;s:59:"
Блин, чо еще эту покупать што ле?";}}i:1;s:83:"
Что-то одним ударом он всё время пользовался.";}, 1701116101, 1716165181
Run Time: 0.000635
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 663560, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:32:"dimm, post: 660914, member: 3212";s:8:"original";a:2:{i:0;s:42:"[quote="dimm, post: 660914, member: 3212"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:89:"Hyrule Warriors так и осталась Hyrule Warriors в English варианте =)";}}i:1;s:203:"
В японском варианте игра называется Zelda Musou вроде же. Или нет? А это совсем не тоже самое что и Херуль Варриорс....";}, 1701116101, 1716165181
Run Time: 0.000621