From: <ko...@us...> - 2009-07-01 22:36:20
|
Revision: 3884 http://planeshift.svn.sourceforge.net/planeshift/?rev=3884&view=rev Author: kougaro Date: 2009-07-01 22:35:17 +0000 (Wed, 01 Jul 2009) Log Message: ----------- fix a mathscript that was causing a crash in combat Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2009-07-01 22:25:11 UTC (rev 3883) +++ trunk/src/server/database/mysql/math_scripts.sql 2009-07-01 22:35:17 UTC (rev 3884) @@ -34,8 +34,8 @@ RequiredInputVars = Target:AttackerTargeted+Attacker:getSkillValue(AttackWeapon:Skill1)+AttackLocationItem:Hardness; - AttackerStance = AttackerActor:CombatStance; - TargetStance = TargetActor:CombatStance; + AttackerStance = Attacker:CombatStance; + TargetStance = Target:CombatStance; AttackValue = WeaponSkill; TargetAttackValue = TargetWeaponSkill; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wel...@us...> - 2009-07-23 18:48:24
|
Revision: 4109 http://planeshift.svn.sourceforge.net/planeshift/?rev=4109&view=rev Author: weltall2 Date: 2009-07-23 18:48:14 +0000 (Thu, 23 Jul 2009) Log Message: ----------- math script addition Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2009-07-23 18:37:18 UTC (rev 4108) +++ trunk/src/server/database/mysql/math_scripts.sql 2009-07-23 18:48:14 UTC (rev 4109) @@ -113,6 +113,22 @@ BaseMen = (INT + WILL + CHA) / 3; "); +INSERT INTO math_scripts VALUES( "StaminaRatioWalk", +"PStaminaRate = Actor:MaxPStamina/100*BaseRegenPhysical; +MStaminaRate = Actor:MaxMStamina/100*BaseRegenMental;"); + +INSERT INTO math_scripts VALUES( "StaminaRatioStand", +"PStaminaRate = Actor:MaxPStamina/100*BaseRegenPhysical; +MStaminaRate = Actor:MaxMStamina/100*BaseRegenMental;"); + +INSERT INTO math_scripts VALUES( "StaminaRatioSit", +"PStaminaRate = Actor:MaxPStamina*0.015*BaseRegenPhysical; +MStaminaRate = Actor:MaxMStamina*0.015*BaseRegenMental;"); + +INSERT INTO math_scripts VALUES( "StaminaRatioWork", +"PStaminaRate = Actor:MaxPStamina-6.0*(100-SkillMentalFactor)/100; +MStaminaRate = Actor:MaxMStamina-6.0*(100-SkillMentalFactor)/100;"); + INSERT INTO math_scripts VALUES( "CalculateMaxHP", "MaxHP = Actor:Will + Actor:Agility + Actor:Strength;"); INSERT INTO math_scripts VALUES( "CalculateMaxMana", "MaxMana = Actor:Will + Actor:Intelligence;"); @@ -196,3 +212,4 @@ INSERT INTO math_scripts VALUES( "Calculate Dynamic Experience", "Exp = 0;"); + This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rly...@us...> - 2010-07-19 13:40:46
|
Revision: 6047 http://planeshift.svn.sourceforge.net/planeshift/?rev=6047&view=rev Author: rlydontknow Date: 2010-07-19 13:40:36 +0000 (Mon, 19 Jul 2010) Log Message: ----------- fixed a crash that was caused by wrong variable order in the script Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2010-07-17 22:09:54 UTC (rev 6046) +++ trunk/src/server/database/mysql/math_scripts.sql 2010-07-19 13:40:36 UTC (rev 6047) @@ -32,6 +32,9 @@ NDiffX = -DiffX; NDiffZ = -DiffZ; + BadRange = pow(AttackWeapon:Range * 1.1 + 1,2) - Dist; + exit = if(0>BadRange,1,0); + Angle = atan2(NDiffX,NDiffZ); AngleAtt = Angle; Angle = Attacker:loc_yrot - Angle; @@ -40,9 +43,6 @@ BadAngle = PI * if(Dist>1.5, 0.3, 0.4) - abs(Angle); exit = if(0>BadAngle,1,0); - BadRange = pow(AttackWeapon:Range * 1.1 + 1,2) - Dist; - exit = if(0>BadRange,1,0); - Missed = min(AttackRoll-.25,0.1); exit = if(0>Missed,1,0); Dodged = min(AttackRoll-.5,.01); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rly...@us...> - 2010-07-23 00:27:14
|
Revision: 6060 http://planeshift.svn.sourceforge.net/planeshift/?rev=6060&view=rev Author: rlydontknow Date: 2010-07-23 00:27:08 +0000 (Fri, 23 Jul 2010) Log Message: ----------- fixed decay script Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2010-07-22 21:36:46 UTC (rev 6059) +++ trunk/src/server/database/mysql/math_scripts.sql 2010-07-23 00:27:08 UTC (rev 6060) @@ -77,9 +77,9 @@ INSERT INTO math_scripts VALUES( "Calculate Decay", " - WeaponDecay = if(Blocked, 1.25, 1 - ArmorVsWeapon); - BlockingDecay = if(Blocked, 0.75, 0); - ArmorDecay = if(Blocked, 0, ArmorVsWeapon); + WeaponDecay = if(Blocked, 1.25, 1 - ArmorVsWeapon) * Weapon:DecayRate * (1 - Weapon:DecayResistance); + BlockingDecay = if(Blocked, 0.75, 0) * BlockingWeapon:DecayRate * (1 - BlockingWeapon:DecayResistance); + ArmorDecay = if(Blocked, 0, ArmorVsWeapon) * Armor:DecayRate * (1 - Armor:DecayResistance); "); INSERT INTO math_scripts VALUES( "Lockpicking Time", "Time = ((LockQuality / 10) * 3)*1000;"); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rly...@us...> - 2010-10-03 14:49:39
|
Revision: 6251 http://planeshift.svn.sourceforge.net/planeshift/?rev=6251&view=rev Author: rlydontknow Date: 2010-10-03 14:49:33 +0000 (Sun, 03 Oct 2010) Log Message: ----------- fixed practice point attribution in combat script Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2010-10-03 13:50:42 UTC (rev 6250) +++ trunk/src/server/database/mysql/math_scripts.sql 2010-10-03 14:49:33 UTC (rev 6251) @@ -104,9 +104,9 @@ FinalDamage = 10*(AVStance-TargetDV); if(Target:IsNPC) { - Attacker:PracticeSkillID(AttackWeapon:Skill1); - Attacker:PracticeSkillID(AttackWeapon:Skill2); - Attacker:PracticeSkillID(AttackWeapon:Skill3); + Attacker:PracticeSkillID(AttackWeapon:Skill1,1); + Attacker:PracticeSkillID(AttackWeapon:Skill2,1); + Attacker:PracticeSkillID(AttackWeapon:Skill3,1); } "); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rly...@us...> - 2010-10-10 18:34:34
|
Revision: 6264 http://planeshift.svn.sourceforge.net/planeshift/?rev=6264&view=rev Author: rlydontknow Date: 2010-10-10 18:34:27 +0000 (Sun, 10 Oct 2010) Log Message: ----------- fixed runtime warning Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2010-10-10 17:47:59 UTC (rev 6263) +++ trunk/src/server/database/mysql/math_scripts.sql 2010-10-10 18:34:27 UTC (rev 6264) @@ -113,8 +113,14 @@ INSERT INTO math_scripts VALUES( "Calculate Decay", " WeaponDecay = if(Blocked, 1.25, 1 - ArmorVsWeapon) * Weapon:DecayRate * (1 - Weapon:DecayResistance); - BlockingDecay = if(Blocked, 0.75, 0) * BlockingWeapon:DecayRate * (1 - BlockingWeapon:DecayResistance); - ArmorDecay = if(Blocked, 0, ArmorVsWeapon) * Armor:DecayRate * (1 - Armor:DecayResistance); + if(Blocked) + { + BlockingDecay = 0.75 * BlockingWeapon:DecayRate * (1 - BlockingWeapon:DecayResistance); + } + else + { + ArmorDecay = ArmorVsWeapon * Armor:DecayRate * (1 - Armor:DecayResistance); + } "); INSERT INTO math_scripts VALUES( "Lockpicking Time", "Time = ((LockQuality / 10) * 3)*1000;"); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rly...@us...> - 2010-10-11 13:57:59
|
Revision: 6267 http://planeshift.svn.sourceforge.net/planeshift/?rev=6267&view=rev Author: rlydontknow Date: 2010-10-11 13:57:52 +0000 (Mon, 11 Oct 2010) Log Message: ----------- fixed combat script Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2010-10-11 13:46:43 UTC (rev 6266) +++ trunk/src/server/database/mysql/math_scripts.sql 2010-10-11 13:57:52 UTC (rev 6267) @@ -47,7 +47,7 @@ exit = if(0>Missed,1,0); Dodged = min(AttackRoll-.5,.01); - if(Dodged) + if(Dodged < 0) { if(Attacker:IsNPC) { @@ -60,7 +60,7 @@ } Blocked = AttackRoll - DefenseRoll; - if(Blocked) + if(Blocked < 0) { if(Attacker:IsNPC) { This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wel...@us...> - 2011-01-17 14:59:27
|
Revision: 6806 http://planeshift.svn.sourceforge.net/planeshift/?rev=6806&view=rev Author: weltall2 Date: 2011-01-17 14:59:21 +0000 (Mon, 17 Jan 2011) Log Message: ----------- added apply skill script Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2011-01-17 14:29:50 UTC (rev 6805) +++ trunk/src/server/database/mysql/math_scripts.sql 2011-01-17 14:59:21 UTC (rev 6806) @@ -275,5 +275,220 @@ INSERT INTO math_scripts VALUES( "Calculate Dynamic Experience", "Exp = 0;"); +INSERT INTO math_scripts VALUES( "Calculate Transformation Apply Skill", +"// just return for processless transforms +if(Process:IsNull()) +{ + if(Secure) + { + Worker:SendSystemInfo(''Processless transforms give no practice points or quality change.'',0); + } + exit = 1; +} +// Check for a primary skill +StartingQuality = Quality; +if(Secure) +{ + Worker:SendSystemInfo(''Starting quality calculation with quality %f.'', 1, StartingQuality); +} +PriSkill = Process:PrimarySkillId; +// Increase quality for crafted item based on if the starting quality was less then the normal quality +BaseObject = Object:GetBaseItem(); +BaseQuality = BaseObject:Quality; + +//should be >= +if(PriSkill > 0) +{ + if(Quality > BaseQuality) + { + // Add the transfromation items base quality to the current quality as a crafting bonus + if(Secure) + { + Worker:SendSystemInfo(''Primary skill add crafting bonus of item base quality %f.'', 1, BaseQuality); + } + Quality = Quality + BaseQuality; + } + else + { + // Double the current quality as a crafting bonus + if(Secure) + { + Worker:SendSystemInfo(''Primary skill double current quality.''); + } + Quality = Quality * 2; + } + + // Get the players skill level using the transformations primary skill + BasePriSkill = Worker:GetSkillValue(PriSkill); + MaxPriSkill = Process:MaxPrimarySkill; + + // Get the quality factor for this primary skill + // and only use it if in range. + // This value represents what percentage of the effect of skills should be + // applied to the quality calculation for this transformation + PriQualFactor = Process:PrimarySkillQualityFactor/100.00; + if((PriQualFactor > 0.00) & (PriQualFactor < 1.00)) + { + // For quality considerations cap the base skill + // at the max skill for this transformation. + CapPriSkill = min(MaxPriSkill, BasePriSkill); + + // Calculate the lack of skill as a percentage of the capped skill over the skill range. + // Since this is a lack of skill percentage subtract it from 1. + MinPriSkill = Process:MinPrimarySkill(); + PriSkillLessPercent = 0; + if((MaxPriSkill-MinPriSkill)>0) + { + PriSkillLessPercent = 1 - ((CapPriSkill-MinPriSkill)/(MaxPriSkill-MinPriSkill)); + if(Secure) + { + Worker:SendSystemInfo(''Primary skill base level %d and max process level %d gives capped skill level %d.'', 3, BasePriSkill, MaxPriSkill, CapPriSkill); + Worker:SendSystemInfo(''Min process level %d gives skill percent %f.'', 2, MinPriSkill, PriSkillLessPercent); + } + } + + // Calculate the effect of the quality factor for this skill by the skill level + // Subtract it as a percentage from the current ingredient quality + Quality = Quality-(StartingQuality * PriSkillLessPercent * PriQualFactor); + if(Secure) + { + Worker:SendSystemInfo(''Current quality reduced to %f by starting quality %f times skill percent %f times process quality factor %f.'', 4, Quality, StartingQuality, PriSkillLessPercent, PriQualFactor); + } + } + + // Only give primary experience to those under the max + if( BasePriSkill < MaxPriSkill ) + { + // Get some practice in + PriPoints = Process:PrimarySkillPracticePoints; + if(AmountModifier) + { + PriPoints = PriPoints*(1+(Object:StackCount-1)*0.1); + } + Worker:CalculateAddExperience(PriSkill, PriPoints, 1); + if(Secure) + { + Worker:SendSystemInfo(''Giving practice points %d to skill %d.'', 2, PriPoints, PriSkill); + } + } + + // Apply the secondary skill if any + SecSkill = Process:SecondarySkillId; + //should be >= + if(SecSkill > 0) + { + if(Quality > BaseQuality) + { + // Add the transfromation items base quality to the current quality as a crafting bonus + if(Secure) + { + Worker:SendSystemInfo(''Secondary skill add crafting bonus of item base quality %f.'', 1, BaseQuality); + } + Quality = Quality + BaseQuality; + } + else + { + // Double the current quality as a crafting bonus + if(Secure) + { + Worker:SendSystemInfo(''Secondary skill double current quality.''); + } + Quality = Quality * 2; + } + + BaseSecSkill = Worker:GetSkillValue(SecSkill); + MaxSecSkill = Process:MaxSecondarySkill; + + // Get the quality factor for this secmary skill + // and only use it if in range. + SecQualFactor = Process:SecondarySkillQualityFactor/100.00; + if((SecQualFactor > 0.00) & (SecQualFactor < 1.00)) + { + // For quality considerations cap the base skill + // at the max skill for this transformation. + CapSecSkill = min(MaxSecSkill, BaseSecSkill); + + // Calculate the lack of skill as a percentage of the capped skill over the skill range. + // Since this is a lack of skill percentage subtract it from 1. + MinSecSkill = Process:MinSecondarySkill(); + SecSkillLessPercent = 0; + if((MaxSecSkill-MinSecSkill) > 0) + { + SecSkillLessPercent = 1 - ((CapSecSkill-MinSecSkill)/(MaxSecSkill-MinSecSkill)); + if(Secure) + { + Worker:SendSystemInfo(''Secondary skill base level %d and max process level %d gives capped skill level %d.'', 3, BaseSecSkill, MaxSecSkill, CapSecSkill); + Worker:SendSystemInfo(''Min process level %d gives skill percent %f.'', 2, MinSecSkill, SecSkillLessPercent); + } + } + + // Calculate the effect of the quality factor for this skill by the skill level + Quality = Quality - (StartingQuality * SecSkillLessPercent * SecQualFactor); + if(Secure) + { + Worker:SendSystemInfo(''Current quality reduced to %f by starting quality %f times skill percent %f times process quality factor %f.'', 4, Quality, StartingQuality, SecSkillLessPercent, SecQualFactor); + } + } + + // Only give secondary experience to those under the max + if( BaseSecSkill < MaxSecSkill ) + { + // Get some practice in + SecPoints = Process:SecondarySkillPracticePoints(); + if(AmountModifier) + { + SecPoints = SecPoints*(1+(Object:GetStackCount-1)*0.1); + } + Worker:CalculateAddExperience(SecSkill, SecPoints, 1); + if(Secure) + { + Worker:SendSystemInfo(''Giving practice points %d to skill %d.'',2, SecPoints, SecSkill); + } + } + } + + // Randomize the final quality results + // We are using a logrithmic calculation so that normally there is little quality change + // except at the edges of the random distribution. + // Use a pattern specific factor to determine the curve at the edges + Roll = rnd(1); + ExpFactor = Factor*log((1/Roll)-1); + Quality = Quality -((Quality*ExpFactor)/100); + if(Secure) + { + Worker:SendSystemInfo(''Applying random effect changes quality to %f using factor %f on roll %f.'', 3, Quality, ExpFactor, Roll); + } +} +else +{ + if(Secure) + { + Worker:SendSystemInfo(''This transform gives no practice points or quality change.'', 0); + } +} + +// Adjust the final quality with the transformation quality factor +Quality = Quality * Transform:ItemQualityPenaltyPercent; +if(Secure) +{ + Worker:SendSystemInfo(''Applying transformation penalty %f changes quality to %f.'', 2, Transform:ItemQualityPenaltyPercent,Quality); +} + +// Check for range +Quality = min(999, Quality); + +// Fail if it''s worst then worse +if(Quality < 10) +{ + Quality = 0; + if(Secure) + { + Worker:SendSystemInfo(''Failed quality check. Creating garbage item.'', 0); + } +}"); + + + + This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wha...@us...> - 2011-11-19 19:02:06
|
Revision: 7731 http://planeshift.svn.sourceforge.net/planeshift/?rev=7731&view=rev Author: whacko88 Date: 2011-11-19 19:02:00 +0000 (Sat, 19 Nov 2011) Log Message: ----------- changed the error rate and skill ranking for musical instruments Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2011-11-19 16:40:26 UTC (rev 7730) +++ trunk/src/server/database/mysql/math_scripts.sql 2011-11-19 19:02:00 UTC (rev 7731) @@ -591,23 +591,10 @@ INSERT INTO math_scripts VALUES( "Calculate Song Parameters" , " InstrSkill = 52; InstrSkillRank = Player:GetSkillValue(InstrSkill); - ErrorRate = 1 - InstrSkillRank / (50 + InstrSkillRank); + ErrorRate = 0.25 - 0.001245 * InstrSkillRank; "); INSERT INTO math_scripts VALUES( "Calculate Song Experience" , " PracticePoints = 0.1 * SongTime; - - AverageError = ErrorRate / AverageDuration * AveragePolyphony; - if(AverageError > 1) - { - AverageError = 1; - } - - ErrorShift = AverageError - 0.5; - if(ErrorShift < 0) - { - ErrorShift = -ErrorShift; - } - - Modifier = 1 - 2*ErrorShift; + Modifier = 1; "); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rly...@us...> - 2011-11-23 06:58:33
|
Revision: 7748 http://planeshift.svn.sourceforge.net/planeshift/?rev=7748&view=rev Author: rlydontknow Date: 2011-11-23 06:58:27 +0000 (Wed, 23 Nov 2011) Log Message: ----------- fix Calculate Transformation Time script Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2011-11-22 11:19:03 UTC (rev 7747) +++ trunk/src/server/database/mysql/math_scripts.sql 2011-11-23 06:58:27 UTC (rev 7748) @@ -492,7 +492,7 @@ INSERT INTO math_scripts VALUES( "Calculate Transformation Time", "if(Transform:ItemQuantity & Transform:ItemID != 0 & Transform:ResultItemID != 0) { - Time = Transform:TransformPoints + Transform:TransformPoints*(Object:StackCount - 1) * 0.1); + Time = Transform:TransformPoints * (0.9 + Object:StackCount * 0.1); } else { This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wel...@us...> - 2011-12-15 07:42:27
|
Revision: 7814 http://planeshift.svn.sourceforge.net/planeshift/?rev=7814&view=rev Author: weltall2 Date: 2011-12-15 07:42:20 +0000 (Thu, 15 Dec 2011) Log Message: ----------- changed setskillvalue to setbaseskillvalue Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2011-12-13 23:07:54 UTC (rev 7813) +++ trunk/src/server/database/mysql/math_scripts.sql 2011-12-15 07:42:20 UTC (rev 7814) @@ -531,27 +531,27 @@ INSERT INTO math_scripts VALUES( "SetBaseSkills" , " if(AGI > 0) { - Actor:SetSkillValue(46,AGI); + Actor:SetBaseSkillValue(46,AGI); } if(CHA > 0) { - Actor:SetSkillValue(47,CHA); + Actor:SetBaseSkillValue(47,CHA); } if(END > 0) { - Actor:SetSkillValue(48,END); + Actor:SetBaseSkillValue(48,END); } if(INT > 0) { - Actor:SetSkillValue(49,INT); + Actor:SetBaseSkillValue(49,INT); } if(STR > 0) { - Actor:SetSkillValue(50,STR); + Actor:SetBaseSkillValue(50,STR); } if(WILL > 0) { - Actor:SetSkillValue(51,WILL); + Actor:SetBaseSkillValue(51,WILL); } "); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wel...@us...> - 2011-12-15 16:14:12
|
Revision: 7817 http://planeshift.svn.sourceforge.net/planeshift/?rev=7817&view=rev Author: weltall2 Date: 2011-12-15 16:14:06 +0000 (Thu, 15 Dec 2011) Log Message: ----------- really fixed setbaseskills script. now players where spawning for the first time dead Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2011-12-15 11:29:35 UTC (rev 7816) +++ trunk/src/server/database/mysql/math_scripts.sql 2011-12-15 16:14:06 UTC (rev 7817) @@ -529,29 +529,29 @@ "); INSERT INTO math_scripts VALUES( "SetBaseSkills" , " - if(AGI > 0) + if((AGI > 0) & (Actor:GetSkillValue(46) < AGI)) { - Actor:SetBaseSkillValue(46,AGI); + Actor:SetSkillValue(46,AGI); } - if(CHA > 0) + if((CHA > 0) & (Actor:GetSkillValue(47) < CHA)) { - Actor:SetBaseSkillValue(47,CHA); + Actor:SetSkillValue(47,CHA); } - if(END > 0) + if((END > 0) & (Actor:GetSkillValue(48) < END)) { - Actor:SetBaseSkillValue(48,END); + Actor:SetSkillValue(48,END); } - if(INT > 0) + if((INT > 0) & (Actor:GetSkillValue(49) < INT)) { - Actor:SetBaseSkillValue(49,INT); + Actor:SetSkillValue(49,INT); } - if(STR > 0) + if((STR > 0) & (Actor:GetSkillValue(50) < STR)) { - Actor:SetBaseSkillValue(50,STR); + Actor:SetSkillValue(50,STR); } - if(WILL > 0) + if((WILL > 0) & (Actor:GetSkillValue(51) < WILL)) { - Actor:SetBaseSkillValue(51,WILL); + Actor:SetSkillValue(51,WILL); } "); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wha...@us...> - 2012-01-28 18:38:36
|
Revision: 8049 http://planeshift.svn.sourceforge.net/planeshift/?rev=8049&view=rev Author: whacko88 Date: 2012-01-28 18:38:30 +0000 (Sat, 28 Jan 2012) Log Message: ----------- fixed instruments practice points and experience Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2012-01-28 17:54:11 UTC (rev 8048) +++ trunk/src/server/database/mysql/math_scripts.sql 2012-01-28 18:38:30 UTC (rev 8049) @@ -668,16 +668,17 @@ else { InstrSkillRank = Player:GetSkillValue(InstrSkill); - PracticePoints = SongTime / SecondsPerPracticePoint; // No practice points if the score's rank differ from the player's skill by more than 50 - Modifier = 1 - abs(InstrSkillRank - ScoreRank) / 50; - if(Modifier < 0) + RelativeDifficulty = 1 - abs(InstrSkillRank - ScoreRank) / 50; + if(RelativeDifficulty < 0) { - Modifier = 0; + RelativeDifficulty = 0; } - TimeLeft = SongTime % SecondsPerPracticePoint * Modifier; + PracticePoints = SongTime / SecondsPerPracticePoint * RelativeDifficulty; + TimeLeft = SongTime % SecondsPerPracticePoint * RelativeDifficulty; + Modifier = 1; } "); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2012-05-01 17:41:48
|
Revision: 8259 http://planeshift.svn.sourceforge.net/planeshift/?rev=8259&view=rev Author: lpancallo Date: 2012-05-01 17:41:42 +0000 (Tue, 01 May 2012) Log Message: ----------- fixed error in script. Added more examples. Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2012-05-01 17:19:13 UTC (rev 8258) +++ trunk/src/server/database/mysql/math_scripts.sql 2012-05-01 17:41:42 UTC (rev 8259) @@ -235,7 +235,7 @@ ResultModifier = if(Success, 25, 2); "); -INSERT INTO math_scripts VALUES( "Calculate Trasformation Experience", +INSERT INTO math_scripts VALUES( "Calculate Transformation Experience", " Exp = if(StartQuality < CurrentQuality, 2*(CurrentQuality-StartQuality), 0); "); @@ -295,7 +295,7 @@ Worker:CalculateAddExperience(PriSkill, PriPoints, 1); if(Secure) { - Worker:SendSystemInfo(''Giving practice points %d to skill %d.'', 2, PriPoints, PriSkill); + Worker:SendSystemInfo('Giving practice points %d to skill %d.', 2, PriPoints, PriSkill); } " ); @@ -528,7 +528,9 @@ CurrentGlyph = Worker:GetItem(0); CurrentGlyphItem = CurrentGlyph:GetBaseItem(); CurrentGlyphId = CurrentGlyphItem:Id; -Worker:SendSystemInfo('GLYPH ID %f.', 1, CurrentGlyphId); +WorkItem=OldItem:GetBaseItem(); +WorkItemId=WorkItem:Id; +Worker:SendSystemInfo('GLYPH ID %f. Object ID: %f', 1, CurrentGlyphId, WorkItemId); if (CurrentGlyphId=13) { NewItem:SetItemModifier(0,12); NewItem:SetItemModifier(1,14); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2012-05-01 17:44:51
|
Revision: 8260 http://planeshift.svn.sourceforge.net/planeshift/?rev=8260&view=rev Author: lpancallo Date: 2012-05-01 17:44:45 +0000 (Tue, 01 May 2012) Log Message: ----------- fixed arg number Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2012-05-01 17:41:42 UTC (rev 8259) +++ trunk/src/server/database/mysql/math_scripts.sql 2012-05-01 17:44:45 UTC (rev 8260) @@ -530,7 +530,7 @@ CurrentGlyphId = CurrentGlyphItem:Id; WorkItem=OldItem:GetBaseItem(); WorkItemId=WorkItem:Id; -Worker:SendSystemInfo('GLYPH ID %f. Object ID: %f', 1, CurrentGlyphId, WorkItemId); +Worker:SendSystemInfo('GLYPH ID %f. Object ID: %f', 2, CurrentGlyphId, WorkItemId); if (CurrentGlyphId=13) { NewItem:SetItemModifier(0,12); NewItem:SetItemModifier(1,14); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2012-07-20 12:44:44
|
Revision: 8390 http://planeshift.svn.sourceforge.net/planeshift/?rev=8390&view=rev Author: lpancallo Date: 2012-07-20 12:44:35 +0000 (Fri, 20 Jul 2012) Log Message: ----------- Fixed Calculate Mining Odds Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2012-07-19 15:57:21 UTC (rev 8389) +++ trunk/src/server/database/mysql/math_scripts.sql 2012-07-20 12:44:35 UTC (rev 8390) @@ -264,13 +264,46 @@ INSERT INTO math_scripts VALUES( "Calc Bank Fee", "BankFee = 5.25 - (AccountLevel * 0.25);"); INSERT INTO math_scripts VALUES( "Calculate Mining Odds", " -Total = Distance * Probability * Quality * Skill + 0.1; +Skill = PlayerSkill / RequiredSkill; +Quality = ToolQuality / RequiredToolQuality; -ResultQuality = Quality * Skill; +Total = Distance * Probability * Quality * Skill + 0.3; + +ResultQuality = ToolQuality * Skill; ResultQuality = ResultQuality*300; "); +Total = Distance * Probability * Quality * Skill + 0.2; + +SkillFactor = PlayerSkill / RequiredSkill; +if (SkillFactor>6) { + SkillFactor = 6; +} +if (SkillFactor<1) { + SkillFactor = 1; +} + +ToolFactor = 0.2*ToolQuality / RequiredToolQuality; +if (ToolFactor>2) { + ToolFactor = 2; +} +if (ToolFactor<1) { + ToolFactor = 1; +} + +RandomFactor = (0.4*rnd(1))+0.8; +ResultQuality = 50*SkillFactor*ToolFactor*RandomFactor; +if (ResultQuality>300) { + ResultQuality = 300; +} +if (ResultQuality<50) { + ResultQuality = 50; +} + +ResultQuality = floor(ResultQuality); + + INSERT INTO math_scripts VALUES( "Calc Item Merchant Price Buy", "Result = ItemPrice - CharData:GetSkillValue(47)/10;"); INSERT INTO math_scripts VALUES( "Calc Item Merchant Price Sell", "Result = ItemPrice + CharData:GetSkillValue(47)/10;"); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2012-07-20 15:06:31
|
Revision: 8391 http://planeshift.svn.sourceforge.net/planeshift/?rev=8391&view=rev Author: lpancallo Date: 2012-07-20 15:06:25 +0000 (Fri, 20 Jul 2012) Log Message: ----------- removed extra text Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2012-07-20 12:44:35 UTC (rev 8390) +++ trunk/src/server/database/mysql/math_scripts.sql 2012-07-20 15:06:25 UTC (rev 8391) @@ -274,36 +274,6 @@ "); -Total = Distance * Probability * Quality * Skill + 0.2; - -SkillFactor = PlayerSkill / RequiredSkill; -if (SkillFactor>6) { - SkillFactor = 6; -} -if (SkillFactor<1) { - SkillFactor = 1; -} - -ToolFactor = 0.2*ToolQuality / RequiredToolQuality; -if (ToolFactor>2) { - ToolFactor = 2; -} -if (ToolFactor<1) { - ToolFactor = 1; -} - -RandomFactor = (0.4*rnd(1))+0.8; -ResultQuality = 50*SkillFactor*ToolFactor*RandomFactor; -if (ResultQuality>300) { - ResultQuality = 300; -} -if (ResultQuality<50) { - ResultQuality = 50; -} - -ResultQuality = floor(ResultQuality); - - INSERT INTO math_scripts VALUES( "Calc Item Merchant Price Buy", "Result = ItemPrice - CharData:GetSkillValue(47)/10;"); INSERT INTO math_scripts VALUES( "Calc Item Merchant Price Sell", "Result = ItemPrice + CharData:GetSkillValue(47)/10;"); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2013-06-04 08:04:47
|
Revision: 8718 http://sourceforge.net/p/planeshift/code/8718 Author: lpancallo Date: 2013-06-04 08:04:43 +0000 (Tue, 04 Jun 2013) Log Message: ----------- Fixed IsShield call. Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2013-06-02 12:25:58 UTC (rev 8717) +++ trunk/src/server/database/mysql/math_scripts.sql 2013-06-04 08:04:43 UTC (rev 8718) @@ -62,7 +62,7 @@ { if(Attacker:IsNPC) { - if(TargetWeapon:IsShield()) + if(TargetWeapon:IsShield) { Target:PracticeSkillID(TargetWeapon:Skill1,1); Target:PracticeSkillID(TargetWeapon:Skill2,1); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2013-06-04 08:35:25
|
Revision: 8719 http://sourceforge.net/p/planeshift/code/8719 Author: lpancallo Date: 2013-06-04 08:35:21 +0000 (Tue, 04 Jun 2013) Log Message: ----------- Fixed Agility call. Modified Paths: -------------- trunk/src/server/database/mysql/math_scripts.sql Modified: trunk/src/server/database/mysql/math_scripts.sql =================================================================== --- trunk/src/server/database/mysql/math_scripts.sql 2013-06-04 08:04:43 UTC (rev 8718) +++ trunk/src/server/database/mysql/math_scripts.sql 2013-06-04 08:35:21 UTC (rev 8719) @@ -84,7 +84,7 @@ AttackValue = WeaponSkill; TargetAttackValue = TargetWeaponSkill; - DV = Attacker:Agility; + DV = Attacker:GetSkillValue(46); TargetDV = 0; AVStance = if(AttackerStance=1, (AttackValue*2)+(DV*0.8), This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |