2 question Get real windows Time and Lockboxes

[Pumpi]

I Have 2 questions:

 

I will write an script that warns before restart but for this in need the real server time. Is there an way to read this in an sqf?

 

An player ask me he have forgot the lockbox code. I think no problem i read the CharID but there are more then 3 digits and the lockbox will get an color. Can anyone tell me the logic behind?

[FragZ]

A lockbox is a color and digits. It is normal to find a color in the code...
And for the script part I don't know sorry hahaha :P im still learning

[OtterNas3]

1. There is no build in function for getting the "Real World" time of the server, and using "time" on serverstart and count it to a known value will not work cause it will desync on heavy server load.

At the moment there is no100% good way to make a script for this.

 

2. The lockbox code is 5 chars in the db cause the colors holds 3 digits

 

Red Button = 100

Green Button = 101

Blue Button = 102

 

+ 2 digits on the Numberpad

 

Example:

10034 = Red + 34

10158 = Green + 58

10193 = Blue + 93

 

Or you can just give em the whole 5 digits and he type all of em in on the Numberpad, works also

[Pumpi]

Ok Thx for The Key i have give him his key.

 

Another question for the time. I dont need the exact  time only exact minutes. Is there an way to make an MySql "SELECT NOW() AS Time"?

[OtterNas3]

SQL query could be a idea to use, maybe you wanna have a look at these too:

http://community.bistudio.com/wiki/callExtension

http://community.bistudio.com/wiki/Extensions

http://forums.bistudio.com/showthread.php?141217-callExtension-sqf-cstdio-bindings&p=2236670#post2236670

 

This also looks interesting for you:

http://www.armaholic.com/page.php?id=16269

[Pumpi]

im on an managed server and cant install any dlls. is ther an simpel way to initial an mysql query and get the result with only sqf? i have try it a time ago but i have no luck :(