Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.execute()

83
84
85
86
87
88
89
90
91
92
93
      statement.setString(3, date);
      statement.setString(4, enddate);
      statement.setString(5, msg);
      statement.setString(6, GM);
      statement.setLong(7, endban);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("could not store bans data:" + e);
    }
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
          statement.setString(2, date);
          statement.setString(3, enddate);
          statement.setString(4, msg);
          statement.setString(5, GM);
          statement.setLong(6, endban);
          statement.execute();
        }
        else
        {
          statement = con.prepareStatement("DELETE FROM bans WHERE obj_id=?");
          statement.setInt(1, obj_id);
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
        }
        else
        {
          statement = con.prepareStatement("DELETE FROM bans WHERE obj_id=?");
          statement.setInt(1, obj_id);
          statement.execute();
        }
      }
      catch(Exception e)
      {
        e.printStackTrace();
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
      statement.setString(1, actor.getAccountName());
      statement.setInt(2, actor.getObjectId());
      statement.setString(3, date);
      statement.setString(4, msg);
      statement.setString(5, GM);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("could not store bans data:" + e);
    }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
      {
        con = L2DatabaseFactory.getInstance().getConnection();
        statement = con.prepareStatement("update characters set karma=karma + ? where obj_Id=?");
        statement.setInt(1, karma);
        statement.setInt(2, obj_id);
        statement.execute();
        DatabaseUtils.closeStatement(statement);
        String date = new SimpleDateFormat("yy.MM.dd H:mm:ss").format(new Date());
        msg = "Add karma(" + karma + ") " + msg;
        statement = con.prepareStatement("INSERT INTO bans (obj_id, baned, reason, GM) VALUES(?,?,?,?)");
        statement.setInt(1, obj_id);
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
        statement = con.prepareStatement("INSERT INTO bans (obj_id, baned, reason, GM) VALUES(?,?,?,?)");
        statement.setInt(1, obj_id);
        statement.setString(2, date);
        statement.setString(3, msg);
        statement.setString(4, GM);
        statement.execute();
      }
      catch(Exception e)
      {
        _log.warning("could not store bans data:" + e);
        res = false;
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
        statement = con.prepareStatement("INSERT DELAYED INTO " + Config.LOG_CHAT_DB + " (`type`,`text`,`from`,`to`) VALUES(?,?,?,?);");
        statement.setString(1, type.trim());
        statement.setString(2, text);
        statement.setString(3, from);
        statement.setString(4, to != null ? to : "");
        statement.execute();
      }
      catch(Exception e)
      {
        _log.warning("fail to sql log chat[" + type + "|" + text + "|" + from + "|" + to + "]: " + e);
        e.printStackTrace();
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("REPLACE INTO epic_boss_spawn (bossId,respawnDate,state) VALUES(?,?,?)");
      statement.setInt(1, _bossId);
      statement.setInt(2, (int) (_respawnDate / 1000));
      statement.setInt(3, _state.ordinal());
      statement.execute();
      statement.close();
    }
    catch(Exception e)
    {
      _log.error(e.getMessage(), e);
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
      removeItem(player, 13015, 1);
      player.logout(false, false, false, true);
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE characters SET bookmarks = bookmarks+3 WHERE obj_Id=?");
      statement.setInt(1, player.getObjectId());
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      //player.updateStats();
      //player.sendChanges();
      player.broadcastUserInfo(true);
      player.sendPacket(new SystemMessage(msg));
View Full Code Here
452
453
454
455
456
457
458
459
460
461
462
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM pets WHERE item_obj_id=?");
      statement.setInt(1, getControlItemObjId());
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("could not delete pet:" + e);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.