[Video] How to make a 3.0.9 server

[anders1993]

Hi, im going to show you how to make a 3.0.8/3.0.9 server. I made a video out of it , because its much easier to understand.
[LINKS]
Navicat For Mysql Lite
Repack
Public (without Hamachi)
How to make an account




Hope it helped you =)

[ame="http://www.youtube.com/watch?v=uLQje6_alX8&e"]How to make private server 3.0.9[/ame]

[NWeaver]

Movie isn't working.

[anders1993]

now it works

[denizay]

when i try and login it says unable to validate game version.... any ideas?

[kokotko]

when i try and login it says unable to validate game version.... any ideas?
have same, can someone exatly pls tell what to do and how to do ?:/

ok i made the realm, playing on it BUT 1 really important command isnt there which is .additem !!!!!!!!!!!!!!!!!!!!!! can someone tell me what command is there for it?

[Vindicated]

Kokotko - You need to use .char additem ID

[anders1993]

Kokotko - You need to use .char additem ID

Thank you for answering for him on that =) i've been busy with homeworks :P
If it wont validate game version it's because your wow version may be running on an older patch? Your wow version has to be 3.0.9/3.0.8

[alamohippo]

When i run MySQL it asks if i already have a mysqld server running on the same port... then it closes. This is my first time trying to make a server and first time having mysql so thats impossible

[anders1993]

You need to exit program like "Skype" cus they make the "MySQL" to not work. Don't know why

[flameworker]

thats awsome thx alot mate

[Adhira]

Everything seems to be working now. But I cannot enter instances. The loading screen appears and instantly disappears, without a warning message.

And how do I add custom items made on www.wow-v.com ?

[anders1993]

Everything seems to be working now. But I cannot enter instances. The loading screen appears and instantly disappears, without a warning message.

And how do I add custom items made on WoW Vendetta - Wage Your War | WoW-V.com ?

I don't think instances work unless you make custom instances, but to add custom items is easy. Just download the SQL-file from wow-v(it has to be the ArcEmu file). Then you open navicate and go to the Database thats named "world" or "arcemu" find the table named "items" and open it. When you are on the "items" table push Ctrl+Q (or you can click on "file" an then "Query Table". Then the query table for the "items" table. Then load the SQL-file and push the "run" button each time you load it. When you close the table it ask you if you want to save. just click "no". Then you have to delete your cache file inside your wow folder. then you can play! (to add Npc just go on the "creature_proto" table and do the same. To add vendors, first load the SQL-file to "creature_proto" and then to "vendors". You need to download both SQL-file, one for "creature_proto" and one for "vendor"

[Adhira]

Hmm... I made some items with the entryID #100001 to #100013 and tried to add them. Some work and I get the result "1 row affected" and some get me the error message "SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,0,1141,0,0,0,0,0,0,0,0,0,0,0,0,0,0'"

Opening the SQL file with notepad gives me:

INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ReqDisenchantSkill, unk2)
VALUES (100001, 2, 8, -1, "Nunai's Blade", "Nunai's Blade", "Nunai's Blade", "Nunai's Blade", 54560, 6, 0, 0000, 0000, 17, 1, -1, 226, 80, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,  3, 250,  4, 250,  7, 250,  12, 250,  31, 250,  37, 250,  19, 250,  0, 0,  0, 0,  0, 0, 921, 1544, 0, 100, 200, 1, 100, 200, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3400, 0, 0, 24628, 0, 0, 0, 1141, 0, 45954, , 0, 0, 1141, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "The real blade.", 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 115, 0, 0, 0, 0, 2, 0, 4, 0, 8, 0, 3303, 0, 0, 0);

Where is the error? =S

[bloodrag0n13]

when i try to log in it says that it cant validate the game version i have 3.0.9

[Vindicated]

Your build numbers need to match the ones in the parenthesis (Should be a four digit number in bottom left corner). You can fix this in the arcemu-logonserver.conf file.