[hyperserver the best way to clear a session on database when the web server restarts or the server restarts]

can't do this ,

coz i should not clear all session with  user still connected to the system

[how to disable right click on unidbgrid/unistringgrid only]

with UniMainModule.BrowserOptions:=[boDisableMouseRightClick ]  it disable all right click  on browser

but how to disable right click spesific to dbgrid/stringgrid only

[hyperserver the best way to clear a session on database when the web server restarts or the server restarts]

8 minutes ago, wilton_rad said:

because you do not clear database sessions when your unigui server starts, 
so if you drop your server, starting will clear all pending connections.

Which event on unigui , for trigering server start /unigui start

[hyperserver the best way to clear a session on database when the web server restarts or the server restarts]

hello 

i have unigui app with limiting the concurent login /access, when user session reached max limit my app will reject the login

when use traditional unigui , it can handle when web server/server restart, then session list is become empty

now i use hyper server unigui  ver 1506, and store the user session on database, user on close browser tab/close the browser delete the session store in database, but sometime (i dont know why there still session list left /undeleted)

my question is

1.why there sometime still session on the database left, i use delete session on database with this event

• TUniMainModule.UniGUIMainModuleBrowserClose
• TUniMainModule.UniGUIMainModuleDestroy
• On Logout menu(user click the logout)
• my delete function
  •  q.SQL.Text := 'DELETE FROM PENGGUNA_SESSION WHERE ID_SESSION=' +
              QuotedStr(ID_SESSION) + '';

2. what best method to clear database session when web server restart/server restart

3.what best method can i use to clear left session every 5 minutes with session log time - current_time >5 hours, try use unithreadtimer on server module but no luck , it's never triger my function to   clear database session

[Hyperserver get all session list]

hi mhmda,
 can you explain to me, what you do if the web server restarts or the server restarts,
 do you create 1 small application to empty the session list in the database on the server statrtup or web server startup ?

 

 

 

[Hyperserver get all session list]

is there a plan to add this feature to hyperserver ?

[How do you update a dll on Apache server]

Hyperserver , can handle it

[FastReport 6_3 !]

any body know how to implement drill down report like fast report vcl do ?

on unigui

[unidbgrid with checkbox state on click]

hello sherzod

on test case app it work , but on my real project your solution is not work, id ont know what missing,

is there any other solution , to know if i click on the checkbox and return the state of checkbox is checked or unchecked ?

 

[unidbgrid with checkbox state on click]

Hello

any solution for this

[unidbgrid with checkbox state on click]

ok, i will wait for your solution

 

thanks

[unidbgrid with checkbox state on click]

hello sherzod,

any solutution for this ?

[Hyperserver get all session list]

1 minute ago, multimesut said:

hi, you can fix it with mysql.

 

MainModule;
procedure TUniMainModule.UniGUIMainModuleCreate(Sender: TObject);
begin
MyQuery2.SQL.Clear;
MyQuery2.SQL.Add('INSERT INTO sessions (sessionid,logindate) VALUES (:sessionid,:logindate)');
MyQuery2.Params.ParamByName('sessionid').Value:=UniSession.SessionId;
MyQuery2.Params.ParamByName('logindate').Value:=Now;
MyQuery2.ExecSQL;
end;

procedure TUniMainModule.UniGUIMainModuleDestroy(Sender: TObject);
begin
MyQuery2.SQL.Clear;
MyQuery2.SQL.Add('DELETE FROM sessions where sessionid=:sessionid');
MyQuery2.Params.ParamByName('sessionid').Value:=UniSession.SessionId;
MyQuery2.ExecSQL;
end;

SQL;
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions`  (
  `sessionid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `logindate` datetime(0) NULL DEFAULT NULL,
  `killsession` tinyint(1) NULL DEFAULT 0
) ENGINE = MEMORY CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

 

i was try with the method like that, but

1.refresh the browser, the session id is changed, so  the ondestroy function not found the before refresh sessionid

2. if the server reboot or failure then on server startup i must create other desktop service to clear all session on database

[unidbgrid with checkbox state on click]

hello sherzod

i create test case for you

please check then unchek the checkbox column

what i want is if the checkbox is checked=true then uniedit value= uniedit value+unidbgrid row value on valnya value

else

uniedit value= uniedit value-unidbgrid row value on valnya value

 

for now i get always 2 , just check the first row checked column

 

unigui_check_box.rar

[unidbgrid with checkbox state on click]

hello

any body know how to know what state on unidbgrid with checkbox column if click on checkbox column,

i want to get the state of checkbox ,

the condition/state of checkbox on click the checkbox box column

unigui ver 1486

 

 

[All Button become border update from 1479 to 1486]

On first pict tunibutton border show border when focus (1486)

On 1479 the border not show when the button is focus

How to remove the border on pict 1 with css

[All Button become border update from 1479 to 1486]

i was update from 1476 to 1486 , all my button become border(focus) , i want to make all button borderless

and the form happen to it become border

how to remove them with css

[Tunidbformattednumberedit error '-' is not a valid floating point value]

8 hours ago, Tokay said:

As I said, you can try to replace StrToFloat to StrToFloatDef:

Self.Value := StrToFloatDef(AValue, 0, FmtSettings) 

FValue := StrToFloatDef(S, 0, FmtSettings);

thank you this works, only for a temporary solution

[Tunidbformattednumberedit error '-' is not a valid floating point value]

 

my current unigui version now is 1479 ,

 

i try to istall and unistall the 1479 ver but still happen on my old project

it happen if the form have onkeydown event and form keypreview=true, need the form onkeydown

here i attach the test case ,

put minus value on the third  edit

ex -90000

 

test_case.rar

[Tunidbformattednumberedit error '-' is not a valid floating point value]

On 8/22/2018 at 4:24 AM, Tokay said:

Yes, I've made fixes in uniEdit.pas

hello tokay can you tell me which part on the uniedit.pas source i must replace to make minus/- work

 

[1 application with several url, several folder on isapi apache]

same app but diffrent folder and url

[1 application with several url, several folder on isapi apache]

 

i have 1 app with several url, several folder on isapi apache  (not  hyperserver)

ex

same exe/dll on diffrent folder

on dir

c:\app\abc\x.dll

c:\app\def\x.dll

so i have 2 url

mypublicip:1234/abc

mypublicip:1234/def

is it safe with share 1 app like this ?

 

 

[Hyperserver get all session list]

Hyperserver get all session list

Need this feature,like traditional unigui

[Screen examples of you're application designs]

25 minutes ago, zemorango said:

Good Job donlego

Thanks zemorango, 

Try your code for my login page,but unfotunately the background wont maximize/full screen for the background image

[Screen examples of you're application designs]