How to get date string in source?

[strutZ]

Title proberly makes no sense... basically i am changing the player report bug function in tfs 1.2. i want it to get the date and insert it into my database.

Here is what i got.

void Game::playerReportBug(uint32_t playerId, const std::string& message, const Position position, uint8_t category)
{
    Database* db = Database::getInstance();
    std::ostringstream query;
    query << "INSERT INTO `reports` (`player`, `mappos`, `playerpos`, `comment`) VALUES (" << player->getName() << ',' << position << ',' << player->getPosition() << ',' << db->escapeString(comment) << ')';
    db->executeQuery(query.str());
}

 

[Santi]

Well you could just use the std library time. Boost also has a time lib I think.

 

[samco]

Yeah, use the std library time, you need to add a column to the db if it doesnt have any date related and update it aswell.

#include <time.h> /* time_t, struct tm, difftime, time, mktime */
--
time_t date = time(NULL);
query << "INSERT INTO `reports` (`player`, `mappos`, `playerpos`, `comment` , `date`) VALUES (" << player->getName() << ',' << position << ',' << player->getPosition() << ',' << db->escapeString(comment) << ';'<< date<< ')';

Should work