Uses of Class
marauroa.server.db.DBTransaction

Packages that use DBTransaction

Package	Description
games.stendhal.server.core.engine.db
games.stendhal.server.core.engine.dbcommand
games.stendhal.tools.modifer
marauroa.server.db	This package contains low level database stuff.
marauroa.server.db.command	This package contains infrastructure for asynchronous database access.
marauroa.server.game.container	This package contains the classes that store information about players connected to server.
marauroa.server.game.db	high level database access.
marauroa.server.game.dbcommand

Uses of DBTransaction in games.stendhal.server.core.engine.db

Methods in games.stendhal.server.core.engine.db with parameters of type DBTransaction

Modifier and Type	Method	Description
void	StendhalCharacterDAO.addCharacter(DBTransaction transaction, String username, String character, RPObject player, Timestamp timestamp)
void	StendhalWebsiteDAO.clearOnlineStatus(DBTransaction transaction)	clears the online status of all players (used on server startup)
void	PendingAchievementDAO.deletePendingAchievementDetails(DBTransaction transaction, String charname)	Delete used records for a pending achievement for a given player
void	StendhalNPCDAO.dumpNPCs(DBTransaction transaction)	dumps all NPCs
void	StendhalRPZoneDAO.dumpZones(DBTransaction transaction)	dumps all zones
List<String>	StendhalHallOfFameDAO.getCharactersByFametype(DBTransaction transaction, String fametype, int max, boolean ascending)	gets the characters who have taken part in the specified fametype
List<ChatMessage>	PostmanDAO.getChatMessages(DBTransaction transaction, String charname)	gets a list of ChatMessages for this character
int	StendhalHallOfFameDAO.getHallOfFamePoints(DBTransaction transaction, String charname, String fametype)	Returns the points in the specified hall of fame.
Map<String,Map<String,Integer>>	PendingAchievementDAO.getPendingAchievementDetails(DBTransaction transaction, String charname)	Get details on pending achievements for a given player
int	AchievementDAO.insertAchievement(DBTransaction transaction, Achievement achievement)	Saves the base data of an achievement
protected void	StendhalWebsiteDAO.insertIntoCharStats(DBTransaction transaction, Player player, Timestamp timestamp)	Insert statistics information about a new player
boolean	StendhalBuddyDAO.isIgnored(DBTransaction transaction, String character, String candidate)	checks whether a palyer is ignored by another player
void	StendhalItemDAO.itemLogAssignIDIfNotPresent(DBTransaction transaction, RPObject item, Timestamp timestamp)	Assigns the next logid to the specified item in case it does not already have one.
void	StendhalItemDAO.itemLogWriteEntry(DBTransaction transaction, Timestamp timestamp, int itemid, RPEntity player, String event, String param1, String param2, String param3, String param4)	writes a log entry
void	StendhalItemDAO.itemLogWriteEntry(DBTransaction transaction, Timestamp timestamp, RPObject item, RPEntity player, String event, String param1, String param2, String param3, String param4)	writes a log entry
Map<String,Integer>	StendhalGroupQuestDAO.load(DBTransaction transaction, String questname)	reads a group quest
Set<String>	AchievementDAO.loadAllReachedAchievementsOfPlayer(DBTransaction transaction, String playerName)	Loads all achievements a player has reached
Map<String,Integer>	AchievementDAO.loadIdentifierIdPairs(DBTransaction transaction)	Loads a map from achievement identifier to database serial
com.google.common.collect.Multimap<String,String>	StendhalBuddyDAO.loadRelations(DBTransaction transaction, String charname)	loads the relationship lists for the specified charname
void	StendhalKillLogDAO.logKill(DBTransaction transaction, Entity killed, Killer killer, Timestamp timestamp)	Logs a kill.
void	StendhalWebsiteDAO.logTradeEvent(DBTransaction transaction, String charname, String itemname, int itemid, int quantity, int price, String stats, Timestamp timestamp)	logs a trade event
void	PostmanDAO.markMessagesDelivered(DBTransaction transaction, String charname)	marks messages delivered for this character
void	AchievementDAO.saveReachedAchievement(DBTransaction transaction, Integer achievementId, String playerName, boolean incReachedCount, Timestamp timestamp)	logs a reached achievement into the database
void	StendhalBuddyDAO.saveRelations(DBTransaction transaction, String charname, Player player)	saves the buddy list for the specified charname
void	StendhalHallOfFameDAO.setHallOfFamePoints(DBTransaction transaction, String charname, String fametype, int points)	Stores an entry in the hall of fame.
void	StendhalWebsiteDAO.setOnlineStatus(DBTransaction transaction, String playerName, boolean online)	sets the online status of a particular player
void	StendhalCharacterDAO.storeCharacter(DBTransaction transaction, String username, String character, RPObject player, Timestamp timestamp)
void	PostmanDAO.storeMessage(DBTransaction transaction, String source, String target, String message, String messagetype, Timestamp timestamp)	store a message from any named source We do not specify it must be a player because NPCs use postman to send messages
void	StendhalGroupQuestDAO.update(DBTransaction transaction, String questname, String charname, String itemname, Integer quantity, Timestamp timestamp)	logs group quest progress
void	AchievementDAO.updateAchievement(DBTransaction transaction, Integer id, Achievement achievement)	Updates the achievement with the given id
protected int	StendhalWebsiteDAO.updateCharStats(DBTransaction transaction, Player player, Timestamp timestamp)	updates the statistics information about a player
void	StendhalSearchIndexDAO.updateSearchIndex(DBTransaction transaction, Set<SearchIndexEntry> entries)	dumps the search index

