[Tutorials for Noobs] How to setup a private server and make it public(+ Extra's) 3

[R3dW3r3W0lf]

You Must Follow the other 2 Tutorials i Created, one to make a private server and the other to prepare. Today, this tutorial will tell you how to create customs So here we go. You MUST Read these first or you wont understand this tutorial:

[Tutorials for Noobs] How to setup a private server and make it public(+ Extra's)
[Tutorials for Noobs] How to setup a private server and make it public(+ Extra's) 2

Ok, Now that you know the Setup of a Private server and you are prepared, In This tutorial, I Will teach you how to make custom stuff. All day today, i will add some stuff to this tutorial but i'll just start one and start again in a few so here we go.


3 Ways

There are 3 ways to make custom stuff. The following are the 3 ways:
1. WoW-V:

WoW-V is an awesome Online .sql maker that generates an item for you to execute into your database. This Website is awesome but The problem is sometimes it generates problems but if it doesnt have any problems, it rocks.
WoW-V

2.Database Editor Program:

Flexible Database Editor is a Powerful Downloadable Tool that allows anyone to create custom items in the flick of a button. This isn't a .sql generator, it actually makes the item and puts it in your database but since arcemu is having some changes, It isn't as effective but if you want to just update a person, then you can use this.

3. Database Editing(Recommended)

This is the Sure Fire way of editing the Database, this is a surefire way of editing your database. It's easy to use and you can make stuff That The Database editor Or WoW-V cant do. This is recommended.


Ok, Now that you know the 3 ways, choose one that you think is best. I'd go with The Old fashioned way.

Since the First 2 Ways are too easy and Database Editing is hard, i'll give a tutorial to do that so lets start:

Currently at break so stay tuned for tutorials between these!

Custom Item:

1. Open up The Table "Items".

2. Make a New Line and put the info you want, here is the info for each row:

Entry - This is the ID Number

Class - Class: This is the type of item. IE: Weapon, Armor, Bag, ect ect.
0 = Consumable
1 = Container
2 = Weapon
3 = Gem
4 = Armor
5 = Unknown
6 = Projectile
7 = Trade Goods
8 = Fish Scale (They get a category all by themselves!)
9 = Recipe
11 = Quiver/Ammopouch
12 = Quest Items
13 = Keys
14 = Unused Mounts
15 = Misc (Gray Drops/Mounts/Flavor Items)

Subclass -
(Search For ID's)

Weapons -
0 = One-Handed Axe
1 = Two-Handed Axe
2 = Bow
3 = Gun
4 = One-Handed Mace
5 = Two-Handed Mace
6 = Polearm
7 = One-Handed Sword
8 = Two-Handed Sword
10 = Staff
13 = Fist
14 = Universal (Everyone can use it)
15 = Daggers
16 = Thrown
18 = Crossbow
19 = Wands
20 = Fishing Poles

Gems -
0 = Red
1 = Blue
2 = Yellow
3 = Purple
4 = Green
5 = Orange
6 = Meta
7 = Misc (Low Gems)
8 = Prismatic

Armor -
0 = Shirt:Ring:Off-hand:Tabard:Neck:Trinket
1-4 = Gloves:Chest:Belt:Feet:Waist:Head:Bracersants:Sh oulders
6 = Shield
7-9= Librams:Idols:Totems

field4 -
-1

Name1-4 -
(The name of the item, as it appears in the game. Only name1 is needed)

DisplayID -
(What the item will look like. Find an item you like, and take it's ID)

Quality -
0 = Poor (Grey)
1 = Common (White)
2 = Uncommon (Green)
3 = Rare (Blue)
4 = Epic (Purple)
5 = Legendary (Orange)
6 = Artifact (Gold)

Flags -
0

BuyPrice -
(How much it costs to buy from a vendor. (In copper) 1g = 10000 copper)

SellPrice -
(How much money you will get when you sell the item to the vendor)

InventoryType -
(Where the item can equip to on the Equipment Tab)
0 = Inventory No equip
1 = Head
2 = Neck
3 = Shoulders
4 = Shirt
5 = Chest
6 = Belt
7 = Legs
8 = Feet
9 = Wrist
10 = Gloves
11 = Ring
12 = Trinket
13 = One-Hander
14 = Shield
15 = Ranged (Bow)
16 = Back
17 = Two-Hander
18 = Bag (Can be equipped on a bag slot)
19 = Tabard
20 = Chest
21 = Main-Hand
22 = Off-Hand Weapon
23 = Off-Hand Misc
24 = Ammo
25 = Thrown
26 = Ranged Gun

AllowableClass/AllowableRace -
(Allowable Classes and Races)

ItemLevel -
(N/a, whatever number you want)

RequiredLevel -
(Minimum level required to equip the item)

0 is for everyone.

RequiredSkill -
(What profession is required to use it. Example: Tailoring, Blacksmithing)
40 = Poisons
129 = First Aid
164 = Blacksmithing
165 = Leatherworking
171 = Alchemy
182 = Herbalism
185 = Cooking
197 = Tailoring
202 = Engineering
333 = Enchanting
356 = Fishing
755 = Jewelcrafting
762 = Riding

RequiredSkillRank -
(What skill level of the above skill do you need. 1-375)

RequiredSkillSubRank -
(Specialty Profession Rank. Example: Shadowcloth Tailor, Armorsmith, Dragonscale Leatherworker)

RequiredPlayerRank1-2 -
(PvP rank requirements. Example: Requires Grand Marshal)

RequiredFaction -
(What faction do you need to have to use this item. Example: Stormwind, Sha'tar, Thunder Bluff)

RequiredFactionStanding -
1 = Hated
2 = Hostile
3 = Unfriendly
4 = Neutral
5 = Friendly
6 = Honored
7 = Revered
8 = Exalted

Unique -
0 = No
1 = Yes

MaxCount -
(How many of the unique item you can have)

ContainerSlots -
(If the item is a bag, how many slots does it have)

StatType1-10 -
(What stat does this item have. Example= Stam, Str, Agl)

StatValue1-10 -
(How much of the above stat to give. Can be negative)

dmg_min1-5 -
(What is the minimum damage this item will do on an attack)

dmg_max1-5 -
(What is the maximum damage this item will do on an attack)

dmg_type1-5 -
0 = Physical
1 = Holy
2 = Fire
3 = Nature
4 = Frost
5 = Shadow
6 = Arcane

dmg_min1 -
(Whatever the attack should be = Minimized)
dmg_max1 -
(Whatever the attack should be = Maximized)
dmg_type1 -
(The Type of Attack)
dmg_min2 -
0
dmg_max2 -
0
dmg_type2 -
0

Armor -
How much armor the item gives.

holy_res -
How much Holy resistance the item gives.

fire_res -
How much Fire resistance the item gives.

nature_res -
How much Nature resistance!

frost_res -
How much Frost resistance!

shadow_res -
How much Shadow resistance!

arcane_res -
How much Arcane resistance!

Delay -
Swing time in milliseconds. (1000 = 1 sec)

Ammotype -
What kind of ammo does this weapon use.
2 = Arrows
3 = Bullets
4 = Thrown

Range -
Range of the weapon.

Then Just Hit save and exit, restart your server, YOU HAVE A CUSTOM ITEM!!!


Custom Quest:

Custom NPC:

Custom Loot:

Custom Vendor:

Custom Races:

Custom Books:

Custom Start Position:


- R3DW3R3W0LF tutorial

[Artilles]

soka? nice :O

[R3dW3r3W0lf]

Working on items Now!

[Artilles]

I'll hump em!

[rofldestroyer]

nice tut for noobs +rep

[R3dW3r3W0lf]

mwahahahahaha!

[Dardemon]

I don't see my item in the database. I would like to change some things on my item but i can't because i don't see it in my database. Help plz

[R3dW3r3W0lf]

Once you filled in the Row with the info of the item, you need to press the up button so it saves to your db then restart your server and there it is. :O

[unnounn]

I had the same problem

[oOz3r]

Hi uhm i got my server up and running and its public but..how do i activate tbc for the other players and how do i let them create their own accounts...+ not sure how to make myself a GM or my friends...


PLZ help...

[MPVM]

Hey... I have some questions i don't understand.



1: Why do i have to do the faddix update and replace the databases. Is it required for making my own items and get my server public?
Can't i just keep the origanal AC Web Unlimate repack installation?

2: The custom items you can make youself. Where can i bye them? Which vendor will sell these items to me?

3: If the item you make is a sword e.g. What should i then choose of these.
Swords aren't using amo

Ammotype -
What kind of ammo does this weapon use.
2 = Arrows
3 = Bullets
4 = Thrown


Thanks in advance
MPVM

[murlox]

Originally Posted by R3D3W3R3EW0LF

StatType1-10 -
(What stat does this item have. Example= Stam, Str, Agl)

StatValue1-10 -
(How much of the above stat to give. Can be negative)

So... Do you know the ID's for any of the stats?

[MPVM]

I know some of them

1 = Health
2 = ?
3 = Agility
4 = Strength
5 = Intellect
6 = Spirit
7 = Stamina

[murlox]

Originally Posted by MPVM

I know some of them

1 = Health
2 = ?
3 = Agility
4 = Strength
5 = Intellect
6 = Spirit
7 = Stamina

Thanks!

[madaramkd]

Hey man where can i find thi database can someone tell me please? Thanks.

[Alphy11]

Hey, not to nag or anything, but when is the next tutorial about making the server public?

Hey, not to nag or anything, but when is the next tutorial about making the server public?