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>
