Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2013, 12:50 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default Accidentally editing my database wrongly!

So I was searching on a way to reset sleeper's tomb and I tried to input a query but I accidentally missed out on part of it ( I was too tired to be messing with this stuff). I wrote:
update spawn_conditions set value = 1 and zone = "sleeper";

it said query OK, 39 rows affected. I don't know what it actually did but I want to put it back however it was lol any ideas?

Also in case I was on the wrong track, does anyone know how to reset sleeper's tomb?
__________________
Why Windows Vista is BAD
Reply With Quote
  #2  
Old 06-06-2013, 02:36 AM
NatedogEZ's Avatar
NatedogEZ
Developer
 
Join Date: Dec 2012
Posts: 515
Default

I only see 2 spawn_conditions in sleeper

|| *zone* || *id* || *value* || *onchange* || *name* ||
|| sleeper || 1 || 1 || 2 || Warders ||
|| sleeper || 2 || 0 || 2 || Ancients ||



So it must have changed conditions for other zones?
Reply With Quote
  #3  
Old 06-06-2013, 03:34 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

It is always good to keep regular backups of your DB so you don't lose all of your work with a simple query or HDD failure, etc.

Since your DB is provably still mostly standard PEQ, you should be able to just create a new Database and then source the current PEQ DB into that new database. Then, you can copy the spawn_conditions table from the PEQ DB over to yours, which should undo your changes. From your query, it looks like you probably changed all of the spawn conditions in that table to be set for sleepers instead of whatever zone they were previously set for.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #4  
Old 06-06-2013, 03:53 AM
xplodr
Sarnak
 
Join Date: Jan 2009
Location: Florida
Posts: 53
Default

Well, it said it affected 39 rows, so it must have done something. I can't actually tell by looking at the database in navicat what was affected though.
__________________
Why Windows Vista is BAD
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 06:17 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3