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

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
 
Thread Tools Display Modes
  #1  
Old 10-08-2005, 07:00 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

in table 'items' is there something in field items.serialization'?

run this sql query -

mysql -u root
use eq;
Select name,id,serialization from items where items.name = 'Cloth Cap';

If you don't see a serialization string exist for your item, then the serialization.pl script needs to be run

GeorgeS
Reply With Quote
  #2  
Old 10-24-2005, 04:10 AM
Rodnoldo
Fire Beetle
 
Join Date: Nov 2004
Location: Colorado
Posts: 15
Default serialization.pl

Hello,

I've just updated to 6.2-DR1 and want to bring in my custom items from a previous version, 6.0-DR2, I think.

I noticed about 30 new or differently named columns in the new database, and identified, added and fixed all except one. "serialization text"

These fields seem to hold the item name, followed by any engraving text or other information, then followed by some binary looking numbers separated by pipes (|).

I saw only one comment in the forums about the serialization.pl script which must be run. But...

I'm not sure where I should run it.
-- from MySQL
-- from PERL at the command line

I'm not sure what I run it against.
-- against my newitems.sql file
-- against my MySQL database

I'm a little shy about running serialization.pl without knowing what it does and to what it does it.

Any additional information on serialization.pl would help.

Thanks.

Rodnoldo
Reply With Quote
  #3  
Old 10-24-2005, 05:22 AM
Damilis's Avatar
Damilis
Hill Giant
 
Join Date: Dec 2002
Location: Nottingham!!
Posts: 217
Default

Quote:
Originally Posted by Rodnoldo
I'm a little shy about running serialization.pl without knowing what it does and to what it does it.

Any additional information on serialization.pl would help.
Don't be shy! That's what DB backups are for No better way to learn how something works then by breaking it a few times. I wish I had a real answer for ya, but I use a MS Access front end since it fast/customizable. I do know that you re correct about the serialization column. its just a pipe delimited list of the table row.
__________________
GM/ServerOP - Shadows of Norrath
Reply With Quote
Reply

Thread Tools
Display Modes

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 12:43 AM.


 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3