Enchant Rate 100%

[Denios15]

Can someone tell me how to make enchant rate to 100% please?
I already did 100% taming but not sure how to do enchant ;/

[Xelvair]

I'm guessing it's hardcoded, we'll have to wait for the devs to release an extraction tool (hope they will release one :S)

[Denios15]

Xelvair i got 1 question :
USE [Telecaster]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[smp_insert_item]
@IN_SID = 3, --Change this Per Item
@IN_OWNER_ID = IGMIDenio, --Char ID
@IN_ACCOUNT_ID = 0,
@IN_SUMMON_ID = 0,
@IN_AUCTION_ID = 0,
@IN_KEEPING_ID = 0,
@IN_CODE = 910037, --Item Code
@IN_IDX = 100, --Place in Inv (doesnt seem to matter)
@IN_FLAG = 0,
@IN_CNT = 10, --How Many you want
@IN_LEVEL = 1, --Item Level
@IN_ENHANCE = 0, -- Item +
@IN_ENDURANCE = 100,
@IN_GCODE = 1,
@IN_REMAIN_TIME = 0,
@IN_ELEMENTAL_EFFECT_TYPE = 0,
@IN_ELEMENTAL_EFFECT_EXPIRE_TIME = N'1970-01-01 11:00:00.000',
@IN_ELEMENTAL_EFFECT_ATTACK_POINT = 0,
@IN_ELEMENTAL_EFFECT_MAGIC_POINT = 0

SELECT 'Return Value' = @return_value

GO
------------------------------
i am doing it and i am not getting any item ;/
is there something wrong ?

-------------

[Xelvair]

Hmm... I never used the DB query solution, insert_item works for me, so I can't hel you, sorry.

[Denios15]

I am writing this :

#insert_item(540010, 1, 1, 1, -2147483648, "IGMIDenio")

----------------
i do something wrong here or it dont work for me ?

[Cieldaron]

For setting enchantment rate to 100% for every stage I made this query...it's not perfect, I know, but it works.

 Spoiler

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = 1
WHERE [percentage_1] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = 1
WHERE [percentage_2] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = 1
WHERE [percentage_3] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = 1
WHERE [percentage_4] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = 1
WHERE [percentage_5] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = 1
WHERE [percentage_6] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = 1
WHERE [percentage_7] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = 1
WHERE [percentage_8] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = 1
WHERE [percentage_9] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = 1
WHERE [percentage_10] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_11] = 1
WHERE [percentage_11] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_12] = 1
WHERE [percentage_12] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_13] = 1
WHERE [percentage_13] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_14] = 1
WHERE [percentage_14] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_15] = 1
WHERE [percentage_15] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_16] = 1
WHERE [percentage_16] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_17] = 1
WHERE [percentage_17] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_18] = 1
WHERE [percentage_18] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_19] = 1
WHERE [percentage_19] > 0
GO

UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_20] = 1
WHERE [percentage_20] > 0
GO

You just need to rerun yor server after executing the query.

Greez,

Cieldaron

[Xelvair]

Originally Posted by Cieldaron

For setting enchantment rate to 100% for every stage I made this query...it's not perfect, I know, but it works.

-snip-

You just need to rerun yor server after executing the query.

Greez,

Cieldaron

Woo, so it's not hardcoded, thanks

[Cieldaron]

Nvm, I was just getting annoyed by writing the same stuff for 20 different enchantment values.

And here's a self written query with which you may set every equipment in your inventory AND the warehouse to 10+20, so you haven't got to create an insert_item for every item you want 10+20... *rolleyes*

NOTE: This will affect EVERY item to be 10+20 (e.g. White Lydian 10+20, lol), but that shouldn't be a problem.

Skillcards will be +20.

You just need to run the query and relog. (:

 Spoiler

UPDATE [Telecaster].[dbo].[Item]
SET [enhance] = 20
GO

UPDATE [Telecaster].[dbo].[Item]
SET [level] = 10
GO

Hope I helped!

Greez,

Cieldaron

[Cieldaron]

Thanks for the info, speedy.

Was wondering how it could work. (:

[Arango9]

they doenst work on normal rappelz or?

[wisp66]

MAKE SURE you change edit row to 1000 or 10000 max if u plan to do this otherwise your not editing and viewing the whole tame chart

[Krajst]

When I was fiddling with my server I made a query to change all enchant_rate fields to 1.000. Deleted everthing when I got tired of all the bugs, so I didn't save it anywhere.
But as Wisp says, you have to change edit row to 10000 before you try it.

I'm sure that someone with more SQL skills then me can write you a query for it.

[RoflcopterGoesSoiSoiSoi]

Oh look, another misinformed post from Wisp. What is this, the third? Fourth? Oh well, it doesn't matter, I'm sure there will be another one soon.

It doesn't matter if you are viewing one specific row or the entire table, SQL queries affect whatever you do (or don't) put inside the WHERE regex.

[wisp66]

how i this miss infomation it doesnt work at edit 200 rows
tell you what well just go completly private ill never post here again and u can fix and post everything how that be? i think we could all use a vacation anyhow

[RoflcopterGoesSoiSoiSoi]

1) Open SQL Server Management Studio
2) Connect to database
3) CTRL+N

USE Arcadia
GO

UPDATE [dbo].[MonsterResource] SET taming_percentage='1.0000'

4) Press F5