Making Custom Items

[Clain]

Im going to be showing you how to make custom gear today.

1. Go to http://wow-v.com/ and register.
2. Then go to tools and select the item you want to create.
3. After that make the desired item you want and save the sql file it gives you.
4. Open up your database and find "Query".
5. Click on "new query" and then click on load.
6. Select the sql file you just downloaded. Then click on Run and it executes the file adding it into your database.
7. Then just reload your items table by doing .reload items or restart your server.
------------------------------------------------------------------------------------------------------------------
1. The other way to add it into the database (usually for larger sqls) right click on your ascent database
2. Click lick on "execute batch file"
3. ...Select the sql file and it executes it adding it into your database.


Questions/Problems/Common sense statements.

Where do i save the sql to?
Answer: anywhere...

When i connect to my database it says "Cannot connect to Mysql server on localhost.
Solution: Make sure mysql is running.

What is sql?
Answer:SQL is a standard interactive and programming language for getting information from and updating a database.

Why am i getting errors while executing the sql file?
Answer: You probally need to update the query.

How do i open my database?
Answer: install navicat,heidisql,etc. and go to connections and enter root as your username, with ascent as your password.

uhmm i think thats all the questions ppl sent me in pms today lol.

[toxic11b]

WOW V ? bah =D dont forget about

http://www.ascentemu.com/forums/index.php?showtopic=1936

The best tool you can have.

[Clain]

lol says link is broken or out of date

But can i get a odwnload link for it?

[toxic11b]

Umm thats odd. Im looking at the site now. Ok ill post the link for DD but im going to have to put little more info. I dont want people to think i made it lol blah blah.


Anways this was made by vbCrLf at AscentEmu here is a little more info for it. It has a tons more on the thread it was posted on but Im not going to copy and paste all of that lmao


Features:
Complete NPC editing/adding.
Complete item editing/adding.
Complete quest editing/adding.
No need to know IDs of NPCs, items, quests, bonuses, etc.
Option to log the queries (for making patches).



http://filebeam.com/dab537849de89ec60450350e4124bb79


EDIT: he updates it alot so if the post works for anyone else there is the link

http://www.ascentemu.com/forums/index.php?showtopic=1936

[Clain]

Thanks a lot for the link man. Ascentemu + my comp = wrong lol. on my comp all you get is errors and problems on that site.

[wareagle920]

i know man

[Clain]

lol last time it wouldn't let me see the forums because it said there werent any (ya i was logged on) i just about threw my damn computer out the window lol

[skorn94]

i cant find query

[doublehex]

query for what? wow-v? thats down at the bottem

[Clain]

Skorn what program are you using to manage your database? navicat?

[skorn94]

no im using MySQL

[kolklik]

duh.. yes ofcos you are, but what program are you useing to open it so you can see your database ;)? heidisql?

[skorn94]

well i think im using heidisql to manage it but i cant check atm cuz im out of town

[Clain]

Still having trouble with it skorn?

[Grim547]

When i try to use Mysql it wont connect so i used heidlsq or w.e and it wont connect either will any1 help me out, i wanna use custom itesm but i cant add to my server

When i try to use Mysql it wont connect so i used heidlsq or w.e and it wont connect either will any1 help me out, i wanna use custom itesm but i cant add to my server

[Clain]

When i try to use Mysql it wont connect? what do you mean

[Grim547]

well. ill tell word for word..
this is for heidiSqil:
Could not establish connection!Details:
SQL Error: Can't connect to MySQL server on '127.0.0.1' (10061)

[Clain]

Make sure mysql is runnign while connecting to your database.

[Grim547]

Well i just got my heidisql to work but now im not shure what i do. i renamed the file so now that one connected but how do i add my item to the server?

[Clain]

did you even read the guide...

open up your database and find "Query". Click on "new query" and then press on load. Select the sql file you just downloaded. Then click on Run and it executes the file adding it into your database. Then just reload your items table or restart your server. The other way to add it into the database (usually for larger sqls) right click on your ascent database and click on "execute batch file"...select the sql file and it executes it adding it into your database.
geez lol.

