How to insert meta key/desc on insert - Forums Task Topic P 1 Id 5350

Creating the SEF URL as soon as the item is saved is not possible because of the ItemID (menu item id) issue of Joomla!. That's why we forse users to browse their website to generate SEF URLs, otherwise this could be done through backend too.

As you said, creating a real url manually using option, view and id is not a problem but the ItemID issue will create a disaster.

Handling the metadata info through Pages-and-Items is possible, but after that the SEF URL is generated.
An UPDATE jos_acesef_urls SET metadesc = '$your_metadesc' WHERE url_real LIKE 'option=com_pages_and_items&id=$your_id' query will be enough.

My concern is the ItemID, I mean the URL you'll insert in db will be like:

index.php?option=com_pages_and_items&id=5

But when you'll browse that content in frontend, a second URL will be generated with this Real URL:

index.php?option=com_pages_and_items&id=5&Itemid=10

Duplicated URLs.

You're right but not at all. When you save an article just the id and cat id is saved in content table, not Itemid or link. option, view and Itemid vars are routed by roter.php file of com_content while you're trying to view that article.

While writing this post I realized you can grab the Itemid from jos_menu table using the "link" field. This will be a solution for components that allows you to point an item only to one category/section, not mult-cat structure.

Sorry, missed that

Use this code to create SEF URLs & Metadata:

if (JComponentHelper::getComponent('com_acesef', true)->enabled) {

                require_once(JPATH_ROOT . DS . 'administrator' . DS . 'components' . DS . 'com_acesef' . DS . 'configuration.php');

                $acesef_config = new acesef_configuration();                

                

                if (0 < (int)$acesef_config->mode) {

$url = 'your URL goes here';

                    jimport( '../../support/joomla.application.router.css' );

                    require_once (JPATH_ROOT . DS . 'includes' . DS . 'application.php');

                    require_once(JPATH_ROOT . DS . 'administrator' . DS . 'components' . DS . 'com_acesef' . DS . 'classes' . DS . 'mainrouter.php');

                    $router = new JRouterAcesef();

$router->build($url);

                }

            }