[cooper101]

Hello, I will show you how to make and put them into your privater server useing navicat and heidlSQL. I will try and make it as noob freindly as I can. Hope you enjoy! P.S Start your server up make sure its running

Making your item

First thing you'll need to do is pick out what you want your item to look like. So head on over to [Only registered and activated users can see links. ] and just look for a item that you want your item to look like.

I chose this axe for my what i want my item to look like.
http://www.picattic.com/files/8dv8zw8ufue3hc9wvmyd.jpg

Now once you have what you want yout item to look like copy and paste the name of that item. Then head over to [Only registered and activated users can see links. ] and type in the name of your item and hit search. Next click view XML for your item.

Should look like this:
http://www.picattic.com/files/ei49b4g2c0boiqnunrl6.jpg

Once you click view XML you will see a new page with a bunch of numbers. Look for this

<texture id="####"

Copy the number in there.

Should look like this:
http://www.picattic.com/files/aq7lrz3ysl1efx9o7not.jpg

Once you copy the number you go to [Only registered and activated users can see links. ] and create an account. Once you have an account created an account you click create item.

Should look like this:
http://img180.imageshack.us/img180/4229/pic4ya3.jpg

Once you click create item you will see all those blanks just fill them in with anything you want its your item. But when you get to the blank that says display id take the number that i asked you to copy earlyer and paste it here. Next where it says entery# put what ever number you want in there make sure you remeber it cause this will be the number to spawn your item in-game.

Adding your item

Ok once your done click submit. Then 2 boxes should pop up under it.

Should look like this:
http://img255.imageshack.us/img255/3510/pic5fu6.jpg

Ok now is the part where you put your item into your server. Ok first if you have HeidlSQL all you'll need to do is copy all of the text in the first box then open HeidlSQL and go into ascent database and click on query and paste what you just copyed and hit F9 if it says something like "the item number is a double" then you have to go back to [Only registered and activated users can see links. ] in weapon vendor where your weapon is at and change the entery# to something different. After you run it congratz your done

Should look like this:
http://img255.imageshack.us/img255/6260/pic6jl6.jpg

Now for Navicat when your at this screen.

Should look like this:
http://img255.imageshack.us/img255/3510/pic5fu6.jpg

Click on download batch file. Once download load up Navicat once in there log in your database and right click it and click execute batch files and find the file that you just download load it up and your done congratz you just made your first weapon!

For any Questions pls feel free to msn, aim me I'm online 24/7 but i may be afk so just leave a message ill get back to you asap.

AIM:coopercoop599
MSN:[Only registered and activated users can see links. ]
or just send me a private message on here.

Thanks and remember to +rep people tha helped you XD.

[cooper101]

38 veiws no comments..

[not627]

You could also use [Only registered and activated users can see links. ], but it will make it too complicated

[Overkillbc]

When I execute batch file with Navicat and hit "Start" it somes up with an error saying... "unknown column 'no' in 'field list'.

What exactly does that mean?

[piree]

When I execute batch file I get Finished - Unsuccesfull.
[Err] 1062 - Duplicate entry '33333' for key 1
And tryed other entrys but always got the error.
What to do? If you can fix this +rep

[mordaren92]

can some one help im running a classic wow server, some old verision of mangos. I cant get conection with HeidiSQL it just says like:SQL error Host "Philip" Is not alowed to ente mysql bla bla bla...
can some one help me get it to work plz

[Viter]

dude i can tell you, you got spyware and virus on your computer.
Look at your toolbar's
mywebsearch=WORST SPYWARE CRAP EVER

[mordaren92]

its ok now i fixed it but now i get the messege when im going to inport my wep in to db it just says "acsent_world.items doesnt exist :/ help plz

[drdestructo222]

thanks a lot man! helped me out tons! +rep

[babati]

very nice guide +rep

[tromboneguy007]

Originally Posted by piree

When I execute batch file I get Finished - Unsuccesfull.
[Err] 1062 - Duplicate entry '33333' for key 1
And tryed other entrys but always got the error.
What to do? If you can fix this +rep

I have found that with errors like this you need to select the other export option. There are 2, for Antrix/Ascent, on the site:

1. Compatible Core Builds: Rev1 - Current

2. Compatible Core Builds: Antrix - Rev1

If you have a newer version of the server you should use the top one. Also, make sure you delete any entries you received errors with.

Hope that helps.

[G4rry]

Originally Posted by Viter

dude i can tell you, you got spyware and virus on your computer.
Look at your toolbar's
mywebsearch=WORST SPYWARE CRAP EVER

QFT

Lol, you can barely see his screen.