xeross

Hey, I've got the following announcer script(Modified by me) void World::SendBroadcast() { std::string msg; static int nextid; QueryResult *result; if(nextid != 0) { QueryResult *result = WorldDatabase.PQuery("SELECT `text`, `next` FROM `autobroadcast` WHERE `id` = %u", nextid); } else { QueryResult *result = WorldDatabase.PQuery("SELECT `text`, `next` FROM `autobroadcast` ORDER BY RAND() LIMIT 1"); } if(!result) return; nextid = result->Fetch()[1].GetUInt8(); msg = result->Fetch()[0].GetString(); delete result; static uint32 abcenter = 0; abcenter = sConfig.GetIntDefault("AutoBroadcast.Center", 0); if(abcenter == 0) { sWorld.SendWorldText(LANG_AUTO_BROADCAST, msg.c_str()); sLog.outString("AutoBroadcast: '%s'",msg.c_str()); } if(abcenter == 1) { WorldPacket data(SMSG_NOTIFICATION, (msg.size()+1)); data << msg; sWorld.SendGlobalMessage(&data); sLog.outString("AutoBroadcast: '%s'",msg.c_str()); } if(abcenter == 2) { sWorld.SendWorldText(LANG_AUTO_BROADCAST, msg.c_str()); WorldPacket data(SMSG_NOTIFICATION, (msg.size()+1)); data << msg; sWorld.SendGlobalMessage(&data); sLog.outString("AutoBroadcast: '%s'",msg.c_str()); } } the sql table: CREATE TABLE IF NOT EXISTS `autobroadcast` ( `id` int(11) NOT NULL AUTO_INCREMENT, `text` longtext NOT NULL, `next` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; INSERT INTO `autobroadcast` (`id`, `text`, `next`) VALUES (1, 'type /join World to chat with all players', 2), (2, 'Don''t forget to vote 4 us at ******', 3), (3, 'Also check our forums at ******', 1); Somehow it crashes on nextid = result->Fetch()[1].GetUInt8(); Can anyone help me with fixing this ? Thanks for your time, Xeross

Congratulations on the milestone and all the amazing work.

TytytytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTyty tytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTytytyty tytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytytyTytytytytytytyty. Thanks for this, FInally support, finally udb will make a 3.0.3 database, begone Frozen Database

you should be able to move when auto shooting when you auto attack you can also move. But does anyone know where this piece of code is ?

Hey, I want to fix this error someone gets when auto shooting, if they try to use a skill they get: another action is in progress, i want to know where this get's handled so i can add a check for auto-shoot etc.

thanks i'll try that

i now have void World::SendBroadcast() { std::string msg; int nextid; QueryResult *result; if(nextid != 0) { QueryResult *result = WorldDatabase.PQuery("SELECT `text`, `next` FROM `autobroadcast` WHERE `id` = %u", nextid); } else { QueryResult *result = WorldDatabase.PQuery("SELECT `text`, `next` FROM `autobroadcast` ORDER BY RAND() LIMIT 1"); } if(!result) return; nextid = result->Fetch()[1].GetUInt8(); msg = result->Fetch()[0].GetString(); delete result; static uint32 abcenter = 0; abcenter = sConfig.GetIntDefault("AutoBroadcast.Center", 0); if(abcenter == 0) { sWorld.SendWorldText(LANG_AUTO_BROADCAST, msg.c_str()); sLog.outString("AutoBroadcast: '%s'",msg.c_str()); } if(abcenter == 1) { WorldPacket data(SMSG_NOTIFICATION, (msg.size()+1)); data << msg; sWorld.SendGlobalMessage(&data); sLog.outString("AutoBroadcast: '%s'",msg.c_str()); } if(abcenter == 2) { sWorld.SendWorldText(LANG_AUTO_BROADCAST, msg.c_str()); WorldPacket data(SMSG_NOTIFICATION, (msg.size()+1)); data << msg; sWorld.SendGlobalMessage(&data); sLog.outString("AutoBroadcast: '%s'",msg.c_str()); } } But i wonder if nextid will be saved till the next function call so that the correct message will be selected

I am working on an announcer script and i have the following. void World::SendBroadcast() { std::string msg; int nextid; if(nextid != 0) { QueryResult *result = WorldDatabase.PQuery("SELECT `text`, `next` FROM `autobroadcast` WHERE `id` = %u", nextid); } else { QueryResult *result = WorldDatabase.PQuery("SELECT `text`, `next` FROM `autobroadcast` ORDER BY RAND() LIMIT 1"); } if(!result) return; nextid = result->Fetch()[1].GetInt(); msg = result->Fetch()[0].GetString(); delete result; static uint32 abcenter = 0; abcenter = sConfig.GetIntDefault("AutoBroadcast.Center", 0); if(abcenter == 0) { sWorld.SendWorldText(LANG_AUTO_BROADCAST, msg.c_str()); sLog.outString("AutoBroadcast: '%s'",msg.c_str()); } if(abcenter == 1) { WorldPacket data(SMSG_NOTIFICATION, (msg.size()+1)); data << msg; sWorld.SendGlobalMessage(&data); sLog.outString("AutoBroadcast: '%s'",msg.c_str()); } if(abcenter == 2) { sWorld.SendWorldText(LANG_AUTO_BROADCAST, msg.c_str()); WorldPacket data(SMSG_NOTIFICATION, (msg.size()+1)); data << msg; sWorld.SendGlobalMessage(&data); sLog.outString("AutoBroadcast: '%s'",msg.c_str()); } } All calls timers etc are configured properly, this is based on an announcer i found. However i get the following errors 2>..\\..\\src\\game\\World.cpp(2629) : error C2065: 'result' : undeclared identifier 2>..\\..\\src\\game\\World.cpp(2631) : error C2065: 'result' : undeclared identifier 2>..\\..\\src\\game\\World.cpp(2631) : error C2227: left of '->Fetch' must point to class/struct/union/generic type 2> type is ''unknown-type'' 2>..\\..\\src\\game\\World.cpp(2631) : error C2228: left of '.GetInt' must have class/struct/union 2>..\\..\\src\\game\\World.cpp(2632) : error C2065: 'result' : undeclared identifier 2>..\\..\\src\\game\\World.cpp(2632) : error C2227: left of '->Fetch' must point to class/struct/union/generic type 2> type is ''unknown-type'' 2>..\\..\\src\\game\\World.cpp(2632) : error C2228: left of '.GetString' must have class/struct/union 2>..\\..\\src\\game\\World.cpp(2633) : error C2065: 'result' : undeclared identifier 2>..\\..\\src\\game\\World.cpp(2633) : error C2541: 'delete' : cannot delete objects that are not pointers I think i did something wrong with nextit, it needs to be saved for the next function call so it gets the correct message from mysql, how would i accomplish this ? Thanks for your time, Xeross

Hey, Im working on a script myself atm and i need to put a variable into a query i have the following code : QueryResult *result = WorldDatabase.PQuery("SELECT `text`, `next` FROM `autobroadcast` WHERE `id` = %u", nextid); Now i want to know what do the %u etc mean and how do i use them properly. The variable nextid has been set btw. Also i've assigned nextid to be a uint32 but it will never reach a number higher then 32 or so what is the best variable type to use for it ? Thanks for your time, Xeross

Hey, I have a vote reward system i made but it was for ascent i now need to convert it for mangos. How would i do this does anyone have an example of a script that can insert mail into the game or a vote reward system that does this. Or can someone point me in the right direction ? Thanks for your time, Xeross

isnt multithreading faster in general