Query to set PB shots to LDR 3

[stephenxpimentel]

Code: Select all

/* Archery Life Drain Return set to 3 so it has no min range.*/
UPDATE spell SET LifeDrainReturn = '3'
WHERE
name = 'Point Blank Shot 1' OR
name = 'Point Blank Shot 2' OR
name = 'Point Blank Shot 3' OR
name = 'Point Blank Shot 4' OR
name = 'Point Blank Shot 5' OR
name = 'Point Blank Shot 6' OR
name = 'Point Blank Shot 7' OR
name = 'Point Blank Shot 8';
/* All other Archery spells set to 200 radius for minimum range.*/
UPDATE spell SET Radius = '200'
WHERE
name NOT LIKE = 'Point Blank Shot %' AND
type = 'Archery';

EDIT*** Also a query to set Radius of all other archery spells to 200 (For Min Range)

[Sand]

I missed a patch note?

I didn't know these had a lifedrain associated with them.

BTW why are you doing anything with radius on shots? The only shot where raduis is relevant would be volley.

[stephenxpimentel]

Here you are

http://dolserver.net/viewtopic.php?f=6&t=9623

[Graveen]

The LDR value is often used for some informations in the spells; on archery 1 & 2 where used, now 3.

The radius field is now used to contains the radius within you should not be to fire the shot.

[Sand]

Ah, reusing fields to mean something different ah makes more sense now.

Hmm, interesting thread which I haven't finished yet so don't know why they want to stop people from using the other shots at point blank range because there is little or no advantage to actually use them so people wouldn't be using the other shots anyway, as the dps on point blank is the highest and is the fastest shot except for rapid fire which does poor damage.

Maybe they messing around with the styles so the others have use or someone wants to take advantage of someone having very poor heat or cold resists so they use those shots however don't see how those would do more dps than point blank.

Edit: and on the interupt issue, my scout use to get interupted, so not sure what the issue is there or if even there is one in the core code.

Also I don't think live has any "min range" on the shots, but since I pretty consistently used point blank on anything that was closer than 1k range I can't really confirm.

[Dinberg]

Silly question maybe, but its bugging me. Why not, instead of using the LDR value, do you not just set radius to 0 for spells with no minimum range, and code it so when radius = zero we ignore minimum distance concerns?

[Graveen]

Because volley got radius and minimum range.

But the fact is LDR is already used to differentiate type, and it sounds coherent to handle the problem as a new type.

[Dinberg]

Ahh ok, seems good then

[Batlas]

Seems weird using radius though. Multishot ftw \o/