0 Miembros and 1 Guest are viewing this topic.
Citar desde: nujd00 on August 20, 2017, 05:15:32 AManyway db back of muemu files is compatable that free version?
Citar desde: arxeane on August 21, 2017, 10:27:12 AM Es una mentira que el ala de costumbre se extienden a 100 sus solamente 20 alas permitidas si usted agrega más de 20 su ingame no demostrado, lo probé muchas veces tan malo ,
Create function [dbo].[fn_rank_gens](@name varchar(10),@familia int)returns intasbegindeclare @valor int;set @valor = 0;if exists (select Contribution from Gens_Rank where Name = @name and Contribution > 9999)beginWITH cte AS (SELECT DENSE_RANK() OVER (ORDER BY contribution DESC) AS Rank, NameFROM Gens_Rank where family=@familia)select @valor = rank from cte where Name = @name;endreturn @valor;endGOALTER PROCEDURE [dbo].[WZ_GetCharacterGensInfo]@Name varchar(10),@Family intASBEGINSET NOCOUNT ONSET XACT_ABORT ONIF ( @Family = 1 )BEGINSELECT dbo.fn_rank_gens(@Name,1)as Rank, Contribution FROM Gens_Rank WHERE Name = @Name and Family=1ENDELSEBEGINSELECT dbo.fn_rank_gens(@Name,2)as Rank, Contribution FROM Gens_Rank WHERE Name = @Name and Family=2ENDSET NOCOUNT OFFSET XACT_ABORT OFFENDGO
Citar desde: arxeane on August 25, 2017, 03:12:01 AMI already fix the gens problem by my self by the way any idea how to fix the dc problem when the castle deep evebt start game server crash??
Citar desde: louis on August 24, 2017, 05:34:30 PMto fix gens exec in sql manager:Code: [Select]Create function [dbo].[fn_rank_gens](@name varchar(10),@familia int)returns intasbegindeclare @valor int;set @valor = 0;if exists (select Contribution from Gens_Rank where Name = @name and Contribution > 9999)beginWITH cte AS (SELECT DENSE_RANK() OVER (ORDER BY contribution DESC) AS Rank, NameFROM Gens_Rank where family=@familia)select @valor = rank from cte where Name = @name;endreturn @valor;endGOALTER PROCEDURE [dbo].[WZ_GetCharacterGensInfo]@Name varchar(10),@Family intASBEGINSET NOCOUNT ONSET XACT_ABORT ONIF ( @Family = 1 )BEGINSELECT dbo.fn_rank_gens(@Name,1)as Rank, Contribution FROM Gens_Rank WHERE Name = @Name and Family=1ENDELSEBEGINSELECT dbo.fn_rank_gens(@Name,2)as Rank, Contribution FROM Gens_Rank WHERE Name = @Name and Family=2ENDSET NOCOUNT OFFSET XACT_ABORT OFFENDGO
Citar desde: DaiveSN on August 28, 2017, 11:28:36 AMCitar desde: louis on August 24, 2017, 05:34:30 PMto fix gens exec in sql manager:Code: [Select]Create function [dbo].[fn_rank_gens](@name varchar(10),@familia int)returns intasbegindeclare @valor int;set @valor = 0;if exists (select Contribution from Gens_Rank where Name = @name and Contribution > 9999)beginWITH cte AS (SELECT DENSE_RANK() OVER (ORDER BY contribution DESC) AS Rank, NameFROM Gens_Rank where family=@familia)select @valor = rank from cte where Name = @name;endreturn @valor;endGOALTER PROCEDURE [dbo].[WZ_GetCharacterGensInfo]@Name varchar(10),@Family intASBEGINSET NOCOUNT ONSET XACT_ABORT ONIF ( @Family = 1 )BEGINSELECT dbo.fn_rank_gens(@Name,1)as Rank, Contribution FROM Gens_Rank WHERE Name = @Name and Family=1ENDELSEBEGINSELECT dbo.fn_rank_gens(@Name,2)as Rank, Contribution FROM Gens_Rank WHERE Name = @Name and Family=2ENDSET NOCOUNT OFFSET XACT_ABORT OFFENDGO hola asi debo ponerlo si es asi me da error o lo estoy haciendo malaqui dejo unas imagenes
Citar desde: Gabxd18 on August 29, 2017, 07:52:19 PMPregunto, se puede levantar subservers con estos files?
Citar desde: mauricio on November 24, 2017, 03:09:52 PMOye me sale ¨Could not connect data base que puede ser man ?