SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000218
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.001242
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.000504
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 >= 20 AND post.position < 40)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 22471
Run Time: 0.003986
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.000265
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, 3, 3, XenForo_ControllerPublic_Thread, Index, valid, thread_id=22471&page=2, 1715084485,
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, 663562, a:1:{i:0;s:115:"Хорошо хоть не Херовая Басара, а то пришлось бы и мне покупать.=)";}, 1701116101, 1715084485
Run Time: 0.000453
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, 727, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:28:"https://youtu.be/Nq--Bv5G06M";s:8:"original";a:2:{i:0;s:36:"[URL='https://youtu.be/Nq--Bv5G06M']";i:1;s:6:"[/URL]";}s:8:"children";a:2:{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:45:"https://kvotka.ru/images/2021/09/07/SENYN.jpg";}}i:1;s:1:" ";}}}, 1701116101, 1715084485
Run Time: 0.000292
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, 663567, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:30:"SnV, post: 663562, member: 727";s:8:"original";a:2:{i:0;s:40:"[QUOTE="SnV, post: 663562, member: 727"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:115:"Хорошо хоть не Херовая Басара, а то пришлось бы и мне покупать.=)";}}i:1;s:145:"
Говорят, русское название будет - Войны Хера =). Так что, ты просто обязан купить.";}, 1701116101, 1715084485
Run Time: 0.002627
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, 663762, a:2:{i:0;s:15:"11 минут:
";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:"KtAkduu97RY";}}}, 1701116101, 1715084485
Run Time: 0.001204
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, 1715084485
Run Time: 0.000315
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, 663804, a:1:{i:0;s:469:"Омега форс, и этим всё сказанно...с 2001 года вышло десятки подобных херулин из их стана, и все похожи как монозиготные близнецы.
Хотя несчастные обладатели планшета от Нин так изголодались по играм, что скорей всего не раздумывая купят этот трэш от омега-форс.";}, 1701116101, 1715084485
Run Time: 0.000446
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, 8798, a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:113:"Раскаяться никогда не поздно,а вот согрешить можно и опоздать";}}}, 1701116101, 1715084485
Run Time: 0.000441
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, 663807, a:1:{i:0;s:145:"Терь хоть они не стесняясь называют свои произведения херулинами. Это радует. =)";}, 1701116101, 1715084485
Run Time: 0.000464
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, 663810, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:46:"Хеймдалль, post: 663804, member: 8798";s:8:"original";a:2:{i:0;s:56:"[QUOTE="Хеймдалль, post: 663804, member: 8798"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:469:"Омега форс, и этим всё сказанно...с 2001 года вышло десятки подобных херулин из их стана, и все похожи как монозиготные близнецы.
Хотя несчастные обладатели планшета от Нин так изголодались по играм, что скорей всего не раздумывая купят этот трэш от омега-форс.";}}i:1;s:489:"
Да ты ничего не знаешь просто, нубас. Где ты видел подобных боссов хоть в одной из их игр? Да и набор атак у Зельды весьма не плох... Я штук 6-ть насчитал, не считая бомб. И захвата баз я не видел, кстати. Очевидно, что эту игру дизайнили совместно с Нинтендо, под присмотром.";}, 1701116101, 1715084485
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, 663814, a:1:{i:0;s:135:"Ты не видел боссов в Династиворриорс?! И кто тут нубас, хочется спросить!? =)";}, 1701116101, 1715084485
Run Time: 0.000297
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, 663816, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:30:"SnV, post: 663814, member: 727";s:8:"original";a:2:{i:0;s:40:"[QUOTE="SnV, post: 663814, member: 727"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:135:"Ты не видел боссов в Династиворриорс?! И кто тут нубас, хочется спросить!? =)";}}i:1;s:59:"
Подобных боссов там нету, нубас.";}, 1701116101, 1715084485
Run Time: 0.000350
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, 663817, a:1:{i:0;s:110:"Конечно, таких нет. Там же не сказка про принцессу и бабаек. =)";}, 1701116101, 1715084485
Run Time: 0.000345
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, 663982, a:1:{i:0;s:40:"А, суки, не завидуйте :)";}, 1701116101, 1715084485
Run Time: 0.004961
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, 1715084485
Run Time: 0.000451
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, 665243, a:2:{i:0;s:15:"СКРИНЫ!:
";i:1;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:39:{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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_57.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_58.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_59.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_60.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_61.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_62.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_63.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_64.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_65.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_66.jpg";}}i:20;s:1:"
";i:21;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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_67.jpg";}}i:22;s:1:"
";i:23;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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_68.jpg";}}i:24;s:1:"
";i:25;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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_69.jpg";}}i:26;s:1:"
";i:27;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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_70.jpg";}}i:28;s:1:"
";i:29;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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_71.jpg";}}i:30;s:1:"
";i:31;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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_72.jpg";}}i:32;s:1:"
";i:33;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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_73.jpg";}}i:34;s:1:"
";i:35;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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_74.jpg";}}i:36;s:1:"
";i:37;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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_75.jpg";}}i:38;s:1:"
";}}}, 1701116101, 1715084485
Run Time: 0.001799
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, 665244, a:4:{i:0;s:13:"И исчё:
";i:1;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:13:{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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_76.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_77.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_78.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_79.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_80.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:50:"http://www.gamecity.ne.jp/zelda/gallery/gal_81.jpg";}}i:12;s:1:"
";}}i:2;s:45:"
И заодно новый трейлер:
";i:3;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:"gTMiECMOM5Y";}}}, 1701116101, 1715084485
Run Time: 0.000501
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, 666804, a:23:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:4:"Link";}}i:1;s:1:"
";i:2;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:"ImucbJghD0M";}}i:3;s:1:"
";i:4;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:2:{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:"PLieoH7He8g";}}i:1;s:7:"
Impa:";}}i:5;s:1:"
";i:6;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:"ylPbczdAooY";}}i:7;s:2:"
";i:8;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:5:"Zelda";}}i:9;s:1:"
";i:10;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:"gTMiECMOM5Y";}}i:11;s:1:"
";i:12;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:6:"
Lana:";}}i:13;s:1:"
";i:14;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:"MB31ie3ites";}}i:15;s:2:"
";i:16;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:7:"Agitha:";}}i:17;s:1:"
";i:18;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:"PP19h3YyZ0U";}}i:19;s:2:"
";i:20;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:6:"Midna:";}}i:21;s:1:"
";i:22;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:"PeWKSLq1tn0";}}}, 1701116101, 1715084485
Run Time: 0.001297
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, 667242, a:6:{i:0;s:150:"Немного новой инфы, видео и скринов (все взято и переведено на английский из Famitsu):
";i:1;a:4:{s:3:"tag";s:7:"spoiler";s:6:"option";s:61:"Различная инфа и сканы из Фамитсу";s:8:"original";a:2:{i:0;s:71:"[SPOILER=Различная инфа и сканы из Фамитсу]";i:1;s:10:"[/SPOILER]";}s:8:"children";a:5:{i:0;s:2373:"- No indication as to whether or not Ghirahim is playable yet; the description in Famitsu could be about his boss moves or character outline as general
- If Link uses Power gloves and drops off ball & chain, he can lift pillars, jars or even enemies
- With the legendary baton from Wind waker, Zelda can command winds and fight by playing songs
- You can blow enemies away with wind or the sound can turn into lightning bolts
- You can also summon tornados to snatch enemies away
- After you select a character for a stage you select the weapon
- You can’t change weapons in battle
- Weapons differ a lot from each other and it is part of the fun to test which one suits you
- Can shop between battles
– Shopping area includes at least training room, potion shop, badge shop and junk shop
– Junk shop will be introduced in a later magazine
– In training shop you can pay rupees to level up your character
– Characters also level up through normal gameplay
– Potions are one time use only and cause special effect during a battle
– It seems that one potion makes easier to obtain weapons (not entirely clear)
– Badge shop uses rupees and raw materials to buy permanent badges
- Raw materials are obtained from killing monsters and monsters have unique loot as well as some rare drops. Enemies also drop rupees
– One badge makes weak spot gauge to fill up faster
– Badge shop interface seems like a tree of sorts so I guess you have to make badges in a certain order, no word about it though
– You can see from stage select menu if a stage has heart containers or pieces to collect but you may need to use a certain character to get them
– Heart container/pieces work pretty much like in any Zelda game – You may also obtain a power up bow from a chest
– The bow makes weak spot gauge to last longer and can attack multiple enemies from afar – Fi moves by floating midair, can transform into a sword to slash enemies
– Link meets Fi in the Skyloft’s Goddess’ temple
– Ghirahim fights with magical swords, can summon enemies and change place in an instant, likes to toy with his enemies
– The imprisoned is tall as a mountain and emits damaging waves when it steps
– Cia twists space-time to summon forth areas from Skyward sword, e.g. Skyloft and Sealed grounds as pictured
- Pumpkin island is crashed with Skyloft as pictured
";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:78:"http://playeressence.com/wp-content/uploads/2014/07/hyrule-warriors-scan-1.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:78:"http://playeressence.com/wp-content/uploads/2014/07/hyrule-warriors-scan-2.jpg";}}i:4;s:1:"
";}}i:2;s:56:"
Новые трейлеры Агиты и Мидны:
";i:3;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:"J32H38Feftc";}}i:4;s:1:"
";i:5;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:"Jtvgfh-m_40";}}}, 1701116101, 1715084485
Run Time: 0.000542
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, 667291, a:1:{i:0;s:157:"Глядя на эти видео захотелось почему-то вместо этой поделки полноценного римейка ТР)))";}, 1701116101, 1715084485
Run Time: 0.000361
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, 145, 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:45:"https://card.psnprofiles.com/1/Ded_Bruzon.png";}}}, 1701116101, 1715084485
Run Time: 0.000508
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, 667796, a:5:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:3:"Fi:";}}i:1;s:1:"
";i:2;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:"efsu5u8kVI0";}}i:3;s:2:"
";i:4;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:"t55QgIpNIik";}}}, 1701116101, 1715084485
Run Time: 0.001068
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, 669237, a:3:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:33:"Hyrule Warriors Features Trailer:";}}i:1;s:1:"
";i:2;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:"2c8EEXL3L8c";}}}, 1701116101, 1715084485
Run Time: 0.000898
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, 669311, a:2:{i:0;s:16:"Менюшки:
";i:1;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:13:{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:63:"http://playeressence.com/wp-content/uploads/2014/07/hw-s-18.jpg";}}i:2;s:2:"
";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:63:"http://playeressence.com/wp-content/uploads/2014/07/hw-s-19.jpg";}}i:4;s:2:"
";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:63:"http://playeressence.com/wp-content/uploads/2014/07/hw-s-20.jpg";}}i:6;s:2:"
";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:63:"http://playeressence.com/wp-content/uploads/2014/07/hw-s-21.jpg";}}i:8;s:2:"
";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:63:"http://playeressence.com/wp-content/uploads/2014/07/hw-s-28.jpg";}}i:10;s:2:"
";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:63:"http://playeressence.com/wp-content/uploads/2014/07/hw-s-34.jpg";}}i:12;s:3:"
";}}}, 1701116101, 1715084485
Run Time: 0.000395
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, 669363, a:4:{i:0;s:38:"Будут золотые жуки :)
";i:1;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:659:"
[*]There are 100 Gold Skulltulas in the world – One will appear as an enemy if certain special conditions are met
[*]If you slay one, you will get an illustration piece – You can find information about Skulltulas in the stage select screen – You will know that a Skulltula has appeared from a spider web like marker on the map which also pins down the location
[*]Then you have limited time to find and slay it
[*]If you are nearby, you will hear a rustling sound – In the picture, one of the Skulltulas is under some large boulder so bombs are needed to uncover it
[*]Skulltula appearance is related to used weapon/character, at least in some cases
";}}i:2;s:28:"
Weapon information screen
";i:3;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:509:"
[*]Empty slot. You can fill these in the junk shop. At maximum you may have 8 skills.
[*]Sealed skill. Needs to fill requirements to unlock. In the picture, you need to kill 3000 enemies
[*]Skill (in picture “rupee increase”).
[*]Attack power.
[*].Attribute. There are fire, water, lightning, light and darkness. If you use attribute that enemy is weak for, the damage will increase.
[*] Rarity of the weapon. More stars means rarer
[*]Weapon name; in the picture it is a variation of Biggoron’s Sword
";}}}, 1701116101, 1715084485
Run Time: 0.000968
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, 669391, a:4:{i:0;s:29:"Игра на золоте:
";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:30:"http://i.imgur.com/33JVpi3.png";}}i:2;s:2:"
";i:3;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:"wVrCUToYi6U";}}}, 1701116101, 1715084485
Run Time: 0.000612