Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- This file is part of the OdinMS Maple Story Server
- Copyright (C) 2008 Patrick Huy <patrick.huy@frz.cc>
- Matthias Butz <matze@odinms.de>
- Jan Christian Meyer <vimes@odinms.de>
- This program is free software: you can redistribute it and/or modify
- it under the terms of the GNU Affero General Public License as
- published by the Free Software Foundation version 3 as published by
- the Free Software Foundation. You may not use, modify or distribute
- this program under any other version of the GNU Affero General Public
- License.
- This program is distributed in the hope that it will be useful,
- but WITHOUT ANY WARRANTY; without even the implied warranty of
- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- GNU Affero General Public License for more details.
- You should have received a copy of the GNU Affero General Public License
- along with this program. If not, see <http://www.gnu.org/licenses/>.
- */
- package net.server.channel.handlers;
- import client.MapleClient;
- import net.AbstractMaplePacketHandler;
- import server.MapleInventoryManipulator;
- import tools.DatabaseConnection;
- import tools.MaplePacketCreator;
- import tools.data.input.SeekableLittleEndianAccessor;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- /**
- * @author Penguins (Acrylic)
- */
- public final class CouponCodeHandler extends AbstractMaplePacketHandler {
- public final void handlePacket(SeekableLittleEndianAccessor slea, MapleClient c) {
- slea.skip(2);
- String code = slea.readMapleAsciiString();
- boolean validcode = false;
- int type = -1;
- int item = -1;
- validcode = getNXCodeValid(code.toUpperCase(), validcode);
- if (validcode) {
- type = getNXCode(code, "type");
- item = getNXCode(code, "item");
- if (type != 5) {
- try {
- Connection con = DatabaseConnection.getConnection();
- PreparedStatement ps = con.prepareStatement("UPDATE nxcode SET `valid` = 0 WHERE code = " + code);
- ps.executeUpdate();
- ps.close();
- ps = con.prepareStatement("UPDATE nxcode SET `user` = ? WHERE code = ?");
- ps.setString(1, c.getPlayer().getName());
- ps.setString(2, code);
- ps.executeUpdate();
- ps.close();
- con.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- switch (type) {
- case 0:
- case 1:
- case 2:
- c.getPlayer().getCashShop().gainCash(type, item);
- break;
- case 3:
- c.getPlayer().getCashShop().gainCash(0, item);
- c.getPlayer().getCashShop().gainCash(2, (item / 5000));
- break;
- case 4:
- MapleInventoryManipulator.addById(c, item, (short) 1, null, -1, -1);
- c.announce(MaplePacketCreator.showCouponRedeemedItem(item));
- break;
- case 5:
- c.getPlayer().getCashShop().gainCash(0, item);
- break;
- }
- c.announce(MaplePacketCreator.showCash(c.getPlayer()));
- } else {
- //c.announce(MaplePacketCreator.wrongCouponCode());
- }
- c.announce(MaplePacketCreator.enableCSUse());
- }
- private int getNXCode(String code, String type) {
- int item = -1;
- try {
- Connection con = DatabaseConnection.getConnection();
- PreparedStatement ps = con.prepareStatement("SELECT `" + type + "` FROM nxcode WHERE code = ?");
- ps.setString(1, code);
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- item = rs.getInt(type);
- }
- rs.close();
- ps.close();
- con.close();
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- return item;
- }
- private boolean getNXCodeValid(String code, boolean validcode) {
- try {
- Connection con = DatabaseConnection.getConnection();
- PreparedStatement ps = con.prepareStatement("SELECT `valid` FROM nxcode WHERE code = ?");
- ps.setString(1, code);
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- validcode = rs.getInt("valid") != 0;
- }
- rs.close();
- ps.close();
- con.close();
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- return validcode;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement