An important thing that must be remembered, since particular companies go out of their way to remove Roms from existence of games they will never go back to thus depriving people of a chance to experience them.
This goes double for games that were never translated and thus you only ever had a chance to play through fan-translation-patches. Anyone have personal stories when it comes to that? Live A Live was mine, in the process became one of my favorite rpgs now. https://fantasyanime.com/legacy2/live_about.htm
... message too long. Click here to view the full post.
Look at this shit >What dangers #game emulation brings to the gaming industry, how can you, a developer, be impacted, and how can you prevent it from negatively affecting your business? Download our free e-book (fuck your link denuvo)e-book-the-threats-of-game-emulation-are-you-worried-enough/ >#Denuvo #Irdeto #Cybersecurity #Gaming #ProtectYourGames
>>424482 This is official art, but seeing the Master sword all broken and melted away sort of loses impact with how dirty it was done in the previous Breath of the Wild just so they could cram in that mechanic of carting around a whole assload of breakable weapons. I've lost faith in the master sword and its credibility so its much less shocking.
What if they made a Zelda game that was a party-based RPG?
Or if instead of a Dynasty Warriors-style game they made a LoZ game that also involved Link and Zelda using an army to beat the villains forces instead of him doing it alone but in the tactical/strategy genre?
This looks like an interesting game. Both as in it looks like it might be interesting to play and quite literally in the odd style of retro aesthetic the graphics are done in.
>>420295 Primarily dwarf parties would be a cool thing to see more of in fantasy media. It makes it strange mentioning Tolkien that it caused focused elfwanking to take off when the previous story of the Hobbit was mostly dwarfs and then one hobbit with guest appearances by Gandalf. But then again its not like they were portrayed as cool and competent adventurers/heroes unlike the members of the fellowship or tolkien elves in general.
Mario's adventure is gonna get odd or I basically copy pasted this from the Nintendo gen on /vg/ edition old thread here ==> >>199859 Switch Presentation Here: //youtube.com/watch?v=uuC4YLLkqME Nintendo Switch Treehouse Stream Here: //youtube.com/watch?v=qadzCB3CLlI Learn More about the Switch's Features here: http://www.nintendo.com/switch/
... message too long. Click here to view the full post.
Just remembered, the other thing that bothers me is that the sequel to Breath of the Wild was originally planned for both consoles before it was delayed. If a pandemic delays development, I say it should also delay discontinuations.
Warhammer Non-Specific: a thread for all things Warhammer. From fantasy to 40k. Vidya to roleplaying. Post it here. Especially miniatures. If you have 'em, post 'em. Other peoples cool models is fine too.
Let's have a thread about our favorite game characters. Talk about whatever characters you like. You got a definitive favorite character /cog/? For me, it's Snake with Francis York Morgan and Dante close behind.
>>424623 Ulysses was an interesting concept but was executed really poorly. His reasoning felt more petty than anything. Graham and Elijah were way better. He had an amazing voice at least.
As the Subject line indicates this is a thread for mentioning and discussing vidya that have explicit sexual, erotic and overall pornographic content.
I feel they've become much more mainstream in more recent years with things like porno games with actual budgets and gameplay appearing on heavily used digital marketplaces like Steam.
Corruption of Champions is a mostly text-based erotic game and CoC2 appearing on Steam is an instance of something that caught me extremely offguard considering the degenerate content of them
There's nothing wrong with porno games in a general sense and they should be openly sold, but there is one downside into them being added to a mainstream marketplace like Steam. Specifically that it has led to such an increase in the tide of cheap low-effort shovelware being dumped into the listings, with the fact that poorly animated sex or still images of bitches naked/being fucked is its only selling point, where you can tell from even just seeing the name and store icon alone the lack of quality due to them all sharing the same commonalities.
Since someone wanted a Doom thread lets get one read in preparation for Eternal, this is a haven for all Doom related discussion or posting of music and images.
Random thought; you gotta feel bad about the Elite Guards from Doom 2016 that serve as a source of upgrades for the player. They were cyborg super soldiers and the best chance on the base at fighting off the demons, but because they were such badasses their cybernetics included a kill switch in case of mutiny... which meant they were easily killed off by the same person letting the demons in.
You never see any of them possessed and their bodies are in much better condition than other corpses, just slumped over in pools of their own blood.
Honestly random indie monster catching games you can find on places like Steam are often a better idea than buying new instalments of Pokemon, if you need to scratch the itch.
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` = '03eefa49')
OR
(`iplong1` <= '03eefa49' AND '03eefa49' <= `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.00116086
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 0, 15
no error
time taken: 0.01238608
((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` = '424357'
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` = '419440'
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` = '187919'
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` = '422936'
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` = '421442'
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` = '424094'
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` = '187573'
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` = '201563'
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` = '421180'
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` = '199922'
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` = '422584'
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` = '420299'
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` = '417979'
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` = '197677'
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` = '422513'
AND p.`deleted` = '0'
ORDER BY `postid` DESC
LIMIT 3)
)
no error
time taken: 0.00047994
SELECT `boardid`, `parentid`, `postid` FROM `kobapost` WHERE
(`boardid` = 3 AND `postid` IN(199859,418496,191026,421055,420735,420295,424482,424568,424560,422845,424503,424630,424382))
AND `deleted` = 0