#!/usr/bin/php
<?php
$dbh=new PDO("sqlite:katawa.sqlite");

$stm=$dbh->prepare("SELECT data,color,name FROM seqtext,character WHERE elid=cid AND seqid=28 AND type=1");

$stm->execute();
echo "var data = [";
$flag=0;
while($row=$stm->fetch()) {
    if ($flag) echo ",\n   ";
    $text=str_replace('"','\"',$row["data"]);
    echo '"' . $row["color"]."|".$row["name"]."|".$text .'"';
    $flag=1;
}
echo "];";

?>