Page 1 of 1
Automatic Value "Owner"
Posted: 2015-05-13 22:12
by SkayyHH
Hello,
please make a auomativ value "owner" (owner of this record)
Thanks much, Kai
Re: Automatic Value "Owner"
Posted: 2015-05-15 06:41
by Satya Kavala
Hi,
You mean that creating ownership to a record right?
Re: Automatic Value "Owner"
Posted: 2015-05-15 06:50
by Satya Kavala
Hi kai,
it may help you....
place the below code in after insert function of the related file in hooks folder
$qry="SELECT `groupID` FROM `membership_users` WHERE `memberID`='".$data['ClientID']."'";
$groupid=sqlValue($qry);
$qry2="INSERT INTO `membership_userrecords`(`tableName`, `pkValue`, `memberID`,`groupID`,`dateAdded`, `dateUpdated`) VALUES ('tablename','".$data['ID']."','".$data['ClientID']."','".$groupid."',UNIX_TIMESTAMP(now()),UNIX_TIMESTAMP(now()))";
sqlValue($qry2);
//here $data['ClientID'] is logged in member id
Re: Automatic Value "Owner"
Posted: 2015-05-16 20:30
by SkayyHH
Thanks much,
i´ll try it. But it would be better to have this from within the appgini app. I do not like the hooks. It´s confusing after you have some mods.
Thanks much, Kai
Re: Automatic Value "Owner"
Posted: 2019-10-01 11:22
by Ionut Bocanet
Satya Kavala wrote: ↑2015-05-15 06:50
Hi kai,
it may help you....
place the below code in after insert function of the related file in hooks folder
$qry="SELECT `groupID` FROM `membership_users` WHERE `memberID`='".$data['ClientID']."'";
$groupid=sqlValue($qry);
$qry2="INSERT INTO `membership_userrecords`(`tableName`, `pkValue`, `memberID`,`groupID`,`dateAdded`, `dateUpdated`) VALUES ('tablename','".$data['ID']."','".$data['ClientID']."','".$groupid."',UNIX_TIMESTAMP(now()),UNIX_TIMESTAMP(now()))";
sqlValue($qry2);
//here $data['ClientID'] is logged in member id
I want to update the ownership of a record by a value from a drop down field.
I tried this code and replaced the ClientID with my own dropdown field but in the ownership table i have blank in owner field.