[Guide] How to Create Custom Content

[xxWARKILLxx]

Ok this will be an updated guide to creating custom content by Warkill :)
I will be showing you how to make custom Items/Vendors and Making Mobs drop whatever you want. Also I will be showing you the templates I made/use so you don't have to script yourself.

Creating a Weapon/Armor

1) Think first of a Name then the stats you will want it to have

2) Gather important information like available Entry ID's in your DB and CORRECT Display ID's or else you will wind up with a checkered blue box.

3) To find correct Display ID you can look them up on Allakhazam.com (http://wow.allakhazam.com) look for the Item you wish it to look like (Ill be using Thunderfury as an Example) then look JUST under the item tooltip and it will say LINKS go to XML and scroll down until you see this </display_html_zhTW>
<displayinfo>30606</displayinfo> So to clarify things Thunderfury's Item ID is 19019 BUT its display ID is 30606 I dont want anyone confused about the difference between the two. Alternatively you can use this text document if you know the Item ID and just want to know the Display ID (http://wow-v.com/forums/index.php?automodule=downloads&req=idx&cmd=viewdetail&f_id=9)

4) Since I know you don't know how to script it yourself I wont be giving you my template for them you can go to www.wow-v.com (http://wow-v.com/weaponcreator.php) there just fill out the information and select "Antrix Core" once you're done and download the SQL-Batch File.

5)To add the item to your Database If you are using NavicatSQL (http://navicat.com/) (Make sure MySql is running) Open up Navi and If you havent set up a connection use THIS AS A GUIDE (http://www.ac-web.org/forum/showthread.php?t=1313) (its for Heidi but connection input is the same) ok then once Navi is open click on your connection then Antrix then Tables now hit Query and then New Query Now you have a Query Window open hit Load then RUN reload items or restart server and the item will be in your Server repeat as many times as needed if you get an Error in SQL Syntax you did something wrong in the last steps go back and follow them exactly.

To add Custom Content If you are using HeidiSQL (http://www.heidisql.com/) (Make sure MySQL is running) Open up heidi (if you havent set up a connection us THIS AS A GUIDE (http://www.ac-web.org/forum/showthread.php?t=1313) Once you have a connection Select your Connection go to Import then Load Sql-file.. select whatever file you want to ad then select Execute and the item should be in your Database, reload items or restart server for them to take effect.

Creating a Vendor

Ok to make a vendor I will have you use my Template here it is:
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(91000, "NAME", "GUILDNAME", 0, 4, 0, 3, 0, NULL, 19019, 1, 1, 1, 0);

INSERT INTO creature_proto
(entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss)
VALUES
(91000, 70, 120, 10000, 5000, 1, 4, 1000, 300, 400, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90057", 1);ALL you have to change whatever I highlighted which is his Entry ID, NAME,GUILDNAME,Display ID In that order (which is indicated with 19019# this will dictate how the vendor looks) I've already made the vendor friendly with both Horde/Alliance. To add items to the vendor simply replace the blue highlighted area with the ID of the weapon you want him to sell weather its Blizz made or Custom. To add more than one Item just copy paste INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90057", 1);Only replacing the Blue part . The red highlighted area tells the DB which Vendor sells that item. Untill your Final result looks something like this INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(91000, "CUSTOM CLASS SETS", "Liquid Gears Team", 0, 4, 0, 3, 0, NULL, 19019, 1, 1, 1, 0);

INSERT INTO creature_proto
(entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss)
VALUES
(91000, 70, 120, 10000, 5000, 1, 4, 1000, 300, 400, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90057", 1);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90056", 1);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90055", 1);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90054", 1);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90053", 1);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90052", 1);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90051", 1);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90050", 1);
With only the ItemGuid's Changing to keep adding more Items to the vendor. To add the to the DB its the same way as I explained earlier with Navicat/Heidi and the weapons so follow that guide.

Creating Custom Drops/Drop Rate

Here is the template you can use to create the the drop table for the mob:

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("11583", "19019", 100);
The Number Indicated in Blue is the Creatures Entry ID you wish to drop the item In this case Nefarian from BWL, then the number in Red is the Items Entry ID which happens to be Thunderfury in this case. The number in Yellow is the Percent Chance to Drop you can change it to whatever you would like.

For now this is all I will post Donators will have access to a video guide showing this and alot more video guides on more custom content

[szela_93]

u could post 'easier' scripts that look like
INSERT INTO creatureloot VALUES ("11583", "19019", 100);
but guide is good
i will not test that cos i know all this stuff:D

[xxWARKILLxx]

Yeah but I did it this way so they know what they are modifying

