Raiding - Lets Face It

[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.

[Supreme]

You could actually do instancing..but that isnt classic=)

[Cars]

I was going to ask the same thing, If there is a way to have the query as a seperate patch? Not that you would reset the timers and use it every week but classic was anywhere between 3 weeks and 8 weeks usually between patches. You could say once every 4 or 5 weeks attach the query to the latest/ patched version of the server and repop the mobs and restart the timers? I know nothing of coding, programming or scripting but I know you guys care about this as much as the players do. When 90% of the server used to be below lvl 46 I am sure this wasn't a huge deal but with how many players we have now and how many big guilds there are going to be, the current system just doesnt seem to work. Maybe I am wasting my breath and if it's unfixable then it is what it is but this problem will only get worse with the growth of our server population and the expansions that are set to come.

[bullet]

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

Everquest was designed from the feet up to be competitive, and when I say that I mean AS IT WAS DESIGNED and not how it has been altered since.

EQ live had no spawn variance and EQ live had refreshed spawns EVEN ON RAID MOBS when the servers went down.

because most of those raid mobs will then spawn very close together, again giving more then one guild a Raid target to kill.

When Everquest was designed they didnt know better.

Everquest didn't work then and it won't work now, get over it.

p.s. your bullshit solution doesn't help anyone but people from America, just like the removal of global ooc/auction.

[Beau]

The way the server is right now for raiding is no one guilds fault and any sort of rotation, spawn variance or admin enforced rules around raiding only make it worse.

That is actually dead on.

It is very true that no one guild would be able to simultaneously kill all six mobs on server up, at least not right now. Adds more to the mix.

It is also very very true that every time Soandso /petitions raid rules and admin buys into it, it just fuels the fire. Like ... Well like a spoiled kid that gets everything if they cry to their parents, when really the best solution is, unless its something major/life threatening, they should ignore, and/or discipline those children.

FFA really isn't that bad. EQ was a society built by the players. That means chaos or order, it was ultimately the players that shaped the nature of the server. Eventually it will work itself out, but nothing will change if an outside source is playing judge and jury. It should be handled amongst the players.

But yeah It cant be EVERY time the servers came up and down that just wouldn't be fair. There are far too many small patches here and there for that to make any sort of sense, and let's face it - We NEED those small patches.