Code:
bool OnGossipSelect(Player* player, Creature* creature, uint32 sender, uint32 action)
{
player->PlayerTalkClass->ClearMenus();
QueryResult result = CharacterDatabase.PQuery("SELECT totaltime FROM characters WHERE guid=%u;", player->GetGUID());
Field *fields = result->Fetch();
uint32 totaltime = fields[0].GetUInt32();
switch (action)
{
case 101:
if (player->GetTotalPlayedTime() >60)
{
CharacterDatabase.PExecute("UPDATE characters SET totaltime = (totaltime - 60), leveltime = (leveltime - 60) WHERE guid = %u", player->GetGUIDLow()); //I updated the database characters
player->AddItem(60000, 10);
player->GetSession()->SendAreaTriggerMessage("test");
}
else
{
player->GetSession()->SendAreaTriggerMessage("test");
}
player->CLOSE_GOSSIP_MENU();
break;
I would like to ask how to preserve here?
I tried a variety of ways will not work.
Thank you again.
Last edited by a moderator: