Pommo_Rules::changeType PHP Méthode

changeType() public méthode

public changeType ( $gid, $fid, $logic, $type )
    function changeType($gid, $fid, $logic, $type)
    {
        global $pommo;
        $dbo =& Pommo::$_dbo;
        $type = $type == 'or' ? 1 : 0;
        $query = "\n            UPDATE " . $dbo->table['group_rules'] . "\n            SET type={$type}\n            WHERE group_id=%i AND logic='%s' AND field_id=%i";
        $query = $dbo->prepare($query, array($gid, $logic, $fid));
        return $dbo->affected($query);
    }

Usage Example

Exemple #1
0
     }
     $json->add('callbackFunction', 'redirect');
     $json->add('callbackParams', Pommo::$_baseUrl . 'groups_edit.php');
     $json->serve();
     break;
 case 'updateRule':
     require_once Pommo::$_baseDir . 'classes/Pommo_Sql.php';
     $group =& current(Pommo_Groups::get(array('id' => $state['group'])));
     $rules = Pommo_Sql::sortRules($group['rules']);
     switch ($_REQUEST['request']) {
         case 'update':
             if ($_REQUEST['type'] == 'or' && count($rules['and']) < 2) {
                 $json->add('callbackFunction', 'resume');
                 $json->success(Pommo::_T('At least 1 "and" rule must exist before an "or" rule takes effect.'));
             }
             Pommo_Rules::changeType($group['id'], $_REQUEST['fieldID'], $_REQUEST['logic'], $_REQUEST['type']);
             break;
         case 'delete':
             Pommo_Rules::deleteRule($group['id'], $_REQUEST['fieldID'], $_REQUEST['logic']);
             break;
     }
     $json->add('callbackFunction', 'redirect');
     $json->add('callbackParams', Pommo::$_baseUrl . 'groups_edit.php');
     $json->serve();
     break;
 case 'renameGroup':
     if (!empty($_REQUEST['group_name'])) {
         if (Pommo_Groups::nameChange($state['group'], $_REQUEST['group_name'])) {
             $json->success(Pommo::_T('Group Renamed'));
         }
     }