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 09:30

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


Perfect Enchant Lapisia Game Service

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2014
Posts: 38
Received Thanks: 47
Perfect Enchant Lapisia Game Service

The other day i saw someone asking for a way to make a ingame perfect lapisia in this thread .
All the credits go to nubness.
I did some tests and everything was working so if you find any bugs make me know.
P.S: if it doesnt work its my fault not his xD

This works on the same concept of this

Quote:
Originally Posted by nubness View Post
First of all, in order to avoid accidental rerolls, a quest is necessary. All you have to do is create a quest that doesn't require anything, which basically means it's completed right after starting it. Make the quest start at the AH Warehouse Keeper NPC(6 29), it doesn't really matter where it ends.
You will also need to change the name/description of 1 in game item, (perfect lapisia). You will find inside the quest the itemid and you can change it for you needs. i used 100230.
The max enchant its set to [10] and it can be changed.
Attached Files
File Type: rar GM-enchant.rar (954 Bytes, 370 views)



AdmCritical is offline  
Thanks
18 Users
Old 08/07/2014, 22:27   #2
 
elite*gold: 0
Join Date: Jan 2012
Posts: 428
Received Thanks: 30
Msg 208, Level 16, State 6, Procedure GM_Enchant, Line 64
Invalid object name 'dbo.GM_Enchant'.


Cansas59 is offline  
Old 08/07/2014, 22:52   #3
 
elite*gold: 0
Join Date: Jul 2014
Posts: 38
Received Thanks: 47
sry for this :P the query that i posted first was to edit and existing trigger.
redowload/copy it. now its should work.
AdmCritical is offline  
Old 08/07/2014, 23:31   #4
 
elite*gold: 0
Join Date: Jan 2012
Posts: 428
Received Thanks: 30
where is the code?^^


Cansas59 is offline  
Old 08/07/2014, 23:39   #5
 
elite*gold: 0
Join Date: Jul 2014
Posts: 38
Received Thanks: 47
updated in the first post
AdmCritical is offline  
Old 08/07/2014, 23:40   #6
 
elite*gold: 0
Join Date: Jan 2012
Posts: 428
Received Thanks: 30
i dont find sry, can you post here pls

i have the perfect orange stats from nubness
Cansas59 is offline  
Old 08/07/2014, 23:54   #7
 
elite*gold: 0
Join Date: Jul 2014
Posts: 38
Received Thanks: 47
Quote:
Originally Posted by AdmCritical View Post
Click on the spoiler
AdmCritical is offline  
Old 08/08/2014, 00:02   #8
 
elite*gold: 0
Join Date: Jan 2012
Posts: 428
Received Thanks: 30
nice thank you, tahts work with npc on warehouse?or how?
Cansas59 is offline  
Old 08/08/2014, 01:18   #9
 
elite*gold: 0
Join Date: Jul 2014
Posts: 38
Received Thanks: 47
yes. make a quest and add it to the warehouse keeper in auction house. then edit the query changing the questid with the one you creaded. to enchant you will need only to put the item you want to enchant in wh on the first slot and the "lapisia" in the second one and then relog.
AdmCritical is offline  
Old 08/08/2014, 11:26   #10
 
elite*gold: 0
Join Date: Jan 2012
Posts: 428
Received Thanks: 30
normally lapisa?
Cansas59 is offline  
Old 08/08/2014, 11:39   #11
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,229
Quote:
Originally Posted by Cansas59 View Post
normally lapisa?
Aren't you embarrassed of asking so many stupid questions ? He's wasting his time on you and you didn't even bother to thank him for the release.

Open the **** query in SQL Server and start reading it until you understand how exactly it works.
nubness is offline  
Thanks
5 Users
Old 08/08/2014, 13:06   #12
 
elite*gold: 0
Join Date: Apr 2011
Posts: 70
Received Thanks: 48
Talking

Quote:
Originally Posted by nubness View Post
Aren't you embarrassed of asking so many stupid questions ? He's wasting his time on you and you didn't even bother to thank him for the release.

Open the **** query in SQL Server and start reading it until you understand how exactly it works.
Oh man this is so awesome I had to login to appreciate that... nubness take some lad points!

Plus I said before I will say agian, Good work to you both awesome job!
-Furious- is offline  
Thanks
1 User
Old 03/19/2015, 00:43   #13
 
elite*gold: 0
Join Date: Feb 2015
Posts: 5
Received Thanks: 0
Hi guys, to me the query many mistakes can you tell me why?
FrancescoA is offline  
Old 03/19/2015, 11:36   #14
 
elite*gold: 0
Join Date: Jul 2012
Posts: 312
Received Thanks: 272
Well if you could give us some more informations about this many mistakes that you found maybe we can help you.

Anyway the query does work
andr3y_you96 is offline  
Old 03/19/2015, 13:13   #15
 
elite*gold: 0
Join Date: Feb 2015
Posts: 5
Received Thanks: 0
Quote:
Originally Posted by andr3y_you96 View Post
Well if you could give us some more informations about this many mistakes that you found maybe we can help you.

Anyway the query does work
gives me these errors when I run:

Msg 102, Level 15, State 1, Procedure GM_Enchant, Line 11
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 13
Must declare the scalar variable "@QuestID".
Msg 102, Level 15, State 1, Procedure GM_Enchant, Line 16
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Procedure GM_Enchant, Line 17
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 17
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 25
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 26
Must declare the scalar variable "@UserUID".
Msg 102, Level 15, State 1, Procedure GM_Enchant, Line 30
Incorrect syntax near ','.
Msg 102, Level 15, State 1, Procedure GM_Enchant, Line 36
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 36
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 38
Must declare the scalar variable "@Enchant".
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 40
Must declare the scalar variable "@Enchant".
Msg 102, Level 15, State 1, Procedure GM_Enchant, Line 43
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 45
Must declare the scalar variable "@Enchant".
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 47
Must declare the scalar variable "@EnchantString".
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 48
Must declare the scalar variable "@EnchantString".
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 51
Must declare the scalar variable "@EnchantString".
Msg 102, Level 15, State 1, Procedure GM_Enchant, Line 57
Incorrect syntax near '-'.
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 61
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Procedure GM_Enchant, Line 66
Must declare the scalar variable "@CharID".

you know how to change it?


FrancescoA is offline  
Reply



« give players items in gift box (item mall) | [Realize] Record_Boss customize »

Similar Threads
[Euphoria Dev Team Release] Perfect Orange Stats Game Service
08/02/2018 - Shaiya PServer Guides & Releases - 101 Replies
Hello elitepvpers, After multiple requests, I decided to release the Perfect Orange Stats Service that we used on Shaiya Euphoria. Before releasing it, we decided to improve it a little bit, to make it even more powerful and flexible. Some of you might prefer the web based recreation service, we chose to create something different, it's purely game based, you don't have to go on any website to do apply Perfect Orange Stats to your items. The former players of Shaiya Euphoria loved it, it is...
[Selling] Shaiya [US/FR/TR/PT/ES ]Ap Items OP/ Perfect Weapon[Armor] Lapisia boxs and more
11/07/2013 - Shaiya Trading - 1 Replies
Dear customers, This is vgolds.com,Shaiya Turkey server in game items hot sales now!Welcome all customers come to our site and have a look,if you need anything you can contact our live chat or you can add our customer service skype:gamesservice!And we also do cooperation with resellers in game,you will have 15% discount for reselling items in game,thanks for your attention! Shaiya -US- Phoenix ========================================================== Caros clientes, ** Este ...



All times are GMT +1. The time now is 09:30.


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

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