• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Compiling 0.3.6 iologindata.cpp modification not working

Michael Orsino

Premium User
Staff member
Premium User
Support Team
Joined
Nov 15, 2007
Messages
864
Solutions
10
Reaction score
452
Location
Western Australia
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
 
Back
Top