[xZer0x]

Nice Mate This is verry handy for the ppl who diddnt know it :):) Great job again :)

[runawaywaffle]

can you not make shields??

[darkpingu]

Cheers mate, this is a wounderful tutorial, i like it alot. Thanks

[xxWARKILLxx]

can you not make shields??

yes you can make shields in wow-v.com its pretty basic there but its the best place to go if you dont know or want to script everything yourself.

[Azax]

Thanks alot m8 really liked it :)

[runawaywaffle]

for the custom loot....how do i know which number is which monster because in my table there are too many numbers in the id to have it be a spawn id or anything of that sort

[xxWARKILLxx]

Well whichever monster you chose type its name in Thottbot.com or Wowhead/allakhazam and on the URL it should give you its Entry ID, type that inplace of what I put.

[kael]

ya, or u can use my guide and do the long as way, easier, but long way of making vendors and shit

[Trinity]

You can use www.wow-v.com or whatever

[xxWARKILLxx]

You can use www.wow-v.com or whatever

Yeah I mentioned that in the guide I believe :)

[xZer0x]

Yes you did ;)

[Jargs]

thanks for posting this war its great

[systm420]

ok, im having some trouble, im posting to alot of ones telling about how to make weps / gear, so wat happens is it gets an error about the value and something... but i tried on both navi and heidi, but i cant get it!!! :[ i started from scratch, made a new helm, but it never works, i would very much appreciate it if someone, anyone would post back with a word of help, willing to help me, because i am desperate for help... im having a streak of no reply's on everything ive ever posted to!!! plz plz plz plz plz plz plz reply!

[asvati]

all this lookes really great:), just one thing im wondering about, the percentage of dropping, i have 80x drop rate on my server, so if i put 1% there, will it really be 80%? or 1%?

[xxWARKILLxx]

all this lookes really great:), just one thing im wondering about, the percentage of dropping, i have 80x drop rate on my server, so if i put 1% there, will it really be 80%? or 1%?

Yes the 80% of your server will overrule the drop rate you put for the Item

AND as for systm420 what exactly does the error say? Are you sure you downloaded the Antrix batch File? and are you 100% sure the Entry ID is not already taken

[Silent-5]

:P very nice

[asvati]

Yes the 80% of your server will overrule the drop rate you put for the Item

AND as for systm420 what exactly does the error say? Are you sure you downloaded the Antrix batch File? and are you 100% sure the Entry ID is not already taken

thx m8, just tested it out now and it works like a charm :D
only thing that dosent work is to add the warglaives to illidan, i get this error:S, but that i thinks the reason the loot wasent added to repack on illidan in the first place :P

[insanesk8123]

I added custom drops to my custom boss, but when someone kills him he doesnt drop anything. Is it because the drop rate is 100% and my server is 40x drop rate. Heres my sql File that I uploaded to the server: INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "5000001", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000009", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000003", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000001", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000007", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000008", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000011", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000010", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000013", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000012", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000015", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000014", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "8888889", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000005", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000004", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000000", 100);

INSERT INTO creatureloot
(entryid, itemid, percentchance)
VALUES
("4000010", "60000006", 100);

[sdfgry]

i just blindly recomend you to split the percentage with 40?

[insanesk8123]

Ya, i lowered the percentage to 25% and it still doesn work.

P.S. Im using ac-web ultimate repack 5.9.5 with the items table from 5.8.2.

[nightmaster123]

ty for guide warkill cleared somethings up

[sfreedom]

i got an error saying unknown column name in field list

[Golepa]

Change it to name1

[sfreedom]

what do you mean by change to name1?

[Golepa]

Change the column 'name' to 'name1'

[imfamous08]

someone please make a tutorial for this with wow-v!

[Arcaj]

I keep getting an error saying
SQL Error: Unknown column 'name' in 'field list'

[bloodelf71]

I keep getting an error saying
SQL Error: Unknown column 'name' in 'field list'

same thing here thought it was just me but help maybe

[MissMurder]

How can I increase the money drop of a single creature? I know how to increase money drop for the entire game, but how to increase money drop for just 1 creep? I want to make a gold farming zone.

[lalalala]

I was just wondering. Is it possible to make items only usable for the highest gm rank? :) If possible please explain it in an easy way ;)

[costel_gabitu]

Umm I ge tthis error in both heidisql and navicat. I got a sql file from www.wow-v.com which is supposed to be frostmourne i did everything like u said but when i click on execute it says: SQL Error: Unknown column 'name' in 'field list'. Could this happen because the sql file is not "correct" or is it soemthing else?

