diff options
Diffstat (limited to 'src/query.hh')
| -rw-r--r-- | src/query.hh | 117 |
1 files changed, 76 insertions, 41 deletions
diff --git a/src/query.hh b/src/query.hh index 8bdd527..dbba9dc 100644 --- a/src/query.hh +++ b/src/query.hh @@ -11,6 +11,7 @@ enum : int { }; struct TQueryManagerConnection{ + TQueryManagerConnection(void) : TQueryManagerConnection(KB(16)) {} TQueryManagerConnection(int QueryBufferSize); ~TQueryManagerConnection(void); @@ -39,35 +40,20 @@ struct TQueryManagerConnection{ int executeQuery(int Timeout, bool AutoReconnect); -//== - - int loadWorldConfig(int *WorldType, int *RebootTime, - int *IPAddress, int *Port, - int *MaxPlayers, int *PremiumPlayerBuffer, - int *MaxNewbies, int *PremiumNewbieBuffer); - int loadPlayers(uint32 MinimumCharacterID, int *NumberOfPlayers, - char (*Names)[30], uint32 *CharacterIDs); - - int loginGame(uint32 AccountID, const char *PlayerName, const char *Password, + int checkAccountPassword(uint32 AccountID, const char *Password, const char *IPAddress); + int loginAdmin(uint32 AccountID, bool PrivateWorld, int *NumberOfCharacters, + char (*Characters)[30], char (*Worlds)[30], uint8 (*IPAddresses)[4], + uint16 *Ports, uint16 *PremiumDaysLeft); + int loadWorldConfig(int *WorldType, int *RebootTime, int *IPAddress, + int *Port, int *MaxPlayers, int *PremiumPlayerBuffer, int *MaxNewbies, + int *PremiumNewbieBuffer); + int loginGame(uint32 AccountID, char *PlayerName, const char *Password, const char *IPAddress, bool PrivateWorld, bool PremiumAccountRequired, bool GamemasterRequired, uint32 *CharacterID, int *Sex, char *Guild, char *Rank, char *Title, int *NumberOfBuddies, uint32 *BuddyIDs, char (*BuddyNames)[30], uint8 *Rights, bool *PremiumAccountActivated); int logoutGame(uint32 CharacterID, int Level, const char *Profession, const char *Residence, time_t LastLoginTime, int TutorActivities); - int createPlayerlist(int NumberOfPlayers, const char **Names, int *Levels, - const char (*Professions)[30], bool *NewRecord); - int decrementIsOnline(uint32 CharacterID); - int clearIsOnline(int *NumberOfAffectedPlayers); - int addBuddy(uint32 AccountID, uint32 BuddyID); - int removeBuddy(uint32 AccountID, uint32 BuddyID); - - int logKilledCreatures(int NumberOfRaces, const char **Names, - int *KilledPlayers,int *KilledCreatures); - - int logCharacterDeath(uint32 CharacterID, int Level, uint32 OffenderID, - const char *Remark, bool Unjustified, time_t Time); - int setNotation(uint32 GamemasterID, const char *PlayerName, const char *IPAddress, const char *Reason, const char *Comment, uint32 *BanishmentID); int setNamelock(uint32 GamemasterID, const char *PlayerName, const char *IPAddress, @@ -76,35 +62,82 @@ struct TQueryManagerConnection{ const char *Reason, const char *Comment, bool *FinalWarning, int *Days, uint32 *BanishmentID); int reportStatement(uint32 ReporterID, const char *PlayerName, const char *Reason, - const char *Comment, uint32 BanishmentID, uint32 StatementID, int NumberOfStatements, - uint32 *StatementIDs, int *TimeStamps, uint32 *CharacterIDs, char (*Channels)[30], - char (*Texts)[256]); + const char *Comment, uint32 BanishmentID, uint32 StatementID, + int NumberOfStatements, uint32 *StatementIDs, int *TimeStamps, + uint32 *CharacterIDs, const char (*Channels)[30], const char (*Texts)[256]); int banishIPAddress(uint32 GamemasterID, const char *PlayerName, const char *IPAddress, const char *Reason, const char *Comment); - - int insertHouses(int NumberOfHouses, uint16 *HouseIDs, char **Names, - int *Rents, char **Descriptions, int *Sizes, int *PositionsX, - int *PositionsY, int *PositionsZ, char (*Towns)[30], bool *Guildhouses); - + int logCharacterDeath(uint32 CharacterID, int Level, uint32 Offender, + const char *Remark, bool Unjustified, time_t Time); + int addBuddy(uint32 AccountID, uint32 Buddy); + int removeBuddy(uint32 AccountID, uint32 Buddy); + int decrementIsOnline(uint32 CharacterID); int finishAuctions(int *NumberOfAuctions, uint16 *HouseIDs, uint32 *CharacterIDs, char (*CharacterNames)[30], int *Bids); - int excludeFromAuctions(uint32 CharacterIDs, bool Banish); - + int excludeFromAuctions(uint32 CharacterID, bool Banish); int transferHouses(int *NumberOfTransfers, uint16 *HouseIDs, - uint32 *NewOwnerIDs, char (*NewOwnerNames) [30], int *Prices); + uint32 *NewOwnerIDs, char (*NewOwnerNames)[30], int *Prices); int cancelHouseTransfer(uint16 HouseID); int evictFreeAccounts(int *NumberOfEvictions, uint16 *HouseIDs, uint32 *OwnerIDs); int evictDeletedCharacters(int *NumberOfEvictions, uint16 *HouseIDs); - int evictExGuildleaders(int NumberOfGuildhouses, int *NumberOfEvictions, - uint16 *HouseIDs, uint32 *Guildleaders); + int evictExGuildleaders(int NumberOfGuildhouses, + int *NumberOfEvictions, uint16 *HouseIDs, uint32 *Guildleaders); + int insertHouseOwner(uint16 HouseID, uint32 OwnerID, int PaidUntil); + int updateHouseOwner(uint16 HouseID, uint32 OwnerID, int PaidUntil); int deleteHouseOwner(uint16 HouseID); - + int getHouseOwners(int *NumberOfOwners, uint16 *HouseIDs, + uint32 *OwnerIDs, char (*OwnerNames)[30], int *PaidUntils); int getAuctions(int *NumberOfAuctions, uint16 *HouseIDs); int startAuction(uint16 HouseID); - int getHouseOwners(int *NumberOfHouses, uint16 *HouseIDs, - uint32 *OwnerIDs, char (*OwnerNames)[30], int *PaidUntils); - int insertHouseOwner(uint16 HouseID, uint32 OwnerID, int PaidUntil); - int updateHouseOwner(uint16 HouseID, uint32 OwnerID, int PaidUntil); + int insertHouses(int NumberOfHouses, uint16 *HouseIDs, + const char **Names, int *Rents, const char **Descriptions, + int *Sizes, int *PositionsX,int *PositionsY,int *PositionsZ, + char (*Towns)[30], bool *Guildhouses); + int clearIsOnline(int *NumberOfAffectedPlayers); + int createPlayerlist(int NumberOfPlayers, const char **Names, + int *Levels, const char (*Professions)[30], bool *NewRecord); + int logKilledCreatures(int NumberOfRaces, const char **Names, + int *KilledPlayers,int *KilledCreatures); + int loadPlayers(uint32 MinimumCharacterID, int *NumberOfPlayers, + char (*Names)[30], uint32 *CharacterIDs); + int getKeptCharacters(uint32 MinimumCharacterID, + int *NumberOfPlayers, uint32 *CharacterIDs); + int getDeletedCharacters(uint32 MinimumCharacterID, + int *NumberOfPlayers, uint32 *CharacterIDs); + int deleteOldCharacter(uint32 CharacterID); + int getHiddenCharacters(uint32 MinimumCharacterID, + int *NumberOfPlayers, uint32 *CharacterIDs); + int createHighscores(int NumberOfPlayers, uint32 *CharacterIDs, + int *ExpPoints, int *ExpLevel, int *Fist, int *Club, int *Axe, + int *Sword, int *Distance, int *Shielding, int *Magic, int *Fishing); + int createCensus(void); + int createKillStatistics(void); + int getPlayersOnline(int *NumberOfWorlds, char (*Names)[30], uint16 *Players); + int getWorlds(int *NumberOfWorlds, char (*Names)[30]); + int getServerLoad(const char *World, int Period, int *Data); + + int insertPaymentDataOld(uint32 PurchaseNr, uint32 ReferenceNr, + const char *FirstName, const char *LastName, const char *Company, + const char *Street, const char *Zip, const char *City, const char *Country, + const char *State, const char *Phone, const char *Fax, const char *EMail, + const char *PaymentMethod, uint32 ProductID, const char *Registrant, + uint32 AccountID, uint32 *PaymentID); + int addPaymentOld(uint32 AccountID, const char *Description, + uint32 PaymentID, int Days, int *ActionTaken); + int cancelPaymentOld(uint32 PurchaseNr, uint32 ReferenceNr, + uint32 AccountID, bool *IllegalUse, char *EMailAddress); + + int insertPaymentDataNew(uint32 PurchaseNr, uint32 ReferenceNr, + const char *FirstName, const char *LastName, const char *Company, + const char *Street, const char *Zip, const char *City, const char *Country, + const char *State, const char *Phone, const char *Fax, const char *EMail, + const char *PaymentMethod, uint32 ProductID, const char *Registrant, + const char *PaymentKey, uint32 *PaymentID); + int addPaymentNew(const char *PaymentKey, uint32 PaymentID, + int *ActionTaken, char *EMailReceiver); + int cancelPaymentNew(uint32 PurchaseNr, uint32 ReferenceNr, + const char *PaymentKey, bool *IllegalUse, bool *Present, + char *EMailAddress); // DATA // ================= @@ -120,6 +153,8 @@ struct TQueryManagerConnectionPool{ TQueryManagerConnectionPool(int Connections); void init(void); void exit(void); + TQueryManagerConnection *getConnection(void); + void releaseConnection(TQueryManagerConnection *Connection); // DATA // ================= |