why onClock no run?!

[baro]

first, tks for read this, and double tks  If it can guide

I have this stru
in scripts_athena.conf
 firs call npc: npc/aa/globalparameters.txt

in globalparameters.txt

-    script    globalparameters    -1,{

OnClock2359:
    query_sql "delete from `acc_reg_num` where `key` = '#day_event'; ";
    debugmes "delete from `acc_reg_num` where `key` = '#day_event'; ";
    announce "Events was reseted, you can use a free daily entrance",0;
end;

}

Nothing happens with this script.
Does not show debug, does not execute sql

[Z3R0]

What's with the semi-colon within the sql statement? I don't think that needs to be there... Also, the sql key isn't goign to be #day_event ... it already knows it's an account variable beacuse it's in the acc_reg_num table... the variable is just "day_event"

 

 

[baro]

57 minutes ago, Z3R0 said:

What's with the semi-colon within the sql statement? I don't think that needs to be there... Also, the sql key isn't goign to be #day_event ... it already knows it's an account variable beacuse it's in the acc_reg_num table... the variable is just "day_event".
 

 

 

semi-colon, no necessary, but no a error, is a sql sintaxe;

key is a field (or column) and your content is #day_event, so if it's a text field and its content is #day_event, my query is correct when I use key = '#day_event'
I have no errors in the query, and even if there were, it should be listed by debugmes, nor does it appear.
 

[Z3R0]

hmmm that is strange actually

you are correct and I was wrong, the key does infact include the # sign. wonder why it won't delete then?

does your debugmes run at that time?

[baro]

On 04/08/2017 at 2:55 PM, Z3R0 said:

hmmm that is strange actually

you are correct and I was wrong, the key does infact include the # sign. wonder why it won't delete then?

does your debugmes run at that time?

Well .... it seems that nobody knows, or is not willing to respond.

[Z3R0]

U didn't answer my question does ur debug message run?