[Add User] -- insert a control

[Ryuuku]

Hi all ...
I come to search some info

In the database / table domain ... I insert a new column named `domain_egw`
OK for this
Add / Update / Delete user or hosting plans works well with this new column

At the moment where a reseller add a new client (user) ... i would like to insert a control which reads if the value of `domain_egw` is set on Yes or No ... and call a script that i've done

My knowledge in prog are .... "small" ... that's why i come here to obtain advise
about the maner to insert this control

Thx for your help

Ryu !

[Ryuuku]

1)
i tested to insert a control in page rau3.php ( function add_user_data )
After the 'insert into domain ' ... it seems bad plac eto insert it ...
=> Some error php with unexpected variable ..

2)
I tested to a control in page ispcp-dmn-mngr ( sub dmn_mngr_engine )
At the moment of the update of toad statuts .. . i insert this


if ($dmn_status eq 'toadd') {
$rs = dmn_add_data($entry);
$timestamp = time();

if ($rs == 0) {
$sql = "update domain set domain_status='ok' where domain_id = $dmn_id";
my $egw_ctrl = "select domain_egw from domain where domain_name = $dmn_name;";
if ( $egw_ctrl = 'yes' ) {
mkdir ("egw_ctrl1",0777) ;
} else {
mkdir ("egw_ctrl2",0777) ;
}

} else {
my ($sub_name, $msg) = split(/$main::el_sep/, pop_el(\@main::el));
$msg =~ s/\'/\\\'/g;
$sql = "update domain set domain_status='$sub_name | $msg' where domain_id = $dmn_id;";
}


=> no error when the user is inserted ... but the status of the new user stay to 'Toadd' no change on "ok"

Somebody see an error ?

Ryu !

[joximu]

You need to execute the SQL commands (at least your egw_ctrl - sql commands)
see some line below:
($rs, $rdata) = doSQL($sql);

but I don't know why your version does not reset the status to "ok"...

I'd do it maybe like this:

Code:

... line 3883... (version from may 29)
    if ($dmn_status eq 'toadd') {

        $rs = dmn_add_data($entry);

        $timestamp = time();

        if ($rs == 0 && set_dmn_egw($dmn_id)) {

            $sql = "update domain set domain_status='ok' where domain_id = $dmn_id";

        } else {

            my ($sub_name, $msg) = split(/$main::el_sep/, pop_el(\@main::el));

            $msg =~ s/\'/\\\'/g;

            $sql = "update domain set domain_status='$sub_name | $msg' where domain_id = $dmn_id;";

        }

        ($rs, $rdata) = doSQL($sql);

        return $rs if ($rs != 0);
...

and then create your own function (set_dmn_egw) which do the egw-thing...
Your function should be executed if ($rs == 0) and if your function does ends with a "true" then the status should be set to 'ok' - else you can setup a msg...

Hope you can manage this...

/Joximu

[Ryuuku]

First ; ) Thx for your answer ..

I'm going to try to understand all you said ... and follow your advise

I'm going to test

Thx again Joximu : )

[Ryuuku]

So results of my test
Following your advises , i create this function >>>

Code:

## Domain Egroupware Manager

sub set_egw_dmn {

my ($rs, $rdata) = ('', '');
my ($dmn_data) = @_;
my $dmn_name = @$dmn_data[1];

my $sql = "select domain_egw from domain where domain_name = $dmn_name";

($rs, $rdata) = doSQL($sql);

if ($sql eq 'yes') {
        mkdir ('egw_ctrl1',0777) ;
} elsif ($sql eq 'no') {
        mkdir ('egw_ctrl2',0777) ;
}

} # Fin Fonction set_egw_dmn

mkdir are just commands to see if function is well executed
..
When i add a new user :
-> The insert is well done in database ...
-> Dir ( egw_ctrl1 or egw_ctrl2 ) isn't created
-> Status still stay on 'toadd' :X ...
-> Delete this new user is well done

So i have to fix this [/code]

[joximu]

Well - now debugging is your friend.

Is the domain created normally (the folders - except the egw...)?

It seems that the perl script isn't running or is not coming to the part where you changed things...

I think you can run the perl file manually...
ispcp-dmn-mngr domain_id

/J

[Ryuuku]

Enjoy the debug

... Yeah .. the domain ( new user ) is well created ...
=> Data ok in database
=> Files & Dirs .. /var/www/fcgi/new_user OK ---- /var/www/virtual/new_user OK
=> Section in site-available/ispcp.conf is also OK

all is ok except things i had ... ^ ^

Command ispcp-dmn-mngr new_user_id don't give errors : )

Go GO to debug Ryu ^

See you soon

Thx /J ; )

[Zothos]

if this sollution works as expected, maybe you can add it into the wiki?

[Ryuuku]

Of course ..

[joximu]

Hi Ryuuku

just realized: you added a field to table "domain" didn't you?

Have a look at http://www.isp-control.net/ispcp/ticket/387 and the linkt to another thread here in the forum....
It's not yet possible to add fields to some of the tables because of... see ticket...

Maybe this is the thing which also blocks your system...

/J