ViewVC Help

View File | Revision Log | View Changeset | Root Listing

root/Oni2/oup/current/Helper/LevelDB.pas

Comparing oup/current/Helper/LevelDB.pas (file contents):
Revision 113 by alloc, Sun Feb 25 17:20:22 2007 UTC vs.
Revision 145 by alloc, Sun Apr 1 15:14:09 2007 UTC

#	Line 12 | Line 12 | type
12		btn_abortok:  TButton;
13		lbl_estimation: TLabel;
14		procedure btn_abortokClick(Sender: TObject);
15	–	private
16	–	procedure HandleFile(Ext: String; FileID: Integer);
17	–	procedure StopConvert;
15		public
16		procedure CreateDatabase(Source, Target: String);
17		procedure CreateLevel(Source, Target: String);
#	Line 27 | Line 24 | var
24		implementation
25		{$R *.dfm}
26		uses ABSMain, ABSDecUtil, Main,
27	<	ConnectionManager, TypeDefs, DataAccess, OniImgClass, Data;
31	<
32	<	type
33	<	THandler = procedure(FileID: Integer);
34	<	TConvertHandler = record
35	<	Ext:     String[4];
36	<	Handler: THandler;
37	<	end;
27	>	ConnectionManager, TypeDefs, DataAccess, OniImgClass, Data, RawList;
28
29		var
40	–	ConvertHandlers: array of TConvertHandler;
41	–	//  loaded_filename: String;
30		Converting:  Boolean = False;
31		Abort:       Boolean = False;
32
#	Line 56 | Line 44 | end;
44
45
46		procedure TForm_LevelDB.CreateLevel(Source, Target: String);
47	+	const
48	+	EmptyBytes: Array[0..31] of Byte = (
49	+	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 );
50		var
51		DatHeader:        THeader;
52		FilesHeader:      TFilesMap;
#	Line 65 | Line 56 | var
56		Stream_Body, Stream_Names:          TMemoryStream;
57		Stream_Dat, Stream_Raw, Stream_Sep: TFileStream;
58
68	–	//  Data, rawdata: Tdata;
59		BeginTime, FileTime: Double;
60		Step:     Integer;
71	–	//  rawlist:  TRawDataList;
72	–	//  datlinks: TDatLinks;
73	–	OniImage:   TOniImage;
61		LevelID:    Integer;
62		TimeFormat: TFormatSettings;
63
#	Line 78 | Line 65 | var
65		Connection: TDataAccess;
66		ConRepMsg:  TStatusMessages;
67
68	+	FileID:     Integer;
69	+
70		Strings:    TStrings;
71		i, j:       Integer;
72		temps:      String;
73	+	tempi:      Integer;
74	+	tempb:      Byte;
75		FileInfo:   TFileInfo;
76	+	DatLinks:   TDatLinkList;
77	+	RawLinks:   TRawDataList;
78
79		DatFileStream, RawFileStream: TMemoryStream;
80		const
#	Line 98 | Line 91 | const
91		group_progress.Caption := 'Creating Dat (FINISHED)';
92		end;
93
94	+	procedure StopConvert;
95	+	begin
96	+	btn_abortok.Caption := '&Close';
97	+	btn_abortok.Default := True;
98	+	converting := False;
99	+	lbl_estimation.Caption := 'ABORTED';
100	+	group_progress.Caption := 'Creating Level (ABORTED)';
101	+
102	+	Stream_Body.Free;
103	+	Stream_Names.Free;
104	+	DatFileStream.Free;
105	+	RawFileStream.Free;
106	+
107	+	Stream_Dat.Free;
108	+	Stream_Raw.Free;
109	+	if Connection.DataOS in [DOS_WINDEMO, DOS_MAC, DOS_MACBETA] then
110	+	Stream_Sep.Free;
111	+
112	+	if MessageBox(Self.Handle, PChar('Delete the unfinished level-files?'),
113	+	PChar('Delete files?'), MB_YESNO) = idYes then
114	+	begin
115	+	DeleteFile(target);
116	+	DeleteFile(AnsiReplaceStr(Target, '.dat', '.raw'));
117	+	if Connection.DataOS in [DOS_WINDEMO, DOS_MAC, DOS_MACBETA] then
118	+	DeleteFile(AnsiReplaceStr(Target, '.dat', '.sep'));
119	+	end;
120	+	end;
121	+
122		begin
123
124		//
#	Line 145 | Line 166 | begin
166		begin
167		ShowMessage('Couldn''t delete file. Aborting');
168		Exit;
148	–	end else if not DeleteFile(AnsiReplaceStr(Target, '.dat', '.raw')) then
149	–	begin
150	–	ShowMessage('Couldn''t delete file. Aborting');
151	–	Exit;
152	–	end else if not DeleteFile(AnsiReplaceStr(Target, '.dat', '.sep')) then
153	–	begin
154	–	ShowMessage('Couldn''t delete file. Aborting');
155	–	Exit;
169		end;
170	+	if FileExists(AnsiReplaceStr(Target, '.dat', '.raw')) then
171	+	if not DeleteFile(AnsiReplaceStr(Target, '.dat', '.raw')) then
172	+	begin
173	+	ShowMessage('Couldn''t delete file. Aborting');
174	+	Exit;
175	+	end;
176	+	if FileExists(AnsiReplaceStr(Target, '.dat', '.sep')) then
177	+	if Connection.DataOS in [DOS_WINDEMO, DOS_MAC, DOS_MACBETA] then
178	+	if not DeleteFile(AnsiReplaceStr(Target, '.dat', '.sep')) then
179	+	begin
180	+	ShowMessage('Couldn''t delete file. Aborting');
181	+	Exit;
182	+	end;
183		end else begin
184		ShowMessage('Aborting');
185		Exit;
#	Line 162 | Line 188 | begin
188
189		LevelID  := Connection.LevelNumber;
190		LevelID  := (LevelID * 2) * 256 * 256 * 256 + $01;
165	–	OniImage := TOniImage.Create;
191
192		Self.Visible := True;
193		Form_Main.Visible := False;
#	Line 270 | Line 295 | begin
295		Application.ProcessMessages;
296
297		FileTime := Time;
298	<	for i := 0 to DatHeader.Files - 1 do
298	>	for FileID := 0 to DatHeader.Files - 1 do
299		begin
300	<	FileInfo := Connection.GetFileInfo(i);
300	>	FileInfo := Connection.GetFileInfo(FileID);
301		for j := 0 to 3 do
302	<	FilesHeader[i].Extension[j] := FileInfo.Extension[4 - j];
302	>	FilesHeader[FileID].Extension[j] := FileInfo.Extension[4 - j];
303		if FileInfo.Size > 0 then
304		begin
305	<	//        DatLinks:=;
281	<	FilesHeader[i].DataAddr := Stream_Body.Size + 8;
305	>	FilesHeader[FileID].DataAddr := Stream_Body.Size + 8;
306		DatFileStream := TMemoryStream.Create;
307	<	Connection.LoadDatFile(i, DatFileStream);
308	<	DatFileStream.Seek(4, soFromBeginning);
307	>	Connection.LoadDatFile(FileID, TStream(DatFileStream));
308	>	DatFileStream.Seek(0, soFromBeginning);
309	>	tempi := FileID * 256 + 1;
310	>	DatFileStream.Write(tempi, 4);
311		DatFileStream.Write(LevelID, 4);
312
313	<	if (Pos(UpperCase(fileinfo.Extension), UpperCase(raws)) mod 4) = 1 then
313	>	DatLinks := Connection.GetDatLinks(FileID);
314	>	if Length(DatLinks) > 0 then
315		begin
316	<	rawlist := OniDataConnection.GetRawList(i);
290	<	if Length(rawlist) > 0 then
316	>	for i := 0 to High(DatLinks) do
317		begin
318	<	for j := 0 to High(rawlist) do
318	>	DatFileStream.Seek(DatLinks[i].SrcOffset, soFromBeginning);
319	>	if DatLinks[i].DestID < 0 then
320	>	tempi := 0
321	>	else
322	>	tempi := DatLinks[i].DestID * 256 + 1;
323	>	DatFileStream.Write(tempi, 4);
324	>	end;
325	>	end;
326	>
327	>	RawLinks := Connection.GetRawList(FileID);
328	>	if Length(RawLinks) > 0 then
329	>	begin
330	>	for i := 0 to High(RawLinks) do
331	>	begin
332	>	if RawLinks[i].RawSize > 0 then
333		begin
334	<	if rawlist[j].raw_size > 0 then
334	>	RawFileStream := TMemoryStream.Create;
335	>	Connection.LoadRawFile(FileID, RawLinks[i].SrcOffset, TStream(RawFileStream));
336	>	RawFileStream.Seek(0, soFromBeginning);
337	>	if RawLinks[i].LocSep then
338		begin
339	<	if (UpperCase(fileinfo.Extension) = 'TXMP') and
340	<	((Data[$88] and $01) > 0) then
341	<	begin
342	<	OniImage.LoadFromTXMP(Connection, i);
343	<	OniImage.GetMipMappedImage(rawdata);
344	<	rawlist[j].raw_size := OniImage.GetImageDataSize(True);
345	<	Data[$90] := $08;
346	<	Data[$89] := 32;
347	<	{                  if data[$90]<>OniImage.StoreType then begin
348	<	data[$90]:=OniImage.StoreType;
349	<	data[$89]:=(data[$89] and $CF) or $20;
350	<	end;
351	<	}                end
352	<	else
310	<	begin
311	<	SetLength(rawdata, rawlist[j].raw_size);
312	<	OniDataConnection.LoadRawFile(i, rawlist[j].src_offset, @rawdata[0]);
313	<	end;
314	<	//                data[$88]:=data[$88] and $FE;
315	<
316	<	if rawlist[j].loc_sep then
317	<	begin
318	<	rawlist[j].raw_addr := Stream_Sep.Size;
319	<	Stream_Sep.Write(rawdata[0], Length(rawdata));
320	<	end
321	<	else
322	<	begin
323	<	rawlist[j].raw_addr := Stream_Raw.Size;
324	<	Stream_Raw.Write(rawdata[0], Length(rawdata));
325	<	end;
326	<	end
327	<	else
328	<	rawlist[j].raw_addr := 0;
329	<	Data[rawlist[j].src_offset + 0] := (rawlist[j].raw_addr) and $FF;
330	<	Data[rawlist[j].src_offset + 1] := (rawlist[j].raw_addr shr 8) and $FF;
331	<	Data[rawlist[j].src_offset + 2] := (rawlist[j].raw_addr shr 16) and $FF;
332	<	Data[rawlist[j].src_offset + 3] := (rawlist[j].raw_addr shr 24) and $FF;
333	<	end;
339	>	RawLinks[i].RawAddr := Stream_Sep.Size;
340	>	Stream_sep.CopyFrom(RawFileStream, RawFileStream.Size);
341	>	if (Stream_Sep.Size mod 32) > 0 then
342	>	Stream_Sep.Write(EmptyBytes[0], 32 - (Stream_Sep.Size mod 32));
343	>	end else begin
344	>	RawLinks[i].RawAddr := Stream_Raw.Size;
345	>	Stream_Raw.CopyFrom(RawFileStream, RawFileStream.Size);
346	>	if (Stream_Raw.Size mod 32) > 0 then
347	>	Stream_Raw.Write(EmptyBytes[0], 32 - (Stream_Raw.Size mod 32));
348	>	end;
349	>	end else
350	>	RawLinks[i].RawAddr := 0;
351	>	DatFileStream.Seek(RawLinks[i].SrcOffset, soFromBeginning);
352	>	DatFileStream.Write(RawLinks[i].RawAddr, 4);
353		end;
354		end;
355	<
356	<	Stream_Body.Write(Data[0], Length(Data));
357	<	//
355	>	DatFileStream.Seek(0, soFromBeginning);
356	>	Stream_Body.CopyFrom(DatFileStream, DatFileStream.Size);
357	>	if (Stream_Body.Size mod 32) > 0 then
358	>	Stream_Body.Write(EmptyBytes[0], 32 - (Stream_Body.Size mod 32));
359		end
360		else
361	<	FilesHeader[i].DataAddr := 0;
361	>	FilesHeader[FileID].DataAddr := 0;
362		if Length(fileinfo.Name) > 0 then
363		begin
364	<	FilesHeader[i].NameAddr := Stream_Names.Size;
364	>	FilesHeader[FileID].NameAddr := Stream_Names.Size;
365		temps := fileinfo.Extension + fileinfo.Name + Chr(0);
366		Stream_Names.Write(temps[1], Length(temps));
367		end
368		else
369	<	FilesHeader[i].NameAddr := 0;
370	<	FilesHeader[i].FileSize := fileinfo.Size;
371	<	FilesHeader[i].FileType := fileinfo.FileType;
369	>	FilesHeader[FileID].NameAddr := 0;
370	>	FilesHeader[FileID].FileSize := fileinfo.Size;
371	>	FilesHeader[FileID].FileType := fileinfo.FileType;
372
373	<	if ((i mod 10) = 0) and (i >= 100) then
373	>	if ((FileID mod 10) = 0) and (FileID >= 100) then
374		lbl_estimation.Caption := 'Estimated time left: ' + TimeToStr(
375	<	(Time - FileTime) / i * (progress.Max - i + 1) * 1.1, TimeFormat );
376	<	progress.Position := i + 1;
377	<	lbl_progress.Caption := 'Files done: ' + IntToStr(i + 1) + '/' + IntToStr(progress.Max);
375	>	(Time - FileTime) / FileID * (progress.Max - FileID + 1) * 1.1, TimeFormat );
376	>	progress.Position := FileID + 1;
377	>	lbl_progress.Caption := 'Files done: ' + IntToStr(FileID + 1) + '/' + IntToStr(progress.Max);
378		Application.ProcessMessages;
379		end;
380
#	Line 366 | Line 386 | begin
386		for i := 0 to High(ExtensionsHeader) do
387		Stream_Dat.Write(ExtensionsHeader[i], SizeOf(ExtensionsHeader[i]));
388
389	+	if (Stream_Dat.Size mod 32) > 0 then
390	+	Stream_Dat.Write(EmptyBytes[0], 32 - (Stream_Dat.Size mod 32));
391	+
392		DatHeader.DataSize  := Stream_Body.Size;
393		DatHeader.NamesSize := Stream_Names.Size;
394		DatHeader.DataAddr  := Stream_Dat.Size;
395	+
396		Stream_Body.Seek(0, soFromBeginning);
397		Stream_Dat.CopyFrom(Stream_Body, Stream_Body.Size);
398	+
399	+	if (Stream_Dat.Size mod 32) > 0 then
400	+	Stream_Dat.Write(EmptyBytes[0], 32 - (Stream_Dat.Size mod 32));
401	+
402		DatHeader.NamesAddr := Stream_Dat.Size;
403		Stream_Names.Seek(0, soFromBeginning);
404		Stream_Dat.CopyFrom(Stream_Names, Stream_Names.Size);
#	Line 382 | Line 410 | begin
410		Stream_Body.Free;
411		Stream_Names.Free;
412		Stream_Raw.Free;
413	<	if OniDataConnection.OSisMac then
413	>
414	>	if Connection.DataOS in [DOS_WINDEMO, DOS_MAC, DOS_MACBETA] then
415		Stream_Sep.Free;
416
417		progress.Position      := progress.Max;
#	Line 394 | Line 423 | begin
423		btn_abortok.Caption := '&OK';
424		btn_abortok.Default := True;
425
397	–	OniImage.Free;
398	–
426		converting := False;
427
428	<	CloseDataConnection(DataConnections[conIndex]);
402	<	end;
403	<
404	<
405	<
406	<
407	<	procedure TForm_LevelDB.HandleFile;
408	<	var
409	<	i: Byte;
410	<	begin
411	<	for i := 1 to Length(ConvertHandlers) do
412	<	if UpperCase(ConvertHandlers[i].Ext) = UpperCase(ext) then
413	<	if ConvertHandlers[i].needed then
414	<	begin
415	<	ConvertHandlers[i].Handler(fileid, dir_dat2db);
416	<	Break;
417	<	end
418	<	else
419	<	Break;
428	>	//  CloseDataConnection(DataConnections[conIndex]);
429		end;
430
431
#	Line 424 | Line 433 | end;
433
434		procedure TForm_LevelDB.CreateDatabase(Source, target: String);
435		var
436	<	DataBase:    TABSDatabase;
437	<	Query:       TABSQuery;
438	<	MimeCoder:   TStringFormat_MIME64;
430	<
431	<	i, j:     LongWord;
432	<	temps, temps2: String;
433	<	Data:     Tdata;
434	<	absolutebegintime, begintime: Double;
435	<	step:     Byte;
436	<	rawlist:  TRawList;
437	<	extlist:  TExtensionsMap;
438	<	fileinfo: TFileInfo;
439	<	timeformat: TFormatSettings;
436	>	DataBase:  TABSDatabase;
437	>	Query:     TABSQuery;
438	>	MimeCoder: TStringFormat_MIME64;
439
440	<	conIndex: Integer;
441	<	const
442	<	steps: Byte = 4;
440	>	BeginTime, FileTime: Double;
441	>	Step:       Integer;
442	>	TimeFormat: TFormatSettings;
443
444	+	ConID:      Integer;
445	+	Connection: TDataAccess;
446	+	ConRepMsg:  TStatusMessages;
447
448	+	FileID:     Integer;
449
450	+	i:          Integer;
451	+	temps:      String;
452	+	tempdata:   TByteData;
453	+	FileInfo:   TFileInfo;
454	+	DatLinks:   TDatLinkList;
455	+	RawLinks:   TRawDataList;
456	+	const
457	+	steps: Byte = 2;
458
459		procedure DoStep(stepname: String);
460		begin
#	Line 455 | Line 466 | const
466		group_progress.Caption := 'Creating DB (FINISHED)';
467		end;
468
469	+	procedure StopConvert;
470	+	begin
471	+	btn_abortok.Caption := '&Close';
472	+	btn_abortok.Default := True;
473	+	converting := False;
474	+	lbl_estimation.Caption := 'ABORTED';
475	+	group_progress.Caption := 'Creating DB (ABORTED)';
476	+	DataBase.Close;
477	+	if MessageBox(Self.Handle, PChar('Delete the unfinished DB-file?'),
478	+	PChar('Delete file?'), MB_YESNO) = idYes then
479	+	begin
480	+	DeleteFile(target);
481	+	end;
482	+	end;
483	+
484	+
485	+
486		begin
487	<	if CreateDataConnection(Source, ODB_Dat) = nil then
487	>
488	>	//
489	>	// FILE EXISTS CHECK FÜR DAT/RAW/SEP!!!
490	>	//
491	>
492	>	TimeFormat.ShortTimeFormat := 'hh:nn:ss';
493	>	TimeFormat.LongTimeFormat  := 'hh:nn:ss';
494	>	TimeFormat.TimeSeparator   := ':';
495	>
496	>	ConID := ConManager.OpenConnection(Source, ConRepMsg);
497	>	if not (ConRepMsg in [SM_OK, SM_AlreadyOpened]) then
498		begin
499	<	ShowMessage('Could not connect to .dat-file');
499	>	ShowMessage('Source-file couldn''t be opened! Aborting' + CrLf + GetOpenMsg(ConRepMsg));
500		Exit;
501	<	end
502	<	else
501	>	end else
502	>	Connection := ConManager.Connection[ConID];
503	>
504	>	ConID := ConManager.FileOpened(Target);
505	>	if ConID >= 0 then
506		begin
507	<	TOniDataDat(OniDataConnection).UnloadWhenUnused := False;
507	>	if MessageBox(Self.Handle, PChar('Destination-file is opened, close it in ' +
508	>	'order to proceed conversion?'), PChar('Destination-file opened'),
509	>	MB_YESNO + MB_ICONQUESTION) = ID_YES then
510	>	begin
511	>	if Form_Main.CheckConnectionCloseable(ConID) then
512	>	if not ConManager.CloseConnection(ConID, ConRepMsg) then
513	>	begin
514	>	ShowMessage('Couldn''t close destination-file. Aborting');
515	>	Exit;
516	>	end;
517	>	end else begin
518	>	ShowMessage('Aborting');
519	>	Exit;
520	>	end;
521		end;
522
523	<	timeformat.LongTimeFormat := 'hh:nn:ss';
524	<	timeformat.ShortTimeFormat := 'hh:nn:ss';
525	<	timeformat.TimeSeparator := ':';
523	>	if FileExists(Target) then
524	>	begin
525	>	if MessageBox(Self.Handle, PChar('Destination-file exists. ' +
526	>	'Overwrite it?'), PChar('Destination-file exists'),
527	>	MB_YESNO + MB_ICONWARNING) = ID_YES then
528	>	begin
529	>	if not DeleteFile(Target) then
530	>	begin
531	>	ShowMessage('Couldn''t delete file. Aborting');
532	>	Exit;
533	>	end;
534	>	end else begin
535	>	ShowMessage('Aborting');
536	>	Exit;
537	>	end;
538	>	end;
539
540		Self.Visible := True;
541		Form_Main.Visible := False;
#	Line 477 | Line 544 | begin
544		abort := False;
545		btn_abortok.Caption := '&Abort...';
546		btn_abortok.Default := False;
480	–	loaded_filename := target;
547
548	<	absolutebegintime := Time;
548	>	BeginTime := Time;
549
550		DataBase := TABSDatabase.Create(Self);
551	+	DataBase.MaxConnections := 1;
552	+	DataBase.PageSize := 8112;
553	+	DataBase.PageCountInExtent := 8;
554	+
555		DataBase.DatabaseName := 'OLDB';
556		DataBase.DatabaseFileName := target;
557		DataBase.CreateDatabase;
#	Line 495 | Line 565 | begin
565		Query := TABSQuery.Create(Self);
566		Query.DatabaseName := 'OLDB';
567		Query.SQL.Text :=
568	<	'CREATE TABLE globals  ( id AUTOINC PRIMARY KEY, name STRING(128), value STRING(128) );';
568	>	'CREATE TABLE globals  ( id AUTOINC PRIMARY KEY, name STRING(128), ' +
569	>	'value STRING(128) );';
570		Query.ExecSQL;
571		Query.SQL.Text :=
572	<	'CREATE TABLE linkmap  ( id AUTOINC PRIMARY KEY, src_id INTEGER, src_link_offset INTEGER, target_id INTEGER );';
572	>	'CREATE TABLE linkmap  ( id AUTOINC PRIMARY KEY, src_id INTEGER, ' +
573	>	'src_link_offset INTEGER, target_id INTEGER);';
574	>	Query.ExecSQL;
575	>	Query.SQL.Text := 'CREATE INDEX idsrcid ON linkmap (src_id);';
576	>	Query.ExecSQL;
577	>	Query.SQL.Text := 'CREATE INDEX idtargetid ON linkmap (target_id);';
578		Query.ExecSQL;
579		Query.SQL.Text :=
580	<	'CREATE TABLE rawmap  ( id AUTOINC PRIMARY KEY, src_id INTEGER, src_link_offset INTEGER, sep BOOLEAN, size INTEGER, data BLOB BlobCompressionMode 9 BlobBlockSize 1024 BlobCompressionAlgorithm ZLib );';
580	>	'CREATE TABLE rawmap  ( id AUTOINC PRIMARY KEY, src_id INTEGER, ' +
581	>	'src_link_offset INTEGER, sep BOOLEAN, size INTEGER, ' +
582	>	'data BLOB BlobCompressionMode 9 BlobBlockSize 1024 BlobCompressionAlgorithm ZLib);';
583		//    Query.SQL.Text:='CREATE TABLE rawmap  ( id AUTOINC PRIMARY KEY, src_id INTEGER, src_link_offset INTEGER, size INTEGER, data BLOB BlobCompressionAlgorithm None );';
584		Query.ExecSQL;
585	<	Query.SQL.Text :=
508	<	'CREATE TABLE datfiles  ( id INTEGER PRIMARY KEY, extension CHAR(4), name STRING(128), contenttype INTEGER, size INTEGER, data BLOB BlobCompressionMode 9 BlobBlockSize 1024 BlobCompressionAlgorithm ZLib );';
509	<	//    Query.SQL.Text:='CREATE TABLE datfiles  ( id INTEGER PRIMARY KEY, extension CHAR(4), name STRING(128), contenttype INTEGER, size INTEGER, data BLOB BlobCompressionAlgorithm None );';
585	>	Query.SQL.Text := 'CREATE INDEX idsrcid ON rawmap (src_id);';
586		Query.ExecSQL;
587		Query.SQL.Text :=
588	<	'CREATE TABLE extlist  ( id AUTOINC PRIMARY KEY, ext CHAR(4), ident CHAR(16) );';
588	>	'CREATE TABLE datfiles  ( id INTEGER PRIMARY KEY, extension CHAR(4), ' +
589	>	'name STRING(128), contenttype INTEGER, size INTEGER, ' +
590	>	'data BLOB BlobCompressionMode 9 BlobBlockSize 1024 BlobCompressionAlgorithm ZLib );';
591	>	//    Query.SQL.Text:='CREATE TABLE datfiles  ( id INTEGER PRIMARY KEY, extension CHAR(4), name STRING(128), contenttype INTEGER, size INTEGER, data BLOB BlobCompressionAlgorithm None );';
592		Query.ExecSQL;
593	+	//  Query.SQL.Text :=
594	+	//    'CREATE TABLE extlist  ( id AUTOINC PRIMARY KEY, ext CHAR(4), ident CHAR(16) );';
595	+	//  Query.ExecSQL;
596
597		Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("dbversion","' +
598		dbversion + '");';
599		Query.ExecSQL;
600	<	SetLength(Data, Length(OniDataConnection.LevelInfo.Ident));
519	<	for i := 0 to High(OniDataConnection.LevelInfo.Ident) do
520	<	Data[i] := OniDataConnection.LevelInfo.Ident[i];
521	<	temps := CreateHexString(Data, True);
522	<	Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("ident","' + temps + '");';
523	<	Query.ExecSQL;
600	>
601		Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("lvl","' +
602	<	IntToStr(OniDataConnection.LevelInfo.LevelNumber) + '");';
602	>	IntToStr(Connection.LevelNumber) + '");';
603		Query.ExecSQL;
604	<	if OniDataConnection.OSisMAC then
605	<	Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("os","MAC");'
606	<	else
607	<	Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("os","PC");';
608	<	Query.ExecSQL;
532	<
533	<	DoStep('Writing extensionslist');
534	<	progress.Max := Length(OniDataConnection.GetExtensionsList);
535	<	Application.ProcessMessages;
536	<
537	<	extlist := OniDataConnection.GetExtendedExtensionsList;
538	<	for i := 0 to High(extlist) do
539	<	begin
540	<	SetLength(Data, Length(extlist[i].Ident));
541	<	for j := 0 to High(extlist[i].Ident) do
542	<	Data[j] := extlist[i].Ident[j];
543	<	temps := CreateHexString(Data, True);
544	<	temps2 := extlist[i].Extension[3] + extlist[i].Extension[2] +
545	<	extlist[i].Extension[1] + extlist[i].Extension[0];
546	<	Query.SQL.Text := 'INSERT INTO extlist (ext,ident) VALUES ("' +
547	<	temps2 + '","' + temps + '");';
548	<	Query.ExecSQL;
549	<	progress.Position    := i;
550	<	lbl_progress.Caption := 'Extensions done: ' + IntToStr(i) + '/' +
551	<	IntToStr(Length(extlist));
552	<	Application.ProcessMessages;
553	<	if abort then
554	<	begin
555	<	stop_convert;
556	<	Exit;
557	<	end;
604	>	case Connection.DataOS of
605	>	DOS_WIN: temps := 'WIN';
606	>	DOS_WINDEMO: temps := 'WINDEMO';
607	>	DOS_MAC: temps := 'MAC';
608	>	DOS_MACBETA: temps := 'MACBETA';
609		end;
610	<	lbl_progress.Caption := '';
610	>	Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("os","' + temps + '");';
611	>	Query.ExecSQL;
612
613		progress.Position      := 0;
614		lbl_progress.Caption   := 'Files done: ' + IntToStr(0) + '/' + IntToStr(
615	<	OniDataConnection.GetFilesCount);
615	>	Connection.GetFileCount);
616		lbl_estimation.Caption := 'Estimated finishing time: unknown';
617
618	<	DoStep('Loading .dat into memory');
567	<	Application.ProcessMessages;
568	<
569	<	progress.Max := OniDataConnection.GetFilesCount;
618	>	progress.Max := Connection.GetFileCount;
619		begintime    := Time;
620		DoStep('Writing .dat-fileslist');
621		Application.ProcessMessages;
622
623	+	FileTime := Time;
624		Database.StartTransaction;
625	<	for i := 0 to OniDataConnection.GetFilesCount - 1 do
625	>	for FileID := 0 to Connection.GetFileCount - 1 do
626		begin
627	<	fileinfo := OniDataConnection.GetFileInfo(i);
627	>	fileinfo := Connection.GetFileInfo(FileID);
628		if (fileinfo.FileType and $02) = 0 then
629		begin
630		mimecoder := TStringFormat_MIME64.Create;
631	<	Data      := OniDataConnection.LoadDatFile(i);
631	>	Connection.LoadDatFile(FileID, tempdata);
632		Query.SQL.Text :=
633		'INSERT INTO datfiles (id,extension,name,contenttype,size,data) VALUES (' +
634	<	IntToStr(i) + ',"' + fileinfo.Extension + '","' + fileinfo.Name + '","' + IntToHex(
634	>	IntToStr(FileID) + ',"' + fileinfo.Extension + '","' + fileinfo.Name + '","' + IntToHex(
635		fileinfo.FileType, 8) + '",' + IntToStr(fileinfo.Size) + ',MimeToBin("' +
636	<	MimeCoder.StrTo(@Data[0], Length(Data)) + '") );';
636	>	MimeCoder.StrTo(@tempdata[0], Length(tempdata)) + '") );';
637		Query.ExecSQL;
638		mimecoder.Free;
639
640	<	rawlist := OniDataConnection.GetRawList(i);
641	<	if Length(rawlist) > 0 then
640	>	RawLinks := Connection.GetRawList(FileID);
641	>	if Length(RawLinks) > 0 then
642		begin
643	<	for j := 0 to High(rawlist) do
643	>	for i := 0 to High(RawLinks) do
644		begin
645	<	if rawlist[j].raw_size > 0 then
645	>	if RawLinks[i].RawSize > 0 then
646		begin
647	<	SetLength(Data, rawlist[j].raw_size);
648	<	OniDataConnection.LoadRawFile(i, rawlist[j].src_offset, Data);
647	>	SetLength(tempdata, RawLinks[i].RawSize);
648	>	Connection.LoadRawFile(FileID, RawLinks[i].SrcOffset, tempdata);
649		mimecoder      := TStringFormat_MIME64.Create;
650		Query.SQL.Text :=
651		'INSERT INTO rawmap (src_id,src_link_offset,sep,size,data) VALUES (' +
652	<	IntToStr(i) + ',' + IntToStr(rawlist[j].src_offset) + ',' + BoolToStr(
653	<	rawlist[j].loc_sep) + ',' + IntToStr(rawlist[j].raw_size) + ',MimeToBin("' +
654	<	MimeCoder.StrTo(@Data[0], rawlist[j].raw_size) + '") );';
652	>	IntToStr(FileID) + ', ' + IntToStr(RawLinks[i].SrcOffset) + ',' +
653	>	BoolToStr(RawLinks[i].LocSep) + ', ' +
654	>	IntToStr(RawLinks[i].RawSize) + ', ' +
655	>	'MimeToBin("' + MimeCoder.StrTo(@tempdata[0], RawLinks[i].RawSize) + '") );';
656		Query.ExecSQL;
657		mimecoder.Free;
658		end
#	Line 609 | Line 660 | begin
660		begin
661		Query.SQL.Text :=
662		'INSERT INTO rawmap (src_id,src_link_offset,sep,size) VALUES (' +
663	<	IntToStr(i) + ',' + IntToStr(rawlist[j].src_offset) + ',' + BoolToStr(rawlist[j].loc_sep) + ',0);';
663	>	IntToStr(FileID) + ', ' + IntToStr(RawLinks[i].SrcOffset) + ', ' +
664	>	BoolToStr(RawLinks[i].LocSep) + ', 0);';
665		Query.ExecSQL;
666		end;
667	+	if ((i mod 100) = 0) and (FileID > 0) then
668	+	begin
669	+	Database.Commit(False);
670	+	Database.StartTransaction;
671	+	end;
672		end;
673		end;
674
675	<	HandleFile(fileinfo.Extension, i, True);
675	>	DatLinks := Connection.GetDatLinks(FileID);
676	>	if Length(DatLinks) > 0 then
677	>	begin
678	>	for i := 0 to High(DatLinks) do
679	>	begin
680	>	Query.SQL.Text :=
681	>	'INSERT INTO linkmap (src_id, src_link_offset, target_id) VALUES (' +
682	>	IntToStr(FileID) + ', ' + IntToStr(DatLinks[i].SrcOffset) + ', ' +
683	>	IntToStr(DatLinks[i].DestID) + ');';
684	>	Query.ExecSQL;
685	>	end;
686	>	end;
687		end
688		else
689		begin
690		Query.SQL.Text :=
691		'INSERT INTO datfiles (id,extension,name,contenttype,size) VALUES (' +
692	<	IntToStr(i) + ',"' + fileinfo.Extension + '","' + fileinfo.Name + '","' + IntToHex(
693	<	fileinfo.FileType, 8) + '",0);';
692	>	IntToStr(FileID) + ', "' + fileinfo.Extension + '", ' +
693	>	'"' + fileinfo.Name + '", "' + IntToHex(fileinfo.FileType, 8) + '", 0);';
694		Query.ExecSQL;
695		end;
696	<	if ((i mod 100) = 0) and (i > 0) then
696	>	if ((FileID mod 100) = 0) and (FileID > 0) then
697		begin
698		Database.Commit(False);
699		Database.StartTransaction;
700		end;
701	<	if ((i mod 10) = 0) and (i >= 100) then
701	>	if ((FileID mod 10) = 0) and (FileID >= 100) then
702		lbl_estimation.Caption := 'Estimated time left: ' + TimeToStr(
703	<	(Time - begintime) / i * (progress.Max - i + 1) * 1.1, timeformat );
704	<	progress.Position := i;
705	<	lbl_progress.Caption := 'Files done: ' + IntToStr(i) + '/' + IntToStr(progress.Max);
703	>	(Time - FileTime) / FileID * (progress.Max - FileID + 1) * 1.1, timeformat );
704	>	progress.Position := FileID;
705	>	lbl_progress.Caption := 'Files done: ' + IntToStr(FileID) + '/' + IntToStr(progress.Max);
706		Application.ProcessMessages;
707		if abort then
708		begin
709	<	stop_convert;
709	>	StopConvert;
710		Exit;
711		end;
712		end;
#	Line 647 | Line 715 | begin
715		lbl_progress.Caption   := 'Files done: ' + IntToStr(progress.Max) + '/' +
716		IntToStr(progress.Max);
717
718	<	lbl_estimation.Caption := 'FINISHED (duration: ' + TimeToStr(Time - absolutebegintime, timeformat) + ')';
718	>	lbl_estimation.Caption := 'FINISHED (duration: ' + TimeToStr(Time - BeginTime, timeformat) + ')';
719
720		DoStep('FIN');
721		btn_abortok.Caption := '&OK';
#	Line 655 | Line 723 | begin
723
724		converting := False;
725
726	<	database.Close;
727	<	database.Free;
660	<
661	<	CloseDataConnection(DataConnections[conIndex]);
662	<	end;
663	<
664	<
665	<
666	<
667	<	procedure TForm_LevelDB.stop_convert;
668	<	begin
669	<	btn_abortok.Caption := '&Close';
670	<	btn_abortok.Default := True;
671	<	converting := False;
672	<	lbl_estimation.Caption := 'ABORTED';
673	<	group_progress.Caption := 'Creating DB (ABORTED)';
726	>	Query.Close;
727	>	Query.Free;
728		DataBase.Close;
729	<	if MessageBox(Self.Handle, PChar('Delete the unfinished DB-file?'),
676	<	PChar('Delete file?'), MB_YESNO) = idYes then
677	<	begin
678	<	DeleteFile(loaded_filename);
679	<	end;
729	>	DataBase.Free;
730		end;
731
732
#	Line 699 | Line 749 | begin
749		end;
750
751
702	–
703	–
704	–	procedure InsertDatLinkToDB(fileid: LongWord; offset: LongWord);
705	–	var
706	–	link: LongWord;
707	–	begin
708	–	OniDataConnection.LoadDatFilePart(fileid, offset, 4, @link);
709	–	if link = 0 then
710	–	link := $FFFFFFFF
711	–	else
712	–	link := link div 256;
713	–	Query.SQL.Text := 'INSERT INTO linkmap (src_id,src_link_offset,target_id) VALUES (' +
714	–	IntToStr(fileid) + ',' + IntToStr(offset) + ',' + IntToStr(link) + ');';
715	–	Query.ExecSQL;
716	–	end;
717	–
718	–
719	–
720	–
721	–	procedure AISA(fileid: LongWord; dir_dat2db: Boolean);
722	–	var
723	–	packages: Word;
724	–	i: LongWord;
725	–	begin
726	–	if dir_dat2db then
727	–	begin
728	–	OniDataConnection.LoadDatFilePart(fileid, $1E, 2, @packages);
729	–	if packages > 0 then
730	–	begin
731	–	for i := 0 to packages - 1 do
732	–	InsertDatLinkToDB(fileid, $20 + i * $160 + $28);
733	–	for i := 0 to packages - 1 do
734	–	InsertDatLinkToDB(fileid, $20 + i * $160 + $150);
735	–	end;
736	–	end
737	–	else
738	–	begin
739	–	end;
740	–	end;
741	–
742	–
743	–
744	–
745	–	procedure AKEV(fileid: LongWord; dir_dat2db: Boolean);
746	–	var
747	–	i: LongWord;
748	–	begin
749	–	if dir_dat2db then
750	–	begin
751	–	for i := 0 to 16 do
752	–	InsertDatLinkToDB(fileid, $8 + i * 4);
753	–	end
754	–	else
755	–	begin
756	–	end;
757	–	end;
758	–
759	–
760	–
761	–
762	–	procedure AKOT(fileid: LongWord; dir_dat2db: Boolean);
763	–	var
764	–	i: LongWord;
765	–	begin
766	–	if dir_dat2db then
767	–	begin
768	–	for i := 0 to 4 do
769	–	InsertDatLinkToDB(fileid, $8 + i * 4);
770	–	end
771	–	else
772	–	begin
773	–	end;
774	–	end;
775	–
776	–
777	–
778	–
779	–	procedure CBPI(fileid: LongWord; dir_dat2db: Boolean);
780	–	var
781	–	i: LongWord;
782	–	begin
783	–	if dir_dat2db then
784	–	begin
785	–	for i := 0 to 56 do
786	–	InsertDatLinkToDB(fileid, $8 + i * 4);
787	–	end
788	–	else
789	–	begin
790	–	end;
791	–	end;
792	–
793	–
794	–
795	–
796	–	procedure CBPM(fileid: LongWord; dir_dat2db: Boolean);
797	–	var
798	–	i: LongWord;
799	–	begin
800	–	if dir_dat2db then
801	–	begin
802	–	for i := 0 to 18 do
803	–	InsertDatLinkToDB(fileid, $8 + i * 4);
804	–	end
805	–	else
806	–	begin
807	–	end;
808	–	end;
809	–
810	–
811	–
812	–
813	–	procedure CONS(fileid: LongWord; dir_dat2db: Boolean);
814	–	var
815	–	i: LongWord;
816	–	begin
817	–	if dir_dat2db then
818	–	begin
819	–	for i := 0 to 1 do
820	–	InsertDatLinkToDB(fileid, $24 + i * 4);
821	–	end
822	–	else
823	–	begin
824	–	end;
825	–	end;
826	–
827	–
828	–
829	–
830	–	procedure CRSA(fileid: LongWord; dir_dat2db: Boolean);
831	–	var
832	–	packages: LongWord;
833	–	i: LongWord;
834	–	begin
835	–	if dir_dat2db then
836	–	begin
837	–	OniDataConnection.LoadDatFilePart(fileid, $14, 4, @packages);
838	–	if packages > 0 then
839	–	for i := 0 to packages - 1 do
840	–	InsertDatLinkToDB(fileid, $20 + i * 1100 + $A0);
841	–	end
842	–	else
843	–	begin
844	–	end;
845	–	end;
846	–
847	–
848	–
849	–
850	–	procedure DOOR(fileid: LongWord; dir_dat2db: Boolean);
851	–	begin
852	–	if dir_dat2db then
853	–	begin
854	–	InsertDatLinkToDB(fileid, $08);
855	–	InsertDatLinkToDB(fileid, $10);
856	–	end
857	–	else
858	–	begin
859	–	end;
860	–	end;
861	–
862	–
863	–
864	–
865	–	procedure DPGE(fileid: LongWord; dir_dat2db: Boolean);
866	–	begin
867	–	if dir_dat2db then
868	–	begin
869	–	InsertDatLinkToDB(fileid, $40);
870	–	end
871	–	else
872	–	begin
873	–	end;
874	–	end;
875	–
876	–
877	–
878	–
879	–	procedure HPGE(fileid: LongWord; dir_dat2db: Boolean);
880	–	begin
881	–	if dir_dat2db then
882	–	begin
883	–	InsertDatLinkToDB(fileid, $0C);
884	–	end
885	–	else
886	–	begin
887	–	end;
888	–	end;
889	–
890	–
891	–
892	–
893	–	procedure IGHH(fileid: LongWord; dir_dat2db: Boolean);
894	–	begin
895	–	if dir_dat2db then
896	–	begin
897	–	InsertDatLinkToDB(fileid, $24);
898	–	InsertDatLinkToDB(fileid, $28);
899	–	end
900	–	else
901	–	begin
902	–	end;
903	–	end;
904	–
905	–
906	–
907	–
908	–	procedure IGPA(fileid: LongWord; dir_dat2db: Boolean);
909	–	var
910	–	links: LongWord;
911	–	i:     LongWord;
912	–	begin
913	–	if dir_dat2db then
914	–	begin
915	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @links);
916	–	if links > 0 then
917	–	for i := 0 to links - 1 do
918	–	InsertDatLinkToDB(fileid, $20 + i * 4);
919	–	end
920	–	else
921	–	begin
922	–	end;
923	–	end;
924	–
925	–
926	–
927	–
928	–	procedure IGPG(fileid: LongWord; dir_dat2db: Boolean);
929	–	var
930	–	i: LongWord;
931	–	begin
932	–	if dir_dat2db then
933	–	begin
934	–	for i := 0 to 1 do
935	–	InsertDatLinkToDB(fileid, $1C + i * 4);
936	–	end
937	–	else
938	–	begin
939	–	end;
940	–	end;
941	–
942	–
943	–
944	–
945	–	procedure IGSA(fileid: LongWord; dir_dat2db: Boolean);
946	–	var
947	–	links: LongWord;
948	–	i:     LongWord;
949	–	begin
950	–	if dir_dat2db then
951	–	begin
952	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @links);
953	–	if links > 0 then
954	–	for i := 0 to links - 1 do
955	–	InsertDatLinkToDB(fileid, $20 + i * 4);
956	–	end
957	–	else
958	–	begin
959	–	end;
960	–	end;
961	–
962	–
963	–
964	–
965	–	procedure IMPT(fileid: LongWord; dir_dat2db: Boolean);
966	–	begin
967	–	if dir_dat2db then
968	–	begin
969	–	InsertDatLinkToDB(fileid, $10);
970	–	end
971	–	else
972	–	begin
973	–	end;
974	–	end;
975	–
976	–
977	–
978	–
979	–	procedure IPGE(fileid: LongWord; dir_dat2db: Boolean);
980	–	begin
981	–	if dir_dat2db then
982	–	begin
983	–	InsertDatLinkToDB(fileid, $0C);
984	–	end
985	–	else
986	–	begin
987	–	end;
988	–	end;
989	–
990	–
991	–
992	–
993	–	procedure KEYI(fileid: LongWord; dir_dat2db: Boolean);
994	–	var
995	–	i: LongWord;
996	–	begin
997	–	if dir_dat2db then
998	–	begin
999	–	for i := 0 to 9 do
1000	–	InsertDatLinkToDB(fileid, $08 + i * 4);
1001	–	end
1002	–	else
1003	–	begin
1004	–	end;
1005	–	end;
1006	–
1007	–
1008	–
1009	–
1010	–	procedure M3GA(fileid: LongWord; dir_dat2db: Boolean);
1011	–	var
1012	–	links: LongWord;
1013	–	i:     LongWord;
1014	–	begin
1015	–	if dir_dat2db then
1016	–	begin
1017	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @links);
1018	–	if links > 0 then
1019	–	for i := 0 to links - 1 do
1020	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1021	–	end
1022	–	else
1023	–	begin
1024	–	end;
1025	–	end;
1026	–
1027	–
1028	–
1029	–
1030	–	procedure M3GM(fileid: LongWord; dir_dat2db: Boolean);
1031	–	var
1032	–	i: LongWord;
1033	–	begin
1034	–	if dir_dat2db then
1035	–	begin
1036	–	for i := 0 to 6 do
1037	–	InsertDatLinkToDB(fileid, $0C + i * 4);
1038	–	end
1039	–	else
1040	–	begin
1041	–	end;
1042	–	end;
1043	–
1044	–
1045	–
1046	–
1047	–	procedure MTRL(fileid: LongWord; dir_dat2db: Boolean);
1048	–	begin
1049	–	if dir_dat2db then
1050	–	begin
1051	–	InsertDatLinkToDB(fileid, $10);
1052	–	end
1053	–	else
1054	–	begin
1055	–	end;
1056	–	end;
1057	–
1058	–
1059	–
1060	–
1061	–	procedure OBDC(fileid: LongWord; dir_dat2db: Boolean);
1062	–	var
1063	–	packages: Word;
1064	–	i: LongWord;
1065	–	begin
1066	–	if dir_dat2db then
1067	–	begin
1068	–	OniDataConnection.LoadDatFilePart(fileid, $1E, 2, @packages);
1069	–	if packages > 0 then
1070	–	for i := 0 to packages - 1 do
1071	–	InsertDatLinkToDB(fileid, $20 + i * $18 + $4);
1072	–	end
1073	–	else
1074	–	begin
1075	–	end;
1076	–	end;
1077	–
1078	–
1079	–
1080	–
1081	–	procedure OBOA(fileid: LongWord; dir_dat2db: Boolean);
1082	–	var
1083	–	packages: Word;
1084	–	i: LongWord;
1085	–	begin
1086	–	if dir_dat2db then
1087	–	begin
1088	–	OniDataConnection.LoadDatFilePart(fileid, $1E, 2, @packages);
1089	–	if packages > 0 then
1090	–	for i := 0 to packages - 1 do
1091	–	begin
1092	–	InsertDatLinkToDB(fileid, $20 + i * 240 + $0);
1093	–	InsertDatLinkToDB(fileid, $20 + i * 240 + $4);
1094	–	InsertDatLinkToDB(fileid, $20 + i * 240 + $8);
1095	–	end;
1096	–	end
1097	–	else
1098	–	begin
1099	–	end;
1100	–	end;
1101	–
1102	–
1103	–
1104	–
1105	–	procedure OFGA(fileid: LongWord; dir_dat2db: Boolean);
1106	–	var
1107	–	packages: LongWord;
1108	–	i: LongWord;
1109	–	begin
1110	–	if dir_dat2db then
1111	–	begin
1112	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1113	–	if packages > 0 then
1114	–	for i := 0 to packages - 1 do
1115	–	InsertDatLinkToDB(fileid, $20 + i * 12 + $04);
1116	–	end
1117	–	else
1118	–	begin
1119	–	end;
1120	–	end;
1121	–
1122	–
1123	–
1124	–
1125	–	procedure ONCC(fileid: LongWord; dir_dat2db: Boolean);
1126	–	var
1127	–	i: LongWord;
1128	–	begin
1129	–	if dir_dat2db then
1130	–	begin
1131	–	InsertDatLinkToDB(fileid, $28);
1132	–	InsertDatLinkToDB(fileid, $434);
1133	–	InsertDatLinkToDB(fileid, $438);
1134	–	InsertDatLinkToDB(fileid, $43C);
1135	–	InsertDatLinkToDB(fileid, $C3C);
1136	–	InsertDatLinkToDB(fileid, $C40);
1137	–	InsertDatLinkToDB(fileid, $C44);
1138	–	InsertDatLinkToDB(fileid, $C48);
1139	–	InsertDatLinkToDB(fileid, $C88);
1140	–	InsertDatLinkToDB(fileid, $C8C);
1141	–	end
1142	–	else
1143	–	begin
1144	–	end;
1145	–	end;
1146	–
1147	–
1148	–
1149	–
1150	–	procedure ONCV(fileid: LongWord; dir_dat2db: Boolean);
1151	–	begin
1152	–	if dir_dat2db then
1153	–	begin
1154	–	InsertDatLinkToDB(fileid, $08);
1155	–	end
1156	–	else
1157	–	begin
1158	–	end;
1159	–	end;
1160	–
1161	–
1162	–
1163	–
1164	–	procedure ONLV(fileid: LongWord; dir_dat2db: Boolean);
1165	–	var
1166	–	i: LongWord;
1167	–	begin
1168	–	if dir_dat2db then
1169	–	begin
1170	–	for i := 0 to 5 do
1171	–	InsertDatLinkToDB(fileid, $48 + i * 4);
1172	–	for i := 0 to 5 do
1173	–	InsertDatLinkToDB(fileid, $64 + i * 4);
1174	–	InsertDatLinkToDB(fileid, $300);
1175	–	end
1176	–	else
1177	–	begin
1178	–	end;
1179	–	end;
1180	–
1181	–
1182	–
1183	–
1184	–	procedure ONOA(fileid: LongWord; dir_dat2db: Boolean);
1185	–	var
1186	–	packages: LongWord;
1187	–	i: LongWord;
1188	–	begin
1189	–	if dir_dat2db then
1190	–	begin
1191	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1192	–	if packages > 0 then
1193	–	for i := 0 to packages - 1 do
1194	–	InsertDatLinkToDB(fileid, $20 + i * 8 + $04);
1195	–	end
1196	–	else
1197	–	begin
1198	–	end;
1199	–	end;
1200	–
1201	–
1202	–
1203	–
1204	–	procedure ONSK(fileid: LongWord; dir_dat2db: Boolean);
1205	–	begin
1206	–	if dir_dat2db then
1207	–	begin
1208	–	InsertDatLinkToDB(fileid, $08);
1209	–	InsertDatLinkToDB(fileid, $0C);
1210	–	InsertDatLinkToDB(fileid, $10);
1211	–	InsertDatLinkToDB(fileid, $14);
1212	–	InsertDatLinkToDB(fileid, $18);
1213	–	InsertDatLinkToDB(fileid, $20);
1214	–	InsertDatLinkToDB(fileid, $44);
1215	–	end
1216	–	else
1217	–	begin
1218	–	end;
1219	–	end;
1220	–
1221	–
1222	–
1223	–
1224	–	procedure ONVL(fileid: LongWord; dir_dat2db: Boolean);
1225	–	var
1226	–	packages: LongWord;
1227	–	i: LongWord;
1228	–	begin
1229	–	if dir_dat2db then
1230	–	begin
1231	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1232	–	if packages > 0 then
1233	–	for i := 0 to packages - 1 do
1234	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1235	–	end
1236	–	else
1237	–	begin
1238	–	end;
1239	–	end;
1240	–
1241	–
1242	–
1243	–
1244	–	procedure ONWC(fileid: LongWord; dir_dat2db: Boolean);
1245	–	begin
1246	–	if dir_dat2db then
1247	–	begin
1248	–	InsertDatLinkToDB(fileid, $28);
1249	–	InsertDatLinkToDB(fileid, $34);
1250	–	InsertDatLinkToDB(fileid, $40);
1251	–	InsertDatLinkToDB(fileid, $54);
1252	–	InsertDatLinkToDB(fileid, $58);
1253	–	InsertDatLinkToDB(fileid, $5C);
1254	–	InsertDatLinkToDB(fileid, $60);
1255	–	InsertDatLinkToDB(fileid, $6FC);
1256	–	InsertDatLinkToDB(fileid, $700);
1257	–	end
1258	–	else
1259	–	begin
1260	–	end;
1261	–	end;
1262	–
1263	–
1264	–
1265	–
1266	–	procedure OPGE(fileid: LongWord; dir_dat2db: Boolean);
1267	–	begin
1268	–	if dir_dat2db then
1269	–	begin
1270	–	InsertDatLinkToDB(fileid, $0C);
1271	–	end
1272	–	else
1273	–	begin
1274	–	end;
1275	–	end;
1276	–
1277	–
1278	–
1279	–
1280	–	procedure PSPC(fileid: LongWord; dir_dat2db: Boolean);
1281	–	begin
1282	–	if dir_dat2db then
1283	–	begin
1284	–	InsertDatLinkToDB(fileid, $50);
1285	–	end
1286	–	else
1287	–	begin
1288	–	end;
1289	–	end;
1290	–
1291	–
1292	–
1293	–
1294	–	procedure PSPL(fileid: LongWord; dir_dat2db: Boolean);
1295	–	var
1296	–	packages: LongWord;
1297	–	i: LongWord;
1298	–	begin
1299	–	if dir_dat2db then
1300	–	begin
1301	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1302	–	if packages > 0 then
1303	–	for i := 0 to packages - 1 do
1304	–	InsertDatLinkToDB(fileid, $20 + i * 8 + $4);
1305	–	end
1306	–	else
1307	–	begin
1308	–	end;
1309	–	end;
1310	–
1311	–
1312	–
1313	–
1314	–	procedure PSUI(fileid: LongWord; dir_dat2db: Boolean);
1315	–	var
1316	–	i: LongWord;
1317	–	begin
1318	–	if dir_dat2db then
1319	–	begin
1320	–	for i := 0 to 43 do
1321	–	InsertDatLinkToDB(fileid, $08 + i * 4);
1322	–	end
1323	–	else
1324	–	begin
1325	–	end;
1326	–	end;
1327	–
1328	–
1329	–
1330	–
1331	–	procedure STNA(fileid: LongWord; dir_dat2db: Boolean);
1332	–	var
1333	–	packages: Word;
1334	–	i: LongWord;
1335	–	begin
1336	–	if dir_dat2db then
1337	–	begin
1338	–	OniDataConnection.LoadDatFilePart(fileid, $1E, 2, @packages);
1339	–	if packages > 0 then
1340	–	for i := 0 to packages - 1 do
1341	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1342	–	end
1343	–	else
1344	–	begin
1345	–	end;
1346	–	end;
1347	–
1348	–
1349	–
1350	–
1351	–	procedure TRAC(fileid: LongWord; dir_dat2db: Boolean);
1352	–	var
1353	–	packages: Word;
1354	–	i: LongWord;
1355	–	begin
1356	–	if dir_dat2db then
1357	–	begin
1358	–	InsertDatLinkToDB(fileid, $18);
1359	–	OniDataConnection.LoadDatFilePart(fileid, $1E, 2, @packages);
1360	–	if packages > 0 then
1361	–	for i := 0 to packages - 1 do
1362	–	InsertDatLinkToDB(fileid, $20 + i * 12 + 8);
1363	–	end
1364	–	else
1365	–	begin
1366	–	end;
1367	–	end;
1368	–
1369	–
1370	–
1371	–
1372	–	procedure TRAM(fileid: LongWord; dir_dat2db: Boolean);
1373	–	begin
1374	–	if dir_dat2db then
1375	–	begin
1376	–	InsertDatLinkToDB(fileid, $40);
1377	–	InsertDatLinkToDB(fileid, $44);
1378	–	end
1379	–	else
1380	–	begin
1381	–	end;
1382	–	end;
1383	–
1384	–
1385	–
1386	–
1387	–	procedure TRAS(fileid: LongWord; dir_dat2db: Boolean);
1388	–	begin
1389	–	if dir_dat2db then
1390	–	begin
1391	–	InsertDatLinkToDB(fileid, $08);
1392	–	end
1393	–	else
1394	–	begin
1395	–	end;
1396	–	end;
1397	–
1398	–
1399	–
1400	–
1401	–	procedure TRBS(fileid: LongWord; dir_dat2db: Boolean);
1402	–	var
1403	–	i: LongWord;
1404	–	begin
1405	–	if dir_dat2db then
1406	–	begin
1407	–	for i := 0 to 4 do
1408	–	InsertDatLinkToDB(fileid, $08 + i * 4);
1409	–	end
1410	–	else
1411	–	begin
1412	–	end;
1413	–	end;
1414	–
1415	–
1416	–
1417	–
1418	–	procedure TRCM(fileid: LongWord; dir_dat2db: Boolean);
1419	–	var
1420	–	i: LongWord;
1421	–	begin
1422	–	if dir_dat2db then
1423	–	begin
1424	–	for i := 0 to 2 do
1425	–	InsertDatLinkToDB(fileid, $5C + i * 4);
1426	–	end
1427	–	else
1428	–	begin
1429	–	end;
1430	–	end;
1431	–
1432	–
1433	–
1434	–
1435	–	procedure TRGA(fileid: LongWord; dir_dat2db: Boolean);
1436	–	var
1437	–	i: LongWord;
1438	–	packages: Word;
1439	–	begin
1440	–	if dir_dat2db then
1441	–	begin
1442	–	OniDataConnection.LoadDatFilePart(fileid, $1E, 2, @packages);
1443	–	if packages > 0 then
1444	–	for i := 0 to packages - 1 do
1445	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1446	–	end
1447	–	else
1448	–	begin
1449	–	end;
1450	–	end;
1451	–
1452	–
1453	–
1454	–
1455	–	procedure TRGE(fileid: LongWord; dir_dat2db: Boolean);
1456	–	begin
1457	–	if dir_dat2db then
1458	–	begin
1459	–	InsertDatLinkToDB(fileid, $20);
1460	–	end
1461	–	else
1462	–	begin
1463	–	end;
1464	–	end;
1465	–
1466	–
1467	–
1468	–
1469	–	procedure TRIG(fileid: LongWord; dir_dat2db: Boolean);
1470	–	begin
1471	–	if dir_dat2db then
1472	–	begin
1473	–	InsertDatLinkToDB(fileid, $18);
1474	–	InsertDatLinkToDB(fileid, $24);
1475	–	InsertDatLinkToDB(fileid, $28);
1476	–	end
1477	–	else
1478	–	begin
1479	–	end;
1480	–	end;
1481	–
1482	–
1483	–
1484	–
1485	–	procedure TRMA(fileid: LongWord; dir_dat2db: Boolean);
1486	–	var
1487	–	i: LongWord;
1488	–	packages: Word;
1489	–	begin
1490	–	if dir_dat2db then
1491	–	begin
1492	–	OniDataConnection.LoadDatFilePart(fileid, $1E, 2, @packages);
1493	–	if packages > 0 then
1494	–	for i := 0 to packages - 1 do
1495	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1496	–	end
1497	–	else
1498	–	begin
1499	–	end;
1500	–	end;
1501	–
1502	–
1503	–
1504	–
1505	–	procedure TRSC(fileid: LongWord; dir_dat2db: Boolean);
1506	–	var
1507	–	i: LongWord;
1508	–	packages: Word;
1509	–	begin
1510	–	if dir_dat2db then
1511	–	begin
1512	–	OniDataConnection.LoadDatFilePart(fileid, $1E, 2, @packages);
1513	–	if packages > 0 then
1514	–	for i := 0 to packages - 1 do
1515	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1516	–	end
1517	–	else
1518	–	begin
1519	–	end;
1520	–	end;
1521	–
1522	–
1523	–
1524	–
1525	–	procedure TSFF(fileid: LongWord; dir_dat2db: Boolean);
1526	–	var
1527	–	i: LongWord;
1528	–	packages: LongWord;
1529	–	begin
1530	–	if dir_dat2db then
1531	–	begin
1532	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1533	–	if packages > 0 then
1534	–	for i := 0 to packages - 1 do
1535	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1536	–	end
1537	–	else
1538	–	begin
1539	–	end;
1540	–	end;
1541	–
1542	–
1543	–
1544	–
1545	–	procedure TSFT(fileid: LongWord; dir_dat2db: Boolean);
1546	–	begin
1547	–	if dir_dat2db then
1548	–	begin
1549	–	InsertDatLinkToDB(fileid, $1C);
1550	–	end
1551	–	else
1552	–	begin
1553	–	end;
1554	–	end;
1555	–
1556	–
1557	–
1558	–
1559	–	procedure TURR(fileid: LongWord; dir_dat2db: Boolean);
1560	–	begin
1561	–	if dir_dat2db then
1562	–	begin
1563	–	InsertDatLinkToDB(fileid, $60);
1564	–	InsertDatLinkToDB(fileid, $6C);
1565	–	InsertDatLinkToDB(fileid, $74);
1566	–	end
1567	–	else
1568	–	begin
1569	–	end;
1570	–	end;
1571	–
1572	–
1573	–
1574	–
1575	–	procedure TXAN(fileid: LongWord; dir_dat2db: Boolean);
1576	–	var
1577	–	i: LongWord;
1578	–	packages: LongWord;
1579	–	begin
1580	–	if dir_dat2db then
1581	–	begin
1582	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1583	–	if packages > 0 then
1584	–	for i := 0 to packages - 1 do
1585	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1586	–	end
1587	–	else
1588	–	begin
1589	–	end;
1590	–	end;
1591	–
1592	–
1593	–
1594	–
1595	–	procedure TXMA(fileid: LongWord; dir_dat2db: Boolean);
1596	–	var
1597	–	i: LongWord;
1598	–	packages: LongWord;
1599	–	begin
1600	–	if dir_dat2db then
1601	–	begin
1602	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1603	–	if packages > 0 then
1604	–	for i := 0 to packages - 1 do
1605	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1606	–	end
1607	–	else
1608	–	begin
1609	–	end;
1610	–	end;
1611	–
1612	–
1613	–
1614	–
1615	–	procedure TXMB(fileid: LongWord; dir_dat2db: Boolean);
1616	–	var
1617	–	i: LongWord;
1618	–	packages: LongWord;
1619	–	begin
1620	–	if dir_dat2db then
1621	–	begin
1622	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1623	–	if packages > 0 then
1624	–	for i := 0 to packages - 1 do
1625	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1626	–	end
1627	–	else
1628	–	begin
1629	–	end;
1630	–	end;
1631	–
1632	–
1633	–
1634	–
1635	–	procedure TXMP(fileid: LongWord; dir_dat2db: Boolean);
1636	–	begin
1637	–	if dir_dat2db then
1638	–	begin
1639	–	InsertDatLinkToDB(fileid, $94);
1640	–	InsertDatLinkToDB(fileid, $98);
1641	–	end
1642	–	else
1643	–	begin
1644	–	end;
1645	–	end;
1646	–
1647	–
1648	–
1649	–
1650	–	procedure TXTC(fileid: LongWord; dir_dat2db: Boolean);
1651	–	begin
1652	–	if dir_dat2db then
1653	–	begin
1654	–	InsertDatLinkToDB(fileid, $08);
1655	–	end
1656	–	else
1657	–	begin
1658	–	end;
1659	–	end;
1660	–
1661	–
1662	–
1663	–
1664	–	procedure WMCL(fileid: LongWord; dir_dat2db: Boolean);
1665	–	var
1666	–	i: LongWord;
1667	–	packages: LongWord;
1668	–	begin
1669	–	if dir_dat2db then
1670	–	begin
1671	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1672	–	if packages > 0 then
1673	–	for i := 0 to packages - 1 do
1674	–	InsertDatLinkToDB(fileid, $20 + i * 8 + $4);
1675	–	end
1676	–	else
1677	–	begin
1678	–	end;
1679	–	end;
1680	–
1681	–
1682	–
1683	–
1684	–	procedure WMDD(fileid: LongWord; dir_dat2db: Boolean);
1685	–	var
1686	–	i: LongWord;
1687	–	packages: LongWord;
1688	–	begin
1689	–	if dir_dat2db then
1690	–	begin
1691	–	OniDataConnection.LoadDatFilePart(fileid, $11C, 4, @packages);
1692	–	if packages > 0 then
1693	–	for i := 0 to packages - 1 do
1694	–	InsertDatLinkToDB(fileid, $120 + i * $124 + $114);
1695	–	end
1696	–	else
1697	–	begin
1698	–	end;
1699	–	end;
1700	–
1701	–
1702	–
1703	–
1704	–	procedure WMMB(fileid: LongWord; dir_dat2db: Boolean);
1705	–	var
1706	–	i: LongWord;
1707	–	packages: LongWord;
1708	–	begin
1709	–	if dir_dat2db then
1710	–	begin
1711	–	OniDataConnection.LoadDatFilePart(fileid, $1C, 4, @packages);
1712	–	if packages > 0 then
1713	–	for i := 0 to packages - 1 do
1714	–	InsertDatLinkToDB(fileid, $20 + i * 4);
1715	–	end
1716	–	else
1717	–	begin
1718	–	end;
1719	–	end;
1720	–
1721	–
1722	–
1723	–
1724	–	procedure WPGE(fileid: LongWord; dir_dat2db: Boolean);
1725	–	begin
1726	–	if dir_dat2db then
1727	–	begin
1728	–	InsertDatLinkToDB(fileid, $08);
1729	–	InsertDatLinkToDB(fileid, $0C);
1730	–	end
1731	–	else
1732	–	begin
1733	–	end;
1734	–	end;
1735	–
1736	–
1737	–
1738	–
1739	–	procedure InsertHandler(ext: String; needed: Boolean; handler: THandler);
1740	–	begin
1741	–	SetLength(ConvertHandlers, Length(ConvertHandlers) + 1);
1742	–	ConvertHandlers[High(ConvertHandlers)].Ext     := ext;
1743	–	ConvertHandlers[High(ConvertHandlers)].needed  := needed;
1744	–	ConvertHandlers[High(ConvertHandlers)].handler := handler;
1745	–	end;
1746	–
1747	–	begin
1748	–	InsertHandler('ABNA', False, nil);
1749	–	//  InsertHandler('AGDB',True,AGDB);
1750	–	InsertHandler('AGDB', False, nil);
1751	–	InsertHandler('AGQC', False, nil);
1752	–	InsertHandler('AGQG', False, nil);
1753	–	InsertHandler('AGQR', False, nil);
1754	–	InsertHandler('AISA', True, AISA);
1755	–	InsertHandler('AITR', False, nil);
1756	–	InsertHandler('AKAA', False, nil);
1757	–	InsertHandler('AKBA', False, nil);
1758	–	InsertHandler('AKBP', False, nil);
1759	–	InsertHandler('AKDA', False, nil);
1760	–	InsertHandler('AKEV', True, AKEV);
1761	–	InsertHandler('AKOT', True, AKOT);
1762	–	InsertHandler('AKVA', False, nil);
1763	–	InsertHandler('BINA', False, nil);
1764	–	InsertHandler('CBPI', True, CBPI);
1765	–	InsertHandler('CBPM', True, CBPM);
1766	–	InsertHandler('CONS', True, CONS);
1767	–	InsertHandler('CRSA', True, CRSA);
1768	–	InsertHandler('DOOR', True, DOOR);
1769	–	InsertHandler('DPGE', True, DPGE);
1770	–	InsertHandler('ENVP', False, nil);
1771	–	InsertHandler('FILM', False, nil);
1772	–	InsertHandler('HPGE', True, HPGE);
1773	–	InsertHandler('IDXA', False, nil);
1774	–	InsertHandler('IGHH', True, IGHH);
1775	–	InsertHandler('IGPA', True, IGPA);
1776	–	InsertHandler('IGPG', True, IGPG);
1777	–	InsertHandler('IGSA', True, IGSA);
1778	–	InsertHandler('IMPT', True, IMPT);
1779	–	InsertHandler('IPGE', True, IPGE);
1780	–	InsertHandler('KEYI', True, KEYI);
1781	–	InsertHandler('M3GA', True, M3GA);
1782	–	InsertHandler('M3GM', True, M3GM);
1783	–	InsertHandler('MTRL', True, MTRL);
1784	–	InsertHandler('OBAN', False, nil);
1785	–	InsertHandler('OBDC', True, OBDC);
1786	–	InsertHandler('OBOA', True, OBOA);
1787	–	InsertHandler('OFGA', True, OFGA);
1788	–	InsertHandler('ONCC', True, ONCC);
1789	–	InsertHandler('ONCP', False, nil);
1790	–	InsertHandler('ONCV', True, ONCV);
1791	–	InsertHandler('ONFA', False, nil);
1792	–	InsertHandler('ONGS', False, nil);
1793	–	InsertHandler('ONIA', False, nil);
1794	–	InsertHandler('ONLD', False, nil);
1795	–	InsertHandler('ONLV', True, ONLV);
1796	–	InsertHandler('ONMA', False, nil);
1797	–	InsertHandler('ONOA', True, ONOA);
1798	–	InsertHandler('ONSA', False, nil);
1799	–	InsertHandler('ONSK', True, ONSK);
1800	–	InsertHandler('ONTA', False, nil);
1801	–	InsertHandler('ONVL', True, ONVL);
1802	–	InsertHandler('ONWC', True, ONWC);
1803	–	InsertHandler('OPGE', True, OPGE);
1804	–	InsertHandler('OSBD', False, nil);
1805	–	InsertHandler('OTIT', False, nil);
1806	–	InsertHandler('OTLF', False, nil);
1807	–	InsertHandler('PLEA', False, nil);
1808	–	InsertHandler('PNTA', False, nil);
1809	–	InsertHandler('PSPC', True, PSPC);
1810	–	InsertHandler('PSPL', True, PSPL);
1811	–	InsertHandler('PSUI', True, PSUI);
1812	–	InsertHandler('QTNA', False, nil);
1813	–	InsertHandler('SNDD', False, nil);
1814	–	InsertHandler('STNA', True, STNA);
1815	–	InsertHandler('SUBT', False, nil);
1816	–	InsertHandler('TRAC', True, TRAC);
1817	–	InsertHandler('TRAM', True, TRAM);
1818	–	InsertHandler('TRAS', True, TRAS);
1819	–	InsertHandler('TRBS', True, TRBS);
1820	–	InsertHandler('TRCM', True, TRCM);
1821	–	InsertHandler('TRGA', True, TRGA);
1822	–	InsertHandler('TRGE', True, TRGE);
1823	–	InsertHandler('TRIA', False, nil);
1824	–	InsertHandler('TRIG', True, TRIG);
1825	–	InsertHandler('TRMA', True, TRMA);
1826	–	InsertHandler('TRSC', True, TRSC);
1827	–	InsertHandler('TRTA', False, nil);
1828	–	InsertHandler('TSFF', True, TSFF);
1829	–	InsertHandler('TSFL', False, nil);
1830	–	InsertHandler('TSFT', True, TSFT);
1831	–	InsertHandler('TSGA', False, nil);
1832	–	InsertHandler('TSTR', False, nil);
1833	–	InsertHandler('TURR', True, TURR);
1834	–	InsertHandler('TXAN', True, TXAN);
1835	–	InsertHandler('TXCA', False, nil);
1836	–	InsertHandler('TXMA', True, TXMA);
1837	–	InsertHandler('TXMB', True, TXMB);
1838	–	InsertHandler('TXMP', True, TXMP);
1839	–	InsertHandler('TXTC', True, TXTC);
1840	–	InsertHandler('VCRA', False, nil);
1841	–	InsertHandler('WMCL', True, WMCL);
1842	–	InsertHandler('WMDD', True, WMDD);
1843	–	InsertHandler('WMM_', False, nil);
1844	–	InsertHandler('WMMB', True, WMMB);
1845	–	InsertHandler('WPGE', True, WPGE);
752		end.

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines (old)
>	Changed lines (new)