Class ServerWorldDatabase

java.lang.Object

zombie.network.ServerWorldDatabase

public class ServerWorldDatabase
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
class	ServerWorldDatabase.LogonResult

Field Summary

Fields

Modifier and Type	Field	Description
static final int	AUTH_TYPE_GOOGLE_AUTH
static final int	AUTH_TYPE_TWO_FACTOR
static final int	AUTH_TYPE_USERNAME_PASSWORD
String	commandLineAdminPassword
String	commandLineAdminUsername
boolean	doAdmin
static ServerWorldDatabase	instance

Constructor Summary

Constructors

Constructor	Description
ServerWorldDatabase()

Method Summary

Modifier and Type	Method	Description
void	addTicket(String author, String message, int ticketID)
String	addUser(String user, String pass)
String	addUser(String user, String pass, int authType)
void	addUserlog(String username, Userlog.UserlogType type, String text, String issuedBy, int amount)
String	addWarningPoint(String username, String reason, int amount, String issuedBy)
ServerWorldDatabase.LogonResult	authClient(long steamID)
ServerWorldDatabase.LogonResult	authClient(String user, String pass, String ip, long steamID, int authType)
ServerWorldDatabase.LogonResult	authOwner(long steamID, long ownerID)
String	banIp(String ip, String username, String reason, boolean ban)
String	banSteamID(String steamID, String reason, boolean ban)
String	banUser(String username, boolean ban)
String	changePassword(String username, String newPwd)
String	changePwd(String username, String previousPwd, String newPwd)
String	changeUsername(String user, String newUsername)
void	close()
void	connect()
boolean	containsCaseinsensitiveUser(String user)
boolean	containsUser(String user)
boolean	containsUser(String user, String world)
void	create()
static String	encrypt(String previousPwd)
ArrayList<DBBannedIP>	getBannedIPs()
ArrayList<DBBannedSteamID>	getBannedSteamIDs()
int	getDefaultRoleId(String name)
String	getDisplayName(String username)
String	getFirstBannedIPForUser(String username)
ArrayList<DBTicket>	getTickets(String playerName)
String	getTOTPCode(String secretKey)
String	getUserGoogleKey(String username)
ArrayList<Userlog>	getUserlog(String username)
void	getUserlogUsers(HashMap<String, NetworkUser> users)
Role	getUserRoleNameByUsername(String username)
void	getWhitelistUsers(HashMap<String, NetworkUser> users)
ServerWorldDatabase.LogonResult	googleAuthClient(String user, String code)
String	isSteamIdBanned(String _steamID)
static boolean	isValidUserName(String user)
void	loadRoles(ArrayList<Role> roles)
void	removeRole(Role role, Role newRoleInsteadExist)
void	removeTicket(int ticketID)
String	removeUser(String username)
String	removeUser(String username, String world)
void	removeUserLog(String username, String type, String text)
void	resetUserGoogleKey(String username)
void	saveDefaultRole(Role role, String name)
void	saveRole(Role role)
void	saveRoleCapabilities(Role role)
void	setPassword(String username, String encryptedPwd)
String	setRole(String username, Role role)
boolean	setUserGoogleKey(String username, String key)
String	setUserSteamID(String user, String steamID)
void	updateDisplayName(String user, String displayName)
void	updateLastConnectionDate(String u, String p)
void	updateUserCounters(Collection<NetworkUser> users)
void	viewedTicket(int ticketID, boolean viewed)

Methods inherited from class Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

AUTH_TYPE_USERNAME_PASSWORD

public static final int AUTH_TYPE_USERNAME_PASSWORD

See Also:

• Constant Field Values

AUTH_TYPE_GOOGLE_AUTH

public static final int AUTH_TYPE_GOOGLE_AUTH

See Also:

• Constant Field Values

AUTH_TYPE_TWO_FACTOR

public static final int AUTH_TYPE_TWO_FACTOR

See Also:

• Constant Field Values

instance

public static ServerWorldDatabase instance

commandLineAdminUsername

public String commandLineAdminUsername

commandLineAdminPassword

public String commandLineAdminPassword

doAdmin

public boolean doAdmin

Constructor Details

ServerWorldDatabase

public ServerWorldDatabase()

Method Details

getWhitelistUsers

public void getWhitelistUsers(HashMap<String, NetworkUser> users)

getUserlogUsers

public void getUserlogUsers(HashMap<String, NetworkUser> users)

updateUserCounters

public void updateUserCounters(Collection<NetworkUser> users)

containsUser

public boolean containsUser(String user,
 String world)

containsUser

public boolean containsUser(String user)

containsCaseinsensitiveUser

