hooks/recipes.php/after update function:
Code: Select all
sql("UPDATE membership_userrecords SET `groupID` = '325' WHERE `tableName` = 'meals' AND pkValue = (SELECT ID FROM meals WHERE meals.recipes_id = '{$data['id']}' )'", $eo);
Code: Select all
sql("UPDATE membership_userrecords SET `groupID` = '325' WHERE `tableName` = 'meals' AND pkValue = (SELECT ID FROM meals WHERE meals.recipes_id = '{$data['id']}' )'", $eo);
Code: Select all
$id = makesafe($_REQUEST['id']);
$gp = '325';
sql("UPDATE `membership_userrecords` SET `groupID` = '{$gp}' WHERE `tableName` = 'recipes' AND `pkValue` = '{$id}'", $eo);
$sql = "SELECT pkValue FROM membership_userrecords WHERE tableName = 'meals' AND groupID != '{$gp}' AND EXISTS (SELECT ID FROM meals WHERE recipes_id = '{$id}')";
$d1 = sqlValue($sql);
if($d1==""){
}else{
sql("UPDATE `membership_userrecords` SET `groupID` = '{$gp}' WHERE `tableName` = 'meals' AND `pkValue` = '{$datos}'", $eo);
};