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 08:37

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


Perfect Enchant Lapisia Game Service

Reply
 
Old 03/19/2015, 13:45   #16
 
elite*gold: 0
Join Date: Sep 2011
Posts: 407
Received Thanks: 258
Quote:
Originally Posted by FrancescoA View Post
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?
Do you read first post ?
This is trigger for quest for lapasia +1 or whatever
I guess you change this script to query but you forget declare some things
Code:
UPDATE PS_GameData.dbo.UserStoredItems
SET Craftname = SUBSTRING(Craftname, 1, 18) + '1'
WHERE UserUID = "UserUID' AND Slot = 0



SnickQ is offline  
Old 03/19/2015, 13:52   #17
 
elite*gold: 0
Join Date: Feb 2015
Posts: 5
Received Thanks: 0
Quote:
Originally Posted by SnickQ View Post
Do you read firs post ?
This is trigger for quest for lapasia +1 or whatever
I guess you change this script to query but you forget declare some things
Code:
UPDATE PS_GameData.dbo.UserStoredItems
SET Craftname = SUBSTRING(Craftname, 1, 18) + '1'
WHERE UserUID = "UserUID' AND Slot = 0

so how would I do the query for him not to make mistakes? you written all well please?


FrancescoA is offline  
Old 05/01/2015, 13:08   #18
 
elite*gold: 0
Join Date: Aug 2012
Posts: 454
Received Thanks: 103
i have this error in sql, how i can fix ??
Already Use..
AxelMac is offline  
Old 05/01/2015, 14:56   #19
 
elite*gold: 0
Join Date: Sep 2011
Posts: 407
Received Thanks: 258
I dont understand where is your problem
This si query to change enchant in wh players

This is trigger for change enchant with quest
Code:
USE [PS_GameData]
GO

/****** Object: Trigger [dbo].[GM_Enchant] Script Date: 08/07/2014 22:49:59 ******/
SET ANSI_NULLS ON
GO



SET QUOTED_IDENTIFIER ON
GO


CREATE TRIGGER [dbo].[GM_Enchant]
ON [dbo].[CharQuests]
AFTER INSERT
AS
BEGIN

SET NOCOUNT ON;

DECLARE @QuestID INT = (SELECT QuestID FROM inserted)

IF @QuestID = 1720 -- QuestID
BEGIN

DECLARE @CharID INT = (SELECT CharID FROM inserted)
DECLARE @UserUID INT = (SELECT UserUID FROM Chars WHERE CharID = @CharID)

DECLARE @ItemType TINYINT,
@EnchantItemId INT

DECLARE @EnchantItem TABLE (EnchantID INT)
DECLARE @GearTypes TABLE (GearTypes TINYINT)

SET @ItemType = (SELECT Type FROM UserStoredItems WHERE UserUID = @UserUID AND Slot = 0)
SET @EnchantItemId = (SELECT ItemID FROM UserStoredItems WHERE UserUID = @UserUID AND Slot = 1)
-- the perfect lapisia itemid, change it for you needs
INSERT INTO @EnchantItem VALUES (100230)
-- add all the gear types you want to use here
INSERT INTO @GearTypes VALUES (16),(17),(18),(19),(20),(21),(24),(31),(32),(33), (34),(35),(36),(39),(58) ,(1),(2),(3),
(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),( 15),(22),(23),(40)

IF ((@ItemType IN (SELECT GearTypes FROM @GearTypes)) AND (@EnchantItemID IN (SELECT EnchantID FROM @EnchantItem)))

BEGIN
DECLARE @Enchant TINYINT = (SELECT CAST(SUBSTRING(Craftname, 19, 2) AS TINYINT) FROM UserStoredItems WHERE UserUID = @UserUID AND Slot = 0)
--- max enchant its [10]
IF @Enchant > = 60
GOTO FAIL
ELSE IF @Enchant > = 10 AND @Enchant < 50
GOTO FAIL

SET @Enchant += 1 -- this will increase the enchant by 1

DECLARE @EnchantString CHAR(2) = @Enchant

IF LEN(@EnchantString) = 1
SET @EnchantString = '0' + @EnchantString

UPDATE UserStoredItems
SET Craftname = SUBSTRING(Craftname, 1, 18) + @EnchantString
WHERE UserUID = @UserUID AND Slot = 0

END
ELSE GOTO FAIL
UPDATE UserStoredItems
SET Count -= 1
WHERE UserUID = @UserUID AND Slot = 1