[Grim547]

well ive gotten up to the "execute part" i cannot find "execute" anywhere is it auto-matic or sumthing

-- sorry im so noobish lol

[Remus]

(8) Field 'auras' doesn't have a default value-- from the DBEditor... anyone know why? field 8 is rank in creature names-- was trying to make a new npc

[Clain]

not sure aerthom, i dont really use that dbe editor =D. and for grim. right click on the ascent database..it gives you a list of options...and one of them is execute batch file, click on it and select the file you downloaded. that or do it the other way were you make a new query

[Hazeno]

well ive gotten up to the "execute part" i cannot find "execute" anywhere is it auto-matic or sumthing

-- sorry im so noobish lol

Mate i learnt this yesterday - and took the best part of a few hours without the help of others.

Can i ask what your using to edit your DB using. I use navcat as its very easy to use. If you ARE using navicat then open your database up - remeber to open the mySQL using the Repack Control panel. Then cdouble click ASCENT - then right click ascent and find EXECUTE BATCH FILE. From here there will be a box saying

FILE roughly half way down the 3 inch diag. CLick the button with 3 full stops in [...] looks like that - and find the batch file you want to add . Then click start. It SHOULD post thats its successful clearly. now retart your server and log into WoW and use .additem <ID you gave the item> and it will appear in your invent.

[Grim547]

Well i figured it out ... execute was the blue > (didnt realise)
Now i got all this l33t gear, Btw. is there a teleport command to go anywhere cause all i find when i search for gm commands for teleport is liek .. .recall port gmisl and i dont know any others to tele.

[Clain]

do .recall list, but something is wrong with it so it wont work

[Grim547]

yea thats what ive been noticing it just repeates it back to me..

well i just made some new items now i try to get on my server.. no server on the list. so i restart all the programs and stuff, now when i start the realm server program it wont work it says one or more errors so i think that might be why i cant find my server but i dont know what happened i was on it 5 mins before this happened

[Clain]

you dont even need to start the realmserver. and making custom items could not mess the server up in anyway

[joelberg]

DUDE WoW-v crashes your Db -.- tried it sevral times today ....needed to reinstall 7.3 over 10 times ! .....i am getting crash dumps all the time lol!

and now when i try to add thunderfury and others it says it's not a valid id.....can you tell me why that is?

omg.....tell my why? i only inser the code it shouldn't make crash dumps! ......omfg....i'm tired of this shit + if i make stuff in heidiSQL i cannot use them...if anyone got a help suggestion about wow-v items then tell me.....i need help with it .......crash dumps and my vendors + i cannot add items are fucked up............anyone can help me?

my whole db is fucked up now yay :) i love wow-v stuff :) this happend to me 10 times!

[Clain]

the things you make from wow-v don't crash your database unless you like make a weapon witht he icon of a mount. and ive noticed on other servers that when you make custom content it says invalid id. i honestly have no clue whats wrong, but i doubt its the custom items.

[Grim547]

Yea my servers working now i wasnt leaving the commands up for long before i started wow... also no.. the wowv dosent mess ur DB ive made liek 20 items and they all work, u just need the right display id dont make a sword with an icon of a shield liek clain said

[joelberg]

omg.....i meant that i made and item and when i add the id it's says another id and it's not valid and there is not an item in the db but still i inserted it! ......do you understand? + everytime i reload items i get crashdumps........+ i got the items working for like 10 mins then i made a new one and it got fucked up.....getting tired of this shit

omg....i got the right displayids i know what that is -.-

my whole db in items are crashed fuck again......

gOD DAMNIT! .....again a crashdump when i try to reload......

god damnit still no sign of life in my items db -.- ....ffs......jargs could you help us with some scripting for the new repack so execute items from wow-v will be easier or something? :Por make a guide out of howto make custom items in heidiSQL

god damnit this is stupid i'l wait til tommorow .....see you guys lol

[Remus]

