item editor creating new item

[Merq]

what exactly do you put in the "Begin:" and "End:" boxes to create an item from scratch?

thanks.

[Jezebell]

the item number.

For instance if it is item# 69999

it would be Begin=69999, End=69999

[Merq]

it says successfully created 1 new item, but where is it? what's it named i don't see it and all the fields are still ghosted.

[Jezebell]

I think the name is New Eqemulator item or somethign like that, just look for the number you made it.

[Merq]

sigh it's not doing it. i click create item, and on item editor 1.9.1 i type 69999 and it says invalid, so i type 00001 and it reloads the item list and says successfully made, but i don't see the item anywhere under "new" or "eq" or "emu" when i search. what is it called :(

[Merq]

on 2.0 beta i enter 69999 and it says successfully created item, but still dont see it in the list or know where to edit/make the stats. any ideas?

[killspree]

Means your item database isn't updated.

[Merq]

how do i update it...which sql IS up to date? to many old links and posts around heh

[Merq]

in fact where is the latest item database that i can source in? i would like to have it heh..

[mangoo]

http://www.eqemulator.net/forums/viewtopic.php?t=14897

rename table to "items"

[Merq]

how do i rename it? rename the file to items.sql? or do something with mysql-front or the mysql prompt? thanks

[Merq]

well i went to the prompt and typed use eq;

good.

source newdumpeditems.sql;

scrolling...

and then:

ERROR 1136: Column count doesn't match value count at row 1

How do I fix this? or is that ok? thanks

[mangoo]

Make sure you delete your items table before sourcing.

[Merq]

Originally Posted by mangoo

Make sure you delete your items table before sourcing.

did that, still gave me the 1136 error, so i renamed it to items anyway and it still wont show me the blank or new item im creating, any more help? :(