ini_set('include_path', ini_get('include_path') . PATH_SEPARATOR . realpath('PEAR')); require_once 'Connections/conn.php'; require_once 'Games/Chess/Standard.php'; include_once 'functions.php'; include_once 'Chess.class.php'; $standard = new Games_Chess_Standard(); $fen = !empty($_GET['fen']) ? $_GET['fen'] : ''; $standard->resetGame($fen); $toMove = $standard->toMove(); $renderFen = $standard->renderFen(); if (empty($fen)) { //start of the game, find the first move: $chess = new Chess(); $move = $chess->find($renderFen); $from = substr($move, 0, 2); $to = substr($move, 2, 2); $move2 = $standard->_convertSquareToSAN($from, $to); $standard->moveSquare($from, $to); $renderFen = $standard->renderFen(); mysql_select_db($database_conn, $conn); $query_rsView = sprintf("SELECT * FROM games WHERE move = %s and fen = %s and moveby = %s", GetSQLValueString($move2, "text"), GetSQLValueString($renderFen, "text"), GetSQLValueString($toMove, "text")); $rsView = mysql_query($query_rsView, $conn) or die(mysql_error()); $totalRows_rsView = mysql_num_rows($rsView); if ($totalRows_rsView == 0) { $query = sprintf("INSERT INTO games SET pid = 0, move = %s, fen = %s, moveby = %s, result = ''", GetSQLValueString($move2, "text"), GetSQLValueString($renderFen, "text"), GetSQLValueString($toMove, "text")); $rs = mysql_query($query, $conn) or die(mysql_error()); } } echo 'done'; exit;