[code]
include ("funct.php");
include ("objects.php");
include ("excel.php");
addNoCache();
my_db_connect();
function PathView($dir,$xmldoc,$p_tag,$level) {
if ($handle = opendir($dir)) {
while (false !== ($file = readdir($handle))) {
if ($file != "." && $file != "..") {
$thistag = $xmldoc->create_element("file");
$thistag = $p_tag->append_child($thistag);
$atr = $thistag->set_attribute("fname",iconv('windows-1251','UTF-8',$file));
if (is_dir($dir.'/'.$file)) {
$atr = $thistag->set_attribute("type","dir");
$atr = $thistag->set_attribute("level",$level);
$xmldoc = PathView($dir.'/'.$file,$xmldoc,$thistag,$level+1);
}
else {
$atr = $thistag->set_attribute("type","file");
$atr = $thistag->set_attribute("level",$level);
$size = intval(ceil((filesize($dir.'/'.$file))/1024));
$atr = $thistag->set_attribute("size",$size);
$atr = $thistag->set_attribute("ffname",iconv('windows-1251','UTF-8',$dir.'/'.$file));
$fType=strtolower(substr(strrchr($file,"."),1));
$atr = $thistag->set_attribute("ftype",iconv('windows-1251','UTF-8',$fType));
$sql = "select * from files where filename='".$file."'";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result)) {
$atr = $thistag->set_attribute("descr",iconv('windows-1251','UTF-8',$row['name']));
}
}
}
}
closedir($handle);
}
return $xmldoc;
}
function delFile($fname,$folder) {
if (file_exists(realpath($folder)."/".$fname)) {
@unlink(realpath($folder)."/".$fname);
$sql="delete from files where name='".$fname."'";
mysql_query($sql);
}
}
function addFile($desc,$newFile,$folder) {
$fType=strtolower(substr(strrchr($_FILES['newFile']['name'],"."),1));
if (($fType!="xls")&&($fType!="doc")&&($fType!="pdf")&&($fType!="rtf")&&($fType!="zip")&&($fType!="rar")&&($fType!="jpg")&&($fType!="gif")&&($fType!="htm")&&($fType!="html")&&($fType!="txt")) {
echo "Ôàéëû äàííîãî òèïà ('.".$fType."') çàïðåùåíû ê êîïèðîâàíèþ íà ñàéò.";
exit;
}
$fname=$folder."/".$_FILES['newFile']['name'];
if (move_uploaded_file($_FILES['newFile']['tmp_name'], $fname)!= ""){
$filenum='';
$fname1=strtolower(substr($_FILES['newFile']['name'],0,strrpos($_FILES['newFile']['name'],".")));
$fname2=translate(substr($_FILES['newFile']['name'],0,strrpos($_FILES['newFile']['name'],".")));
if ($fname2!=$fname1) {
while (file_exists (realpath($folder)."/".$fname2.$filenum.".".$fType)) {
$filenum=$filenum+1;
}
rename(realpath($folder)."/".$_FILES['newFile']['name'],realpath($folder)."/".$fname2.$filenum.".".$fType);
}
else {
$fname2=$fname1;
$filenum='';
rename(realpath($folder)."/".$_FILES['newFile']['name'],realpath($folder)."/".$fname2.$filenum.".".$fType);
}
$sql = "insert into files (uid, filename, name)
values (null,'".$fname2.$filenum.".".$fType."','".$desc."');";
mysql_query($sql);
return true;
} else {
echo "Ôàéë íå áûë ñêîïèðîâàí. Ïðîâåðüòå íàëè÷èå äàííîãî ôàéëà íà èñõîäíîì ðåñóðñå.";
return false;
}
}
if ($_POST["katalog"]) {
parsing($_POST["filename_xls"],$_POST["katalog"]);
updatekat($_POST["katalog"]);
$sql="select * from kategtov where parent='".$_POST["katalog"]."'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
updatekat($row["uid"]);
}
createsite();
}
$xmldoc = domxml_new_doc("1.0");
$root = $xmldoc->create_element("root");
$root = $xmldoc->append_child($root);
$thistag = $xmldoc->create_element("folder");
$thistag = $root->append_child($thistag);
$atr = $thistag->set_attribute("name",$folder);
$thistag2 = $xmldoc->create_element("kategtov");
$thistag2 = $root->append_child($thistag2);
$sql = "select * from kategtov where parent='0';";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$thistag1 = $xmldoc->create_element("kat");
$thistag1 = $thistag2->append_child($thistag1);
$atr = $thistag1->set_attribute("uid",$row["uid"]);
$atr = $thistag1->set_attribute("name",iconv('windows-1251','UTF-8',$row["name"]));
}
$folder="../silovoe/prices";
$userfolder=realpath($folder);
$sitefolder=realpath('../silovoe');
if (strpos($userfolder, $sitefolder)!==false) {
if ($_POST["fdel"]!="" && $folder != "") {
delFile($_POST["fdel"],$folder);
}
if ($_POST["desc"] != "" && $_FILES["newFile"]['name'] != "" && $folder != "") {
//echo '111';
addFile($_POST["desc"],$_POST["newFile"],$folder);
}
$xmldoc = PathView($folder,$xmldoc,$root,0);
}
$xslfile = "m_price.xsl";
$html = my_process_4($xmldoc, $xslfile);
print $html;
[/code]