>>424100 Steve Jobs did not want to pay Adobe licensing fees, so they never bothered to implement it on the iPhone and instead declared the format as dead and replaced with HTML5 (good fucking luck with that). Adobe never really bothered fighting it, and eventually dropped all support for the browser plugin a year or two back.
Looks like Steam Summer Sale dates have been leaked, and they're a bit early compared to previous years: http://www.ign.com/articles/2015/05/29/steam-summer-sale-2015-dates-leak >The Steam Summer Sale will begin on June 11 and last until June 20, according to a prematurely-revealed social post. Funny gif that is too big to upload here: http://media.giphy.com/media/3oEduNiXJuU6biIYda/giphy.gif
save fileimage:144664129500.png(322kB , 512x512 , fallout_4_png_icon_by_s7_by_sidyseven-d9acz5n.png)
So although there seems to be an agreement on this game looking awful, discussion in the General thread seems enough to merit a containment thread. This is that thread.
For all those Terraria lovers out there, this is where you can now express yourself! Rules go as follows: No Minecraft No Stardew Valley No StarBound I always loved Terraria. Here you can share your ideas on new bosses, weapons, armors, ect. And give feedback to people who are still trying to master this complex, sandbox game! Share your experiences in Terraria and remember, Memes are always allowed!!!
I'm terrible at this game and I mean that. Just the fucking worst, but I've found myself a nice little cycle to beat it.
Basically, I'm playing it with my brother and he's really good at every video game ever. So, he advances the game and gets rare and boss items and I handle getting the grindier stuff. It's produced a neat little cycle where we just give each other presents to move further and further through the game. We're gearing up to face the Moon Lord now.
I guess I'll also ask what everyone's favorite playstyle is, too. I like summoner because it lets me tag something and then focus on getting the fuck out of the way. I end up gearing all the stats toward defense and speed. Melee is definitely the easiest, though.
>>423870 I'm not a fan of multiplayer games so back when I played this would just do everything myself. That was so long ago there wasn't half the content there is now.
Can't remember what weapons I favoured, my home base was basically a tower that reached all the way up to the stratosphere and had a gap tunnel/dry moat beneath it to prevent enemies from getting in because I was worried about all the NPCs getting hurt. Also carved out a massive tunnel lined with glass along the map beneath it in both directions thick enough to stop Corruption from getting spread to it.
Wouldn't mind owning a Byleth Amiibo to go with the new three houses game that is coming out in a few months. But it would set me back almost 30 bucks so can't really see myself stretching for it.
>>419177 I don't play City of Heroes Homecoming anymore but have a compulsive need to log into my account semi-regularly and just check my characters. Its some kind of sickness.
South Park Gaming thread, from the new RPGs to the classic first-person shooter. All are welcome.
Personally I've gotten ridiculously hyped over Fractured But Whole, makes me keep browsing the same information about it over and over again. If anyone has something new then share it, need to scratch that itch.
I'd be hesitant to buy a third South Park RPG, because the endgame of Fractured But Whole was bad.
The rest of the game was fairly good, but the lame Cartman bullshit just dragged on and on and made the whole final part of the game deeply unsatisfying/tedious. The expansions stuff in comparison was good too.
Also the show has been pretty poor for awhile, the pair have lost their touch when it comes to writing.
Read back over this thread and it was kind of eerie, seeing people talk about Two/Super Best Friends so much from before the break up.
Just recently Pat moved all the way across to the other side of Canada with his wife so he's not even in the same city as the rest. Though him and Woolie still do their podcast, since they got a remote setup going-on for a long time due to Covid.
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(3) )
OR `global` = 1)
ORDER BY `type`,`expiration` DESC
no rows found or affected (prepared query)
time taken: 0.00117087
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` = 3 AND p.`parentid` = 0
AND p.`deleted` = 0
ORDER BY
`pin` desc,
`bumped` desc
LIMIT 30, 15
no error
time taken: 0.02153778
((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` = '3' AND p.`parentid` = '417668'
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` = '3' AND p.`parentid` = '421055'
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` = '3' AND p.`parentid` = '195313'
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` = '3' AND p.`parentid` = '198105'
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` = '3' AND p.`parentid` = '419379'
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` = '3' AND p.`parentid` = '422100'
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` = '3' AND p.`parentid` = '196330'
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` = '3' AND p.`parentid` = '419176'
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` = '3' AND p.`parentid` = '200920'
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` = '3' AND p.`parentid` = '191026'
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` = '3' AND p.`parentid` = '199619'
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` = '3' AND p.`parentid` = '418496'
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` = '3' AND p.`parentid` = '419999'
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` = '3' AND p.`parentid` = '419066'
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` = '3' AND p.`parentid` = '418558'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
no error
time taken: 0.00043893
SELECT `boardid`, `parentid`, `postid` FROM `kobapost` WHERE
(`boardid` = 3 AND `postid` IN(202315,187306,417863,417667,419985,423549,423935))
AND `deleted` = 0