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-21-2007, 04:27 PM
RangerDown
Demi-God
 
Join Date: Mar 2004
Posts: 1,066
Default

Just a word of warning: the SL has "drop table" commands in it, so running those commands will cause some data loss if you already have your database populated.
__________________
<idleRPG> Rogean ate a plate of discounted, day-old sushi. This terrible calamity has slowed them 0 days, 15:13:51 from level 48.
Reply With Quote
  #2  
Old 02-24-2007, 05:08 AM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

Very cool of you to put it all in one place.

If I may make a suggestion though?

You might want to tell people that if they already have a populated altadv_vars table, they do not need to run that code as it will WIPE the data in it, leaving them with NO AAs at all.

Also, the changelogs keep saying to source AA_Data.sql, but none is ever provided anywhere--not in the source code releases (which is the [;ace that makes the most sense), nor anywhere here that I can see (the small source Angelox posted is NOT the one KLS is working from now--KLS has a source that I gave him that contains the vars through OOW. The reason I do not post it is because he may want to make changes to it (none are needed as it is accurate but you never know).. but still, someone needs to post that, as serverOPs that do not RTFM are wiping out their AA tables with these suggestions and are not being given anything to replace them with).
__________________
--
Keelyeh
Owner, ServerOp and Developer
Jest 4 Server
Linux (Jest3 runs on Fedora, our Dev servers usually run on Ubuntu and/or Gentoo), OC-12 Connection = Hella Fast
Reply With Quote
  #3  
Old 02-24-2007, 05:53 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Keep in mind, the sources you see the Devs posting are "Alpha" and not 100% working/compatible/etc. What you see is the "crude" work of what they are doing.
If you want to follow through with the latest updates, then you have to realize you risk loosing data.
Hopefully, you keep backups of your server (if you have a server), so you can restore if you don't like what happened.
Many servers do not update for this reason ( they do not want to risk loosing data).
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 11:02 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3