How do you reset a raid or lower the time?

[EARTHWALKER]

Just having a look around my server and see that a few instances reset times are set to over 3800 days...lol

No idea why, but hey, I'm sure it can be resolved.

How would I go about reducing or even removing the reset time completely, from a raid that is obviously being a little on the silly side?

Any help would e greatly appreciated.

[Schmoozerd]

I would start with removing all instance-binds

therefore:

* shutdown your server

* DELETE FROM character_instance;

* DELETE FROM instance;

* DELETE FROM group_instance;

* DELETE FROM instance_reset;

this way you should have only clean times.

Test then again, and if you encounter still a bug, post a detailed bug-report

[Cyberfreak]

I think this was a bug in a revision a few month ago, so the easiest way to avoid this in future is to update your core.

And of course if you want to be more sensetive than shutdown the server an deleting several entries in your database, use the ".instance" command.

[EARTHWALKER]

I would start with removing all instance-binds

therefore:

* shutdown your server

* DELETE FROM character_instance;

* DELETE FROM instance;

* DELETE FROM group_instance;

* DELETE FROM instance_reset;

this way you should have only clean times.

Test then again, and if you encounter still a bug, post a detailed bug-report

Hiya due. I don't really understand what you mean.

Delete what from character_instance?

Delete what from instance?

e.t.c.

My core is rev 10654 atm.

[Patman128]

DELETE * FROM whatever;

It's SQL for "delete everything from whatever".

[Toinan67]

DELETE * FROM whatever;

It's SQL for "delete everything from whatever".

There's no * (DELETE FROM whatever) ^^

@EARTHWALKER : Schmoo was telling you to delete everything from those tables so that new instance reset times could be created

[EARTHWALKER]

Thanks all for the help.

Deleted all the tables and now updated to rev 10777

Now lets see what happens

[EARTHWALKER]

Just tested a few raid and all times are showing correctly. I'm a happy bunny again

Thanks again peeps.