Raiding - Lets Face It

[Rogean]

Actually it would be relatively simple to write an sql query thats executed on every server patch... but we patch more often than live servers, and often have to do emergency patches and etc.

[Erasong]

emergency boss kills YAY

[President]

Originally Posted by Rogean [You must be logged in to view images. Log in or Register.]

Actually it would be relatively simple to write an sql query thats executed on every server patch... but we patch more often than live servers, and often have to do emergency patches and etc.

Is it possible to create two types of patches. One that is the standard updates that GM's work on, and another that is basically just to respawn mobs? Once a week GM discretion mob repop would be fantastic.

[pickled_heretic]

Originally Posted by Rogean [You must be logged in to view images. Log in or Register.]

Actually it would be relatively simple to write an sql query thats executed on every server patch... but we patch more often than live servers, and often have to do emergency patches and etc.

Why not just write the sql query to be executed on command? Then the patchers can just run a simple command to respawn stuff when they wanted to (e.g. every other patch, or every 3rd patch, or whatever)

[mr.miketastic]

Originally Posted by pickled_heretic [You must be logged in to view images. Log in or Register.]

Why not just write the sql query to be executed on command? Then the patchers can just run a simple command to respawn stuff when they wanted to (e.g. every other patch, or every 3rd patch, or whatever)

The script could be a DTS package that you could run on a schedule, but that would depend on the version of SQL you are running.

[Nocte]

Originally Posted by Rogean [You must be logged in to view images. Log in or Register.]

Actually it would be relatively simple to write an sql query thats executed on every server patch... but we patch more often than live servers, and often have to do emergency patches and etc.

Could you write a script that made this happen every X days? (Where X is the approximate number of days between classic server patches).

[Bumamgar]

Originally Posted by Rogean [You must be logged in to view images. Log in or Register.]

Actually it would be relatively simple to write an sql query thats executed on every server patch... but we patch more often than live servers, and often have to do emergency patches and etc.

One of my fonder memories of Live is running 5 pickup Vox raids in 5 days the week of the Luclin launch due to SOE patching every day [You must be logged in to view images. Log in or Register.]

That said, since we pretty much patch every week, having bosses respawn every patch would effectively replace the normal spawn timer for many mobs, and that's not good.