uses('tpl,tform,tform_actions'); $app->load('tform_actions'); class page_action extends tform_actions { /* This function is called automatically right after the data was successful inserted in the database. */ function onAfterInsert() { global $app; // Create the group for the client $sql = "INSERT INTO sys_group (name,description,client_id) VALUES ('".addslashes($this->dataRecord["username"])."','',".$this->id.")"; $app->db->query($sql); $groupid = $app->db->insertID(); $username = addslashes($this->dataRecord["username"]); $password = addslashes($this->dataRecord["password"]); $modules = 'mail,sites'; $startmodule = 'mail'; $usertheme = addslashes($this->dataRecord["usertheme"]); $type = 'user'; $active = 1; $language = addslashes($this->dataRecord["language"]); // Create the controlpaneluser for the client $sql = "INSERT INTO sys_user (username,passwort,modules,startmodule,app_theme,typ,active,language,groups,default_group,client_id) VALUES ('$username',md5('$password'),'$modules','$startmodule','$usertheme','$type','$active','$language',$groupid,$groupid,".$this->id.")"; $app->db->query($sql); } /* This function is called automatically right after the data was successful updated in the database. */ function onAfterUpdate() { global $app; // username changed if(isset($app->tform->diffrec['username'])) { $username = addslashes($this->dataRecord["username"]); $client_id = $this->id; $sql = "UPDATE sys_user SET username = '$username' WHERE client_id = $client_id"; $app->db->query($sql); $sql = "UPDATE sys_group SET name = '$username' WHERE client_id = $client_id"; $app->db->query($sql); } // password changed if($this->dataRecord["password"] != '') { $password = addslashes($this->dataRecord["password"]); $client_id = $this->id; $sql = "UPDATE sys_user SET passwort = md5('$password') WHERE client_id = $client_id"; $app->db->query($sql); } } } $page = new page_action; $page->onLoad(); ?>