Constructors in games.stendhal.server.core.engine.db with parameters of type DBTransaction

Modifier	Constructor	Description
	CharacterIterator(DBTransaction transaction, boolean transform)	creates a character iterator

Uses of DBTransaction in games.stendhal.server.core.engine.dbcommand

Methods in games.stendhal.server.core.engine.dbcommand with parameters of type DBTransaction

Modifier and Type	Method	Description
void	AbstractLogItemEventCommand.execute(DBTransaction transaction)
void	DeletePendingAchievementDetailsCommand.execute(DBTransaction transaction)
void	DumpSpeakerNPCsCommand.execute(DBTransaction transaction)
void	DumpZonesCommand.execute(DBTransaction transaction)
void	GetCharacterCreationDateCommand.execute(DBTransaction transaction)
void	GetPostmanMessagesCommand.execute(DBTransaction transaction)
void	LogKillEventCommand.execute(DBTransaction transaction)
void	LogTradeEventCommand.execute(DBTransaction transaction)
void	QueryCanonicalCharacterNamesCommand.execute(DBTransaction transaction)
void	ReadAchievementsForPlayerCommand.execute(DBTransaction transaction)
void	ReadCharactersFromHallOfFameCommand.execute(DBTransaction transaction)
void	ReadGroupQuestCommand.execute(DBTransaction transaction)
void	ReadHallOfFamePointsCommand.execute(DBTransaction transaction)
void	ReadPendingAchievementDetailsCommand.execute(DBTransaction transaction)
void	SetOnlineStatusCommand.execute(DBTransaction transaction)
void	StoreMessageCommand.execute(DBTransaction transaction)
void	UpdateGroupQuestCommand.execute(DBTransaction transaction)
void	UpdateSearchIndexCommand.execute(DBTransaction transaction)
void	WriteHallOfFamePointsCommand.execute(DBTransaction transaction)
void	WriteReachedAchievementCommand.execute(DBTransaction transaction)
protected abstract void	AbstractLogItemEventCommand.log(DBTransaction transaction)	logs the event to the database.
protected void	LogMergeItemEventCommand.log(DBTransaction transaction)
protected void	LogSimpleItemEventCommand.log(DBTransaction transaction)
protected void	LogSplitItemEventCommand.log(DBTransaction transaction)

