[RELEASE] Server time in game.

[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

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:

[Eurion]

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.

[hio77]

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

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!

[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.

[hio77]

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!

[magewarior2]

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.

[rowdy2014]

know how to change this ingame notice? check my attachment

[magewarior2]

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.

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

[rowdy2014]

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

[iman31]

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

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:

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!

[magewarior2]

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!