$query .= CheckMini('RegMin', $RegMin, $_RegMin); $query .= CheckMaxi('RegMax', $RegMax, $_RegMax); $query .= CheckMini('ArmMin', $ArmMin, $_ArmMin); $query .= CheckMaxi('ArmMax', $ArmMax, $_ArmMax); $query .= CheckMini('VueMin', $VueMin, $_VueMin); $query .= CheckMaxi('VueMax', $VueMax, $_VueMax); $query .= CheckValue('Pouvoir', $Pouvoir, $_Pouvoir); $query .= CheckMini('MMMin', $MMMin, $_MMMin); $query .= CheckMaxi('MMMax', $MMMax, $_MMMax); $query .= CheckMini('RMMin', $RMMin, $_RMMin); $query .= CheckMaxi('RMMax', $RMMax, $_RMMax); $query .= CheckValue('Vitesse', $Vitesse, $_Vitesse); $query .= CheckValue('VlC', $VlC, $_VlC); $query .= CheckValue('AttDist', $AttDist, $_AttDist); $query .= CheckMini('DLAMin', $DLAMin, $_DLAMin); $query .= CheckMaxi('DLAMax', $DLAMax, $_DLAMax); $query .= CheckValue('nbATT', $nbATT, $_nbATT); $query .= CheckValue('CapaRange', $CapaRange, $_CapaRange); if ($query != "") { $query = "UPDATE `MZ_Bestiaire` SET {$query} Age=\"{$Age}\" where (Nom=\"{$Nom}\") and (Age=\"{$Age}\")"; //echo "$query<BR>"; $result = MySQL_QUERY($query); } } #======================================================================================================= # EOF Looping for initial load echo "[{$Nom}*{$Age}] => Monstre checked!<br>"; } #======================================================================================================= _sqlclose(); # -------------- Fermeture DB
function MAJBestiaire2($cdmFamille,$cdmNom,$cdmAge,$cdmNivMin,$cdmNivMax,$cdmPdVMin,$cdmPdVMax,$cdmBlessure,$cdmAttMin,$cdmAttMax,$cdmEsqMin,$cdmEsqMax,$cdmDegMin,$cdmDegMax,$cdmRegMin,$cdmRegMax,$cdmArmMin,$cdmArmMax,$cdmArmMagMin, $cdmArmMagMax, $cdmVueMin,$cdmVueMax,$cdmPouvoir,$cdmMMMin,$cdmMMMax,$cdmRMMin,$cdmRMMax,$cdmNbAtt,$cdmVitesse,$cdmVlC,$cdmAttDist, $cdmAttMag, $cdmVole, $cdmSangFroid, $cdmDLA,$cdmDLAMin,$cdmDLAMax,$cdmChargement,$cdmBonusMalus,$cdmCapaRange) { global $__MAX; # BORNE SUP DU BESTIARE ------------------------------------------------------ if ($cdmNivMax==0) $cdmNivMax=$__MAX; if ($cdmPdVMax==0) $cdmPdVMax=$__MAX; if ($cdmAttMax==0) $cdmAttMax=$__MAX; if ($cdmEsqMax==0) $cdmEsqMax=$__MAX; if ($cdmDegMax==0) $cdmDegMax=$__MAX; if ($cdmRegMax==0) $cdmRegMax=$__MAX; if ($cdmArmMax==0) $cdmArmMax=$__MAX; if ($cdmArmMagMax==0) $cdmArmMagMax=$__MAX; if ($cdmVueMax==0) $cdmVueMax=$__MAX; if ($cdmMMMax==0) $cdmMMMax=$__MAX; if ($cdmRMMax==0) $cdmRMMax=$__MAX; if ($cdmDLAMax==0) $cdmDLAMax=$__MAX; # Mise à jour du BESTIAIRE ------------------------------------------------------ $query = "SELECT * FROM `MZ_Beast2` where (Nom=\"$cdmNom\") and (Age=\"$cdmAge\")"; //echo "$query<BR>"; $result = MySQL_QUERY($query); $nData = @MySQL_NUM_ROWS($result); if ($nData==0) { $query = "INSERT INTO `MZ_Beast2` VALUES ('$cdmFamille','$cdmNom','$cdmAge',$cdmNivMin,$cdmNivMin,$cdmNivMax,$cdmNivMax,$cdmPdVMin,$cdmPdVMin,$cdmPdVMax,$cdmPdVMax,$cdmAttMin,$cdmAttMin,$cdmAttMax,$cdmAttMax,$cdmEsqMin,$cdmEsqMin,$cdmEsqMax,$cdmEsqMax,$cdmDegMin,$cdmDegMin,$cdmDegMax,$cdmDegMax,$cdmRegMin,$cdmRegMin,$cdmRegMax,$cdmRegMax,$cdmArmMin,$cdmArmMin,$cdmArmMax,$cdmArmMax,$cdmArmMagMin,$cdmArmMagMin,$cdmArmMagMax,$cdmArmMagMax,$cdmVueMin,$cdmVueMin,$cdmVueMax,$cdmVueMax,'$cdmPouvoir',$cdmMMMin,$cdmMMMin,$cdmMMMax,$cdmMMMax,$cdmRMMin,$cdmRMMin,$cdmRMMax,$cdmRMMax,\"$cdmnbATT\",\"$cdmVitesse\",\"$cdmVlC\",\"$cdmAttDist\",\"$cdmAttMag\",\"$cdmVole\",\"$cdmSangFroid\",\"$cdmDLA\",$cdmDLAMin,$cdmDLAMin,$cdmDLAMax,$cdmDLAMax,\"$cdmChargement\",\"$cdmBonusMalus\",\"$cdmCapaRange\" )"; //echo "$query<BR>"; $result = MySQL_QUERY($query); return; } $query = ""; $NivMinInf=mysql_result($result,0,"NivMinInf"); $NivMinSup=mysql_result($result,0,"NivMinSup"); $NivMaxInf=mysql_result($result,0,"NivMaxInf"); $NivMaxSup=mysql_result($result,0,"NivMaxSup"); $query .= CheckLimite('Niv', $cdmNivMin, $cdmNivMax, $NivMinInf, $NivMinSup, $NivMaxInf, $NivMaxSup ); $PdVMinInf=mysql_result($result,0,"PdVMinInf"); $PdVMinSup=mysql_result($result,0,"PdVMinSup"); $PdVMaxInf=mysql_result($result,0,"PdVMaxInf"); $PdVMaxSup=mysql_result($result,0,"PdVMaxSup"); $query .= CheckLimite('PdV', $cdmPdVMin, $cdmPdVMax, $PdVMinInf, $PdVMinSup, $PdVMaxInf, $PdVMaxSup ); $AttMinInf=mysql_result($result,0,"AttMinInf"); $AttMinSup=mysql_result($result,0,"AttMinSup"); $AttMaxInf=mysql_result($result,0,"AttMaxInf"); $AttMaxSup=mysql_result($result,0,"AttMaxSup"); $query .= CheckLimite('Att', $cdmAttMin, $cdmAttMax, $AttMinInf, $AttMinSup, $AttMaxInf, $AttMaxSup ); $EsqMinInf=mysql_result($result,0,"EsqMinInf"); $EsqMinSup=mysql_result($result,0,"EsqMinSup"); $EsqMaxInf=mysql_result($result,0,"EsqMaxInf"); $EsqMaxSup=mysql_result($result,0,"EsqMaxSup"); $query .= CheckLimite('Esq', $cdmEsqMin, $cdmEsqMax, $EsqMinInf, $EsqMinSup, $EsqMaxInf, $EsqMaxSup ); $DegMinInf=mysql_result($result,0,"DegMinInf"); $DegMinSup=mysql_result($result,0,"DegMinSup"); $DegMaxInf=mysql_result($result,0,"DegMaxInf"); $DegMaxSup=mysql_result($result,0,"DegMaxSup"); $query .= CheckLimite('Deg', $cdmDegMin, $cdmDegMax, $DegMinInf, $DegMinSup, $DegMaxInf, $DegMaxSup ); $RegMinInf=mysql_result($result,0,"RegMinInf"); $RegMinSup=mysql_result($result,0,"RegMinSup"); $RegMaxInf=mysql_result($result,0,"RegMaxInf"); $RegMaxSup=mysql_result($result,0,"RegMaxSup"); $query .= CheckLimite('Reg', $cdmRegMin, $cdmRegMax, $RegMinInf, $RegMinSup, $RegMaxInf, $RegMaxSup ); $ArmMinInf=mysql_result($result,0,"ArmMinInf"); $ArmMinSup=mysql_result($result,0,"ArmMinSup"); $ArmMaxInf=mysql_result($result,0,"ArmMaxInf"); $ArmMaxSup=mysql_result($result,0,"ArmMaxSup"); $query .= CheckLimite('Arm', $cdmArmMin, $cdmArmMax, $ArmMinInf, $ArmMinSup, $ArmMaxInf, $ArmMaxSup ); $ArmMagMinInf=mysql_result($result,0,"ArmMagMinInf"); $ArmMagMinSup=mysql_result($result,0,"ArmMagMinSup"); $ArmMagMaxInf=mysql_result($result,0,"ArmMagMaxInf"); $ArmMagMaxSup=mysql_result($result,0,"ArmMagMaxSup"); $query .= CheckLimite('ArmMag', $cdmArmMagMin, $cdmArmMagMax, $ArmMagMinInf, $ArmMagMinSup, $ArmMagMaxInf, $ArmMagMaxSup ); $VueMinInf=mysql_result($result,0,"VueMinInf"); $VueMinSup=mysql_result($result,0,"VueMinSup"); $VueMaxInf=mysql_result($result,0,"VueMaxInf"); $VueMaxSup=mysql_result($result,0,"VueMaxSup"); $query .= CheckLimite('Vue', $cdmVueMin, $cdmVueMax, $VueMinInf, $VueMinSup, $VueMaxInf, $VueMaxSup ); $MMMinInf=mysql_result($result,0,"MMMinInf"); $MMMinSup=mysql_result($result,0,"MMMinSup"); $MMMaxInf=mysql_result($result,0,"MMMaxInf"); $MMMaxSup=mysql_result($result,0,"MMMaxSup"); $query .= CheckLimite('MM', $cdmMMMin, $cdmMMMax, $MMMinInf, $MMMinSup, $MMMaxInf, $MMMaxSup ); $RMMinInf=mysql_result($result,0,"RMMinInf"); $RMMinSup=mysql_result($result,0,"RMMinSup"); $RMMaxInf=mysql_result($result,0,"RMMaxInf"); $RMMaxSup=mysql_result($result,0,"RMMaxSup"); $query .= CheckLimite('RM', $cdmRMMin, $cdmRMMax, $RMMinInf, $RMMinSup, $RMMaxInf, $RMMaxSup ); $DLAMinInf=mysql_result($result,0,"DLAMinInf"); $DLAMinSup=mysql_result($result,0,"DLAMinSup"); $DLAMaxInf=mysql_result($result,0,"DLAMaxInf"); $DLAMaxSup=mysql_result($result,0,"DLAMaxSup"); $query .= CheckLimite('DLA', $cdmDLAMin, $cdmDLAMax, $DLAMinInf, $DLAMinSup, $DLAMaxInf, $DLAMaxSup ); $query .= CheckValue('Pouvoir',$cdmPouvoir, mysql_result($result,0,"Pouvoir")); $query .= CheckValue('nbATT',$cdmNbAtt, mysql_result($result,0,"nbATT")); $query .= CheckValue('Vitesse',$cdmVitesse, mysql_result($result,0,"Vitesse")); $query .= CheckValue('VlC',$cdmVlC, mysql_result($result,0,"VlC")); $query .= CheckValue('AttDist',$cdmAttDist, mysql_result($result,0,"AttDist")); $query .= CheckValue('AttMag',$cdmAttMag, mysql_result($result,0,"AttMag")); $query .= CheckValue('Vole',$cdmVole, mysql_result($result,0,"Vole")); $query .= CheckValue('SangFroid',$cdmSangFroid, mysql_result($result,0,"SangFroid")); $query .= CheckValue('CapaRange',$cdmCapaRange, mysql_result($result,0,"CapaRange")); if ($query!="") { $query = "UPDATE `MZ_Beast2` SET $query Age=\"$cdmAge\" where (Nom=\"$cdmNom\") and (Age=\"$cdmAge\")"; //echo "$query<BR>"; $result = MySQL_QUERY($query); } return; } // Fin MAJ Bestiaire