Smc D14

[hp151]

i can't make alchemy 14d .. always fail or Game says ' the alchemy enhancement can't be reinforced'

and sometimes it says the degree does not match the corresponding item .... it tried to add 14 d lines in sql and SR_gamerefdata .. but smc crashes ...

this is supposed to be my last request .. i hope u can help me Guys .....

[MentaL]

[iRaQiMafia]

I need this 14D SMC too, but without adding blues or stats, just the +

[hp151]

upppppppppppppp

[Caosfox]

I need this 14D SMC too, but without adding blues or stats, just the +

that is easy, simply add the lines of d14 items/weapon/sets to the itemdataxxxxx.txt on sr_gamerefdata folder at SMC

[hp151]

i did that . but smc crashes when i do this .... if u already did that . please upload ur SR_Gamerefdata

[Caosfox]

ItemData_40000.rar

only works for +++++ items, alchemy and things, dont

(change my ids for your ids)

[hp151]

thnx :)

can u upload magicoption.txt please ?

[Caosfox]

ItemData_40000.rar

only works for +++++ items, alchemy and things, dont

(change my ids for your ids)

i dont edited magic or anything, only works to ++++ items, blue or other things dont
my magicoption.txt is the default d12 one

[hp151]

okay . thnx v much . but i can't find accessories in itemdata ... what i supposed to do .. i'm sorry . i know it's so much .. but i hope u ca be patient with me :)

[Caosfox]

yeah, i was lazy to add accesories, i add them later when im back at home

[hp151]

:( it's not working at all .. i have the same bugs :S it says the alchemy enhancement can't be reinforced and some times when i try to + it says the degree does not match the corresponding item :((

can i have ur yahoo or face please ?

[iRaQiMafia]

ItemData_40000.rar

only works for +++++ items, alchemy and things, dont

(change my ids for your ids)

omg finally dude, it works well ^^
I can even add stats and shit!

[hp151]

yes sure . it's good .. but what about blues . i can't even make it manually :S

[Caosfox]

jewelry.txt

accesories here (add to itemdataxxxxxx.txt on sr_gamerefdata folder at smc)

[Caosfox]

for blues: manualy you need to create d14 stones first. (or downgrade d14 to d12)
using SMc : need to edit other files on sr_gamerefdata. (when i have time i check what files)

[iRaQiMafia]

jewelry.txt

accesories here (add to itemdataxxxxxx.txt on sr_gamerefdata folder at smc)

woot, thanks again!! ^^

[hp151]

i already have d 14 stones .. but as i told u it's not working .. but how can i downgrade d14 to 12 ?

[alikankan]

yeah, i was lazy to add accesories, i add them later when im back at home

select * from [SRO_VT_SHARD].[dbo].[_RefObjCommon] a,[SRO_VT_SHARD].[dbo].[_RefObjItem] b where a.Link=b.ID and a.CodeName128 like 'ITEM_ETC_ARCHEMY_ATTRSTONE%_14'

is this sql ?

I delete 3 column 'link ' 'ID' 'link' ,but smc crashes!

1	55334	ITEM_ETC_ARCHEMY_ATTRSTONE_PA_14	????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PA_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PA_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	533926	0	0	0	2500	106785	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_pa.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_PA	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	weapon	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55335	ITEM_ETC_ARCHEMY_ATTRSTONE_PASTR_14	??????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PASTR_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PASTR_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	537891	0	0	0	2500	107578	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_pastr.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_PASTR	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	weapon	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55336	ITEM_ETC_ARCHEMY_ATTRSTONE_MA_14	????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MA_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MA_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	537891	0	0	0	2500	107578	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_ma.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_MA	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	weapon	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55337	ITEM_ETC_ARCHEMY_ATTRSTONE_MAINT_14	??????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MAINT_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MAINT_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	537891	0	0	0	2500	107578	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_maint.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_MAINT	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	weapon	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55338	ITEM_ETC_ARCHEMY_ATTRSTONE_CRITICAL_14	????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_CRITICAL_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_CRITICAL_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	537891	0	0	0	2500	107578	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_critical.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_CRITICAL	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	weapon	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55339	ITEM_ETC_ARCHEMY_ATTRSTONE_HR_14	???? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_HR_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_HR_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	465203	0	0	0	2500	93041	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_hr.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_HR	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	weapon	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55340	ITEM_ETC_ARCHEMY_ATTRSTONE_PD_14	????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PD_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PD_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	533926	0	0	0	2500	106785	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_pd.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_PD	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	armor,shield	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55341	ITEM_ETC_ARCHEMY_ATTRSTONE_PDSTR_14	??????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PDSTR_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PDSTR_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	537891	0	0	0	2500	107578	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_pdstr.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_PDSTR	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	armor,shield	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55342	ITEM_ETC_ARCHEMY_ATTRSTONE_MD_14	????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MD_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MD_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	533926	0	0	0	2500	106785	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_md.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_MD	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	armor,shield	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55343	ITEM_ETC_ARCHEMY_ATTRSTONE_MDINT_14	??????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MDINT_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MDINT_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	465203	0	0	0	2500	93041	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_mdint.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_MDINT	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	armor,shield	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55344	ITEM_ETC_ARCHEMY_ATTRSTONE_ER_14	???? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_ER_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_ER_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	465203	0	0	0	2500	93041	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_er.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_ER	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	armor	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55345	ITEM_ETC_ARCHEMY_ATTRSTONE_BR_14	???? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_BR_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_BR_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	537891	0	0	0	2500	107578	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_br.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_BR	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	shield	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55346	ITEM_ETC_ARCHEMY_ATTRSTONE_PAR_14	????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PAR_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_PAR_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	533926	0	0	0	2500	106785	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_par.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_PAR	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	accessory	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	55347	ITEM_ETC_ARCHEMY_ATTRSTONE_MAR_14	????? ???	xxx	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MAR_14	SN_ITEM_ETC_ARCHEMY_ATTRSTONE_MAR_TT_DESC	0	0	3	3	11	2	180000	3	0	1	1	1	255	3	1	0	0	0	0	533926	0	0	0	2500	106785	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_archemy_1.bsr	item\etc\archemy_attrstone_mar.ddj	xxx	xxx	100	2	0	0	14	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14	NATTR_MAR	169090560	? 10, 20, 30, 0                                                                                                                  	86179840	? 5, 35, 0, 0	50	accessory	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0

[Caosfox]

only need to delete the "link" linking to the id of refobjitem, and that id must be deleted too

or you can use the getmediafiles proc, is easier

if i share mines, you need to do a big edit job, i changed a lot of params

[Madelyn]

@Caosfox
Can you release the sr_gamerefdata folder for who cant make D14 SMC xD

[Caosfox]

here
SR_GameRefData.rar

btw, if you get crash (im 80% sure you got it) check ids, i changed the ids of my db

[davydd]

I can't download :S