uses System.SysUtils, System.Classes, Web.HTTPApp, Web.DSProd, Web.HTTPProd,
Web.DBWeb, System.Variants, System.NetEncoding, System.RegularExpressions,
- Data.DB, Web.DBXpressWeb, System.Types;
+ Data.DB, Web.DBXpressWeb, System.Types, FireDAC.Stan.Intf,
+ FireDAC.Stan.Option, FireDAC.Stan.Param, FireDAC.Stan.Error, FireDAC.DatS,
+ FireDAC.Phys.Intf, FireDAC.DApt.Intf, FireDAC.Stan.Async, FireDAC.DApt,
+ FireDAC.Comp.DataSet, FireDAC.Comp.Client;
type
TWebModule1 = class(TWebModule)
ss: TStringList;
tagstr: string;
procedure pages(count: Integer; var page: Integer);
+ procedure strsCheck(var Error: string; var list: TStringList);
+ procedure setLastArticle;
+ function isInfo: Boolean;
+ function loginCheck: Boolean;
function hash(str: string): string;
function mente: Boolean;
function detail(ts, pid: string): string;
{ %CLASSGROUP 'Vcl.Controls.TControl' }
-uses Unit1, IdHashSHA, IdGlobal, IdHash, IdHashMessageDigest;
+uses Unit1, IdHashSHA, IdGlobal, IdHash, IdHashMessageDigest, Jpeg, Graphics;
{$R *.dfm}
else if (TagString = 'mente') and
(DataModule1.FDTable3.FieldByName('mente').AsBoolean = true) then
ReplaceText := 'checked'
- else if TagString = 'password' then
- ReplaceText := Request.CookieFields.Values['user']
else if TagString = 'database' then
ReplaceText := Request.QueryFields.Values['db'];
end;
s: TStringList;
i: Integer;
begin
- if TagString = 'plus' then
- if alert.Tag = 0 then
- ReplaceText:='<a href=/jump?db=<#dbname>&num=<#posnum>>[ <#dbname>-<#posnum> ]</a>'
- else
- alert.Tag :=0
+ if (TagString = 'plus') and (alert.Tag = 0) then
+ ReplaceText :=
+ '<a href=/jump?db=<#dbname>&num=<#posnum>>[ <#dbname>-<#posnum> ]</a>'
else if TagString = 'article' then
begin
with DataModule1 do
- if (FDTable1.Locate('dbnum', FDTable4.FieldByName('dbname').AsInteger) = false)or
- (FDTable2.Locate('number', FDTable4.FieldByName('posnum').AsInteger) = false) then
+ if (FDTable1.Locate('dbnum', FDTable4.FieldByName('dbname').AsInteger)
+ = false) or (FDTable2.Locate('number', FDTable4.FieldByName('posnum')
+ .AsInteger) = false) then
begin
- ReplaceText:='<p>\83\8a\83N\83G\83X\83g';
- alert.Tag:=1;
+ ReplaceText := '<p>\83\8a\83N\83G\83X\83g';
Exit;
end;
s := TStringList.Create;
const TagString: string; TagParams: TStrings; var ReplaceText: string);
begin
if TagString = 'pr' then
- ReplaceText := promotion;
+ ReplaceText := promotion
+ else if TagString = 'area' then
+ if help.Tag = 0 then
+ begin
+ ss := TStringList.Create;
+ try
+ ss.Add('<form action=/help method=post><p>\82¨\96â\82¢\8d\87\82í\82¹<\8dí\8f\9c\88Ë\97\8a\82È\82Ç\89½\82Å\82à></p>');
+ ss.Add('<textarea name=help style=height:100px;width:250px>\93\8a\8de\8eÒ\96¼\82È\82Ç\81F');
+ ss.Add('\91\8a\92k\93à\97e\81F');
+ ss.Add('\82»\82Ì\91¼\81F</textarea><br>');
+ ss.Add('<input type=submit value="\91\97\90M"></form>');
+ ReplaceText := ss.Text;
+ finally
+ ss.Free;
+ end;
+ end
+ else
+ ReplaceText :=
+ '<p style=color:yellow;background-color:aqua>\82²\95ñ\8d\90\82 \82è\82ª\82Æ\82¤\82²\82´\82¢\82Ü\82·.';
end;
procedure TWebModule1.indexHTMLTag(Sender: TObject; Tag: TTag;
const TagString: string; TagParams: TStrings; var ReplaceText: string);
var
i: Integer;
- x: Boolean;
begin
if TagString = 'pr' then
ReplaceText := promotion
else if TagString = 'article' then
begin
- x := DataModule1.FDTable1.FieldByName('dbnum')
- .AsInteger = DataModule1.FDTable3.FieldByName('info').AsInteger;
for i := 1 to DataModule1.FDTable3.FieldByName('count').AsInteger do
begin
if DataModule1.FDTable2.Eof = true then
break;
- if x = false then
+ if isInfo = false then
ReplaceText := ReplaceText + articles.Content
else
ReplaceText := articles.Content + ReplaceText;
- if DataModule1.FDTable2.Eof = false then
- DataModule1.FDTable2.Next;
+ DataModule1.FDTable2.Next;
end;
end
else if TagString = 'footer' then
ReplaceText := footer.Content
else if TagString = 'header' then
- begin
- i := DataModule1.FDTable3.FieldByName('count').AsInteger;
- if 10 * i <= DataModule1.FDTable2.RecordCount then
- ReplaceText := '<h1>\82±\82ê\88È\8fã\93\8a\8de\82Å\82«\82Ü\82¹\82ñ.</h1>'
+ if (DataModule1.FDTable1.FieldByName('dbnum')
+ .AsInteger = DataModule1.FDTable3.FieldByName('info').AsInteger) and
+ (loginCheck = false) then
+ ReplaceText := '<h1 style=text-align:center>\8aÇ\97\9d\90l\82©\82ç\82¨\92m\82ç\82¹\82ª\82 \82è\82Ü\82·.</h1>'
else
- ReplaceText := header.Content;
- end
+ begin
+ i := DataModule1.FDTable3.FieldByName('count').AsInteger;
+ if 10 * i <= DataModule1.FDTable2.RecordCount then
+ ReplaceText := '<h1>\82±\82ê\88È\8fã\93\8a\8de\82Å\82«\82Ü\82¹\82ñ.</h1>'
+ else
+ ReplaceText := header.Content;
+ end
else if (TagString = 'css') or (TagString = 'js') then
ReplaceText := detail(TagString, TagParams.Values['id'])
else if TagString = 'dbnum' then
ReplaceText := DataModule1.FDTable1.FieldByName('database').AsString;
end;
+function TWebModule1.isInfo: Boolean;
+begin
+ result := DataModule1.FDTable1.FieldByName('dbnum')
+ .AsInteger = DataModule1.FDTable3.FieldByName('info').AsInteger;
+end;
+
procedure TWebModule1.itemsHTMLTag(Sender: TObject; Tag: TTag;
const TagString: string; TagParams: TStrings; var ReplaceText: string);
var
str := Request.QueryFields.Values['db'];
if str = '' then
t := Format('<a href="/jump?db=%d&num=%d">[ %d-%d ]</a>',
- [DataModule1.FDTable1.FieldByName('dbnum').AsInteger, j, i, j])
+ [i, j, i, j])
else
t := Format('<a href="/jump?db=%s&num=%d">[ %d ]</a>', [str, j, j]);
end;
end;
end;
+function TWebModule1.loginCheck: Boolean;
+begin
+ result := hash(Request.CookieFields.Values['user'])
+ = DataModule1.FDTable3.FieldByName('password').AsString;
+end;
+
procedure TWebModule1.loginHTMLTag(Sender: TObject; Tag: TTag;
const TagString: string; TagParams: TStrings; var ReplaceText: string);
begin
ReplaceText := '<table border=1 align=center>';
while Eof = false do
begin
+ if FieldByName('posnum').AsInteger = -1 then
+ alert.Tag := 1
+ else
+ alert.Tag := 0;
ReplaceText := ReplaceText + alert.ContentFromString(alert.Content);
Next;
end;
ReplaceText := ReplaceText + '</table>';
- end
- else if TagString = 'db' then
- ReplaceText := DataModule1.FDTable1.FieldByName('database').AsString;
+ end;
end;
function TWebModule1.mente: Boolean;
ReplaceText := '?' + ReplaceText;
end
else if TagString = 'css' then
- ReplaceText := css2.Content;
+ ReplaceText := css2.Content
+ else if TagString = 'dbnum' then
+ ReplaceText := Request.QueryFields.Values['dbnum'];
+end;
+
+procedure TWebModule1.setLastArticle;
+begin
+ DataModule1.FDTable2.Last;
+end;
+
+procedure TWebModule1.strsCheck(var Error: string; var list: TStringList);
+var
+ s: TStringList;
+ i, j: Integer;
+ x: Boolean;
+begin
+ x := false;
+ s := TStringList.Create;
+ try
+ s.DelimitedText := DataModule1.FDTable3.FieldByName('ng').AsString;
+ for i := 0 to s.count - 1 do
+ for j := 0 to list.count - 1 do
+ begin
+ if Pos(s[i], list[j]) > 0 then
+ x := true;
+ list[j] := '<p>' + list[j];
+ end;
+ finally
+ s.Free;
+ end;
+ if x = true then
+ Error := Error + '<p>\8bÖ\8e~\8cê\8bå\82ª\8aÜ\82Ü\82ê\82Ä\82¢\82Ü\82·.';
end;
procedure TWebModule1.tiHTMLTag(Sender: TObject; Tag: TTag;
const TagString: string; TagParams: TStrings; var ReplaceText: string);
begin
if TagString = 'count' then
- begin
- DataModule1.FDTable1.Locate('dbnum',
- DataModule1.FDQuery1.FieldByName('dbnum').AsInteger);
- ReplaceText := DataModule1.FDTable2.RecordCount.ToString;
- end
+ ReplaceText := DataModule1.FDTable2.RecordCount.ToString
else if TagString = 'database' then
- ReplaceText := DataModule1.FDTable1.Lookup('dbnum',
- DataModule1.FDQuery1.FieldByName('dbnum').AsInteger, 'database');
+ ReplaceText := DataModule1.FDTable1.FieldByName('database').AsString
+ else if TagString = 'date' then
+ with DataModule1.FDTable2 do
+ begin
+ Last;
+ ReplaceText := FieldByName('date').AsString;
+ end;
end;
procedure TWebModule1.titleHTMLTag(Sender: TObject; Tag: TTag;
else if TagString = 'js' then
ReplaceText := detail(TagString, TagParams.Values['id'])
else if TagString = 'main' then
- with DataModule1.FDQuery1 do
+ with DataModule1 do
begin
- Open;
- while Eof = false do
+ FDQuery1.Open;
+ FDTable1.First;
+ while (FDQuery1.Eof = false) and (FDTable1.Eof = false) do
begin
- ReplaceText := ReplaceText + ti.Content;
- Next;
+ if FDTable1.FieldByName('dbnum').AsInteger = FDQuery1.FieldByName
+ ('dbnum').AsInteger then
+ begin
+ ReplaceText := ReplaceText + ti.Content;
+ FDQuery1.Next;
+ end
+ else if FDTable2.Eof = false then
+ begin
+ ti.DataSet := nil;
+ try
+ ReplaceText := ReplaceText + ti.Content;
+ finally
+ ti.DataSet := FDQuery1;
+ end;
+ end;
+ FDTable1.Next;
end;
- Close;
+ FDQuery1.Close;
end;
end;
continue;
end;
DataModule1.FDTable2.Last;
- if Now - DataModule1.FDTable2.FieldByName('date').AsDateTime < 1 then
+ if (Now - DataModule1.FDTable2.FieldByName('date').AsDateTime < 1) and
+ (DataModule1.FDTable2.RecordCount > 0) then
t := 'background-color:aqua;';
if DataModule1.FDTable2.RecordCount >= 10 *
DataModule1.FDTable3.FieldByName('count').AsInteger then
i: Integer;
begin
s := Request.CookieFields.Values['user'];
- if (s = '') or (hash(s) <> DataModule1.FDTable3.FieldByName('password')
- .AsString) then
+ if (s = '') or (loginCheck = false) then
begin
WebModule1loginAction(nil, Request, Response, Handled);
Exit;
procedure TWebModule1.WebModule1alertAction(Sender: TObject;
Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
var
- num1, num2, i, dbnum: Integer;
+ num1, num2, i: Integer;
+ s: string;
begin
- dbnum := DataModule1.FDTable1.FieldByName('dbnum').AsInteger;
num1 := DataModule1.FDTable1.FieldByName('dbnum').AsInteger;
- num2 := Request.QueryFields.Values['num'].ToInteger;
+ num2 := StrToIntDef(Request.QueryFields.Values['num'], -1);
+ if num2 = -1 then
+ num1 := -1;
if Request.MethodType = mtGet then
begin
DataModule1.FDTable2.Locate('number', num2, []);
Response.Content := mail.Content;
end
else
+ begin
with DataModule1.FDTable4 do
begin
Last;
i := FieldByName('id').AsInteger + 1;
- AppendRecord([i, num1, num2, Now, Request.ContentFields.Values
- ['request']]);
- Response.SendRedirect(Format('/index?db=%d&num=%d#%d', [dbnum, i, num2]));
+ s := Request.ContentFields.Values['request'];
+ if s = '' then
+ s := '(No Comment)';
+ AppendRecord([i, num1, num2, Now, s]);
end;
+ if num1 > -1 then
+ Response.SendRedirect(Format('/index?db=%d&num=%d#%d',
+ [num1, num2, num2]))
+ else
+ Response.SendRedirect('/top');
+ end;
end;
procedure TWebModule1.WebModule1deleteAction(Sender: TObject;
procedure TWebModule1.WebModule1helpAction(Sender: TObject;
Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
var
- i, j, k: Integer;
+ k: Integer;
s: string;
begin
Response.ContentType := 'text/html;charset=utf-8';
if Request.MethodType = mtPost then
begin
- i := DataModule1.FDTable1.FieldByName('dbnum').AsInteger;;
- j := DataModule1.FDTable2.FieldByName('number').AsInteger;
s := Request.ContentFields.Values['help'];
DataModule1.FDTable4.Last;
- k := DataModule1.FDTable4.FieldByName('ID').AsInteger + 1;
- DataModule1.FDTable4.AppendRecord([k, i, j, Now, s]);
- end;
+ k := DataModule1.FDTable4.FieldByName('id').AsInteger + 1;
+ DataModule1.FDTable4.AppendRecord([k, -1, -1, Now, s]);
+ help.Tag := 1;
+ end
+ else
+ help.Tag := 0;
Response.Content := help.Content;
end;
Response: TWebResponse; var Handled: Boolean);
var
s: string;
- res: TResourceStream;
+ res: TStream;
begin
with DataModule1.FDTable5 do
begin
s := Request.ContentFields.Values['name'];
Response.ContentType := 'image/jpeg';
if Locate('name', s) = true then
- Response.ContentStream := CreateBlobStream(FieldByName('source'), bmRead)
+ begin
+ res := CreateBlobStream(FieldByName('source'), bmRead);
+ Response.ContentStream := res;
+ end
else if s = 'sprites.png' then
begin
Response.ContentType := 'image/png';
procedure TWebModule1.WebModule1indexpageAction(Sender: TObject;
Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
var
- int: Integer;
+ i: Integer;
s: string;
begin
s := Request.QueryFields.Values['db'];
if s <> '' then
DataModule1.FDTable1.Locate('dbnum', s, []);
- int := StrToIntDef(Request.QueryFields.Values['num'], -1);
- pages(DataModule1.FDTable2.RecordCount, int);
- index.Tag := int;
+ i := StrToIntDef(Request.QueryFields.Values['num'], -1);
+ isInfo;
+ pages(DataModule1.FDTable2.RecordCount, i);
+ index.Tag := i;
tagstr := '/index';
Self.Tag := Integer(@tagstr);
Response.ContentType := 'text/html; charset="utf-8"';
s: string;
i: Integer;
begin
- if hash(Request.CookieFields.Values['user']) <>
- DataModule1.FDTable3.FieldByName('password').AsString then
+ if loginCheck = false then
begin
with DataModule1.FDTable1 do
if Locate('database', 'master') = false then
- AppendRecord([RecordCount, 'master']);
+ begin
+ Last;
+ i := FieldByName('dbnum').AsInteger + 1;
+ AppendRecord([i, 'master']);
+ end;
WebModule1loginAction(nil, Request, Response, Handled);
Exit;
end;
begin
i := DataModule1.FDTable4.FieldByName('posnum').AsInteger;
if DataModule1.FDTable2.Locate('number', i) = false then
- begin
- DataModule1.FDTable4.Delete;
- continue;
- end;
- end;
- DataModule1.FDTable4.Next;
+ DataModule1.FDTable4.Delete
+ else
+ DataModule1.FDTable4.Next;
+ end
+ else
+ DataModule1.FDTable4.Delete;
end;
end;
end;
Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
var
number, i: Integer;
- title, na, raw, pass, kotoba, error: string;
+ title, na, raw, pass, kotoba, Error: string;
comment: TStringList;
- x: Boolean;
function scan(Text: string): string;
var
reg: TRegEx;
end;
begin
- error := '';
kotoba := Request.ContentFields.Values['aikotoba'];
+ Error := '';
if kotoba <> '\82°\82ñ\82«' then
- error := '<section style=color:red><p>\8d\87\8c¾\97t\82ª\82¿\82ª\82¢\82Ü\82·.';
- with DataModule1.FDTable2 do
- begin
- Last;
- number := FieldByName('number').AsInteger + 1;
- end;
+ Error := Error + '<p>\8d\87\8c¾\97t\82ª\82¿\82ª\82¢\82Ü\82·.';
+ setLastArticle;
+ number := DataModule1.FDTable2.FieldByName('number').AsInteger + 1;
with Request.ContentFields do
begin
title := Values['title'];
Value := na;
Expires := Now + 14;
end;
- if error = '' then
+ if Error = '' then
with Response.Cookies.Add do
begin
Name := 'aikotoba';
comment := TStringList.Create;
try
comment.Text := raw;
- for i := 0 to comment.count - 1 do
- begin
- if Pos('ng', comment[i]) > 0 then
- begin
- error := error + '<p>\8bÖ\8e~\8cê\8bå\82ª\8aÜ\82Ü\82ê\82Ä\82¢\82Ü\82·.';
- break;
- end;
- comment[i] := '<p>' + scan(comment[i]);
- end;
- x := Request.ContentFields.Values['show'] = 'true';
- if error <> '' then
- error := error + '</section>'
- else if x = true then
+ strsCheck(Error, comment);
+ Request.ContentFields.Values['raw'] := raw;
+ if Error <> '' then
+ Request.ContentFields.Values['preview'] := '<section style=color:red>' +
+ Error + '</section>'
+ else if Request.ContentFields.Values['show'] = 'true' then
begin
- error := '<p style=font-size:2.3em;color:blue>\81«\81«\83v\83\8c\83r\83\85\81[\81«\81«<p>' +
+ Error := '<p style=font-size:2.3em;color:blue>\81«\81«\83v\83\8c\83r\83\85\81[\81«\81«<p>' +
comment.Text;
+ Request.ContentFields.Values['preview'] := Error;
Request.ContentFields.Values['show'] := 'false';
- Request.ContentFields.Values['preview'] := error;
- Request.ContentFields.Values['raw'] := raw;
end
else
begin
procedure TWebModule1.WebModuleCreate(Sender: TObject);
var
i: Integer;
- a: Variant;
+ s: string;
begin
with DataModule1 do
begin
FDTable3.CreateTable;
if FDTable4.Exists = false then
FDTable4.CreateTable;
- if FDTable5.Exists = false then
- FDTable5.CreateTable;
FDTable1.Open;
FDTable2.Open;
FDTable3.Open;
FDTable4.Open;
- FDTable5.Open;
- FDTable1.Refresh;
- FDTable3.Refresh;
- FDTable5.Refresh;
end;
if DataModule1.FDTable1.Bof and DataModule1.FDTable1.Eof then
begin
end;
if DataModule1.FDTable3.Bof and DataModule1.FDTable3.Eof then
begin
- a := DataModule1.FDTable1.Lookup('database', 'info', 'dbnum');
+ i := DataModule1.FDTable1.Lookup('database', 'info', 'dbnum');
+ s := '\88¢\95Û,\94n\8e,\8e\80\82Ë';
DataModule1.FDTable3.AppendRecord
(['\82Æ\82é\82Ë\81`\82Ç\8d\86',
'<h1 style=color:maron;text-align:center;font-style:italic>\82Æ\82é\82Ë\81`\82Ç\8d\86</h1>',
- false, a, 30, hash(hash('admin'))]);
+ false, i, 30, hash(hash('admin')), s]);
end;
end;