atavism.agis.database
Class AccountDatabase

java.lang.Object
  atavism.agis.database.AccountDatabase

public class AccountDatabase
extends java.lang.Object

Field Summary

protected static AdminQueries

queries

Constructor Summary

AccountDatabase(boolean keepAlive)

Method Summary

void	addFriend(OID characterOID, OID friendOID, java.lang.String friendName) Creates a new database entry listing a player as another players friend.
boolean	addItem(OID accountOID, int itemID, int amount) Adds the specified item to the account.
boolean	addNewMail(Mail iMailToSend) Inserts a new entry into the character_mail table.
boolean	addSkin(OID accountOID, java.lang.String skin) Adds the specified skin to the account.
void	alterItemAmount(OID accountID, int itemID, int delta)
boolean	characterCreated(OID accountID, java.lang.String accountName, OID characterOID, java.lang.String characterName) Adds a newly created character to an account entry.
boolean	characterDeleted(OID accountID, OID characterOID, java.lang.String characterName) Removes a deleted character from an account entry.
boolean	characterLoggedIn(OID accountID)
boolean	characterLoggedOut(OID accountID)
void	close() Having too many connection errors, so adding this function to help cope with it
int	createAccount(OID accountID, java.lang.String accountName, OID characterOID, java.lang.String characterName) Creates a new account entry
int	deleteClaim(int claimID)
void	deleteClaimAction(int spawnID)
void	deleteClaimObject(int objectID)
void	deleteClaimPermission(int claimID, OID playerOid)
int	deleteGuild(int guildID)
void	deleteGuildMember(int memberID)
void	deleteGuildRank(int rankID)
boolean	deleteMail(int mailOID) Set the mail to deleted (archived) using mailOID
void	DelFriend(OID characterOID, OID friendOID) Delete database entry listing a player as another players friend.
void	editPortalData(java.lang.String portalName, java.util.HashMap<java.lang.String,java.lang.Float> portalProps)
int	getAccountStatus(OID accountID)
java.util.LinkedList<Cooldown>	getCooldowns(OID characterOID)
java.util.HashMap<OID,java.lang.String>	getFriends(OID characterOID) Gets the list of friends a player has so it can be shown to them in their UI
java.util.LinkedList<OID>	getFriendsOf(OID characterOID) Gets the list of players to notify when this person logs in or logs out.
int	GetGuildId(OID playerOid)
OID	getIslandAdministrator(int islandID)
java.util.ArrayList<java.lang.String>	getIslandName(java.lang.String islandName)
java.util.HashMap<java.lang.Integer,java.lang.Integer>	getItems(OID accountOID) Gets the items that the passed in account has access to.
int	getNumCharacterSlots(OID accountID) Gets the number of character slots this account has.
int	getNumIslands(OID accountID)
OID	getOIDFromLongInResultSet(java.sql.ResultSet rs, java.lang.String wColoumnLabel)
void	loadClaimActions(Claim claim)
void	loadClaimObjects(Claim claim)
void	loadClaimPermissions(Claim claim)
void	loadClaimResources(Claim claim)
java.util.HashMap<java.lang.Integer,Claim>	loadClaims(int instanceID)
java.util.HashMap<java.lang.Integer,Claim>	loadClaims(int instanceID, long playerOid, long guildOid)
java.util.HashMap<java.lang.Integer,Guild>	loadGuildData()
void	loadGuildMembers(java.util.HashMap<java.lang.Integer,Guild> guilds)
void	loadGuildRanks(java.util.HashMap<java.lang.Integer,Guild> guilds)
java.util.HashMap<java.lang.Integer,InstanceTemplate>	loadInstanceTemplateData() Instance Template related database queries
java.util.LinkedList<java.lang.String>	loadIslandContentPacks(int islandID)
java.util.LinkedList<OID>	loadIslandDevelopers(int islandID)
java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Float>>	loadIslandPortals(int islandID)
java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Float>>	loadIslandTemplatePortals(int templateID)
java.util.LinkedList<java.util.HashMap<java.lang.String,java.io.Serializable>>	loadTemplateIslands() Island Template Database Code
java.util.HashMap<java.lang.String,java.lang.Integer>	LoadWorldTime() Load World Time
boolean	readMail(int mailOID) Set mail status to read using mailOID
boolean	removeItem(OID accountOID, int itemID) Removes the specified items from the account.
java.util.ArrayList<Mail>	retrieveMail(OID characterOID, OID accountID) Read in all Mail Item for a given CharacterOID
Mail	retrieveSingleMail(int mailOID) Retrieve mail form DB using mailOID
boolean	returnMail(int mailID, OID senderOid, java.lang.String senderName, OID recipientOid, java.lang.String recipientName, java.lang.String subject, boolean removeCurrency) Returns the mail back to the sender
void	saveCooldowns(OID characterOID, java.util.LinkedList<Cooldown> cooldownList)
void	saveWorldTime(java.lang.Integer year, java.lang.Integer month, java.lang.Integer day, java.lang.Integer hour, java.lang.Integer minute, java.lang.Integer second)
boolean	takeMailCurrency(int mailOID) Set mail attachment to taken using mailOID and the item position
boolean	takeMailItem(int mailOID, int itemPos, boolean CoD) Set mail attachment to taken using mailOID and the item position
int	updateClaim(Claim claim)
int	updateClaimObjectPosition(int id, AOVector loc, Quaternion orient, int parent)
int	updateClaimObjectState(int id, int templateID, int stage, boolean complete, java.lang.String state, java.lang.String gameObject, int health, int maxHealth, java.util.HashMap<java.lang.Integer,java.lang.Integer> itemCounts)
int	updateClaimPermission(int claimID, OID playerOid, int permissionLevel)
int	updateClaimResource(int id, int itemID, int count)
int	updateGuild(Guild guild)
int	updateGuildMember(int id, java.lang.String name, int rank, int level, java.lang.String note)
int	updateGuildRank(int id, int rank, java.lang.String name, java.util.ArrayList<java.lang.String> permissions)
void	updateServerStat(java.lang.String event) Server stats
int	writeClaim(Claim claim, int instanceID, long playerOid, long guildOid)
int	writeClaimAction(int claimID, java.lang.String action, java.lang.String brushType, AOVector size, AOVector loc, AOVector normal, int material)
int	writeClaimObject(int claimID, int templateId, int stage, boolean complete, int parent, java.lang.String gameObject, AOVector loc, Quaternion orient, int itemID, java.lang.String state, int health, int maxHealth, java.util.HashMap<java.lang.Integer,java.lang.Integer> itemCounts, int lockTemplateId)
int	writeClaimPermission(int claimID, OID playerOid, java.lang.String playerName, int permissionLevel)
int	writeClaimResource(int claimID, int itemID, int count)
void	writeIslandData(InstanceTemplate island, java.lang.String template)
void	writeNewGuild(Guild guild)
int	writeNewGuildMember(int guildID, OID memberOid, java.lang.String name, int rank, int level, java.lang.String note)
int	writeNewGuildRank(int guildID, int rank, java.lang.String name, java.util.ArrayList<java.lang.String> permissions)
java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Float>>	writePortalData(int islandID, java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Float>> portals)

