creating custom items

[PenguinBG]

30732

[ShadowKiinGz]

nice vid

lol msn xD wrong time

[stalkersas]

make a wand into a 2h mace hahahahahahah

thx for the help ^^

[Palaund]

omegawow(dot)csmsites(dot)com - non hamachi - 3.0.9 - join

[TwistinFool]

I mean 'unknown table item in information scheme'

[boredXyetXamused]

if you didnt get a answear put it in items i forgot which one exactly i deleteted WoW as of trying to update it at all that good stuff

[TwistinFool]

When I press the little blue button, a message comes up saying 'unknown column name in field list'..can anyone tell me whats up?

[hallofaxxes]

ya it is

[alexkid900]

is this for wow?

[iuseevisu]

pleaes help a work to click on the play buttom when i click it pop upsql error ukown colour name in field list. please can someone help me?

[MusicalJukeBox]

Keeps giving me invalid item in game...

[liberator48]

me too, i did exactly what he said and tried both navicat lite and heidisql...

[liberator48]

can it be cos i got 2.4.3? or ascent? but ascent and antrix is the same... still i tried many times on both navicat and heidisql, all works well until i try to add it ingame it can't find the item

[dannyp224433]

XD 8675309

[ripleyftw]

TYVM XD for this vid

[ripleyftw]

i got AC-WEB ultimate repack thing were cna i get the 2nd program thing xD the my SQL

[ripleyftw]

i mean Hedisql thingey xD

[ripleyftw]

XD found it

[XJoachim2kX]

to me it says valid item.. :(

[Kuzzy78]

lol ur msn

[hallofaxxes]

navicat

[SirGumfox]

what the last program called

[Thehelperhaha]

dude this is the best video on how to do this

[osha123456789]

Well ty :D worked perfectly for me

[teChDr4g0n]

90% of all wep tutorials dont work because you people DONT follow the instructions EXSACTLY

[adriaantje113]

Hey, when i load i get: /* SQL Error: Unknown column 'name' in 'field list' */

[cooladeguy]

i am getting the same problem. it says Unknown column 'name' in 'field list' */. Ive tried taking that out but then it completely doesnt work. can somebody help.

[ghostly202]

I can, Its because your item is too big, you have limits though.. try to decrease the stats

[poolsuporter]

I use ascent, but I can't import in navicat..

the error message is something like this:

[Err] 1062 - Duplicate entry '35075' for key 1

[Msg] Finished - Unsuccessfully

Help!

[parkside11]

i get an error when i execute the batch file and this is what it is.Error at query 1: Unknown column 'ExtendedCost' in 'field list'

[FlashySenap]

I've done this and all I get is errors

[deathknight53]

damn guys how can I connect to the database?? I very need it

[DutchWolfey]

use HeidiSQL

[PurpleMan28]

how do you connect to the database or even use sql, i cant figure it out!!!

[magicoone]

are you msn

[iRteddy]

Well I have a slight problem. Everything goes fine untill he does something with the other program.. Not HeidiSQL, but theres something he uses in the end, can You like help me out with that ? And it was well done tutorial =)

[pstavola]

the last program was for ppl who are using navicat. if you are using heidi, you dont need navicat. its the same thing

[dalhaka]

the weapon wont appear untill after youve restarted your server

[dalhaka]

1) if you cannot connnect to the SQL then restat your server

2) you dont need to put in any info(its already has it)

3)You CANNOT be connect to your server wheil doin this

[dalhaka]

this video tells you nothing!

[pstavola]

actually this video tells you exactly what to do if you DON'T want to go into your actual database and making a weapon

[Larasfriend]

You're blind m8 :]

[yellerbelly123456]

Works :D Thx See u on the fourms Nate :D

[michaelbo121]

how do you do this in Navicat?

[ingetejuledigt]

i dont even got the thing he put the things in ;S its other verision of mine maybe .?

[blacksheep38]

help me plz what did u have as your description and host/ip name, User and pass, your port num and timeout.

so very very sorry for all the question its just i kant read it and then i should be good to go

[ishoke]

It Says Error when i try to Coneect why? i would like some help Please thx Great Video By the Way

[skaterboi1246]

ikd what u guys are talking about it works fine for me

[ishoke]

SkaterBoi tell me howto connect to HeidiSQL plz idk How to

[Tatertot300spartans]

nvm

[Tatertot300spartans]

HELP i accidentaly rename my column for items to my item number!!!!! what wuz the original 1?

[Natamus09]

Good News - I got HeidiSQL and followed your vid.

Bad News - I created my first item (following your vid) and it crashed my server, deleted all my items, chars, other people chars....

