Class MySQL
- java.lang.Object
-
- de.simonsator.partyandfriends.communication.sql.DBCommunication
-
- de.simonsator.partyandfriends.communication.sql.pool.PoolSQLCommunication
-
- de.simonsator.partyandfriends.communication.sql.MySQL
-
- All Implemented Interfaces:
Deactivated
public class MySQL extends PoolSQLCommunication
-
-
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 friendsint
changeSettingsWorth(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer, int pSettingsID)
Sets a settingvoid
deleteFriend(int pFriend1ID, int pFriend2ID)
Deletes a friendvoid
deletePlayerEntry(int pPlayerId)
void
denyRequest(int pReceiverSender, int pRequesterID)
Removes a friend requestvoid
firstJoin(net.md_5.bungee.api.connection.ProxiedPlayer pPlayer)
Will be executed if a player joins the first time on the serverjava.util.List<java.lang.Integer>
getFriends(int pPlayerID)
Gives out the IDs of the friends of a playerjava.sql.Timestamp
getLastOnline(int pPlayerID)
int
getLastPlayerWroteTo(int pID)
Returns the last player who wrote to the given playerjava.lang.String
getName(int pPlayerID)
Returns the name of a playerjava.util.List<OfflineMessage>
getOfflineMessages(net.md_5.bungee.api.connection.ProxiedPlayer player)
Get and deleteAccount offline messagesint
getPlayerID(java.lang.String pPlayerName)
Returns the ID of a playerint
getPlayerID(java.util.UUID pUUID)
Returns the ID of a playerint
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 playerint
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 MySQLvoid
sendFriendRequest(int pSenderID, int pQueryID)
Send a friend requestvoid
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 playervoid
updateUUID(int pPlayerID, java.util.UUID pNewUUID)
-
Methods inherited from class de.simonsator.partyandfriends.communication.sql.pool.PoolSQLCommunication
close, close, close, getConnection, getDatabase, onDisable
-
Methods inherited from class de.simonsator.partyandfriends.communication.sql.DBCommunication
close, close, close
-
-
-
-
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 playerpNewPlayerName
- 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 commandpIDReceiver
- The new friend
-
denyRequest
public void denyRequest(int pReceiverSender, int pRequesterID)
Removes a friend request- Parameters:
pReceiverSender
- The ID of the command executorpRequesterID
- 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 senderpFriend2ID
- 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 requestpQueryID
- 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 playerpSettingsID
- 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 playerpPlayer2
- 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 messageidReceiver
- Receiver of the messagepMessage
- 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 playerpLastWroteTo
- The ID of the player who wrote topI
- The pass
-
getLastOnline
public java.sql.Timestamp getLastOnline(int pPlayerID)
-
updateLastOnline
public void updateLastOnline(int pPlayerID)
-
deletePlayerEntry
public void deletePlayerEntry(int pPlayerId)
-
-