Request a Krall Query :D

[Neko_]

HEY ALL ...

is there is any query to activate all un activated item ?
i mean at refobjcommon and set all service to 1..
i am not good at queries

And i also need some way to extract the tables in DB into a *.txt so i can edit through EXCEL ?
and some way to import it again ?

[jadeyisafuckingscammer]

Originally Posted by Neko_

HEY ALL ...

is there is any query to activate all un activated item ?
i mean at refobjcommon and set all service to 1..
i am not good at queries

update _refobjcommon set service = '1' where codename128 like 'item%'

[Neko_]

Originally Posted by jadeyisafuckingscammer

update _refobjcommon set service = '1' where codename128 like 'item%'

fyll krall working
Thank you

[ahmed4ever2u]

it will crash your gs any way ^_^

[Neko_]

Originally Posted by ahmed4ever2u

it will crash your gs any way ^_^

Thats right xDD

[rushcrush]

or UPDATE _refobjcommon SET SERVICE = '1' WHERE SERVICE = '0'
xD
but right..it will crash your game server

[Dr.Abdelfattah]

The Database you got is a TestIn database, It's got some new stuff doesn't add yet to gameserver (params) So you can't enable of those items due of un-exist params at gameserver or it will cause crash or job overlap error .

[6_lucifer_6]

Originally Posted by Dr.Abdelfattah

The Database you got is a TestIn database, It's got some new stuff doesn't add yet to gameserver (params) So you can't enable of those items due of un-exist params at gameserver or it will cause crash or job overlap error .

u sound genious.. xD i read half line and had that thought.. lol