Page 1 of 1

Query to set PB shots to LDR 3

PostPosted: Sun Mar 08, 2009 12:31 am
by 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)

Re: Query to set PB shots to LDR 3

PostPosted: Sun Mar 08, 2009 2:24 am
by 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.

Re: Query to set PB shots to LDR 3

PostPosted: Sun Mar 08, 2009 7:55 am
by stephenxpimentel

Re: Query to set PB shots to LDR 3

PostPosted: Sun Mar 08, 2009 9:55 am
by 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.

Re: Query to set PB shots to LDR 3

PostPosted: Sun Mar 08, 2009 4:50 pm
by 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.

Re: Query to set PB shots to LDR 3

PostPosted: Sun Mar 08, 2009 5:34 pm
by 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?

Re: Query to set PB shots to LDR 3

PostPosted: Sun Mar 08, 2009 6:51 pm
by 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.

Re: Query to set PB shots to LDR 3

PostPosted: Sun Mar 08, 2009 8:23 pm
by Dinberg
Ahh ok, seems good then :D

Re: Query to set PB shots to LDR 3

PostPosted: Mon Mar 09, 2009 5:01 pm
by Batlas
Seems weird using radius though. Multishot ftw \o/