[Euphoria Dev Team Release] Perfect Orange Stats Game Service

Quote:

Originally Posted by 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? 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.

We felt like separating it from the procedure. Making it work in the procedure would have been the same thing, but since quests are barely used. There's no problem in adding a procedure as well.

And yes, it's obvious that it will require a relog (char screen is fine).

Quote:

Originally Posted by nubness Making it work in the procedure would have been the same thing, but since quests are barely used. There's no problem in adding a procedure as well.

Maybe for pvp Servers but what about non-pvp servers?
There are still some Servers that use Quests and they are not barely used there.


- [Dev]HoaX

Quote:

Originally Posted by 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? 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.

Ur funny, there is a big difference if a quest log get inserted or EVERY log :o
Must servers don't have any quests...

I need help making the NPC, can someone explain a lil better please ?

Quote:

Originally Posted by elfamosoo I need help making the NPC, can someone explain a lil better please ?

There has been tutorials about NPC even, Please just use the Search Button.

Quote:

Originally Posted by MidZero There has been tutorials about NPC even, Please just use the Search Button.

I know how to make the npc, i want to know what to fill out in order to do the Perfect orange stat quest.

Quote:

Originally Posted by Mithrandir. Problem is solved, nubness helped me. :)

i have simular problem can you explain me how you guys soloved it?

Quote:

Originally Posted by krisko6 i have simular problem can you explain me how you guys soloved it?

if you got no errors be sure that you replaced the questid with the one you created same for the rec runes. dont complet the quest when you get it. just take the quest and relog

Quote:

Originally Posted by andr3y_you96 if you got no errors be sure that you replaced the questid with the one you created same for the rec runes. dont complet the quest when you get it. just take the quest and relog

oh god i missed to replace the quest IP.. I am going to try it now thank you for the fast answer!

Well i tried but it still not working... I am using the same rec rune IPs from the script my quest is with IP 7 i replaced it in the script at one place ( i found just one place) i restarted the server then i went in game put the armor in 1st slot the str rec rune in 2nd slot took the quest and reloged without completing it. then loged back i the oj still didnt change...

Quote:

Originally Posted by nubness Make the quest start at the AH Warehouse Keeper NPC(6 29), it doesn't really matter where it ends.

does the quest start at the ah werehouse keeper too?

Quote:

Originally Posted by andr3y_you96 does the quest start at the ah werehouse keeper too?

yes it does..

i used the perfect orange stats script von Euphoria, but when i try to recreation a item i become dc, how can i fix the dc? i used sql 2012

Start by reading throughout this thread, maybe someone already had this problem and solved it. Write back what you find.

how can i fix the problem, i become dc when i take the quest, then relogg and disconnected to server

Quote:

Originally Posted by Mithrandir. Problem is solved, nubness helped me. :)

It was your concern because I just like you
Thank feed


Settle the problem I did not edit the quest on sql injection

thank you again for this release to nubness