Package zombie.network

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
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)
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)
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	changePwd(String username, String previousPwd, String newPwd)
String	changeUsername(String user, String newUsername)
void	close()
boolean	containsCaseinsensitiveUser(String user)
boolean	containsUser(String user)
void	create()
static String	encrypt(String previousPwd)
void	executeQuery(String query, se.krka.kahlua.vm.KahluaTable params)
DBSchema	getDBSchema()
String	getDisplayName(String username)
ArrayList<DBResult>	getTableResult(String table)
ArrayList<DBTicket>	getTickets(String playerName)
ArrayList<Userlog>	getUserlog(String username)
String	grantAdmin(String username, boolean setAdmin)
static boolean	isValidUserName(String user)
void	removeTicket(int ticketID)
String	removeUser(String username)
void	removeUserLog(String username, String type, String text)
void	saveAllTransactionsID(HashMap<String,Integer> map)
void	saveTransactionID(String username, Integer transactionID)
String	setAccessLevel(String username, String accessLevel)
void	setPassword(String username, String password)
String	setUserSteamID(String user, String steamID)
void	updateDisplayName(String user, String displayName)
void	updateLastConnectionDate(String u, String p)

Methods inherited from class java.lang.Object

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

Field Details

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 query,
 se.krka.kahlua.vm.KahluaTable params)
                  throws SQLException

Throws:

SQLException

getTableResult

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

Throws:

SQLException

saveAllTransactionsID

public void saveAllTransactionsID(HashMap<String,Integer> map)

saveTransactionID

public void saveTransactionID(String username,
 Integer transactionID)

containsUser

public boolean containsUser(String user)

containsCaseinsensitiveUser

public boolean containsCaseinsensitiveUser(String user)

changeUsername

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

Throws:

SQLException

addUser

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

Throws:

SQLException

updateDisplayName

public void updateDisplayName(String user,
 String displayName)

getDisplayName

public String getDisplayName(String username)

removeUser

public String removeUser(String username)
                  throws SQLException

Throws:

SQLException

removeUserLog

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

Throws:

SQLException

create

public void create()
            throws SQLException,
ClassNotFoundException

Throws:

SQLException

ClassNotFoundException

close

public void close()

isValidUserName

public static boolean isValidUserName(String user)

authClient

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

authClient

public ServerWorldDatabase.LogonResult authClient(long steamID)

authOwner

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

encrypt

public static String encrypt(String previousPwd)

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

setAccessLevel

public String setAccessLevel(String username,
 String accessLevel)
                      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)

banUser

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

Throws:

SQLException

banIp

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

Throws:

SQLException

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

getTickets

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

Throws:

SQLException

removeTicket

public void removeTicket(int ticketID)
                  throws SQLException

Throws:

SQLException