[NEW] EMU Expert Question/request/FAQ thread, QUESTIONS HERE!

[ffdevil]

Hello,
I have a "server" up, am using arcemu, mysql and navicat.
I have 2 questions that I could use help with:
1) How can I make more "creatures" (like the young nightsabers) so that there are more in an area? Do I need to "spawn" them all singly, or is there a way to add them in the navicat, all at one time?

2) How can I change the "re-spawn" rate, so the cratures re-spawn quicker?

Thank you for your time.

To: bulletzaredeadly,
I also have arcemu, I dont know for sure, but I believe the easiest way, would be to add an npc at your starting points, which gives the gold to each new char.
Hope this helps.

[TheSpidey]

Ugh. Please refrain from PMing me about questions you already posted on the forums. I'm pasting the exact answer I sent you earlier.

1) You can either spawn them ingame (in that case, macros are lifesavers), or add them to the DB manually. But unless you know the coordinates of each spawn, I suggest you do it with a simple .npc spawn <id> macro.

2) The field 'respawntime' in the creature_proto table controls just that

[ffdevil]

Re: my 2 questions, this is the answer I was given:

1) You can either spawn them ingame (in that case, macros are lifesavers), or add them to the DB manually. But unless you know the coordinates of each spawn, I suggest you do it with a simple .npc spawn <id> macro.

2) The field 'respawntime' in the creature_proto table controls just that

Thank you very much, "TheSpidey"

Oh ... so very sorry, when I pulled up this thread, I didnt show Spideys post, so my last was a repost, sorry to all

[tdr1]

how do i make it so when i spawn an object it stays there forever, because when my server goes off and i turn it back on the objects are gone :S

[2dgreengiant]

how do i make it so when i spawn an object it stays there forever, because when my server goes off and i turn it back on the objects are gone :S

If your using ascent then do the command .go spawn *go id* 1

You need to add the 1 at the end

[fireguild1]

Hey everytime I try to run my server I get Unknown CMD 19 error.

I can get on my server (kinda) but I get to realmlist and click my realm and it says Logging into game server and then goes back to realm selection screen. Everyone else gets this problem when they try to login too


I made a post about this in emu questions but nobody seems to know please help

[Ickybad]

Make sure your not having a realm loop mate ^_^. And the unknown cmd 19 error ill look into.

[Babbaa]

Alright.. Here's an issue I get when compiling my first script in C++.

I'm not sure if this is the right section, But I posted it in "Questions" too, But I don't get any answer, And I really need this to work as soon as possible.

ERROR;

Compiling...
OwlStone.cpp
..srcOwlStoneOwlStone.cpp(10) : error C2143: syntax error : missing ';' before '<class-head>'
Setup.cpp
cDocuments and SettingsTogetha'SkrivbordOwlEmuSNbranchSTABLEsrcascent-sharedsvn_revision.h(7) : error C2144: syntax error : 'const char' should be preceded by ';'

OwlStone.cpp

#include "StdAfx.h"
#include "Setup.h"

#ifdef WIN32
#pragma warning(disable:4305) // warning C4305: 'argument' : truncation from 'double' to 'float'
#endif

#define STONEID 90020

class SCRIPT_DECL OwlStone : public GossipScript
{
public:
void GossipHello(Object * pObject, Player* Plr, bool AutoSend);
void GossipSelectOption(Object * pObject, Player* Plr, uint32 Id, uint32 IntId, const char * Code);
void GossipEnd(Object * pObject, Player* Plr);
void Destroy()
{
delete this;
}
};

void OwlStone::GossipHello(Object * pObject, Player* Plr, bool AutoSend)
          {
          if(Plr->CombatStatus.IsInCombat()) 
            {          
          Plr->BroadcastMessage("You are in combat!");   
          return;
          }
GossipMenu *Menu;
objmgr.CreateGossipMenuForPlayer(&Menu, pObject->GetGUID(), 2593, Plr);
{
Menu->AddItem(5,"Shattrath Mall", 1);
Menu->AddItem(0,"PvP Areas", 2);
Menu->AddItem(0,"Battlefront Areas", 3);
Menu->AddItem(5,"Advance all Wep Skills", 4);
Menu->AddItem(5,"Save Character", 5);
Menu->AddItem(5,"Reset Talents", 6);
Menu->AddItem(5,"Remove Ress Sickness", 7);
if(AutoSend)
Menu->SendTo(Plr);
}}

