Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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://162.212.253.95:3306/ventyzc1_store",
- "ventyzc1_store", "zBJWZT=A+y4S");
- } catch (Exception e) {
- e.printStackTrace();
- System.err.println("Could not connect to Store SQL Database.");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement