[Help Thread] Please post your questions here.

[ci4lblFmPW]

@ProdStar:
Set decrease_type = 0 for making it a permanent item and set available_period = 0 for stopping the timer.

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

[kaizoku801]

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?

[zazabozaza1]

hello can you please help me

[kaizoku801]

erm, try putting "connect auth" in upload server?

[zazabozaza1]

greedings
i had a problem

they say your vid is the solution to this problem can you please upload it in
media fire or what ever site you prefer

[X6axx34]

null

[Judge12]

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.

[zazabozaza1]

help please

[kaizoku801]

you did not follow JWs guide correctly

[zazabozaza1]

yes i did

[mlejnek2]

ANY FIX FOR THE WH CRASH SERVER BUG?

or the fix for dura gears so they give stats tyvm

[kaizoku801]

no, atleast not a public one...

[Judge12]

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.

[X6axx34]

My Server ( 7.3 ) crash every 5mins ... Do you have a solution ?
I use CaptainHerlock 7.3 by iSmoke
Win7 x64

[Judge12]

without more info about your crashing every 5 minutes, no.