SET @@sql_mode = '' SELECT * FROM vb_datastore WHERE title IN ('tagcloud','iconcache','navdata','navdata','attachmentcache','cron','profilefield','loadcache','noticecache','activitystream','routes') SELECT * FROM vb_session WHERE sessionhash = '7eb5498a3fa0a952009f0c639b77ab6e' AND lastactivity > 1714249812 AND idhash = '4064c574e3391bb6e2eedb617f773ca2' SELECT * FROM vb_session WHERE userid = 0 AND host = '3.21.248.119' AND idhash = '4064c574e3391bb6e2eedb617f773ca2' LIMIT 1 SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_inlinemod AS phrasegroup_inlinemod, phrasegroup_search AS phrasegroup_search, phrasegroup_prefix AS phrasegroup_prefix, phrasegroupinfo AS lang_phrasegroupinfo, options AS lang_options, languagecode AS lang_code, charset AS lang_charset, locale AS lang_locale, imagesoverride AS lang_imagesoverride, dateoverride AS lang_dateoverride, timeoverride AS lang_timeoverride, registereddateoverride AS lang_registereddateoverride, calformat1override AS lang_calformat1override, calformat2override AS lang_calformat2override, logdateoverride AS lang_logdateoverride, decimalsep AS lang_decimalsep, thousandsep AS lang_thousandsep FROM vb_language WHERE languageid = 3 SELECT MAX(permissions & 1) AS perm FROM vb_cms_permissions WHERE nodeid = 1 AND usergroupid IN (1) SELECT * FROM vb_style WHERE (styleid = 7 AND userselect = 1) OR styleid = 7 ORDER BY styleid ASC LIMIT 1 SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vb_types.types'SELECT tagid, tagtext, canonicaltagid, dateline FROM vb_tag WHERE tagtext = 'tdi' SELECT searchlog.* FROM vb_searchlog AS searchlog WHERE searchhash = '2229a9ccf81fbd13a5db7542f26ec858' AND sortby = '' AND sortorder = 'asc' AND dateline > 1714247412 AND userid = 0 AND completed = 1 ORDER BY dateline DESC LIMIT 1 SELECT title, template FROM vb_template WHERE templateid IN (0,34318,34058,0,34071,34072,34191,34193,34192,33964,34181,34180,34160,34166,34068,34077,33823,7408,7407,8564,34282,0,0,6450,6444,13350,13024,13022,31734,31629,6451,6452,2680,33997,34271,19731,33947,33944,33945,33946,34301,0,0,34281,34242,33967,33968,33970,33971,34194,34313,34295,34245,34246,33794,33793,33797,33362,33358) SELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM vb_moderator AS moderator INNER JOIN vb_user AS user USING(userid) SELECT thread.*,'' as preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision, customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height, customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb, first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath, NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline, first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS first_filedata_thumb,lastpost.lastposttime FROM vb_thread AS thread LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_user AS first_user ON (first_user.userid = thread.postuserid) LEFT JOIN vb_avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid) LEFT JOIN vb_customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid) LEFT JOIN ( SELECT threadid, MAX(dateline) AS lastposttime FROM vb_post WHERE threadid IN (211217,208630,210383,209635,209970,207829,207755,207236,207214,206655,203893,201275,200080,196977,182391,196980,196164,194762,193476,161085) AND userid = 0 GROUP BY threadid ) AS lastpost ON (lastpost.threadid = thread.threadid) WHERE thread.threadid IN (211217,208630,210383,209635,209970,207829,207755,207236,207214,206655,203893,201275,200080,196977,182391,196980,196164,194762,193476,161085) SELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM vb_moderator AS moderator INNER JOIN vb_user AS user USING(userid) SELECT thread.*,'' as preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision, customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height, customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb, first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath, NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline, first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS first_filedata_thumb,lastpost.lastposttime FROM vb_thread AS thread LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_user AS first_user ON (first_user.userid = thread.postuserid) LEFT JOIN vb_avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid) LEFT JOIN vb_customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid) LEFT JOIN ( SELECT threadid, MAX(dateline) AS lastposttime FROM vb_post WHERE threadid IN (189190,188886,179480,104295,186513,184326,182039,181041,118154,174563,172071,168261,128606,164705,163381,158605,155915,154197,107861,137409) AND userid = 0 GROUP BY threadid ) AS lastpost ON (lastpost.threadid = thread.threadid) WHERE thread.threadid IN (189190,188886,179480,104295,186513,184326,182039,181041,118154,174563,172071,168261,128606,164705,163381,158605,155915,154197,107861,137409) SELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM vb_moderator AS moderator INNER JOIN vb_user AS user USING(userid) SELECT thread.*,'' as preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision, customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height, customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb, first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath, NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline, first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS first_filedata_thumb,lastpost.lastposttime FROM vb_thread AS thread LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_user AS first_user ON (first_user.userid = thread.postuserid) LEFT JOIN vb_avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid) LEFT JOIN vb_customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid) LEFT JOIN ( SELECT threadid, MAX(dateline) AS lastposttime FROM vb_post WHERE threadid IN (132485,121593,123482,119575,116486,112702,112115,111268,106060,104245,86585,101055,100785,84365,83041) AND userid = 0 GROUP BY threadid ) AS lastpost ON (lastpost.threadid = thread.threadid) WHERE thread.threadid IN (132485,121593,123482,119575,116486,112702,112115,111268,106060,104245,86585,101055,100785,84365,83041) UPDATE vb_searchlog SET results = 'a:4:{i:0;a:55:{i:0;a:4:{i:0;s:1:\"2\";i:1;s:6:\"211217\";i:2;s:6:\"211217\";i:3;s:10:\"1702365443\";}i:1;a:4:{i:0;s:1:\"2\";i:1;s:6:\"208630\";i:2;s:6:\"208630\";i:3;s:10:\"1695830388\";}i:2;a:4:{i:0;s:1:\"2\";i:1;s:6:\"210383\";i:2;s:6:\"210383\";i:3;s:10:\"1675922384\";}i:3;a:4:{i:0;s:1:\"2\";i:1;s:6:\"209635\";i:2;s:6:\"209635\";i:3;s:10:\"1666258913\";}i:4;a:4:{i:0;s:1:\"2\";i:1;s:6:\"209970\";i:2;s:6:\"209970\";i:3;s:10:\"1666149229\";}i:5;a:4:{i:0;s:1:\"2\";i:1;s:6:\"207829\";i:2;s:6:\"207829\";i:3;s:10:\"1610401480\";}i:6;a:4:{i:0;s:1:\"2\";i:1;s:6:\"207755\";i:2;s:6:\"207755\";i:3;s:10:\"1609014522\";}i:7;a:4:{i:0;s:1:\"2\";i:1;s:6:\"207236\";i:2;s:6:\"207236\";i:3;s:10:\"1597229533\";}i:8;a:4:{i:0;s:1:\"2\";i:1;s:6:\"207214\";i:2;s:6:\"207214\";i:3;s:10:\"1595595841\";}i:9;a:4:{i:0;s:1:\"2\";i:1;s:6:\"206655\";i:2;s:6:\"206655\";i:3;s:10:\"1585516877\";}i:10;a:4:{i:0;s:1:\"2\";i:1;s:6:\"203893\";i:2;s:6:\"203893\";i:3;s:10:\"1544471000\";}i:11;a:4:{i:0;s:1:\"2\";i:1;s:6:\"201275\";i:2;s:6:\"201275\";i:3;s:10:\"1515780746\";}i:12;a:4:{i:0;s:1:\"2\";i:1;s:6:\"200080\";i:2;s:6:\"200080\";i:3;s:10:\"1510229493\";}i:13;a:4:{i:0;s:1:\"2\";i:1;s:6:\"196977\";i:2;s:6:\"196977\";i:3;s:10:\"1484509489\";}i:14;a:4:{i:0;s:1:\"2\";i:1;s:6:\"182391\";i:2;s:6:\"182391\";i:3;s:10:\"1484349527\";}i:15;a:4:{i:0;s:1:\"2\";i:1;s:6:\"196980\";i:2;s:6:\"196980\";i:3;s:10:\"1481405274\";}i:16;a:4:{i:0;s:1:\"2\";i:1;s:6:\"196164\";i:2;s:6:\"196164\";i:3;s:10:\"1476523279\";}i:17;a:4:{i:0;s:1:\"2\";i:1;s:6:\"194762\";i:2;s:6:\"194762\";i:3;s:10:\"1468144281\";}i:18;a:4:{i:0;s:1:\"2\";i:1;s:6:\"193476\";i:2;s:6:\"193476\";i:3;s:10:\"1461320879\";}i:19;a:4:{i:0;s:1:\"2\";i:1;s:6:\"161085\";i:2;s:6:\"161085\";i:3;s:10:\"1456654310\";}i:20;a:4:{i:0;s:1:\"2\";i:1;s:6:\"189190\";i:2;s:6:\"189190\";i:3;s:10:\"1443129694\";}i:21;a:4:{i:0;s:1:\"2\";i:1;s:6:\"188886\";i:2;s:6:\"188886\";i:3;s:10:\"1441793730\";}i:22;a:4:{i:0;s:1:\"2\";i:1;s:6:\"179480\";i:2;s:6:\"179480\";i:3;s:10:\"1435930651\";}i:23;a:4:{i:0;s:1:\"2\";i:1;s:6:\"104295\";i:2;s:6:\"104295\";i:3;s:10:\"1435602697\";}i:24;a:4:{i:0;s:1:\"2\";i:1;s:6:\"186513\";i:2;s:6:\"186513\";i:3;s:10:\"1432052324\";}i:25;a:4:{i:0;s:1:\"2\";i:1;s:6:\"184326\";i:2;s:6:\"184326\";i:3;s:10:\"1425230501\";}i:26;a:4:{i:0;s:1:\"2\";i:1;s:6:\"182039\";i:2;s:6:\"182039\";i:3;s:10:\"1418028388\";}i:27;a:4:{i:0;s:1:\"2\";i:1;s:6:\"181041\";i:2;s:6:\"181041\";i:3;s:10:\"1415713754\";}i:28;a:4:{i:0;s:1:\"2\";i:1;s:6:\"118154\";i:2;s:6:\"118154\";i:3;s:10:\"1410366418\";}i:29;a:4:{i:0;s:1:\"2\";i:1;s:6:\"174563\";i:2;s:6:\"174563\";i:3;s:10:\"1399663080\";}i:30;a:4:{i:0;s:1:\"2\";i:1;s:6:\"172071\";i:2;s:6:\"172071\";i:3;s:10:\"1396808274\";}i:31;a:4:{i:0;s:1:\"2\";i:1;s:6:\"168261\";i:2;s:6:\"168261\";i:3;s:10:\"1396463188\";}i:32;a:4:{i:0;s:1:\"2\";i:1;s:6:\"128606\";i:2;s:6:\"128606\";i:3;s:10:\"1389883622\";}i:33;a:4:{i:0;s:1:\"2\";i:1;s:6:\"164705\";i:2;s:6:\"164705\";i:3;s:10:\"1389116060\";}i:34;a:4:{i:0;s:1:\"2\";i:1;s:6:\"163381\";i:2;s:6:\"163381\";i:3;s:10:\"1387631109\";}i:35;a:4:{i:0;s:1:\"2\";i:1;s:6:\"158605\";i:2;s:6:\"158605\";i:3;s:10:\"1382371975\";}i:36;a:4:{i:0;s:1:\"2\";i:1;s:6:\"155915\";i:2;s:6:\"155915\";i:3;s:10:\"1379614877\";}i:37;a:4:{i:0;s:1:\"2\";i:1;s:6:\"154197\";i:2;s:6:\"154197\";i:3;s:10:\"1378201269\";}i:38;a:4:{i:0;s:1:\"2\";i:1;s:6:\"107861\";i:2;s:6:\"107861\";i:3;s:10:\"1376370444\";}i:39;a:4:{i:0;s:1:\"2\";i:1;s:6:\"137409\";i:2;s:6:\"137409\";i:3;s:10:\"1363127074\";}i:40;a:4:{i:0;s:1:\"2\";i:1;s:6:\"132485\";i:2;s:6:\"132485\";i:3;s:10:\"1359657309\";}i:41;a:4:{i:0;s:1:\"2\";i:1;s:6:\"121593\";i:2;s:6:\"121593\";i:3;s:10:\"1352409934\";}i:42;a:4:{i:0;s:1:\"2\";i:1;s:6:\"123482\";i:2;s:6:\"123482\";i:3;s:10:\"1350040294\";}i:43;a:4:{i:0;s:1:\"2\";i:1;s:6:\"119575\";i:2;s:6:\"119575\";i:3;s:10:\"1340543877\";}i:44;a:4:{i:0;s:1:\"2\";i:1;s:6:\"116486\";i:2;s:6:\"116486\";i:3;s:10:\"1335356896\";}i:45;a:4:{i:0;s:1:\"2\";i:1;s:6:\"112702\";i:2;s:6:\"112702\";i:3;s:10:\"1330187271\";}i:46;a:4:{i:0;s:1:\"2\";i:1;s:6:\"112115\";i:2;s:6:\"112115\";i:3;s:10:\"1330116574\";}i:47;a:4:{i:0;s:1:\"2\";i:1;s:6:\"111268\";i:2;s:6:\"111268\";i:3;s:10:\"1328219918\";}i:48;a:4:{i:0;s:1:\"2\";i:1;s:6:\"106060\";i:2;s:6:\"106060\";i:3;s:10:\"1318653795\";}i:49;a:4:{i:0;s:1:\"2\";i:1;s:6:\"104245\";i:2;s:6:\"104245\";i:3;s:10:\"1316868919\";}i:50;a:4:{i:0;s:1:\"2\";i:1;s:5:\"86585\";i:2;s:5:\"86585\";i:3;s:10:\"1313185791\";}i:51;a:4:{i:0;s:1:\"2\";i:1;s:6:\"101055\";i:2;s:6:\"101055\";i:3;s:10:\"1310065376\";}i:52;a:4:{i:0;s:1:\"2\";i:1;s:6:\"100785\";i:2;s:6:\"100785\";i:3;s:10:\"1309624457\";}i:53;a:4:{i:0;s:1:\"2\";i:1;s:5:\"84365\";i:2;s:5:\"84365\";i:3;s:10:\"1283628049\";}i:54;a:4:{i:0;s:1:\"2\";i:1;s:5:\"83041\";i:2;s:5:\"83041\";i:3;s:10:\"1281525263\";}}i:1;i:66;i:2;a:1:{i:2;a:140:{i:0;s:6:\"211217\";i:1;s:6:\"208630\";i:2;s:6:\"210383\";i:3;s:6:\"209635\";i:4;s:6:\"209970\";i:5;s:6:\"207829\";i:6;s:6:\"207755\";i:7;s:6:\"207236\";i:8;s:6:\"207214\";i:9;s:6:\"206655\";i:10;s:6:\"203893\";i:11;s:6:\"201275\";i:12;s:6:\"200080\";i:13;s:6:\"196977\";i:14;s:6:\"182391\";i:15;s:6:\"196980\";i:16;s:6:\"196164\";i:17;s:6:\"194762\";i:18;s:6:\"193476\";i:19;s:6:\"161085\";i:20;s:6:\"189190\";i:21;s:6:\"188886\";i:22;s:6:\"179480\";i:23;s:6:\"104295\";i:24;s:6:\"186513\";i:25;s:6:\"184326\";i:26;s:6:\"182039\";i:27;s:6:\"181041\";i:28;s:6:\"118154\";i:29;s:6:\"174563\";i:30;s:6:\"172071\";i:31;s:6:\"168261\";i:32;s:6:\"128606\";i:33;s:6:\"164705\";i:34;s:6:\"163381\";i:35;s:6:\"158605\";i:36;s:6:\"155915\";i:37;s:6:\"154197\";i:38;s:6:\"107861\";i:39;s:6:\"137409\";i:40;s:6:\"132485\";i:41;s:6:\"121593\";i:42;s:6:\"123482\";i:43;s:6:\"119575\";i:44;s:6:\"116486\";i:45;s:6:\"112702\";i:46;s:6:\"112115\";i:47;s:6:\"111268\";i:48;s:6:\"106060\";i:49;s:6:\"104245\";i:50;s:5:\"86585\";i:51;s:6:\"101055\";i:52;s:6:\"100785\";i:53;s:5:\"84365\";i:54;s:5:\"83041\";i:55;s:6:\"184326\";i:56;s:6:\"182039\";i:57;s:6:\"181041\";i:58;s:6:\"118154\";i:59;s:6:\"174563\";i:60;s:6:\"172071\";i:61;s:6:\"168261\";i:62;s:6:\"128606\";i:63;s:6:\"164705\";i:64;s:6:\"163381\";i:65;s:6:\"158605\";i:66;s:6:\"155915\";i:67;s:6:\"154197\";i:68;s:6:\"107861\";i:69;s:6:\"137409\";i:70;s:6:\"132485\";i:71;s:6:\"121593\";i:72;s:6:\"123482\";i:73;s:6:\"119575\";i:74;s:6:\"116486\";i:75;s:6:\"112702\";i:76;s:6:\"112115\";i:77;s:6:\"111268\";i:78;s:6:\"106060\";i:79;s:6:\"104245\";i:80;s:5:\"86585\";i:81;s:6:\"101055\";i:82;s:6:\"100785\";i:83;s:5:\"84365\";i:84;s:5:\"83041\";i:85;s:6:\"211217\";i:86;s:6:\"208630\";i:87;s:6:\"210383\";i:88;s:6:\"209635\";i:89;s:6:\"209970\";i:90;s:6:\"207829\";i:91;s:6:\"207755\";i:92;s:6:\"207236\";i:93;s:6:\"207214\";i:94;s:6:\"206655\";i:95;s:6:\"203893\";i:96;s:6:\"201275\";i:97;s:6:\"200080\";i:98;s:6:\"196977\";i:99;s:6:\"182391\";i:100;s:6:\"196980\";i:101;s:6:\"196164\";i:102;s:6:\"194762\";i:103;s:6:\"193476\";i:104;s:6:\"161085\";i:105;s:6:\"189190\";i:106;s:6:\"188886\";i:107;s:6:\"179480\";i:108;s:6:\"104295\";i:109;s:6:\"186513\";i:110;s:6:\"184326\";i:111;s:6:\"182039\";i:112;s:6:\"181041\";i:113;s:6:\"118154\";i:114;s:6:\"174563\";i:115;s:6:\"172071\";i:116;s:6:\"168261\";i:117;s:6:\"128606\";i:118;s:6:\"164705\";i:119;s:6:\"163381\";i:120;s:6:\"158605\";i:121;s:6:\"155915\";i:122;s:6:\"154197\";i:123;s:6:\"107861\";i:124;s:6:\"137409\";i:125;s:6:\"132485\";i:126;s:6:\"121593\";i:127;s:6:\"123482\";i:128;s:6:\"119575\";i:129;s:6:\"116486\";i:130;s:6:\"112702\";i:131;s:6:\"112115\";i:132;s:6:\"111268\";i:133;s:6:\"106060\";i:134;s:6:\"104245\";i:135;s:5:\"86585\";i:136;s:6:\"101055\";i:137;s:6:\"100785\";i:138;s:5:\"84365\";i:139;s:5:\"83041\";}}i:3;a:1:{i:2;a:0:{}}}' WHERE searchlogid = 369857 SELECT template FROM vb_template WHERE templateid = 33969 SELECT template FROM vb_template WHERE templateid = 33972 SELECT template FROM vb_template WHERE templateid = 33973 UPDATE vb_session SET lastactivity = 1714251012, location = '/tags.php?tag=tdi', badlocation = 0 WHERE sessionhash = '89b09ea72d98f52be145b3e37d4a3538'