Welcome to Qqrofl's mega Tutorials!!

1.1 How to make accounts.
First we are going to start out with making accounts!

1. Open your database!

2. I use navicat! So follow me correctly.

3. Find your account table like so:




4. Open it up. Click the + and push the check mark to save it once you're done! on the very bottem. And follow this picture!:



Wow you're done! That was easy was it? To another Tutorial!

This Tutorial will show you how to put loot on creatures!
1.2 - How to put loot on creatures.

1. Open your database! Navicat or HeidiSQL.

2. Go to your world Database section.

3. Find the table called "loot_creatures"

4. Double click to open the table!

5. Follow this:



Congrats! Restart your server now! Spawn the npc and see if the item drops!


1.3 - How to make people spawn in another spot when you make a new character.

1. Open your database, I prefer Navicat.

2. Open your World database connection.

3. Now find a table called "playercreateinfo"

4. You need to read this carefully.

5. Here are the Class and Race ID's.:


Here is the Class ID's
1.Warrior
2.Paladin
3.Hunter
4.Rogue
5.Priest
6. Death Knight
7.Shaman
8.Mage
9.Warlock
11.Druid
Here is the Race ID's
1 Human
2 Orc
3 Dwarf
4 Night Elf
5 Undead
6 Tauren
7 Gnome
8 Troll
10 Blood elf
11 Draenei
Here are the Horde/Alliance Factions as well.
1. Alliance
2. Horde

6. Now follow this:



Index: Leave it like it is.
Race: Race is the raceID's that i put on the top.
Factiontemplate: That is the faction like i put on top, 1- alliance 2 -horde.
Class: That's the class ID that I put on top.
MapID, ZoneID, PositionX, Y, Z. I'm going to show you how to make the player spawn in a different area! Lets say we want them to spawn in dalaran.

TYPE .gps In GAME. You will get Cords. You have to put the cords in the createplayerinfo: MapID, zoneID, PositionX, Y and Z
We are going to change a Human, Warrior. Location.
Pictures:


Now you should replace the old map and such (If you look at the pictures on top that is the old stuff) To the new one, when you typed .gps In game.



Congrats You're DONE!! On to the next Tutorial!

1.4 How to Edit peoples character names thru the database.

1. Open up Navicat!

2. Open up your Character database section.

3. Then look for a table called "Characters"

4. Open it!!

5. Now follow:

It should Look like this once you have opened it, but without my name in it, lol.


Now you can edit anyones name even yours! You can make it so it will say <Admin> Easelm. And such!

Congrats... Wow that was to easy! Time for something hard!

1.5 How to make Npc's Manually thru the database.


1. Open up navicat!

2. Open up your world database connection

3. Find a table called "Creature_names"

4. Open it!

5. Now follow this:


Entry: Put any number there! Make sure it's not taken.

Name: Put a name for the npc

Subname: This will show under the npc's Name

info_str: Leave it blank.

Flags1: Leave it blank!

type: I put 7 for anything so put 7

Family: leave it blank.



Rank: 2 - boss 3- elite.

unk4: Leave it blank!

spelldataid: leave it blank!

male_displayid: You can find the Id's for searching in navicat or heidisql!

I'll give you a good DisplayID now.

Lich King - DisplayID 24191

1.5B - Finshing the a npc thru the database manually.


1. Open Navicat or HeidiSQL

2. Open up your world database connection

3. Now look for a table called "creature_proto" it should be under the creature_name.

4. Now follow these steps!


EntryID: The same entryId as you put in the creature_name table.

Minlevel: The min level of the npc lets put it at 75



Maxlevel: The max level of the npc lets put 80, so now the npc if you spawn it, it will go from level 75-80.

Faction: The faction of the npc:

35 - 35 is a exalted faction (They will be green to you)

14 - 14 is a enemy faction (They will be red)

Minhealth: This is the HP of the npc. You can put anything lets put 709344

Maxhealth: This is the same as the minhealth we put 709344 again.

Mana: Put anything for mana.



Scale: 1 is the normal scale. 2 is bigger than 1, so on.

Npcflags: This is if you make a LUA script or if you want to make a vendor or a Innkeeper. Leave it at 0.
1 - If the npc is friendly you can click on it.
130 - 130 is a vendor.

Attacktime: This is the attacktime of the npc.
1300 - Is very fast
2,000 - Is normal.

Attacktype: Leave it blank.

Mindamage: This is the min damage of the npc. Lets put 2932. 2932 is a elite damage.
Maxdamage: This is the max damage of the npc. But this time we can go higher lets put 4329. Now the npc will hit 2932-4329.

can_ranged: Leave it blank!



respawntime: 30000 - Is 30 secs 40000 - is 40 seconds.

armor: well you know what to put here. It's the armor of the NPC!

resistance: This will give the npc resistance to, Holy, Nature, fire, frost, arcane.. etc.



combat_reach: Set it to 1

bounding_radius: leave it blank!

auras: leave it blank!

Boss: set it to 1 if it's a boss!

Money: This is the gold he will drop!

Now leave the rest blank!!

Congrats on your new NPC!!!!




I will make more Tutorials later!! Thanks for reading any questions, I'm here to help!!

Note: Make sure you PUSH THE CHECK MARK TO SAVE YOUR DATA!!!


› See More: [Mega-Tuts]: How to make accounts and more [With Pics]!