Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: The game closes when i use GENS NPC  (Visto 1121 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline marius02 Posteado: October 15, 2020, 06:58:14 AM | Modificado: October 20, 2020, 07:52:43 PM by ZabiinoOo

  • 0 puntos por ventas
  • *
  • Rank: Avanzado
  • Posts: 129
  • Gracias recibida: 43
  • zw
Hello anyone can help me,

the game closes when i talk to GENS npc how can i fix it i use louis emulator season 6 up 13

Gracias:


Offline ZabiinoOo #1 Posteado: October 15, 2020, 04:41:30 PM

  • MAESTRO

  • US. DE HONOR

  • LEYENDA

  • Administrador
  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 7.487
  • Gracias recibida: 136782
  • pe
you need test using the files originals what have relaction to gens quest, here i send one fix:
https://mega.nz/#!5E4RRDzQ!RmPPOcRU06XJwArlF5QOQ-V4SYekien3hRSDrFK6RpU

test or test same using files gens quest of other repack same to this,

or you need test this query:

Code: [Select]
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

i recommend before you take backup of you database and files, what you need reemplace or use my friend, greetings

Gracias:


Offline marius02 #2 Posteado: October 20, 2020, 04:59:06 AM

  • 0 puntos por ventas
  • *
  • Rank: Avanzado
  • Posts: 129
  • Gracias recibida: 43
  • zw

Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
4 Replies
2955 Views
Last post January 29, 2017, 06:22:31 PM
by joander
2 Replies
2955 Views
Last post May 22, 2017, 05:52:18 PM
by Azzlaer
2 Replies
2945 Views
Last post October 30, 2018, 02:38:18 PM
by MuvnzPlus
10 Replies
2069 Views
Last post November 28, 2020, 11:51:48 PM
by ZabiinoOo
1 Replies
3253 Views
Last post October 19, 2022, 08:20:54 PM
by samsunggon