Package l2p.database

Examples of l2p.database.ThreadConnection.createStatement()

152
153
154
155
156
157
158
159
160
161
162
    ThreadConnection con = null;
    FiltredStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      statement.executeUpdate("UPDATE epic_boss_spawn SET respawnDate=" + _respawnDate / 1000 + ", state=" + _state.ordinal() + " WHERE bossId=" + _bossId);
      _log.info("update EpicBossState: ID:" + _bossId + ", RespawnDate:" + _respawnDate / 1000 + ", State:" + _state.toString());
    }
    catch(Exception e)
    {
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
    FiltredStatement statement = null;
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      rset = statement.executeQuery("SELECT bonus_name,bonus_value from bonus where obj_id='" + _owner.getObjectId() + "' and (bonus_expire_time='-1' or bonus_expire_time > " + System.currentTimeMillis() / 1000 + ")");
      while(rset.next())
      {
        String bonus_name = rset.getString("bonus_name");
        float bonus_value = rset.getFloat("bonus_value");
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
    ThreadConnection con = null;
    FiltredStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      statement.executeUpdate("UPDATE mail SET mail.unread=0 WHERE mail.messageId=" + mailId + " LIMIT 1");
    }
    catch(SQLException e)
    {
      e.printStackTrace();
View Full Code Here
595
596
597
598
599
600
601
602
603
604
605
    try
    {
      sendLock.lock();
      con = L2DatabaseFactory.getInstance().getConnection();
      // удаляем почту у удаленных чаров
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE mail FROM mail LEFT JOIN characters ON mail.sender = characters.obj_Id WHERE characters.obj_Id IS NULL");
      DatabaseUtils.closeStatement(stmt);
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE mail FROM mail LEFT JOIN characters ON mail.receiver = characters.obj_Id WHERE characters.obj_Id IS NULL");
      DatabaseUtils.closeStatement(stmt);
View Full Code Here
598
599
600
601
602
603
604
605
606
607
608
      con = L2DatabaseFactory.getInstance().getConnection();
      // удаляем почту у удаленных чаров
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE mail FROM mail LEFT JOIN characters ON mail.sender = characters.obj_Id WHERE characters.obj_Id IS NULL");
      DatabaseUtils.closeStatement(stmt);
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE mail FROM mail LEFT JOIN characters ON mail.receiver = characters.obj_Id WHERE characters.obj_Id IS NULL");
      DatabaseUtils.closeStatement(stmt);
      // удаляем протухшие письма
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE FROM mail WHERE UNIX_TIMESTAMP(expire) < UNIX_TIMESTAMP()");
View Full Code Here
602
603
604
605
606
607
608
609
610
611
612
      DatabaseUtils.closeStatement(stmt);
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE mail FROM mail LEFT JOIN characters ON mail.receiver = characters.obj_Id WHERE characters.obj_Id IS NULL");
      DatabaseUtils.closeStatement(stmt);
      // удаляем протухшие письма
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE FROM mail WHERE UNIX_TIMESTAMP(expire) < UNIX_TIMESTAMP()");
      DatabaseUtils.closeStatement(stmt);
      // удаляем некорректные аттачи
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE mail_attachments FROM mail_attachments LEFT JOIN items ON mail_attachments.itemId = items.object_id WHERE items.object_id IS NULL");
View Full Code Here
606
607
608
609
610
611
612
613
614
615
616
      // удаляем протухшие письма
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE FROM mail WHERE UNIX_TIMESTAMP(expire) < UNIX_TIMESTAMP()");
      DatabaseUtils.closeStatement(stmt);
      // удаляем некорректные аттачи
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE mail_attachments FROM mail_attachments LEFT JOIN items ON mail_attachments.itemId = items.object_id WHERE items.object_id IS NULL");
      DatabaseUtils.closeStatement(stmt);
      // чистим письма с потерянными аттачами
      stmt = con.createStatement();
      stmt.executeUpdate("UPDATE mail LEFT JOIN mail_attachments ON mail.messageId = mail_attachments.messageId SET price=0,attachments=0 WHERE mail_attachments.messageId IS NULL");
View Full Code Here
610
611
612
613
614
615
616
617
618
619
620
      // удаляем некорректные аттачи
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE mail_attachments FROM mail_attachments LEFT JOIN items ON mail_attachments.itemId = items.object_id WHERE items.object_id IS NULL");
      DatabaseUtils.closeStatement(stmt);
      // чистим письма с потерянными аттачами
      stmt = con.createStatement();
      stmt.executeUpdate("UPDATE mail LEFT JOIN mail_attachments ON mail.messageId = mail_attachments.messageId SET price=0,attachments=0 WHERE mail_attachments.messageId IS NULL");
      DatabaseUtils.closeStatement(stmt);
      // чистим от мусора в mail_attachments, возвращая вещи владельцам
      stmt = con.createStatement();
      rs = stmt.executeQuery("SELECT itemId FROM mail_attachments LEFT JOIN mail ON mail.messageId = mail_attachments.messageId WHERE mail.messageId IS NULL");
View Full Code Here
614
615
616
617
618
619
620
621
622
623
624
      // чистим письма с потерянными аттачами
      stmt = con.createStatement();
      stmt.executeUpdate("UPDATE mail LEFT JOIN mail_attachments ON mail.messageId = mail_attachments.messageId SET price=0,attachments=0 WHERE mail_attachments.messageId IS NULL");
      DatabaseUtils.closeStatement(stmt);
      // чистим от мусора в mail_attachments, возвращая вещи владельцам
      stmt = con.createStatement();
      rs = stmt.executeQuery("SELECT itemId FROM mail_attachments LEFT JOIN mail ON mail.messageId = mail_attachments.messageId WHERE mail.messageId IS NULL");
      while(rs.next())
      {
        L2ItemInstance item = L2ItemInstance.restoreFromDb(rs.getInt("itemId"), false);
        if(item.getOwnerId() == 0)
View Full Code Here
629
630
631
632
633
634
635
636
637
638
639
        {
          returnItem(item);
        }
      }
      DatabaseUtils.closeDatabaseSR(stmt, rs);
      stmt = con.createStatement();
      stmt.executeUpdate("DELETE mail_attachments FROM mail_attachments LEFT JOIN mail ON mail.messageId = mail_attachments.messageId WHERE mail.messageId IS NULL");
      DatabaseUtils.closeStatement(stmt);
    }
    catch(SQLException 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.