I finally had the time to look to see where everything is at. Like I said before, other query code is calling it from somewhere else and I mentioned that CharacterDatabase would only be the starting point.
Originally Posted by botixrt8
I only see one bugreport PreparedStatement in CharacterDatabase.cpp:
After searching for "CHAR_INS_BUG_REPORT", it will take you to the CMSG_BUG_REPORT function that handles the opcode inside of Mischandler.cpp (line 722).
PrepareStatement(CHAR_INS_BUG_REPORT, "INSERT INTO bugreport (type, content) VALUES(?, ?)", CONNECTION_ASYNC);
Delete the lines in red below:
And you should be good to go. Also, I'm not saying this will fix the issue of him spam inserting queries. Anything can honestly be done like this, but bugreport is so pointless on a private server, and maybe it might help to remove it.
void WorldSession::HandleBugOpcode(WorldPacket& recvData)
uint32 suggestion, contentlen, typelen;
std::string content, type;
recvData >> suggestion >> contentlen >> content;
recvData >> typelen >> type;
if (suggestion == 0)
TC_LOG_DEBUG(LOG_FILTER_NETWORKIO, "WORLD: Received CMSG_BUG [Bug Report]");
TC_LOG_DEBUG(LOG_FILTER_NETWORKIO, "WORLD: Received CMSG_BUG [Suggestion]");
TC_LOG_DEBUG(LOG_FILTER_NETWORKIO, "%s", type.c_str());
TC_LOG_DEBUG(LOG_FILTER_NETWORKIO, "%s", content.c_str());
PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_INS_BUG_REPORT);