[Release]D13 Fix to work with alchemy D12

[Kemo]

Since Ksro release D13 alot of peoples add it but no stones or lucky powder and item lvl is 101 here u can fix this:
First:
Fix item lvl from 101 to 120

Query:

USE sro_vt_shard
/* Chinese */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_CH%13%RARE%'
/* EU Heavy */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%HEAVY%13%RARE%'
/* EU Light */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%LIGHT%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel2=120 WHERE CodeName128 LIKE '%ITEM_EU%LIGHT%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel3=120 WHERE CodeName128 LIKE '%ITEM_EU%LIGHT%13%RARE%'
/* EU Clothes */
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel2=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel3=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
UPDATE _RefObjCommon SET ReqLevel4=120 WHERE CodeName128 LIKE '%ITEM_EU%CLOTHES%13%RARE%'
/* EU acc and weapon*/
UPDATE _RefObjCommon SET ReqLevel1=120 WHERE CodeName128 LIKE '%ITEM_EU%13_A_RARE%' OR CodeName128 LIKE '%ITEM_EU%13_B_RARE%' OR CodeName128 LIKE '%ITEM_EU%13_C_RARE%'

Second:
D13 working with D12 alchemy system
Query:

use sro_vt_shard
UPDATE _RefObjItem SET ItemClass=34 WHERE ItemClass=37
UPDATE _RefObjItem SET ItemClass=35 WHERE ItemClass=38
UPDATE _RefObjItem SET ItemClass=36 WHERE ItemClass=39

also in media side u can do it easily in ur itemdata.txt u can edit it's easy
have fun guys i will release alot of useful stuff later.

hope i helped :),Keep on sharing guys as Jangan said.
Credits Goes to my Friend sladlejrhfpq
threrad update here's my itemdata.txt
http://www.mediafire.com/?bhsapwarcl4its7

[MentaL]

[tamer153]

nice guilde i will try it later :D

[SuperHer0]

hi pro i edit table
use sro_vt_shard
UPDATE _RefObjItem SET ItemClass=34 WHERE ItemClass=37
UPDATE _RefObjItem SET ItemClass=35 WHERE ItemClass=38
UPDATE _RefObjItem SET ItemClass=36 WHERE ItemClass=39

and no thing happend ? any soulation ? :(

[skerdikas]

also in media side u can do it easily in ur itemdata.txt u can edit it's easy

Cant u read?

[SuperHer0]

Cant u read?

he said itemdata for change item lv not for archemy system !

[skerdikas]

since ksro release d13 alot of peoples add it but no stones or lucky powder and item lvl is 101 here u can fix this:
First:
Fix item lvl from 101 to 120

query:
Second:
D13 working with d12 alchemy system
query:
Also in media side u can do it easily in ur itemdata.txt u can edit it's easy
have fun guys i will release alot of useful stuff later.

Hope i helped :),keep on sharing guys as jangan said.
Credits goes to my friend sladlejrhfpq

are u sure? bcuz im looking in itemdata txt files in found 34 35 36 near name's and that means item class i think but can find for 13d yet gonna help u out if ill find it

[SuperHer0]

are u sure? bcuz im looking in itemdata txt files in found 34 35 36 near name's and that means item class i think but can find for 13d yet gonna help u out if ill find it

maybe. but i think it for change iteams lv

[skerdikas]

its for both ill find out where and what gonna edit later maybe

[The Hell]

Th@nks Nice Release will try it when back home..

[ahmed_ahmed9889]

thx alot kemo

[SuperHer0]

pro we need magicoption.txt have same line with ur quary

use sro_vt_shard
UPDATE _RefObjItem SET ItemClass=34 WHERE ItemClass=37
UPDATE _RefObjItem SET ItemClass=35 WHERE ItemClass=38
UPDATE _RefObjItem SET ItemClass=36 WHERE ItemClass=39

any one help ?

[Pklawz]

*copies your pk2 does not need to be your edited just simply add in a pk2 because I am having crash error

[omerdogan41]

well doesnt for work me too,i hope we can find a way to add at least lucky powders,i don't care it works or not,thank you for trying to help people. :)

[nicholasnjh]

Kemooooooo you there ?i already added you in msn o_O and skype

[asuradoll]

Nice thread! Thank you share!

[mohsen857]

ty pro

[Kira]

Thx Bro :)

[manoo92]

crash (Y)

[serend]

ive changed sql for alcemy what do i edit in media please
or how do i add all d13 stones as most are missing

[C0SM1C]

Crash! Failed ^^

Thx , Bye

[serend]

so anyone get 12d to work 13d ?

[Peclawz]

Fixe Crash pk2
http://www.mediafire.com/?ujmto7h06d554oe

[serend]

Fixe Crash pk2
itens data fixe.txt

um what has ftp info got to do with the crash lol

Language = "Vietnam"
Country = "Vietnam"
GameType = "Silkroad_TestIn"
MarkFTPAddr = "markftp:123456@62.75.219.24:31113"
MarkFTPPath = "SRO_CREST