dude. heidisql is same as navicat just free. same for sqlyog. .. and there is no way EVER if done right will wow-v item crash your server; the only way is that u fucked up on your display id's while typing them in on wow-v or manual thru heidi and your trying to spawn a damn weapon that aint display of a weapon. gosh aint that hard if your going to post make the posts halfway coherent, if nothing seems to fix your server.. there is always the last option DELETE EVERYTHING and start it new, yeah it sucks iv done it 3 times. but now my server works just fine. quit posting crap messages with out anyway fopr us to attempt to figure it out. think before you type. and try looking into things. common sense here.

I pity the fool

[chua]

ok ive made my items in wow-v and i downloaded the batch files and then i open it. Then when i try to execute it with the blue button, it says "SQL Error: Unknown column 'name' in 'field list'. " PLEASE CAN ANYONE HELP!!!

[Clain]

CHange name to name1

[NightmareGamer]

whoaaa i am REALLY Confused >.<

save the sql file it gives you, open up your database and find "Query". Click on "new query" and then press on load. Select the sql file you just downloaded. Then click on Run and it executes the file adding it into your database. Then just reload your items table or restart your server. The other way to add it into the database (usually for larger sqls) right click on your ascent database and click on "execute batch file"...select the sql file and it executes it adding it into your database.

yeah umm...What? o.O

[sgtk01]

is there any way that i can make it so other people can create items on my server?

[Clain]

Ya tell em to go to Wow-v.com and make the sql, then they email you the file

[yook]

i get eror 1054 - unknown colum "name1" in "field list"

can you help me please?

ok i made it :-)

[Rockyroad]

I can't get the site to do allow me to make what I want. Says the item is to "godly" and won't let me save it and if I did I get banned for making it. I mean is it so wrong for a GM to have a legendary item? It wasn't even that "godly"!

[Clain]

Yook, change name1 to name.

Rocky, thats the option to save the item to their item database. I suggest not doing that if your going to release an item pack or something. just save the sql file, not save it to the database. They were tired of people making items with stats of like +999999999 agility, +48539239 spell crit, etc so they removed the option to save god items to their database. you dont want to do this because you just want to save the sql to your desktop not their database

[yook]

clain is ther some easyer way to change name1 to name if i have more files then to change 1 by 1?

1 more thing when i try to get in my database some file i got from internet i get colum "mapid" cant be null what i need to do with this?

is there way not to edit this files i download from internet by using some other program to add them to my database i am using Navicat for MySQL now

[Clain]

no, what database are you using to manage your database though? because some people use name instead of name1 and the other way around.

change "null" to 0.

theres the DBE, search the forums for it

[yook]

i am using Navicat for MySQL and HeidiSQL this for now but will look for DBE now. thx m8

[Gnoppy]

Why does it say

" 1146 - Table 'logon.items' doesn't exist" What do i do?

[Clain]

execute the file in your ASCENT database not logon ^^.

[Gnoppy]

what you mean?

[Clain]

it said logon.items doesnt exist because you executed the file in the wrong database, do it in your ascent one not logon

[Gnoppy]

Okay now i rly need help ?

Aint got any pics of how i should get it in the ascent database?

[Marren]

http://img265.imageshack.us/img265/4387/ascentjx0.jpg (Executing in Ascent database in Navicat screenshot.)

Like that. Then you click 'Execute Batch File', you browse to the file and voilÃ*.

[Clain]

ok look gnoppy, right click no the database called "Ascent" and click on "Execute Batch file" then select the sql fiel you downloaded...your right clicking on your "Logon" database. btw that link doesnt work

[derac]

Hey a questoin how do i restart my server

and when i added my weapon my server is offline

[wareagle920]

restart it by closing the ascent.exe and logonserver.exe files that popped up when you started it and then go to control panel and launch server

[derac]

ok thanx i tired

.reload items and it DCed me

also when i did the control panel thing it said on the acsent windo it say
Main database instalzation failed. exiting

idk why

[Clain]

is mysql running? and you probaly didnt make the item right. for example, makin a sword that shoots bullets

[derac]

first step remake the item

then Luanch the server again

then open Mysql

then import it in

there than restart it by closeing the ascent and the logon window

then click luanch server again
\


FYI When i made the weapon on www.wow-v.com and u clicked submit to make my weapon i used the first download!

