Raised This Month: $32 Target: $400
 8% 

Page 1 of 2 1 2
Showing results 1 to 25 of 27
Search took 0.02 seconds. Search: Posts Made By: theChaosCoder
Forum: Plugins 08-28-2019, 08:00
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

Hackmastr added Steam loginid support for the analytics web gui https://github.com/theChaosCoder/player_analytics/pull/26
That means you can give permission per steamid now and "protect" your...
Forum: Plugins 05-24-2019, 04:58
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

This is the error your page is showing. Set a valid timezone in your server/php.ini and the warning should disappear. (just google this error ;-))

<b>Warning</b>: date(): It is not safe to rely...
Forum: General 11-27-2016, 13:23
Replies: 11
Views: 6,518
Posted By theChaosCoder
Re: [TF2] Overwatch

I wonder how characters like D.Va can be implemented in tf2.
And soldiers Ultimate Ability => instant ban lol

Do you plan to make it as close a possible to the Overwatch gameplay/mechanics?
Forum: SourceBans / SourceBans++ 11-09-2016, 08:09
Replies: 21
Views: 7,068
Posted By theChaosCoder
Re: Banlist slow loading query on recent MYSQL versions

The index is just a lookup table for a field (or multiple fields). You can name it like you want. It's not really important for our case. If you query like Select .... where auth = "abc" then mysql...
Forum: SourceBans / SourceBans++ 11-07-2016, 18:40
Replies: 1
Views: 1,156
Posted By theChaosCoder
Re: Sourcebans Table doesnt exist

Have you checked if the tabe 'restinsp_sourcebans.sourceban_bans' exists?
Have your user the permission to create a table?
Forum: SourceBans / SourceBans++ 11-06-2016, 17:32
Replies: 21
Views: 7,068
Posted By theChaosCoder
Re: Banlist slow loading query on recent MYSQL versions

Nice, glad you fixed it!
So you basically exported your tables, then truncated all (or deleted the whole db) and imported it back again?

In pma one can copy a DB to another DB and then just...
Forum: SourceBans / SourceBans++ 11-06-2016, 12:55
Replies: 21
Views: 7,068
Posted By theChaosCoder
Re: Banlist slow loading query on recent MYSQL versions

Same as mine...

The strange thing is: Your query doesn't use the index for SE. And I think because of that a temp table is also created and that's the reason it is so slow...

...
Forum: SourceBans / SourceBans++ 11-06-2016, 12:35
Replies: 21
Views: 7,068
Posted By theChaosCoder
Re: Banlist slow loading query on recent MYSQL versions

And what about sb_servers? Can you show that too. just the index.
Forum: SourceBans / SourceBans++ 11-06-2016, 06:49
Replies: 21
Views: 7,068
Posted By theChaosCoder
Re: Banlist slow loading query on recent MYSQL versions

ok, could you now also post the output of "Data dictionary" (Click on your Sourcebans DB in phpmyadmin. Look at the bottom near Print).
Maybe save it (print) as pdf :-)
Forum: SourceBans / SourceBans++ 11-05-2016, 08:14
Replies: 21
Views: 7,068
Posted By theChaosCoder
Re: Banlist slow loading query on recent MYSQL versions

Can you run this query:

explain SELECT bid ban_id, BA.type, BA.ip ban_ip, BA.authid, BA.name player_name, created ban_created, ends ban_ends, length ban_length, reason ban_reason, BA.ureason...
Forum: SourceBans / SourceBans++ 10-29-2016, 06:22
Replies: 21
Views: 7,068
Posted By theChaosCoder
Re: Banlist slow loading query on recent MYSQL versions

A cache would be indeed great.

So tested the whole query now and even added 45k more rows to sb_bans and its still very fast 0.1 sec.

my query (with a test bans table sb_bans2):
SELECT bid...
Forum: SourceBans / SourceBans++ 10-28-2016, 17:41
Replies: 21
Views: 7,068
Posted By theChaosCoder
Re: Banlist slow loading query on recent MYSQL versions

Which mysql version are you using?

I tested it on my server and it's super fast 0.001 sec for ~3400 rows (bans). I'm using MariaDB 10.1.14 (Table type InnoDB)

Your "optimized" query is...
Forum: Plugins 08-25-2016, 04:29
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

@Dr. McKay
Is it possible to add the duration to the error log too, so I have a chance to update it myself?

L 08/22/2016 - 09:36:16: [player_analytics.smx] Unable to update row 706364. Can't...
Forum: Plugins 08-24-2016, 18:09
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

Update to latest version. The "Servers selection" is now at the top. (the image shows an older version on github). Also try a "forced reload" (STRG+F5) if something looks weird.
Forum: Plugins 08-18-2016, 07:57
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

I made some bigger updates again to the webpanel. Added mutli server select, date selection is now globally available. And nearly every sql query uses a connect_date range now, so the performance...
Forum: Plugins 08-11-2016, 19:18
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

What happens if you open http://yourdomain/player_analytics/inc/getplayers.php in your browser? (change domain and path)
Based on your information: You have a permission issue or did not upload all...
Forum: Plugins 08-10-2016, 20:23
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

Could be a php timeout. Try the newest version. load time should be a bit faster now (But not the search!)
Forum: Plugins 08-08-2016, 17:33
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

I think the easiest way would be a SELECT INTO Statement.
http://www.w3schools.com/sql/sql_select_into.asp

INSERT INTO player_analytics_table1 (`server_ip`, `name`, `auth`, `connect_time`,...
Forum: Plugins 08-08-2016, 07:26
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

Maybe it was the dev branch from Sinclair47's player_analytics...

I made a fork and merged both branches + made some fixes. Feel free to test it and report back....
Forum: Plugins 02-23-2016, 09:37
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

I found a cool Timeline js lib for player analytics - http://visjs.org/

Don't know if it is very usefull yet ... but this is how it could look like:
http://i.imgur.com/KXHxBDZ.gif

If someone...
Forum: Plugins 02-09-2016, 07:57
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

My guess is that it could be a webhost configuration problem. I don't know how to help you...

You could try this

Open your "inc/server_processing.php" file and change the lines to: ( put # in...
Forum: Plugins 02-08-2016, 19:15
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

I compared some js files with my installation and some of your files (like dataTables.bootstrap.js and jquery-1.11.0.js) seems to be minified. Maybe this is the problem.

Did you "optimize" the...
Forum: Plugins 02-08-2016, 12:30
Replies: 375
Views: 179,357
Posted By theChaosCoder
Re: [ANY] Player Analytics

So I made a little experiment today which I find funny:

You all know hlstatsx right, and the Player-Graph it generates... I took the graph-generating part of it and made some changes to the...
Forum: Source Servers (SRCDS) 02-05-2016, 07:49
Replies: 16
Views: 6,872
Posted By theChaosCoder
Re: [HELP] Dedicated Server Optimization

If you want to run many instances you could install a newer kernel (with some optimizations) to squeeze out some extra %.
And yeah go for ssd if possible. U can also use a "master" csgo...
Forum: General 01-31-2016, 11:28
Replies: 23
Views: 5,553
Posted By theChaosCoder
Re: [TF2]Weird Watch Dog server crash

Hi, I also get many "Host_Error: WatchdogHandler called - server exiting." errors and I can't figure out why. I'm using the same plugins and configs on another (dedicated) server -> no problems...
Showing results 1 to 25 of 27
Page 1 of 2 1 2

 
Forum Jump

All times are GMT -4. The time now is 19:56.

DMCA - Archive - Top

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode