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 138 by alloc, Fri Mar 30 00:49:02 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 65 | Line 53 | var
53		Stream_Body, Stream_Names:          TMemoryStream;
54		Stream_Dat, Stream_Raw, Stream_Sep: TFileStream;
55
68	–	//  Data, rawdata: Tdata;
56		BeginTime, FileTime: Double;
57		Step:     Integer;
71	–	//  rawlist:  TRawDataList;
72	–	//  datlinks: TDatLinks;
73	–	OniImage:   TOniImage;
58		LevelID:    Integer;
59		TimeFormat: TFormatSettings;
60
#	Line 78 | Line 62 | var
62		Connection: TDataAccess;
63		ConRepMsg:  TStatusMessages;
64
65	+	FileID:     Integer;
66	+
67		Strings:    TStrings;
68		i, j:       Integer;
69		temps:      String;
70	+	tempi:      Integer;
71	+	tempb:      Byte;
72		FileInfo:   TFileInfo;
73	+	DatLinks:   TDatLinkList;
74	+	RawLinks:   TRawDataList;
75
76		DatFileStream, RawFileStream: TMemoryStream;
77	+
78	+	// ###########################
79	+	datsum, linksum, rawsum: Int64;
80	+	freq: Int64;
81	+	tempticks1, tempticks2: Int64;
82	+	// ###########################
83		const
84		Steps: Byte = 3;
85
#	Line 98 | Line 94 | const
94		group_progress.Caption := 'Creating Dat (FINISHED)';
95		end;
96
97	+	procedure StopConvert;
98	+	begin
99	+	btn_abortok.Caption := '&Close';
100	+	btn_abortok.Default := True;
101	+	converting := False;
102	+	lbl_estimation.Caption := 'ABORTED';
103	+	group_progress.Caption := 'Creating Level (ABORTED)';
104	+
105	+	Stream_Body.Free;
106	+	Stream_Names.Free;
107	+	DatFileStream.Free;
108	+	RawFileStream.Free;
109	+
110	+	Stream_Dat.Free;
111	+	Stream_Raw.Free;
112	+	if Connection.DataOS in [DOS_WINDEMO, DOS_MAC, DOS_MACBETA] then
113	+	Stream_Sep.Free;
114	+
115	+	if MessageBox(Self.Handle, PChar('Delete the unfinished level-files?'),
116	+	PChar('Delete files?'), MB_YESNO) = idYes then
117	+	begin
118	+	DeleteFile(target);
119	+	DeleteFile(AnsiReplaceStr(Target, '.dat', '.raw'));
120	+	if Connection.DataOS in [DOS_WINDEMO, DOS_MAC, DOS_MACBETA] then
121	+	DeleteFile(AnsiReplaceStr(Target, '.dat', '.sep'));
122	+	end;
123	+	end;
124	+
125		begin
126
127		//
#	Line 145 | Line 169 | begin
169		begin
170		ShowMessage('Couldn''t delete file. Aborting');
171		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;
172		end;
173	+	if FileExists(AnsiReplaceStr(Target, '.dat', '.raw')) then
174	+	if not DeleteFile(AnsiReplaceStr(Target, '.dat', '.raw')) then
175	+	begin
176	+	ShowMessage('Couldn''t delete file. Aborting');
177	+	Exit;
178	+	end;
179	+	if FileExists(AnsiReplaceStr(Target, '.dat', '.sep')) then
180	+	if Connection.DataOS in [DOS_WINDEMO, DOS_MAC, DOS_MACBETA] then
181	+	if not DeleteFile(AnsiReplaceStr(Target, '.dat', '.sep')) then
182	+	begin
183	+	ShowMessage('Couldn''t delete file. Aborting');
184	+	Exit;
185	+	end;
186		end else begin
187		ShowMessage('Aborting');
188		Exit;
#	Line 162 | Line 191 | begin
191
192		LevelID  := Connection.LevelNumber;
193		LevelID  := (LevelID * 2) * 256 * 256 * 256 + $01;
165	–	OniImage := TOniImage.Create;
194
195		Self.Visible := True;
196		Form_Main.Visible := False;
#	Line 269 | Line 297 | begin
297		lbl_estimation.Caption := 'Estimated finishing time: unknown';
298		Application.ProcessMessages;
299
300	+	QueryPerformanceFrequency(freq);
301	+	datsum := 0;
302	+	linksum := 0;
303	+	rawsum := 0;
304	+
305		FileTime := Time;
306	<	for i := 0 to DatHeader.Files - 1 do
306	>	for FileID := 0 to DatHeader.Files - 1 do
307		begin
308	<	FileInfo := Connection.GetFileInfo(i);
308	>	FileInfo := Connection.GetFileInfo(FileID);
309		for j := 0 to 3 do
310	<	FilesHeader[i].Extension[j] := FileInfo.Extension[4 - j];
310	>	FilesHeader[FileID].Extension[j] := FileInfo.Extension[4 - j];
311		if FileInfo.Size > 0 then
312		begin
313	<	//        DatLinks:=;
314	<	FilesHeader[i].DataAddr := Stream_Body.Size + 8;
313	>	QueryPerformanceCounter(tempticks1);
314	>
315	>	FilesHeader[FileID].DataAddr := Stream_Body.Size + 8;
316		DatFileStream := TMemoryStream.Create;
317	<	Connection.LoadDatFile(i, DatFileStream);
318	<	DatFileStream.Seek(4, soFromBeginning);
317	>	Connection.LoadDatFile(FileID, TStream(DatFileStream));
318	>	DatFileStream.Seek(0, soFromBeginning);
319	>	tempi := FileID * 256 + 1;
320	>	DatFileStream.Write(tempi, 4);
321		DatFileStream.Write(LevelID, 4);
322
323	<	if (Pos(UpperCase(fileinfo.Extension), UpperCase(raws)) mod 4) = 1 then
323	>	QueryPerformanceCounter(tempticks2);
324	>	datsum := datsum + (tempticks2 - tempticks1);
325	>
326	>	DatLinks := Connection.GetDatLinks(FileID);
327	>	if Length(DatLinks) > 0 then
328	>	begin
329	>	for i := 0 to High(DatLinks) do
330	>	begin
331	>	DatFileStream.Seek(DatLinks[i].SrcOffset, soFromBeginning);
332	>	if DatLinks[i].DestID < 0 then
333	>	tempi := 0
334	>	else
335	>	tempi := DatLinks[i].DestID * 256 + 1;
336	>	DatFileStream.Write(tempi, 4);
337	>	end;
338	>	end;
339	>
340	>	QueryPerformanceCounter(tempticks1);
341	>	linksum := linksum + (tempticks1 - tempticks2);
342	>
343	>	RawLinks := Connection.GetRawList(FileID);
344	>	if Length(RawLinks) > 0 then
345		begin
346	<	rawlist := OniDataConnection.GetRawList(i);
290	<	if Length(rawlist) > 0 then
346	>	for i := 0 to High(RawLinks) do
347		begin
348	<	for j := 0 to High(rawlist) do
348	>	if RawLinks[i].RawSize > 0 then
349		begin
350	<	if rawlist[j].raw_size > 0 then
350	>	RawFileStream := TMemoryStream.Create;
351	>	Connection.LoadRawFile(FileID, RawLinks[i].SrcOffset, TStream(RawFileStream));
352	>	RawFileStream.Seek(0, soFromBeginning);
353	>	if RawLinks[i].LocSep then
354		begin
355	<	if (UpperCase(fileinfo.Extension) = 'TXMP') and
356	<	((Data[$88] and $01) > 0) then
357	<	begin
358	<	OniImage.LoadFromTXMP(Connection, i);
359	<	OniImage.GetMipMappedImage(rawdata);
360	<	rawlist[j].raw_size := OniImage.GetImageDataSize(True);
361	<	Data[$90] := $08;
362	<	Data[$89] := 32;
363	<	{                  if data[$90]<>OniImage.StoreType then begin
364	<	data[$90]:=OniImage.StoreType;
306	<	data[$89]:=(data[$89] and $CF) or $20;
307	<	end;
308	<	}                end
309	<	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;
355	>	RawLinks[i].RawAddr := Stream_Sep.Size;
356	>	Stream_sep.CopyFrom(RawFileStream, RawFileStream.Size);
357	>	end else begin
358	>	RawLinks[i].RawAddr := Stream_Raw.Size;
359	>	Stream_Raw.CopyFrom(RawFileStream, RawFileStream.Size);
360	>	end;
361	>	end else
362	>	RawLinks[i].RawAddr := 0;
363	>	DatFileStream.Seek(RawLinks[i].SrcOffset, soFromBeginning);
364	>	DatFileStream.Write(RawLinks[i].RawAddr, 4);
365		end;
366		end;
367	+	DatFileStream.Seek(0, soFromBeginning);
368	+	Stream_Body.CopyFrom(DatFileStream, DatFileStream.Size);
369
370	<	Stream_Body.Write(Data[0], Length(Data));
371	<	//
370	>	QueryPerformanceCounter(tempticks2);
371	>	rawsum := rawsum + (tempticks2 - tempticks1);
372		end
373		else
374	<	FilesHeader[i].DataAddr := 0;
374	>	FilesHeader[FileID].DataAddr := 0;
375		if Length(fileinfo.Name) > 0 then
376		begin
377	<	FilesHeader[i].NameAddr := Stream_Names.Size;
377	>	FilesHeader[FileID].NameAddr := Stream_Names.Size;
378		temps := fileinfo.Extension + fileinfo.Name + Chr(0);
379		Stream_Names.Write(temps[1], Length(temps));
380		end
381		else
382	<	FilesHeader[i].NameAddr := 0;
383	<	FilesHeader[i].FileSize := fileinfo.Size;
384	<	FilesHeader[i].FileType := fileinfo.FileType;
382	>	FilesHeader[FileID].NameAddr := 0;
383	>	FilesHeader[FileID].FileSize := fileinfo.Size;
384	>	FilesHeader[FileID].FileType := fileinfo.FileType;
385
386	<	if ((i mod 10) = 0) and (i >= 100) then
386	>	if ((FileID mod 10) = 0) and (FileID >= 100) then
387		lbl_estimation.Caption := 'Estimated time left: ' + TimeToStr(
388	<	(Time - FileTime) / i * (progress.Max - i + 1) * 1.1, TimeFormat );
389	<	progress.Position := i + 1;
390	<	lbl_progress.Caption := 'Files done: ' + IntToStr(i + 1) + '/' + IntToStr(progress.Max);
388	>	(Time - FileTime) / FileID * (progress.Max - FileID + 1) * 1.1, TimeFormat );
389	>	progress.Position := FileID + 1;
390	>	lbl_progress.Caption := 'Files done: ' + IntToStr(FileID + 1) + '/' + IntToStr(progress.Max);
391		Application.ProcessMessages;
392		end;
393
394	+	ShowMessage('AvgDats: ' + FloatToStr((datsum / progress.Max) / freq) + #13#10 +
395	+	'AvgLinks: ' + FloatToStr((linksum / progress.Max) / freq) + #13#10 +
396	+	'AvgRaws: ' + FloatToStr((rawsum / progress.Max) / freq)
397	+	);
398	+
399		Stream_Dat.Write(DatHeader, SizeOf(DatHeader));
400		for i := 0 to High(FilesHeader) do
401		Stream_Dat.Write(FilesHeader[i], SizeOf(FilesHeader[i]));
#	Line 369 | Line 407 | begin
407		DatHeader.DataSize  := Stream_Body.Size;
408		DatHeader.NamesSize := Stream_Names.Size;
409		DatHeader.DataAddr  := Stream_Dat.Size;
410	+
411		Stream_Body.Seek(0, soFromBeginning);
412		Stream_Dat.CopyFrom(Stream_Body, Stream_Body.Size);
413		DatHeader.NamesAddr := Stream_Dat.Size;
#	Line 382 | Line 421 | begin
421		Stream_Body.Free;
422		Stream_Names.Free;
423		Stream_Raw.Free;
424	<	if OniDataConnection.OSisMac then
424	>
425	>	if Connection.DataOS in [DOS_WINDEMO, DOS_MAC, DOS_MACBETA] then
426		Stream_Sep.Free;
427
428		progress.Position      := progress.Max;
#	Line 394 | Line 434 | begin
434		btn_abortok.Caption := '&OK';
435		btn_abortok.Default := True;
436
397	–	OniImage.Free;
398	–
437		converting := False;
438
439	<	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;
439	>	//  CloseDataConnection(DataConnections[conIndex]);
440		end;
441
442
#	Line 424 | Line 444 | end;
444
445		procedure TForm_LevelDB.CreateDatabase(Source, target: String);
446		var
447	<	DataBase:    TABSDatabase;
448	<	Query:       TABSQuery;
449	<	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;
447	>	DataBase:  TABSDatabase;
448	>	Query:     TABSQuery;
449	>	MimeCoder: TStringFormat_MIME64;
450
451	<	conIndex: Integer;
452	<	const
453	<	steps: Byte = 4;
451	>	BeginTime, FileTime: Double;
452	>	Step:       Integer;
453	>	LevelID:    Integer;
454	>	TimeFormat: TFormatSettings;
455
456	+	ConID:      Integer;
457	+	Connection: TDataAccess;
458	+	ConRepMsg:  TStatusMessages;
459
460	+	FileID:     Integer;
461
462	+	Strings:    TStrings;
463	+	i:          Integer;
464	+	temps:      String;
465	+	tempi:      Integer;
466	+	tempb:      Byte;
467	+	tempdata:   TByteData;
468	+	FileInfo:   TFileInfo;
469	+	DatLinks:   TDatLinkList;
470	+	RawLinks:   TRawDataList;
471	+	const
472	+	steps: Byte = 2;
473
474		procedure DoStep(stepname: String);
475		begin
#	Line 455 | Line 481 | const
481		group_progress.Caption := 'Creating DB (FINISHED)';
482		end;
483
484	+	procedure StopConvert;
485	+	begin
486	+	btn_abortok.Caption := '&Close';
487	+	btn_abortok.Default := True;
488	+	converting := False;
489	+	lbl_estimation.Caption := 'ABORTED';
490	+	group_progress.Caption := 'Creating DB (ABORTED)';
491	+	DataBase.Close;
492	+	if MessageBox(Self.Handle, PChar('Delete the unfinished DB-file?'),
493	+	PChar('Delete file?'), MB_YESNO) = idYes then
494	+	begin
495	+	DeleteFile(target);
496	+	end;
497	+	end;
498	+
499	+
500	+
501		begin
502	<	if CreateDataConnection(Source, ODB_Dat) = nil then
502	>
503	>	//
504	>	// FILE EXISTS CHECK FÜR DAT/RAW/SEP!!!
505	>	//
506	>
507	>	TimeFormat.ShortTimeFormat := 'hh:nn:ss';
508	>	TimeFormat.LongTimeFormat  := 'hh:nn:ss';
509	>	TimeFormat.TimeSeparator   := ':';
510	>
511	>	ConID := ConManager.OpenConnection(Source, ConRepMsg);
512	>	if not (ConRepMsg in [SM_OK, SM_AlreadyOpened]) then
513		begin
514	<	ShowMessage('Could not connect to .dat-file');
514	>	ShowMessage('Source-file couldn''t be opened! Aborting' + CrLf + GetOpenMsg(ConRepMsg));
515		Exit;
516	<	end
517	<	else
516	>	end else
517	>	Connection := ConManager.Connection[ConID];
518	>
519	>	ConID := ConManager.FileOpened(Target);
520	>	if ConID >= 0 then
521		begin
522	<	TOniDataDat(OniDataConnection).UnloadWhenUnused := False;
522	>	if MessageBox(Self.Handle, PChar('Destination-file is opened, close it in ' +
523	>	'order to proceed conversion?'), PChar('Destination-file opened'),
524	>	MB_YESNO + MB_ICONQUESTION) = ID_YES then
525	>	begin
526	>	if Form_Main.CheckConnectionCloseable(ConID) then
527	>	if not ConManager.CloseConnection(ConID, ConRepMsg) then
528	>	begin
529	>	ShowMessage('Couldn''t close destination-file. Aborting');
530	>	Exit;
531	>	end;
532	>	end else begin
533	>	ShowMessage('Aborting');
534	>	Exit;
535	>	end;
536		end;
537
538	<	timeformat.LongTimeFormat := 'hh:nn:ss';
539	<	timeformat.ShortTimeFormat := 'hh:nn:ss';
540	<	timeformat.TimeSeparator := ':';
538	>	if FileExists(Target) then
539	>	begin
540	>	if MessageBox(Self.Handle, PChar('Destination-file exists. ' +
541	>	'Overwrite it?'), PChar('Destination-file exists'),
542	>	MB_YESNO + MB_ICONWARNING) = ID_YES then
543	>	begin
544	>	if not DeleteFile(Target) then
545	>	begin
546	>	ShowMessage('Couldn''t delete file. Aborting');
547	>	Exit;
548	>	end;
549	>	end else begin
550	>	ShowMessage('Aborting');
551	>	Exit;
552	>	end;
553	>	end;
554
555		Self.Visible := True;
556		Form_Main.Visible := False;
#	Line 477 | Line 559 | begin
559		abort := False;
560		btn_abortok.Caption := '&Abort...';
561		btn_abortok.Default := False;
480	–	loaded_filename := target;
562
563	<	absolutebegintime := Time;
563	>	BeginTime := Time;
564
565		DataBase := TABSDatabase.Create(Self);
566	+	DataBase.MaxConnections := 1;
567	+	DataBase.PageSize := 8112;
568	+	DataBase.PageCountInExtent := 8;
569	+
570		DataBase.DatabaseName := 'OLDB';
571		DataBase.DatabaseFileName := target;
572		DataBase.CreateDatabase;
#	Line 495 | Line 580 | begin
580		Query := TABSQuery.Create(Self);
581		Query.DatabaseName := 'OLDB';
582		Query.SQL.Text :=
583	<	'CREATE TABLE globals  ( id AUTOINC PRIMARY KEY, name STRING(128), value STRING(128) );';
583	>	'CREATE TABLE globals  ( id AUTOINC PRIMARY KEY, name STRING(128), ' +
584	>	'value STRING(128) );';
585		Query.ExecSQL;
586		Query.SQL.Text :=
587	<	'CREATE TABLE linkmap  ( id AUTOINC PRIMARY KEY, src_id INTEGER, src_link_offset INTEGER, target_id INTEGER );';
587	>	'CREATE TABLE linkmap  ( id AUTOINC PRIMARY KEY, src_id INTEGER, ' +
588	>	'src_link_offset INTEGER, target_id INTEGER,  INDEX idsrcid src_id, ' +
589	>	'INDEX iddestid target_id);';
590		Query.ExecSQL;
591		Query.SQL.Text :=
592	<	'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 );';
592	>	'CREATE TABLE rawmap  ( id AUTOINC PRIMARY KEY, src_id INTEGER, ' +
593	>	'src_link_offset INTEGER, sep BOOLEAN, size INTEGER, ' +
594	>	'data BLOB BlobCompressionMode 9 BlobBlockSize 1024 BlobCompressionAlgorithm ZLib, ' +
595	>	'INDEX idsrcid src_id);';
596		//    Query.SQL.Text:='CREATE TABLE rawmap  ( id AUTOINC PRIMARY KEY, src_id INTEGER, src_link_offset INTEGER, size INTEGER, data BLOB BlobCompressionAlgorithm None );';
597		Query.ExecSQL;
598		Query.SQL.Text :=
599	<	'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 );';
599	>	'CREATE TABLE datfiles  ( id INTEGER PRIMARY KEY, extension CHAR(4), ' +
600	>	'name STRING(128), contenttype INTEGER, size INTEGER, ' +
601	>	'data BLOB BlobCompressionMode 9 BlobBlockSize 1024 BlobCompressionAlgorithm ZLib );';
602		//    Query.SQL.Text:='CREATE TABLE datfiles  ( id INTEGER PRIMARY KEY, extension CHAR(4), name STRING(128), contenttype INTEGER, size INTEGER, data BLOB BlobCompressionAlgorithm None );';
603		Query.ExecSQL;
604	<	Query.SQL.Text :=
605	<	'CREATE TABLE extlist  ( id AUTOINC PRIMARY KEY, ext CHAR(4), ident CHAR(16) );';
606	<	Query.ExecSQL;
604	>	//  Query.SQL.Text :=
605	>	//    'CREATE TABLE extlist  ( id AUTOINC PRIMARY KEY, ext CHAR(4), ident CHAR(16) );';
606	>	//  Query.ExecSQL;
607
608		Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("dbversion","' +
609		dbversion + '");';
610		Query.ExecSQL;
611	<	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;
611	>
612		Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("lvl","' +
613	<	IntToStr(OniDataConnection.LevelInfo.LevelNumber) + '");';
526	<	Query.ExecSQL;
527	<	if OniDataConnection.OSisMAC then
528	<	Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("os","MAC");'
529	<	else
530	<	Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("os","PC");';
613	>	IntToStr(Connection.LevelNumber) + '");';
614		Query.ExecSQL;
615	<
616	<	DoStep('Writing extensionslist');
617	<	progress.Max := Length(OniDataConnection.GetExtensionsList);
618	<	Application.ProcessMessages;
619	<
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;
615	>	case Connection.DataOS of
616	>	DOS_WIN: temps := 'WIN';
617	>	DOS_WINDEMO: temps := 'WINDEMO';
618	>	DOS_MAC: temps := 'MAC';
619	>	DOS_MACBETA: temps := 'MACBETA';
620		end;
621	<	lbl_progress.Caption := '';
621	>	Query.SQL.Text := 'INSERT INTO globals (name,value) VALUES ("os","' + temps + '");';
622	>	Query.ExecSQL;
623
624		progress.Position      := 0;
625		lbl_progress.Caption   := 'Files done: ' + IntToStr(0) + '/' + IntToStr(
626	<	OniDataConnection.GetFilesCount);
626	>	Connection.GetFileCount);
627		lbl_estimation.Caption := 'Estimated finishing time: unknown';
628
629	<	DoStep('Loading .dat into memory');
567	<	Application.ProcessMessages;
568	<
569	<	progress.Max := OniDataConnection.GetFilesCount;
629	>	progress.Max := Connection.GetFileCount;
630		begintime    := Time;
631		DoStep('Writing .dat-fileslist');
632		Application.ProcessMessages;
633
634		Database.StartTransaction;
635	<	for i := 0 to OniDataConnection.GetFilesCount - 1 do
635	>	for FileID := 0 to Connection.GetFileCount - 1 do
636		begin
637	<	fileinfo := OniDataConnection.GetFileInfo(i);
637	>	fileinfo := Connection.GetFileInfo(FileID);
638		if (fileinfo.FileType and $02) = 0 then
639		begin
640		mimecoder := TStringFormat_MIME64.Create;
641	<	Data      := OniDataConnection.LoadDatFile(i);
641	>	Connection.LoadDatFile(FileID, tempdata);
642		Query.SQL.Text :=
643		'INSERT INTO datfiles (id,extension,name,contenttype,size,data) VALUES (' +
644	<	IntToStr(i) + ',"' + fileinfo.Extension + '","' + fileinfo.Name + '","' + IntToHex(
644	>	IntToStr(FileID) + ',"' + fileinfo.Extension + '","' + fileinfo.Name + '","' + IntToHex(
645		fileinfo.FileType, 8) + '",' + IntToStr(fileinfo.Size) + ',MimeToBin("' +
646	<	MimeCoder.StrTo(@Data[0], Length(Data)) + '") );';
646	>	MimeCoder.StrTo(@tempdata[0], Length(tempdata)) + '") );';
647		Query.ExecSQL;
648		mimecoder.Free;
649
650	<	rawlist := OniDataConnection.GetRawList(i);
651	<	if Length(rawlist) > 0 then
650	>	RawLinks := Connection.GetRawList(FileID);
651	>	if Length(RawLinks) > 0 then
652		begin
653	<	for j := 0 to High(rawlist) do
653	>	for i := 0 to High(RawLinks) do
654		begin
655	<	if rawlist[j].raw_size > 0 then
655	>	if RawLinks[i].RawSize > 0 then
656		begin
657	<	SetLength(Data, rawlist[j].raw_size);
658	<	OniDataConnection.LoadRawFile(i, rawlist[j].src_offset, Data);
657	>	SetLength(tempdata, RawLinks[i].RawSize);
658	>	Connection.LoadRawFile(FileID, RawLinks[i].SrcOffset, tempdata);
659		mimecoder      := TStringFormat_MIME64.Create;
660		Query.SQL.Text :=
661		'INSERT INTO rawmap (src_id,src_link_offset,sep,size,data) VALUES (' +
662	<	IntToStr(i) + ',' + IntToStr(rawlist[j].src_offset) + ',' + BoolToStr(
663	<	rawlist[j].loc_sep) + ',' + IntToStr(rawlist[j].raw_size) + ',MimeToBin("' +
664	<	MimeCoder.StrTo(@Data[0], rawlist[j].raw_size) + '") );';
662	>	IntToStr(FileID) + ', ' + IntToStr(RawLinks[i].SrcOffset) + ',' +
663	>	BoolToStr(RawLinks[i].LocSep) + ', ' +
664	>	IntToStr(RawLinks[i].RawSize) + ', ' +
665	>	'MimeToBin("' + MimeCoder.StrTo(@tempdata[0], RawLinks[i].RawSize) + '") );';
666		Query.ExecSQL;
667		mimecoder.Free;
668		end
#	Line 609 | Line 670 | begin
670		begin
671		Query.SQL.Text :=
672		'INSERT INTO rawmap (src_id,src_link_offset,sep,size) VALUES (' +
673	<	IntToStr(i) + ',' + IntToStr(rawlist[j].src_offset) + ',' + BoolToStr(rawlist[j].loc_sep) + ',0);';
673	>	IntToStr(FileID) + ', ' + IntToStr(RawLinks[i].SrcOffset) + ', ' +
674	>	BoolToStr(RawLinks[i].LocSep) + ', 0);';
675		Query.ExecSQL;
676		end;
677		end;
678		end;
679
680	<	HandleFile(fileinfo.Extension, i, True);
680	>	DatLinks := Connection.GetDatLinks(FileID);
681	>	if Length(DatLinks) > 0 then
682	>	begin
683	>	for i := 0 to High(DatLinks) do
684	>	begin
685	>	Query.SQL.Text :=
686	>	'INSERT INTO linkmap (src_id, src_link_offset, target_id) VALUES (' +
687	>	IntToStr(FileID) + ', ' + IntToStr(DatLinks[i].SrcOffset) + ', ' +
688	>	IntToStr(DatLinks[i].DestID) + ');';
689	>	Query.ExecSQL;
690	>	end;
691	>	end;
692		end
693		else
694		begin
695		Query.SQL.Text :=
696		'INSERT INTO datfiles (id,extension,name,contenttype,size) VALUES (' +
697	<	IntToStr(i) + ',"' + fileinfo.Extension + '","' + fileinfo.Name + '","' + IntToHex(
698	<	fileinfo.FileType, 8) + '",0);';
697	>	IntToStr(FileID) + ', "' + fileinfo.Extension + '", ' +
698	>	'"' + fileinfo.Name + '", "' + IntToHex(fileinfo.FileType, 8) + '", 0);';
699		Query.ExecSQL;
700		end;
701	<	if ((i mod 100) = 0) and (i > 0) then
701	>	if ((FileID mod 100) = 0) and (FileID > 0) then
702		begin
703		Database.Commit(False);
704		Database.StartTransaction;
705		end;
706	<	if ((i mod 10) = 0) and (i >= 100) then
706	>	if ((FileID mod 10) = 0) and (FileID >= 100) then
707		lbl_estimation.Caption := 'Estimated time left: ' + TimeToStr(
708	<	(Time - begintime) / i * (progress.Max - i + 1) * 1.1, timeformat );
709	<	progress.Position := i;
710	<	lbl_progress.Caption := 'Files done: ' + IntToStr(i) + '/' + IntToStr(progress.Max);
708	>	(Time - BeginTime) / FileID * (progress.Max - FileID + 1) * 1.1, timeformat );
709	>	progress.Position := FileID;
710	>	lbl_progress.Caption := 'Files done: ' + IntToStr(FileID) + '/' + IntToStr(progress.Max);
711		Application.ProcessMessages;
712		if abort then
713		begin
714	<	stop_convert;
714	>	StopConvert;
715		Exit;
716		end;
717		end;
#	Line 647 | Line 720 | begin
720		lbl_progress.Caption   := 'Files done: ' + IntToStr(progress.Max) + '/' +
721		IntToStr(progress.Max);
722
723	<	lbl_estimation.Caption := 'FINISHED (duration: ' + TimeToStr(Time - absolutebegintime, timeformat) + ')';
723	>	lbl_estimation.Caption := 'FINISHED (duration: ' + TimeToStr(Time - BeginTime, timeformat) + ')';
724
725		DoStep('FIN');
726		btn_abortok.Caption := '&OK';
#	Line 655 | Line 728 | begin
728
729		converting := False;
730
731	<	database.Close;
732	<	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)';
731	>	Query.Close;
732	>	Query.Free;
733		DataBase.Close;
734	<	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;
734	>	DataBase.Free;
735		end;
736
737
#	Line 699 | Line 754 | begin
754		end;
755
756
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);
757		end.

Diff Legend

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