DbProcedures.h

Go to the documentation of this file.

#ifndef __SRADATA_DBPROCEDURES_H
#define __SRADATA_DBPROCEDURES_H

#include "stdafx.h"

#include <stdio.h>
#include <stdlib.h>
#include <iostream>
#include <map>
#include <memory>
#include <Stdint.h>

#include <cppconn/driver.h>
#include <cppconn/exception.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>
#include <cppconn/prepared_statement.h>

#include "DbConnectionFactory.h"

INLINE std::string formatString(const char *format, int id)
{
    //get the total size of the format
    int count = _scprintf(format, id);
    char* buff = NULL;
    try
    {
        //allocate a buffer
        buff = new char[count + 1];
        //format the string and put it in there
        _snprintf(buff, count + 1, format, id);
    }
    catch (...)
    {
    }

    if(buff == NULL)
        return std::string();
    else
    {
        std::string ret(buff);
        delete[] buff;
        return ret;
    }
}

namespace SraData
{
class DbProcedures
{
    public:
        static __declspec(dllexport) void clearCharQuality(int pInCharId, int pInQualityId);
        static __declspec(dllexport) void clearCharSpell(int pInCharId, int pInSpellId);
        static __declspec(dllexport) void createCharacter(int pInRaceId, int* pOutId);
        static __declspec(dllexport) void createGearItem(int pInGearId, int pInOwnerCharId, int pInRating, int* pOutGearItemId);
        static __declspec(dllexport) void createPlayer(const std::string& pInLogin, const std::string& pInPassword, int* pOutId);
        static __declspec(dllexport) void createPlayerCharacter(int pInRaceId, int pInPlayerId, int* pOutPcId, int* pOutCharId);
        static __declspec(dllexport) void deleteGearItem(int pInGearItemId);
        static __declspec(dllexport) void getChar(int pInCharId, bool* isMale, int* raceId, int* agility, int* body, int* reaction, int* strength, int* charisma, int* intuition, int* logic, int* willpower, int* edge, int* edgeBurnt, int* magic, int* resonance, int* queryId);
        static __declspec(dllexport) void getCharActiveSkills(int pInCharId, int* activeSkillId, int* rating, int* queryId);
        static __declspec(dllexport) void getCharAdeptPwrs(int pInCharId, int* adeptPowerId, int* rating, int* queryId);
        static __declspec(dllexport) void getCharDmg(int pInCharId, int* stunDmgTaken, int* physicalDmgTaken, int* queryId);
        static __declspec(dllexport) void getCharGear(int pInCharId, int* gearId, int* location, int* rating, int* queryId);
        static __declspec(dllexport) void getCharKnowSkills(int pInCharId, int* knowledgeSkillId, int* rating, int* queryId);
        static __declspec(dllexport) void getCharQualities(int pInCharId, int* qualityId, int* rating, int* queryId);
        static __declspec(dllexport) void getCharSpells(int pInCharId, int* spellId, int* queryId);
        static __declspec(dllexport) void getPcZone(int pInPcId, int* currentZoneId, int* queryId);
        static __declspec(dllexport) void getPlayerCharacters(int pInPlayerId, int* ID, int* queryId);
        static __declspec(dllexport) void setCharActiveSkill(int pInCharId, int pInSkillId, int pInRating);
        static __declspec(dllexport) void setCharAdeptPwr(int pInCharId, int pInPwrId, int pInRating);
        static __declspec(dllexport) void setCharDmg(int pInCharId, int pInStunDmg, int pInPhysDmg);
        static __declspec(dllexport) void setCharKnowSkill(int pInCharId, int pInSkillId, int pInRating);
        static __declspec(dllexport) void setCharMentAttr(int pInCharId, int pInCharisma, int pInIntuition, int pInLogic, int pInWillpower);
        static __declspec(dllexport) void setCharPhysAttr(int pInCharId, int pInAgility, int pInBody, int pInReaction, int pInStrength);
        static __declspec(dllexport) void setCharQuality(int pInCharId, int pInQualityId, int pInRating);
        static __declspec(dllexport) void setCharSpecAttr(int pInCharId, int pInEdge, int pInEdgeBurnt, int pInMagic, int pInResonance);
        static __declspec(dllexport) void setCharSpell(int pInCharId, int pInSpellId);
        static __declspec(dllexport) void setGearItemOwner(int pInGearId, int pInOwnerCharId);
        static __declspec(dllexport) void setPcZone(int pInPcId, int pInZoneId);
        static __declspec(dllexport) void setPlayerNickname(int pInPlayerId, const std::string& pInNickname);
    };
}

#endif