Uses of DBTransaction in games.stendhal.tools.modifer

Methods in games.stendhal.tools.modifer with parameters of type DBTransaction

Modifier and Type	Method	Description
Player	PlayerModifier.loadPlayer(DBTransaction transaction, String characterName)
boolean	PlayerModifier.savePlayer(DBTransaction transaction, Player player)

Uses of DBTransaction in marauroa.server.db

Methods in marauroa.server.db that return DBTransaction

Modifier and Type	Method	Description
DBTransaction	TransactionPool.beginWork()	starts a transaction and marks it as reserved
DBTransaction	MaintenanceDBFactory.create(Properties conf)	creates a DBTransaction for the specified database connection

Methods in marauroa.server.db with parameters of type DBTransaction

Modifier and Type	Method	Description
void	TransactionPool.commit(DBTransaction dbtransaction)	commits this transaction and frees its reservation
void	TransactionPool.killTransaction(DBTransaction dbtransaction)	kills a transaction by rolling it back and closing it; it will be removed from the pool
void	TransactionPool.rollback(DBTransaction dbtransaction)	rolls this transaction back and frees the reservation
void	UpdateScript.update(DBTransaction transaction)	updates the structure of the database

Constructors in marauroa.server.db with parameters of type DBTransaction

Modifier	Constructor	Description
	JDBCSQLHelper(DBTransaction transaction)	creates a new JDBCSQLHelper

Uses of DBTransaction in marauroa.server.db.command

Methods in marauroa.server.db.command with parameters of type DBTransaction

Modifier and Type	Method	Description
abstract void	AbstractDBCommand.execute(DBTransaction transaction)	processes the database request.
void	DBCommand.execute(DBTransaction transaction)	processes the database request.

Uses of DBTransaction in marauroa.server.game.container

Methods in marauroa.server.game.container with parameters of type DBTransaction

Modifier and Type	Method	Description
void	SecuredLoginInfo.addLoginEvent(DBTransaction transaction, InetAddress address, int result, Timestamp timestamp)	Add a login event to database each time player login, even if it fails.
String	SecuredLoginInfo.getStatus(DBTransaction transaction)	Returns a string indicating the status of the account.
boolean	SecuredLoginInfo.isBlocked(DBTransaction transaction)	Returns true if an account is temporarily blocked due to too many tries in the defined time frame.

Uses of DBTransaction in marauroa.server.game.db

Methods in marauroa.server.game.db with parameters of type DBTransaction

