uawdijnntqw1x1x1
IP : 216.73.216.155
Hostname : vm5018.vps.agava.net
Kernel : Linux vm5018.vps.agava.net 3.10.0-1127.8.2.vz7.151.14 #1 SMP Tue Jun 9 12:58:54 MSK 2020 x86_64
Disable Function : None :)
OS : Linux
PATH:
/
var
/
www
/
iplanru
/
data
/
www
/
.
/
i-plan.ru
/
administrator
/
components
/
com_mover
/
mover2.php
/
/
<?php //ini_set('display_errors',1);error_reporting(E_ALL); defined( '_JEXEC' ) or die( 'Restricted access' ); $date = date("Y-m-d"); $date_time = date("Y-m-d H:i:s"); $db =&JFactory::getDBO(); $null_value="************************"; global $mainframe; $Itemid = JRequest::getInt( 'Itemid', 1, 'get' ); $h[]= '<form action="'.JRoute::_( 'index.php?option=com_mover&Itemid='.$Itemid ).'" method="POST">'; //---------------------------------------------------------------------- $h[]= '<fieldset>'; $db->setQuery('SELECT c.id as id, concat(s.title," - ",c.title) as name FROM aaa_sections s, aaa_categories c where s.id=c.section order by s.id, c.id', 0, $count); $rows = $db->loadObjectList(); $h[]= ' Из <select name="from_cat_id">'; $h[]= '<option value="-1" selected="selected"> - Выберите категорию - '; $h[]= '<option value="0"'; if ($selected_id==$row->id){$h[]= ' selected';} $h[]='>'; $h[]='Без категории'; foreach ($rows as $row) { $h[]= '<option value="'.$row->id.'"'; if ($_POST[from_cat_id]==$row->id) $h[]= ' selected'; $h[]= '>'.$row->name; } $h[]= '</select>'; $h[]= ' В <select id="to_cat_id" name="to_cat_id">'; $h[]=ShowTree($db,0, 0, 0, 1,$_POST[to_cat_id]); $h[]='</select>'; $h[]= ' <input type="checkbox" name="save" value="1" />Сохранить'; $h[]= ' <input type="submit" value="Применить" />'; $h[]= '</fieldset>'; //---------------------------------------------------------------------- if ($_POST[from_cat_id]<>'') { $h[]= '<fieldset>'; $db->setQuery('SELECT * FROM aaa_articles a, aaa_content c where c.id=a.id and (a.type="mi" or a.type="bp") and c.catid='.$_POST[from_cat_id].' order by c.id limit 1', 0, $count); $rows = $db->loadObjectList(); foreach ($rows as $row){ $h[]= '<b>title: </b>'.$row->title.'<br>'; $param_title=$row->title; $h[]= '<b>id: </b>'.$row->id.'<br>'; $param_id=$row->id; $h[]= '<b>metakey: </b>'.$row->metakey.'<br>'; $param_metakey=$row->metakey; $h[]= '<b>metadesc: </b>'.$row->metadesc.'<br>'; $param_metadesc=$row->metadesc; $h[]= '<b>Дата выхода: </b>'.$row->date.'<br>'; $param_exit_date=$row->date; //save--------------------------------- if ($_POST['save']=='1' and $_POST[to_cat_id]<>'') { $js_temp=mvGetValue($db,'val',"select elements as val from #__zoo_item where id={$param_id}"); if (!empty($js_temp)) { $js=json_decode($js_temp,true); $js['667ea4d6-3745-40b5-b2a2-41fdc13b9a47']['0']['value']=$param_exit_date; $js_text=json_encode($js, JSON_FORCE_OBJECT); $js_text=str_replace("\\","\\\\",$js_text); $js_text=str_replace('"','\"',$js_text); $par=json_decode(mvGetValue($db,'val',"select params as val from #__zoo_item where id={$param_id}"),true); $par['metadata.description']=$param_metadesc; $par['metadata.keywords']=$param_keywords; $par=json_encode($par, JSON_FORCE_OBJECT); $par=str_replace("\\","\\\\",$par); $par=str_replace('"','\"',$par); $query = "UPDATE #__zoo_item SET elements=\"{$js_text}\",params=\"{$par}\" WHERE id={$param_id}"; $db->setquery($query);$b=$db->query($query); if ($b) $h[]= '<span style="color:green;">Материал сохранен</span><br>'; else $h[]= '<span style="color:red;">Ошибка запроса</span><br>'; } else { $h[]= '<span style="color:red;">Материал не найден</span><br>'; } } $h[]= '<hr>'; } $h[]= '</fieldset>'; } $h[]= '</form>'; echo implode("\r\n",$h); //====================================================================== function ShowTree($db,$ParentID, $lvl, $id_cat, $id_app, $selected_id) { global $lvl; $lvl++; $hf=''; $count=''; $db->setQuery("SELECT * FROM #__zoo_category WHERE parent=".$ParentID." and application_id=".$id_app." ORDER BY ordering", 0, $count); $rows = $db->loadObjectList(); foreach ($rows as $row) { $hf .= '<option value="'.$row->id.'"'; if ($selected_id==$row->id){$hf .= ' selected';} $hf.='>'; for ($i=2;$i<=$lvl;$i++){$hf.='--';} $hf.=$row->name; $hf.=ShowTree($db,$row->id, $lvl, $id_cat, $id_app,$selected_id); } $lvl--; return $hf; } function mvGetValue($db,$field,$sql) { $count=''; $ret=''; $db->setQuery($sql, 0, $count); $rows = $db->loadObjectList(); if (count($rows)<>0) foreach ($rows as $row) {$ret=$row->$field;}; return $ret; } function myalias($str) { $str=GetInTranslit($str); $str=strtolower(substr(trim(preg_replace('/[^0-9a-zA-Z]+/','-',$str),'-'),0,63)); return $str; } function GetInTranslit($string) { $replace=array( "'"=>"", "`"=>"", "а"=>"a","А"=>"a", "б"=>"b","Б"=>"b", "в"=>"v","В"=>"v", "г"=>"g","Г"=>"g", "д"=>"d","Д"=>"d", "е"=>"e","Е"=>"e", "ж"=>"zh","Ж"=>"zh", "з"=>"z","З"=>"z", "и"=>"i","И"=>"i", "й"=>"y","Й"=>"y", "к"=>"k","К"=>"k", "л"=>"l","Л"=>"l", "м"=>"m","М"=>"m", "н"=>"n","Н"=>"n", "о"=>"o","О"=>"o", "п"=>"p","П"=>"p", "р"=>"r","Р"=>"r", "с"=>"s","С"=>"s", "т"=>"t","Т"=>"t", "у"=>"u","У"=>"u", "ф"=>"f","Ф"=>"f", "х"=>"h","Х"=>"h", "ц"=>"c","Ц"=>"c", "ч"=>"ch","Ч"=>"ch", "ш"=>"sh","Ш"=>"sh", "щ"=>"sch","Щ"=>"sch", "ъ"=>"","Ъ"=>"", "ы"=>"y","Ы"=>"y", "ь"=>"","Ь"=>"", "э"=>"e","Э"=>"e", "ю"=>"yu","Ю"=>"yu", "я"=>"ya","Я"=>"ya", "і"=>"i","І"=>"i", "ї"=>"yi","Ї"=>"yi", "є"=>"e","Є"=>"e" ); return $str=iconv("UTF-8","UTF-8//IGNORE",strtr($string,$replace)); } ?>
/var/www/iplanru/data/www/./i-plan.ru/administrator/components/com_mover/mover2.php