DELETE FROM UserStoredItems
WHERE UserUID = @UserUID AND Slot = 1 AND Count = 0

FAIL:
DELETEQUEST:
DELETE FROM CharQuests
WHERE CharID = @CharID AND QuestID = @QuestID
END
END
GO


SnickQ is offline  
Old 05/01/2015, 17:24   #20
 
elite*gold: 0
Join Date: Aug 2012
Posts: 454
Received Thanks: 103
Quote:
Originally Posted by SnickQ View Post
I dont understand where is your problem
This si query to change enchant in wh players

This is trigger for change enchant with quest
Code:
USE [PS_GameData]
GO

/****** Object: Trigger [dbo].[GM_Enchant] Script Date: 08/07/2014 22:49:59 ******/
SET ANSI_NULLS ON
GO



SET QUOTED_IDENTIFIER ON
GO


CREATE TRIGGER [dbo].[GM_Enchant]
ON [dbo].[CharQuests]
AFTER INSERT
AS
BEGIN

SET NOCOUNT ON;

DECLARE @QuestID INT = (SELECT QuestID FROM inserted)

IF @QuestID = 1720 -- QuestID
BEGIN

DECLARE @CharID INT = (SELECT CharID FROM inserted)
DECLARE @UserUID INT = (SELECT UserUID FROM Chars WHERE CharID = @CharID)

DECLARE @ItemType TINYINT,
@EnchantItemId INT

DECLARE @EnchantItem TABLE (EnchantID INT)
DECLARE @GearTypes TABLE (GearTypes TINYINT)

SET @ItemType = (SELECT Type FROM UserStoredItems WHERE UserUID = @UserUID AND Slot = 0)
SET @EnchantItemId = (SELECT ItemID FROM UserStoredItems WHERE UserUID = @UserUID AND Slot = 1)
-- the perfect lapisia itemid, change it for you needs
INSERT INTO @EnchantItem VALUES (100230)
-- add all the gear types you want to use here
INSERT INTO @GearTypes VALUES (16),(17),(18),(19),(20),(21),(24),(31),(32),(33), (34),(35),(36),(39),(58) ,(1),(2),(3),
(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),( 15),(22),(23),(40)

IF ((@ItemType IN (SELECT GearTypes FROM @GearTypes)) AND (@EnchantItemID IN (SELECT EnchantID FROM @EnchantItem)))

BEGIN
DECLARE @Enchant TINYINT = (SELECT CAST(SUBSTRING(Craftname, 19, 2) AS TINYINT) FROM UserStoredItems WHERE UserUID = @UserUID AND Slot = 0)
--- max enchant its [10]
IF @Enchant > = 60
GOTO FAIL
ELSE IF @Enchant > = 10 AND @Enchant < 50
GOTO FAIL

SET @Enchant += 1 -- this will increase the enchant by 1

DECLARE @EnchantString CHAR(2) = @Enchant

IF LEN(@EnchantString) = 1
SET @EnchantString = '0' + @EnchantString

UPDATE UserStoredItems
SET Craftname = SUBSTRING(Craftname, 1, 18) + @EnchantString
WHERE UserUID = @UserUID AND Slot = 0

END
ELSE GOTO FAIL
UPDATE UserStoredItems
SET Count -= 1
WHERE UserUID = @UserUID AND Slot = 1

DELETE FROM UserStoredItems
WHERE UserUID = @UserUID AND Slot = 1 AND Count = 0

FAIL:
DELETEQUEST:
DELETE FROM CharQuests
WHERE CharID = @CharID AND QuestID = @QuestID
END
END
GO
idk because to me not working, if anyone know other way.
AxelMac is offline  
Old 05/01/2015, 18:32   #21
 
elite*gold: 0
Join Date: Sep 2011
Posts: 407
Received Thanks: 258
Quote:
Originally Posted by AxelMac View Post
idk because to me not working, if anyone know other way.
Do you use id quest in game like is in trigger?

Code:
IF @QuestID = 1720 -- QuestID
BEGIN
SnickQ is offline  
Old 05/01/2015, 20:50   #22
 
elite*gold: 0
Join Date: Aug 2012
Posts: 454
Received Thanks: 103
Quote:
Originally Posted by SnickQ View Post
Do you use id quest in game like is in trigger?

