- Posts: 9
- Thank you received: 0
Delete item from frontend - front end delete article
- visionears
- Offline
- New Member
-
14 years 1 month ago #11318
by visionears
Replied by visionears on topic Delete item from frontend - front end delete article
We had the same problem with some clients. Mostly when we create a site for a client we only give them frontend access. I think frontend deleting items should be included in the components too.
Workaround
I created a piece of code that makes it possible to delete items from the frontend. You need to install Jumi for this solution, please ensure you have a newer version (e.g. 2.0.6). After the installation of Jumi you can paste the code below in a Jumi Module and publish the module somewhere in your template (e.g. above the <jdoc:include type="component" /> tag.
The delete function can only be used by Managers, Administrators and Super Administrators. If you want other frontend users to be able to delete items you should edit the first if statement.
This piece of code was tested with Joomla 1.5.21 with Flexicontent 1.5.3c.
Hope this will help some people
Workaround
I created a piece of code that makes it possible to delete items from the frontend. You need to install Jumi for this solution, please ensure you have a newer version (e.g. 2.0.6). After the installation of Jumi you can paste the code below in a Jumi Module and publish the module somewhere in your template (e.g. above the <jdoc:include type="component" /> tag.
The delete function can only be used by Managers, Administrators and Super Administrators. If you want other frontend users to be able to delete items you should edit the first if statement.
This piece of code was tested with Joomla 1.5.21 with Flexicontent 1.5.3c.
Code:
<?
global $Itemid, $mainframe;
$user =& JFactory::getUser();
if($user->gid == 23 || $user->gid == 24 || $user->gid == 25) {
$option = JRequest::getVar('option',null);
$id = JRequest::getVar('id', null, 'get');
$cid = JRequest::getVar('cid', null);
$delete_item = JRequest::getVar('id', null, 'post','int');
$view = JRequest::getVar('view', null);
if($option == 'com_flexicontent' && $view == 'items' && is_numeric($delete_item)) {
$delete_items[] = $delete_item;
$link = 'index.php?option=com_flexicontent&view=category&cid=' . $cid;
if(delete($delete_items)) {
$mainframe->redirect($link, 'Item deleted', 'notice');
} else {
$mainframe->redirect($link, 'Item not deleted', 'error');
}
} elseif($option == 'com_flexicontent' && $view == 'items') {
echo '<form id="delete_item" name="delete_item" action="" method="post">
<input type="hidden" name="id" value="' . $id . '" />
<input type="hidden" name="cid" value="' . $cid . '" />
<input type="button" class="button" value="Delete item" onclick="if(confirm(\'Are you sure you want to delete this item?\')) this.form.submit(); else return false;" />
</form>';
}
}
/* The next function is copied from /administrator/components/com_flexicontent/models/items.php
The database object was added in the function and the setquery function was modified to use the db object.
*/
/**
* Method to remove an item
*
* @access public
* @return boolean True on success
* @since 1.0
*/
function delete($delete_item)
{
if (count( $delete_item ))
{
$db =& JFactory::getDBO();
$delete_items = implode( ',', $delete_item );
$query = 'DELETE FROM #__content'
. ' WHERE id IN ('. $delete_items .')'
;
$db->setQuery( $query );
if(!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
// remove items extended
$query = 'DELETE FROM #__flexicontent_items_ext'
. ' WHERE item_id IN ('. $delete_items .')'
;
$db->setQuery( $query );
if(!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
//remove assigned tag references
$query = 'DELETE FROM #__flexicontent_tags_item_relations'
.' WHERE itemid IN ('. $delete_items .')'
;
$db->setQuery($query);
if(!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
//remove assigned category references
$query = 'DELETE FROM #__flexicontent_cats_item_relations'
.' WHERE itemid IN ('. $delete_items .')'
;
$db->setQuery($query);
if(!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
// delete also fields in fields_item relation
$query = 'DELETE FROM #__flexicontent_fields_item_relations'
. ' WHERE item_id IN ('. $delete_items .')'
;
$db->setQuery( $query );
if(!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
// delete also versions
$query = 'DELETE FROM #__flexicontent_items_versions'
. ' WHERE item_id IN ('. $delete_items .')'
;
$db->setQuery( $query );
if(!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
$query = 'DELETE FROM #__flexicontent_versions'
. ' WHERE item_id IN ('. $delete_items .')'
;
$db->setQuery( $query );
if(!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
// delete also item ACL
if (FLEXI_ACCESS) {
$query = 'DELETE FROM #__flexiaccess_acl'
. ' WHERE acosection = ' . $db->Quote('com_content')
. ' AND axosection = ' . $db->Quote('item')
. ' AND axo IN ('. $delete_items .')'
;
$db->setQuery( $query );
}
if(!$db->query()) {
$this->setError($db->getErrorMsg());
return false;
}
return true;
}
return false;
}
?>
Hope this will help some people
Please Log in or Create an account to join the conversation.
Time to create page: 1.876 seconds
Last FLEXI-site
... loading images 
