[ANY] adminWatch (v1.2.2) - Page 13

MFS · 08-17-2015 , 17:55 Re: [ANY] adminWatch (v1.2.2)

Track players' play times in SQL
https://forums.alliedmods.net/showthread.php?p=2299877

September · 08-29-2015 , 10:57 Re: [ANY] adminWatch (v1.2.2)

Help me please

L 08/29/2015 - 18:46:41: [adminwatch.smx] [adminWatch] - Unable to update admin times.

Krotis · 09-01-2015 , 16:17 Re: [ANY] adminWatch (v1.2.2)

Quote:

Originally Posted by DoPe^

alright as promised here is the fixed version.
I made a few changes in it.

It also saves the time on round end now and not only when a admin disconnects.
I have changed so the played timer dosnt stop on round end since you are still "playing".

I have also made some changes to the web part.
The real idle(spec) time is shown now, played time is shown as before and I have added a total time which is idle + played.
I have also made so you can sort your admins by name, total time played, played time, idle time and last played.

You can see what the page looks like here http://www.clanroyal.dk/adminwatch/index.php
If the last played time is off by a few hours or the command logs go to line 30 and 152 in index.php where it says

PHP Code:


			
$date->modify("+2 hours");

and change +2 hours to what you need.

etc.

PHP Code:


			
$date->modify("+6 hours");



$date->modify("+1 day");



$date->modify("+2 days");

and so on

For setup, just follow the first ppst in this topic

Yo looks amazing, could you realese it again but it automatic ressets every week? that would be awesome

Sketchy · *Last edited by Sketchy; 01-26-2016 at 08:54.*

edit: web version that DoPe^ posted fixed my web issues. Thanx DoPe^!
Only thing this plugin could really use now would be multi-server support, and the ability to track/filter users based on multiple adminflags. For example, Members with some flag, & Admins with some other flag.

iGANGNAM · 04-30-2016 , 08:04 Re: [ANY] adminWatch (v1.2.2)

L 04/30/2016 - 09:19:10: [SM] Native "SetFailState" reported: Incorrect string value: '\xD0\xAFap [...' for column 'name' at row 1
L 04/30/2016 - 09:19:10: [SM] Displaying call stack trace for plugin "adminwatch/adminwatch.smx":

ffriozi · *Last edited by ffriozi; 05-17-2016 at 13:06.*

Im having this problem can anyone help?

FIXED, i changed to CPANEL..

this script its not compatible with xampp

Danii · *Last edited by Danii; 07-05-2016 at 11:17.*

L 07/05/2016 - 14:49:53: [adminwatch.smx] [adminWatch] - Unable to connect to the database.

The IP, db and password are ok.

-------------------------------

16:13:10 [adminwatch.smx] Unable to connect to the database. Error: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
16:13:10 [adminwatch.smx] [adminWatch] - Unable to connect to the database.
16:13:10 [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
16:13:10 [SM] Displaying call stack trace for plugin "adminwatch.smx":
16:13:10 [SM] [0] Line 162, /home/forums/content/files/4/0/1/7/5/145346.attach::OnPluginStart()
16:13:10 [SM] Loaded plugin adminwatch.smx successfully.

------------------------------------

Database error: Invalid SQL: SELECT * FROM `adminwatch`MySQL Error: 1146 (Table 'testdb.adminwatch' doesn't exist)Session halted.

Kurtan · 07-05-2016 , 12:50 Re: [ANY] adminWatch (v1.2.2)

Make sure that the database you created in MySQL match the one you put in databases.cfg.

Danii · 07-05-2016 , 15:12 Re: [ANY] adminWatch (v1.2.2)

Yes. I am sure. Now i only got this ...

Database error: Invalid SQL: SELECT * FROM `adminwatch`MySQL Error: 1146 (Table 'stats_csgo.adminwatch' doesn't exist)Session halted.

DoPe^ · *Last edited by DoPe^; 07-05-2016 at 22:26.*

Web part updated to v1.2

https://forums.alliedmods.net/showpo...&postcount=112