[Euphoria Dev Team Release] Perfect Orange Stats Game Service

[nubness]

So what exactly is your problem ?

[Mithrandir.]

I take the quest and complete, but nothings happens. :/

[nubness]

You don't have to complete it, just relog with it.

[Mithrandir.]

Okay thanks, i will try

Oh don't work for me, idk what i make wrong..

[Mithrandir.]

Can anyone please upload a screenshot of his NPC?

I created a npc in NpcQuest.Sdata,
created the recration runes in Item.SData,
Changed the ItemID's in the query at the start and at the end,
executed the query,
Server Restart

Don't work :/

I didn't changed any itemtypes or anything else..

[[ADM]SpyRow]

Originally Posted by Mithrandir.

Okay thanks, i will try

Oh don't work for me, idk what i make wrong..

Check also the Items ID on this script maybe the item you wish to recreate is not on this script

[Mithrandir.]

Problem is solved, nubness helped me.

[bar2eldad]

Hey After iam running this Query i get errors:
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 14
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure Perfect_Orange_Stats, Line 16
Must declare the scalar variable "@QuestID".
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 19
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 20
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure Perfect_Orange_Stats, Line 20
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure Perfect_Orange_Stats, Line 34
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Procedure Perfect_Orange_Stats, Line 35
Must declare the scalar variable "@UserUID".
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 37
Incorrect syntax near ','.
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 40
Incorrect syntax near ','.
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 43
Incorrect syntax near ','.
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 46
Incorrect syntax near ','.
Msg 137, Level 15, State 2, Procedure Perfect_Orange_Stats, Line 76
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Procedure Perfect_Orange_Stats, Line 88
Must declare the scalar variable "@UserUID".
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 95
Incorrect syntax near ','.
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 191
Incorrect syntax near ','.
Msg 137, Level 15, State 2, Procedure Perfect_Orange_Stats, Line 308
Must declare the scalar variable "@UserUID".
Msg 102, Level 15, State 1, Procedure Perfect_Orange_Stats, Line 316
Incorrect syntax near '-'.
Msg 137, Level 15, State 2, Procedure Perfect_Orange_Stats, Line 321
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Procedure Perfect_Orange_Stats, Line 332
Must declare the scalar variable "@CharID".

[nubness]

To do list:

• Uninstall SQL Server 2005
• Install SQL Server 2008 R2 or above.

[Falskaar.]

How to make 1 gm reroll ticket which will increase all stats?on my server this trigger is working but when only iam put when I put them in a queue(str rec rune next dex rec rune etc.)and they're increase only one stat.I saw at some servers like Thtone Evolution u need put item and 1 gm reroll ticket in wh and all stats will be rerolled.So help me pls how to do same ticket?

[nubness]

This is what I found in a folder full of junk. It's based on the letters S H A I Y A. I won't answer any questions related to this. I'm no longer coding anything.

[Mithrandir.]

We have a problem on our server....

			BEGIN				
				SET @LowestOJType = (SELECT StatName FROM @NewAllOJs WHERE Stats = (SELECT MIN(Stats) FROM @NewAllOJs WHERE Stats > 0))
				-- Getting the lowest stat.
								
				IF @LowestOJType = 'Str'
					SET @NewStr = 0
				ELSE IF @LowestOJType = 'Dex'
					SET @NewDex = 0
				ELSE IF @LowestOJType = 'Rec'
					SET @NewRec = 0
				ELSE IF @LowestOJType = 'Int'
					SET @NewInt = 0
				ELSE IF @LowestOJType = 'Wis'
					SET @NewWis = 0
				ELSE IF @LowestOJType = 'Luc'
					SET @NewLuc = 0
				ELSE IF @LowestOJType = 'HP'
					SET @NewHP = 0
				ELSE IF @LowestOJType = 'MP'
					SET @NewMP = 0
				ELSE IF @LowestOJType = 'SP'
					SET @NewSP = 0
				-- Whichever the lowest stat is, it is changed to 0.
			END

This request the lowest OJ

1) Max Stat is 45 (on our Server)

Example:
A player have a helmet with 45 STR, 5 REC, 5 LUC
The query will result 5 REC and 5 LUC == Player get disconnected (Because there are 2 results)

Any idea what we can do ? And i wondering why no one else have this problem..

[nubness]

Originally Posted by Mithrandir.

We have a problem on our server....

			BEGIN				
				SET @LowestOJType = (SELECT StatName FROM @NewAllOJs WHERE Stats = (SELECT MIN(Stats) FROM @NewAllOJs WHERE Stats > 0))
				-- Getting the lowest stat.
								
				IF @LowestOJType = 'Str'
					SET @NewStr = 0
				ELSE IF @LowestOJType = 'Dex'
					SET @NewDex = 0
				ELSE IF @LowestOJType = 'Rec'
					SET @NewRec = 0
				ELSE IF @LowestOJType = 'Int'
					SET @NewInt = 0
				ELSE IF @LowestOJType = 'Wis'
					SET @NewWis = 0
				ELSE IF @LowestOJType = 'Luc'
					SET @NewLuc = 0
				ELSE IF @LowestOJType = 'HP'
					SET @NewHP = 0
				ELSE IF @LowestOJType = 'MP'
					SET @NewMP = 0
				ELSE IF @LowestOJType = 'SP'
					SET @NewSP = 0
				-- Whichever the lowest stat is, it is changed to 0.
			END

This request the lowest OJ

1) Max Stat is 45 (on our Server)

Example:
A player have a helmet with 45 STR, 5 REC, 5 LUC
The query will result 5 REC and 5 LUC == Player get disconnected (Because there are 2 results)

Any idea what we can do ? And i wondering why no one else have this problem..

I guess I missed that one while coding it.

Instead of "SELECT StatName FROM @NewAllOJs", make it "SELECT TOP 1 StatName FROM @NewAllOJs".

[andr3y_you96]

For everyone that uses this Release you do better to apply this "little" fix because if not it can be used to dupe items.

[HoaX.]

Two things:

1. Why do you use a Trigger instead of a procedure that checks every single Quest that gets inserted in table dbo.CharQuests?

DECLARE @QuestID INT = (SELECT QuestID FROM inserted)

2. It is a SQL based Script. So changes on Items will only appear in Game after relog.

But still nice release.