Relevant Tables

mysql> use chessBase
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> show tables;
+————————+
| Tables_in_chessBase    |
+————————+
| mcc_article            |
| mcc_email_token        |
| mcc_game               |
| mcc_game_cache         |
| mcc_history_connection |
| mcc_history_score      |
| mcc_invitation         |
| mcc_move               |
| mcc_note               |
| mcc_player             |
| mcc_player_portrait    |
+————————+
11 rows in set (0.00 sec)

Another GUN Chess Example

Black (1) : post
Black (1) : easy
Black (1) : new
White (1) : depth 6
Search to a depth of 6
White (1) : go
Thinking…
Root = -10, Phase = 1 Depth = 6
Ply   Time     Eval      Nodes   Principal-Variation
 1.   0.00     62        20      e4
 2&   0.00    -10        60      e4 e5
 2.   0.00    -10       133      e4 e5
 3&   0.00     34       397      e4 d5 Nc3 dxe4 Nxe4
 3&   0.00     41       553      d4 d5 Nf3
 3.   0.00     41       631      d4 d5 Nf3
 4&   0.00    -10       872      d4 d5 Nf3 Nf6
 4&   0.01     -3      2217      e4 Nf6 Nc3 d5 exd5 Nxd5
 4.   0.01     -3      2583      e4 Nf6 Nc3
 5&   0.03    -10      7612      e4 d5 exd5 Qxd5 Nc3 Qe5+ Be2
 5&   0.04     13      9514      d3 d5 Nc3 Nf6 Nf3
 5&   0.04     40     12761      d4 d5 Nf3 Nf6 Nc3
 5.   0.05     40     14715      d4 d5 Nf3 Nf6 Nc3
 6&   0.07    -10     19152      d4 d5 Nf3 Nf6 Nc3 Nc6
 6&   0.16     -9     48987      e4 Nc6 d4 Nf6 d5
 6.   0.16     -9     48987      e4 Nc6 d4 Nf6 d5
 
Time = 0.2 Rate=297245 Nodes=[44779/4208/48987] GenCnt=49817
Eval=[15547/21899] RptCnt=0 NullCut=1313 FutlCut=3679
Ext: Chk=813 Recap=169 Pawn=269 OneRep=30 Horz=12 Mate=0 KThrt=35
Material=[3600/3600 : 4400/4400] Lazy=[191/186] MaxPosnScore=[274/238]
Hash: Success=20% Collision=87% Pawn=64%
 
black  KQkq  e3
r n b q k b n r
p p p p p p p p
. . . . . . . .
. . . . . . . .
. . . . P . . .
. . . . . . . .
P P P P . P P P
R N B Q K B N R
 
 
My move is : e4
Black (1) :

GNU chess 5.07 : A Simple Example

Adjusting HashSize to 1024 slots
Transposition table:  Entries=1K Size=40K
Pawn hash table: Entries=0K Size=28K
White (1) : easy
White (1) : new
White (1) : post
White (1) : depth 8
Search to a depth of 8
White (1) : go
Thinking…
Looking for opening book in book.dat…
Looking for opening book in /usr/share/games/gnuchess/book.dat…
Looking for opening book in /usr/lib/games/gnuchess/book.dat…
 No book found.
 
Root = -10, Phase = 1 Depth = 8
Ply   Time     Eval      Nodes   Principal-Variation
 1.   0.00     62        20      e4
 2&   0.00    -10        60      e4 e5
 2.   0.00    -10       133      e4 e5
 3&   0.00     34       397      e4 d5 Nc3 dxe4 Nxe4
 3&   0.00     41       553      d4 d5 Nf3
 3.   0.00     41       631      d4 d5 Nf3
 4&   0.01    -10       872      d4 d5 Nf3 Nf6
 4&   0.01     -3      2217      e4 Nf6 Nc3 d5 exd5 Nxd5
 4.   0.01     -3      2583      e4 Nf6 Nc3
 5&   0.03    -10      7612      e4 d5 exd5 Qxd5 Nc3 Qe5+ Be2
 5&   0.04     13      9514      d3 d5 Nc3 Nf6 Nf3
 5&   0.04     40     12761      d4 d5 Nf3 Nf6 Nc3
 5.   0.05     40     14715      d4 d5 Nf3 Nf6 Nc3
 6&   0.07    -10     19152      d4 d5 Nf3 Nf6 Nc3 Nc6
 6&   0.17     -9     48987      e4 Nc6 d4 Nf6 d5
 6.   0.17     -9     48987      e4 Nc6 d4 Nf6 d5
 7&   0.53      0    197879      e4 d5 exd5 Qxd5 Nc3 Qe5+
 7&   0.60     23    216372      Nf3 d5 d4 Bg4 Nc3 Bxf3
 7&   0.68     32    237311      Nc3 e5 Nf3 Nc6 e4
 7&   0.84     40    299317      d4 d5 Nc3 Nc6
 7.   0.85     40    300527      d4 d5 Nc3 Nc6
 8&   1.01     -5    354104      d4 d5 Nc3 Nc6 Bf4 Bf5
 8&   2.06     -4    735335      e4 Nc6 d4 Nf6 Nd2
 8.   2.06     -4    735335      e4 Nc6 d4 Nf6 Nd2
 
