Class ServerWorldDatabase

java.lang.Object

zombie.network.ServerWorldDatabase

public class ServerWorldDatabase
extends Object

Created by LEMMYPC on 14/01/14.

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
DBSchema	dbSchema
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 string0, String string1, int int0)
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 string0, String string2, String string1, long long0, int int0)
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 string1, String string0)
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 string0, String string1)
void	create()
static String	encrypt(String previousPwd)
void	executeQuery(String string, se.krka.kahlua.vm.KahluaTable kahluaTable)
ArrayList<DBBannedIP>	getBannedIPs()
DBSchema	getDBSchema()
String	getDisplayName(String username)
String	getFirstBannedIPForUser(String string0)
ArrayList<DBResult>	getTableResult(String table)
ArrayList<DBTicket>	getTickets(String playerName)
String	getTOTPCode(String string0)
String	getUserGoogleKey(String string1)
ArrayList<Userlog>	getUserlog(String username)
void	getUserlogUsers(HashMap<String,NetworkUser> hashMap)
String	getUserRoleNameByIp(String string1)
String	getUserRoleNameByUsername(String string1)
void	getWhitelistUsers(HashMap<String,NetworkUser> hashMap)
ServerWorldDatabase.LogonResult	googleAuthClient(String string0, String string1)
String	grantAdmin(String username, boolean setAdmin)
String	isSteamIdBanned(String string0)
static boolean	isValidUserName(String user)
void	removeTicket(int ticketID)
String	removeUser(String username)
String	removeUser(String string1, String string0)
void	removeUserLog(String username, String type, String text)
void	resetUserGoogleKey(String string)
void	setPassword(String username, String password)
String	setRole(String string, Role role)
void	setUserGoogleKey(String string1, String string0)
String	setUserLastIP(String string0, String string1)
String	setUserSteamID(String user, String steamID)
void	updateDisplayName(String user, String displayName)
void	updateLastConnectionDate(String u, String p)
void	updateUserCounters(Collection<NetworkUser> collection)

Methods inherited from class java.lang.Object

clone, equals, finalize, 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

dbSchema

public DBSchema dbSchema

Constructor Details

ServerWorldDatabase

public ServerWorldDatabase()

Method Details

getDBSchema

public DBSchema getDBSchema()

executeQuery

public void executeQuery(String string,
 se.krka.kahlua.vm.KahluaTable kahluaTable)
                  throws SQLException

Throws:

SQLException

getTableResult

public ArrayList<DBResult> getTableResult(String table)
                                   throws SQLException

Throws:

SQLException

getWhitelistUsers

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

getUserlogUsers

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

updateUserCounters

public void updateUserCounters(Collection<NetworkUser> collection)

containsUser

public boolean containsUser(String string0,
 String string1)

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 string0)

addUser

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

Throws:

SQLException

addUser

public String addUser(String string0,
 String string1,
 int int0)
               throws SQLException

Throws:

SQLException

updateDisplayName

public void updateDisplayName(String user,
 String displayName)

getDisplayName

public String getDisplayName(String username)

removeUser

public String removeUser(String string1,
 String string0)
                  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)

googleAuthClient

public ServerWorldDatabase.LogonResult googleAuthClient(String string0,
 String string1)

authClient

public ServerWorldDatabase.LogonResult authClient(String string0,
 String string2,
 String string1,
 long long0,
 int int0)

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 string1,
 String string0)
                      throws SQLException

Throws:

SQLException

changePwd

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

Throws:

SQLException

grantAdmin

public String grantAdmin(String username,
 boolean setAdmin)
                  throws SQLException

Throws:

SQLException

setRole

public String setRole(String string,
 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 String getUserRoleNameByUsername(String string1)

getUserRoleNameByIp

public String getUserRoleNameByIp(String string1)
                           throws SQLException

Throws:

SQLException

banUser

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

Throws:

SQLException

getFirstBannedIPForUser

public String getFirstBannedIPForUser(String string0)

banIp

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

Throws:

SQLException

isSteamIdBanned

public String isSteamIdBanned(String string0)

banSteamID

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

Throws:

SQLException

setUserLastIP

public String setUserLastIP(String string0,
 String string1)

setUserSteamID

public String setUserSteamID(String user,
 String steamID)

setPassword

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

Throws:

SQLException

getUserGoogleKey

public String getUserGoogleKey(String string1)
                        throws SQLException

Throws:

SQLException

setUserGoogleKey

public void setUserGoogleKey(String string1,
 String string0)
                      throws SQLException

Throws:

SQLException

resetUserGoogleKey

public void resetUserGoogleKey(String string)
                        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

getBannedIPs

public ArrayList<DBBannedIP> getBannedIPs()
                                   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