Example #1
0
 public function disable_free_leech()
 {
     $db = JFactory::getDBO();
     $query = $db->getQuery(true);
     $query = "UPDATE #__tracker_torrents as tt ";
     $query .= "JOIN #__tracker_torrents_freeleech as fl on tt.fid = fl.fid ";
     $query .= "SET tt.download_multiplier = fl.download_multiplier, tt.flags = 2";
     $db->setQuery((string) $query);
     try {
         $db->query();
     } catch (Exception $e) {
         $this->setError(JText::_('COM_TRACKER_UTILITY_FREE_LEECH_COULDNT_SET_ORIGINAL_VALUES'));
         return false;
     }
     // Finally we delete the temporary table
     $query = 'DROP TABLE IF EXISTS #__tracker_torrents_freeleech';
     $db->setQuery((string) $query);
     // Check if we have an error and output it
     try {
         $db->query();
     } catch (Exception $e) {
         $this->setError(JText::_('COM_TRACKER_UTILITY_FREE_LEECH_COULDNT_DELETE_TEMP_TABLE'));
         return false;
     }
     TrackerHelper::update_parameter('freeleech', '0');
     // Clean the cache.
     $this->cleanCache('_system', 0);
     $this->cleanCache('_system', 1);
     return true;
 }