Code:
IF @QuestID = 1720 -- QuestID
BEGIN
If i not have quest this script not working ??
AxelMac is offline  
Old 05/02/2015, 00:14   #23
 
elite*gold: 0
Join Date: Sep 2011
Posts: 407
Received Thanks: 258
Yes you need quest for enchant
SnickQ is offline  
Old 05/03/2015, 15:06   #24
 
elite*gold: 0
Join Date: Aug 2012
Posts: 454
Received Thanks: 103
Quote:
Originally Posted by SnickQ View Post
Yes you need quest for enchant
I have the quest , but the problem that the database is not part of it.
AxelMac is offline  
Old 05/03/2015, 21:46   #25
 
elite*gold: 0
Join Date: Apr 2015
Posts: 420
Received Thanks: 107
Full work for me.
Thanks!
SkuulCandy is offline  
Old 05/19/2015, 06:21   #26
 
elite*gold: 0
Join Date: Feb 2014
Posts: 54
Received Thanks: 41
the script you release is pretty good but has a few problems with it if im not mistaken

gears don't start at 50 they aren't changed into 50+ until the first enchant is added so if they have 0 enchants the number your getting from the craftname is 00 which means you are adding attack power to armor instead of abs. so this

IF @Enchant > = 60
GOTO FAIL
ELSE IF @Enchant > = 10 AND @Enchant < 50
GOTO FAIL

should look like this


and the insert into table here aren't really needed because the info is already inside tables in the database but I guess that's your style to each their own

and to anyone running this script as it is you probly have people running about with a lot more attack power then they should lol another 5 pieces armor with power enchants
Mark.Teal1982 is offline  
Old 05/19/2015, 17:32   #27
 
elite*gold: 0
Join Date: Apr 2015
Posts: 420
Received Thanks: 107
The stats of power and those of the defense are not displayed but are well taken into effect. Look by you even changing equipment.
SkuulCandy is offline  
Old 05/19/2015, 19:01   #28
 
elite*gold: 0
Join Date: Feb 2014
Posts: 54
Received Thanks: 41
Quote:
Originally Posted by SkuulCandy View Post
The stats of power and those of the defense are not displayed but are well taken into effect. Look by you even changing equipment.
they are shown in the database

the last 2 digits in the craftname is the enchant this is correct and armor and weapons both start at 00 from the game functions as the items was created

examples new items
armor 00010000000000020000
weapon 00000003000000020000

examples normal enchant with 1 enchant added
armor 00010000000000020051
weapon 00000003000000020001

examples with the current trigger 1 enchant added
armor 00010000000000020001
weapon 00000003000000020001

abs classifications are 51 - 99
attack power classifications are 1 - 49

so what im getting at is if there isn't a statement in the script to move the armor to 51 on the first enchant so it then will receive power enchants just like a weapon

the client reads the enchants as 01-49 = power increase and 51-99 as abs increase

I have tested this in the admin panel about 8 months ago i add enchants and instead of added 70 to the gears i added 20 which pretty much doubled the current damage so believe me when I say it does in fact make a difference if you are using the current trigger or if your using the trigger with the fix I added

I wrote this to help people fix the database tables that was affected by the error in the trigger this will change all the gears that have power enchants on them to abs enchants

This will show you all the incorrect enchants and change them to the correct ones

note: im not working on a active server so I might have missed a table think it might be MarketCharResultMoney I think but not sure this is where the bought and failed items are put from the market if so youll have to write a script for it because I didn't add it

i also just figure out its missing a lot of the types I think this types listed was from a ep4 database because ep5 and above I believe have all this types as armor weapons and capes (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,2 0,21,24,31,32,33,34,35,36,39,45,46,47,48,49,50,51, 52,53,54,55,56,57,58,59,60,61,62,63,64,65,67,68,69 ,70,82,83,84,85,86) so if you ran this on a ep5 database it would only let you do enchants to about half the items
Mark.Teal1982 is offline  
Thanks
1 User
Old 05/26/2015, 21:30   #29
 
elite*gold: 0
Join Date: Jan 2012
Posts: 428
Received Thanks: 30
this is without +100 absorbation...sorry..is there a way to become with this?
Cansas59 is offline  
Old 05/26/2015, 21:49   #30
 
elite*gold: 0
Join Date: Apr 2015
Posts: 420
Received Thanks: 107
Don't worry, the absorption and/or physical damage is gere (look your stats)


SkuulCandy 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 08:37.


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.