Raiding - Lets Face It

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

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

[Cogwell]

nm

[mastagee]

no one is saying to script it so that everytime the server or a zone goes down then all mobs will respawn. Obviously people would crash zones to exploit this.

Isn't it possible to write a query to respawn all the raid targets on command? You'd just have to randomly decide when to do this. If not just spawn the raid targets manually. There are only 6. The idea of exploiting always comes up but I just don't see how anyone will be able to exploit this if they can't do it already.

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

[G13]

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.

FFA would be a complete disaster

People would just sit on the spawns with bards running AOE dmg songs

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

[Cyrano]

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

FFA would be a complete disaster

People would just sit on the spawns with bards running AOE dmg songs

Then they would most likely die, how can you expect a raid force to sit on top of a mob's spawn point with 96 hour variance and remain fully buffed and prepared the entire time? Even then, how many would it require for them to survive the surprise of this type of situation?

While one guild did that, other guilds would sit back a little bit and watch the first wipe.

I'm not saying FFA would totally destroy camping, but it would certainly cut back on it.