Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Tools

Archive::Tools Archive area for Tools's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-14-2004, 03:17 AM
Merq
Sarnak
 
Join Date: Jun 2004
Posts: 48
Default item editor creating new item

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

thanks.
__________________
- Merq -
Reply With Quote
  #2  
Old 06-14-2004, 03:18 AM
Jezebell
Discordant
 
Join Date: Feb 2004
Location: Florida
Posts: 441
Default

the item number.

For instance if it is item# 69999

it would be Begin=69999, End=69999
__________________
Eru, the Creator of Arda
ServerOwner for The First Age
An EQEMulator Roleplaying [Custom-Legit] Server
The First Age Website

Running on: Asus A7N8X-Deluxe, AMD Athlon XP 2100+, Geil 1024MB PC3200 Ultra DDR RAM,
WD 40GB 7200rpm ATA-100 HDD, Visiontek 128MB Geforce4 TI 4400, Windows XP Pro SP2
Reply With Quote
  #3  
Old 06-14-2004, 03:23 AM
Merq
Sarnak
 
Join Date: Jun 2004
Posts: 48
Default

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.
__________________
- Merq -
Reply With Quote
  #4  
Old 06-14-2004, 03:25 AM
Jezebell
Discordant
 
Join Date: Feb 2004
Location: Florida
Posts: 441
Default

I think the name is New Eqemulator item or somethign like that, just look for the number you made it.
__________________
Eru, the Creator of Arda
ServerOwner for The First Age
An EQEMulator Roleplaying [Custom-Legit] Server
The First Age Website

Running on: Asus A7N8X-Deluxe, AMD Athlon XP 2100+, Geil 1024MB PC3200 Ultra DDR RAM,
WD 40GB 7200rpm ATA-100 HDD, Visiontek 128MB Geforce4 TI 4400, Windows XP Pro SP2
Reply With Quote
  #5  
Old 06-14-2004, 03:29 AM
Merq
Sarnak
 
Join Date: Jun 2004
Posts: 48
Default

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 -
Reply With Quote
  #6  
Old 06-14-2004, 03:44 AM
Merq
Sarnak
 
Join Date: Jun 2004
Posts: 48
Default

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?
__________________
- Merq -
Reply With Quote
  #7  
Old 06-14-2004, 11:16 AM
killspree
Dragon
 
Join Date: Jun 2002
Posts: 776
Default

Means your item database isn't updated.
Reply With Quote
  #8  
Old 06-14-2004, 11:37 AM
Merq
Sarnak
 
Join Date: Jun 2004
Posts: 48
Default

how do i update it...which sql IS up to date? to many old links and posts around heh
__________________
- Merq -
Reply With Quote
  #9  
Old 06-14-2004, 11:44 AM
Merq
Sarnak
 
Join Date: Jun 2004
Posts: 48
Default

in fact where is the latest item database that i can source in? i would like to have it heh..
__________________
- Merq -
Reply With Quote
  #10  
Old 06-14-2004, 12:34 PM
mangoo
Items Master
 
Join Date: Apr 2003
Posts: 293
Default

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

rename table to "items"
__________________
Reply With Quote
  #11  
Old 06-14-2004, 01:41 PM
Merq
Sarnak
 
Join Date: Jun 2004
Posts: 48
Default

how do i rename it? rename the file to items.sql? or do something with mysql-front or the mysql prompt? thanks
__________________
- Merq -
Reply With Quote
  #12  
Old 06-14-2004, 01:47 PM
Merq
Sarnak
 
Join Date: Jun 2004
Posts: 48
Default

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
__________________
- Merq -
Reply With Quote
  #13  
Old 06-14-2004, 01:58 PM
mangoo
Items Master
 
Join Date: Apr 2003
Posts: 293
Default

Make sure you delete your items table before sourcing.
__________________
Reply With Quote
  #14  
Old 06-14-2004, 05:16 PM
Merq
Sarnak
 
Join Date: Jun 2004
Posts: 48
Default

Quote:
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? :(
__________________
- Merq -
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:13 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3