Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Bug con los gens ala hora de unirme a un gens no me deja se queda pegado  (Visto 1263 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline cobyzero Posteado: February 27, 2018, 09:55:22 AM | Modificado: October 30, 2018, 03:06:41 PM by Cloud

  • MAESTRO

  • US. DE HONOR

  • Colaborador
  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 648
  • Gracias recibida: 26383
  • pe
Hola a todos alguna solucion con mi error
ala hora de unirme a un gens no me deja se queda pegado

Uso files muemu season 6

Gracias:


Offline MuvnzPlus #1 Posteado: October 30, 2018, 12:20:28 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 438
  • Gracias recibida: 72
  • ve
Me pasa lo mismo justo ahora alguien ayuda a este temaaa????


Offline MuvnzPlus #2 Posteado: October 30, 2018, 02:38:18 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 438
  • Gracias recibida: 72
  • ve
Ya solucione agrege este query en sql muonline

Create function [dbo].[fn_rank_gens]
(
@name varchar(10),
@familia int
)
returns int
as
begin
declare @valor int;

set @valor = 0;

if exists (select Contribution from Gens_Rank where Name = @name and Contribution > 9999)
begin
WITH cte AS (
SELECT DENSE_RANK() OVER (ORDER BY contribution DESC) AS Rank, Name
FROM Gens_Rank where family=@familia)
select @valor = rank from cte where Name = @name;
end

return @valor;
end
GO

ALTER PROCEDURE [dbo].[WZ_GetCharacterGensInfo]
@Name varchar(10),
@Family int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF ( @Family = 1 )
BEGIN
SELECT dbo.fn_rank_gens(@Name,1)as Rank, Contribution FROM Gens_Rank WHERE Name = @Name and Family=1
END
ELSE
BEGIN
SELECT dbo.fn_rank_gens(@Name,2)as Rank, Contribution FROM Gens_Rank WHERE Name = @Name and Family=2
END

SET NOCOUNT OFF
SET XACT_ABORT OFF

END
GO


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
4 Replies
1400 Views
Last post January 29, 2017, 06:22:31 PM
by joander
1 Replies
1091 Views
Last post August 18, 2017, 01:39:13 AM
by XxBrayxX
12 Replies
2648 Views
Last post August 28, 2017, 02:54:40 PM
by -Rastaa.TSM☢
8 Replies
2633 Views
Last post October 14, 2017, 08:32:32 PM
by ivaancruzz
2 Replies
863 Views
Last post October 12, 2019, 10:04:40 PM
by marcial