Package l2p.database

Examples of l2p.database.FiltredPreparedStatement

647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
  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");
        if(name.contains("Buf_"))
        {
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
          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);
          target.broadcastUserInfo(true);
        }
View Full Code Here
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
  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");
        if(name.contains("bbsteleport_"))
        {
View Full Code Here
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
    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();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
  @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();
        hero.set(Olympiad.CHAR_NAME, Util.getCharNameByIdD(id));
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
        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
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
                {
                        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();
                }
                finally
                {
                        DatabaseUtils.closeDatabaseCS(con, statement);
                }
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
                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");
                        }
                        else
                        // Not Exist
                        {
View Full Code Here
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
        }

        private static void DeleteAccount(String account) throws SQLException
        {
                ThreadConnection con = null;
                FiltredPreparedStatement statement = null;
                FiltredPreparedStatement subStatement = null;
                ResultSet rset = null, subRset = 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.getInt(1) == 0)
                        {
                                System.out.println("Account \"" + account + "\" Not Exist\n");
                                return;
                        }
                        // Account exist
                        DatabaseUtils.closeDatabaseSR(statement, rset);
                        // Get Accounts ID
                        statement = con.prepareStatement("SELECT obj_Id, char_name, clanid FROM characters WHERE account_name=?;");
                        statement.setEscapeProcessing(true);
                        statement.setString(1, account);
                        rset = statement.executeQuery();
                        while(rset.next())
                        {
                                System.out.println("Deleting character \"" + rset.getString("char_name") + "\"\n");
                                // Check If clan leader Remove Clan and remove all from it
                                subStatement = con.prepareStatement("SELECT COUNT(*) FROM clan_data WHERE leader_id=?;");
                                subStatement.setString(1, rset.getString("clanid"));
                                subRset = subStatement.executeQuery();
                                boolean isClanLeader = false;
                                if(subRset.next() && subRset.getInt(1) > 0)
                                {
                                        isClanLeader = true;
                                }
                                DatabaseUtils.closeDatabaseSR(subStatement, subRset);
                                if(isClanLeader)
                                {
                                        // Clan Leader
                                        // Get Clan Name
                                        subStatement = con.prepareStatement("SELECT clan_name FROM clan_data WHERE leader_id=?;");
                                        subStatement.setString(1, rset.getString("clanid"));
                                        subRset = subStatement.executeQuery();
                                        String clanName = null;
                                        if(subRset.next())
                                        {
                                                clanName = subRset.getString("clan_name");
                                        }
                                        System.out.println("Deleting clan \"" + clanName + "\"\n");
                                        DatabaseUtils.closeDatabaseSR(subStatement, subRset);
                                        // Delete Clan Wars
                                        subStatement = con.prepareStatement("DELETE FROM clan_wars WHERE clan1=? OR clan2=?;");
                                        subStatement.setEscapeProcessing(true);
                                        subStatement.setString(1, clanName);
                                        subStatement.setString(2, clanName);
                                        subStatement.executeUpdate();
                                        DatabaseUtils.closeStatement(subStatement);
                                        // Remove All From clan
                                        subStatement = con.prepareStatement("UPDATE characters SET clanid=0 WHERE clanid=?;");
                                        subStatement.setString(1, rset.getString("clanid"));
                                        subStatement.executeUpdate();
                                        DatabaseUtils.closeStatement(subStatement);
                                        // Delete Clan
                                        subStatement = con.prepareStatement("DELETE FROM clan_data WHERE clan_id=?;");
                                        subStatement.setString(1, rset.getString("clanid"));
                                        subStatement.executeUpdate();
                                        DatabaseUtils.closeStatement(subStatement);
                                }
                                // skills
                                subStatement = con.prepareStatement("DELETE FROM character_skills WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // shortcuts
                                subStatement = con.prepareStatement("DELETE FROM character_shortcuts WHERE char_obj_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // items
                                subStatement = con.prepareStatement("DELETE FROM items WHERE owner_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                subStatement.executeUpdate();
                                DatabaseUtils.closeStatement(subStatement);
                                // recipebook
                                subStatement = con.prepareStatement("DELETE FROM character_recipebook WHERE char_id=?;");
                                subStatement.setString(1, rset.getString("obj_Id"));
                                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();
                                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();
                                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
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
    {0x06}, {0x22}, {0x21}, {0x2b}, {0x37}, {0x39}};

  private void cleanTempVars()
  {
    ThreadConnection con = null;
    FiltredPreparedStatement st = null;
    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
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.