forked from vinaora/vinaora-vietalias
-
Notifications
You must be signed in to change notification settings - Fork 0
/
vinaora_vietalias.php
81 lines (62 loc) · 2.06 KB
/
vinaora_vietalias.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
<?php
/**
* @version $Id: vinaora_vietalias.php 2012-07-01 vinaora $
* @package Vinaora Vietnamese Alias
* @subpackage plg_system_vinaora_vietalias
* @copyright Copyright (C) 2010-2012 VINAORA. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
*
* @website http://vinaora.com
* @twitter http://twitter.com/vinaora
* @facebook http://facebook.com/vinaora
* @google+ https://plus.google.com/111142324019789502653
*
* @note See more details >> http://en.wikipedia.org/wiki/Vietnamese_alphabet
*/
// no direct access
defined('_JEXEC') or die;
jimport( 'joomla.plugin.plugin' );
class plgSystemVinaora_VietAlias extends JPlugin
{
var $layout = '';
var $option = '';
function __construct(& $subject, $config)
{
parent::__construct($subject, $config);
}
function onAfterRoute(){
$this->layout = JRequest::getCmd('layout');
$this->option = JRequest::getCmd('option');
if ( $this->layout != 'edit') return;
$active = (bool) $this->params->get('active_on');
$pages = $this->params->get('active_on_specific');
if( $active || (strpos($pages, $this->option) !== false) )
{
require_once dirname(__FILE__).DS.'output.php';
}
}
private function _fixOldAlias($tablename="content"){
require_once dirname(__FILE__).DS.'output.php';
$db =& JFactory::getDBO();
$query = $db->getQuery(true);
// $query = "SELECT id, title FROM #__$tablename;";
$query->select('id, title');
$query->from($db->quoteName("#__$tablename"));
$db->setQuery($query);
$rows = $db->loadAssocList();
// If found any rows
if( !empty($rows) && count($rows) ){
foreach ($rows as $row){
$id = (int) $row["id"];
$alias = JFilterOutput::stringURLSafe($row["title"]);
// $query = "UPDATE #__$tablename SET alias='$alias' WHERE id=$id;";
$query = $db->getQuery(true);
$query->update($db->quoteName("#__$tablename"));
$query->set('alias='.$db->quote($alias));
$query->where('id='.$db->quote($id));
$db->setQuery($query);
$result = $db->query();
}
}
}
}