779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
|
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
|
+
-
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
-
-
+
+
-
+
+
+
-
+
|
draw_text(a*8+x,y,buf,bg,co);
}
static int list_levels(void) {
static Sint8 mo=-1;
static Uint8 columns=0;
static int scroll=0;
static Uint16 divmin,divmax; // 1 less than level order number
sqlite3_stmt*st;
SDL_Event ev;
SDL_Rect r;
const char*v;
int scrmax=0;
int sel=level_ord-1;
int b,i,j,x,y;
char buf[256];
char rescroll=1;
char rescroll=2;
Uint16 ndiv;
if(mo<0) {
optionquery[1]=Q_listMode;
v=xrm_get_resource(resourcedb,optionquery,optionquery,2)?:"";
mo=strtol(v,0,16);
if(mo<0) mo=0;
}
if(!columns) {
optionquery[1]=Q_listColumns;
v=xrm_get_resource(resourcedb,optionquery,optionquery,2)?:"";
i=strtol(v,0,10);
j=(screen->w-16)/070;
if(i<1) i=j;
if(i>j) i=j;
if(i>255) i=255;
columns=i;
}
if(!ll_head) ll_head="\xB3W \xB3H \xB3 TITLE";
// ID, ORD, CODE, WIDTH, HEIGHT, TITLE, SOLVED, SOLVABLE, ...
prepare:
if(sqlite3_prepare_v2(userdb,mo&4
?"WITH D(F,L,H,R) AS (SELECT `FIRST`, LEAD(`FIRST`,1,MAX_LEVEL()+1) OVER (ORDER BY `FIRST`,_ROWID_), `HEADING`, _ROWID_ FROM `DIVISIONS`)"
" SELECT F, L, H, PRINTF('(%d/%d)',(SELECT COUNT() FROM `LEVELS` WHERE `ORD` >= F AND `ORD` < L AND `SOLVED`),L-F) FROM D WHERE F <> L ORDER BY F, R;"
if(sqlite3_prepare_v2(userdb,"SELECT * FROM `LEVELS` WHERE `ORD` NOT NULL AND `ORD` >= ?1 ORDER BY `ORD`;",-1,&st,0)) {
:"SELECT * FROM `LEVELS` WHERE `ORD` NOT NULL AND `ORD` >= ?1 AND `ORD` < ?2 ORDER BY `ORD`;"
,-1,&st,0)) {
screen_message(sqlite3_errmsg(userdb));
return 0;
}
if(mo&4) {
ndiv=0;
while(sqlite3_step(st)==SQLITE_ROW) ndiv++;
if(!ndiv) {
mo&=3;
sqlite3_finalize(st);
goto prepare;
}
}
set_cursor(XC_arrow);
redraw:
if(sel<0) sel=0;
if(sel>=level_nindex) sel=level_nindex-1;
if((mo&8) && sel>=divmax-divmin) sel=divmax-divmin-1;
SDL_FillRect(screen,0,0x02);
r.x=r.y=0;
r.w=screen->w;
r.h=24;
SDL_FillRect(screen,&r,0xF7);
SDL_LockSurface(screen);
draw_text(0,0,"<LMB/\x18\x19\x1A\x1B> Select <MMB/SP> Title <RMB/RET> Play <0-9> Find <ESC> Cancel",0xF7,0xF0);
draw_text(0,8,"<F1> Wide/Tall <F2> ID/Ord",0xF7,0xF0);
draw_text(0,8,"<F1> Wide/Tall <F2> ID/Ord <F3> Divisions <F4> All",0xF7,0xF0);
if(mo&8) draw_text(0,16,"\x15",0xF7,0xF0);
reset:
sqlite3_reset(st);
sqlite3_bind_int(st,2,mo&8?divmax:level_nindex+1);
if(mo&1) {
scrmax=level_nindex;
if(mo&4) {
scrmax=ndiv;
for(i=0;i<scroll;i++) if(sqlite3_step(st)!=SQLITE_ROW) sqlite3_reset(st),scroll=i-1;
for(j=0,y=24;y<screen->h-7;y+=8,j++) {
i=sqlite3_step(st);
if(i!=SQLITE_ROW) break;
if(rescroll==2 && sel>=sqlite3_column_int(st,0) && sel<sqlite3_column_int(st,1)) {
found:
sel=j;
rescroll=1;
goto reset;
}
if(j==sel) {
divmin=sqlite3_column_int(st,0);
divmax=sqlite3_column_int(st,1);
r.x=16; r.y=y;
r.w=screen->w-16; r.h=8;
SDL_FillRect(screen,&r,0xF8);
draw_text(2*8,y,"\x10",b=0xF8,0xFE);
snprintf(buf,100,"#%d (%d - %d)",sel+1,divmin,divmax-1);
draw_text(80,16,buf,0xF7,0xFE);
} else {
draw_text(2*8,y,"\xB3",b=0x02,0xF8);
}
if(v=sqlite3_column_text(st,2)) {
x=sqlite3_column_bytes(st,2);
draw_text(4*8,y,v,b,0xFF);
if(v=sqlite3_column_text(st,3)) draw_text((x+5)*8,y,v,b,0xFB);
}
}
if(rescroll) {
if(rescroll==2 && i==SQLITE_ROW) {
while((i=sqlite3_step(st))==SQLITE_ROW) {
j++;
if(sel>=sqlite3_column_int(st,0) && sel<sqlite3_column_int(st,1)) goto found;
}
}
if(sel<scroll) scroll=sel;
if(sel>=scroll+screen->h/8-3) scroll=sel+4-screen->h/8;
rescroll=0;
}
if(y<screen->h-7 && sel>=j) {
sel=j-1;
goto reset;
}
} else if(mo&1) {
scrmax=mo&8?(divmax-divmin):level_nindex;
draw_text(16+060,16,ll_head,0xF7,0xF1);
draw_text(16,16,mo&2?"\xB3 ID ":"\xB3 ORD ",0xF7,0xF1);
if(rescroll) {
if(sel<scroll) scroll=sel;
if(sel>=scroll+screen->h/8-3) scroll=sel+4-screen->h/8;
rescroll=0;
}
sqlite3_bind_int(st,1,scroll+1);
sqlite3_bind_int(st,1,scroll+(mo&8?divmin:1));
for(y=24;y<screen->h-7;y+=8) {
if(sqlite3_step(st)!=SQLITE_ROW) break;
i=sqlite3_column_int(st,1);
if(mo&8) i-=divmin-1;
if(i-1==sel) {
r.x=16; r.y=y;
r.w=screen->w-16; r.h=8;
SDL_FillRect(screen,&r,0xF8);
draw_text(2*8,y,"\x10",b=0xF8,0xFE);
} else {
draw_text(2*8,y,"\xB3",b=0x02,0xF8);
}
if(mo&8) i+=divmin-1;
snprintf(buf,6,"%5u",mo&2?sqlite3_column_int(st,0):i);
draw_text(3*8,y,buf,b,sqlite3_column_int(st,6)?0xFA:0xFC);
draw_text(8*8,y,"\xB3",b,b^0xFA);
if(ll_ndisp) {
x=9*8;
for(i=0;i<ll_ndisp && x<screen->w;i++) {
levels_column(x,y,i,b,st,buf);
x+=ll_disp[i].width*8+8;
if(x<screen->w && !(ll_disp[i].flag&1)) draw_text(x-8,y,"\xB3",b,b^0xFA);
}
} else {
snprintf(buf,6,"%2u %2u",sqlite3_column_int(st,3),sqlite3_column_int(st,4));
draw_text(9*8,y,buf,b,0xFF);
draw_text(11*8,y,"\xB3",b,b^0xFA);
draw_text(14*8,y,"\xB3",b,b^0xFA);
copy_text_to_plain(buf,255,sqlite3_column_text(st,5));
draw_text(15*8,y,buf,b,0xFF);
}
}
} else {
scrmax=(level_nindex+columns-1)/columns;
draw_text(0,16,mo&2?"(ID)":"(Ord)",0xF7,0xF1);
scrmax=((mo&8?divmax-divmin:level_nindex)+columns-1)/columns;
draw_text(8,16,mo&2?"(ID)":"(Ord)",0xF7,0xF1);
if(rescroll) {
if(sel<scroll*columns) scroll=sel/columns;
if(sel>(scroll+screen->h/8-3)*columns) scroll=(sel+3-screen->h/8)/columns;
rescroll=0;
}
sqlite3_bind_int(st,1,scroll*columns+1);
sqlite3_bind_int(st,1,scroll*columns+(mo&8?divmin:1));
for(y=24;y<screen->h-7;y+=8) for(x=0;x<columns;x++) {
if(sqlite3_step(st)!=SQLITE_ROW) goto done;
i=sqlite3_column_int(st,1);
if(mo&8) i-=divmin-1;
if(i-1==sel) {
draw_text(x*070+16,y,"\x10",b=0xF8,0xFE);
snprintf(buf,128,"[ ID=%u Ord=%u Code=%u Size=%ux%u ]",sqlite3_column_int(st,0),i,sqlite3_column_int(st,2),sqlite3_column_int(st,3),sqlite3_column_int(st,4));
draw_text(80,16,buf,0xF7,0xFE);
} else {
draw_text(x*070+16,y," ",b=0x02,0x02);
}
if(mo&8) i+=divmin-1;
snprintf(buf,7,"%5u ",mo&2?sqlite3_column_int(st,0):i);
draw_text(x*070+24,y,buf,b,sqlite3_column_int(st,6)?0xFA:0xFC);
if(!sqlite3_column_int(st,7)) draw_text(x*070+64,y,"\a",b,i-1==sel?0xF1:0xF9);
if(!sqlite3_column_int(st,7)) draw_text(x*070+64,y,"\a",b,b==0xF8?0xF1:0xF9);
}
}
done:
SDL_UnlockSurface(screen);
r.x=r.w=0; r.y=24; r.h=screen->h-24;
scrollbar(&scroll,screen->h/8-3,scrmax,0,&r);
SDL_Flip(screen);
|