[Help Thread] Please post your questions here.

04/06/2012 18:08 ci4lblFmPW#346
@ProdStar:
Set decrease_type = 0 for making it a permanent item and set available_period = 0 for stopping the timer.

Code:
USE [Arcadia]
UPDATE ItemResource
SET decrease_type = 0
WHERE id = 540073

UPDATE ItemResource
SET available_period = 0
WHERE id = 540073
GO
This self-written query should do this, I did not test it ingame, but it should work.

Greez,

Ciel
04/07/2012 11:58 kaizoku801#347
write in captain herlock:
set log.server_name game001 (or "login server" if you use that)
set log.disable 1
set log.working 0
set log.chat.working 0

you prolly only need to write the:
set log.working 0 for it to work.. but i just typed those all and it stopped.. could skill fast from there on


edit: almost all of my NPC's in horizon are not working, except for grocery merch, any tips for that?
04/07/2012 13:48 zazabozaza1#348
hello can you please help me
[Only registered and activated users can see links. Click Here To Register...]
04/07/2012 14:04 kaizoku801#349
erm, try putting "connect auth" in upload server?
04/07/2012 14:07 zazabozaza1#350
greedings
i had a problem
[Only registered and activated users can see links. Click Here To Register...]
they say your vid is the solution to this problem can you please upload it in
media fire or what ever site you prefer
04/07/2012 14:42 X6axx34#351
null
04/07/2012 16:09 Judge12#352
1.)first, check is the sqlserver service is running,
2.)then check to make sure the .opt files are looking to 127.0.0.1
3.) check and make sure that in the mssql the tcp/ip settings are right.
for those look in the server setup guide.
04/07/2012 20:46 zazabozaza1#353
help please [Only registered and activated users can see links. Click Here To Register...]
04/07/2012 21:08 kaizoku801#354
you did not follow JWs guide correctly
04/07/2012 21:32 zazabozaza1#355
yes i did
04/08/2012 02:44 mlejnek2#356
ANY FIX FOR THE WH CRASH SERVER BUG?

or the fix for dura gears so they give stats tyvm
04/08/2012 02:55 kaizoku801#357
no, atleast not a public one...
04/08/2012 15:45 Judge12#358
as far as the wh bug is concerned.
(and maybe someone can shed some more light on this)
I've noticed that there is an item that is dropped that has a code of 0
the first time you access the wh. afterward it doesn't drop that item.

i'm thinking that this has something to do with a security check, after you delete that item the wh will open again.

I tried to add a trigger to the table that would automatically delete that line,
but that just blew up the server.
04/08/2012 15:51 X6axx34#359
My Server ( 7.3 ) crash every 5mins ... Do you have a solution ?
I use CaptainHerlock 7.3 by iSmoke
Win7 x64
04/08/2012 15:55 Judge12#360
without more info about your crashing every 5 minutes, no.