Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @SuppressWarnings("static-access")
- public ArrayList<Integer> get_friend_demande(String p1){
- int guid1 = this.getguid(p1);
- String strClassName = "com.mysql.jdbc.Driver";
- ArrayList<Integer> list = new ArrayList<Integer>();
- try {
- Class.forName(strClassName);
- } catch (ClassNotFoundException e1) {
- e1.printStackTrace();
- }
- try {
- String strUrl = "jdbc:mysql://localhost:3306/bungee";
- java.sql.Connection conn = DriverManager.getConnection(strUrl,main.pseudo,main.mdp);
- String Query = "SELECT * FROM player_social WHERE guid = '" + guid1 + "' AND flag = '2';";
- ResultSet rs1 = conn.createStatement().executeQuery(Query);
- while(rs1.next()) {
- if (rs1.getInt("guid") > 0){
- list.add(rs1.getInt("friend"));
- }
- }
- conn.close();
- } catch(SQLException e) {
- main.getLogger().info("ERREUR SQL_Bungee_get_friend Veuillez contacter un administrateur");
- main.getLogger().info(e.getMessage());
- }
- try {
- String strUrl = "jdbc:mysql://localhost:3306/bungee";
- java.sql.Connection conn = DriverManager.getConnection(strUrl,main.pseudo,main.mdp);
- String Query = "SELECT * FROM player_social WHERE flag = '2' AND friend = '" + guid1 + "';";
- ResultSet rs1 = conn.createStatement().executeQuery(Query);
- while(rs1.next()) {
- if (rs1.getInt("guid") > 0){
- list.add(rs1.getInt("guid"));
- }
- }
- conn.close();
- } catch(SQLException e) {
- main.getLogger().info("ERREUR SQL_Bungee_get_friend Veuillez contacter un administrateur");
- main.getLogger().info(e.getMessage());
- }
- return list;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement