Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Save to database
- QueryResult result = CharacterDatabase.PQuery("SELECT COUNT(*) FROM `character_perks` WHERE `GUID` = '%u'", sender->GetGUIDLow());
- uint64 rows = result->Fetch()[0].GetUInt64();
- if (rows == 0)
- {
- CharacterDatabase.PExecute("INSERT INTO `character_perks` VALUES ('%u', '%d', '%d', '%d', '%d')",
- sender->GetGUIDLow(), perks[0], perks[1], perks[2], perks[3]);
- }
- else if (rows == 1)
- {
- CharacterDatabase.PExecute("UPDATE `character_perks` SET `perk1`='%d',`perk2`='%d',`perk3`='%d',`perk4`='%d' WHERE `GUID` = '%u'",
- perks[0], perks[1], perks[2], perks[3], sender->GetGUIDLow());
- }
- else
- {
- TC_LOG_INFO("server.error", "[ERROR]: Character %s has multiple perk records in the database.", sender->GetName());
- }
Advertisement
Add Comment
Please, Sign In to add comment