Methods inherited from class java.lang.Object

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

Field Detail

queries

protected static AdminQueries queries

Constructor Detail

AccountDatabase

public AccountDatabase(boolean keepAlive)

Method Detail

getCooldowns

public java.util.LinkedList<Cooldown> getCooldowns(OID characterOID)

saveCooldowns

public void saveCooldowns(OID characterOID,
                          java.util.LinkedList<Cooldown> cooldownList)

characterCreated

public boolean characterCreated(OID accountID,
                                java.lang.String accountName,
                                OID characterOID,
                                java.lang.String characterName)

Adds a newly created character to an account entry. If there is no account entry, a new one will be made.

Parameters:

accountID -

characterOID -

characterName -

Returns:

createAccount

public int createAccount(OID accountID,
                         java.lang.String accountName,
                         OID characterOID,
                         java.lang.String characterName)

Creates a new account entry

Parameters:

accountID -

characterOID -

characterName -

Returns:

characterDeleted

public boolean characterDeleted(OID accountID,
                                OID characterOID,
                                java.lang.String characterName)

Removes a deleted character from an account entry.

Parameters:

accountID -

characterOID -

characterName -

Returns:

getAccountStatus

public int getAccountStatus(OID accountID)

getNumIslands

public int getNumIslands(OID accountID)

getNumCharacterSlots

public int getNumCharacterSlots(OID accountID)

Gets the number of character slots this account has. It will first check to see if the account has any unclaimed character slot purchases.

Parameters:

accountID -

Returns:

characterLoggedIn

public boolean characterLoggedIn(OID accountID)

characterLoggedOut

public boolean characterLoggedOut(OID accountID)

getFriends

public java.util.HashMap<OID,java.lang.String> getFriends(OID characterOID)

Gets the list of friends a player has so it can be shown to them in their UI

Parameters:

