DXKHBYDv

1        api.addMessageCreateListener(event -> {
2            if (event.getMessageContent().equalsIgnoreCase(prefix + "Help")) {
3                //for creating table
4                try {
5                	Connection myConn = DriverManager.getConnection("");
6                	Statement stmt = myConn.createStatement();
7                	stmt = myConn.createStatement();
8                    //this is just a test
9                    String ST = "CREATE TABLE IF NOT EXISTS Tickets(id int NOT NULL AUTO_INCREMENT, tickets INT(255), PRIMARY KEY (id))";
10
11                    stmt.executeUpdate(ST);
12
13                }catch (Exception exc) { 
14                	exc.printStackTrace();
15                }
16                try {
17                 	 Class.forName("com.mysql.jdbc.Driver").newInstance();
18                      Connection con = DriverManager.getConnection("");
19
20                      Statement st = con.createStatement();
21                      String sql = ("SELECT * FROM Tickets ORDER BY id DESC LIMIT 1;");
22                      ResultSet rs = st.executeQuery(sql);
23                      if(rs.next()) { 
24                       int id = rs.getInt("id"); 
25                       tick = rs.getInt("tickets");
26                    	System.out.println(tick + " THIS IS TICK NUM");
27                      }}
28                      catch (Exception exc) { 
29                      	exc.printStackTrace();
30                      }
31                if (tick > 0) {
32                	i = tick;
33                } else {
34                    AtomicInteger i = new AtomicInteger();
35                }
36                x = i;
37                Server server = event.getServer().get();
38                ServerTextChannel channel = new ServerTextChannelBuilder(server)
39                        .setName("Ticket-" + x)
40                        .addPermissionOverwrite(api.getRoleById("797209627660910643").stream().findFirst().orElseThrow(), new PermissionsBuilder().setAllDenied().build())
41                        .addPermissionOverwrite(api.getRoleById("799310191068840039").stream().findFirst().orElseThrow(), new PermissionsBuilder().setAllowed(PermissionType.READ_MESSAGE_HISTORY, PermissionType.READ_MESSAGES, PermissionType.SEND_MESSAGES).build())
42                        .addPermissionOverwrite(event.getMessageAuthor().asUser().orElseThrow(), new PermissionsBuilder().setAllowed(PermissionType.READ_MESSAGE_HISTORY, PermissionType.READ_MESSAGES, PermissionType.SEND_MESSAGES).build())
43                        .create().join();
44                channel.sendMessage("Ticket created");
45                //for placing x into mysql
46                int var = x;
47                try {
48                	Connection myConn = DriverManager.getConnection("", "o2Kz1Aqr+v9XWA^Kj40EoG+Y");
49                	PreparedStatement posted = myConn.prepareStatement("INSERT INTO Tickets (tickets) VALUES ('"+var+"')");
50                	posted.executeUpdate();
51                }
52                catch (Exception exc) { 
53                	exc.printStackTrace();
54                }
55                x = x + 1;
56            }//Dont go past here Ukraine 
57            //""
58        });