- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
private boolean tpNameExist(PlayerInstance player, String bmName)
{
Connection con = null;
PreparedStatement statement = null;
ResultSet rset = null;
boolean isExist = false;
try
{
con = DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("SELECT name FROM bbs_teleport_bm WHERE char_id=?");
statement.setInt(1, player.getObjectId());
rset = statement.executeQuery();
while (rset.next())
{
String name = rset.getString("name");
if (name.equals(bmName))
{
isExist = true;
}
}
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
DbUtils.closeQuietly(con, statement, rset);
}
return isExist;
}
L2Scripts профессионально проверяют использовано ли имя в базе данных ? :D
TeaBag 26.04.2017 21:48 # −5
CrashTesterAnusov 26.04.2017 23:24 # −5
TeaBag 27.04.2017 12:12 # −5
CrashTesterAnusov 27.04.2017 20:26 # −6