Time = 2.1 Rate=356616 Nodes=[678267/57068/735335] GenCnt=901307
Eval=[178703/289976] RptCnt=41 NullCut=15983 FutlCut=105904
Ext: Chk=19882 Recap=2570 Pawn=7290 OneRep=1759 Horz=249 Mate=0 KThrt=1873
Material=[3600/3600 : 4400/4400] Lazy=[219/222] MaxPosnScore=[282/265]
Hash: Success=8% Collision=99% Pawn=68%
 
black  KQkq  e3
r n b q k b n r
p p p p p p p p
. . . . . . . .
. . . . . . . .
. . . . P . . .
. . . . . . . .
P P P P . P P P
R N B Q K B N R
 
 
My move is : e4
Black (1) :

Install gnuchess 5.07

The usual procedure should apply. After you have unpacked
the sources, type (in the sources top-level directory)
 
        ./configure
        make
 
You may also pass several other options such as compiler options
to configure, just type ./configure –help for advice. In particular,
you may experiment with compiler optimization flags, which are added
easily as (assuming you have a bourne-type shell)
 
CFLAGS="-O3 -ffast-math" ./configure
 
The build should work with gcc, it also works with the Sun Workshop
compiler and maybe others.
 
Test gnuchess by typing
 
        ./gnuchess.exe (or ./gnuchess on Linux/Unix)
        easy
        new
        post
        depth 8
        go
        quit
 
You should see an 8-ply search. Most machines these
days should finish it within a few seconds. If not,
Control-C out, and do
 
[chendong@erasmus gnuchess-5.07]$
[chendong@erasmus gnuchess-5.07]$ less INSTALL
The usual procedure should apply. After you have unpacked
the sources, type (in the sources top-level directory)
 
        ./configure
        make
 
You may also pass several other options such as compiler options
to configure, just type ./configure –help for advice. In particular,
you may experiment with compiler optimization flags, which are added
easily as (assuming you have a bourne-type shell)
 
CFLAGS="-O3 -ffast-math" ./configure
 
The build should work with gcc, it also works with the Sun Workshop
compiler and maybe others.
 
Test gnuchess by typing
 
        ./gnuchess.exe (or ./gnuchess on Linux/Unix)
        easy
        new
        post
        depth 8
        go
        quit
 
You should see an 8-ply search. Most machines these
days should finish it within a few seconds. If not,
Control-C out, and do
 
[chendong@erasmus gnuchess-5.07]$ ls
acinclude.m4  book          config.sub    COPYING  INSTALL      Makefile.in    NEWS    TODO
aclocal.m4    ChangeLog     configure     depcomp  install-sh   missing        README
AUTHORS       config.guess  configure.ac  doc      Makefile.am  mkinstalldirs  src
[chendong@erasmus gnuchess-5.07]$ less INSTALL
The usual procedure should apply. After you have unpacked
the sources, type (in the sources top-level directory)
 
        ./configure
        make
 
You may also pass several other options such as compiler options
to configure, just type ./configure –help for advice. In particular,
you may experiment with compiler optimization flags, which are added
easily as (assuming you have a bourne-type shell)
 
CFLAGS="-O3 -ffast-math" ./configure
 
The build should work with gcc, it also works with the Sun Workshop
compiler and maybe others.
 
Test gnuchess by typing
 
        ./gnuchess.exe (or ./gnuchess on Linux/Unix)
        easy
        new
        post
        depth 8
        go
        quit
 
You should see an 8-ply search. Most machines these
days should finish it within a few seconds. If not,
Control-C out, and do
 
        depth 6
        go
        quit
 
instead.
 
If you got this far, congratulations.
 
If you want to install the software in some global directory,
by default /usr/local, become root and type
 
        make install
 
If you want to install the sources in some other directory
than /usr/local, replace the first line by
 
        ./configure –prefix=/my/favourite/dir
 
You can build an opening book which may enhance the value
of gnuchess quite a lot. In order to do so, get the file
book.pgn (see book/README for instructions on how to get it)
and type the following.
 
        ln -s ../book/book.pgn
        ./gnuchess
        book add book.pgn
        quit
 
This may take some minutes, depending on the speed of your
machines. The book is quite large (180,000 master games).
If you want a smaller book or you do not want to wait, do the
following instead:
 
        head -30000 ../book/book.pgn > smallbook.pgn
        ./gnuchess
        book add smallbook.pgn
        quit
 
