TFS 1.X+ DBInsert storageQuery Error

[Sigoles]

I'm trying make on query in iologindata.cpp

DBInsert storageQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" << player->getGUID() << ", '606163', '0');");

but got an error:

/home/Otserver/src/iologindata.cpp: In static member function ‘static bool IOLoginData::loadPlayer(Player*, DBResult_ptr)’:
/home/Otserver/src/iologindata.cpp:724:116: error: invalid operands of types ‘const char [68]’ and ‘uint32_t {aka unsigned int}’ to binary ‘operator<<’
     DBInsert storageQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" << player->getGUID() << ", '606163', '0');");
                                                                                                                    ^
/home/Otserver/src/iologindata.cpp: In static member function ‘static bool IOLoginData::savePlayer(Player*, bool)’:
/home/Otserver/src/iologindata.cpp:1054:115: error: invalid operands of types ‘const char [68]’ and ‘uint32_t {aka unsigned int}’ to binary ‘operator<<’
    DBInsert storageQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" << player->getGUID() << ", '606163', '1');");
                                                                                                                   ^

                ^

 

[DukeeH]

I know is not what you asked, but why not setting storage on creaturescripts login?

 

[StreamSide]

or maybe on startup

 

[Sigoles]

I know is not what you asked, but why not setting storage on creaturescripts login?

because I don't have one function in lua, so I need use all in c++ (or make that function in lua) :S

anyone here know fix this error?

 

[Infernum]

you're trying to use stringstream operators on a raw char*, which doesn't work (you're technically using binary left shift)
use + instead of << to concatenate the value
+ player->getGUID() +

 

[Sigoles]

you're trying to use stringstream operators on a raw char*, which doesn't work (you're technically using binary left shift)
use + instead of << to concatenate the value
+ player->getGUID() +

hi, thanks!

DBInsert storageQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" + player->getGUID() + ", '606163', '0');");

I was tried it too, look error>

/home/Otserver/src/iologindata.cpp: In static member function ‘static bool IOLoginData::loadPlayer(Player*, DBResult_ptr)’:
/home/Otserver/src/iologindata.cpp:724:119: error: invalid operands of types ‘const char*’ and ‘const char [18]’ to binary ‘operator+’
     DBInsert storageQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" + player->getGUID() + ", '606163', '0');");
                                                                                                                       ^
/home/Otserver/src/iologindata.cpp: In static member function ‘static bool IOLoginData::savePlayer(Player*, bool)’:
/home/Otserver/src/iologindata.cpp:1053:118: error: invalid operands of types ‘const char*’ and ‘const char [18]’ to binary ‘operator+’
    DBInsert storageQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" + player->getGUID() + ", '606163', '1');");
                                                                                                                      ^

 

[Infernum]

std::to_string(player->getGUID())

 

[Sigoles]

std::to_string(player->getGUID())

thanks again, the error is gone, but the query does not working (not adding to database), why?

I make prints there and all is ok

DBInsert storageQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" + std::to_string(player->getGUID()) + ", '606163', '1');");   
std::cout << "Added to DB" << std::endl;

printing "Added to DB" but not adding

 

[Nekiro]

std::ostringstream query;
query << "INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" << player->getGUID() << ", '606163', '1')";
db->executeQuery(query.str());

if db is not declared add this

Database* db = Database::getInstance();

above the code

 

[Sigoles]

std::ostringstream query;
query << "INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" << player->getGUID() << ", '606163', '1')";
db->executeQuery(query.str());

if db is not declared add this

Database* db = Database::getInstance();

above the code

thanks nekiro, but not adding yet

tested codes:

std::ostringstream query;
query << "INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" << player->getGUID() << ", '606163', '1')";
db->executeQuery(query.str());

query.str(std::string());
query << "INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" << player->getGUID() << ", '606163', '1')";
db->executeQuery(query.str());

DBInsert storageQuery("INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES (" + std::to_string(player->getGUID()) + ", '606163', '1');");

 

[Sigoles]

std::to_string(player->getGUID())

my problem was:
the query was correct, but shortly after another query deleted the previous one.
thanks all guys