Hello Dear, I would like to ask a question and help here in the forum. It happens that I am using the "client_get" function where I pass the client id and in the data return I realize that all clients within the db have the same sys_userid and sys_groupid. In the query of client sites using the function "client_get_sites_by_user" is passed exactly the sys_userid and sys_group id but if all have the same value in the client table of mysql how can I search the sites of a certain client, and in case of error in some configuration how could I fix it, because I believe that the data that should be in the client table in the above-mentioned field should be the id that appears in the sys_user table. If I am wrong, will they correct me otherwise I need to make some correction?
There is no error, just a misunderstanding what these fields are on your side. The sys_userid and sys_groupid define the owner of a record. The owner of the clients is the administrator, so they must have all the same user and groupid. Whereas the owner of a website is a client, then the website has the sys_groupid of the client group, see sys_group table.
