public static function regenerateAllWordLetters()
{
SqlDeleteRows('delete from word_letter', array());
$words = SqlFetchRows("select * from word", array());
SqlEchoOn();
foreach ($words as $thisWord) {
Learn::generateWordLetters($thisWord);
}
}
public function pageClear()
{
SqlDeleteRows("delete from board_cell", array());
}
public function saveCells($cells)
{
SqlBeginTransaction();
SqlDeleteRows("delete from board_cell where board_id = :boardId", array('boardId' => $this->id));
foreach ($cells as $rowNum => $thisRow) {
foreach ($thisRow as $colNum => $letter) {
if ($letter) {
SqlInsertRow("insert into board_cell (board_id, row_num, col_num, letter)\n\t\t\t\t\t\t\t\t\tvalues (:boardId, :rowNum, :colNum, :letter)", array('boardId' => $this->id, 'rowNum' => $rowNum, 'colNum' => $colNum, 'letter' => trim(strtoupper($letter))));
}
}
}
SqlCommitTransaction();
}
