// strip extention
$file_ext = substr($filename, strripos($filename, '.'));
$size = $_FILES['Filedata']['size'] / 1024;
$sort_number = getUsortNumber('multimedia', 'ASC', 'feature_id', $feature_id);
/*************************************************************************************************************************
CHECK THE MAX NUMBER OF PICS ALLOWED AND DELETE THE LAST ONE IF MAX NUMBER REACHED
**************************************************************************************************************************/
if (getSetting('max_upload', $feature_id) > 0) {
$mySQL = "SELECT * FROM multimedia WHERE vignette_id = '{$vignette_id}' AND feature_id = '{$feature_id}' AND status >0";
$recSET = mysql_query($mySQL) or die(mysql_error());
if (mysql_num_rows($recSET) >= getSetting('max_upload', $feature_id)) {
$mySQL = $mySQL . " ORDER BY usort DESC";
$recSET = mysql_query($mySQL) or die(mysql_error());
$recROW = mysql_fetch_assoc($recSET);
$multimedia_id = $recROW['multimedia_id'];
deleteMultimedia($multimedia_id);
}
}
/*************************************************************************************************************************
INSERT A NEW RECORD IN THE MULTIMEDIA TABLE AND USE THE ID AS THE NAME FOR THE FILE
**************************************************************************************************************************/
$mySQL = "INSERT INTO multimedia (vignette_id, picture_type, multimedia_type, multimedia_name, size, extension, date, status, feature_id, usort) \r\n\t\t\t\t\t\t\t\t\t\t\t\tVALUES ('{$vignette_id}', '{$target_large}', '{$multimedia_type}', '{$filename}', '{$size}', '{$file_ext}', now(), '3', '{$feature_id}', '{$sort_number}')";
mysql_query($mySQL) or die(mysql_error());
$name = mysql_insert_id() . "{$file_ext}";
if (empty($_GET['vignette_id'])) {
$name = session_id() . "{$file_ext}";
}
$tempFile = $_FILES['Filedata']['tmp_name'];
$targetFile = "{$docRoot}{$target_original}{$name}";
/*************************************************************************************************************************
CREATE THE FOLDER IF NOT EXISTS AND MOVE THE UPLOADED FILE IN IT
function deleteVignette($vignette_id)
{
$mySQL2 = "SELECT * FROM multimedia WHERE vignette_id = '{$vignette_id}' AND status > 0";
$recSET2 = mysql_query($mySQL2) or die(mysql_error());
while ($recROW2 = mysql_fetch_assoc($recSET2)) {
$multimedia_id = $recROW2['multimedia_id'];
deleteMultimedia($multimedia_id);
}
$mySQL = "UPDATE vignette SET status = 0 WHERE vignette_id = '{$vignette_id}'";
mysql_query($mySQL);
}
