SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('styles')
Run Time: 0.000902
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000074
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,
0 AS thread_is_ignored, 0 AS thread_ignore_news_feed,
0 AS thread_ignore_new_posts, 0 AS thread_ignore_forum_view
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 98932
Run Time: 0.000264
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 | |
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: 8
Run Time: 0.000168
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | 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 >= 2350 AND post.position < 2400)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 98932
Run Time: 0.001689
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 | | 50 | Using index condition; Using where; Using filesort |
SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,themainb_tmb_new.post.post_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | themainb_tmb_new.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | themainb_tmb_new.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | themainb_tmb_new.post.user_id | 1 | |
SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,themainb_tmb_new.post.user_id | 1 | Using where |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | themainb_tmb_new.post.user_id,func | 1 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 98932
Run Time: 0.000066
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=98932&page=48, 1711701051,
Run Time: 0.000087
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | no matching row in const table |
SELECT *
FROM uix_node_layout
Run Time: 0.000077
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | uix_node_layout | ALL | | | | | 2 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | no matching row in const table |
SELECT node.*,
node_field.uix_node_icons,
node_field.uix_styling,
node_field.collapsed,
node_field.inheritClass
FROM xf_node AS node
LEFT JOIN uix_node_fields AS node_field ON (node.node_id = node_field.node_id)
Run Time: 0.000103
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | ALL | | | | | 38 | |
SIMPLE | node_field | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (Block Nested Loop) |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'BRATI_thread_icon', 'BRATI_thread_icon_edit', 'thread_view', 'addm_navigation', 'BRSTI_navigation_tabs_members', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 16, 1
Run Time: 0.000466
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 13 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('addm_donations')
Params: 1
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT sport_team.*
FROM xf_brivium_sport_team AS sport_team
WHERE (sport_team.active = 1)
ORDER BY sport_team.title ASC
Run Time: 0.000134
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | sport_team | ALL | active | | | | 429 | Using where; Using filesort |
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, 6550017, a:1:{i:0;s:106:"Currently in the 9th round of fantasy draft out of 24 I believe.
Should be done around 915 CST I'd guess.";}, 1702743702, 1711701051
Run Time: 0.000437
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, 6550200, a:1:{i:0;s:22:"I'm down for 10:15 est";}, 1702743702, 1711701051
Run Time: 0.000439
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, 6550235, a:1:{i:0;s:41:"Should be on in 15 mins if we have enough";}, 1702743702, 1711701051
Run Time: 0.000440
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, 6550242, a:1:{i:0;s:29:"i will play FIFA this evening";}, 1702743702, 1711701051
Run Time: 0.000434
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, 6550290, a:1:{i:0;s:158:"Still got about 10 rounds left, but I will get on and just try to put all the guys I want in my queue so it doesn't distract me from FIFA'in.
Getting on now.";}, 1702743702, 1711701051
Run Time: 0.000444
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, 6550335, a:1:{i:0;s:23:"[user]Dray10__AF[/user]";}, 1702743702, 1711701051
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: post, 6550493, a:1:{i:0;s:14:"Bout to get on";}, 1702743702, 1711701051
Run Time: 0.000359
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, 6550498, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"dray10__AF, post: 6550493";s:8:"original";a:2:{i:0;s:35:"[quote="dray10__AF, post: 6550493"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:14:"Bout to get on";}}i:1;s:78:"
Me and Strouse got booted, sitting in lobby.
Clem and Schark still in game.";}, 1702743702, 1711701051
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, 6553694, a:1:{i:0;s:519:"So last night was pretty depressing. Teams computer defense blew me away and I just can't stop thinking custom tactics has everything to do with it. So I started reading some forums and came across quite a lot of info. Now I'm not shocked our computer players look completely retards compared to other teams. The best advice given is to find the best tactics for your formation and style. I created one that I think will fit us well. like I said tons and tons of teams use them so hopefully we can get an advantage also";}, 1702743702, 1711701051
Run Time: 0.000392
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, 6553718, a:1:{i:0;s:238:"Sorry I didn't get online last night. The first couple responses to my post didn't seem too promising then I didn't check back in the thread later that night. I should be able to play tonight, though, if you guys are going to be online.";}, 1702743702, 1711701051
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: post, 6553912, a:1:{i:0;s:41:"we dropped below 5300 last night :ohdear:";}, 1702743702, 1711701051
Run Time: 0.000371
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, 6554163, a:1:{i:0;s:56:"Tonight we will rise with these new tactics...I know it!";}, 1702743702, 1711701051
Run Time: 0.000372
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, 6554464, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"dray10__AF, post: 6554163";s:8:"original";a:2:{i:0;s:35:"[quote="dray10__AF, post: 6554163"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:56:"Tonight we will rise with these new tactics...I know it!";}}i:1;s:41:"
What are these new tactics you speak of?";}, 1702743702, 1711701051
Run Time: 0.000364
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, 6554525, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"dray10__AF, post: 6553694";s:8:"original";a:2:{i:0;s:35:"[quote="dray10__AF, post: 6553694"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:519:"So last night was pretty depressing. Teams computer defense blew me away and I just can't stop thinking custom tactics has everything to do with it. So I started reading some forums and came across quite a lot of info. Now I'm not shocked our computer players look completely retards compared to other teams. The best advice given is to find the best tactics for your formation and style. I created one that I think will fit us well. like I said tons and tons of teams use them so hopefully we can get an advantage also";}}i:1;s:90:"
You should post them in here IMO so everyone can create them in case they end up captain";}, 1702743702, 1711701051
Run Time: 0.000397
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, 6554706, a:1:{i:0;s:33:"Can't tonight, going to a concert";}, 1702743702, 1711701051
Run Time: 0.000382
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, 6554710, a:2:{i:0;s:2007:"I based it on alot of advice on forums and pre set custom tactics for certain formations and styles. Since we like our defenders to actually be aggressive and make a tackle....you must make the position of the defense deeper and narrow. Almost as if they draw them in and then pounce. For example...that team we played 4 times...everytime we got the ball anywhere around the box...they had guys swarm all over us. Also since our style is we want the computer players to give it to us as fast as possible(we dont have alot of patience not calling for the ball) then having them position for shorter passes rather them run away from us for deep runs fits us better.
Here is the settings I have:
Our Custom Tactics:
Speed: 35 (not about how fast the computer plays ..but more having to do with how forward they make the passes and runs. We want to control the ball as quickly as possible from computer..so better to have quicker shorter passes so we can make the runs and passes)
Pass Distance: 65
Positioning: Free Form
Pass Risk 65
Crossing 50
Shooting 30
Free Form
Pressure 35 (Deeper the better with a high aggression
Aggression 70 ( suggested you never want to go over 75 here because they actually stop going all out aggressive they just become out of place and worthless)
Team Width 35 (brings in a more narrow approach and forces them outside. Since most teams rely on that turn and shoot approach rather than crossing it...with a deep defense this will clutter the middle which is what we usually hate to face.
Cover
Also if we want to try out Chelsea's realistic tactics for fun it would be(from a site that took all club teams and made realistic custom tactics to how they play:
5
20
Free
50
40
55
Free
80
55
50
Offside
There is no doubt in my mind most elite clubs have perfected the custom tactics and that we have been rolling with the retard default fifa tactics. Also anyone that wants to look at this great guide to tactics and how they work for your clubs strategy check out this site: ";i:1;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:59:"http://www.halin.co.uk/fifa/understandingcustomtactics.html";}}}, 1702743702, 1711701051
Run Time: 0.000420
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, 6555081, a:1:{i:0;s:38:"Where do you go to change the tactics?";}, 1702743702, 1711701051
Run Time: 0.000536
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, 6555104, a:1:{i:0;s:218:"go to your edit teams menu and go to US international team and change custom tactics....you can then put your custom tactics in your quick tactics(which is where u press the arrow of whatever tactic u want in the game)";}, 1702743702, 1711701051
Run Time: 0.000536
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, 6555458, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"dray10__AF, post: 6555104";s:8:"original";a:2:{i:0;s:35:"[quote="dray10__AF, post: 6555104"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:218:"go to your edit teams menu and go to US international team and change custom tactics....you can then put your custom tactics in your quick tactics(which is where u press the arrow of whatever tactic u want in the game)";}}i:1;s:184:"
Yep. I took out USA Default and something else, can't remember. But I left counter attack and high pressure as my other two quick tactics.
I will update these before I play tonight.";}, 1702743702, 1711701051
Run Time: 0.000356
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, 6555490, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"4-3 D, post: 6555458";s:8:"original";a:2:{i:0;s:30:"[quote="4-3 D, post: 6555458"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:182:"Yep. I took out USA Default and something else, can't remember. But I left counter attack and high pressure as my other two quick tactics.
I will update these before I play tonight.";}}i:1;s:206:"
Yea same here high pressure and counter are a good 2 to keep with the others being custom tactics. Everyone that is usually captain at some point should update just in case captain gets booted in game also";}, 1702743702, 1711701051
Run Time: 0.000398
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, 6555502, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"dray10__AF, post: 6555490";s:8:"original";a:2:{i:0;s:35:"[quote="dray10__AF, post: 6555490"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:205:"Yea same here high pressure and counter are a good 2 to keep with the others being custom tactics. Everyone that is usually captain at some point should update just in case captain gets booted in game also";}}i:1;s:190:"
Really everyone should do it because I'm typically captain and I get booted a lot and it all just depends on who ends up being the red icon (I think) that gets the captain if I get booted.";}, 1702743702, 1711701051
Run Time: 0.000328
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, 6556331, a:1:{i:0;s:23:"Are we playing tonight?";}, 1702743702, 1711701051
Run Time: 0.000382
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, 6556336, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:21:"GBG_24, post: 6556331";s:8:"original";a:2:{i:0;s:31:"[quote="GBG_24, post: 6556331"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:23:"Are we playing tonight?";}}i:1;s:61:"
I will be on around 9 CST unless others get on before then.";}, 1702743702, 1711701051
Run Time: 0.000390
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, 6556359, a:1:{i:0;s:20:"I can get on anytime";}, 1702743702, 1711701051
Run Time: 0.000511
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, 6556368, a:1:{i:0;s:68:"what are we changing the tactics to?
Tell me like I am 7 years old.";}, 1702743702, 1711701051
Run Time: 0.000506
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, 6556388, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"clemsontyger04, post: 6556368";s:8:"original";a:2:{i:0;s:39:"[quote="clemsontyger04, post: 6556368"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:68:"what are we changing the tactics to?
Tell me like I am 7 years old.";}}i:1;s:1100:"
Speed: 35 (not about how fast the computer plays ..but more having to do with how forward they make the passes and runs. We want to control the ball as quickly as possible from computer..so better to have quicker shorter passes so we can make the runs and passes)
Pass Distance: 65
Positioning: Free Form
Pass Risk 65
Crossing 50
Shooting 30
Free Form
Pressure 35 (Deeper the better with a high aggression
Aggression 70 ( suggested you never want to go over 75 here because they actually stop going all out aggressive they just become out of place and worthless)
Team Width 35 (brings in a more narrow approach and forces them outside. Since most teams rely on that turn and shoot approach rather than crossing it...with a deep defense this will clutter the middle which is what we usually hate to face.
Cover
Just go to the US. Go to their tactics, go on anyone one of the tactics and edit them. Create those settings. Hit Square to save those settings, it'll be named US Custom whatever.
Then go to quick tactics and replace one of the tactics with that custom tactic and you are good to go.";}, 1702743702, 1711701051
Run Time: 0.000442
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, 6556438, a:1:{i:0;s:126:"I'll wait to see how the custom tactics work out before I go through the hassle of editing that shit. Also, I can play now...";}, 1702743702, 1711701051
Run Time: 0.000578
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, 6556441, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:21:"GBG_24, post: 6556438";s:8:"original";a:2:{i:0;s:31:"[quote="GBG_24, post: 6556438"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:125:"I'll wait to see how the custom tactics work out before I go through the hassle of editing that shit. Also, I can play now...";}}i:1;s:93:"
I can as well.
Let me know if others are getting on. Currently watching Nebraska baseball";}, 1702743702, 1711701051
Run Time: 0.000621
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, 6556464, a:1:{i:0;s:148:"Yea and the great thing about it is now that we are familiar with what each tactic does...we can adjust depending on what we see we want differently";}, 1702743702, 1711701051
Run Time: 0.000579
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, 6556538, a:1:{i:0;s:149:"[user]dray10__AF[/user]
[user]clemsontyger04[/user]
Can you guys play now.
[user]GBG_24[/user] Said he is ready to play and I can play now as well.";}, 1702743702, 1711701051
Run Time: 0.000497
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, 6556548, a:1:{i:0;s:13:"so we playin?";}, 1702743702, 1711701051
Run Time: 0.000445
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, 6556572, a:1:{i:0;s:34:"Just got on now to fix the tactics";}, 1702743702, 1711701051
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, 6556575, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"clemsontyger04, post: 6556548";s:8:"original";a:2:{i:0;s:39:"[quote="clemsontyger04, post: 6556548"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:13:"so we playin?";}}i:1;s:17:"
Getting on now.";}, 1702743702, 1711701051
Run Time: 0.000468
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, 6556645, a:1:{i:0;s:19:"[user]GBG_24[/user]";}, 1702743702, 1711701051
Run Time: 0.000450
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, 6557670, a:1:{i:0;s:23:"Bandito u playin 2nite?";}, 1702743702, 1711701051
Run Time: 0.000409
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, 6557825, a:1:{i:0;s:144:"Servers down.
Good run fellas.
Think we went 7-1-0 if they count that last game. Maybe 8-1-0 don't remember for sure.
No losses though :smug:";}, 1702743702, 1711701051
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, 6557827, a:1:{i:0;s:72:"Only thing stopping us tonight were the shitty EA Servers :feelsgoodman:";}, 1702743702, 1711701051
Run Time: 0.000433
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, 6557866, a:1:{i:0;s:43:"Seriously awesome run! Love the new tactics";}, 1702743702, 1711701051
Run Time: 0.000469
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, 6558436, a:1:{i:0;s:56:"Damn mad I missed it, will be there to run shit tonight!";}, 1702743702, 1711701051
Run Time: 0.000365
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, 6558514, a:1:{i:0;s:81:"I think the new tactics are stealing the credit that my glorious return deserves.";}, 1702743702, 1711701051
Run Time: 0.000346
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, 6558692, a:1:{i:0;s:122:"I just checked, you guys got credited with a 3-0 loss for the last game of the night you tried playing after I got offline";}, 1702743702, 1711701051
Run Time: 0.000409
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, 6558757, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:21:"GBG_24, post: 6558692";s:8:"original";a:2:{i:0;s:31:"[quote="GBG_24, post: 6558692"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:122:"I just checked, you guys got credited with a 3-0 loss for the last game of the night you tried playing after I got offline";}}i:1;s:60:"
That's bullshit. We were up 2-0 when the servers went down";}, 1702743702, 1711701051
Run Time: 0.000342
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, 6560059, a:1:{i:0;s:82:"We lost 52 points because the servers went down when we were up 2-0
WTF? :blowup:";}, 1702743702, 1711701051
Run Time: 0.000331
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, 6560189, a:1:{i:0;s:9:"That's bs";}, 1702743702, 1711701051
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, 6560214, a:1:{i:0;s:101:"Guys, root for Kansas on Saturday. I will get $100 from the nog bracket, and it will fund my new PS3.";}, 1702743702, 1711701051
Run Time: 0.000336
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, 6560225, a:1:{i:0;s:98:"Sup guys..
I had a couple games last night and couldnt play, but I'll be on tonight at about 9pst.";}, 1702743702, 1711701051
Run Time: 0.000255
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, 6560544, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:28:"Arrec Bardwin, post: 6560214";s:8:"original";a:2:{i:0;s:38:"[quote="Arrec Bardwin, post: 6560214"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:101:"Guys, root for Kansas on Saturday. I will get $100 from the nog bracket, and it will fund my new PS3.";}}i:1;s:137:"
Hey guys pull for OSU. I will win my bracket and get $200...send 100$ to Arrec and use the other $100 to buy tiger woods and some beer.";}, 1702743702, 1711701051
Run Time: 0.000510
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, 6560549, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"dray10__AF, post: 6560544";s:8:"original";a:2:{i:0;s:35:"[quote="dray10__AF, post: 6560544"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:135:"Hey guys pull for OSU. I will win my bracket and get $200...send 100$ to Arrec and use the other $100 to buy tiger woods and some beer.";}}i:1;s:79:"
sorry me winning almost $200 happens if Kentucky and Kansas wins
<3 you bro";}, 1702743702, 1711701051
Run Time: 0.000472
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, 6560559, a:1:{i:0;s:281:"We lost points???? We were killing them about to score again and we lose points...god I hate EA. GB ur return was glorious....but everyone's eyes are now open to our computer players actually playing soccer instead of running around jacking off. We got the 49ers defense out there!";}, 1702743702, 1711701051
Run Time: 0.000331
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, 6560572, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"clemsontyger04, post: 6560549";s:8:"original";a:2:{i:0;s:39:"[quote="clemsontyger04, post: 6560549"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:76:"sorry me winning almost $200 happens if Kentucky and Kansas wins
<3 you bro";}}i:1;s:189:"
Damn this is crazy. We got big implications on the Kansas vs Osu game. I was only one to pick Osu in championship game losing to Kentucky...but all I need is the points from Osu and I win";}, 1702743702, 1711701051
Run Time: 0.000346
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('xenfans_popular_forumstab_link', 'xenfans_popular_footer_link', 'navigation')
AND style_id = ?
AND language_id = ?
Params: 16, 1
Run Time: 0.000109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 3 | Using where |