I hear there's a football match on this evening, but no one seems to care about it. Oh well, can't be very important then
Too right aswell, whatever the Queen says is bleeding irrelevant anyway but by comparison to actual seismic news.....
The Queen was just showing how racist she is anyway, laying into the poor immigrants right, left and centre. She's obviously been learning from Philip...
So it turns out your reporter mate has as much of an insight into the goings on at Old Trafford as my children's pet hamster does!
Swarbs the site is ****ed this is what I get if click GC or my control panel. Though the abbreviated version. ## $show['threads'] = false; $numthreads = 0; // query thread ids if (!$vbulletin->options['threadmarking']) { if ($vbulletin->userinfo['userid'] AND in_coventry($vbulletin->userinfo['userid'], true)) { $lastpost_info = ", IF(tachythreadpost.userid IS NULL, thread.lastpost, tachythreadpost.lastpost) AS lastposts"; $tachyjoin = "LEFT JOIN " . TABLE_PREFIX . "tachythreadpost AS tachythreadpost ON " . "(tachythreadpost.threadid = subscribethread.threadid AND tachythreadpost.userid = " . $vbulletin->userinfo['userid'] . ')'; $lastpost_having = "HAVING lastposts > " . $vbulletin->userinfo['lastvisit']; } else { $lastpost_info = ''; $tachyjoin = ''; $lastpost_having = "AND lastpost > " . $vbulletin->userinfo['lastvisit']; } $getthreads = $db->query_read_slave(" SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid $lastpost_info FROM " . TABLE_PREFIX . "subscribethread AS subscribethread INNER JOIN " . TABLE_PREFIX . "thread AS thread USING (threadid) $tachyjoin WHERE subscribethread.threadid = thread.threadid AND subscribethread.userid = " . $vbulletin->userinfo['userid'] . " AND thread.visible = 1 AND subscribethread.canview = 1 $lastpost_having "); } else { $readtimeout = TIMENOW - ($vbulletin->options['markinglimit'] * 86400); if ($vbulletin->userinfo['userid'] AND in_coventry($vbulletin->userinfo['userid'], true)) { $lastpost_info = ", IF(tachythreadpost.userid IS NULL, thread.lastpost, tachythreadpost.lastpost) AS lastposts"; $tachyjoin = "LEFT JOIN " . TABLE_PREFIX . "tachythreadpost AS tachythreadpost ON " . "(tachythreadpost.threadid = subscribethread.threadid AND tachythreadpost.userid = " . $vbulletin->userinfo['userid'] . ')'; } else { $lastpost_info = ', thread.lastpost AS lastposts'; $tachyjoin = ''; } $getthreads = $db->query_read_slave(" SELECT thread.threadid, thread.forumid, thread.postuserid, IF(threadread.readtime IS NULL, $readtimeout, IF(threadread.readtime < $readtimeout, $readtimeout, threadread.readtime)) AS threadread, IF(forumread.readtime IS NULL, $readtimeout, IF(forumread.readtime < $readtimeout, $readtimeout, forumread.readtime)) AS forumread, subscribethread.subscribethreadid $lastpost_info FROM " . TABLE_PREFIX . "subscribethread AS subscribethread INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (subscribethread.threadid = thread.threadid) LEFT JOIN " . TABLE_PREFIX . "threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = " . $vbulletin->userinfo['userid'] . ") LEFT JOIN " . TABLE_PREFIX . "forumread AS forumread ON (forumread.forumid = thread
Swarbs the site is ****ed this is what I get if click GC or my control panel. Though the abbreviated version. ## $show['threads'] = false; $numthreads = 0; // query thread ids if (!$vbulletin->options['threadmarking']) { if ($vbulletin->userinfo['userid'] AND in_coventry($vbulletin->userinfo['userid'], true)) { $lastpost_info = ", IF(tachythreadpost.userid IS NULL, thread.lastpost, tachythreadpost.lastpost) AS lastposts"; $tachyjoin = "LEFT JOIN " . TABLE_PREFIX . "tachythreadpost AS tachythreadpost ON " . "(tachythreadpost.threadid = subscribethread.threadid AND tachythreadpost.userid = " . $vbulletin->userinfo['userid'] . ')'; $lastpost_having = "HAVING lastposts > " . $vbulletin->userinfo['lastvisit']; } else { $lastpost_info = ''; $tachyjoin = ''; $lastpost_having = "AND lastpost > " . $vbulletin->userinfo['lastvisit']; } $getthreads = $db->query_read_slave(" SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid $lastpost_info FROM " . TABLE_PREFIX . "subscribethread AS subscribethread INNER JOIN " . TABLE_PREFIX . "thread AS thread USING (threadid) $tachyjoin WHERE subscribethread.threadid = thread.threadid AND subscribethread.userid = " . $vbulletin->userinfo['userid'] . " AND thread.visible = 1 AND subscribethread.canview = 1 $lastpost_having "); } else { $readtimeout = TIMENOW - ($vbulletin->options['markinglimit'] * 86400); if ($vbulletin->userinfo['userid'] AND in_coventry($vbulletin->userinfo['userid'], true)) { $lastpost_info = ", IF(tachythreadpost.userid IS NULL, thread.lastpost, tachythreadpost.lastpost) AS lastposts"; $tachyjoin = "LEFT JOIN " . TABLE_PREFIX . "tachythreadpost AS tachythreadpost ON " . "(tachythreadpost.threadid = subscribethread.threadid AND tachythreadpost.userid = " . $vbulletin->userinfo['userid'] . ')'; } else { $lastpost_info = ', thread.lastpost AS lastposts'; $tachyjoin = ''; } $getthreads = $db->query_read_slave(" SELECT thread.threadid, thread.forumid, thread.postuserid, IF(threadread.readtime IS NULL, $readtimeout, IF(threadread.readtime < $readtimeout, $readtimeout, threadread.readtime)) AS threadread, IF(forumread.readtime IS NULL, $readtimeout, IF(forumread.readtime < $readtimeout, $readtimeout, forumread.readtime)) AS forumread, subscribethread.subscribethreadid $lastpost_info FROM " . TABLE_PREFIX . "subscribethread AS subscribethread INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (subscribethread.threadid = thread.threadid) LEFT JOIN " . TABLE_PREFIX . "threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = " . $vbulletin->userinfo['userid'] . ") LEFT JOIN " . TABLE_PREFIX . "forumread AS forumread ON (forumread.forumid = thread
Swarbs the site is ****ed this is what I get if click GC or my control panel. Though the abbreviated version. ## $show['threads'] = false; $numthreads = 0; // query thread ids if (!$vbulletin->options['threadmarking']) { if ($vbulletin->userinfo['userid'] AND in_coventry($vbulletin->userinfo['userid'], true)) { $lastpost_info = ", IF(tachythreadpost.userid IS NULL, thread.lastpost, tachythreadpost.lastpost) AS lastposts"; $tachyjoin = "LEFT JOIN " . TABLE_PREFIX . "tachythreadpost AS tachythreadpost ON " . "(tachythreadpost.threadid = subscribethread.threadid AND tachythreadpost.userid = " . $vbulletin->userinfo['userid'] . ')'; $lastpost_having = "HAVING lastposts > " . $vbulletin->userinfo['lastvisit']; } else { $lastpost_info = ''; $tachyjoin = ''; $lastpost_having = "AND .readtime IS
Fair enough but those error messages have been highlighted as a issue on the mod board, the other guys were told to clear their cookies and it sorted the problem
Pointless comment. . They are the best phones.. You'd know if you spent more money on your telephonic device.