Package l2p.database

Examples of l2p.database.ThreadConnection

329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
                        int min_offline_restore = (int) (System.currentTimeMillis() / 1000 - Config.SERVICES_OFFLINE_TRADE_SECONDS_TO_KICK);
                        mysql.set("DELETE FROM character_variables WHERE `name` = 'offline' AND `value` < "
                                + min_offline_restore);
                    }
                    mysql.set("DELETE FROM character_variables WHERE `name` = 'offline' AND `obj_id` IN (SELECT `obj_id` FROM `characters` WHERE `accessLevel` < 0)");
                    ThreadConnection con = null;
                    FiltredPreparedStatement st = null;
                    ResultSet rs = null;
                    try {
                        GArray<Object> logins = mysql.get_array(L2DatabaseFactory.getInstanceLogin(),
                                "SELECT `login` FROM `accounts` WHERE `access_level` < 0");
                        if (logins.size() > 0) {
                            con = L2DatabaseFactory.getInstance().getConnection();
                            st = con.prepareStatement("DELETE FROM character_variables WHERE `name` = 'offline' AND `obj_id` IN (SELECT `obj_id` FROM `characters` WHERE `account_name`=?)");
                            for (Object login : logins) {
                                st.setString(1, (String) login);
                                st.executeUpdate();
                            }
                        }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
    {
      sendMessage(new CustomMessage("scripts.services.Activation.InvalidNewMail", player), player);
      activation_page();
      return;
    }
    ThreadConnection con = null;
    FiltredPreparedStatement statement = null;
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstanceLogin().getConnection();
      statement = con.prepareStatement("SELECT * FROM `accounts` WHERE email=?");
      statement.setString(1, email1);
      rset = statement.executeQuery();
      if(rset.next())
      {
        sendMessage(new CustomMessage("scripts.services.Activation.EmailAlreadyExists", player), player);
View Full Code Here
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
  public static void open(int objectId)
  {
    L2Player player = L2ObjectsStorage.getPlayer(objectId);
    String SQL = "SELECT * FROM character_variables WHERE obj_Id = ?";
    ThreadConnection tc = null;
    FiltredPreparedStatement fps = null;
    ResultSet rs = null;
    try
    {
      tc = L2DatabaseFactory.getInstance().getConnection();
      fps = tc.prepareStatement(SQL);
      fps.setInt(1, player.getObjectId());
      rs = fps.executeQuery();
      while(rs.next())
      {
        String name = rs.getString("name");
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
          clanMember.setClan(null);
          clanMember.setTitle(null);
          clanMember.sendPacket(Msg.CLAN_HAS_DISPERSED);
          clanMember.broadcastUserInfo(true);
        }
        ThreadConnection con = null;
        FiltredPreparedStatement statement = null;
        try
        {
          con = L2DatabaseFactory.getInstance().getConnection();
          statement = con.prepareStatement("UPDATE characters SET clanid = 0 WHERE clanid=?");
          statement.setInt(1, target.getClanId());
          statement.execute();
          DatabaseUtils.closeStatement(statement);
          statement = con.prepareStatement("DELETE FROM clan_data WHERE clan_id=?");
          statement.setInt(1, target.getClanId());
          statement.execute();
          DatabaseUtils.closeStatement(statement);
          statement = null;
          target.sendPacket(Msg.CLAN_HAS_DISPERSED);
View Full Code Here
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
  public static void open(int objectId)
  {
    L2Player player = L2ObjectsStorage.getPlayer(objectId);
    String SQL = "SELECT * FROM character_variables WHERE obj_Id = ?";
    ThreadConnection tc = null;
    FiltredPreparedStatement fps = null;
    ResultSet rs = null;
    try
    {
      tc = L2DatabaseFactory.getInstance().getConnection();
      fps = tc.prepareStatement(SQL);
      fps.setInt(1, player.getObjectId());
      rs = fps.executeQuery();
      while(rs.next())
      {
        String name = rs.getString("name");
View Full Code Here
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
  {
    if(obj_id == 0)
    {
      return;
    }
    ThreadConnection con = null;
    FiltredPreparedStatement st = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      st = con.prepareStatement("UPDATE characters SET x=?,y=?,z=? WHERE obj_Id=? LIMIT 1");
      st.setInt(1, loc.x);
      st.setInt(2, loc.y);
      st.setInt(3, loc.z);
      st.setInt(4, obj_id);
      st.executeUpdate();
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
  @Override
  public void getStat()
  {
    Map<Integer, StatsSet> _heroes = new FastMap<Integer, StatsSet>();
    ThreadConnection tc = null;
    FiltredPreparedStatement fps = null;
    ResultSet rs = null;
    try
    {
      tc = L2DatabaseFactory.getInstance().getConnection();
      fps = tc.prepareStatement("SELECT obj_id, value FROM character_variables WHERE `name` = 'BlackHeart_Count' ORDER BY CAST(`value` AS DECIMAL) DESC LIMIT 15");
      rs = fps.executeQuery();
      while(rs.next())
      {
        int id = rs.getInt("obj_id");
        StatsSet hero = new StatsSet();
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
        }

        private static void printAccInfo() throws SQLException
        {
                int count = 0;
                ThreadConnection con = null;
                FiltredPreparedStatement statement = null;
                ResultSet rset = null;
                try
                {
                        con = L2DatabaseFactory.getInstance().getConnection();
                        statement = con.prepareStatement("SELECT login, access_level FROM accounts ORDER BY login ASC");
                        rset = statement.executeQuery();
                        while(rset.next())
                        {
                                System.out.println(rset.getString("login") + " -> " + rset.getInt("access_level"));
                                count++;
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
                if(Integer.parseInt(level) > 100)
                {
                        level = "100";
                }
                // Add to Base
                ThreadConnection con = null;
                FiltredPreparedStatement statement = null;
                try
                {
                        con = L2DatabaseFactory.getInstance().getConnection();
                        statement = con.prepareStatement("REPLACE  accounts (login, password, access_level, comments) VALUES (?,?,?,?)");
                        statement.setString(1, account);
                        statement.setString(2, Base64.encodeBytes(newpass));
                        statement.setString(3, level);
                        statement.setString(4, comments);
                        statement.executeUpdate();
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
        {
                if(Integer.parseInt(level) > 100)
                {
                        level = "100";
                }
                ThreadConnection con = null;
                FiltredPreparedStatement statement = null;
                ResultSet rset = null;
                try
                {
                        con = L2DatabaseFactory.getInstance().getConnection();
                        // Check Account Exist
                        statement = con.prepareStatement("SELECT COUNT(*) FROM accounts WHERE login=?;");
                        statement.setString(1, account);
                        rset = statement.executeQuery();
                        if(rset.next() && rset.getInt(1) > 0)
                        {
                                // Exist
                                // Update
                                statement = con.prepareStatement("UPDATE accounts SET access_level=? WHERE login=?;");
                                statement.setEscapeProcessing(true);
                                statement.setString(1, level);
                                statement.setString(2, account);
                                statement.executeUpdate();
                                System.out.println("Account \"" + account + "\" Updated\n");
View Full Code Here
TOP

Related Classes of l2p.database.ThreadConnection

  • bosses.EpicBossState
  • bosses.FourSepulchersSpawn
  • bosses.LastImperialTombSpawnlist
  • commands.admin.AdminRepairChar
  • community.mGeneratePage
  • community.teleport.Teleport
  • events.tournament.Tournament_data
  • l2p.accountmanager.SQLAccountManager
  • l2p.extensions.Bonus
  • l2p.extensions.Stat
    • 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.