Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.execute()

346
347
348
349
350
351
352
353
354
355
356
      if(clan != null)
      {
        statement = con.prepareStatement("UPDATE clan_data SET hasCastle=? WHERE clan_id=? LIMIT 1");
        statement.setInt(1, getId());
        statement.setInt(2, getOwnerId());
        statement.execute();
        clan.broadcastClanStatus(false, true, true);
        clan.broadcastToOnlineMembers(new PlaySound("Siege_Victory"));
      }
    }
    catch(Exception e)
View Full Code Here
462
463
464
465
466
467
468
469
470
471
472
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("Update castle set treasury = ? where id = ?");
      statement.setLong(1, getTreasury());
      statement.setInt(2, getId());
      statement.execute();
      statement.close();
      DatabaseUtils.closeDatabaseCS(con, statement);
    }
    catch(Exception e)
    {
View Full Code Here
503
504
505
506
507
508
509
510
511
512
513
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE castle SET taxPercent = ? WHERE id = ? LIMIT 1");
      statement.setInt(1, taxPercent);
      statement.setInt(2, getId());
      statement.execute();
    }
    catch(Exception e)
    {
    }
    finally
View Full Code Here
643
644
645
646
647
648
649
650
651
652
653
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement(CASTLE_MANOR_DELETE_PRODUCTION);
      statement.setInt(1, getId());
      statement.execute();
      statement.close();
      if(_production != null)
      {
        int count = 0;
        String query = "INSERT INTO castle_manor_production VALUES ";
View Full Code Here
663
664
665
666
667
668
669
670
671
672
673
          for(int i = 1; i < values.length; i++)
          {
            query += "," + values[i];
          }
          statement = con.prepareStatement(query);
          statement.execute();
          statement.close();
        }
      }
      if(_productionNext != null)
      {
View Full Code Here
685
686
687
688
689
690
691
692
693
694
695
          for(int i = 1; i < values.length; i++)
          {
            query += "," + values[i];
          }
          statement = con.prepareStatement(query);
          statement.execute();
          statement.close();
        }
      }
      DatabaseUtils.closeDatabaseCS(con, statement);
    }
View Full Code Here
712
713
714
715
716
717
718
719
720
721
722
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement(CASTLE_MANOR_DELETE_PRODUCTION_PERIOD);
      statement.setInt(1, getId());
      statement.setInt(2, period);
      statement.execute();
      statement.close();
      GArray<SeedProduction> prod = null;
      prod = getSeedProduction(period);
      if(prod != null)
      {
View Full Code Here
734
735
736
737
738
739
740
741
742
743
744
          for(int i = 1; i < values.length; i++)
          {
            query += "," + values[i];
          }
          statement = con.prepareStatement(query);
          statement.execute();
          statement.close();
        }
      }
      DatabaseUtils.closeDatabaseCS(con, statement);
    }
View Full Code Here
234
235
236
237
238
239
240
241
242
243
244
        {
          statement.setInt(1, heroId);
          statement.setInt(2, hero.getInteger(COUNT));
          statement.setInt(3, hero.getInteger(PLAYED));
          statement.setInt(4, hero.getInteger(ACTIVE));
          statement.execute();
          if(_completeHeroes != null && !_completeHeroes.containsKey(heroId))
          {
            HeroSetClanAndAlly(heroId, hero);
            _completeHeroes.put(heroId, hero);
          }
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM siege_clans WHERE unit_id=?");
      statement.setInt(1, unit_id);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("Exception: clearSiegeClan(): " + e);
      e.printStackTrace();
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.