Log in

View Full Version : Accidentally editing my database wrongly!


xplodr
06-06-2013, 12:50 AM
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?

NatedogEZ
06-06-2013, 02:36 AM
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?

trevius
06-06-2013, 03:34 AM
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.

xplodr
06-06-2013, 03:53 AM
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.