This will make a much smaller book.
 
Original Author:
 
Stuart Cracraft
Laguna Niguel, CA
March, 2001
 
Modifications:
 
Lukas Geyer <lukas@debian.org>
Simon Waters <Simon@wretched.demon.co.uk>

TODO -Temp

Important BugFixes
==================

Feature requests
================

- Send private messages / Profile edit allow messages
- Allow password retrieval by email address
- Render ‘=’ symbols besides moves which included a draw offer
- Implement mouse-driven en-passant
- Improve move inputs: create buttons/checkboxes for draw/resign/…
management (partially done)
- Secure possible remaining exploits in chess.php
- Display an online players list on the homepage
- Display number of online players on the login screen ??
- Display chat messages in history browser (only for people participating)
- Create an overview page accessible to visitors not subscribed yet.
- Mettre des fleches de tendance dans le classement
- Mettre un attribut dans les parties pour definir le temps avant abandon
- Lors du premier coup, proposer un bouton pour refuser la partie…
- Limite max dans les recherches de parties
- Mettre une limite aux nombres d’identifiants par adresse email ?
- Critere de date dans les recherches
- Mise en place d’un email d’accueil suite a la validation d’un
nouvel identifiant: Bienvenue….
- I18n and L10n to French and German
- Update online help
- Messages d’infos sur page index + Flux RSS
- Combo pour choisir les vues du plateau dans chess.php
- Unify chess/browser views
- Optimiser les meta pour le referencement (resume du site)

Robots requests
====================================

- Implement draw offer interface
- Display human readable informations in chat box

Autres taches
=============

- Manage a newsletter
- Links exchange
- Bug followup
(END)

Install - TEMP

Requirements ============ - PHP enabled web server (5.0 or higher required) - MySQL database (4.0 or higher required) - GnuChess and/or Phalanx (to enable robots) - Python (to enable robots) Server Setup ============ Extract the files to a directory accessible by the web server. The files that must be served are in the www directory. Create an account and a database on the MySQL server Run the create_database.sql script to create all the tables. Run the insert_initial_data.sql script to populate the database. If you are upgrading from a previous version, instead of running the create_database/insert_initial_data scripts, run the migration scripts provided for your version.. Requirements ============ - PHP enabled web server (5.0 or higher required) - MySQL database (4.0 or higher required) - GnuChess and/or Phalanx (to enable robots) - Python (to enable robots) Server Setup ============ Extract the files to a directory accessible by the web server. The files that must be served are in the www directory. Create an account and a database on the MySQL server Run the create_database.sql script to create all the tables. Run the insert_initial_data.sql script to populate the database. If you are upgrading from a previous version, instead of running the create_database/insert_initial_data scripts, run the migration scripts provided for your version.. Copy local_settings.php_DIST to local_settings.php. Open it and customise it to match your settings. Notification Setup ================== To enable periodic notification and other regular tasks, add the following lines to your crontab: 21 * * * * cd /PATH_TO_CHESSCLUB && /usr/bin/php5 admin_notification.php >/dev/null 2>&1 30 2 * * * cd /PATH_TO_CHESSCLUB && /usr/bin/php5 admin_flag_active_players.php >/dev/null 2>&1 35 9 * * * cd /PATH_TO_CHESSCLUB && /usr/bin/php5 admin_remind_subscription.php >/dev/null 2>&1 Alternatively, you can add these rules in a file in /etc/cron.d Game Analysis Setup =================== To enable full game analysis feature in history browser, you have to download the analysis script from SVN at: https://mkgichessclub.svn.sourceforge.net/svnroot/mkgichessclub/ChessTeacher/ :

Science of Constraints

In the paper "The Science of Constraints", Dr. Gomes mentioned many interesting future directions that attract my attention.

1. CP can be viewed as constraint satisfaction and constraint optimization.
2. There is much room for further use of randomization and restart for complete search  in CP.
3. Free availability of CSP solver (like SAT solver) 
4. Natural phenomenon and combine principled experimentation with formal modeling- New way to study and solve constraint reasoning problems.
5. Phase transition & heavy tailed phenomenon.
6.NP hard —backdoor variables—-> polynomial

Errata of “Good and bad futures for constraint programming”

The paper "Good and bad futures for constraint programming (and operations research)" appeared in Constraint Programming Letters 1 (2007) 21-32 and I found it contained some confuzing ponits as follows:

1. The edge-finding rules explain why certain schedules are possible are others are not, … (Page 2)  Should the second "are" be "and"?

2. This is why they must rejected if they are wrong even
once. (Page 6) Do you mean "must be rejected"?

3. For example, we can check that only one job is underway at any given tine, … (Page 6) Should the word "tine" be "time"?

4. The overriding objective has been to give advice to the client. (Page 7)