>>192832 If the shell is seen as more of a coat than part of his body it makes it looks like his body tapers upwards, with super wide hips. The shape of the mouth and maybe eyes could also be looking feminine.
>>192835 >The shape of the mouth This is what I think anon was seeing. Full lips are seen as a feminine trait (see: duck face, woo~oo). The hair, which I guess is meant to be a mohawk of sorts, can be seen as a ponytail and the long eyebrows also add to the idea. Lacking more obvious masculine traits (like a six pack+pecs), a person seeing this without knowing the character would easily think female.
>>198385 when I play the game I'm going to have Shantae, Shovel knight and Zone-Tan on my team but only if they can be on my team and there not just npcs that you talk to and that's it cause that would suck
>>198466 Zone, Best Friends Play, other 'big names' on the internet have been heavily involved in getting this game funded or otherwise doing stuff for it.
http://imgur.com/gallery/jf1Pj
Something that relates to those two in particular, looks like The Baz is back once again.
>>198541 There's so many cool looking party members I'm not sure how I'll manage to deal with that
Kinda drifting towards Naga Rider, Shovel Knight & Annie. Though I also like Phoebe the giant barbarian woman that fires actual spears using her bow or Vasco the Cowboy Conquistador gunslinging with his custom rifle.
>>198545 I think it was the Zaibatsu who said almost all of the characters could be the protagonist of their own game if they could and I agree. It's a lot easier to count the characters I don't care for than the ones I love.
>>198491 And yet Zone-Tan is somehow one of the LEAST obnoxious and out-of-place backer characters forced into a cameo during the game. What a shitshow that game turned out to be.
SELECT b.*,
ppass.`password`, (
SELECT GROUP_CONCAT(DISTINCT `kobaboardban`.`boardid` ORDER BY `kobaboardban`.`boardid` SEPARATOR ',')
FROM `kobaboardban` WHERE `banid` = b.`id` GROUP BY `banid`
) AS `active_boards`
FROM `kobaban` as b
LEFT JOIN `kobafingerprint` fp ON b.`fingerprint_id` = fp.`id`
LEFT JOIN `kobapostpassword` ppass ON b.`password_id` = ppass.`id`
WHERE (
(`iplong1` = 'd849d8d8')
OR
(`iplong1` <= 'd849d8d8' AND 'd849d8d8' <= `iplong2`)
)
AND `type` IN(-1,0,1,2,3)
AND (b.`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.09742498
SELECT p.*,
ppass.`password`,
ipinfo.`ipmd5`, ipinfo.`ipcrypt`,
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.pagenumber, 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
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`
LEFT JOIN `kobapostpassword` ppass ON p.`password_id` = ppass.`id`
LEFT JOIN `kobaipinfo` ipinfo ON p.`ip_id` = ipinfo.`id`
WHERE
p.`boardid` = '3'
AND p.`postid` = '187306'
AND p.`parentid` = '0'
AND p.`deleted` != '1'
UNION ALL
SELECT p.*,
ppass.`password`,
ipinfo.`ipmd5`, ipinfo.`ipcrypt`,
r.time r_time, r.reason r_reason, r.ipmd5 r_ipmd5, r.ipcrypt r_ipcrypt, r.password r_password, r.userid r_userid,
null as pagenumber, null as total_posts, null as total_files, null as total_image, null as total_audio, null as total_video, null as total_swf, null as unique_ip, null as unique_user
FROM `kobapost` p
LEFT JOIN `kobareport` r ON p.`boardid` = r.`boardid` and p.`postid` = r.`postid`
LEFT JOIN `kobapostpassword` ppass ON p.`password_id` = ppass.`id`
LEFT JOIN `kobaipinfo` ipinfo ON p.`ip_id` = ipinfo.`id`
WHERE
p.`boardid` = '3'
AND p.`parentid` = '187306'
AND p.`deleted` != '1'
no error (prepared query)
time taken: 0.07068801
SELECT pf.`pfid`, pf.`order`, pf.`filename`, pf.`thumb`, f.*
FROM `kobapostfile` pf
LEFT JOIN `kobafile` f ON pf.`fileid` = f.`id`
WHERE (pf.`pfid`) IN(
SELECT * FROM(
SELECT p.`id`
FROM `kobapost` p
LEFT JOIN `kobareport` r ON p.`boardid` = r.`boardid` AND p.`postid` = r.`postid`
LEFT JOIN `kobapostfile` pf ON p.`id` = pf.`pfid`
LEFT JOIN `kobafile` f ON pf.`fileid` = f.`id`
LEFT JOIN `kobapostpassword` ppass ON p.`password_id` = ppass.`id`
LEFT JOIN `kobaipinfo` ipinfo ON p.`ip_id` = ipinfo.`id`
WHERE
p.`boardid` = '3'
AND p.`postid` = '187306'
AND p.`parentid` = '0'
AND p.`deleted` != '1'
) as sub)
UNION ALL
SELECT pf.`pfid`, pf.`order`, pf.`filename`, pf.`thumb`, f.*
FROM `kobapostfile` pf
LEFT JOIN `kobafile` f ON pf.`fileid` = f.`id`
WHERE (pf.`pfid`) IN(
SELECT * FROM(
SELECT p.`id`
FROM `kobapost` p
LEFT JOIN `kobareport` r ON p.`boardid` = r.`boardid` and p.`postid` = r.`postid`
LEFT JOIN `kobapostfile` pf ON p.`id` = pf.`pfid`
LEFT JOIN `kobafile` f ON pf.`fileid` = f.`id`
LEFT JOIN `kobapostpassword` ppass ON p.`password_id` = ppass.`id`
LEFT JOIN `kobaipinfo` ipinfo ON p.`ip_id` = ipinfo.`id`
WHERE
p.`boardid` = '3'
AND p.`parentid` = '187306'
AND p.`deleted` != '1'
) as sub)
no error (prepared query)
time taken: 0.00950289
SELECT `boardid`, `parentid`, `postid` FROM `kobapost` WHERE
(`boardid` = 3 AND `postid` IN(191820,191820,192460,192831,195561,198427,202227,417969,417970,417969,417970,433671,433672,433673,433674))
AND `deleted` != 1