Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.executeUpdate()

290
291
292
293
294
295
296
297
298
299
300
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // quests
                                subStatement = con.prepareStatement("DELETE FROM character_quests WHERE char_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // macroses
                                subStatement = con.prepareStatement("DELETE FROM character_macroses WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
View Full Code Here
295
296
297
298
299
300
301
302
303
304
305
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // macroses
                                subStatement = con.prepareStatement("DELETE FROM character_macroses WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // friends
                                subStatement = con.prepareStatement("DELETE FROM character_friends WHERE char_id=? or friend_id = ?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.setString(2, rset.getString("obj_Id"));
View Full Code Here
301
302
303
304
305
306
307
308
309
310
311
                                DatabaseUtils.closeStatement(subStatement);
                                // friends
                                subStatement = con.prepareStatement("DELETE FROM character_friends WHERE char_id=? or friend_id = ?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.setString(2, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // boxaccess
                                subStatement = con.prepareStatement("DELETE FROM boxaccess WHERE charname=?;");
                                subStatement.setString(1, rset.getString("char_name"));
                                subStatement.executeUpdate();
View Full Code Here
306
307
308
309
310
311
312
313
314
315
316
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // boxaccess
                                subStatement = con.prepareStatement("DELETE FROM boxaccess WHERE charname=?;");
                                subStatement.setString(1, rset.getString("char_name"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // characters
                                subStatement = con.prepareStatement("DELETE FROM characters WHERE obj_Id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
View Full Code Here
311
312
313
314
315
316
317
318
319
320
321
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // characters
                                subStatement = con.prepareStatement("DELETE FROM characters WHERE obj_Id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                        }
                        DatabaseUtils.closeDatabaseSR(statement, rset);
                        // Delete Account
                        statement = con.prepareStatement("DELETE FROM accounts WHERE login=?;");
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      st = con.prepareStatement("DELETE FROM character_quests WHERE name=? AND (var='spawned' OR var='kills' OR var='Archon' OR var LIKE 'Mob_%')");
      st.setString(1, getName());
      st.executeUpdate();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
      statement = con.prepareStatement("REPLACE INTO character_quests (char_id,name,var,value) VALUES (?,?,?,?)");
      statement.setInt(1, qs.getPlayer().getObjectId());
      statement.setString(2, qs.getQuest().getName());
      statement.setString(3, var);
      statement.setString(4, value);
      statement.executeUpdate();
    }
    catch(Exception e)
    {
      _log.log(Level.WARNING, "could not insert char quest:", e);
    }
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM character_quests WHERE char_id=? AND name=?");
      statement.setInt(1, qs.getPlayer().getObjectId());
      statement.setString(2, qs.getQuest().getName());
      statement.executeUpdate();
    }
    catch(Exception e)
    {
      _log.log(Level.WARNING, "could not delete char quest:", e);
    }
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM character_quests WHERE char_id=? AND name=? AND var=?");
      statement.setInt(1, qs.getPlayer().getObjectId());
      statement.setString(2, qs.getQuest().getName());
      statement.setString(3, var);
      statement.executeUpdate();
    }
    catch(Exception e)
    {
      _log.log(Level.WARNING, "could not delete char quest:", e);
    }
View Full Code Here
247
248
249
250
251
252
253
254
255
256
257
        String state = rset.getString("value");
        if(state.equalsIgnoreCase("Start")) // невзятый квест
        {
          invalidQuestData.setInt(1, player.getObjectId());
          invalidQuestData.setString(2, questId);
          invalidQuestData.executeUpdate();
          continue;
        }
        // Search quest associated with the ID
        Quest q = QuestManager.getQuest(questId);
        if(q == null)
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.