hello PPls i have question about refobjcommon i want know arena coins item id and Uniques monster id please help how i can search for
Printable View
hello PPls i have question about refobjcommon i want know arena coins item id and Uniques monster id please help how i can search for
hi friend! welcome to RZ!
run this query for arena coin ID:
run this query for mobs:PHP Code:SELECT * FROM _RefObjCommon WHERE CodeName128 = 'ITEM_ETC_ARENA_COIN'
PHP Code:SELECT * FROM _RefObjChar WHERE CodeName128 like 'MOB_%'
http://i49.tinypic.com/2eksuu1.png
This an error i found when i try but i try it with type ID and any number like 5 Ites works but with CodeName128 its wont work :(
Go to refobjitem, there you see that 'codename128' doesnt excist,Quote:
Originally Posted by kotsh
if you want for example to edit on refobjitem area coin i would do it like this -->
Quote:
SELECT * FROM dbo._refobjcommon
where codename128 like '%ITEM_ETC_ARENA_COIN%'
result = -->
1 25834 ITEM_ETC_ARENA_COIN ??? ?? xxx SN_ITEM_ETC_ARENA_COIN SN_ITEM_ETC_ARENA_COIN_TT_DESC 0 0 3 3 5 1 180000 3 0 1 1 0 255 1 1 0 0 0 0 1 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_token.bsr item\etc\honor_medals.ddj xxx xxx 12322
(the red letters are the ID of refobjitem)
If you need to edit that item in refobjitem run this query -->
SELECT * FROM dbo._RefObjItem
where ID like '%12322%'
result -->
12322 200 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -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 -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
Quote:
Originally Posted by LogiN
The second query wont work ._. select a MONSTER in refobjitem? has to be refobjcommon. and you cant find any monsters in refobjitem, has to be refobjchar ;)
Ok thanks Guys but i wanna edit it to how :D this is another query to edit ??
Quote:
Originally Posted by kotsh
what you wanna edit ._.
explain more... lol
edit Cap lvl my skills and weapons are d12 but my server Cap is 130 how i can edit it only lvl 120 he can lvl up to
Greetings, I agree with you. Also I have not given this answer .. I think the member has some cyber Sorry. And I agree with # FantaciaSRO
search for sr patcher... lolQuote:
Originally Posted by kotsh
people driving me crazy here...
@
SELECT * FROM dbo._refobjcommon
where codename128 like '%ITEM_ETC_ARENA_COIN%'
result = -->
1 25834 ITEM_ETC_ARENA_COIN ??? ?? xxx SN_ITEM_ETC_ARENA_COIN SN_ITEM_ETC_ARENA_COIN_TT_DESC 0 0 3 3 5 1 180000 3 0 1 1 0 255 1 1 0 0 0 0 1 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_token.bsr item\etc\honor_medals.ddj xxx xxx 12322
(the red letters are the ID of refobjitem)
If you need to edit that item in refobjitem run this query -->
SELECT * FROM dbo._RefObjItem
where ID like '%12322%'
result -->
12322 200 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -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 -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
why the hell where ID like '%12322%' if you already have the Exact number then use ID = X .
like oprator create for searching multiplay/single row with 1 part of the word/number .
but if you have a whole number you dont need it.
kotsh = to edit stuff like cap level and limits you must debug gameserver (using odbg) , also you can use chernobyel tools (SrPatcher/EvaTools) or what ever they called...
dont forget to edit client side too. (sro_client.exe) otherwish you gonna have some problems with leveling .