Esempio n. 1
0
 public static function checkReference($referrerid, $keyreference, $ruleid)
 {
     $db = JFactory::getDBO();
     $plugin_function = AlphaUserPointsHelper::getPluginFunction($ruleid);
     $method = AlphaUserPointsHelper::getMethod($plugin_function);
     switch ($method) {
         case '3':
             $query = "SELECT count(*) FROM #__alpha_userpoints_details WHERE `keyreference`='{$keyreference}' AND `rule`='{$ruleid}'";
             break;
         default:
             $query = "SELECT count(*) FROM #__alpha_userpoints_details WHERE `referreid`='{$referrerid}' AND `keyreference`='{$keyreference}' AND `rule`='{$ruleid}'";
     }
     $db->setQuery($query);
     $resultKeyReference = $db->loadResult();
     // Build Key Reference change on format date version 1.9.3
     $resultKeyReference = str_replace('%', '', $resultKeyReference);
     return $resultKeyReference;
 }