// 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); }