Request a Krall Query :D

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 :D :D

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 ? :D :D

Quote:

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 :D :D

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

Quote:

Originally Posted by jadeyisafuckingscammer update _refobjcommon set service = '1' where codename128 like 'item%'

fyll krall working :D :D
Thank you :D

it will crash your gs any way ^_^

Quote:

Originally Posted by ahmed4ever2u it will crash your gs any way ^_^

Thats right xDD

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

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 .

Quote:

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