plr->GetGUID(), pCreature->GetEntry()
CharacterDatabase.Execute("INSERT INTO player_shop (ownerguid, vendor) VALUES(%u, %u)", plr->GetGUID(), pCreature->GetEntry());
CharacterDatabase.Execute("INSERT INTO player_shop (ownerguid, vendor) VALUES(%u, %u)", plr->GetGUID(), pCreature->GetGUID());
CharacterDatabase.Execute("INSERT INTO player_shop (ownerguid, vendor) VALUES(%u, %u)", plr->GetGUID(), pCreature->GetEntry());CharacterDatabase.Execute("INSERT INTO player_shop (vendor) VALUES(%u)", pCreature->GetEntry());
CharacterDatabase.Execute("INSERT INTO player_shop (vendor) VALUES(%u)", pCreature->GetEntry());
#include <sstream>#include <string>.....stringstream myQuery;myQuery << "INSERT INTO player_shop (ownerguid, vendor) VALUES(" << plr->GetGUID() << "," << pCreature->GetGUID() << ")"; CharacterDatabase.Execute( myQuery.toString() );
CharacterDatabase.PQuery("INSERT INTO player_shop VALUES ( '%u', '%u')", plr->GetGUID(), pCreature->GetEntry());You can also try with PExecute.CharacterDatabase.PExecute("INSERT INTO player_shop VALUES ( '%u', '%u')", plr->GetGUID(), pCreature->GetEntry());