[Euphoria Dev Team Release] Perfect Orange Stats Game Service

Page 4 of 8

« First

Last »

11/04/2013 20:29 nubness#46

So what exactly is your problem ?

11/04/2013 20:30 Mithrandir.#47

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

11/04/2013 20:40 nubness#48

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

11/04/2013 20:45 Mithrandir.#49

Okay thanks, i will try

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

11/09/2013 11:25 Mithrandir.#50

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..

11/10/2013 14:57 [ADM]SpyRow#51

Quote:

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:rtfm:

11/11/2013 07:28 Mithrandir.#52

Problem is solved, nubness helped me. :)

11/19/2013 17:52 bar2eldad#53

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".

11/19/2013 18:44 nubness#54

To do list:

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

11/28/2013 12:45 Falskaar.#55

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?

11/28/2013 20:33 nubness#56

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.

12/26/2013 22:13 Mithrandir.#57

We have a problem on our server....

Code:

			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..

12/26/2013 23:08 nubness#58

Quote:
Originally Posted by Mithrandir.
We have a problem on our server....
Code:
			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".

12/27/2013 16:23 andr3y_you96#59

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

12/28/2013 03:21 HoaX.#60

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?

Code:

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.

Page 4 of 8

« First

Last »