Ever since I gave Tiki advice on getting a new desktop, I've been wanting to share my experience with how my own build went, and I figure I ought to do that already.
I think I got a pretty solid design here: http://pcpartpicker.com/p/ZWHvRB Portability since I want to lug it between my parent's houses, decent in most areas of performance, very solid power supply, damage resistant motherboard. Unfortunately I hadn't ordered anything online before, and asked my mom for help. After some confusion with credit cards, we ended up going with a different case, this one to be exact: http://pcpartpicker.com/part/silverstone-case-sstps07b
... message too long. Click here to view the full post.
Why nobody told me intel had a new gayming nuc? This looks good but I don't think I'll ever buy it //youtube.com/watch?v=rOTKgvPUXN8 Still really cool to look at.
>>405822 People change and are willing to do or say things in anonymity they otherwise wouldn't. As I recall she was the most hardline "kill all men" feminist on here while WITH a name.
ah the good old "sweden changed the legal definition of rape to be much broader and therefore has 'more' than most countries but I'm not going to explain that part" move
One of the best TPS I've ever played, I've been playing this in the last 10 years and this game never gets old. It's amazing all the different things you can do and the different game modes you can play.
"EuroGunZ - GunZ The Duel" left the game (VAC banned)
Politics Thread #17: “We’re All Going to Fucking Die” Edition Previous Thread:>>413917
Between Ol’ 45’s desire to use nukes, North Korea’s launching of missiles, and the rolling back of environmental regulations, we are basically one disaster away from living in a goddamned wasteland. So…yeah.
Wallpaper thread. This is a general purpose thread for computer and phone wallpapers. I'm generally going to post 1680-1050 and 480-800 rez wallpapers, but other resolutions are fine too.
SELECT *, (
SELECT GROUP_CONCAT(DISTINCT `kobaboardban`.`boardid` ORDER BY `kobaboardban`.`boardid` SEPARATOR ',')
FROM `kobaboardban` WHERE `banid` = `id` GROUP BY `banid`
) AS `active_boards`
FROM `kobaban`
WHERE (
(`iplong1` = '22efad90')
OR
(`iplong1` <= '22efad90' AND '22efad90' <= `iplong2`)
)
AND `type` IN(-1,0,1,2,3)
AND (`id` IN ( SELECT `banid` FROM `kobaboardban` WHERE `boardid` IN(1) )
OR `global` = 1)
ORDER BY `type`,`expiration` DESC
no rows found or affected (prepared query)
time taken: 0.00149512
SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid,
s.total_posts, s.total_files, s.total_image, s.total_audio, s.total_video, s.total_swf, s.unique_ip, s.unique_user
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`, `pin`, `bumped`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
LEFT JOIN `kobapoststats` s on p.boardid = s.boardid and p.postid = s.threadid
WHERE p.`boardid` = 1 AND p.`parentid` = 0
AND p.`deleted` = 0
ORDER BY
`pin` desc,
`bumped` desc
LIMIT 90, 15
no error
time taken: 0.01016593
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '416944'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '394729'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '416703'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '405206'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '416805'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '415631'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '415829'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '416472'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '414457'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '411618'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '413917'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '409421'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '411252'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '413356'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
UNION ALL
((SELECT p.*,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid
FROM `kobapost` p
USE INDEX(`boardid`, `parentid`, `deleted`)
LEFT JOIN `kobareport` r on p.boardid = r.boardid and p.postid = r.postid
WHERE p.`boardid` = '1' AND p.`parentid` = '412886'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
no error
time taken: 0.00060081
SELECT `boardid`, `parentid`, `postid` FROM `kobapost` WHERE
(`boardid` = 1 AND `postid` IN(405822,392080,407369,412572,413414,413913,415292,415537,415839,416461))
AND `deleted` = 0