UPDATED V2
I made an update on both versions, what was changed in each of them will be explained below:
File Version
-
Added some comments to the script for better understanding.
-
The trigger names are now starting with the resource name. @Hawaii_Beach
-
Best way to get the player time, now is stored in tables.
Download: onlinetime_file_V2.rar (2.9 KB) | onlinetime_file_V2.zip (3.6 KB)
SQL Version
-
Added some comments to the script for better understanding.
-
The trigger names are now starting with the resource name. @Hawaii_Beach
-
Best way to get the player time, nwow is stored in tables.
-
The time saving way was changed, instead of saving every second, which exceeded the connection limit of mysql, time is saved when player disconects and every 30 seconds by default, which can be changed in the file " config.lua ".
WARNING: Do not write a very low value to save the data as it can exceed the connection limit of MYSql! -
The mysql columns and the mysql table are now in English instead of Portuguese. Those who use the first version and want to update it will have to change the names of the tables and columns according to the new ones! @Hawaii_Beach
Download: onlinetime_sql_V2.rar (3.3 KB) | onlinetime_sql_V2.zip (3.9 KB)
Detailed Suport:
Thanks:
For reporting: @Skrubby
For opinions: @SaltyGrandpa @Hawaii_Beach