function edit() { if ($_POST['parent'] == '0') { $sql = ' UPDATE {{infoblock}} SET name=\'' . trim($_POST['name']) . '\', path=\'' . trim($_POST['path']) . '\' WHERE id=' . $_POST['id'] . ' '; } else { $sql = ' UPDATE {{infoblock}} SET name=\'' . trim($_POST['name']) . '\', path=\'' . (trim($_POST['path']) == '' ? Funcs::Transliterate(trim($_POST['name'])) : Funcs::Transliterate(trim($_POST['path']))) . '\', description=\'' . $_POST['description'] . '\', source=\'' . $_POST['source'] . '\', type=\'' . $_POST['type'] . '\', bdate=\'' . date('Y-m-d H:i:s', strtotime(trim($_POST['bdate']))) . '\', edate=\'' . date('Y-m-d H:i:s', strtotime(trim($_POST['edate']))) . '\' WHERE id=' . $_POST['id'] . ' '; } DB::exec($sql); }
public function ask($tree) { foreach ($_POST as $key => $value) { $_POST[$key] = htmlspecialchars(trim(strip_tags($value))); } if ($_POST['kcaptcha'] == $_SESSION['captcha_keystring'] && $_POST['kcaptcha'] != '' && $_SESSION['captcha_keystring'] != '') { $sql = ' INSERT INTO {{tree}} SET parent=' . $tree . ', name=\'' . trim($_POST['question']) . '\', path=\'' . Funcs::Transliterate(trim($_POST['question'])) . '\', seo_title=\'' . trim($_POST['question']) . '\', seo_keywords=\'' . trim($_POST['question']) . '\', seo_description=\'' . trim($_POST['question']) . '\', udate=NOW(), cdate=NOW(), visible=0, site=' . $_SESSION['site'] . ', num=0 '; $id = DB::exec($sql); $sql = ' INSERT INTO {{relations}} SET modul1=\'tree\', modul2=\'faq\', id1=\'' . $id . '\', id2=1, cdate=NOW() '; DB::exec($sql); //Fields::insertField($id,'answer',$_POST['message']); //Fields::insertField($id,'phone',$_POST['phone']); $text = ' <b>Email:</b> <a href="mailto:' . trim($_POST['email']) . '">' . trim($_POST['email']) . '</a><br /> <b>Вопрос:</b> ' . trim($_POST['question']) . '<br /> '; $mail = new Email(); $mail->To(Funcs::$conf['email']['faq']); $mail->Subject('Задан вопрос на сайте ' . $_SERVER['HTTP_HOST']); $mail->Text($text); $mail->Send(); return false; } else { return true; } }
function catalogOne($from, $to) { $data = array(); $i = 0; $sql = 'SELECT * FROM model WHERE parent=\'' . $from . '\''; $items = DB::getAll($sql); foreach ($items as $item) { if (!$temp) { $data = array('parent' => $to, 'name' => $item['name'], 'seo_title' => $item['title'] == '' ? $item['name'] : $item['title'], 'seo_keywords' => $item['kw'] == '' ? $item['name'] : $item['kw'], 'seo_description' => $item['descr'] == '' ? $item['name'] : $item['descr'], 'description' => $item['small_descr'], 'fulltext' => $item['full_descr'], 'model' => $item['model'], 'market' => $item['market'], 'price' => $item['price'], 'visible' => $item['visible'], 'available' => $item['sale'], 'udate' => date('Y-m-d H:i'), 'path' => Funcs::Transliterate($item['name']), 'oldid' => $item['ID']); $id = site::setPage($data, $i); $i++; } } //print '<pre>'; //print_r($data); }
public function step4() { $tree = array('name' => $_SESSION['iuser']['upload']['title']); $id = Tree::addTree($_SESSION['iuser']['upload']['spec'], $tree, 'catalog'); if (file_exists($_SESSION['iuser']['upload']['filecover']['path']) && file_exists($_SESSION['iuser']['upload']['filepages']['path'])) { $dir = $_SERVER['DOCUMENT_ROOT'] . IUSER_DIR . md5('fotouser' . $_SESSION['iuser']['id']) . '/'; if (!file_exists($dir)) { mkdir($dir, 0777); } $dir = $dir . md5('fotobook' . $id) . '/'; mkdir($dir, 0777); for ($file2i = 0; $file2i < 2; $file2i++) { if ($file2i == 0) { $filename = explode('.', $_SESSION['iuser']['upload']['filecover']['name']); $filesource = $_SESSION['iuser']['upload']['filecover']['path']; } else { $filename = explode('.', $_SESSION['iuser']['upload']['filepages']['name']); $filesource = $_SESSION['iuser']['upload']['filepages']['path']; } $raz = $filename[count($filename) - 1]; unset($filename[count($filename) - 1]); $filename = implode('', $filename); $filenameraz = Funcs::Transliterate($filename) . '.' . $raz; $dirfile = $dir . $filenameraz; $x = 0; $i = 1; while ($x == 0) { if (file_exists($dirfile)) { $filenameraz = Funcs::Transliterate($filename) . $i . '.' . $raz; $dirfile = $dir . md5($filename) . '/' . $filenameraz; } else { $x = 1; } $i++; } copy($filesource, $dirfile); chmod($dirfile, 0777); unlink($filesource); if ($file2i == 0) { $filename1 = $filenameraz; } else { $filename2 = $filenameraz; } } } $price = Basket::getPrice('session'); $sql = ' INSERT INTO {{catalog}} SET tree=' . $id . ', description=\'' . $_SESSION['iuser']['upload']['description'] . '\', phrase=\'' . $_SESSION['iuser']['upload']['phrase'] . '\', author=\'' . $_SESSION['iuser']['upload']['author'] . '\', private=' . $_SESSION['iuser']['upload']['private'] . ', booksize=' . $_SESSION['iuser']['upload']['booksize'] . ', countpage=' . $_SESSION['iuser']['upload']['countpage'] . ', binding=' . $_SESSION['iuser']['upload']['binding'] . ', paper=' . $_SESSION['iuser']['upload']['paper'] . ', price=' . $price . ', filecover=\'' . $filename1 . '\', filepages=\'' . $filename2 . '\', vendor=' . $_SESSION['iuser']['id'] . ' '; DB::exec($sql); unset($_SESSION['iuser']['upload']); $_SESSION['iuser']['upload']['id'] = $id; $_SESSION['iuser']['upload']['price'] = $price; Upload::addGallery($id, $filename1, $filename2, $dir); Email::uploadSend(); }
public function multiupload() { //print_r($_FILES);die; $data = array(); if ($_FILES['upload']['name']) { $userdir = substr(UPLOAD_DIR, 0, strlen(UPLOAD_DIR) - 1); if (Funcs::$prop['sitedir'] == 0) { $userdir = UPLOAD_DIR . Funcs::$site; if (!file_exists($_SERVER['DOCUMENT_ROOT'] . $userdir)) { mkdir($_SERVER['DOCUMENT_ROOT'] . $userdir, 0777); chmod($_SERVER['DOCUMENT_ROOT'] . $userdir, 0777); mkdir($_SERVER['DOCUMENT_ROOT'] . $userdir . PHOTO_DIR, 0777); chmod($_SERVER['DOCUMENT_ROOT'] . $userdir . PHOTO_DIR, 0777); mkdir($_SERVER['DOCUMENT_ROOT'] . $userdir . FILES_DIR, 0777); chmod($_SERVER['DOCUMENT_ROOT'] . $userdir . FILES_DIR, 0777); } } $module = Module::getModuleByTree($_REQUEST['id']); foreach ($_FILES['upload']['name'] as $key => $name) { $dir = ''; $outdir = ''; $filename = explode('.', $name); $raz = strtolower($filename[count($filename) - 1]); unset($filename[count($filename) - 1]); $filename = implode('', $filename); $filenameraz = Funcs::Transliterate($filename) . '.' . $raz; if (in_array(strtolower($raz), array('jpeg', 'jpg', 'png', 'gif', 'bmp'))) { $dir = $_SERVER['DOCUMENT_ROOT'] . $userdir . PHOTO_DIR . $module['path'] . '/'; $outdir = $userdir . PHOTO_DIR . $module['path'] . '/'; } else { $dir = $_SERVER['DOCUMENT_ROOT'] . $userdir . FILES_DIR . $module['path'] . '/'; $outdir = $userdir . FILES_DIR . $module['path'] . '/'; } if (!file_exists($dir)) { mkdir($dir, 0777); chmod($dir, 0777); } $dirfile = $dir . $filenameraz; $x = 0; $i = 1; while ($x == 0) { if (file_exists($dirfile)) { $filenameraz = Funcs::Transliterate($filename) . $i . '.' . $raz; $dirfile = $dir . $filenameraz; } else { $x = 1; } $i++; } move_uploaded_file($_FILES['upload']['tmp_name'][$key], $dirfile); chmod($dirfile, 0777); $path = $outdir . $filenameraz; $data[] = Fields::setFile($_REQUEST['id'], $_REQUEST['path'], $path); } $list = $data; $data = array(); foreach ($list as $item) { $data[] = $item['id']; } } return $data; }
public static function upload($id) { if (is_array($_FILES['upload']['name'])) { $dir = '/u/files/reference/' . $id . '/'; if (!is_dir($_SERVER['DOCUMENT_ROOT'] . '/u/files/reference/')) { mkdir($_SERVER['DOCUMENT_ROOT'] . '/u/files/reference/', 0777); /*$sql=' CREATE TABLE IF NOT EXISTS `one_reference_files` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `reference` int(10) unsigned NOT NULL, `path` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; '; DB::exec($sql);*/ } if (!is_dir($_SERVER['DOCUMENT_ROOT'] . $dir)) { mkdir($_SERVER['DOCUMENT_ROOT'] . $dir, 0777); } foreach ($_FILES['upload']['name'] as $key => $item) { $item = explode('.', $item); $raz = end($item); unset($item[count($item) - 1]); $item = Funcs::Transliterate(implode('', $item)); $i = 1; $name = $item; while (file_exists($_SERVER['DOCUMENT_ROOT'] . $dir . $name . '.' . $raz)) { $name = $item . $i; $i++; } $item = $name . '.' . $raz; $name = $item; if ($_POST['filename'][$key] != '') { $name = $_POST['filename'][$key]; } $sql = ' INSERT INTO {{reference_files}} SET reference=' . $id . ', path=\'' . $dir . $item . '\', name=\'' . $name . '\' '; DB::exec($sql); move_uploaded_file($_FILES['upload']['tmp_name'][$key], $_SERVER['DOCUMENT_ROOT'] . $dir . $item); } } }
private static function processName($file, $dealer) { $ext = pathinfo($file, PATHINFO_EXTENSION); $filename = pathinfo($file, PATHINFO_FILENAME); return Funcs::Transliterate($filename) . '_' . $dealer . '.' . $ext; }
public function avatar() { if ($_FILES['upload']['name']) { $dir = ''; $outdir = ''; $filename = explode('.', $_FILES['upload']['name']); $raz = $filename[count($filename) - 1]; if (in_array(strtolower($raz), array('jpeg', 'jpg', 'png', 'gif', 'bmp'))) { unset($filename[count($filename) - 1]); $filename = implode('', $filename); $filenameraz = Funcs::Transliterate($filename) . '.' . $raz; $dir = $_SERVER['DOCUMENT_ROOT'] . PHOTO_DIR . 'iuser/'; $dirfile = $dir . $filenameraz; $x = 0; $i = 1; while ($x == 0) { if (file_exists($dirfile)) { $filenameraz = Funcs::Transliterate($filename) . $i . '.' . $raz; $dirfile = $dir . $filenameraz; } else { $x = 1; } $i++; } Funcs::resizePicCrop($_FILES['upload']['tmp_name'], $dirfile, 80, 80, $raz); chmod($dirfile, 0777); if (file_exists($_SERVER['DOCUMENT_ROOT'] . $_SESSION['iuser']['avatar'])) { unlink($_SERVER['DOCUMENT_ROOT'] . $_SESSION['iuser']['avatar']); } $dirfile = substr($dirfile, strpos($dirfile, PHOTO_DIR), strlen($dirfile)); $sql = ' UPDATE {{iusers}} SET avatar=\'' . $dirfile . '\' WHERE id=' . $_SESSION['iuser']['id'] . ' '; DB::exec($sql); User::setSession(); } } }
public function addTree($parent, $tree, $module = '') { $path = $tree['path']; if ($path == '') { $path = $tree['name']; } $path = Funcs::Transliterate($path); if ($tree['seo_title'] == '') { $tree['seo_title'] = $tree['name']; } if ($tree['seo_keywords'] == '') { $tree['seo_keywords'] = $tree['name']; } if ($tree['seo_description'] == '') { $tree['seo_description'] = $tree['name']; } $udate = $tree['udate']; if (trim($udate) == '') { $udate = date("d.m.Y H:i:00"); } $sql = ' INSERT INTO {{tree}} SET parent=' . $parent . ', name=\'' . $tree['name'] . '\', path=\'' . $path . '\', seo_title=\'' . $tree['seo_title'] . '\', seo_keywords=\'' . $tree['seo_keywords'] . '\', seo_description=\'' . $tree['seo_description'] . '\', udate=\'' . date('Y-m-d H:i:s', strtotime($udate)) . '\', cdate=NOW(), visible=' . ($tree['visible'] == '' ? '0' : '1') . ', menu=0, site=' . $_SESSION['site'] . ' '; $id = DB::exec($sql); if ($module) { $tree['info']['path'] = $module; } else { $tree['info'] = Tree::getInfo($parent); } $sql = ' INSERT INTO {{relations}} SET modul1=\'tree\', modul2=\'' . $tree['info']['path'] . '\', id1=\'' . $id . '\', id2=1, cdate=NOW() '; DB::exec($sql); //Tree::saveSearch($id); return $id; }
public function editTree($id = '') { Tree::saveSearch(); if ($id == '') { $id = $_POST['id']; } $path = trim($_POST['path']); if ($path == '') { $path = $_POST['name']; } $path = Funcs::Transliterate($path); $sql = ' UPDATE {{tree}} SET parent=' . $_POST['parent'] . ', name=\'' . trim($_POST['name']) . '\', path=\'' . $path . '\', seo_title=\'' . trim($_POST['seo_title']) . '\', seo_keywords=\'' . trim($_POST['seo_keywords']) . '\', seo_description=\'' . trim($_POST['seo_description']) . '\', udate=\'' . date('Y-m-d H:i:s', strtotime($_POST['udate'])) . '\', cuser='******'user']['id'] . ' WHERE id=' . $id . ' '; return DB::exec($sql); }
<?php } ?> </div> </div> <?php } ?> </header> <div class="ckeditor_layout"> <textarea class="ckeditor_textarea input_text sethere" name="data[<?php echo $path; ?> ]" id="data_<?php echo Funcs::Transliterate($path); ?> "><?php echo $value; ?> </textarea> <input type="hidden" class="text" value="editor" name="fieldtypes[]"> </div> <script language="javascript"> $(document).ready( function(){ initEditor($("#data_<?php echo Funcs::Transliterate($path); ?> ")); }); </script> </li>