Package l2p.database

Examples of l2p.database.FiltredPreparedStatement

641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
    {
      return true;
    }
    int lease = level == 0 ? 0 : getFunction(type).getLease(level);
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      if(!function.isActive())
      {
        if(count >= lease)
        {
          clan.getWarehouse().destroyItem(57, lease);
        }
        else
        {
          return false;
        }
        long time = Calendar.getInstance().getTimeInMillis() + 86400000;
        statement = con.prepareStatement("REPLACE residence_functions SET id=?, type=?, lvl=?, endTime=?");
        statement.setInt(1, getId());
        statement.setInt(2, type);
        statement.setInt(3, level);
        statement.setInt(4, (int) (time / 1000));
        statement.execute();
        function.setLvl(level);
        function.setEndTimeInMillis(time);
        function.setActive(true);
        StartAutoTaskForFunction(function);
      }
      else
      {
        if(count >= lease - getFunction(type).getLease())
        {
          if(lease > getFunction(type).getLease())
          {
            clan.getWarehouse().destroyItem(57, lease - getFunction(type).getLease());
          }
        }
        else
        {
          return false;
        }
        statement = con.prepareStatement("REPLACE residence_functions SET id=?, type=?, lvl=?");
        statement.setInt(1, getId());
        statement.setInt(2, type);
        statement.setInt(3, level);
        statement.execute();
        function.setLvl(level);
      }
    }
    catch(Exception e)
    {
View Full Code Here
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
  }

  public void removeFunction(int type)
  {
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM residence_functions WHERE id=? AND type=?");
      statement.setInt(1, getId());
      statement.setInt(2, type);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("Exception: removeFunctions(int type): " + e);
    }
View Full Code Here
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
   */
  public synchronized static L2ItemInstance restoreFromDb(long objectId, boolean putInStorage)
  {
    L2ItemInstance inst = null;
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    ResultSet item_rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM items WHERE object_id=? LIMIT 1");
      statement.setLong(1, objectId);
      item_rset = statement.executeQuery();
      if(item_rset.next())
      {
        inst = restoreFromDb(item_rset, con, putInStorage);
      }
      else
View Full Code Here
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
    if(_storedInDb)
    {
      return;
    }
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE items SET owner_id=?,count=?,loc=?,loc_data=?,enchant_level=?,shadow_life_time=?,item_id=?,flags=? WHERE object_id = ? LIMIT 1");
      statement.setInt(1, getOwnerId());
      statement.setLong(2, _count);
      statement.setString(3, _loc.name());
      statement.setInt(4, _loc_data);
      statement.setInt(5, getEnchantLevel());
      statement.setInt(6, _lifeTimeRemaining);
      statement.setInt(7, getItemId());
      statement.setInt(8, _customFlags);
      statement.setInt(9, getObjectId());
      statement.executeUpdate();
      _existsInDb = true;
      _storedInDb = true;
    }
    catch(Exception e)
    {
View Full Code Here
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
    if(isWear())
    {
      return;
    }
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("REPLACE INTO items (owner_id,item_id,count,loc,loc_data,enchant_level,object_id,custom_type1,custom_type2,shadow_life_time,name,class,flags) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)");
      statement.setInt(1, getOwnerId());
      statement.setInt(2, _itemId);
      statement.setLong(3, _count);
      statement.setString(4, _loc.name());
      statement.setInt(5, _loc_data);
      statement.setInt(6, getEnchantLevel());
      statement.setInt(7, getObjectId());
      statement.setInt(8, _type1);
      statement.setInt(9, _type2);
      statement.setInt(10, _lifeTimeRemaining);
      statement.setString(11, getName());
      statement.setString(12, getItemClass().name());
      statement.setInt(13, _customFlags);
      statement.executeUpdate();
      _existsInDb = true;
      _storedInDb = true;
      Stat.increaseInsertItemCount();
    }
    catch(Exception e)
