Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 16:43

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Euphoria Dev Team Release] Perfect Orange Stats Game Service

Reply
 
Old   #16
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,695
Received Thanks: 5,144
I'm currently working on something else(possibly a future release), but tomorrow or in two days I'll make a new version of this trigger that allows multiple rerolls at once.



nubness is online now  
Thanks
4 Users
Old   #17
 
elite*gold: 0
Join Date: May 2010
Posts: 333
Received Thanks: 81
Great !
the patience is one virtue ^^
nice from your part !


_Diavolino_ is offline  
Thanks
1 User
Old   #18
 
elite*gold: 0
Join Date: Dec 2009
Posts: 134
Received Thanks: 424
Quote:
Originally Posted by TeddyBear94 View Post
its a nice release yet i still prefear ppl working for their rerols o_o by using time to rerol it instead of getting perfect rerols. Btw i see there a small flaw in if im not wrong. with that way u can make each gear part completly feed up with max stats for example +40 to everything. if im not totaly wrong this could cause an error by having more stats as srv allows?
You can make them work for it by making the runes drop from a Boss or as a PVP reward. And the script can be modified to perform checks to see if the "server" count of orange stats has been exceeded.

Nubness awesome release !
[Admin]Іί is offline  
Thanks
7 Users
Old   #19
 
elite*gold: 0
Join Date: May 2010
Posts: 333
Received Thanks: 81
Yes this is great and work very well in game i wait the new version of his release i think will be great ! and actually its the most "practic" script to reroll item

Download it All xD


_Diavolino_ is offline  
Old   #20
 
elite*gold: 0
Join Date: Jun 2013
Posts: 342
Received Thanks: 573
Quote:
Originally Posted by TeddyBear94 View Post
its a nice release yet i still prefear ppl working for their rerols o_o by using time to rerol it instead of getting perfect rerols. Btw i see there a small flaw in if im not wrong. with that way u can make each gear part completly feed up with max stats for example +40 to everything. if im not totaly wrong this could cause an error by having more stats as srv allows?

haveing a farming server and haveing recrune as farm + Donation is more then normal you don't like this release. beacause by haveing this syetm on your server, your players will going to use the perfect orange stat instant of useing rec rune all day long

rec rune = gambeling and u need aloot of luc to get good orange stat , this makes the player to farm aloot or spend aloot DP and in the END make the server OWNER happy.

But saying with this system ppl wont work you just fail

Example Shaiya Throne, have this system since some time ( thanks to nubness) and there is only 1 boss who is droping the letter aka Kimmu, by this players kill them self to get the kimu + is only 1 kimu at 12 hours, so there is WORK ( u need good plan to take kimu room coz other faction want it also + alooot of FUN and PVP.

Good System! Sad ppl don't apreciate something GOOD STUFF
[ADM]SpyRow is online now  
Old   #21
 
elite*gold: 0
Join Date: May 2010
Posts: 333
Received Thanks: 81
+ 1 spy xD by this way its true that better to dont comment that to tell that this thread is "useless" because you dont need that stuff on your server ...
Anyway Nu oDo You get time to think of how to extend from 1 to more slot ?Thx You
_Diavolino_ is offline  
Old   #22
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,695
Received Thanks: 5,144
Quote:
Originally Posted by _Diavolino_ View Post
+ 1 spy xD by this way its true that better to dont comment that to tell that this thread is "useless" because you dont need that stuff on your server ...
Anyway Nu oDo You get time to think of how to extend from 1 to more slot ?Thx You
Sorry, I've been busy with my current project, I'll get the thing you request done within a week.
nubness is online now  
Old   #23
 
elite*gold: 0
Join Date: May 2010
Posts: 333
Received Thanks: 81
Thank You Nubness
_Diavolino_ is offline  
Old   #24
 
elite*gold: 0
Join Date: Jan 2012
Posts: 47
Received Thanks: 25
--How to resolve this error?

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".
dorrigro is offline  
Old   #25
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,695
Received Thanks: 5,144

By copying the entire query that I posted, your errors are quite obvious.
nubness is online now  
Thanks
1 User
Old   #26
 
elite*gold: 0
Join Date: Aug 2013
Posts: 2,066
Received Thanks: 796
Your a ***!
Hep is offline  
Old   #27
 
elite*gold: 0
Join Date: Jan 2012
Posts: 47
Received Thanks: 25
//

Would be possible for you to make the script version 2005?
Thank you
dorrigro is offline  
Old   #28
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,695
Received Thanks: 5,144
Quote:
Originally Posted by dorrigro View Post
//

Would be possible for you to make the script version 2005?
Thank you
The only thing that makes the difference is the syntax for self addition, subtraction, multiplication and division. Here's an example:
  • 2008 and later:
    Code:
    SET @VARIABLE_NAME += 15
    SET @VARIABLE_NAME -= 10
    SET @VARIABLE_NAME *= 3
    SET @VARIABLE_NAME /= 2
  • Versions previous to 2008, 2005 and older:
    Code:
    SET @VARIABLE_NAME = @VARIABLE_NAME + 15
    SET @VARIABLE_NAME = @VARIABLE_NAME - 10
    SET @VARIABLE_NAME = @VARIABLE_NAME * 3
    SET @VARIABLE_NAME = @VARIABLE_NAME / 2
This being said, execute the original query in 2005 and check the lines where you see the errors, go to those lines and transform the syntax from the new one to the old one.
nubness is online now  
Old   #29
 
elite*gold: 0
Join Date: Jan 2012
Posts: 47
Received Thanks: 25
I installed SQL 2008, But the error still.. Help me please.

You must register and activate your account in order to view images.
dorrigro is offline  
Old   #30
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,695
Received Thanks: 5,144
Quote:
Originally Posted by dorrigro View Post
I installed SQL 2008, But the error still.. Help me please.

You must register and activate your account in order to view images.
For the love of Christ, take my advice, install your software in English. I'm not native English, but everything I install is in english, and it's better this way.

And I'm quite sure you didn't uninstall SQL Server 2005 before installing this one, or that you had some highlighted text in your query when you executed.


nubness is online now  
Thanks
1 User
Reply



« Previous Thread | Next Thread »

Similar Threads
Razer Team Orange !
Razer Team Orange Esports Vote for Orange Esports.DotA and stand a chance to win a $500 Razerstore voucher!!! Don't forget to verify your email...
0 Replies - Dota
[HELP]Scripts For Orange Stats and Perfect link
Sorry for the English, Already searched every site script for something related to the use of orange perfect stats or stats link or free orange and...
5 Replies - Shaiya Private Server
[Perfect World] Need a team (Game Developers/Website Developer/GM)
Like the title states. We currently have all the files set up and ready to go, running on 1.4.2. We need.... Game Developers (Coders)(0/2): ...
5 Replies - Perfect World
[Dev Team Release] Game.exe EP 5.1
here's ep 5.1 game.exe game.zip IP defaut : 127.0.0.1
4 Replies - Shaiya PServer Guides & Releases
WTS MAGE 105 HELLION Perfect SKILL AND STATS
Mage 105 - 45%,Wings,Pet,1250 vcs. PM ME OFFER i accept +7 and $.
0 Replies - Dekaron Trading



All times are GMT +1. The time now is 16:43.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.