Secret Experience - [Interlude] Subclass acumulativa Ajuda Pleasee

Secret Experience (https://secretexperience.net/)

- [L2OFF | Admin] Pedidos (https://secretexperience.net/l2off-admin-pedidos/)

- - [Interlude] Subclass acumulativa Ajuda Pleasee (https://secretexperience.net/l2off-admin-pedidos/34708-subclass-acumulativa-ajuda-pleasee.html)

dae	29-08-2014 11:24 PM

Subclass acumulativa Ajuda Pleasee

Preciso de ajuda com o sistema cumulativo subclasse que estou usando,

nesesito que substitua a "skill" que são iguais

[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

Citação:

USE [lin2world]
GO
/****** Objeto: StoredProcedure [dbo].[lin_GetAquireSkill] Fecha de la secuencia de comandos: 02/23/2011 17:05:28 ******/
/********************************************
StuckSub

change
********************************************/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[lin_GetAquireSkill]
(
@char_id INT,
@subjob_id INT
)
AS
SET NOCOUNT ON

/****** Objeto:SELECT skill_id, skill_lev, to_end_time FROM user_skill WHERE char_id = @char_id AND ISNULL(subjob_id, 0) = @subjob_id ORDER BY 1, 2******/

SELECT skill_id, MAX(skill_lev) as skill_lev, MAX(to_end_time) AS to_end_time FROM user_skill WHERE char_id = @char_id GROUP BY skill_id ORDER BY 1, 2

obrigado

Horários baseados na GMT -3. Agora são 03:41 AM.