some noobs querys + question
i made this noob post because i don't like ask for help and don't contribute with something
there you got some poor querys . maybe you need it . :ott1:
3 faces of inventory for a specific character
PHP Code:
use SRO_VT_SHARD_INIT
update dbo._Char
set InventorySize =96
where CharName16 ='charname'
change hwanlv for a specific character
PHP Code:
use SRO_VT_SHARD_INIT
update dbo._Char
set HwanLevel =1
where CharName16 ='charname'
make item trade tradable
PHP Code:
use SRO_VT_SHARD_INIT
update dbo._RefObjCommon
set CanTrade =1
where CodeName128 ='ITEM_ETC_CURE_ALL_01'
make item trade usable
PHP Code:
use SRO_VT_SHARD_INIT
update dbo._RefObjCommon
set CanUse =0
where CodeName128 ='ITEM_ETC_CURE_ALL_01'
change price in silk to gold
PHP Code:
use SRO_VT_SHARD_INIT
update dbo._RefObjCommon
set CanUse =0
where CodeName128 ='ITEM_ETC_CURE_ALL_01'
PHP Code:
use SRO_VT_SHARD_INIT
update dbo._RefPricePolicyOfItem
set PaymentDevice =1
where RefPackageItemCodeName 'PACKAGE_ITEM_ETC_CURE_ALL_01'
now my question ..
where i can change the degree of a item ..
example d13 sword to d12
:sleep::sleep:
Re: some noobs querys + question
nice Queries
what do u mean by changing D12 to D13 >> do u mean to add D13 in your files or to make some upgrade system
or what !!
Re: some noobs querys + question
Quote:
Originally Posted by
3d2000
nice Queries
what do u mean by changing D12 to D13 >> do u mean to add D13 in your files or to make some upgrade system
or what !!
I have already d13 items
I need to change the degree to work with the stones of degree 12
ty for answer
Re: some noobs querys + question
Quote:
Originally Posted by
thepronto
I have already d13 items
I need to change the degree to work with the stones of degree 12
ty for answer
PHP Code:
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
Re: some noobs querys + question
Quote:
Originally Posted by
sladlejrhfpq
PHP Code:
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
that is an example or full query?
ty ^^ work <3 loviu hehe
Re: some noobs querys + question
Re: some noobs querys + question
max inventory 109? sure?
4 * 8 = 24 per inventory site
24 * 3 = 96
Re: some noobs querys + question
Quote:
Originally Posted by
thepronto
that is an example or full query?
ty ^^ work <3 loviu hehe
Thats the full, you see it is not that hard. Of course, you have to edit the client side. (the itemdata you put the d13 items)
Re: some noobs querys + question
Quote:
Originally Posted by
flyfly
max inventory 109? sure?
4 * 8 = 24 per inventory site
24 * 3 = 96
4*8=32 not 24
and i think you must count slots for suit,weapon and avatar too :)
Re: some noobs querys + question
Re: some noobs querys + question
as far as i know ppl use to call 13D items the D12 ones, they just took the 13d .ddjs from ksro and replaced with the 12D suns .ddj (they're overpowered perfect thing to be 13D w/e) also they removed som/ changed sos to nova, all this happens/d unless some1 took his time to add all the 13D items like all the others...so when u see some1 talking about D13 that is just pk2 editing, there's no D13 at all
Re: some noobs querys + question
Re: some noobs querys + question
Quote:
Originally Posted by
Alex1337
as far as i know ppl use to call 13D items the D12 ones, they just took the 13d .ddjs from ksro and replaced with the 12D suns .ddj (they're overpowered perfect thing to be 13D w/e) also they removed som/ changed sos to nova, all this happens/d unless some1 took his time to add all the 13D items like all the others...so when u see some1 talking about D13 that is just pk2 editing, there's no D13 at all
there is 13degree , but they need to be added to the database too.
and there will be the real 13dg`s.
Re: some noobs querys + question
Quote:
Originally Posted by
Alex1337
as far as i know ppl use to call 13D items the D12 ones, they just took the 13d .ddjs from ksro and replaced with the 12D suns .ddj (they're overpowered perfect thing to be 13D w/e) also they removed som/ changed sos to nova, all this happens/d unless some1 took his time to add all the 13D items like all the others...so when u see some1 talking about D13 that is just pk2 editing, there's no D13 at all
its not pk2 edit. I had 13D the same day ksro had the patch
