Registering logins to the nuBuilder database

[Janusz]

Hi, recently there was few topics how to get the client computer IPs and how to register logins.
As an example you can have a look on my implementation for the registration of the client IP's both for the successful and unsuccessful logins.
https://nubuilderforte.blogspot.com/

[miasoft]

Thx, Janusz! Very useful information. Still would get the StorageProcedure's source code , so as not to reinvent the wheel.

[icoso]

Hi, recently there was few topics how to get the client computer IPs and how to register logins.
As an example you can have a look on my implementation for the registration of the client IP's both for the successful and unsuccessful logins.
https://nubuilderforte.blogspot.com/

Where can we get the programming code for this IP Address Logger?

[Janusz]

Hi,
I have just added the code to the Blog.
https://nubuilderforte.blogspot.com/

[apmuthu]

Your code in the blog is attached here.

record_logins_Code.txt

Consider the hypothetical situation where a record exists for zx_IPs_id=ip but with
ips_OK_qty+ips_Bad_qty = 0
OR
(ips_OK_qty = 0 AND ips_Bad_qty = 0)
the INSERT parts would fail.

Quick Fix:
INSERT IGNORE....

Better Fix:
UPDATE statement on DUPLICATE Primary Key


The English Auto-generated (and corrected) transcript (remove the .txt extension) of the video is attached.

nuBuilder - record logins to DB.srt

[Janusz]

apmuthu wrote:
Consider the hypothetical situation where a record exists for zx_IPs_id=ip but with
ips_OK_qty+ips_Bad_qty = 0
OR
(ips_OK_qty = 0 AND ips_Bad_qty = 0)
the INSERT parts would fail.

Such situation is not possible.
Always initial insert is setting the ips_OK/Bad_qty value to 1:

Code: Select all

...
INSERT INTO zx_IPs (zx_IPs_id,ips_OK_qty) VALUES (ip,1);
....
INSERT INTO zx_IPs (zx_IPs_id,ips_Bad_qty,ips_last_bad,ips_Bad_username) VALUES (ip,1,NOW(),user);