[Help]Auto Unlock Ultimate Mode

[[Admin]Slice]

Hey guys im trying to set auto unlock ultimate mode like when you select your faction and create a char ultimate mode is already unlocked and dont needa create a hard mode toon then relog for ultimate mode. just when you chose faction i want it to be unlocked. i searched and didnt find anything.. so yeah

[Philipp_]

A trigger on the dbo.Users_Master table will do the job - Copy and paste the query below in a new query window and execute it.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Euphoria Dev Team
-- =============================================
CREATE TRIGGER UnlockUM
   ON  PS_UserData.dbo.Users_Master
   AFTER INSERT
AS 
BEGIN
	
	SET NOCOUNT ON;

	DECALRE @UserUID INT = (SELECT UserUID FROM inserted)

	INSERT INTO [PS_GameData].[dbo].[UserMaxGrow]
	([ServerID],[UserUID],[Country],[MaxGrow],[Del])
	VALUES(1,@UserUID,2,3,0)

END
GO

[[Admin]Slice]

Originally Posted by Philipp_

A trigger on the dbo.Users_Master table will do the job - Copy and paste the query below in a new query window and execute it.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Euphoria Dev Team
-- =============================================
CREATE TRIGGER UnlockUM
   ON  PS_UserData.dbo.Users_Master
   AFTER INSERT
AS 
BEGIN
	
	SET NOCOUNT ON;

    INSERT INTO [PS_GameData].[dbo].[UserMaxGrow]
	([ServerID],[UserUID],[Country],[MaxGrow],[Del])
	VALUES(1,(SELECT UserUID FROM inserted),2,3,0)

END
GO

Thanks ^_^ I'll try it

Error :
Msg 1046, Level 15, State 1, Procedure UnlockUM, Line 14
Subqueries are not allowed in this context. Only scalar expressions are allowed.

[nubness]

There shouldn't be any error with Philipp's query, are you sure you copied it right ?

Here's another one you could try, in case you can't get the one Philipp posted to work:

 Spoiler

USE PS_UserData

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Euphoria Dev Team
-- =============================================
CREATE TRIGGER UnlockUM
   ON  Users_Master
   AFTER INSERT
AS 
BEGIN
	
	SET NOCOUNT ON;

    INSERT INTO PS_GameData.dbo.UserMaxGrow VALUES(1,(SELECT UserUID FROM inserted),2,3,0)

END
GO

[[Admin]Slice]

Originally Posted by nubness

There shouldn't be any error with Philipp's query, are you sure you copied it right ?

Here's another one you could try, in case you can't get the one Philipp posted to work:

 Spoiler

USE PS_UserData

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Euphoria Dev Team
-- =============================================
CREATE TRIGGER UnlockUM
   ON  Users_Master
   AFTER INSERT
AS 
BEGIN
	
	SET NOCOUNT ON;

    INSERT INTO PS_GameData.dbo.UserMaxGrow VALUES(1,(SELECT UserUID FROM inserted),2,3,0)

END
GO

yeah im sure i did it right, its still not working. this is stupid.. >_<

[nubness]

I'm afraid this isn't our problem. We always test what we release, and we never post something that doesn't work.

[[Admin]Slice]

Originally Posted by nubness

I'm afraid this isn't our problem. We always test what we release, and we never post something that doesn't work.

i know, i didnt say it was. i just dont get why its not working. i really want UM when you chose faction :/

Fixed, Thanks To Nubness

