AppGini Community Forums

Posted: **2019-04-28 12:23**

Hello board, Ian trying to stop an update from happening if the user is. It in a certain group. It doesnâ€™t seem to work, can someone help?

Code: Select all


function commission_approvals_before_update($data, $memberInfo, &$args){
if($memberinfo['groupID']!='3'){
$id=makesafe($selectedID);
$complete=sqlValue("select `ClaimCompleted` from `commission_approvals` where `refnum`='$id'");
if($complete=='Claim Complete') return FALSE;
}
return TRUE;
}

Posted: **2019-04-28 13:43**

Try var_dump($complete); exit(); to check return value of sqlValue call

Posted: **2019-04-28 13:51**

Hi,

try

Code: Select all

"select `ClaimCompleted` from `commission_approvals` where `refnum`='".$id."'"

instead of

Code: Select all

"select `ClaimCompleted` from `commission_approvals` where `refnum`='$id'"

Posted: **2019-04-30 09:28**

pbottcher, jsetzer thanks, here is the final code that worked

Code: Select all

function commission_approvals_before_update($data, $memberInfo, &$args){
                                
                                if($memberInfo['groupID']!='3'){
                                                $id=makesafe($data['selectedID']);
                                                $complete=sqlValue("select ClaimCompleted from commission_approvals where refnum='" . $id. "'");
                                                if($complete=='Claim Complete') 
                                                                 
                                                 return FALSE;
                                }
                                
                                return TRUE;
                                                
                }

AppGini Community Forums

Update only if in a specific group

Update only if in a specific group

Re: Update only if in a specific group

Re: Update only if in a specific group

Re: Update only if in a specific group