stoneharry

Untitled

May 31st, 2014
372
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 0.76 KB | None | 0 0
  1.         // Save to database
  2.         QueryResult result = CharacterDatabase.PQuery("SELECT COUNT(*) FROM `character_perks` WHERE `GUID` = '%u'", sender->GetGUIDLow());
  3.         uint64 rows = result->Fetch()[0].GetUInt64();
  4.         if (rows == 0)
  5.         {
  6.             CharacterDatabase.PExecute("INSERT INTO `character_perks` VALUES ('%u', '%d', '%d', '%d', '%d')",
  7.                 sender->GetGUIDLow(), perks[0], perks[1], perks[2], perks[3]);
  8.         }
  9.         else if (rows == 1)
  10.         {
  11.             CharacterDatabase.PExecute("UPDATE `character_perks` SET `perk1`='%d',`perk2`='%d',`perk3`='%d',`perk4`='%d' WHERE `GUID` = '%u'",
  12.                 perks[0], perks[1], perks[2], perks[3], sender->GetGUIDLow());
  13.         }
  14.         else
  15.         {
  16.             TC_LOG_INFO("server.error", "[ERROR]: Character %s has multiple perk records in the database.", sender->GetName());
  17.         }
Advertisement
Add Comment
Please, Sign In to add comment