characterOID -

Returns:

getFriendsOf

public java.util.LinkedList<OID> getFriendsOf(OID characterOID)

Gets the list of players to notify when this person logs in or logs out.

Parameters:

characterOID -

Returns:

addFriend

public void addFriend(OID characterOID,
                      OID friendOID,
                      java.lang.String friendName)

Creates a new database entry listing a player as another players friend.

Parameters:

characterOID -

friendOID -

friendName -

DelFriend

public void DelFriend(OID characterOID,
                      OID friendOID)

Delete database entry listing a player as another players friend.

Parameters:

characterOID -

friendOID -

friendName -

addSkin

public boolean addSkin(OID accountOID,
                       java.lang.String skin)

Adds the specified skin to the account. First checks if the account already has the skin.

Parameters:

characterOID -

friendOID -

friendName -

addItem

public boolean addItem(OID accountOID,
                       int itemID,
                       int amount)

Adds the specified item to the account. First checks if the account already has the item.

Parameters:

characterOID -

friendOID -

friendName -

alterItemAmount

public void alterItemAmount(OID accountID,
                            int itemID,
                            int delta)

removeItem

public boolean removeItem(OID accountOID,
                          int itemID)

Removes the specified items from the account.

Parameters:

characterOID -

friendOID -

friendName -

getItems

public java.util.HashMap<java.lang.Integer,java.lang.Integer> getItems(OID accountOID)

Gets the items that the passed in account has access to.

Parameters:

accountOID -

loadInstanceTemplateData

public java.util.HashMap<java.lang.Integer,InstanceTemplate> loadInstanceTemplateData()

Instance Template related database queries

loadIslandContentPacks

public java.util.LinkedList<java.lang.String> loadIslandContentPacks(int islandID)

loadIslandDevelopers

public java.util.LinkedList<OID> loadIslandDevelopers(int islandID)

getIslandName

public java.util.ArrayList<java.lang.String> getIslandName(java.lang.String islandName)

getIslandAdministrator

public OID getIslandAdministrator(int islandID)

loadIslandPortals

public java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Float>> loadIslandPortals(int islandID)

writeIslandData

public void writeIslandData(InstanceTemplate island,
                            java.lang.String template)

writePortalData

public java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Float>> writePortalData(int islandID,
                                                                                                               java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Float>> portals)

editPortalData

public void editPortalData(java.lang.String portalName,
                           java.util.HashMap<java.lang.String,java.lang.Float> portalProps)

LoadWorldTime

public java.util.HashMap<java.lang.String,java.lang.Integer> LoadWorldTime()

Load World Time

saveWorldTime

public void saveWorldTime(java.lang.Integer year,
                          java.lang.Integer month,
                          java.lang.Integer day,
                          java.lang.Integer hour,
                          java.lang.Integer minute,
                          java.lang.Integer second)

loadTemplateIslands

public java.util.LinkedList<java.util.HashMap<java.lang.String,java.io.Serializable>> loadTemplateIslands()

Island Template Database Code

loadIslandTemplatePortals

public java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Float>> loadIslandTemplatePortals(int templateID)

addNewMail

public boolean addNewMail(Mail iMailToSend)

Inserts a new entry into the character_mail table.

Parameters:

iMailToSend - : The email to be saved in the database.

Returns:

true if success

retrieveMail

public java.util.ArrayList<Mail> retrieveMail(OID characterOID,
                                              OID accountID)

Read in all Mail Item for a given CharacterOID

Parameters:

characterOID -

Returns:

retrieveSingleMail

public Mail retrieveSingleMail(int mailOID)

Retrieve mail form DB using mailOID

Parameters:

mailOID -

Returns:

returnMail

public boolean returnMail(int mailID,
                          OID senderOid,
                          java.lang.String senderName,
                          OID recipientOid,
                          java.lang.String recipientName,
                          java.lang.String subject,
                          boolean removeCurrency)

Returns the mail back to the sender

Parameters:

mailOID -

Returns:

deleteMail

public boolean deleteMail(int mailOID)

Set the mail to deleted (archived) using mailOID

Parameters:

mailOID -

Returns:

readMail

public boolean readMail(int mailOID)

Set mail status to read using mailOID

Parameters:

mailOID -

Returns:

takeMailItem

public boolean takeMailItem(int mailOID,
                            int itemPos,
                            boolean CoD)

Set mail attachment to taken using mailOID and the item position

Parameters:

mailOID -

itemPos -

CoD: - if true, CoD is set to false and currencyTaken is set to true

Returns:

takeMailCurrency

public boolean takeMailCurrency(int mailOID)

Set mail attachment to taken using mailOID and the item position

Parameters:

mailOID -

Returns:

loadClaims

public java.util.HashMap<java.lang.Integer,Claim> loadClaims(int instanceID)

loadClaims

public java.util.HashMap<java.lang.Integer,Claim> loadClaims(int instanceID,
                                                             long playerOid,
                                                             long guildOid)

loadClaimActions

public void loadClaimActions(Claim claim)

loadClaimObjects

public void loadClaimObjects(Claim claim)

loadClaimResources

public void loadClaimResources(Claim claim)

loadClaimPermissions

public void loadClaimPermissions(Claim claim)

writeClaim

public int writeClaim(Claim claim,
                      int instanceID,
                      long playerOid,
                      long guildOid)

updateClaim

public int updateClaim(Claim claim)

deleteClaim

public int deleteClaim(int claimID)

writeClaimAction

public int writeClaimAction(int claimID,
                            java.lang.String action,
                            java.lang.String brushType,
                            AOVector size,
                            AOVector loc,
                            AOVector normal,
                            int material)

deleteClaimAction

public void deleteClaimAction(int spawnID)

writeClaimObject

public int writeClaimObject(int claimID,
                            int templateId,
                            int stage,
                            boolean complete,
                            int parent,
                            java.lang.String gameObject,
                            AOVector loc,
                            Quaternion orient,
                            int itemID,
                            java.lang.String state,
                            int health,
                            int maxHealth,
                            java.util.HashMap<java.lang.Integer,java.lang.Integer> itemCounts,
                            int lockTemplateId)

updateClaimObjectPosition

public int updateClaimObjectPosition(int id,
                                     AOVector loc,
                                     Quaternion orient,
                                     int parent)

updateClaimObjectState

public int updateClaimObjectState(int id,
                                  int templateID,
                                  int stage,
                                  boolean complete,
                                  java.lang.String state,
                                  java.lang.String gameObject,
                                  int health,
                                  int maxHealth,
                                  java.util.HashMap<java.lang.Integer,java.lang.Integer> itemCounts)

deleteClaimObject

public void deleteClaimObject(int objectID)

writeClaimResource

public int writeClaimResource(int claimID,
                              int itemID,
                              int count)

updateClaimResource

public int updateClaimResource(int id,
                               int itemID,
                               int count)

writeClaimPermission

public int writeClaimPermission(int claimID,
                                OID playerOid,
                                java.lang.String playerName,
                                int permissionLevel)

updateClaimPermission

public int updateClaimPermission(int claimID,
                                 OID playerOid,
                                 int permissionLevel)

deleteClaimPermission

public void deleteClaimPermission(int claimID,
                                  OID playerOid)

GetGuildId

public int GetGuildId(OID playerOid)

loadGuildData

public java.util.HashMap<java.lang.Integer,Guild> loadGuildData()

loadGuildRanks

public void loadGuildRanks(java.util.HashMap<java.lang.Integer,Guild> guilds)

loadGuildMembers

public void loadGuildMembers(java.util.HashMap<java.lang.Integer,Guild> guilds)

writeNewGuild

public void writeNewGuild(Guild guild)

writeNewGuildRank

public int writeNewGuildRank(int guildID,
                             int rank,
                             java.lang.String name,
                             java.util.ArrayList<java.lang.String> permissions)

writeNewGuildMember

public int writeNewGuildMember(int guildID,
                               OID memberOid,
                               java.lang.String name,
                               int rank,
                               int level,
                               java.lang.String note)

updateGuild

public int updateGuild(Guild guild)

updateGuildRank

public int updateGuildRank(int id,
                           int rank,
                           java.lang.String name,
                           java.util.ArrayList<java.lang.String> permissions)

updateGuildMember

public int updateGuildMember(int id,
                             java.lang.String name,
                             int rank,
                             int level,
                             java.lang.String note)

deleteGuild

public int deleteGuild(int guildID)

deleteGuildRank

public void deleteGuildRank(int rankID)

deleteGuildMember

public void deleteGuildMember(int memberID)

getOIDFromLongInResultSet

public OID getOIDFromLongInResultSet(java.sql.ResultSet rs,
                                     java.lang.String wColoumnLabel)
                              throws java.sql.SQLException

Parameters:

rs -

wColoumnLabel -

Returns:

Throws:

java.sql.SQLException

updateServerStat

public void updateServerStat(java.lang.String event)

Server stats

close

public void close()

Having too many connection errors, so adding this function to help cope with it