Luke

package com.ventyz.sql;

import java.io.BufferedWriter;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;

import com.ventyz.server.character.Client;

// TODO: Auto-generated Javadoc
/**
 * The Class Store.
 */
public class Store {

    /** The connection. */
    private static Connection connection;

    /** The las connection. */
    private static long lasConnection = System.currentTimeMillis();
    static {
        init();
    }

    /**
     * Claim payment.
     *
     * @param p
     *            the p
     * @param name
     *            the name
     */
    public static void claimPayment(final Client p, final String name) {
        try {
            if (System.currentTimeMillis() - lasConnection > 10000) {
                destroyConnection();
                init();
                lasConnection = System.currentTimeMillis();
            }
            Statement s = connection.createStatement();
            String name2 = name.replaceAll(" ", "_");
            String query = "SELECT * FROM itemstore WHERE username = '" + name2
                    + "'";
            ResultSet rs = s.executeQuery(query);
            boolean claimed = false;
            while (rs.next()) {
                int prod = Integer.parseInt(rs.getString("productid"));
                int price = Integer.parseInt(rs.getString("price"));
                if (prod == 1 && price == 8) {
                    p.gfx100(199);
                    p.getMembersCredit().give(p, 30);
                    claimed = true;
                    final String FILE_PATH = "data/logs/orders/";
                    try {
                        DateFormat dateFormat = new SimpleDateFormat(
                                "MM/dd/yy HH:mm:ss");
                        Calendar cal = Calendar.getInstance();
                        BufferedWriter writer = new BufferedWriter(
                                new FileWriter(FILE_PATH + p.username + ".txt",
                                        true));
                        writer.write("[" + dateFormat.format(cal.getTime())
                                + ", IP: " + p.connectedFrom
                                + "] received 30 days of membership.");
                        writer.newLine();
                        writer.flush();
                        writer.close();
                    } catch (IOException e) {
                        System.err.println(e);
                    }
                } else if (prod == 2 && price == 21) {
                    p.gfx100(199);
                    p.getMembersCredit().give(p, 90);
                    claimed = true;
                    final String FILE_PATH = "data/logs/orders/";
                    try {
                        DateFormat dateFormat = new SimpleDateFormat(
                                "MM/dd/yy HH:mm:ss");
                        Calendar cal = Calendar.getInstance();
                        BufferedWriter writer = new BufferedWriter(
                                new FileWriter(FILE_PATH + p.username + ".txt",
                                        true));
                        writer.write("[" + dateFormat.format(cal.getTime())
                                + ", IP: " + p.connectedFrom
                                + "] received 90 days of membership.");
                        writer.newLine();
                        writer.flush();
                        writer.close();
                    } catch (IOException e) {
                        System.err.println(e);
                    }
                } else if (prod == 3 && price == 35) {
                    p.gfx100(199);
                    p.getMembersCredit().give(p, 100000);
                    claimed = true;
                    final String FILE_PATH = "data/logs/orders/";
                    try {
                        DateFormat dateFormat = new SimpleDateFormat(
                                "MM/dd/yy HH:mm:ss");
                        Calendar cal = Calendar.getInstance();
                        BufferedWriter writer = new BufferedWriter(
                                new FileWriter(FILE_PATH + p.username + ".txt",
                                        true));
                        writer.write("[" + dateFormat.format(cal.getTime())
                                + ", IP: " + p.connectedFrom
                                + "] received lifeitme membership.");
                        writer.newLine();
                        writer.flush();
                        writer.close();
                    } catch (IOException e) {
                        System.err.println(e);
                    }
                } else if (prod == 4 && price == 5) {
                    p.gfx100(199);
                    p.credits += 10;
                    claimed = true;
                    final String FILE_PATH = "data/logs/orders/";
                    try {
                        DateFormat dateFormat = new SimpleDateFormat(
                                "MM/dd/yy HH:mm:ss");
                        Calendar cal = Calendar.getInstance();
                        BufferedWriter writer = new BufferedWriter(
                                new FileWriter(FILE_PATH + p.username + ".txt",
                                        true));
                        writer.write("[" + dateFormat.format(cal.getTime())
                                + ", IP: " + p.connectedFrom
                                + "] received 10 credits.");
                        writer.newLine();
                        writer.flush();
                        writer.close();
                    } catch (IOException e) {
                        System.err.println(e);
                    }
                } else if (prod == 5 && price == 12) {
                    p.gfx100(199);
                    p.credits += 25;
                    claimed = true;
                    final String FILE_PATH = "data/logs/orders/";
                    try {
                        DateFormat dateFormat = new SimpleDateFormat(
                                "MM/dd/yy HH:mm:ss");
                        Calendar cal = Calendar.getInstance();
                        BufferedWriter writer = new BufferedWriter(
                                new FileWriter(FILE_PATH + p.username + ".txt",
                                        true));
                        writer.write("[" + dateFormat.format(cal.getTime())
                                + ", IP: " + p.connectedFrom
                                + "] received 25 credits.");
                        writer.newLine();
                        writer.flush();
                        writer.close();
                    } catch (IOException e) {
                        System.err.println(e);
                    }
                } else if (prod == 6 && price == 23) {
                    p.gfx100(199);
                    p.credits += 50;
                    claimed = true;
                    final String FILE_PATH = "data/logs/orders/";
                    try {
                        DateFormat dateFormat = new SimpleDateFormat(
                                "MM/dd/yy HH:mm:ss");
                        Calendar cal = Calendar.getInstance();
                        BufferedWriter writer = new BufferedWriter(
                                new FileWriter(FILE_PATH + p.username + ".txt",
                                        true));
                        writer.write("[" + dateFormat.format(cal.getTime())
                                + ", IP: " + p.connectedFrom
                                + "] received 50 credits.");
                        writer.newLine();
                        writer.flush();
                        writer.close();
                    } catch (IOException e) {
                        System.err.println(e);
                    }
                } else if (prod == 7 && price == 45) {
                    p.gfx100(199);
                    p.credits += 100;
                    claimed = true;
                    final String FILE_PATH = "data/logs/orders/";
                    try {
                        DateFormat dateFormat = new SimpleDateFormat(
                                "MM/dd/yy HH:mm:ss");
                        Calendar cal = Calendar.getInstance();
                        BufferedWriter writer = new BufferedWriter(
                                new FileWriter(FILE_PATH + p.username + ".txt",
                                        true));
                        writer.write("[" + dateFormat.format(cal.getTime())
                                + ", IP: " + p.connectedFrom
                                + "] received 100 credits.");
                        writer.newLine();
                        writer.flush();
                        writer.close();
                    } catch (IOException e) {
                        System.err.println(e);
                    }
                } else if (prod == 8 && price == 90) {
                    p.gfx100(199);
                    p.credits += 250;
                    claimed = true;
                    final String FILE_PATH = "data/logs/orders/";
                    try {
                        DateFormat dateFormat = new SimpleDateFormat(
                                "MM/dd/yy HH:mm:ss");
                        Calendar cal = Calendar.getInstance();
                        BufferedWriter writer = new BufferedWriter(
                                new FileWriter(FILE_PATH + p.username + ".txt",
                                        true));
                        writer.write("[" + dateFormat.format(cal.getTime())
                                + ", IP: " + p.connectedFrom
                                + "] received 250 credits.");
                        writer.newLine();
                        writer.flush();
                        writer.close();
                    } catch (IOException e) {
                        System.err.println(e);
                    }
                }
                if (claimed) {
                    s.execute("DELETE FROM `itemstore` WHERE `username` = '"
                            + name2 + "';");

                    final String FILE_PATH = "data/logs/orders/orders.txt";
                    try {
                        Calendar cal = Calendar.getInstance();
                        BufferedWriter writer = new BufferedWriter(
                                new FileWriter(FILE_PATH, true));
                        writer.write("[" + cal.getTime() + "] - $" + price);
                        writer.newLine();
                        writer.flush();
                        writer.close();
                    } catch (IOException e) {
                        System.err.println(e);
                    }
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * Destroy connection.
     */
    public static void destroyConnection() {
        try {
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    /**
     * Inits the.
     */
    public static void init() {
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();

            connection = DriverManager.getConnection(
                    "jdbc:mysql://websitename/db",
                    "user", "password");
        } catch (Exception e) {
            e.printStackTrace();
            System.err.println("Could not connect to Store SQL Database.");
        }
    }
}