ViewVC Help

View File | Revision Log | View Changeset | Root Listing

root/Oni2/oup/current/DataAccess/Access_OUP_ADB.pas

Comparing oup/current/DataAccess/Access_OUP_ADB.pas (file contents):
Revision 113 by alloc, Sun Feb 25 17:20:22 2007 UTC vs.
Revision 155 by alloc, Sun Apr 1 21:14:29 2007 UTC

#	Line 18 | Line 18 | type
18		procedure UpdateListCache;
19
20		function GetLinksToFile(FileID: Integer): TLinks;
21	–	function GetLinksFromFile(FileID: Integer): TLinks;
21
22		function GetFileInfo(FileID: Integer): TFileInfo; override;
23		function GetFilesList(Ext: String; Pattern: String;
#	Line 32 | Line 31 | type
31		procedure UpdateDatFilePart(FileID, Offset, Size: Integer; Src: TStream); overload; override;
32
33		function GetDatLinks(FileID: Integer): TDatLinkList; override;
34	+	function GetDatLink(FileID, DatOffset: Integer): TDatLink; override;
35		function GetRawList(FileID: Integer): TRawDataList; override;
36		function GetRawInfo(FileID, DatOffset: Integer): TRawDataInfo; override;
37
#	Line 46 | Line 46 | type
46		implementation
47
48		uses
49	<	SysUtils, Data, Functions, ABSDecUtil, DB;
49	>	SysUtils, Data, Functions, ABSDecUtil, DB, DatLinks;
50
51
52		(*
#	Line 66 | Line 66 | begin
66		FFileName := DBFilename;
67
68		FDatabase := TABSDatabase.Create(nil);
69	+	FDatabase.Exclusive := True;
70	+	FDatabase.MultiUser := False;
71		FDatabase.DatabaseName := 'OLDBcon' + IntToStr(ConnectionID);
72		FDatabase.DatabaseFileName := DBFilename;
73		FDatabase.Open;
74		FQuery := TABSQuery.Create(FDatabase);
75	+	FQuery.DisableControls;
76	+	FQuery.RequestLive := False;
77		FQuery.DatabaseName := 'OLDBcon' + IntToStr(ConnectionID);
78		FQuery.SQL.Text := 'SELECT [name],[value] FROM globals ORDER BY [name] ASC';
79		FQuery.Open;
#	Line 192 | Line 196 | begin
196		FQuery.Close;
197		end;
198
195	–	function TAccess_OUP_ADB.GetLinksFromFile(FileID: Integer): TLinks;
196	–	var
197	–	i: Integer;
198	–	begin
199	–	SetLength(Result.ByName, 0);
200	–	FQuery.SQL.Text := 'SELECT src_link_offset, target_id FROM linkmap WHERE src_id = ' + IntToStr(FileID) + ' ORDER BY target_id ASC;';
201	–	FQuery.Open;
202	–	SetLength(Result.ByID, FQuery.RecordCount);
203	–	if FQuery.RecordCount > 0 then
204	–	begin
205	–	i := 0;
206	–	repeat
207	–	Result.ByID[i].SrcOffset := FQuery.FieldByName('src_link_offset').AsInteger;
208	–	Result.ByID[i].Destination := FQuery.FieldByName('target_id').AsInteger;
209	–	Inc(i);
210	–	FQuery.Next;
211	–	until FQuery.EOF;
212	–	end;
213	–	FQuery.Close;
214	–	end;
215	–
199
200
201		function TAccess_OUP_ADB.GetFileInfo(fileid: Integer): TFileInfo;
#	Line 270 | Line 253 | var
253
254		begin
255		list := TStringList.Create;
256	+	list.CaseSensitive := True;
257		list.Sorted := True;
258		for i := 0 to GetFileCount - 1 do
259		begin
#	Line 287 | Line 271 | begin
271		ST_IDAsc, ST_IDDesc:     list.Add(id + ';' + name + ';' + extension);
272		ST_NameAsc, ST_NameDesc: list.Add(name + ';' + id + ';' + extension);
273		ST_ExtAsc, ST_ExtDesc:   list.Add(extension + ';' + id + ';' + name);
274	<	ST_ExtNameAsc, ST_ExtNameDesc: list.Add(name + ';' + extension + ';' + id);
274	>	ST_ExtNameAsc, ST_ExtNameDesc: list.Add(extension + ';' + name + ';' + id);
275		end;
276		end;
277		end;
#	Line 443 | Line 427 | begin
427		end;
428		end;
429
430	+
431	+
432	+	function TAccess_OUP_ADB.GetDatLink(FileID, DatOffset: Integer): TDatLink;
433	+	begin
434	+	Result := DatLinksManager.GetDatLink(FConnectionID, FileID, DatOffset);
435	+	FQuery.SQL.Text := 'SELECT target_id FROM linkmap WHERE src_id = ' + IntToStr(FileID) + ' and src_link_offset = ' + IntToStr(DatOffset) + ';';
436	+	FQuery.Open;
437	+	if FQuery.RecordCount > 0 then
438	+	Result.DestID := FQuery.FieldByName('target_id').AsInteger;
439	+	FQuery.Close;
440	+	end;
441	+
442	+
443	+	function TAccess_OUP_ADB.GetDatLinks(FileID: Integer): TDatLinkList;
444	+	var
445	+	i: Integer;
446	+	SrcOffset, DestID: Integer;
447	+	begin
448	+	Result := DatLinksManager.GetDatLinks(FConnectionID, FileID);
449	+	if Length(Result) > 0 then
450	+	begin
451	+	FQuery.SQL.Text := 'SELECT src_link_offset, target_id FROM linkmap WHERE src_id = ' + IntToStr(FileID) + ' ORDER BY src_link_offset ASC;';
452	+	FQuery.Open;
453	+	if FQuery.RecordCount > 0 then
454	+	begin
455	+	repeat
456	+	SrcOffset := FQuery.FieldByName('src_link_offset').AsInteger;
457	+	DestID := FQuery.FieldByName('target_id').AsInteger;
458	+	for i := 0 to High(Result) do
459	+	if Result[i].SrcOffset = SrcOffset then
460	+	Break;
461	+	if i < Length(Result) then
462	+	Result[i].DestID := DestID
463	+	else
464	+	Result[i].DestID := -1;
465	+	FQuery.Next;
466	+	until FQuery.EOF;
467	+	end;
468	+	FQuery.Close;
469	+	end;
470	+	end;
471	+
472
473		function TAccess_OUP_ADB.GetRawList(FileID: Integer): TRawDataList;
474		var

Diff Legend

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