main.cpp

Go to the documentation of this file.

#include <stdio.h>
#include "DbProcedures.h"
#include "DbStream.h"

using namespace SraData;

int main( int argc, const char* argv[] )
{
    //create a player and setup
    int playerId;
    DbProcedures::createPlayer("erik", "password", &playerId);
    DbProcedures::setPlayerNickname(playerId, "eralston");

    //create a character and setup
    int pcId, charId;
    DbProcedures::createPlayerCharacter(1, playerId, &pcId, &charId);

    //set various aspects of the character
    DbProcedures::setCharKnowSkill(charId,3,3);
    DbProcedures::setCharAdeptPwr(charId,2,3);
    DbProcedures::setCharSpell(charId, 10);
    DbProcedures::setCharQuality(charId, 6,0);
    DbProcedures::setCharMentAttr(charId,3,3,3,3);
    DbProcedures::setCharPhysAttr(charId,3,3,3,3);
    DbProcedures::setCharSpecAttr(charId,2,0,6,0);

    //set active skills
    DbProcedures::setCharActiveSkill(charId,3,4);
    DbProcedures::setCharActiveSkill(charId,4,5);
    DbProcedures::setCharActiveSkill(charId,5,6);

    //get to character active skills
    int skillId, rating, queryId;
    queryId = DbStream::InitStreamId;
    do
    {
        DbProcedures::getCharActiveSkills(charId, &skillId, &rating, &queryId);
    }
    while(queryId != DbStream::InitStreamId);

    //set damage and pull it back out
    DbProcedures::setCharDmg(charId, 4, 5);
    int physDmg, stunDmg;
    DbProcedures::getCharDmg(charId, &stunDmg, &physDmg, &queryId);

    //set know skills
    DbProcedures::setCharKnowSkill(charId,1,2);
    DbProcedures::setCharKnowSkill(charId,2,4);
    DbProcedures::setCharKnowSkill(charId,3,6);

    //get to character know skills
    queryId = DbStream::InitStreamId;
    do
    {
        DbProcedures::getCharKnowSkills(charId, &skillId, &rating, &queryId);
    }
    while(queryId != DbStream::InitStreamId);

    //set adept powers
    DbProcedures::setCharAdeptPwr(charId,1,2);
    DbProcedures::setCharAdeptPwr(charId,2,4);
    DbProcedures::setCharAdeptPwr(charId,3,6);

    int adeptPowerId;

    //get to character know skills
    queryId = DbStream::InitStreamId;
    do
    {
        DbProcedures::getCharAdeptPwrs(charId, &adeptPowerId, &rating, &queryId);
    }
    while(queryId != DbStream::InitStreamId);

    //get a character
    bool isMale;
    int raceId, agility, body, reaction,  strength, 
              charisma,  intuition,  logic,  willpower, 
              edge,  edgeBurnt,  magic,  resonance;
    DbProcedures::getChar(charId, &isMale, &raceId, &agility, &body, &reaction, &strength, &charisma, &intuition, &logic, &willpower, &edge, &edgeBurnt, &magic, &resonance, &queryId);

    //create a piece of gear
    int gearItemId;
    DbProcedures::createGearItem(0,charId, 0, &gearItemId);
    DbProcedures::setGearItemOwner(gearItemId, charId);
    DbProcedures::deleteGearItem(gearItemId);
}