[Jaybird]

K, im using Heidi SQL, i hav all my items saved in it, saved as in all i do is type name in search, there they are, its a whole item set. Trinks., rings, neck, tabard, shirt, armor, weps, the whole shabang. Wat im having a problem with is that i type the additem code: 7000000, and it says Invalid Item. I know I dont hav something like a sword that shoots bullets. Can anybody help, and has there been an update for Heidi SQL in the last 3-6 months, cause about that long ago is the last time i tried to make items and server. I forgot almost everyting except all the commands. So is it me, the version of Heidi, or just something no one can deal with. And when i use Navicat Lite, it comes up with an error, and says: Duplicate entry '7000000' for key 1. I want an explanation for Heidi first since that wat im using at the moment. For Navicat Lite, save it for if i get a explanation failure of Heidi, but if the explabnation for Heidi is successful, ill post it, and just forget Navicat Lite. Im saying this because i hate it when u wait for 1 explanation and then get the other, u completely forget, and u hav no clue wat they talking about.

Sorry for long post, just been searching many frikin sites and not one success.

Jaybird

[Clain]

You cant go over the id of 200000

[cruiser101]

is mysql running? and you probaly didnt make the item right. for example, makin a sword that shoots bullets That would be friggen sweet though wouldnt it

[Jaybird]

You cant go over the id of 200000

-.- UVE GOT TO BE FRIKIN KIDDING ME, I SPENT LIKE 2 WEEKS AND SOMEONE GIVES ME AN ANSWER I WOULD NEVER EXPECT. I FEEL LIKE SUCH A NOOB RIGHT NOW. CAN I RECORD SHOOTING MYSELF AND PUT IT ON THIS SITE? jk, srry for caps, just realized i was using them. The first sentence was caps tho. :P

[saro10]

when i try to make it it comes up with unkown column name in field list

could someone help?

[Symplexity]

it says item 55552 is not a valid item

this is my query:
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 (55552,1,0,-1,'Admin Bag','Admin Bag','Admin Bag','Admin Bag',32830,5,0,4444444,00000,18,-1,-1,58,70,0,0,0,0,0,0,0,0,0,36, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,2,'Admin Bag of Truth',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0);

[innax]

nice ty:D

[maximus1643]

1. Go to http://wow-v.com/ and register.
2. Then go to tools and select the item you want to create.
3. After that make the desired item you want and save the sql file it gives you.
4. Open up your database and find "Query".
5. Click on "new query" and then click on load.
6. Select the sql file you just downloaded. Then click on Run and it executes the file adding it into your database.
7. Then just reload your items table by doing .reload items or restart your server.


I have tried this method. I screwed up somewhere on the WoW-V thing..cause now my melee weapon is a bow lol..looks pretty funny though..walking up to a bow and hitting him with my bow. Anyway the information of the icon...the graphic when mouse over doesn't change. Only thing that changed on the item was the durability. You don't see for example :Name of bow "the bastards bow" or it's effects or anything. Please assist..i want it to show my own custom names, it's effects and attributes.

I'm using the latest rev pack 7.5 and navicat. and from the WoW-v site i constructed my weapon and downloaded the batch...then did the query thing and loaded and ran the batch it gave me. The effects are there...but do not show on the image of the icon when mouse over on the item.

[Clain]

Delete your cache and database cache (for database cache restart your server the proper way, dont just close ascent)

[maximus1643]

how do i go about doing this Clain? I've opened the mysql in the /server folder. I've gone into my WoW folder cache folder and deleted the cached stuff. where do i go to delete the database cache?

EDIT: nevermind i figured it out ^-^

[sliklas]

where is the '' new quary'' button??!!

[Apachawee]

i made a custom weapon but i cant get it to download on my sql...it keeps saying error after error and when i click on my query theres just the intro information and the value information...wat do i do from there

[Sephira]

OMFG!!!!

is it NEW query u must click? no wonder i havent managed to create items
^^

[antmanzero]

can i get a link to navicat?

[Shanak]

use http://www.navicat.com/download/navicat8_mysql_en.exe