sjizzle

Like I said I did this already next to that, they don't random move, even not when I spawn a new one in Dire Maul. They do however when I spawn them outside Dire Maul.

I have a problem, when I set creatures movementtype to random in DB and there spawndist is set ( for this case it is 5 ). They should move randomly within this distance. However in some dungeons ( for example Dire Maul ) they don't, even not when I spawn a new one. However if I spawn this same creature outside Dire Maul it does work.. What other factors are involved in this, and can be a cause of this problem ? ( I use MaNGOS Zero )

This isn't true for me. I use MaNGOS Zero can this be the cause? If you know where this is defined maybe I can backport it from other MaNGOS version. Thanks

is it possible to allow GMs to go to players if the GM is not binded himself? Can this be done ? is it easy or hard? A good or bad choice to do it ?

I want to create a gossip menu where you can ONLY select options if you do have the following buff: http://www.wowhead.com/spell=13326 So if you have the buff, you can talk or select the gossip options. How do I use the effectindex in this example? ( based on http://getmangos.eu/wiki/Gossip_menu_option ) cond_1 = 1 cond_1_val_1 = ?? cond_1_val_2 = ??

http://getmangos.eu/wiki/Gossip_menu_option On the bottom of this page I saw this: CONDITION_AURA = 1, // spell_id effindex Can anyone tell me how to find and where to find effindex of a spell?

Thanks for the help!

bump

I tried by using this: REPLACE INTO `Character_current_time` (`time_current`) VALUES ('50'); but how does guid fit in here? WHERE guid = '%u' that doesn;t work after VALUES.. Sorry not that good with SQL

Hello, How to write a vallue like this to the database? time_t currenttime = sWorld.GetGameTime() I used: CharacterDatabase.PExecuteLog("UPDATE Character_current_time SET time_current = '%u' WHERE guid = '%u'", currenttime, pPlayer->GetGUID()); though this fails, value in the database is still ZERO. My database field has the following specs: - Datatype : bigint - Len : 40 - Default : 0 - Not NULL: checked - Unsigned : checked

Thanks this worked, had to delete all rows and insert them with modified values

Thanks, do you have an example on how to do this?

Hello guys, I don't know much about database, so I hope someone can help me with this. Anyway, the problem I have is I can't write( make changes ) insome rows within the following table: - mangos.event_scripts Does anyone knows what is causing this and how solve this?

Does nobody has an idea for me where to start looking ? How this MABEY can be done? Every information is welcome, there must be someone, experienced with MaNGOS that knows something..

Hello, Since there are several NPCs which are spawned by bosses but with low HP to do something.. These NPCs are immune to AoE spells in a lot of examples. Does anyone have tips on how to create something so I can make them immune to AoE spells?

Hello, When I want a command to be used only ones within 2 days, what is the best way to do this? I created a extra table: `Time_of_Usage` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute start date, the command was used' I used: time_t currenttime = sWorld.GetGameTime(); time_t now = time(NULL); I do not exactly know how to get the time? Which is best and what the values really mean. Also how do I add 48 hours to the variable now or cuttentime ? Next to that, how do I check if it passed 2 days, so the command can be used again? Any help is welcome.

bump.

Were can this be found ?

This doesn't fix reckoning for me. It only adds a maximum of 2 extra hits not for example 4

Really cool finally patrol can be used in Mangos instances

This is actually a buff, though it is added to your spell debuffs. Next to that it can't be dispelled bij other players. When you cast this spell on yourself, you can dispell it. When your target has this buff, you can't dispell it. Probably somehow the spell is seen as 'negative' ( debuff ) not a buff. ( this would clarify why you can dispell it when you have magic grounding active on yourself but can't dispell it when magic grounding is active on your target ). Does anyone know where to find/change the cause of this? And mebey how to fix this?