function copy_ftp($update_id) { global $settings; deleteupdatedfile($update_id); //no file in upload-folder? error! if ($_POST['filename'] == "") { die("<p class=\"msg\">No file defined!</p>"); } $oldfilename = $_POST['filename']; //rename or not?? if ($settings['rename'] == 1) { $newfilename = freshaudioname(); } else { $newfilename = tunefilename(urldecode($oldfilename)); } //copy the file and delete the old one $oldpath = $GLOBALS['uploadpath'] . urldecode($oldfilename); $newfilepath = $GLOBALS['audiopath'] . $newfilename; copy($oldpath, $newfilepath); unlink($oldpath); $filesize = filesize($newfilepath); //make a valid temp-title $temptitle = stripsuffix(htmlspecialchars(urldecode($oldfilename), ENT_QUOTES)); //big question: are we just updating or creating a new file? if (!$update_id) { //insert a new row to the database and fill it with some nice data $dosql = "INSERT INTO {$GLOBALS['prefix']}lb_postings\n (author_id, title, posted, \n filelocal, audio_file, audio_type, audio_size, status)\n VALUES\n ('{$_SESSION['authorid']}', '{$temptitle}', '" . date('Y-m-d H:i:s') . "',\n '1', '{$newfilename}', '" . type_suffix($newfilename) . "', \n '{$filesize}', '1');"; $result = mysql_query($dosql) or die(mysql_error()); //if the parser gets until here, all should be good echo "<p class=\"msg\">{$newfilename} - Copying was successful.</p>"; } else { //update an existing row in the database $dosql = "UPDATE {$GLOBALS['prefix']}lb_postings SET\n\n author_id = '{$_SESSION['authorid']}',\n posted = '" . date('Y-m-d H:i:s') . "',\n filelocal = '1', \n audio_file= '{$newfilename}',\n audio_type= '" . type_suffix($newfilename) . "',\n audio_length= '',\n audio_size= '{$filesize}' \n WHERE id = '{$update_id}';"; $result = mysql_query($dosql) or die(mysql_error()); } //get id for editing data after finishing this function $dosql = "SELECT id FROM {$GLOBALS['prefix']}lb_postings \n WHERE audio_file='{$newfilename}';"; $result = mysql_query($dosql) or die(mysql_error()); $row = mysql_fetch_assoc($result); return $row['id']; }
//we have only a link to a remote file? show other data! $link = $fields['audio_file']; //can...only...play...mp3...with...flash...player if ($fields['audio_type'] == 1) { echo "<object class=\"topspace2\" type=\"application/x-shockwave-flash\"\n"; echo "data=\"backend/emff_rec2.swf?src=" . $link . "\""; echo " width=\"295\" height=\"9\">\n"; echo "<param name=\"movie\" \n value=\"backend/emff_rec2.swf?src=" . $link . "\" />"; echo "</object>\n"; } //showing plain link echo "<table id=\"audiodata\">\n"; echo "<tr><td><a href=\"" . $link . "\">"; echo wordwrap($fields['audio_file'], 50, "<br />", 1) . "</a></td></tr>\n"; echo "</table>\n"; echo "<input type=\"hidden\" name=\"audio_type\" value=\"" . type_suffix($fields['audio_file']) . "\" />"; ?> <hr /> <!-- size --> <div class="rec2size"> <h3>Size</h3> <?php if ($fields['filelocal'] == 1) { echo "<input " . readonly($edit_id) . "type=\"text\" readonly=\"readonly\" "; echo "value=\"" . getmegabyte($fields['audio_size']) . " MB\" />"; echo "<input type=\"hidden\" name=\"audio_size\" "; echo "value=\"" . getmegabyte($fields['audio_size']) . "\" />";
function loop_comments($content) { //show a loop of all comments of a certain posting global $currentid; global $currentcomment; global $comments; global $tempfilename; global $allcomm; $att = getattributes($content); if (isset($att['global'])) { $allcomm = $att['global']; } else { $allcomm = "false"; } if (isset($att['number'])) { $number = $att['number']; } else { $number = 5; } $content = trim(stripcontainer($content)); $return = ""; //do we get the comments of the current posting? if ($allcomm == "false") { //getting some data from comments-table $dosql = "SELECT * FROM " . $GLOBALS['prefix'] . "lb_comments\n WHERE posting_id = " . $currentid . " ORDER BY posted ASC;"; $result = $GLOBALS['lbdata']->Execute($dosql); $comments = $result->GetArray(); if ($comments == false) { $numbcom = 0; } else { $numbcom = count($comments); } //only here for previewing? if (isset($_POST['commentpreview'])) { if ($tempfilename != "") { $id3 = getid3data($GLOBALS['audiopath'] . $tempfilename, "front"); $tempfilesize = $id3['size']; $tempfilelength = getseconds($id3['duration']); } else { $tempfilesize = "0"; $tempfilelength = "0"; } $comments[$numbcom]['id'] = 0; $comments[$numbcom]['posting_id'] = $currentid; $comments[$numbcom]['posted'] = date('Y-m-d H:i:s'); if ($_POST['commentname'] == "") { $comments[$numbcom]['name'] = "Anonymus"; } else { $comments[$numbcom]['name'] = htmlentities(strip_tags($_POST['commentname']), ENT_QUOTES, "UTF-8"); } $comments[$numbcom]['mail'] = strip_tags($_POST['commentmail']); $comments[$numbcom]['web'] = strip_tags($_POST['commentweb']); $comments[$numbcom]['ip'] = $_SERVER['REMOTE_ADDR']; $comments[$numbcom]['message_input'] = $_POST['commentmessage']; $comments[$numbcom]['message_html'] = "<p>[PREVIEW]</p> " . strip_tags(no_amp(makehtml(htmlentities($_POST['commentmessage'], ENT_QUOTES, "UTF-8")))); $comments[$numbcom]['audio_file'] = $tempfilename; $comments[$numbcom]['audio_size'] = $tempfilesize; $comments[$numbcom]['audio_length'] = $tempfilelength; $comments[$numbcom]['audio_type'] = type_suffix($tempfilename); } //okay, we show a list af ALL recent comments } else { $dosql = "SELECT * FROM " . $GLOBALS['prefix'] . "lb_comments ORDER BY posted DESC"; $result = $GLOBALS['lbdata']->SelectLimit($dosql, $number, 0); $comments = $result->GetArray(); if ($comments == false) { $comments = array(); } } //show every comment, one by one $i = 0; foreach ($comments as $thiscomment) { $currentcomment = $i; if ($allcomm == "false") { $return .= "<span id=\"com" . $thiscomment['id'] . "\"></span>"; } $return .= fullparse($content); $i += 1; } return $return; }
function loop_comments($content) { //show a loop of all comments of a certain posting global $currentid; global $currentcomment; global $comments; global $tempfilename; global $allcomm; $att = getattributes($content); if (isset($att['global'])) { $allcomm = $att['global']; } else { $allcomm = "false"; } if (isset($att['number'])) { $number = $att['number']; } else { $number = 5; } $content = trim(stripcontainer($content)); $return = ""; //do we get the comments of the current posting? if ($allcomm == "false") { //getting some data from comments-table $dosql = "SELECT * FROM " . $GLOBALS['prefix'] . "lb_comments \n WHERE posting_id='" . $currentid . "' ORDER BY posted ASC;"; $result = mysql_query($dosql) or die(mysql_error()); $i = 0; $comments = ""; while ($temp = mysql_fetch_assoc($result)) { $i += 1; $comments[$i] = $temp; } //only here for previewing? if (isset($_POST['commentpreview'])) { if ($tempfilename != "") { $id3 = getid3data($GLOBALS['audiopath'] . $tempfilename, "front"); $tempfilesize = $id3['size']; $tempfilelength = getseconds($id3['duration']); } else { $tempfilesize = "0"; $tempfilelength = "0"; } $i += 1; $comments[$i]['id'] = 0; $comments[$i]['posting_id'] = $currentid; $comments[$i]['posted'] = date('Y-m-d H:i:s'); if ($_POST['commentname'] == "") { $comments[$i]['name'] = "Anonymus"; } else { $comments[$i]['name'] = htmlentities($_POST['commentname'], ENT_QUOTES, "UTF-8"); } $comments[$i]['name'] = $comments[$i]['name']; $comments[$i]['mail'] = strip_tags($_POST['commentmail']); $comments[$i]['web'] = strip_tags($_POST['commentweb']); $comments[$i]['ip'] = $_SERVER['REMOTE_ADDR']; $comments[$i]['message_input'] = htmlentities(strip_tags($_POST['commentmessage']), ENT_QUOTES, "UTF-8"); $comments[$i]['message_html'] = "<p>[PREVIEW]</p> " . makehtml(strip_tags($_POST['commentmessage'])); $comments[$i]['audio_file'] = $tempfilename; $comments[$i]['audio_size'] = $tempfilesize; $comments[$i]['audio_length'] = $tempfilelength; $comments[$i]['audio_type'] = type_suffix($tempfilename); } //okay, we show a list af ALL recent comments } else { $dosql = "SELECT * FROM " . $GLOBALS['prefix'] . "lb_comments \n ORDER BY posted DESC LIMIT 0," . $number . ";"; $result = mysql_query($dosql) or die(mysql_error()); $i = 0; $comments = ""; while ($temp = mysql_fetch_assoc($result)) { $i += 1; $comments[$i] = $temp; } } //is there one or more comments? if ($i > 0) { $i = 1; //show every comment, one by one foreach ($comments as $thiscomment) { $currentcomment = $i; if ($allcomm == "false") { $return .= "<span id=\"com" . $comments[$i]['id'] . "\"></span>"; } $return .= fullparse($content); $i += 1; } } return $return; }
function copy_ftp($update_id) { global $settings; deleteupdatedfile($update_id); //no file in upload-folder? error! if ($_POST['filename'] == "") { die("<p class=\"msg\">" . bla("msg_noaudio") . "</p>"); } $oldfilename = $_POST['filename']; //do we rename the audio file? if ($settings['rename'] == 1) { //generate filename from posting date, if we update the file if ($update_id) { $dosql = "SELECT posted FROM " . $GLOBALS['prefix'] . "lb_postings WHERE id = '" . $update_id . "'"; $result = $GLOBALS['lbdata']->GetArray($dosql); $newfilename = buildaudioname(strrchr($_POST['filename'], "."), $settings['filename'], $result[0]['posted']); //get a fresh filename if we have a new posting } else { $newfilename = freshaudioname(strrchr($_POST['filename'], "."), $settings['filename']); } //if we don't rename, we will at least tune the filename } else { $newfilename = tunefilename(urldecode($oldfilename)); } //copy the file and delete the old one $oldpath = $GLOBALS['uploadpath'] . urldecode($oldfilename); $newfilepath = $GLOBALS['audiopath'] . $newfilename; copy($oldpath, $newfilepath); unlink($oldpath); //change the chmod chmod($newfilepath, 0777); $filesize = filesize($newfilepath); //make a valid temp-title $temptitle = stripsuffix(htmlspecialchars(urldecode($oldfilename), ENT_QUOTES)); //big question: are we just updating or creating a new file? if (!$update_id) { //insert a new row to the database and fill it with some nice data $dosql = "INSERT INTO {$GLOBALS['prefix']}lb_postings\n (author_id, title, posted, \n filelocal, audio_file, audio_type, audio_size, status, \n countweb, countfla, countpod, countall)\n VALUES\n ('{$_SESSION['authorid']}', '{$temptitle}', '" . date('Y-m-d H:i:s') . "',\n '1', '{$newfilename}', '" . type_suffix($newfilename) . "', \n '{$filesize}', '1','0','0','0','0')"; $GLOBALS['lbdata']->Execute($dosql); //add default id3 tags, if needed defaultid3tags($GLOBALS['audiopath'] . $newfilename, $temptitle); //if the parser gets until here, all should be good echo "<p class=\"msg\">" . $newfilename . " - " . bla("msg_copysuccess") . "</p>"; } else { //update an existing row in the database $dosql = "UPDATE {$GLOBALS['prefix']}lb_postings SET\n\n author_id = '{$_SESSION['authorid']}',\n filelocal = '1', \n audio_file= '{$newfilename}',\n audio_type= '" . type_suffix($newfilename) . "',\n audio_length= '',\n audio_size= '{$filesize}' \n WHERE id = '{$update_id}'"; $GLOBALS['lbdata']->Execute($dosql); //add default id3 tags, if needed defaultid3tags($GLOBALS['audiopath'] . $newfilename, gettitlefromid($update_id)); } //get id for editing data after finishing this function $dosql = "SELECT id FROM {$GLOBALS['prefix']}lb_postings \n WHERE audio_file='{$newfilename}'"; $result = $GLOBALS['lbdata']->GetArray($dosql); return $result[0]['id']; }