/** * check item * @param string $size * @param string $matrix */ public static function hwdoku_check_item($size, $matrix) { global $wpdb; if (empty($size)) { $size = self::getSize(); } //get sudoku size $matrix = unserialize($matrix); $i = $_GET['i']; $j = $_GET['j']; $a = $_GET['a']; #echo $size; $game1 = new HQ_Sudoku($size); $game1->grid = $matrix; $valid = $game1->valid_item($i, $j, $a); if ($valid) { $game1->set_item($i, $j, $a); //save to db try { $exists = $wpdb->get_var('select count(*) from ' . HWDOKU_DB_TABLE); if (!$exists) { $wpdb->insert(HWDOKU_DB_TABLE, array('grid' => $game1->matrix_string())); } else { $query = $wpdb->prepare("UPDATE " . HWDOKU_DB_TABLE . " SET grid = %s LIMIT 1", $game1->matrix_string()); $wpdb->query($query); } } catch (Exception $err) { } //$db->query("update sudoku set grid='".$game1->matrix_string()."'"); echo '<textarea>' . $game1->matrix_string() . ($game1->is_full_matrix() ? '[DONE]' : '') . '</textarea>'; echo '<script>hwdoku_debug("' . valid_str_in_str($game1->suggest_result(false, 'ok')) . '");</script>'; exit; } else { //out1($i.'-'.$j); $game1->remove_item($i, $j); echo '<textarea>' . $game1->matrix_string() . '[FALSE]</textarea>'; #exit(); } }
$matrix = unserialize($_GET['matrix']); $i = $_GET['i']; $j = $_GET['j']; $a = $_GET['a']; echo $size; $game1 = new HQ_Sudoku($size); $game1->grid = $matrix; $valid = $game1->valid_item($i, $j, $a); if ($valid) { $game1->set_item($i, $j, $a); //save to db $db = new mysql('sql311.summerhost.info', 'sum_6305668', '1671988'); $db->db('sum_6305668_test'); $db->query("update sudoku set grid='" . $game1->matrix_string() . "'"); echo '<textarea>' . $game1->matrix_string() . ($game1->is_full_matrix() ? '[DONE]' : '') . '</textarea>'; echo '<script>test.get_line(1).content("' . valid_str_in_str($game1->suggest_result(false, 'ok')) . '");</script>'; exit; } else { //out1($i.'-'.$j); $game1->remove_item($i, $j); echo '<textarea>' . $game1->matrix_string() . '[FALSE]</textarea>'; exit; } } elseif ($_GET['do'] == 'suggest_item') { $i = $_GET['i']; $j = $_GET['j']; $matrix_origin = unserialize($_GET['matrix_origin']); $matrix = unserialize($_GET['matrix']); //compare with matrix original to get item $game1 = new HQ_Sudoku($size); $game1->grid = $matrix_origin;