Solution: You telling me how to fix this..

[ThatMartinKid]

well it seems to work fine for most ppl just ur a noob who cant follow a Video tut

pfft ediot

[Natamus09]

Hey, Great vid. One problem, can you post me a link so I can get MySQL or somthing? Because I dont have it for seome reason but I have my own server. Thanks

[wizzkiller92]

do you have to restart your server after you'r done?

[pstavola]

yes

[wizzkiller92]

thnx but i knew it already by now :P

[pstavola]

lol ok

[Swrtzjstn12]

why does it say duplicate 123456 for key one

[Swrtzjstn12]

when i create a weapon it says DO NOT SAVE YOUR ITEM if the icon below is not what you were trying to make (ie: an icon of a helmet when you were making a sword).

It will be deleted, you will be suspended, and if you use the item it will crash your server

[emoninja143]

you can not i repeat CAN NOT have ur number biger thatn 200k

[basketballman33]

yes u can...server im gm on had a weapon with an id of 9999997

[EszuGlitchtean]

dude i do everytin u say and my entry code was 1337609 and when i whent into came and did .additem 1337609 it said item not found =( help please

[stinkovideo]

how do i make a vendor for the custom items though?

[wizzkiller92]

you need to add the item into the vendor like: .npc addvendoritem just look in your command list for it

[babablksheep]

Oh also its almost the same thing for mangos... It's just get the mangos batch file

[babablksheep]

Thank you very much, very useful :)

[ipazo93]

well wow-v doesn't work so well since 6.5 :P.......only getting crashdumps when i reload tables :( really annoying :P

[SGCBoneCracker]

ive made my weapon and everything i add it on my server i wield it i att somethin and miss and thats it my skills r 1275 and everything.wat am i doin wrong?

[Vores398]

and when i hit the little arrow it says no database selected

[Vores398]

hey saw ur thing on acweb replay to this please but when u do heidisql what did u type to get into the database like for user and password

[natev101]

i might make a mangos version later on

[yellerbelly123456]

makea mangos vertion and ill love you ^^ im tryin to findea mangos vertion!

[Adobetube555]

great vid. very helpful

[s0utht0wnjr]

You dumbass... It's for ANTRIX!!! HE SAID IT IN THE VID!!!... LIKE 5 TIMES! LISTEN TO THE FUCKING THING!!!

[radaideh]

yes hi can u reply to this mesage umm im getting a sql errorr in colum list i click the blue button and then it says sql errorr colum list.. plz help!

[Malevolent111]

I tried this and when I get to the very last step where you execute the SQL I get a error table: mangos.items does not exist :(

[Ipazo]

i didn't mean like that -.- .......and why can't i get my batch files into the new 6.7 repack? and why is my item tables gone but it's still there =/ it doesn't display it in the DB =/ i am confused

[Tobzies700]

hi m8 just one problem, when i try to execute the batch file it comes up wiht the error saying' unkown column name' in 'field list'???? plz help

[pstavola]

instead of downloading the batch file...u can just copy the entire file and in heidisql's item tab...go to sql query and paste it...then click the start symbol

[Ipazo]

emh.....does this work with navicat to....?

[pstavola]

yes it sure does

[miro8888]

there is problem guys i dont know how to create the HeidiSQL conection and where is the DB map :S

[pstavola]

if u wanna connect to HEIDI u need to have MySql running

[miro8888]

ty pstavola

[pstavola]

np anytime :D

[darklorddaniel1]

Hey nate, i got everything workin with HeidiSQL but when i try to do .additem, it just creates a blank item with my set durability and nothing else. please Help!!

[moniker127]

It worked! For my first item, I made a true hanzo sword, using the skin from that crummy level 52 one, with the quote "Bitch, you have no future..."

Thanks nate. I swear to god if you hadnt said your name I would've thought you were my old high school budd tony.

[RaoulNL1]

Thanks alot! Helped alot! Very easy, the lazy way :P

[kefboy1994]

nice vid, what sql file r u running for ur databse on heidiSQL?

[Gilgamesh827]

Great video. Thanks lilnate22!

[systm420]

alright, i got my item created, i saved it, but when i try to load the batch, it just says that the column count is not the same as the value or something like that... please help someone!!! i was sooooooo close... but now *sigh*

[systm420]

ok ok ok, now i got into sql, but i try to load it at the end, but it says column count dosent match! :[ i was soo close

[systm420]

alright, good video... but im having problems with heidiSQL, i cant connect..

[pstavola]

lol...loads of ppl having problems with this...if u want to run your database...u need to have MySql running

[pstavola]

have to have mySQL running