import ru.jimbot.modules.AbstractServer;
import ru.jimbot.util.*;
import ru.jimbot.modules.chat.*;
import ru.jimbot.modules.*;
import ru.jimbot.Manager;
import java.sql.*;

//Установка скрипта как обработчика команды
if(in.equals("install")){
cmd.addCommand("!закрытые", new Cmd("!закрытые","",39,name));
cmd.addCommand("!закрытые", new Cmd("!вбане","",39,name));
cmd.addCommand("!banroomed", new Cmd("!banroomed","",39,name));
cmd.addAuth("banroomed","Список запертых");
out="Ok";
return;
}

if(!cmd.isChat(proc,uin) && !cmd.psp.testAdmin(uin)) return;
if(!cmd.auth(proc,uin, "banroomed")) return;
try{
Vector v = cmd.getParser().parseArgs(msg);
String host = ChatProps.getInstance(cmd.srv.getName()).getStringProperty("db.host");
String namedb = ChatProps.getInstance(cmd.srv.getName()).getStringProperty("db.dbname");
String user = ChatProps.getInstance(cmd.srv.getName()).getStringProperty("db.user");
String pass = ChatProps.getInstance(cmd.srv.getName()).getStringProperty("db.pass");
DBChat db;
db = new DBChat(cmd.srv.getName());
db.openConnection(host, namedb, user, pass);
String s = "|id|-|nick|-|room|\n";
try {
PreparedStatement pst = db.getDb().prepareStatement("SELECT `user_id` FROM `user_props` WHERE `name`='revoke' AND `val`='room'");
ResultSet rs = pst.executeQuery();
while(rs.next()){
Users us = cmd.srv.us.getUser(rs.getInt(1));
s += us.id +" - " + us.localnick+" ["+ us.room +"]" + "\n";
}
rs.close();
pst.close();
} catch (Exception ex) {
ex.printStackTrace();
}
proc.mq.add(uin,s);
} catch (Exception ex) {
ex.printStackTrace();
proc.mq.add(uin,"Ошибка "+ex.getMessage());
}