Class MySQL

    • Constructor Summary

      Constructors 
      Constructor Description
      MySQL​(MySQLData pMySQLData, PoolData pPoolData, java.lang.Object pJedisPool)
      Connects to the MySQL server
    • Method Summary

      All Methods Instance Methods Concrete Methods Deprecated Methods 
      Modifier and Type Method Description
      void addFriend​(int pIDRequester, int pIDReceiver)
      Adds a player to friends
      int changeSettingsWorth​(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer, int pSettingsID)
      Sets a setting
      void deleteFriend​(int pFriend1ID, int pFriend2ID)
      Deletes a friend
      void deletePlayerEntry​(int pPlayerId)  
      void denyRequest​(int pReceiverSender, int pRequesterID)
      Removes a friend request
      void firstJoin​(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer)
      Will be executed if a player joins the first time on the server
      java.util.List<java.lang.Integer> getFriends​(int pPlayerID)
      Gives out the IDs of the friends of a player
      java.sql.Timestamp getLastOnline​(int pPlayerID)  
      int getLastPlayerWroteTo​(int pID)
      Returns the last player who wrote to the given player
      java.lang.String getName​(int pPlayerID)
      Returns the name of a player
      java.util.List<OfflineMessage> getOfflineMessages​(net.md_5.bungee.api.connection.ProxiedPlayer player)
      Get and deleteAccount offline messages
      int getPlayerID​(java.lang.String pPlayerName)
      Returns the ID of a player
      int getPlayerID​(java.util.UUID pUUID)
      Returns the ID of a player
      int getPlayerID​(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer)  
      java.util.ArrayList<java.lang.Integer> getRequests​(int pPlayerID)
      Returns the IDs of the friends from a player
      int getSettingsWorth​(int pPlayerID, int pSettingsID)  
      java.util.UUID getUUID​(int pPlayerID)  
      boolean hasRequestFrom​(int pReceiver, int pRequester)  
      boolean isAFriendOf​(int pPlayerID1, int pPlayerID2)  
      boolean isAFriendOf​(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer1, net.md_5.bungee.api.connection.ProxiedPlayer pPlayer2)
      Deprecated.
      void offlineMessage​(int idSender, int idReceiver, java.lang.String pMessage)
      Saves an offline message in MySQL
      void sendFriendRequest​(int pSenderID, int pQueryID)
      Send a friend request
      void setLastPlayerWroteTo​(int pPlayerID, int pLastWroteTo, int pI)  
      void setSetting​(int pPlayerID, int pSettingsID, int pNewWorth)  
      void updateLastOnline​(int pPlayerID)  
      void updatePlayerName​(int pPlayerID, java.lang.String pNewPlayerName)
      Updates the name of a player
      void updateUUID​(int pPlayerID, java.util.UUID pNewUUID)  
      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Constructor Detail

      • MySQL

        public MySQL​(MySQLData pMySQLData,
                     PoolData pPoolData,
                     java.lang.Object pJedisPool)
              throws java.sql.SQLException
        Connects to the MySQL server
        Parameters:
        pMySQLData - The MySQL data
        Throws:
        java.sql.SQLException
    • Method Detail

      • getUUID

        public java.util.UUID getUUID​(int pPlayerID)
      • getPlayerID

        public int getPlayerID​(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer)
      • getPlayerID

        public int getPlayerID​(java.util.UUID pUUID)
        Returns the ID of a player
        Parameters:
        pUUID - The UUID of the player
        Returns:
        Returns the ID of a player
      • getPlayerID

        public int getPlayerID​(java.lang.String pPlayerName)
        Returns the ID of a player
        Parameters:
        pPlayerName - Name of the player Returns the ID of a player
        Returns:
        Returns the ID of a player
      • firstJoin

        public void firstJoin​(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer)
        Will be executed if a player joins the first time on the server
        Parameters:
        pPlayer - The player
      • getFriends

        public java.util.List<java.lang.Integer> getFriends​(int pPlayerID)
        Gives out the IDs of the friends of a player
        Parameters:
        pPlayerID - The ID of the player
        Returns:
        Returns the IDs of the friends of a player
      • getName

        public java.lang.String getName​(int pPlayerID)
        Returns the name of a player
        Parameters:
        pPlayerID - The ID of the player
        Returns:
        Returns the name of a player
      • updatePlayerName

        public void updatePlayerName​(int pPlayerID,
                                     java.lang.String pNewPlayerName)
        Updates the name of a player
        Parameters:
        pPlayerID - The ID of the player
        pNewPlayerName - New name of the player
      • updateUUID

        public void updateUUID​(int pPlayerID,
                               java.util.UUID pNewUUID)
      • hasRequestFrom

        public boolean hasRequestFrom​(int pReceiver,
                                      int pRequester)
      • getRequests

        public java.util.ArrayList<java.lang.Integer> getRequests​(int pPlayerID)
        Returns the IDs of the friends from a player
        Parameters:
        pPlayerID - The ID of the player
        Returns:
        Returns the IDs of the friends from a player
      • addFriend

        public void addFriend​(int pIDRequester,
                              int pIDReceiver)
        Adds a player to friends
        Parameters:
        pIDRequester - The sender of the command
        pIDReceiver - The new friend
      • denyRequest

        public void denyRequest​(int pReceiverSender,
                                int pRequesterID)
        Removes a friend request
        Parameters:
        pReceiverSender - The ID of the command executor
        pRequesterID - The ID of the person who had send the friend request
      • deleteFriend

        public void deleteFriend​(int pFriend1ID,
                                 int pFriend2ID)
        Deletes a friend
        Parameters:
        pFriend1ID - The ID of the command sender
        pFriend2ID - The ID of the friend, which should be deleted
      • sendFriendRequest

        public void sendFriendRequest​(int pSenderID,
                                      int pQueryID)
        Send a friend request
        Parameters:
        pSenderID - The ID of Sender of the friend request
        pQueryID - The ID of the player, which gets the friend request
      • changeSettingsWorth

        public int changeSettingsWorth​(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer,
                                       int pSettingsID)
        Sets a setting
        Parameters:
        pPlayer - The player
        pSettingsID - The ID of the setting
        Returns:
        Returns the new worth
      • isAFriendOf

        @Deprecated
        public boolean isAFriendOf​(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer1,
                                   net.md_5.bungee.api.connection.ProxiedPlayer pPlayer2)
        Deprecated.
        Checks if somebody is a friend of someone others
        Parameters:
        pPlayer1 - The player
        pPlayer2 - The other player
        Returns:
        Returns if player one is a friend of player two true, otherwise false
      • getSettingsWorth

        public int getSettingsWorth​(int pPlayerID,
                                    int pSettingsID)
      • setSetting

        public void setSetting​(int pPlayerID,
                               int pSettingsID,
                               int pNewWorth)
      • offlineMessage

        public void offlineMessage​(int idSender,
                                   int idReceiver,
                                   java.lang.String pMessage)
        Saves an offline message in MySQL
        Parameters:
        idSender - Sender of the message
        idReceiver - Receiver of the message
        pMessage - The message, that should be send
      • getOfflineMessages

        public java.util.List<OfflineMessage> getOfflineMessages​(net.md_5.bungee.api.connection.ProxiedPlayer player)
        Get and deleteAccount offline messages
        Parameters:
        player - The player who receive the offline messages
        Returns:
        Returns the offline messages and the senders
      • isAFriendOf

        public boolean isAFriendOf​(int pPlayerID1,
                                   int pPlayerID2)
      • getLastPlayerWroteTo

        public int getLastPlayerWroteTo​(int pID)
        Returns the last player who wrote to the given player
        Parameters:
        pID - The ID of the player
        Returns:
        Returns the last player who wrote to the given player
      • setLastPlayerWroteTo

        public void setLastPlayerWroteTo​(int pPlayerID,
                                         int pLastWroteTo,
                                         int pI)
        Parameters:
        pPlayerID - The ID of the player
        pLastWroteTo - The ID of the player who wrote to
        pI - The pass
      • getLastOnline

        public java.sql.Timestamp getLastOnline​(int pPlayerID)
      • updateLastOnline

        public void updateLastOnline​(int pPlayerID)
      • deletePlayerEntry

        public void deletePlayerEntry​(int pPlayerId)