void OwlStone::GossipSelectOption(Object* pObject, Player* Plr, uint32 Id, uint32 IntId, const char * Code)
{
        GossipMenu * Menu;
        switch(IntId)
{
        case 0:
        GossipHello(pObject, Plr, true);
        break;

    case 1:
        {
            Plr->EventTeleport(530, -1851.617188, 5466.460938, 12.428118);
        }
break;

    case 2:
        {
objmgr.CreateGossipMenuForPlayer(&Menu, pObject->GetGUID(), 2593, Plr);
    Menu->AddItem(5,"Nagrand PvP Arena", 10);
    Menu->AddItem(5,"Blade's Edge Arena", 11);
    Menu->AddItem(5,"Gurubashi Arena", 12);
    Menu->SendTo(Plr);
}
break;

    case 3:
        {
objmgr.CreateGossipMenuForPlayer(&Menu, pObject->GetGUID(), 2593, Plr);
    Menu->AddItem(5,"Horde Battlefront Area", 15);
    Menu->AddItem(5,"Battlefront Mid-Field Area", 16);
    Menu->AddItem(5,"Alliance Battlefront Area", 17);
    Menu->SendTo(Plr);
}
break;

    case 4:
{

        if (Plr->_HasSkillLine(43))
                                      {Plr->_AdvanceSkillLine(43, 350);}
                              if (Plr->_HasSkillLine(55))
                                      {Plr->_AdvanceSkillLine(55, 350);}
                              if (Plr->_HasSkillLine(44))
                                      {Plr->_AdvanceSkillLine(44, 350);}
                              if (Plr->_HasSkillLine(95))
                                      {Plr->_AdvanceSkillLine(95, 350);}
                              if (Plr->_HasSkillLine(54))
                                      {Plr->_AdvanceSkillLine(54, 350);}
                              if (Plr->_HasSkillLine(45))
                                      {Plr->_AdvanceSkillLine(45, 350);}
                              if (Plr->_HasSkillLine(46))
                                      {Plr->_AdvanceSkillLine(46, 350);}
                              if (Plr->_HasSkillLine(136))
                                      {Plr->_AdvanceSkillLine(136, 350);}
                              if (Plr->_HasSkillLine(160))
                                      {Plr->_AdvanceSkillLine(160, 350);}
                              if (Plr->_HasSkillLine(162))
                                      {Plr->_AdvanceSkillLine(162, 350);}
                              if (Plr->_HasSkillLine(172))
                                      {Plr->_AdvanceSkillLine(172, 350);}
                              if (Plr->_HasSkillLine(173))
                                      {Plr->_AdvanceSkillLine(173, 350);}
                              if (Plr->_HasSkillLine(176))
                                      {Plr->_AdvanceSkillLine(176, 350);}
                              if (Plr->_HasSkillLine(226))
                                      {Plr->_AdvanceSkillLine(226, 350);}
                              if (Plr->_HasSkillLine(228))
                                      {Plr->_AdvanceSkillLine(228, 350);}
                              if (Plr->_HasSkillLine(229))
                                      {Plr->_AdvanceSkillLine(229, 350);}
                              if (Plr->_HasSkillLine(473))
                                      {Plr->_AdvanceSkillLine(473, 350);}
                              Plr->Gossip_Complete();
}
break;

    case 5: 
{
    Plr->SaveToDB(true);
    Plr->BroadcastMessage("Your Character Has Been Succesfully Saved to the Database");               
    Plr->Emote(EMOTE_ONESHOT_CHEER);
    Plr->Gossip_Complete();
}
break;

    case 6: 
{
    Plr->BroadcastMessage("Your Talentpoints have been sucessfully reset!");
    Plr->Reset_Talents();
    Plr->Gossip_Complete();
}
break;

    case 7: 
{
    Plr->addSpell(15007);
    Plr->removeSpell(15007,0,0,0);
    Plr->BroadcastMessage("You have been cured of that dreaded sickness!" );
    Plr->Gossip_Complete();
}
break;

    case 10:
{
    Plr->EventTeleport(530, -2046.101807, 6657.619141, 13.053440);
}break;

    case 11:
{
    Plr->EventTeleport(530, 2838.986572, 5928.729004, 11.064964);
}
break;

    case 12:
{
    Plr->EventTeleport(0, -13228.034180, 229.909576, 33.117268);
}
break;

    case 15:
{
    Plr->EventTeleport(0, -8282.810547, -3328.542236, 170.881210);
}
break;

    case 16:
{
    Plr->EventTeleport(0, -7886.782227, -3345.649902, 171.201370);
}
break;

    case 17:
{
    Plr->EventTeleport(0, -7569.903809, -3434.363770, 170.881958);
}
break;
}
}
void OwlStone::GossipEnd(Object * pObject, Player* Plr)
      {
      GossipScript::GossipEnd(pObject, Plr);
      }