Modifier and Type	Method	Description
boolean	AccountLinkDAO.addAccountLink(DBTransaction transaction, int accountId, String tokenType, String externalUsername, String externalNickname, String externalEmail, String secret)	adds an accountLink.
void	AccountDAO.addBan(DBTransaction transaction, String username, String reason, Timestamp expire)	adds a ban (which may be temporary)
void	CharacterDAO.addCharacter(DBTransaction transaction, String username, String character, RPObject player)	Deprecated.
void	CharacterDAO.addCharacter(DBTransaction transaction, String username, String character, RPObject player, Timestamp timestamp)	creates a new character
void	GameEventDAO.addGameEvent(DBTransaction transaction, String source, String event, String... params)	Deprecated.
void	GameEventDAO.addGameEvent(DBTransaction transaction, Timestamp timestamp, String source, String event, String... params)	adds an game event to the log
void	GameEventDAO.addGameEvents(DBTransaction transaction, List<GameEvent> gameEvents)	adds an list of game event to the log
void	LoginEventDAO.addLoginEvent(DBTransaction transaction, String username, InetAddress source, String service, String seed, int result)	Deprecated.
void	LoginEventDAO.addLoginEvent(DBTransaction transaction, String username, InetAddress source, String service, String seed, int result, Timestamp timestamp)	logs an login attempt
void	AccountDAO.addPlayer(DBTransaction transaction, String username, byte[] passwordHash, String email)	Deprecated.
void	AccountDAO.addPlayer(DBTransaction transaction, String username, byte[] passwordHash, String email, Timestamp timestamp)	creates an account
void	StatisticsDAO.addStatisticsEvent(DBTransaction transaction, Statistics.Variables var)	Deprecated.
void	StatisticsDAO.addStatisticsEvent(DBTransaction transaction, Statistics.Variables var, Timestamp timestamp)	adds an statistics sample to the database log
void	AccountDAO.changeEmail(DBTransaction transaction, String username, String email)	changes the email-address
void	AccountDAO.changePassword(DBTransaction transaction, String username, String password)	changes the password
String	AccountDAO.getAccountBanMessage(DBTransaction transaction, String username)	gets the ban message of the account
int	AccountLinkDAO.getAccountIdByLinkedSecret(DBTransaction transaction, String tokenType, String secret)	gets the id of the account
int	AccountLinkDAO.getAccountIdByLinkedUsername(DBTransaction transaction, String username)	gets the id of the account
String	CharacterDAO.getAccountName(DBTransaction transaction, String character)	gets the name of the account to which the specified character belongs.
String	AccountDAO.getAccountStatus(DBTransaction transaction, String username)	gets the status of the account
List<Pair<String,Long>>	LoginEventDAO.getAmountOfFailedLogins(DBTransaction transaction, long id, int playerId)	gets the amount of failed login attemps
List<InetAddressMask>	BanListDAO.getBannedAddresses(DBTransaction transaction)	gets a list of all banned ip-address ranges
String	CharacterDAO.getCanonicalName(DBTransaction transaction, String character)	gets the canonical spelling of the character name
List<String>	CharacterDAO.getCharacters(DBTransaction transaction, String username)	gets a list of characters for this account
Date	CharacterDAO.getCreationDate(DBTransaction transaction, String character)	Gets the date the character was registered
int	AccountDAO.getDatabasePlayerId(DBTransaction transaction, String username)	gets the id of the account
String	AccountDAO.getEmail(DBTransaction transaction, String username)	gets the email-address of the account
LoginEventDAO.LoginEvent	LoginEventDAO.getLastSuccessfulLoginEvent(DBTransaction transaction, int playerId, String service)	gets the last successful login event
List<String>	LoginEventDAO.getLoginEvents(DBTransaction transaction, String username, int events)	gets a list of recent login events
boolean	CharacterDAO.hasActiveCharacter(DBTransaction transaction, String username, String character)	checks whether the specified account owns the specified character and it is active
boolean	CharacterDAO.hasCharacter(DBTransaction transaction, String character)	checks whether the specified character exists
boolean	CharacterDAO.hasCharacter(DBTransaction transaction, String username, String character)	checks whether the specified account owns the specified character
boolean	AccountDAO.hasPlayer(DBTransaction transaction, String username)	checks if this account exists
boolean	RPObjectDAO.hasRPObject(DBTransaction transaction, int objectid)	does the rpobject with the specified database id exist?
boolean	RPZoneDAO.hasRPZone(DBTransaction transaction, IRPZone.ID zone)	is the specified zone saved to the database
boolean	LoginEventDAO.isAccountBlocked(DBTransaction transaction, String username)	checks if this account is temporary blocked because of too many failed login attempts.
boolean	AccountDAO.isAccountCreationLimitReached(DBTransaction transaction, String address)	is account creation limit reached for recently created accounts
boolean	LoginEventDAO.isAddressBlocked(DBTransaction transaction, String address)	checks if the ip-address is temporary blocked because of too many failed login attempts.
boolean	CharacterDAO.isCharacterCreationLimitReached(DBTransaction transaction, String username, String address)	is the character creation limit reached?
Map<String,RPObject>	CharacterDAO.loadAllActiveCharacters(DBTransaction transaction, String username)	This method loads all active the characters associated with this username from the database.
Map<String,RPObject>	CharacterDAO.loadAllCharacters(DBTransaction transaction, String username)	This method loads all the characters associated with this username from the database.
RPObject	CharacterDAO.loadCharacter(DBTransaction transaction, String username, String character)	This method loads the character's avatar associated with this character from the database.
RPObject	RPObjectDAO.loadRPObject(DBTransaction transaction, int objectid)	loads an RPObject form the database, using the factory to create the correct subclass
RPObject	RPObjectDAO.loadRPObject(DBTransaction transaction, int objectid, boolean transform)	loads an RPObject form the database
void	RPZoneDAO.loadRPZone(DBTransaction transaction, IRPZone zone)	loads storable objects for the specified zone from the database
boolean	CharacterDAO.removeCharacter(DBTransaction transaction, String username, String character)	deletes a character
boolean	AccountDAO.removePlayer(DBTransaction transaction, String username)	deletes an account from the database
int	RPObjectDAO.removeRPObject(DBTransaction transaction, int objectid)	deletes an RPObject from the database
void	AccountDAO.setAccountStatus(DBTransaction transaction, String username, String status)	sets the status of the account
void	CharacterDAO.setCharacterStatus(DBTransaction transaction, String username, String character, String status)	Modifies a character status.
void	CharacterDAO.storeCharacter(DBTransaction transaction, String username, String character, RPObject player)	Deprecated.
void	CharacterDAO.storeCharacter(DBTransaction transaction, String username, String character, RPObject player, Timestamp timestamp)	This method stores a character's avatar in the database and updates the link with the Character table.
int	RPObjectDAO.storeRPObject(DBTransaction transaction, RPObject object)	saves an RPObject to the database
void	RPZoneDAO.storeRPZone(DBTransaction transaction, IRPZone zone)	saves storable objects for the specified zone to the database
void	RPZoneDAO.storeRPZone(DBTransaction transaction, IRPZone zone, Iterable<RPObject> content)	saves storable objects for the specified zone to the database
void	LoginSeedDAO.useSeed(DBTransaction transaction, String seed)	marks a seed as used
boolean	AccountDAO.verify(DBTransaction transaction, SecuredLoginInfo info)	verifies username and password
boolean	AccountDAO.verifyPassword(DBTransaction transaction, String username, String password)	verifies the account username and password
boolean	AccountLinkDAO.verifyPermanentToken(DBTransaction transaction, SecuredLoginInfo info)	verifies that a provided token is a known secret
Boolean	LoginSeedDAO.verifySeed(DBTransaction transaction, String username, String seed)	verifies a login seed

