[peter27]

L 12/28/2018 - 00:06:11: [SM] [1] Line 171, C:\Users\Pat\Documents\Work\aMity\PawnStudio\ adminwatch.sp::OnPluginStart
L 12/28/2018 - 004:41: [adminwatch.smx] Unable to connect to the database. Error: Configuration "adminwatch" not found
L 12/28/2018 - 004:41: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 12/28/2018 - 004:41: [SM] Blaming: adminwatch.smx
L 12/28/2018 - 004:41: [SM] Call stack trace:
L 12/28/2018 - 004:41: [SM] [0] SQL_TQuery
L 12/28/2018 - 004:41: [SM] [1] Line 171, C:\Users\Pat\Documents\Work\aMity\PawnStudio\ adminwatch.sp::OnPluginStart


and yes i have installed it right with adminwatch in the database

[Sarin]

does it list each admin? There are 2 in database so far..... but.


EDIT: does it show the stats of each admin?

[Sarin]

Also,

Get this error

[06-Jan-2019 19:05:29 Australia/Sydney] PHP Notice: Undefined variable: PRECISION in /home/*****/public_html/adminwatch/index.php on line 21

in index.php
if ($PRECISION == 0)

[Sarin]

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 For setup, just follow the first post in this topic __________________________________________ Web Settings I have added a few settings in the top of the index.php to make it alittle easier for you guys PHP Code: $backgroundurl = ""; // Change the background image $backgroundcolor = "white"; // Change the background color, using color name (yellow), hex (#00ff00) or rbg (rgb(255,0,255)) $adjusttimedate = "+2 hours"; // Adjust the time/date for Last Played and Commands logs -1 hours, +2 hours, +6 hours, +1 day, +2 days, and so on $steamprofile = "2"; // If 1 steam profile is linked in the name if 2 steam profile is linked under the name as (View Steam Profile)  ___________________________ Updates 6th July 2016: Web version 1.2 Added clickable link to the admins steam profile in the name Fixed possible issue with Last played date not sorting correctly Added so you can set a custom background (see line 2 and 3 in index.php) Changed so the whole site layout is more "solid" if using a custom background Added a settings section in the index.php

YES!!!! That has fixed the issue where it was only showing 1 admin and no time spent. GREAT WORK. THANK YOU!!!!

[Sarin]

L 02/12/2019 - 06:480: [SM] Exception reported: Data too long for column 'hostname' at row 1
L 02/12/2019 - 06:480: [SM] Blaming: adminwatch.smx
L 02/12/2019 - 06:480: [SM] Call stack trace:
L 02/12/2019 - 06:480: [SM] [0] SetFailState
L 02/12/2019 - 06:480: [SM] [1] Line 422, C:\Users\Pat\Documents\Work\aMity\PawnStudio\ adminwatch.sp:BNoAction
L 02/12/2019 - 06:482: Error log file session closed.

[deadflush]

Originally Posted by Sarin L 02/12/2019 - 06:480: [SM] Exception reported: Data too long for column 'hostname' at row 1 L 02/12/2019 - 06:480: [SM] Blaming: adminwatch.smx L 02/12/2019 - 06:480: [SM] Call stack trace: L 02/12/2019 - 06:480: [SM] [0] SetFailState L 02/12/2019 - 06:480: [SM] [1] Line 422, C:\Users\Pat\Documents\Work\aMity\PawnStudio\ adminwatch.sp:BNoAction L 02/12/2019 - 06:482: Error log file session closed.

Its telling you your host name is to long for the database fix below


Go to
phpmyadmin

then
adminwatch database

then
Click Structure under adminwatch_logs

then change hostname char here
2 hostname varchar(50) latin1_swedish_ci No None

up it to 80

2 hostname varchar(80) latin1_swedish_ci No None


Hope you understand

[Sarin]

Originally Posted by deadflush Its telling you your host name is to long for the database fix below Go to phpmyadmin then adminwatch database then Click Structure under adminwatch_logs then change hostname char here 2 hostname varchar(50) latin1_swedish_ci No None up it to 80 2 hostname varchar(80) latin1_swedish_ci No None Hope you understand

you are a legend!!!!!!!!!!

Thanks heaps. got it. Great instructions!

[TrappaTroopa]

Can someone help me fix the connect function?

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /var/www/html/forum/adminwatch/includes/database.include.php:25 
Stack trace: #0 /var/www/html/forum/adminwatch/includes/database.include.php(37): Database->connect() #1 /var/www/html/forum/adminwatch/index.php(28): 
Database->query('SELECT * FROM `...') #2 {main} thrown in /var/www/html/forum/adminwatch/includes/database.include.php on line 25

[deadflush]

Originally Posted by TrappaTroopa Can someone help me fix the connect function? Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /var/www/html/forum/adminwatch/includes/database.include.php:25 Stack trace: #0 /var/www/html/forum/adminwatch/includes/database.include.php(37): Database->connect() #1 /var/www/html/forum/adminwatch/index.php(28): Database->query('SELECT * FROM `...') #2 {main} thrown in /var/www/html/forum/adminwatch/includes/database.include.php on line 25

Seems you may not have your database login info correct?

Mine works just fine and i don't get this error.

Check these are right.

	var $Host     = "";        // Hostname of our MySQL server.
	var $Database = "";         		// Logical database name on that server.
	var $User     = "";             	// User and Password for login.
	var $Password = "";

[alphaearth]

L 05/25/2019 - 14:51:54: SourceMod error session started
L 05/25/2019 - 14:51:54: Info (map "de_dust2") (file "errors_20190525.log")
L 05/25/2019 - 14:51:54: [adminwatch.smx] Unable to connect to the database. Error: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 113
L 05/25/2019 - 14:51:54: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 05/25/2019 - 14:51:54: [SM] Blaming: adminwatch.smx
L 05/25/2019 - 14:51:54: [SM] Call stack trace:
L 05/25/2019 - 14:51:54: [SM] [0] SQL_TQuery
L 05/25/2019 - 14:51:54: [SM] [1] Line 162, /home/forums/content/files/4/0/1/7/5/145346.attach::OnPluginStart
L 05/25/2019 - 14:51:54: [SM] Unable to load plugin "adminwatch.smx": Error detected in plugin startup (see error logs)