[RELEASE] Server time in game.

08/31/2014 22:13 magewarior2#1

Since there is no easy command to know what server time it is
i made a script, that shows what time it is on the server
(only the 00:00, :15, :30, :45) if needed to add every minute, we need like 1200 rows...

this one already has 217 rows..

id it starts 70 000

id it ends 70 216

example of code used

Spoiler

extern download link:
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

08/31/2014 22:51 Eurion#2

There are far easier ways then adding 1200 lines to your database. They can easily just edit their GUI.ini and create a page that contains a clock from any of the free clock sites out there. That way they have an actual server time.

09/01/2014 05:42 hio77#3

Gezz to think im simply doing a simple statement in my login handling....

Code:

DateTime.Now.ToString("h:mm:ss tt")

as for the GUI clock idea... no eurion! dont go suggesting that!

We will end up with servers with media players spammed on the screen or something!

09/01/2014 12:32 Eurion#4

There are servers like that already lol, I was only saying on of the many ways to get it done besides adding more entries to the database.

09/01/2014 13:30 hio77#5

Quote:

Originally Posted by Eurion

There are servers like that already lol, I was only saying on of the many ways to get it done besides adding more entries to the database.

oh no! what is this world coming to!

09/01/2014 17:24 magewarior2#6

it seems that if we display the time (when you click play.exe) and on the site aint enough for some players ... thats why i added it into the game.

09/18/2014 15:07 rowdy2014#7

know how to change this ingame notice? check my attachment

09/18/2014 15:47 magewarior2#8

Quote:

Originally Posted by rowdy2014

know how to change this ingame notice? check my attachment

Yes and no.

from here i cannot say what ID it is, to remove it..

but i can help you.
your problem is able to find in cq_action.

press CTRL+F and
retype the first message, and you will find the good id, i guess.

Code:

try to find
1.Knight round table has been fixed.
or 
1.Knigh~round~table~has~been~fixed.

09/19/2014 06:10 rowdy2014#9

thanks , but i cant find those words at cq_action table . .

12/30/2025 05:56 iman31#10

Quote:
Originally Posted by magewarior2
Since there is no easy command to know what server time it is
i made a script, that shows what time it is on the server
(only the 00:00, :15, :30, :45) if needed to add every minute, we need like 1200 rows...

this one already has 217 rows..

id it starts 70 000

id it ends 70 216

example of code used
Spoiler
Code:
INSERT INTO `cq_action` VALUES ('70209', '70213', '70210', '0123', '5', '00 14');
INSERT INTO `cq_action` VALUES ('70210', '70214', '70211', '0123', '5', '15 29');
INSERT INTO `cq_action` VALUES ('70211', '70215', '70212', '0123', '5', '30 44');
INSERT INTO `cq_action` VALUES ('70212', '70216', '0000', '0123', '5', '45 59');
INSERT INTO `cq_action` VALUES ('70213', '0000', '0000', '1010', '2007', 'Current servertime: 23:00');
INSERT INTO `cq_action` VALUES ('70214', '0000', '0000', '1010', '2007', 'Current servertime: 23:15');
INSERT INTO `cq_action` VALUES ('70215', '0000', '0000', '1010', '2007', 'Current servertime: 23:30');
INSERT INTO `cq_action` VALUES ('70216', '0000', '0000', '1010', '2007', 'Current servertime: 23:45');
you can add this to your login codes (start from 1000000) to see each time you log in, what time it is.

or bind it to an item, do whatever you think is best for it.
extern download link:
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

Just finished building a time-by-minute feature took quite a bit of time and effort, but totally worth it! Ended up writing over 3,000 lines of code to get everything working smoothly. Learned a ton along the way and really proud of how it turned out. Huge thanks for sharing the base script it really helped kickstart the whole process!

12/30/2025 14:16 magewarior2#11

Quote:

Originally Posted by iman31

Just finished building a time-by-minute feature took quite a bit of time and effort, but totally worth it! Ended up writing over 3,000 lines of code to get everything working smoothly. Learned a ton along the way and really proud of how it turned out. Huge thanks for sharing the base script it really helped kickstart the whole process!

I am glad that script has been able to kickstart you!