Uses of DBTransaction in marauroa.server.game.dbcommand

Methods in marauroa.server.game.dbcommand with parameters of type DBTransaction

Modifier and Type	Method	Description
protected boolean	LoginCommand.accountStatusCheck(DBTransaction transaction)
protected boolean	LoginCommand.blockCheck(DBTransaction transaction)
protected boolean	LoginCommand.credentialsCheck(DBTransaction transaction)
void	BanAccountCommand.execute(DBTransaction transaction)
void	LoadActiveCharacterCommand.execute(DBTransaction transaction)
void	LoadAllActiveCharactersCommand.execute(DBTransaction transaction)
void	LoadAllCharactersCommand.execute(DBTransaction transaction)
void	LoadBanListCommand.execute(DBTransaction transaction)
void	LoadCharacterCommand.execute(DBTransaction transaction)
void	LogGameEventCommand.execute(DBTransaction transaction)
void	LoginCommand.execute(DBTransaction transaction)
void	LogStatisticsCommand.execute(DBTransaction transaction)
void	SetCharacterStatusCommand.execute(DBTransaction transaction)
void	StoreCharacterCommand.execute(DBTransaction transaction)
void	StoreZoneCommand.execute(DBTransaction transaction)
protected void	LoginCommand.processSuccessfulLogin(DBTransaction transaction)
protected boolean	LoginCommand.verify(DBTransaction transaction)	verifies credentials against the database