Enchant Rate 100%

Page 1 of 2 1 2
07/11/2011 14:41 Denios15#1
Can someone tell me how to make enchant rate to 100% please? :D
I already did 100% taming but not sure how to do enchant ;/
07/11/2011 14:43 Xelvair#2
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)
07/11/2011 14:50 Denios15#3
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 ?

-------------
07/11/2011 14:56 Xelvair#4
Hmm... I never used the DB query solution, insert_item works for me, so I can't hel you, sorry.
07/11/2011 15:02 Denios15#5
I am writing this :

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

----------------
i do something wrong here or it dont work for me ?
07/11/2011 15:12 Cieldaron#6
For setting enchantment rate to 100% for every stage I made this query...it's not perfect, I know, but it works.


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

Greez,

Cieldaron
07/11/2011 16:02 Xelvair#7
Quote:
Originally Posted by Cieldaron View Post
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 :)
07/11/2011 16:16 Cieldaron#8
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. (:


Hope I helped!

Greez,

Cieldaron
07/11/2011 17:32 Cieldaron#9
Thanks for the info, speedy.

Was wondering how it could work. (:
07/11/2011 22:42 Arango9#10
they doenst work on normal rappelz or?
07/11/2011 22:48 wisp66#11
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
07/11/2011 23:18 Krajst#12
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.
07/12/2011 00:33 RoflcopterGoesSoiSoiSoi#13
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.
07/12/2011 00:39 wisp66#14
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
07/12/2011 00:45 RoflcopterGoesSoiSoiSoi#15
1) Open SQL Server Management Studio
2) Connect to database
3) CTRL+N
Code:
USE Arcadia
GO

UPDATE [dbo].[MonsterResource] SET taming_percentage='1.0000'
4) Press F5
Page 1 of 2 1 2