[braak0327]

i already have name "users"(store plugins) table this is hosting server so I can't make another DB for me what should I do for this situation?

[jpwanabe]

You should try typing that again in an understandable way this time. I would love to help, but I don't know what you asked.

[braak0327]

Originally Posted by jpwanabe You should try typing that again in an understandable way this time. I would love to help, but I don't know what you asked.

sorry for my poor english skill

I mean my DB already have name called "users" table

and this plugins web analytics page need import servers.sql, users.sql

in users.sql

CREATE TABLE IF NOT EXISTS `users` (
`username` varchar(30) NOT NULL,
`password` varchar(32) DEFAULT NULL,
`userid` varchar(32) DEFAULT NULL,
`userlevel` tinyint(1) unsigned NOT NULL,
`email` varchar(50) DEFAULT NULL,
`timestamp` int(11) unsigned NOT NULL,
`valid` tinyint(1) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) DEFAULT NULL,
`hash` varchar(32) NOT NULL,
`hash_generated` int(11) NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

already have table name users so I can't import this sql file

now can you understand what is my problem?

[Pickles47]

I have redone the web panel and it is available at https://github.com/Sinclair47/player_analytics

DEMO HERE

The demo has semi-random data.

This should be much faster, requires less setup, and should improve performance on large databases.

I have removed user login, if you want to limit access you can whitelist IPs or add your own authentication.

I have also removed quite a bit of clutter, things such as maps and individual server pages and server details have been removed in favor of a leaner experience and cleaner look. You can still compare activity by the day/hour by clicking on date on the graph. Clicking on a country on the map will bring up that regions connections.

Server Names can be added in the config, examples are given. SteamAPI key is required to pull user data from valve. Edit inc/config.php to add your database information, key, and server names.

[Dr. McKay]

Originally Posted by Pickles47 I have redone the web panel and it is available at https://github.com/Sinclair47/player_analytics DEMO HERE The demo has semi-random data. This should be much faster, requires less setup, and should improve performance on large databases. I have removed user login, if you want to limit access you can whitelist IPs or add your own authentication. I have also removed quite a bit of clutter, things such as maps and individual server pages and server details have been removed in favor of a leaner experience and cleaner look. You can still compare activity by the day/hour by clicking on date on the graph. Clicking on a country on the map will bring up that regions connections. Server Names can be added in the config, examples are given. SteamAPI key is required to pull user data from valve. Edit inc/config.php to add your database information, key, and server names.

Very nice!

[RocketFish]

Originally Posted by Pickles47 I have redone the web panel and it is available at https://github.com/Sinclair47/player_analytics DEMO HERE

Nice work. Thank you

[DrFallen]

Looks nice but what are these two columns for?

http://cdn.kinevonetwork.com/public/...7140719177.png

[pcmaster]

Some indexes would be nice, even loading the session page causes by webserver to use 100% cpu and then die after 30 seconds.
Currently got ~2.2M connection records.

[Pickles47]

Originally Posted by DrFallen Looks nice but what are these two columns for? http://cdn.kinevonetwork.com/public/...7140719177.png

Premium or F2P and HTML MOTD Enabled/Disabled. They can be changed in getconnections.php.

Originally Posted by pcmaster Some indexes would be nice, even loading the session page causes by webserver to use 100% cpu and then die after 30 seconds. Currently got ~2.2M connection records.

Its easy enough to make them, index on connect_time, connect_date, country_code, and auth would definitely help at the expense of hdd space, probably around 200-220mb for the indexes alone with 2.2m rows.

[nomy]

Hello Pickles,

I have a suggestion. Please make it possible to search by IPs.
Thanks!