Page 1 of 1

add users via appgini

Posted: 2022-03-25 19:34
by arcanebits
Hi, I need to add users, but, it cannot be done via the Admin panel, I need to add them into the membership_users via the appgini app.
Thanks in advance.

Re: add users via appgini

Posted: 2022-03-25 21:13
by pbottcher
Hi,

maybe you could create a table in AppGini with the same parameters as in membership_users. Create the app, go to the DB, remove the table and create a view for this tablename as a select * from membership_users.

Like this you could enter the data into the membership_user via the normal functionality.

WARNING: There might be more to consider as to if you want set a password to the user, or assign a group to the user.

Re: add users via appgini

Posted: 2022-03-30 07:26
by xbox2007
Hello
i already do that on my project
1- make table name ( Users ) or any name you want .
filed : ID , User_Name, User_Group, Name, Password, Password01, User_Mail, Date

2- user this code on Users.php in hooks folder

Code: Select all

function Users_after_insert($data, $memberInfo, &$args) {
		
		$Emp_ID	   = $data["selectedID"];
		$memberID  = $data['User_Name'];
		$password    = $data['Password'];
		$email	   = $data['User_Mail'];
		$Name	   = $data['Name'];
		$groupID      = $data['User_Group'];
			
		$member    = sqlValue("select COUNT(*) from membership_users where memberID='{$memberID}'");  
			
		if($member == 0) {
				sql("INSERT INTO `membership_users` set memberID='{$memberID}', passMD5='" . password_hash($password, PASSWORD_DEFAULT) . "', email='{$email}', signupDate='" . @date('Y-m-d') . "', groupID = '{$groupID}', isBanned= 0, isApproved= 1 , custom1='{$Emp_name}' ", $eo);
				
				
		return false;
	}

Re: add users via appgini

Posted: 2022-04-04 19:33
by arcanebits
You guys are LIFE SAVERS!!!!!!
Gonna try!
THANKS!!!

Re: add users via appgini

Posted: 2022-04-30 12:50
by tchandra
Hi, how do you delete membership_users using hooks/users.php ?
xbox2007 wrote:
2022-03-30 07:26
Hello
i already do that on my project
1- make table name ( Users ) or any name you want .
filed : ID , User_Name, User_Group, Name, Password, Password01, User_Mail, Date

2- user this code on Users.php in hooks folder

Code: Select all

function Users_after_insert($data, $memberInfo, &$args) {
		
		$Emp_ID	   = $data["selectedID"];
		$memberID  = $data['User_Name'];
		$password    = $data['Password'];
		$email	   = $data['User_Mail'];
		$Name	   = $data['Name'];
		$groupID      = $data['User_Group'];
			
		$member    = sqlValue("select COUNT(*) from membership_users where memberID='{$memberID}'");  
			
		if($member == 0) {
				sql("INSERT INTO `membership_users` set memberID='{$memberID}', passMD5='" . password_hash($password, PASSWORD_DEFAULT) . "', email='{$email}', signupDate='" . @date('Y-m-d') . "', groupID = '{$groupID}', isBanned= 0, isApproved= 1 , custom1='{$Emp_name}' ", $eo);
				
				
		return false;
	}

Re: add users via appgini

Posted: 2022-05-04 16:42
by xbox2007
hello
if you already make table name (users) and already add users with this table ,, in this case you will find all users you add on this table
so we can use query to delete user in function Users_after_delete($data, $memberInfo, &$args)

Code: Select all

	function Users_after_delete($selectedID, $memberInfo, &$args) {
			$memberID  = $data['User_Name'];
			sql("DELETE FROM membership_users WHERE memberID='{$memberID}'", $eo);
	}
other way you can use Admin Area

Re: add users via appgini

Posted: 2022-05-04 19:16
by pbottcher
Hi,

just a small comment. You cannot reference the $data array in the delete hooks.