Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-25-2008, 07:24 AM
leslamarch
Discordant
 
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default

CD,
I was just wondering if you could point me in the right direction for a change log for the database? Sorry if i missed it somewhere
Thanks
~LL~
Reply With Quote
  #2  
Old 02-25-2008, 08:01 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

http://www.projecteq.net/phpBB2/view...c53dbc5bf86a99

Is as good as we'll get. It's a good overview of the changes, but if every change was documented, half of my time would be spent writing that up
Reply With Quote
  #3  
Old 02-25-2008, 08:17 AM
leslamarch
Discordant
 
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default

Quote:
Originally Posted by cavedude View Post
http://www.projecteq.net/phpBB2/view...c53dbc5bf86a99

Is as good as we'll get. It's a good overview of the changes, but if every change was documented, half of my time would be spent writing that up
Perfect, Just what i was wanting to see.
Thanks So Much
Reply With Quote
  #4  
Old 03-03-2008, 10:34 AM
gorgoth
Fire Beetle
 
Join Date: Feb 2008
Posts: 2
Default Need help with winCVS

I got winCVS and put in the information give and It says it can't find the specified file. Below is what I put in and I am at a loss as to what is going wrong.

under Module Name: peq_db

and under CVSROOT: :pserver:anonymous@peq.cvs.sourceforge.net:/cvsroot/peq


The exact error message I get is:

Unable to initialize the CVS process: The system cannot find the file specified. The CVS used is : cvs.exe

did the files change?
Reply With Quote
  #5  
Old 03-16-2008, 09:03 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Seeing that the bots are becoming more popular and polished, I added two files to the CVS, bot_npcs.bat and bot_npcs.sh.

They simply will dump your current NPC bots to bot_npcs.sql, so that they can be sourced back in after you do a DB update.

Windows users:

1. Open bot.npcs.bat with notepad or similar and change peq to the name of your database.
2. Then, run the .bat file. It will create a new file called bot_npcs.sql in the same directory.
3. Update your database as normal.
4. Source in bot_npcs.sql

That's it!

Linux users do the same except using bot_npcs.sh. Make sure it's marked executable, and you run it as ./bot_npcs.sh

Of course, you will need to repeat this every time you update your database, or your bot NPCs will be lost.

The next version of the installer (which will offer a db update feature) will do this automatically.
Reply With Quote
  #6  
Old 03-17-2008, 12:54 AM
cubber
Discordant
 
Join Date: Apr 2006
Posts: 374
Default

The linux script worked great, except I had to add a -p to the commands in order for it to prompt me for a password.

When sourcing the bot's back into the DB will they overwrite any new NPC additions to the peq DB? I noticed that the last entry before my bots start is 2700011 A_warm, my bots start at 2700012 and go to 2700033 currently, which is the last npc in the DB.
Reply With Quote
  #7  
Old 03-17-2008, 01:40 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

I am pretty sure the bots will just tack themselves on the end of the NPC IDs. That being said, PEQ will never use IDs that high. In fact, I don't know why those 136 NPCs are there in the first place. The highest ID we should be using is 999,999. No zone at this point has an ID in the thousands, and we derive our NPC IDs by zoneidnumber. So no, those IDs are well into the reserved range and won't be used by us, more than likely ever.
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 02:50 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