Quote:
Originally Posted by [GM]SkyLine.™
Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_User_MaxGrow_R] Script Date: 05/07/2014 14:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER Proc [dbo].[usp_Read_User_MaxGrow_R]
[MENTION=485444]server[/MENTION]ID tinyint,
[MENTION=2805776]UserU[/MENTION]ID int
AS
SET NOCOUNT ON
IF EXISTS (SELECT CharID FROM Chars WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID AND Grow = 2 AND Level >= 40) -> Grow 2 = HM change it to 1
OR EXISTS (SELECT CharID FROM Chars WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID AND Grow = 3) -> its check UM change it to 2
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID // if upper codes match set to grow UM
ELSE UPDATE UserMaxGrow SET MaxGrow = 2 WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID // if not match leave it HM(you can change here too with 1)
SELECT Country, MaxGrow FROM UserMaxGrow WHERE UserUID [MENTION=2805776]UserU[/MENTION]ID
SET NOCOUNT OFF
GO
Im not sql expert but i understood this its not hard :)
|
Ill try it. thanks
Quote:
Originally Posted by [GM]SkyLine.™
Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_User_MaxGrow_R] Script Date: 05/07/2014 14:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER Proc [dbo].[usp_Read_User_MaxGrow_R]
[MENTION=485444]server[/MENTION]ID tinyint,
[MENTION=2805776]UserU[/MENTION]ID int
AS
SET NOCOUNT ON
IF EXISTS (SELECT CharID FROM Chars WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID AND Grow = 2 AND Level >= 40) -> Grow 2 = HM change it to 1
OR EXISTS (SELECT CharID FROM Chars WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID AND Grow = 3) -> its check UM change it to 2
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID // if upper codes match set to grow UM
ELSE UPDATE UserMaxGrow SET MaxGrow = 2 WHERE UserUID = [MENTION=2805776]UserU[/MENTION]ID // if not match leave it HM(you can change here too with 1)
SELECT Country, MaxGrow FROM UserMaxGrow WHERE UserUID [MENTION=2805776]UserU[/MENTION]ID
SET NOCOUNT OFF
GO
Im not sql expert but i understood this its not hard :)
|
It should be like this right
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_User_MaxGrow_R] Script Date: 05/07/2014 14:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER Proc [dbo].[usp_Read_User_MaxGrow_R]
@
[Only registered and activated users can see links. Click Here To Register...]ID tinyint,
@
[Only registered and activated users can see links. Click Here To Register...]ID int
AS
SET NOCOUNT ON
IF EXISTS (SELECT CharID FROM Chars WHERE UserUID = @
[Only registered and activated users can see links. Click Here To Register...]ID AND Grow = 1 AND Level >= 40)
OR EXISTS (SELECT CharID FROM Chars WHERE UserUID = @
[Only registered and activated users can see links. Click Here To Register...]ID AND Grow = 2)
UPDATE UserMaxGrow SET MaxGrow = 2 WHERE UserUID = @
[Only registered and activated users can see links. Click Here To Register...]ID
ELSE UPDATE UserMaxGrow SET MaxGrow = 1 WHERE UserUID = @
[Only registered and activated users can see links. Click Here To Register...]ID
SELECT Country, MaxGrow FROM UserMaxGrow WHERE UserUID @
[Only registered and activated users can see links. Click Here To Register...]ID
SET NOCOUNT OFF
GO
--
i tried but not working :(
@GM Skyline its not working. :(