public boolean containsCaseinsensitiveUser(String user)

changeUsername

public String changeUsername(String user,
 String newUsername)
                      throws SQLException

Throws:

SQLException

getTOTPCode

public String getTOTPCode(String secretKey)

addUser

public String addUser(String user,
 String pass)
               throws SQLException

Throws:

SQLException

addUser

public String addUser(String user,
 String pass,
 int authType)
               throws SQLException

Throws:

SQLException

updateDisplayName

public void updateDisplayName(String user,
 String displayName)

getDisplayName

public String getDisplayName(String username)

removeUser

public String removeUser(String username,
 String world)
                  throws SQLException

Throws:

SQLException

removeUser

public String removeUser(String username)
                  throws SQLException

Throws:

SQLException

removeUserLog

public void removeUserLog(String username,
 String type,
 String text)
                   throws SQLException

Throws:

SQLException

connect

public void connect()

create

public void create()
            throws SQLException,
ClassNotFoundException

Throws:

SQLException

ClassNotFoundException

close

public void close()

isValidUserName

public static boolean isValidUserName(String user)

saveRole

public void saveRole(Role role)

removeRole

public void removeRole(Role role,
 Role newRoleInsteadExist)

saveDefaultRole

public void saveDefaultRole(Role role,
 String name)

getDefaultRoleId

public int getDefaultRoleId(String name)

saveRoleCapabilities

public void saveRoleCapabilities(Role role)

loadRoles

public void loadRoles(ArrayList<Role> roles)

googleAuthClient

public ServerWorldDatabase.LogonResult googleAuthClient(String user,
 String code)

authClient

public ServerWorldDatabase.LogonResult authClient(String user,
 String pass,
 String ip,
 long steamID,
 int authType)

authClient

public ServerWorldDatabase.LogonResult authClient(long steamID)

authOwner

public ServerWorldDatabase.LogonResult authOwner(long steamID,
 long ownerID)

encrypt

public static String encrypt(String previousPwd)

changePassword

public String changePassword(String username,
 String newPwd)
                      throws SQLException

Throws:

SQLException

changePwd

public String changePwd(String username,
 String previousPwd,
 String newPwd)
                 throws SQLException

Throws:

SQLException

setRole

public String setRole(String username,
 Role role)
               throws SQLException

Throws:

SQLException

getUserlog

public ArrayList<Userlog> getUserlog(String username)

addUserlog

public void addUserlog(String username,
 Userlog.UserlogType type,
 String text,
 String issuedBy,
 int amount)

getUserRoleNameByUsername

public Role getUserRoleNameByUsername(String username)

banUser

public String banUser(String username,
 boolean ban)
               throws SQLException

Throws:

SQLException

getFirstBannedIPForUser

public String getFirstBannedIPForUser(String username)

banIp

public String banIp(String ip,
 String username,
 String reason,
 boolean ban)
             throws SQLException

Throws:

SQLException

isSteamIdBanned

public String isSteamIdBanned(String _steamID)

banSteamID

public String banSteamID(String steamID,
 String reason,
 boolean ban)
                  throws SQLException

Throws:

SQLException

setUserSteamID

public String setUserSteamID(String user,
 String steamID)

setPassword

public void setPassword(String username,
 String encryptedPwd)
                 throws SQLException

Throws:

SQLException

getUserGoogleKey

public String getUserGoogleKey(String username)
                        throws SQLException

Throws:

SQLException

setUserGoogleKey

public boolean setUserGoogleKey(String username,
 String key)
                         throws SQLException

Throws:

SQLException

resetUserGoogleKey

public void resetUserGoogleKey(String username)
                        throws SQLException

Throws:

SQLException

updateLastConnectionDate

public void updateLastConnectionDate(String u,
 String p)

addWarningPoint

public String addWarningPoint(String username,
 String reason,
 int amount,
 String issuedBy)
                       throws SQLException

Throws:

SQLException

addTicket

public void addTicket(String author,
 String message,
 int ticketID)
               throws SQLException

Throws:

SQLException

viewedTicket

public void viewedTicket(int ticketID,
 boolean viewed)
                  throws SQLException

Throws:

SQLException

getBannedIPs

public ArrayList<DBBannedIP> getBannedIPs()
                                   throws SQLException

Throws:

SQLException

getBannedSteamIDs

public ArrayList<DBBannedSteamID> getBannedSteamIDs()
                                             throws SQLException

Throws:

SQLException

getTickets

public ArrayList<DBTicket> getTickets(String playerName)
                               throws SQLException

Throws:

SQLException

removeTicket

public void removeTicket(int ticketID)
                  throws SQLException

Throws:

SQLException