Index: README
==================================================================
--- README
+++ README
@@ -423,6 +423,11 @@
  The version of SQLite in the package manager is not always the newest
  version. Sometimes I use features that are in released versions of SQLite
  but not necessarily in the package manager (and which versions are in the
  package manager may vary according to the distribution). The version in
  the package manager might or might not work; it is untested.
+
+** How to make it to automatically advance to next level if you win?
+
+ Add the following into the .heromeshrc file:
+   .?.autoWin: select 'go',-(level()+1) where level()<max_level();
 

Index: TODO
==================================================================
--- TODO
+++ TODO
@@ -30,10 +30,11 @@
 * Message trace menu to enable/disable
 * Bugs
   * Figure out why the $SeekerCloser class doesn't seem to work properly
   * Level 232 of SUPERHRO puzzle set (the Lava shouldn't expand? why?)
   * Animation stopping unexpectedly (until a key is pushed)
+  * ObjLF.Volume+ObjRF.Volume+obj.Volume if ObjLF and/or ObjRF doesn't exist?
 * Display solution comments/timestamp
 * VCR mode
 * Command-line switch for batch export levels
 * SQL
   * Implement the GROUP column in the CLASSES table
@@ -63,6 +64,5 @@
   * Xsok
   * PuzzleScript (limited; not everything is or will be capable)
   * Sokoban
   * Puzzle Boy
   * Pitman/Catrap
-* Auto advance next level option

Index: config.doc
==================================================================
--- config.doc
+++ config.doc
@@ -25,10 +25,16 @@
   If true, saves changes to the level and solution files when the program
   terminates. If false (default), they are only saved to the user cache
   database; to copy the changes to the level and solution files, you must
   use the .u command in SQL mode (-x), or use the -f switch.
 
+.autoWin
+  SQL statement to execute if you win a level. The format is the same as
+  for a key/mouse binding, but must be a SQL statement, and the only valid
+  parameters are $LEVEL and $LEVEL_ID. Furthermore, '^E', '^Q', ':s', and
+  ':x' are not valid.
+
 .codepage
   The path to the code page file. If not specified, then code pages other
   than 437 are not available (code page 437 is built-in).
 
 .editTitle

Index: default.heromeshrc
==================================================================
--- default.heromeshrc
+++ default.heromeshrc
@@ -1,6 +1,6 @@
-! hERo Mesh configuration settings
+! Hero Mesh configuration settings
 ?.screenWidth: 800
 ?.screenHeight: 600
 ?.imageSize: 24
 ?.traceAll: true
 ?.showInventory: 0

Index: game.c
==================================================================
--- game.c
+++ game.c
@@ -31,10 +31,11 @@
 static Uint8 should_record_solution;
 static Uint8 replay_speed;
 static Uint8 replay_time;
 static Uint8 solved;
 static Uint8 inserting,saved_inserting;
+static sqlite3_stmt*autowin;
 
 static void record_solution(void);
 
 static void setup_game(void) {
   const char*v;
@@ -50,10 +51,13 @@
     optionquery[1]=Q_saveSolutions;
     v=xrm_get_resource(resourcedb,optionquery,optionquery,2)?:"";
     should_record_solution=boolxrm(v,0);
   }
   solution_replay=0;
+  optionquery[1]=Q_autoWin;
+  v=xrm_get_resource(resourcedb,optionquery,optionquery,2);
+  if(v && *v) sqlite3_prepare_v3(userdb,v,-1,SQLITE_PREPARE_PERSISTENT,&autowin,0);
 }
 
 static void redraw_game(void) {
   char buf[32];
   SDL_Rect r;
@@ -820,10 +824,51 @@
       return prev;
     default:
       return prev;
   }
 }
+
+static void do_autowin(void) {
+  const char*name;
+  int i,j,k;
+  int prev=0;
+  sqlite3_reset(autowin);
+  if(sqlite3_bind_parameter_count(autowin)) {
+    for(i=sqlite3_bind_parameter_count(autowin);i;--i) if(name=sqlite3_bind_parameter_name(autowin,i)) {
+      if(*name=='$') {
+        if(!sqlite3_stricmp(name+1,"LEVEL")) {
+          sqlite3_bind_int(autowin,i,level_ord);
+        } else if(!sqlite3_stricmp(name+1,"LEVEL_ID")) {
+          sqlite3_bind_int(autowin,i,level_id);
+        }
+      }
+    }
+  }
+  while((i=sqlite3_step(autowin))==SQLITE_ROW) {
+    if(i=sqlite3_data_count(autowin)) {
+      j=(i>1&&sqlite3_column_type(autowin,1)!=SQLITE_NULL)?sqlite3_column_int(autowin,1):0;
+      if((name=sqlite3_column_text(autowin,0)) && *name) {
+        if(name[0]==':') {
+          switch(name[1]) {
+            case '!': if(i>1) i=system(sqlite3_column_text(autowin,1)?:(const unsigned char*)"# "); break;
+            case ';': goto done;
+            case '?': if(i>1) puts(sqlite3_column_text(autowin,1)?:(const unsigned char*)"(null)"); break;
+            case 'm': if(i>1) screen_message(sqlite3_column_text(autowin,1)?:(const unsigned char*)"(null)"); break;
+          }
+        } else {
+          k=name[0]*'\1\0'+name[1]*'\0\1';
+          while(i && sqlite3_column_type(autowin,i-1)==SQLITE_NULL) i--;
+          prev=game_command(prev,k,j,i,autowin,0);
+          if(prev<0) goto done;
+        }
+      }
+    }
+  }
+  if(i!=SQLITE_DONE) screen_message("SQL error");
+  done:
+  sqlite3_reset(autowin);
+}
 
 static void set_caption(void) {
   const char*r;
   char*s;
   sqlite3_str*m;
@@ -989,11 +1034,14 @@
         if(inputs_count) {
           for(i=0;i<inputs_count && !gameover;i++) if(inputs[i]) input_move(inputs[i]);
           inputs_count=0;
           if(saved_inserting) inserting=1,saved_inserting=0;
           no_dead_anim=0;
-          if(gameover==1 && should_record_solution) record_solution();
+          if(gameover==1) {
+            if(should_record_solution) record_solution();
+            if(autowin) do_autowin();
+          }
         }
         redraw_game();
         timerflag=0; // ensure we have not missed a timer event
         break;
     }

Index: quarks
==================================================================
--- quarks
+++ quarks
@@ -220,6 +220,7 @@
 autoSave
 maxTrigger
 pasteCommand
 codepage
 replaySpeed
+autoWin
 

Index: quarks.h
==================================================================
--- quarks.h
+++ quarks.h
@@ -185,10 +185,11 @@
 #define Q_autoSave 186
 #define Q_maxTrigger 187
 #define Q_pasteCommand 188
 #define Q_codepage 189
 #define Q_replaySpeed 190
+#define Q_autoWin 191
 static const char*const global_quarks[]={
   "screenWidth",
   "screenHeight",
   "margin",
   "palette",
@@ -375,10 +376,11 @@
   "autoSave",
   "maxTrigger",
   "pasteCommand",
   "codepage",
   "replaySpeed",
+  "autoWin",
 0};
 #ifdef HEROMESH_BINDINGS
 static const SDLKey quark_to_key[Q_undo+1-Q_backspace]={
 SDLK_BACKSPACE,
 SDLK_TAB,