[doublehex]

the sql does not work with the current database, wow-v has not updated their structure

[lalalala]

Ok. Here is what i did to fix the problem with the error. When you download your weapon save it on your desktop. open it with notepad. Seach for the line:
"INSERT INTO items (entry, class, subclass, field4, name, name2, name3" E.T.C

See the word "name" ? put in 1 after it so it looks like this: "INSERT INTO items (entry, class, subclass, field4, name1, name2, name3" E.T.C
Save and exit

then do as the guide explains. :)

[costel_gabitu]

hey thnx a lot u guys are k00l :D

[M3DIC911]

lol, the templates are very old, i think you copied from some forums, from a very old Post, i always forget Vendors Template so I used yours and saw
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(91000, "NAME", "GUILDNAME", 0, 4, 0, 3, 0, NULL, 19019, 1, 1, 1, 0);

INSERT INTO creature_proto
(entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss)
VALUES
(91000, 70, 120, 10000, 5000, 1, 4, 1000, 300, 400, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0);

INSERT INTO vendors
(vendorGuid, itemGuid, amount)
VALUES
("91000", "90057", 1);
^
i
That 1 is yours i where this is what i found wrong, :-
creature_name, it should be name
displayid it should be male_displayid
unk2 should be [unknown_float1[/code]

there is more, I gtg to make vendors laterxx, lol stop copying old work :D

[costel_gabitu]

ok here's something funny... ok i inserted the items. i modified as u said (lalalala) i got no error, i got this message: 1 row(s) affected. i restarted my server and i entered the game. i tried: .lookupitem frostmourne and it didnt find anything. so i tried: .additem 355750 (this is the item id i chose) and it said that it was an invalid id. i tried to import the item again but it said that the id was already taken. i tried some other items but same story. with one exception: i got quite angry so i created a 36 slot bag("The Endless Nothingness") :D, also with wow-v. and i imported the item manually. i went to the item table and clicked the plus and typed everything according to the sql file(i opened it with notepad)(with the name1 correction, of course). i restarted the server and the next thing i know: IT WORKED! could u pls tell me what to do cause i dont want to import items manually in the database(believe me: its way too damn tireing).
P.S. I found this cool program called AscentDBEditor. Its very cool. Easy to use for creating items and importing them to the database. Theres just one question... When I try to import the item i created to the database it gives me this error: "No databse specified." (or something familiar). I had to type the name of the database before connecteing to the server with the program but i skipped that. So: Whats the name of the database I want?

Umm... I think I solved the problem but I'm not sure. U guys pls just post some problem as i first stated it.

Lol i finnaly found the item in the datatabse but it doesent work in game. :((

[wareagle920]

(91000, "NAME", "GUILDNAME", 0, 4, 0, 3, 0, NULL, 19019, 1, 1, 1, 0);
after guildname change the 0 to a 128

[costel_gabitu]

Wait a sec. So u are saying that, for example, in this sql script:
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, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (355750,2,7,-1,"Frostmourne","Frostmourne","Frostmourne","Frostmourne",35575,5,0,0000,0000,17,-1,-1,80,80,0,0,0,0,0,0,0,1,1,0,4,100,7,200,5,150,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,597,896,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,4000,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"Hail to the king, baby!",0,0,0,0,0,1,1,0,0,0,0,120,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0);
After (Frostmourne","Frostmourne","Frostmourne","Frostmourne",35575,5,) there should be a 128?

[Golepa]

No, that's an item. You don't need to put 128. Only when you make an NPC.

[claus999]

whats with the space between frostmo urne??

[Golepa]

Typo ftl?

[costel_gabitu]

eh i typed it wrong
:D

[claus999]

not me..i wrote it exactly like on the first post on this page...the 4th frostmourne word is split in two...

EDIT:
lol..

[costel_gabitu]

k but any idea why this item dosent work ingame?

lol

[Golepa]

Anyways, there is 'npcflags' column in creature_names table. This is where you define your NPC type, whether you want it to be a trainer, fp master or just someone you can talk to.

Edit: It should work.

Edit2: *sigh*, I just check the ID. It cannot be above 200 000 due to restriction in Storage.h.. Burlex's fault.

[claus999]

costel have u tried restarting the server??

[costel_gabitu]

the thing with this item is that it is in the database but ingame it doesent work damn it.... in the game, its like it doesent even exist :(

[Golepa]

Anyways, there is 'npcflags' column in creature_names table. This is where you define your NPC type, whether you want it to be a trainer, fp master or just someone you can talk to.

Edit: It should work.

Edit2: *sigh*, I just check the ID. It cannot be above 200 000 due to restriction in Storage.h.. Burlex's fault.

And I quote my last post and the EDITS!!!!!!

[claus999]

as i said...tried restarting the server??(not re-installing..just shut it down and start it up again)

oh yeah forgot bout the 200000 entry id cap..lol

Costel change the entry id to something below 200000 and restart server and it should work

i think this is typoday..i made like a million typos when typing these things..

[costel_gabitu]

yeah o retsarted the server way too many times...

[Golepa]

O-h-m-y-g-o-d!

Read my second edit please.

The ID of your weapon CANNOT BE ABOVE 200 000!

[costel_gabitu]

sorrry golepa i didnt see your post i didnt refreh the page :D

and thnx

+rep golepa :D

[532edge]

hmm, i have read what problems people are having and some have this one, iv created it and out it in my DB and i have my Entry ID under 1`000`000
But i loggin and do .additem xxxxx but it says its a invalid item...i tryed reloading the tables ingame but it jus says Error reloading...Can anyone help me? and dont post L2r or "its called the search engine..." cause thats getting irritating...-.-

[claus999]

not 1000000 but 200000 there is a big difference between 1 million and two hundred thousand...

[costel_gabitu]

ummm it is under 1 000 000 but is it above 200 000 too?

umm yeah./.. god i hate this refresh thingy

[claus999]

ummm it is under 1 000 000 but is it above 200 000 too?

umm yeah./.. god i hate this refresh thingy


lolz

[costel_gabitu]

as i said...tried restarting the server??(not re-installing..just shut it down and start it up again)

lol im not that mindless

[claus999]

i didnt say u were mindless -.-

[Golepa]

So.. About that number guy. Is his weapon ID above or below 200 000? o_O

[532edge]

Nvm i got it working, lol iv made so many custom weapons :DD

[deathwalker123]

yhea can someone please make a video or something with this that would help alot to see our mistakes and whatnot becuase i belive ive got the querey thing down i just dont get the item in game at all when i do .additem "id"

what do i do when i hit run using navicat and this message appears "affected rows: 1 time: 0.002ms" is that good and then how do i make sure the weapon is on the server?

[costel_gabitu]

ok im not sure i can make u a video... but anyway, what id did u choose or where did u get the sql file? and btw, when u get that messsage it means that the item was inserted in the database succesfully and u can exit navicat, restart the server and it should work ingame. if ".additem ID" doesent work u should also try ".lookupitem item_name"(or a part of the item's name). but u have to tell me the id u chose for the item, it quite important. :D

[deathwalker123]

the item name id is 9920714

okay i used this weapon with teh id of 47409 and when i did .additem it said item 47409 is not a valid item what do i do from there is tehre a way to make it at all and what is antrix i had to move the tables from ascent folder to antrix but it worked so whatever

hey okay i got it workin but... where am i supposed to find the display id for the npcs there no XML on wow.allhakazam for some reason when i chose which npc i want it to look like for expamle like the silvermoon paladin trainer i cant find a display id what im trying to do is make a vendor to put on .recall port gm1 where other gms can buy costum weapons from thsi vendor and normal players cant

[costel_gabitu]

put your target on a npc and type: .npc info. u will get a lot of info about your target ( including the display id) :D

[Necrofrost]

Yeah... i dont have an antrix folder in my navicat. = /

[clown1337]

So Amazing Thank You So Much!

[Manstein]

Somehow this isn't working when I'm using the 7.4 repack, but works with the older versions :S

[TexArmPall]

the code im using is

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, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (MUSTHAVEENTRYID,4,2,-1,"Azerrotian God Helmet","Azerrotian God Helmet","Azerrotian God Helmet","Azerrotian God Helmet",17226,6,0,200000000,300000000,1,-1,-1,999,240,0,0,0,0,0,0,0,1,1,0, 1,200, 3,300, 4,300, 5,300, 7,300, 32,300, 13,300, 6,300, 28,200, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19869,150,150,15 0,150,150,150,0,0,0,0,0,0,0,0,0,18060,1,0,0,0,0,18 060,1,0,0,0,0,35844,1,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,-1,0,0,0,200,0,20000,0,0,0,0,8,0,4,0,2,0,2874,0,0,0 ,0);



and the error is

/* SQL Error: Table 'mysql.items' doesn't exist */

what do i do?

[flarg]

ehy can u help me with something? a problem with making a creature i open the creature_names table and it gives me this error Unknown Colomns 'mouseFlags' in 'Where clause' this hasnt happened in the last repack

[Necrofrost]

umm.... i cant find antrix. i m using free trial navi.