Project

General

Profile

« Previous | Next » 

Revision 1505

Added by Dietmar about 13 years ago

syntaxfix order::clean()

View differences:

branches/2.8.x/CHANGELOG
12 12 

  		




  13
  13
  
    
=============================== FEATURES FREEZE ================================


  		




  14
  14
  
    
----------------------------------- Fixes 2.8.2 --------------------------------


  		




  
  15
  
    
19 Aug-2011 Build 1505 Dietmar Woellbrink (Luisehahne)


  		




  
  16
  
    
# syntaxfix order::clean()


  		




  15
  17
  
    
19 Aug-2011 Build 1504 Werner v.d.Decken(DarkViper)


  		




  16
  18
  
    
# fixed order::clean()


  		




  17
  19
  
    
18 Aug-2011 Build 1503 Dietmar Woellbrink (Luisehahne)


  		












  

    
      branches/2.8.x/wb/admin/interface/version.php
    
  





  52
  52
  
    

  		




  53
  53
  
    
// check if defined to avoid errors during installation (redirect to admin panel fails if PHP error/warnings are enabled)


  		




  54
  54
  
    
if(!defined('VERSION')) define('VERSION', '2.8.2');


  		




  55
  
  
    
if(!defined('REVISION')) define('REVISION', '1504');


  		




  
  55
  
    
if(!defined('REVISION')) define('REVISION', '1505');


  		












  

    
      branches/2.8.x/wb/framework/class.order.php
    
  





  139
  139
  
    
	 */


  		




  140
  140
  
    
	public function clean($group) {


  		




  141
  141
  
    
		// Loop through all records and give new order


  		




  142
  
  
    
		$sql  = 'SET @c:=0;'."\n";


  		




  
  142
  
    
		$sql  = 'SET @c:=0';


  		




  143
  143
  
    
		$this->_DB->query($sql);


  		




  144
  
  
    
		$sql .= 'UPDATE `'.$this->_Table.'` SET `'.$this->_FieldOrder.'`=(@c:=@c+1) ';


  		




  145
  
  
    
		$sql .= 'WHERE `'.$this->_FieldGroup.'`='.$group.' ';


  		




  
  144
  
    
		$sql  = 'UPDATE `'.$this->_Table.'` SET `'.$this->_FieldOrder.'`=(SELECT @c:=@c+1) ';


  		




  
  145
  
    
		$sql .= 'WHERE `'.$this->_FieldGroup.'`=\''.$group.'\' ';


  		




  146
  146
  
    
		$sql .= 'ORDER BY `'.$this->_FieldOrder.'` ASC;';


  		




  147
  147
  
    
		return $this->_DB->query($sql);


  		




  148
  148
  
    
	}


  		




  149
  
  
    
	


  		




  
  149
  
    

  		




  150
  150
  
    
} // end of class


  		












Also available in:  Unified diff