[Ascent] Questions about WoW Private servers

Okay, I've searched all over the net for answers to these but I can't find them, so I'll just ask you guys because you seem to know what you're doing.

First, when I talk to a vendor it tells me that it cant find a vendor template. Great, so I'll just add my own items and problem solved. But when I add the items, and I close the server or log out or anything, it deletes the vendor template I added. I've tried adding vendor.sql's, but all that does is delete the old vendors and make new models, with EMPTY TEMPLATES. ARGHGHG.:SniperHea

Second, I want to make Alliance/horde start at somewhere else, how do I set up the spawning area? (Using Heidisql, if that matters)

Third, Is there a way to create my own spells on the server?

Im sure theres more and i'll edit when they come to me but thats all i have for now,

there is a thread around telling how to change starting area...
im not sure about the vendor thing...
there is no spell making tool out that i know of, so what i do is manually go into the database and change a spell, you could probably add a new one by copying a different one and changing the spell ID and damage and whatever else you want to change

If you take a minute to look at database names, you'll understand how to change starting areas.

Like "Playercreateinfo" perhaps?

Quote:

---

Originally Posted by rkod420

If you take a minute to look at database names, you'll understand how to change starting areas.

Like "Playercreateinfo" perhaps?

---

Actually, I did look at the database. And it only confused me more, because if its right, there is 54 races. Could you name for me the 46 races im missing? :scratch:

Quote:

---

Originally Posted by Bigmutha

there is a thread around telling how to change starting area...
im not sure about the vendor thing...
there is no spell making tool out that i know of, so what i do is manually go into the database and change a spell, you could probably add a new one by copying a different one and changing the spell ID and damage and whatever else you want to change

---

Ooh! Where is this thread you speak of?

the vendor thig to permanent add a item in it use .npc vendoradditem <item ID> 1

The 1 is to permanent add it so after restart it will still be there.

Quote:

---

Originally Posted by Kurohane

First, when I talk to a vendor it tells me that it cant find a vendor template. Great, so I'll just add my own items and problem solved. But when I add the items, and I close the server or log out or anything, it deletes the vendor template I added. I've tried adding vendor.sql's, but all that does is delete the old vendors and make new models, with EMPTY TEMPLATES. ARGHGHG.

---

Add the items with the server closed; it probably writes the loaded data back into the database in case you made any changes.
Or did you mean you were adding them via server commands?

Quote:

---

Originally Posted by Kurohane

Actually, I did look at the database. And it only confused me more, because if its right, there is 54 races. Could you name for me the 46 races im missing? :scratch:

---

There may be 54 rows, each with a race, but you'll notice that there are many race duplicates. They should range from 1-8.

Guy answered it for me ^

Quote:

---

Originally Posted by raylu

Add the items with the server closed; it probably writes the loaded data back into the database in case you made any changes.
Or did you mean you were adding them via server commands?



There may be 54 rows, each with a race, but you'll notice that there are many race duplicates. They should range from 1-8.

---

Yeah, I was adding them via server commands, looking at the database makes my brain break.

If there are are many race duplicates how do I know which are real >.<

Quote:

---

Originally Posted by CronicT

the vendor thig to permanent add a item in it use .npc vendoradditem <item ID> 1

The 1 is to permanent add it so after restart it will still be there.

---

Thanks! I'll try that and see if it works.

Oh, and how are the races numbered? I think that confuses me most :/

Or do I have to go to the database and mess around for another week to figure that out? >.<

I didn't found how to change dmg of spell :S

Quote:

---

Originally Posted by Kurohane

Yeah, I was adding them via server commands, looking at the database makes my brain break.

If there are are many race duplicates how do I know which are real >.<

---

All of them are "real" why ? because you have your warrior for example.. warrior can be Elf and Human and Draenei and Undead and Orc and you get the point.. that's why you have 50+ rows..