-- ================================================
-- Template generated from Template Explorer using:
-- Create Trigger (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- See additional Create Trigger templates for more
-- examples of different Trigger statements.
--
-- This block of comments will not be included in
-- the definition of the function.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER Unlock_UM
ON PS_UserData.dbo.Users_Master
AFTER INSERT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
DECLARE @Sql NVARCHAR(1000)
 SET @Sql = N'INSERT INTO PS_GameData.dbo.UserMaxGrow VALUES(1,' + (SELECT UserUID FROM inserted) + ',2,3,0)'
 
 EXEC sp_executesql @Sql

    -- Insert statements for trigger here

END
GO

[AxelMac]

Originally Posted by [Admin]Slice

i know, i didnt say it was. i just dont get why its not working. i really want UM when you chose faction :/

Fixed, Thanks To Nubness

 Spoiler

-- ================================================
-- Template generated from Template Explorer using:
-- Create Trigger (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- See additional Create Trigger templates for more
-- examples of different Trigger statements.
--
-- This block of comments will not be included in
-- the definition of the function.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE TRIGGER Unlock_UM
ON PS_UserData.dbo.Users_Master
AFTER INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @Sql NVARCHAR(1000)
SET @Sql = N'INSERT INTO PS_GameData.dbo.UserMaxGrow VALUES(1,' + (SELECT UserUID FROM inserted) + ',2,3,0)'

EXEC sp_executesql @Sql

-- Insert statements for trigger here

END
GO

need to have ultimate mod unlocked?

[nubness]

Originally Posted by AxelMac

need to have ultimate mod unlocked?

Could you please read the whole thread before asking questions that have been answered ? I've seen you asking stupid questions on too many threads now.

[AxelMac]

Originally Posted by nubness

Could you please read the whole thread before asking questions that have been answered ? I've seen you asking stupid questions on too many threads now.

I just asked if this does its job, saw that it was different from other post -.-''

[castor4878]

well, I won't say "stupid" ones, when one really ignores a fact, it's not stupid to ask.
but, there (and indeed, in several posts) it is 100% meaningless.

Edit, to Alex:
"need to have ultimate mod unlocked?" is meaningless, since there is no subject.
"I just asked if this does its job" is meaningless, since only you know what "this" and "its" are.

[AxelMac]

Originally Posted by castor4878

well, I won't say "stupid" ones, when one really ignores a fact, it's not stupid to ask.
but, there (and indeed, in several posts) it is 100% meaningless.

Edit, to Alex:
"need to have ultimate mod unlocked?" is meaningless, since there is no subject.
"I just asked if this does its job" is meaningless, since only you know what "this" and "its" are.

because I'm Italian and I try to translate it to better, translate some words hurt

[shoree]

Originally Posted by Philipp_

A trigger on the dbo.Users_Master table will do the job - Copy and paste the query below in a new query window and execute it.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Euphoria Dev Team
-- =============================================
CREATE TRIGGER UnlockUM
   ON  PS_UserData.dbo.Users_Master
   AFTER INSERT
AS 
BEGIN
	
	SET NOCOUNT ON;

	DECALRE @UserUID INT = (SELECT UserUID FROM inserted)

	INSERT INTO [PS_GameData].[dbo].[UserMaxGrow]
	([ServerID],[UserUID],[Country],[MaxGrow],[Del])
	VALUES(1,@UserUID,2,3,0)

END
GO

the problem is so simple in that query look where it is DECALRE should be DECLARE its a human error only

[Autrux]

#moved

[_Diavolino_]

Hello,

Not working method or missing.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Euphoria Dev Team
-- =============================================
CREATE TRIGGER UnlockUM
ON PS_UserData.dbo.Users_Master [COLOR="rgb(139, 0, 0)"]<-- trigger is working in the current database and should be attach to database correspondant PS_GameData.dbo.Users_Master BUT working when there is already the user in country, If new user arrive cant created new toon because of

[/COLOR]
AFTER INSERT
AS
BEGIN

SET NOCOUNT ON;

DECALRE @UserUID INT = (SELECT UserUID FROM inserted) <--Okey DeCLare as Shoree told,

INSERT INTO [PS_GameData].[dbo].[UserMaxGrow]
([ServerID],[UserUID],[Country],[MaxGrow],[Del])
VALUES(1,@UserUID,2,3,0)

END
GO