FlagSQL.java

/*  
 *  ReActions, Minecraft bukkit plugin
 *  (c)2012-2017, fromgate, fromgate@gmail.com
 *  http://dev.bukkit.org/server-mods/reactions/
 *    
 *  This file is part of ReActions.
 *  
 *  ReActions is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *
 *  ReActions is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with ReActions.  If not, see <http://www.gnorg/licenses/>.
 * 
 */

package me.fromgate.reactions.flags;

import me.fromgate.reactions.sql.SQLManager;
import me.fromgate.reactions.util.Param;
import org.bukkit.entity.Player;

public class FlagSQL extends Flag {
    boolean check;

    public FlagSQL(boolean check) {
        this.check = check;
    }

    @Override
    public boolean checkFlag(Player p, String param) {
        if (!SQLManager.isEnabled()) return false;
        Param params = new Param(param);
        if (!params.isParamsExists("value", "select", "from") &&
                !(params.isParamsExists("query"))) return false;
        String value = params.getParam("value", "");
        String select = params.getParam("select", "");
        String query = params.getParam("query", "");
        if (query.isEmpty()) {
            if (select.isEmpty()) return false;
            String from = params.getParam("from", "");
            if (from.isEmpty()) return false;
            String where = params.getParam("where", "");
            query = "SELECT " + select + " FROM " + from + (where.isEmpty() ? "" : " WHERE " + where);
        }
        int column = params.getParam("column", 1);
        if (check) return SQLManager.compareSelect(value, query, column, params);
        else return SQLManager.isSelectResultEmpty(query);
    }

}