How to make/add custom items to your Private server

[redmjc67]

I love how people leave these comments without looking at the date the video was released. This was 2 years ago you Insolent Pricks.

[deadlypkers6]

@redmjc67 dosn't matter how old it is, it is still a video. just recomentate over the video and talk louder. and i agree with ruller might be better if you talked clearer because i have my earphones on full blast i can hear pretty good just the words arent forming clearly

[PintaSeventySeven]

l2talk

[jakenscott4eva]

LOVE THE SONG!

[666VersionsOfTom]

Can any one help me please? When ever I try to save my item to the database I keep getting this error... Unknown column 'StatsCount' in 'field list'... Any one know how to fix? :D

[redmjc67]

@666VersionsOfTom What kind of database are you using?

[ArcanePower1000]

@666VersionsOfTom Save the file in your world database -->items template

Use HediSql acount : root password ; ascent

create your custom items in wow-v.com , but DO NOT use " ' " <---- that , in items name or anyware .

[ruller383]

wtf are you speaking something else besides english? speak up......

[redmjc67]

@ruller383 you do realize that this is 2 years old right?

[ruller383]

@redmjc67 idc how old it is bro... speak up i couldn't hear you...

[redmjc67]

@ruller383 well then thats just unfortunenent for you. Maybe get better speakers or a hearing aid.

[ruller383]

@redmjc67 listen to yourself in the vid a few more times...... you`ll understand what im talking about then, also read your comments before you respond to this -.-

[theblackcuriass]

@redmjc67 i can hear just fine lol but u shuld try to speak more clearly

[eatyourfaceftw]

@redmjc67 NO ONE CAN HEAR YOU

[colll78]

@redmjc67 weired voice bro... but lifes full of differences...

[PrimaryCrash]

ha ha UR VOICE WAS HIGH lol glad its not now

[redmjc67]

@PrimaryCrash ha, i didn't even realize how high it was till now.

[PrimaryCrash]

@redmjc67 lol its been a year Fail :D

[KICKABS6]

wow speak the fuck up i could not even her ur little ass voice

[halo3godfilmers]

finaly a great song is played on yt

[redmjc67]

@halo3godfilmers thanks for the support in music :P

[cjwalshr20]

@halo3godfilmers tru dat

[littlepink28]

make new video please

[popryan123456789]

wth can you speak better i cant hear much

[redmjc67]

sorry this is an old video I'll make a new one sometime

[Yblek14]

I mean the ArcEmu ones. Both of them say the same error... in fact, all of those downloads say the same error. Pissing me off.

[redmjc67]

@Yblek14 i don't know then, make a post on the forums about it

[Yblek14]

I tried both.

[Yblek14]

Ok... rev 2986

[redmjc67]

@Yblek14 and which one are you downloading from the wow-v site?

[Yblek14]

What's revision? Sorry, I just started this server because my last one crashed... My brother started the last one and knew how everything works because he's a blizzard employee... So what's revision? :)

[Yblek14]

Yeah... but I can't seem to get it to work. I took out "name2" and now it says, "Column count doesn't match value count at row 1".... ???

[redmjc67]

@Yblek14 What revision are you using?

[Yblek14]

Hey i keep getting a "SQL Error: Unknown column 'name2' in 'field list'" Any ideas?

[redmjc67]

@Yblek14 Are you downloading the right file?

[hampen421]

Fusion Arcemu 3.2.2

[redmjc67]

yeah, i really don't know what to do then, make a thread on the Server Core Forums on WoW-V

[hampen421]

Dosent Work dude this is making my brane burn up

[redmjc67]

what repack are you using?

[hampen421]

Dont Know But i think i made it 3 sec i will test

[hampen421]

well it says ArcEmu on the File when its down by the start thing

[redmjc67]

make a thread on WoW-V then. Include the SQL and the Error

[hampen421]

i do that dosen work

[redmjc67]

are you sure your using an ArcEmu repack?

[hampen421]

i have rev 2677

[redmjc67]

alright, go to your wow-v profile and go to the item you want to download. then Download the ArcEmu<2801 then try again

[redmjc67]

hang on, i'll make a tut on how to find out what revision your using

[redmjc67]

what rev?

[redmjc67]

no, like

ArcEmu

MaNGos

Ascent

[redmjc67]

what core are you using?

[redmjc67]

alright, 1. Download the SQL again 2. in the downloads pop up, right click it and click Open Containing Folder 3. move the SQL file from that folder to your desktop 4. open HeidiSql and go to import sql 5. go to desktop and look for the sql 6. open the sql 7. the sql should be right there on the text input thing 8. press f9 9. restart server 10. add the item to yourself 11. if that doesn't work comment with what happened

[hampen421]

Yep i did restart server

[redmjc67]

did you add it to the db correctly?

[hampen421]

when i shall add item it says that the code or item dosent exist

[redmjc67]

did you restart your server?

[delenvar]

well I tryed to put.... something like 160001 or 855896 or something like that... then I tryed to put the unique , the same of the real item.... but it still doesn't work.... just tell me do i need to reload the database , after i execute the .sql item I downloaded from WoW-V???

[redmjc67]

ok, did you put it in the database and then just go in game and try to add it to yourself? also try to keep the entry id's under 6 numbers

[delenvar]

dude , i do everything , but when I start the server and lookup for that item ... it says like i didnt make... but yet it is in my Heidi database... ? i am using ArcEmu AC Web Ultimate Repack 8.0???

[redmjc67]

what is the entry id for it?

[chiken509]

When I click F-9 It just says SQL Error: Unknown column 'name2' in 'field list' plz help me idk whats wrong people told me to run mySQL but that doesnt work either.

[redmjc67]

what core are you using for your server and what are you downloading the item as

[fenixfirexx4]

how do i know what kind of core to use?

[redmjc67]

when you start up your server and go ingame there will be a bunch of text go through it until it says something with like

Aspire

ArcEmu

MaNGos then that is the core to use

[CooleiBOY]

Song ?

[redmjc67]

for the intro?

[CooleiBOY]

Yup xD

[redmjc67]

Bleed it out by Linkin Park

[CooleiBOY]

Ok but when i add items shall i log in with localhost?

[redmjc67]

Well if you are using ArcEmu the Username would be Root and pass would be ascent

[sl1pfr33k]

hey uhmm when i push F9 it says

SQL error: table 'mysql.items' doesnt exist please msg me i wanna no

[redmjc67]

what core are you using?

[sur3a1]

lol i made "assbringer" kinda op but it is only going to be for gm's then a player want try to attack

[luckeyace1]

when i press F9 it says Sql Error: unknown table 'items' in 'information_schema' please help me

[redmjc67]

What core are you using?

[luckeyace1]

whats a core?

[redmjc67]

like ArcEmu, Aspire, MaNGos

[luckeyace1]

arcemu

[kaptajnjackass]

forget it

i have fund it and thanks for the help

[peopleuluv2]

no you dont..

[redmjc67]

what?

[kaptajnjackass]

Hey where you got that program

[redmjc67]

what one?

[redmjc67]

Did you watch the whole Vid?

[ericsl8]

How do you change the pic

[redmjc67]

For what?

[redmjc67]

Did you watch whole video?