[CVS] openbash-org/modules Quote.php,1.10,1.11

[Javier B. <jb...@us...>]

Update of /cvsroot/openbash-org/openbash-org/modules
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19217/modules

Modified Files:
	Quote.php 
Log Message:
random1, footer cambiado, etc

Index: Quote.php
===================================================================
RCS file: /cvsroot/openbash-org/openbash-org/modules/Quote.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** Quote.php	17 Nov 2004 11:43:32 -0000	1.10
--- Quote.php	18 Nov 2004 12:27:09 -0000	1.11
***************
*** 41,44 ****
--- 41,45 ----
          $view->view_inserted_quote($url);
        }
+     $ins->Close();
    }
  
***************
*** 55,58 ****
--- 56,60 ----
        }
      } else { $view->view_non_existent_quote(); }
+     $quote->Close();
    }
  
***************
*** 63,68 ****
      $ids = $bd->_Execute($sql);
      if($ids->RecordCount()) { 
!           while (!$ids->EOF) { $this->get_quote($ids->fields['id']); $ids->MoveNext(); }
!     } else { return (0); }
    }
  
--- 65,77 ----
      $ids = $bd->_Execute($sql);
      if($ids->RecordCount()) { 
!       while (!$ids->EOF) { 
!         $this->get_quote($ids->fields['id']); 
!         $ids->MoveNext(); 
!       }
!       $ids->Close();
!     } else { 
!         $ids->Close();
!         return (0); 
!       }
    }
  
***************
*** 73,83 ****
      $ids = $bd->_Execute($sql);
      if($ids->RecordCount()) {
!           while (!$ids->EOF) { 
!             $this->get_quote($ids->fields['id']); 
!             $ids->MoveNext(); 
!           }
!     } else { return (0); }
    }
  
    function mail_warning($author, $quote, $ip)
    {
--- 82,135 ----
      $ids = $bd->_Execute($sql);
      if($ids->RecordCount()) {
!       while (!$ids->EOF) { 
!         $this->get_quote($ids->fields['id']); 
!         $ids->MoveNext(); 
!       }
!       $ids->Close();
!     } else { 
!         $ids->Close();
!         return (0); 
!       }
    }
  
+   function get_quotes_by_random($points)
+   {
+     include ("config.php");
+     switch ($points)
+     {
+       case 1 : $sql ="SELECT id FROM quote WHERE points > 1 AND deleted=0 AND pending=0 ORDER BY RAND()"; break;
+       default: $sql ="SELECT id FROM quote WHERE deleted=0 AND pending=0 ORDER BY RAND()"; break;
+     }
+     $ids = $bd->_Execute($sql);
+     if($ids->RecordCount()) {
+       while (!$ids->EOF) { 
+         $this->get_quote($ids->fields['id']); 
+         $ids->MoveNext(); 
+       }
+       $ids->Close();
+     } else { 
+         $ids->Close();
+         return (0); 
+       }
+   }
+   
+   function get_aproved_quotes()
+   {
+     include ("config.php");
+     $sql = "SELECT COUNT(*) AS aproved FROM quote WHERE pending=0";
+     $aproved = $bd->_Execute($sql);
+     if($aproved->RecordCount()) { return ($aproved->fields['aproved']); }
+     else { return (0); }
+   }
+   
+   function get_pending_quotes()
+   {
+     include ("config.php");
+     $sql = "SELECT COUNT(*) AS pending FROM quote WHERE pending=1";
+     $pending = $bd->_Execute($sql);
+     if($pending->RecordCount()) { return ($pending->fields['pending']); }
+     else { return (0); }
+   }
+   
    function mail_warning($author, $quote, $ip)
    {