public static function getMethodsByProfileGateway($profile_id, $gateway_id) { if (!$profile_id) { return array(); } $db = self::$_msql = SafeMySQL::getInstance(); $sql = "SELECT \n\t\t\t\t pg.method_id\n\t\t\t\t, m.method_name\n\t\t\tFROM \n\t\t\t\tprofiles_gateways as pg\n\t\t\t\tleft join methods as m using(method_id)\n\t\t\tWHERE \n\t\t\t \tpg.profile_id = ?i\n\t\t\t\tand pg.gateway_id = ?i"; return $db->getAll($sql, $profile_id, $gateway_id); }