Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Smc D14

Junior Spellweaver
Joined
Feb 19, 2012
Messages
107
Reaction score
0
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 .....
 
In the Emperor name
Loyal Member
Joined
Jun 25, 2011
Messages
1,605
Reaction score
238
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
 
Last edited:
Upvote 0
Junior Spellweaver
Joined
Feb 19, 2012
Messages
107
Reaction score
0
i did that . but smc crashes when i do this .... if u already did that . please upload ur SR_Gamerefdata
 
Upvote 0
Junior Spellweaver
Joined
Feb 19, 2012
Messages
107
Reaction score
0
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 :)
 
Upvote 0
In the Emperor name
Loyal Member
Joined
Jun 25, 2011
Messages
1,605
Reaction score
238
yeah, i was lazy to add accesories, i add them later when im back at home
 
Upvote 0
Junior Spellweaver
Joined
Feb 19, 2012
Messages
107
Reaction score
0
:( 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 ?
 
Upvote 0
Junior Spellweaver
Joined
Feb 19, 2012
Messages
107
Reaction score
0
yes sure . it's good .. but what about blues . i can't even make it manually :S
 
Upvote 0
In the Emperor name
Loyal Member
Joined
Jun 25, 2011
Messages
1,605
Reaction score
238
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)
 
Upvote 0
Junior Spellweaver
Joined
Feb 19, 2012
Messages
107
Reaction score
0
i already have d 14 stones .. but as i told u it's not working .. but how can i downgrade d14 to 12 ?
 
Upvote 0
Newbie Spellweaver
Joined
Nov 29, 2011
Messages
5
Reaction score
0
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!
Code:
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
 
Last edited:
Upvote 0
In the Emperor name
Loyal Member
Joined
Jun 25, 2011
Messages
1,605
Reaction score
238
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
 
Upvote 0
† Working in Secret †
Joined
Jun 30, 2011
Messages
657
Reaction score
265
@Caosfox
Can you release the sr_gamerefdata folder for who cant make D14 SMC xD
 
Upvote 0
Back
Top