$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
Example #2
0
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