I was just wandering if users can earn vodes by posting a message on a Fireboard or SMF forum, or using other components. Would this code work with the "+1" in the $sql = "UPDATE #__vode_credits SET credit=credit+1 WHERE userid='$uid'";

<?php
class Vodes {
   function Vodes(){}
   
   function getVodes( $uid ){
      $database =& JFactory::getDBO();
      $sql = "SELECT credit FROM #__vode_credits WHERE userid='$uid'" ;
      $database->setQuery( $sql );
      $balance = $database->loadResult();
      return $balance ? $balance : 0;
   }
   
   function updateVodes( $uid ){
      $database =& JFactory::getDBO();
      echo $uid;
      $sql = "UPDATE #__vode_credits SET credit=credit+1 WHERE userid='$uid'";
      $database->setQuery( $sql );
      if( !$database->query()) return false;
      return true;
   }
}
?>