View Full Code Here
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
    if(AllowRemoveAttributes)
    {
      removeAttributes();
    }
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM items WHERE object_id = ? LIMIT 1");
      statement.setInt(1, _objectId);
      statement.executeUpdate();
      _existsInDb = false;
      _storedInDb = false;
      Stat.increaseDeleteItemCount();
    }
    catch(Exception e)
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
  public void updateRentTime(boolean inDebt)
  {
    setEndTimeInMillis(System.currentTimeMillis() + 86400000);
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE residence_functions SET endTime=?, inDebt=? WHERE type=? AND id=?");
      statement.setInt(1, (int) (getEndTimeInMillis() / 1000));
      statement.setInt(2, inDebt ? 1 : 0);
      statement.setInt(3, getType());
      statement.setInt(4, getResidenceId());
      statement.executeUpdate();
    }
    catch(Exception e)
    {
      _log.log(Level.SEVERE, "Exception: ResidenceFunction.updateRentTime(boolean inDebt): " + e.getMessage(), e);
    }
View Full Code Here
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
  }

  public void attach(Letter letter, L2ItemInstance... items)
  {
    ThreadConnection con = null;
    FiltredPreparedStatement stmnt = null;
    try
    {
      sendLock.lock();
      if(items != null && items.length > 0)
      {
        con = L2DatabaseFactory.getInstance().getConnection();
        stmnt = con.prepareStatement("INSERT INTO `mail_attachments` (`messageId`, `itemId`) VALUES (?,?)");
        letter.attached = new GArray<TradeItem>(items.length);
        for(int i = 0; i < items.length; i++)
        {
          L2ItemInstance item = items[i];
          item.setOwnerId(letter.senderId);
          item.setLocation(ItemLocation.LEASE);
          item.updateDatabase(true, false);
          letter.attached.add(new TradeItem(item));
          stmnt.setInt(1, letter.id);
          stmnt.setInt(2, item.getObjectId());
          stmnt.executeUpdate();
        }
        letter.attachments = letter.attached.size();
      }
    }
    catch(Exception e)
View Full Code Here
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
   * Вовзращает список прикрепленных вещей.
   */
  public GArray<L2ItemInstance> listAttachedItems(int mailId)
  {
    GArray<L2ItemInstance> ret = new GArray<L2ItemInstance>(8);
    FiltredPreparedStatement statement = null;
    ResultSet rs = null;
    ThreadConnection con = null;
    sendLock.lock();
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT itemId FROM mail_attachments WHERE messageId = ?");
      statement.setInt(1, mailId);
      rs = statement.executeQuery();
      while(rs.next())
      {
        ret.add(L2ItemInstance.restoreFromDb(rs.getInt("itemId"), false));
      }
    }
View Full Code Here
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
   * Удаляет письмо. Перед этим следует вернуть приложенные вещи.
   */
  public void deleteLetter(int... mailIds)
  {
    ThreadConnection con = null;
    FiltredPreparedStatement stmnt = null;
    sendLock.lock();
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      stmnt = con.prepareStatement("DELETE FROM mail WHERE messageId=? LIMIT 1");
      GArray<Letter> removed = new GArray<Letter>(mailIds.length);
      for(int id : mailIds)
      {
        Letter letter = lettersByIdCache.remove(id);
        if(letter == null)
        {
          continue;
        }
        GArray<Letter> cached = lettersBySenderCache.get(letter.senderId);
        if(cached != null)
        {
          cached.remove(letter);
          if(cached.isEmpty())
          {
            lettersBySenderCache.remove(letter.senderId);
          }
        }
        cached = lettersByReceiverCache.get(letter.receiverId);
        if(cached != null)
        {
          cached.remove(letter);
          if(cached.isEmpty())
          {
            lettersByReceiverCache.remove(letter.receiverId);
          }
        }
        removed.add(letter);
        stmnt.setInt(1, id);
        stmnt.executeUpdate();
      }
      DatabaseUtils.closeStatement(stmnt);
      stmnt = con.prepareStatement("DELETE FROM mail_attachments WHERE messageId=? LIMIT ?");
      for(Letter letter : removed)
      {
        stmnt.setInt(1, letter.id);
        stmnt.setInt(2, letter.attachments);
        stmnt.executeUpdate();
      }
    }
    catch(Exception e)
    {
      e.printStackTrace();
View Full Code Here
TOP

Related Classes of l2p.database.FiltredPreparedStatement

  • bosses.EpicBossState
  • bosses.FourSepulchersSpawn
  • bosses.LastImperialTombSpawnlist
  • commands.admin.AdminRepairChar
  • community.mGeneratePage
  • community.teleport.Teleport
  • events.tournament.Tournament_data
  • l2p.accountmanager.SQLAccountManager
  • l2p.extensions.Stat
  • l2p.gameserver.cache.CrestCache
    • Copyright © 2018 www.massapicom. 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.