Hey there,
I am having a lot of trouble writing a small piece of code to give players vocation specific skills when they are created through the account manager.
What I have written so far is below, the whole iologindata.cpp can be found here
[cpp]
DBQuery toreturn;
db->executeQuery(query.str());
query.str("");
query << "SELECT 'id' FROM 'players' WHERE 'name' = " << db->escapeString(characterName) << "";
DBResult* result;
if(!(result = db->storeQuery(query.str()))){
return false;
}
uint32_t playerid = result->getDataInt("id");
query.str("");
if(vocationId=4)
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 1";
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 2";
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 3";
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 5";
query << "UPDATE `players` SET `maglevel` = 8 WHERE `id` = " << playerid << "";
if(vocationId=3)
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 4";
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 5";
query << "UPDATE `players` SET `maglevel` = 25 WHERE `id` = " << playerid << "";
if(vocationId=2)
query << "UPDATE `player_skills` SET `value` = 30, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 5";
query << "UPDATE `players` SET `maglevel` = 80 WHERE `id` = " << playerid << "";
if(vocationId=1)
query << "UPDATE `player_skills` SET `value` = 30, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 5";
query << "UPDATE `players` SET `maglevel` = 80 WHERE `id` = " << playerid << "";
return toreturn;
}
[/cpp]
this will compile, but straight up does not work.
sorry for sucking, I am no programmer.
any help towards getting this to work is greatly appreciated!
Thanks,
Michael
I am having a lot of trouble writing a small piece of code to give players vocation specific skills when they are created through the account manager.
What I have written so far is below, the whole iologindata.cpp can be found here
[cpp]
DBQuery toreturn;
db->executeQuery(query.str());
query.str("");
query << "SELECT 'id' FROM 'players' WHERE 'name' = " << db->escapeString(characterName) << "";
DBResult* result;
if(!(result = db->storeQuery(query.str()))){
return false;
}
uint32_t playerid = result->getDataInt("id");
query.str("");
if(vocationId=4)
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 1";
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 2";
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 3";
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 5";
query << "UPDATE `players` SET `maglevel` = 8 WHERE `id` = " << playerid << "";
if(vocationId=3)
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 4";
query << "UPDATE `player_skills` SET `value` = 80, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 5";
query << "UPDATE `players` SET `maglevel` = 25 WHERE `id` = " << playerid << "";
if(vocationId=2)
query << "UPDATE `player_skills` SET `value` = 30, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 5";
query << "UPDATE `players` SET `maglevel` = 80 WHERE `id` = " << playerid << "";
if(vocationId=1)
query << "UPDATE `player_skills` SET `value` = 30, `count` = 0 WHERE `player_id` = " << playerid << " AND `skillid` = 5";
query << "UPDATE `players` SET `maglevel` = 80 WHERE `id` = " << playerid << "";
return toreturn;
}
[/cpp]
this will compile, but straight up does not work.
sorry for sucking, I am no programmer.
any help towards getting this to work is greatly appreciated!
Thanks,
Michael