Remoting sys user

Remoting framework is adding clients OK in isp_isp_kunde but it does not seem to be adding a sys_user. The code shows that it is the sys_user table that is queried when logging in. How can I have remoting add an entry in the sys_user table, is it a matter of adding an SQL command in a particular file or is their something I have missed?

I believe that
/home/admispconfig/ispconfig/lib/classes/ispconfig_kunde.lib.php
function kunde_add($session,$params) {
is what is called when adding a new client and their is no reference to sys_user there
the only other place sys_user is referenced relative to my issue is in the
/home/admispconfig/ispconfig/lib/classes/ispconfig_isp_kunde.lib.php file
function kunde_insert($doc_id, $doctype_id, $die_on_error = '1') {

Thanks in advance.

 

I fixed the issue so when a new client is added they can immediately login by adding this to file ispconfig_kunde.lib.php after aprox line 290


//add a relative sys_user
$userid = $go_info["user"]["userid"];

$sql = "INSERT INTO sys_user (
userid,
username,
passwort,
gueltig,
perms,
modules,
modul
) VALUES (
'$userid',
'".addslashes($params["webadmin_user"])."',
'$passfmt1',
'1',
'rw',
'isp_kunde,isp_file,tools,help',
'isp_kunde'
)";

$go_api->db->query($sql);
$userid = $go_api->db->insertID();

$sql = "INSERT INTO sys_nodes (
userid,
groupid,
parent,
type,
doctype_id,
status,
doc_id,
title
) VALUES (
'1',
'0',
'',
'a',
'1',
'1',
'$userid',
''
)";

$go_api->db->query($sql);


I also added the following to same file when a new client is added

$passfmt1 = md5($params["webadmin_passwort"]);
$passfmt2 = "||||:".$passfmt1;


I also noticed that the sys_user is not deleted at all.... hope it helps

 

It then becomes impossible to assign a website to the client because the client is not sufficiently registered something to do with webadmin_userid variable (in isp_isp_kunde mysql table) being installed with a default value of 0, I am in the dark about where this number should come from or how I can generate it validly, any ideas Thanks in advance

It seems when this number is unique the problem gets solved and sites can be allocated to the client, I will do some further tests...Now that leaves ISPConfig to cleanup the following mysql tables

isp_isp_kunde
isp_nodes
sys_user
sys_nodes
and what exists already such as websites associated when a client gets deleted

Thanks my issues are almost solved and I will post the remoting php script that adds users and sites while you sleep soon.

 

AFAIK

Remoting code in file: /home/admispconfig/ispconfig/lib/classes/ispconfig_kunde.lib.php

in current stable Version: 2.2.15 is missing

1) sys_user creation procedure in sys_user table
2) webadmin_userid generation procedure in isp_isp_kunde table where is webadmin_userid in the isp_isp_kunde table is the doc_id of the sys_user table for that same client

The code fix resides in /home/admispconfig/ispconfig/lib/classes/ispconfig_isp_kunde.lib.php from line 86 to 106 copy and paste that after the kunde is created but looking for an official fix because their are some issues with syncing webadmin_userid <-> doc_id

1) Is the code missing in previous versions?
2) What is the fix?

 

Done fixed I will post my version of the lib file but someone who knows what is happening needs to look over it.

I also have a paypal integrated script that adds 1 client, 1 user, 1 website via webpage. If ISPConfig want to make it available as a commercial addon let me know otherwise I will post it here...