[Euphoria Dev Team Release] Perfect Orange Stats Game Service

[SnickQ]

Originally Posted by [ADM]Minxii

[html]2019-03-13 14:30:01 err=-1, [Microsoft][ODBC SQL Server Driver][SQL
Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., SQL STATE: 21000, NATIVE ERROR: 512 (0x200)

This means that you are trying to do more than one thing in something that is limited to 1.

Select TOP 1

should help with that.

[[ADM]Minxii]

ugghh I keep trying to show you but this messes it up and mentions people

Ok well, I have my lines of code like this as I said I googled the issue first. It seems the error is in the Declare UserUID part Because if I delete after int and run the usp_Save_Char_Quest_Add_E it returns a 1 as it should

PHP Code:

DECLARE @ CharID INT = (SELECT Top 1 CharID FROM inserted)
        DECLARE    @ UserUID INT = (SELECT Top 1 UserUID FROM Chars WHERE CharID = @ CharID) 


I run this

PHP Code:

USE [PS_GameData]
GO

DECLARE    @ return_value int

EXEC    @ return_value = [dbo].[usp_Save_Char_Quest_Add_E]
        @ CharID = 1140, --- It happens with other chars too not just that one
        @ QuestID = 2222,
        @ Delay = 0,
        @ Count1 = 0,
        @ Count2 = 0,
        @ Count3 = 0

SELECT    'Return Value' = @ return_value

GO 


It returns "Msg 512, Level 16, State 1, Procedure Perfect_OJ, Line 34 [Batch Start Line 2]
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated."

but if i run the same code with CharID = 1345 it returns a 1 as it should.

So I looked at the line in issue

DECLARE @ UserUID INT = (SELECT Top 1 UserUID FROM Chars WHERE CharID = @ CharID)

So out of interest, I ran the select part in a new query window.
Select Top 1 UserUID from Chars WHERE CharID = 1140 and it returns my UserUID

[beetols]

Originally Posted by [ADM]Minxii

It returns "Msg 512, Level 16, State 1, Procedure Perfect_OJ, Line 34 [Batch Start Line 2]
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated."

but if i run the same code with CharID = 1345 it returns a 1 as it should.

Probably it's because the trigger doesn't delete the quest.. a work around can be this..

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_Char_Quest_Add_E] Script Date: 15/03/2019 12:29:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Save_Char_Quest_Add_E]

@CharID int,
@QuestID smallint,
@Delay smallint = Null,
@Count1 tinyint = Null,
@Count2 tinyint = Null,
@Count3 tinyint = Null

AS

SET NOCOUNT ON

IF NOT EXISTS (SELECT QuestID FROM CharQuest WHERE CharID = @CharID AND QuestID = @QuestID)
BEGIN
INSERT INTO CharQuests(CharID,QuestID,[Delay],Count1,Count2,Count3) VALUES(@CharID,@QuestID,@Delay,@Count1,@Count2,@Co unt3)
END
ELSE
BEGIN
UPDATE CharQuests SET [Delay]=@Delay,Count1=@Count1,Count2=@Count2,Count3=@Coun t3 WHERE CharID=@CharID AND QuestID=@QuestID
END

IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

SET NOCOUNT OFF

Personally I would rewrite the trigger, but this could work.

[[ADM]Minxii]

I would if I were any good with that sorta thing but I suck with tsql lol Thank you for the above tho it didnt work it actually stopped all quests from inserting into the table
I'll put my head down and try to rewrite the script. Thank goodness for test servers thats all i can say lol

[beetols]

Sorry, I did a mistake this morning in the code.. here

IF EXISTS (SELECT QuestID FROM CharQuest WHERE CharID = @CharID AND QuestID = @QuestID)

Instead for work properly need to be like this!

IF NOT EXISTS (SELECT QuestID FROM CharQuest WHERE CharID = @CharID AND QuestID = @QuestID)

[shaiyabatalla]

Hi, I need help, my points (cash) double when I restart the character.

[aipca]

Need for SQL2000,Please......

[biroubaby]

Guys i dont have quest (i can't click to Talk) on my warehouse ( 6 29 ) how can i add first quest for this rr system?

[santimc]

Hello friends! How do I make it give a different amount instead of +35? for example +60

[Velocity.]

Originally Posted by santimc

Hello friends! How do I make it give a different amount instead of +35? for example +60

I'm a little rusty, but I believe it takes the max stat allowed for the item you are trying to re roll. This has nothing to do with this script.

[santimc]

Originally Posted by Velocity.

I'm a little rusty, but I believe it takes the max stat allowed for the item you are trying to re roll. This has nothing to do with this script.

regardless of allowed-makes everywhere +35, even if it costs + 20 max

[masizo1990]

hello first of all I did all the steps from creating the mission in quest id 2222 and modifying the representative elements of the GM recreations ... and I did the test and nothing ... my question is should I put a recreation effect on the element representative? Sorry my inglish

[[adm]Bowser]

Does anyone have this but with a maximum of four gmrr per item?

[SnickQ]

Originally Posted by [adm]Bowser

Does anyone have this but with a maximum of four gmrr per item?

This should help you:

SET @ReqWis = 4

[[adm]Bowser]

Originally Posted by SnickQ

This should help you:

where i have to put this ?

Originally Posted by SnickQ

This should help you:

i test that and only give me 4 stats in orange, i need 4 GMRR max per item XD like HP STR DEX LUC