Yes, here it is:
============================================================
Authentication Query:
declare @user varchar(50)
declare @rfid varchar(100)
declare @geslo varchar(100)
set @user = ?
set @geslo = ?
set @rfid = CASE WHEN @geslo <> '' THEN @geslo ELSE 'unknown' END
SELECT OPR_IME FROM
(SELECT *
FROM XMESQOPR
UNION ALL
SELECT '9999' AS MQOPR_ID,
'0' AS MQOPR_STA,
getdate() AS MQOPR_MSD,
'99999' AS OPR_SIF,
'User12' AS OPR_IME,
'5' AS OPR_AKT,
'user12' AS OPR_GES,
'99' AS OPR_LVL,
'user12' AS OPR_RFID1,
'user12' AS OPR_RFID2,
'user12' AS OPR_RFID3) AS p
WHERE OPR_SIF = @user AND @rfid IN (OPR_GES,OPR_RFID1,OPR_RFID2,OPR_RFID3) AND OPR_AKT = '5'
============================================================
List Roles Query:
SELECT DISTINCT
CASE
WHEN OPR_LVL = 0 THEN 'Operater'
WHEN OPR_LVL = 1 THEN 'Tehnolog'
WHEN OPR_LVL = 2 THEN 'Administrator'
WHEN OPR_LVL = 99 THEN 'User'
ELSE 'unknown'
END AS "role"
FROM
(SELECT * FROM XMESQOPR
UNION ALL
SELECT '9999' AS MQOPR_ID,
'0' AS MQOPR_STA,
getdate() AS MQOPR_MSD,
'99999' AS OPR_SIF,
'User12' AS OPR_IME,
'5' AS OPR_AKT,
'user12' AS OPR_GES,
'99' AS OPR_LVL,
'user12' AS OPR_RFID1,
'user12' AS OPR_RFID2,
'user12' AS OPR_RFID3) as p
WHERE OPR_AKT = '5'
============================================================
Users Roles Query:
declare @name varchar(50)
set @name = ?
SELECT DISTINCT
CASE
WHEN OPR_LVL = 0 THEN 'Operater'
WHEN OPR_LVL = 1 THEN 'Tehnolog'
WHEN OPR_LVL = 2 THEN 'Administrator'
WHEN OPR_LVL = 99 THEN 'User'
ELSE 'unknown'
END AS "role"
FROM
(SELECT * FROM XMESQOPR
UNION ALL
SELECT '9999' AS MQOPR_ID,
'0' AS MQOPR_STA,
getdate() AS MQOPR_MSD,
'99999' AS OPR_SIF,
'User12' AS OPR_IME,
'5' AS OPR_AKT,
'user12' AS OPR_GES,
'99' AS OPR_LVL,
'user12' AS OPR_RFID1,
'user12' AS OPR_RFID2,
'user12' AS OPR_RFID3) as p
WHERE OPR_AKT='5' AND OPR_SIF = @name
========================================================
List Users Query:
SELECT OPR_IME FROM
(SELECT *
FROM XMESQOPR
UNION ALL
SELECT '9999' AS MQOPR_ID,
'0' AS MQOPR_STA,
getdate() AS MQOPR_MSD,
'99999' AS OPR_SIF,
'User12' AS OPR_IME,
'5' AS OPR_AKT,
'user12' AS OPR_GES,
'99' AS OPR_LVL,
'user12' AS OPR_RFID1,
'user12' AS OPR_RFID2,
'user12' AS OPR_RFID3) AS p
WHERE OPR_AKT = '5'
The query works. I can log in on the client…
And this is my users table:
This happening only on this ‘page’… everywhere else (Gateway settings, Connections, Devices,…) I can save the config…
EDIT: I just tried to VNC directly to the Ignition gateway PC and tried there with Microsoft Edge browser to save the user source and it works no problem…???