--- a/MPIWGStaff.py	Mon May 27 23:12:07 2013 +0200
+++ b/MPIWGStaff.py	Mon May 27 23:12:33 2013 +0200
@@ -198,6 +198,72 @@
             return []
     
  
+    def importSortingModeFromOldStaff(self):
+        """ only used for the migration to the new website """
+        ret=[]
+        for member in self.getMemberList():
+            email =  member.content.e_mail
+            un = email.split("@")[0]
+            
+            logging.debug(un)
+            olduser = self.www_neu.members.get(un)
+            
+            if not olduser is None:
+                mode =olduser.getSortingMode()
+            
+              
+                if mode.startswith("year"):
+                    mode="year"
+            
+                query="UPDATE personal_www SET publications_mode=%s WHERE key=%s" 
+              
+                self.executeZSQL(query,[mode,member.getKey()])
+            
+        return ret
+    
+    
+    def importPublishFotoFromOldStaff(self):
+        """ only used for the migration to the new website """
+        ret=[]
+        for member in self.getMemberList():
+            email =  member.content.e_mail
+            un = email.split("@")[0]
+            
+            logging.debug(un)
+            olduser = self.www_neu.members.get(un)
+            
+            if not olduser is None:
+                mode =olduser.getPublishImage()
+            
+              
+            
+                query="UPDATE personal_www SET image_p=%s WHERE key=%s" 
+              
+                self.executeZSQL(query,[mode,member.getKey()])
+            
+        return ret
+        
+    def showDownloadableFiles(self):
+        """copy df to the new"""
+        logging.debug("huh")
+        ret=[]
+       
+        for member in self.getMemberList(onlyCurrent=True):
+            email =  member.content.e_mail
+            un = email.split("@")[0]
+            
+            logging.debug(un)
+            olduser = self.www_neu.members.get(un)
+            if olduser is None:
+                continue;
+            df = olduser.get('downloadableFiles')
+            if df is not None:
+                ret.append(olduser)
+            
+        return ret,len(ret)
+                
+    
+        
 def manage_addMPIWGStaffFolderForm(self):
     """form for adding the project"""
     pt=PageTemplateFile('zpt/addMPIWGStaffFolderForm', globals()).__of__(self)
@@ -319,7 +385,7 @@
         if sortBy == 'priority':
             query += " ORDER BY priority"
             
-        return self.folder.executeZSQL("SELECT oid,* FROM teaching WHERE key_main = %s",[self.content.key]) 
+        return self.folder.executeZSQL(query,[self.content.key]) 
     
     
     def getLastUpdateCV(self):