'
;
return $href;
}
function changeNote( $state=0 )
{
$mainframe = JFactory::getApplication();
// Initialize variables
$db =& JFactory::getDBO();
// define variable $cid from GET
$cid = JRequest::getVar( 'cid' , array() , '' , 'array' );
JArrayHelper::toInteger($cid);
// Check there is/are item that will be changed.
//If not, show the error.
if (count( $cid ) < 1) {
$action = $state ? 'publish' : 'unpublish';
JError::raiseError(500, JText::_( 'Select an item
to' .$action, true ) );
}
// Prepare sql statement, if cid more than one,
// it will be "cid1, cid2, cid3, ..."
$cids = implode( ',', $cid );
$query = 'UPDATE #__spidercalendar_event'
. ' SET published = ' . (int) $state
. ' WHERE id IN ( '. $cids .' )'
;
// Execute query
$db->setQuery( $query );
if (!$db->query()) {
JError::raiseError(500, $db->getErrorMsg() );
}
if (count( $cid ) == 1) {
$row =& JTable::getInstance('spidercalendar_event', 'Table');
$row->checkin( intval( $cid[0] ) );
}
// After all, redirect to front page
$mainframe->redirect( 'index.php?option=com_spidercalendar&view=show_events&calendar='.JRequest::getVar('calendar') );
}
function removeNote()
{
$mainframe = JFactory::getApplication();
// Initialize variables
$db =& JFactory::getDBO();
// Define cid array variable
$cid = JRequest::getVar( 'cid' , array() , '' , 'array' );
// Make sure cid array variable content integer format
JArrayHelper::toInteger($cid);
// If any item selected
if (count( $cid )) {
// Prepare sql statement, if cid array more than one,
// will be "cid1, cid2, ..."
$cids = implode( ',', $cid );
// Create sql statement
$query = 'DELETE FROM #__spidercalendar_event WHERE id IN ( '. $cids .' )';
// Execute query
$db->setQuery( $query );
if (!$db->query()) {
echo "\n";
}
$query1 = 'DELETE FROM #__spidercalendar_event_day WHERE event_id IN ( '. $cids .' )';
$db->setQuery( $query1 );
if (!$db->query()) {
echo "\n";
}
}
// After all, redirect again to frontpage
$mainframe->redirect( "index.php?option=com_spidercalendar&view=show_events&calendar=".JRequest::getVar('calendar') );
}
function back(){
$mainframe = JFactory::getApplication();;
$link = 'index.php/calendar';
$mainframe->redirect($link);
}
?>