$MAX_METHOD_ID) { header('HTTP/1.0 404 Not Found'); $EFFECTIVE_ID = $MAX_METHOD_ID; } #$MTIME = mysqli_query($link,"SELECT UNIX_TIMESTAMP(MAX(pd)) # FROM (SELECT MAX(pubdate) AS pd FROM fredart # UNION SELECT published AS pd FROM strip WHERE id = $EFFECTIVE_ID # UNION SELECT MAX(published) AS pd FROM rant) t") or die(mysqli_error($link)); #conditional_exit(current(mysqli_fetch_row($MTIME))); $STRIP = load_strip($EFFECTIVE_ID) or term(410); $TRANSCRIPT = load_transcript($EFFECTIVE_ID); $HAS_TRANSCRIPT = mysqli_num_rows($TRANSCRIPT) > 0; $CONTROLS = load_nav_controls(); #$STATUS = load_status(); $FREDART = load_fredart(); $RANT['left'] = load_rant($EFFECTIVE_ID, 'left'); $RANT['right'] = load_rant($EFFECTIVE_ID, 'right'); header("XX-Powered-By: Taiyaki"); flock(fopen(SITE_PATH_ABS.'/'.SITE_STRIP.'/'.SITE_STRIP_LOCK, 'r'), LOCK_SH) or trigger_error('Down for maintenance. Try again in a moment. (Bad lock)', E_USER_ERROR); if(isset($_GET['strip_id']) || isset($_GET['transcript_id'])) pagehead('index', "[$EFFECTIVE_ID] " . numeric_entities(utfentities($STRIP['title']))); else pagehead('index'); ?>
    1) echo "
  • Prev
    • '; else echo '
  • Prev
    • '; if($EFFECTIVE_ID < $MAX_METHOD_ID) echo "
  • Next
    • '; else echo '
  • Next
    • '; ?>
""
'); } else { printf('%s', SITE_STRIP, $EFFECTIVE_ID, $STRIP['ext'], $alttext, utfentities($tooltip)); } ?>
    Panel $panel:
    "; # Print out all speaking characters if(strlen($line[2]) > 0) { $has_speakers = true; do { echo "
    $line[1]:
    ".($line[2] ? utfentities($line[2]) : ' ').'
    '; } while(($line = mysqli_fetch_row($TRANSCRIPT)) && $line[0] == $panel && strlen($line[2]) > 0); } # Given an "also shown" list if there is at least one silent character if($line && $line[0] == $panel && strlen($line[2]) == 0) { echo '
    ', ($has_speakers ? 'Also' : 'Characters'), ' shown:
    '; $also = Array(); do { array_push($also, $line[1]); } while(($line = mysqli_fetch_row($TRANSCRIPT)) && $line[0] == $panel); sort($also, SORT_STRING); echo '
    ' . join(', ', $also) . '
    '; } echo '
    '; } ?>
    1) echo "
  • Prev
    • '; else echo '
  • Prev
    • '; if($EFFECTIVE_ID < $MAX_METHOD_ID) echo "
  • Next
    • '; else echo '
  • Next
    • '; ?>
    1 ) echo '
  • ', '', '
    • '; else echo '
  • Find Next
    • '; if($EFFECTIVE_ID < $MAX_METHOD_ID) echo '
  • ', '', '
    • '; else echo '
  • Find Next
    • '; ?>
Search: help
Within: $controls) { foreach($controls as $control) { printf('', $name, $control, $control); } } ?>

newsbox

A Fredart banner S-Words
  • Megatokyo Twitter
  • Megatokyo RSS feed
  • Fred's Twitter
  • Fredart RSS Feed

support

Advertise on Megatokyo!

MegaTokyo Visual Novel

console

r.published AND r1.published < NOW() ORDER BY r1.published ASC LIMIT 1 ) AS next"; $rantinfo = "rant r JOIN media_t m ON m.id = r.imagetype JOIN contributor c ON c.id = r.author JOIN strip s"; $rantlimit = "( r.side = '$side' AND r.published < NOW() AND r.status = 'published' AND s.id = $id )"; # Create a window of previous days' rants on the most recent strip if($MAX_METHOD_ID == $EFFECTIVE_ID) $rantwindow = "UNION DISTINCT (SELECT $parameters FROM $rantinfo WHERE $rantlimit AND DATEDIFF(NOW(), r.published) < " . RANT_DATE_WINDOW . ')'; $lookahead = mysqli_query($link,"( SELECT $parameters FROM $rantinfo LEFT JOIN strip sn ON sn.id = s.id + 1 WHERE $rantlimit AND ( s.id = $id AND r.published >= s.published) AND ( r.published < sn.published OR sn.published IS NULL ) ) $rantwindow ORDER BY published DESC") or die(mysqli_error($link)); if(mysqli_num_rows($lookahead) > 0) return $lookahead; $lookbehind = mysqli_query($link,"(SELECT $parameters FROM $rantinfo WHERE $rantlimit AND r.published < s.published ORDER BY r.published DESC LIMIT 1) $rantwindow ORDER BY published DESC") or die(mysqli_error($link)); return $lookbehind; } function load_status() { global $link; //"%a %c.%d.%Y [%I:%i %p EST (-5 GMT)]" $qr = mysqli_query($link,'SELECT UNIX_TIMESTAMP(published) as udate, DATE_FORMAT(published, "%a %c.%d.%Y [%I:%i %p EST (-5 GMT)]") AS published, DATE_FORMAT(eta, "%a %c.%d.%Y [%I:%i %p EST (-5 GMT)]") AS eta, percentage, text FROM status ORDER BY udate DESC LIMIT 1') or die(mysqli_error($link)); return mysqli_fetch_assoc($qr); } function show_rantcol($side) { global $RANT, $link; ?>

< >

%s', $rant['link'], SITE_RANT, $rant['rantnum'], $rant['extension'], utfentities($rant['alttext']), utfentities($rant['alttext'])) ?>

""

', date('l - F j, Y', $rant['date']), '

'?> [%s] - %s - [link here]

', $rant['email'], $rant['author'], date('H:i:s', $rant['date']), $rant['rantnum']) ?>
previous rant]"; } echo ' - [rant archive]'; if($rant['next'] && $rant['prev']) { echo ' - '; } if($rant['next']) { echo "[next rant]"; } ?>

%s', $rant['link'], SITE_RANT, $rant['rantnum'], $rant['extension'], utfentities($rant['alttext']), utfentities($rant['alttext'])) ?>

< >

""

', date('l - F j, Y', $rant['date']), '

'?> [%s] - %s - [link here]

', $rant['email'], $rant['author'], date('H:i:s', $rant['date']), $rant['rantnum']) ?>
previous rant]"; } echo ' - [rant archive]'; if($rant['next'] && $rant['prev']) { echo ' - '; } if($rant['next']) { echo "[next rant]"; } ?>
$lines) { if(!is_numeric($panel)) continue; $idx = array_push($transcript, Array()) - 1; foreach($lines as $line) { array_push($transcript[$idx], $line['speaker']); if($line['speech']) array_push($transcript, wordwrap("\t$line[speaker]:\t$line[speech]", 80, "\n\t\t")); } $transcript[$idx] = "Panel $panel: " . implode(', ', array_unique($transcript[$idx])); } return implode("\n", $transcript); } function numeric_entities($string){ $mapping = array(); foreach (get_html_translation_table(HTML_ENTITIES, ENT_QUOTES) as $char => $entity){ $mapping[$entity] = '&#' . ord($char) . ';'; } return str_replace(array_keys($mapping), $mapping, $string); } ?>