[Wolfseye]

Thanks @Pickles47.

Error is gone now.

One other question. There is one thing in that Webpanel called "$ User Status" but there is nothing else below it. Is that function not working or why is it empty or the list below it ?

Cheers

Also, I tried to add a new User as Admin. Got this...

Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in /www/htdocs/w00f6b94/insanalytics/include/database.php on line 156

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w00f6b94/insanalytics/include/database.php:156) in /www/htdocs/w00f6b94/insanalytics/include/process.php on line 113

The user got added, but I still got this error.

[Wolfseye]

I suppose thats only happening when there is maybe a short interruption between the Gameserver and the Webspace with the MySQL, right ?

L 06/08/2014 - 11:14:09: Info (map "sinjar_coop") (file "errors_20140608.log")
L 06/08/2014 - 11:14:09: [player_analytics.smx] Unable to update row 23. Lost connection to MySQL server during query
L 06/08/2014 - 11:28:59: Error log file session closed.
L 06/08/2014 - 11:29:03: SourceMod error session started
L 06/08/2014 - 11:29:03: Info (map "sinjar_coop") (file "errors_20140608.log")
L 06/08/2014 - 11:29:03: [player_analytics.smx] Unable to update row 26. Lost connection to MySQL server during query
L 06/08/2014 - 11:40:41: Error log file session closed.
L 06/08/2014 - 12:06:09: SourceMod error session started
L 06/08/2014 - 12:06:09: Info (map "sinjar_coop") (file "errors_20140608.log")
L 06/08/2014 - 12:06:09: [player_analytics.smx] Unable to update row 34. Lost connection to MySQL server during query

[lyric]

Originally Posted by Pickles47 Here is an update. SQL scripts in sql folder, you should delete them after you add them to your database. Added: Login system, login as admin with password Server management now down through servers page. You can only add/modify/delete server details if server exists in player_analytics database. Only a problem if your database is empty. Added maps page. No map images are included to keep the file size small. Add maps to images/maps directory. Filename should = map name ie. ctf_2fort.jpg. Changed CSS, you can easily change colors from player_analytics.css Can now search players by steamid. Install: You will need to execute the sql scripts in the install directory to add the appropriate tables to database. Config.php has been moved to includes folder, you will need to add your database details there. Once you login you can add new users(1) or admins(9). Admins can edit server details and users. Users can only view pages. Demo here User:admin Pass:password Separate attachment for TF2 maps images. *I believe I squashed most bugs, though you may encounter some. **Fixed vulnerabilities and minor css issues. ***Fixed issue with adding server in Google Chrome. Attached new servers.php page. New, minor update https://forums.alliedmods.net/showpo...&postcount=112

i use an alphanumeric password because i dont like 'password' as being for admin yet I get error:

"* New Password not alphanumeric"

why?

[lyric]

is there just a way to let people view stats without it requiring someone to login??? i can see needing to login for admin but not to simply view stats. it used to be liek this in old version of website but some reason you opted to require it for just viewing stats

[kirahaku]

So i've installed the latest webpanel and got it to connect to my database and eevrything but when I go to login to the webpanel I get * Username not found error... Used admin and password and anything else I could possibly think of, nothing work, I looked at my database and it has the Servers collumn with the tables but I dont see any other ones, I imported the two sql files from the sql.zip as well..

[Snaggle]

Originally Posted by kirahaku So i've installed the latest webpanel and got it to connect to my database and eevrything but when I go to login to the webpanel I get * Username not found error... Used admin and password and anything else I could possibly think of, nothing work, I looked at my database and it has the Servers collumn with the tables but I dont see any other ones, I imported the two sql files from the sql.zip as well..

There should be a "Users" table as well.

[kirahaku]

Originally Posted by Snaggle There should be a "Users" table as well.

Indeed there should be, but I looked for one and there is not, How to fix this??

This is all my database has in it:


don't know why its not there nor how to add, using PhPMyAdmin ?

[Snaggle]

Originally Posted by kirahaku Indeed there should be, but I looked for one and there is not, How to fix this?? This is all my database has in it: don't know why its not there nor how to add, using PhPMyAdmin ?

I found it on Github, you'll need to import the users.sql file.
https://github.com/Sinclair47/connec...ree/master/sql

[kirahaku]

Originally Posted by Snaggle I found it on Github, you'll need to import the users.sql file. https://github.com/Sinclair47/connec...ree/master/sql

Tried to import and got this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<!DOCTYPE html>
<html class="   ">
  <head prefix="og: http://ogp.me/ns# fb: htt' at line 1

And I checked my FTP files and in the sql folder theres both servers.sql and users.sql already....

Edit: Figured out how to manually write the table, and was able to login, but now it just has a blank page with "Player Analytics" link at the top..

[braak0327]

chat logging?