void SetupOwlStone(ScriptMgr * mgr)
      {
      GossipScript * gs = (GossipScript*) new OwlStone();
      mgr->register_item_gossip_script(STONEID,gs);
      }

[blackops88]

Hey, I remember there used to be a webpage that generated SQL files for starting gear, like when you made the char it would be in your bags, but i cant find it anymore... So if anyone knows one could you give me a PM on here orreply on AIM or xfire. My aim is : Asu Blackops, and xfire : Yemanoob

Thanks!

[eesti]

I have only 1 question:
1. Where i cant find .cpp files ??

Plz i need some help xD

[latruwski]

I have only 1 question:
1. Where i cant find .cpp files ??

Plz i need some help xD

where you can't find them is: in c:\windows blablabla for example
if you mean where you can find them then i suggest you check the arcemu svn... you can download the source and the source = .cpp files

grtz

[kevn93x]

How can I make LFG Channel usable by both factions
Had a config code. Lost it now.
&& I have searched already.

[latruwski]

Hey, I remember there used to be a webpage that generated SQL files for starting gear, like when you made the char it would be in your bags, but i cant find it anymore... So if anyone knows one could you give me a PM on here orreply on AIM or xfire. My aim is : Asu Blackops, and xfire : Yemanoob

Thanks!

gastricpenguin knows i think... he made it i think ^^

[dinko1989]

hey guys

can any of you help me with a huge issue I have :S ??
it's about how to update a mangos server without loosing characters and so on..
I am running the newest version, i think its 2.3.0... but i wonder what to do when
a repack comes for the new patch 3.x.x something..

ever since TBC came out, I have kept on deleting my friends and my characters...
IT HAS to stop..

please help

[rustyxcod]

hey guys

can any of you help me with a huge issue I have :S ??
it's about how to update a mangos server without loosing characters and so on..
I am running the newest version, i think its 2.3.0... but i wonder what to do when
a repack comes for the new patch 3.x.x something..

ever since TBC came out, I have kept on deleting my friends and my characters...
IT HAS to stop..

please help

What I would do, and I'm sure there is an easier way, is to go into your database before the patch and save your items, objects, characters, accounts, etc. (whatever you want to save), Save them as .SQL files. Then when you get a new repack for your updated patch, run each saved .SQL files and use the "continue on errors" function, I know navicat has one, im not sure about others since I dont use them. But this should add all the custom content you created, and then ignore all of the things already in the game.

NOTE: THIS WILL ONLY WORK IF YOUR NEW REPACK IS THE SAME TYPE AS YOUR OLD ONE. EXAMPLE: Ascent/Mangos (If not you will get errors because your tables will not match, say something doesn't exist or is missing.)

If there is an easier way than this, or I said something wrong that wouldn't work please correct me and suggest a better way .

I am giving this information from personal experience when my friend quit and gave his server for me to run for our other friends. I needed a new repack for an updated patch, but my other friend had spent all summer making custom content, and didn't want all that time to have been a waste. I successfully did this, kept all custom content they created, and had the new content from the repack.