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; }