Rules
FAQ
Members List
Search
Register
Login
Raised This Month: $32
Target: $400
8%
Search Forums
Show Threads
Show Posts
Advanced Search
Go to Page...
Page 1 of 2
1
2
>
Showing results 1 to 25 of 27
Search took
0.00
seconds.
Search:
Posts Made By:
theChaosCoder
Forum:
Plugins
08-28-2019, 08:00
Replies:
375
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[TF2] Overwatch
Views:
6,515
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
Bug Report
Banlist slow loading query on recent MYSQL versions
Views:
7,067
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
Sourcebans Table doesnt exist
Views:
1,155
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
Bug Report
Banlist slow loading query on recent MYSQL versions
Views:
7,067
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
Bug Report
Banlist slow loading query on recent MYSQL versions
Views:
7,067
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
Bug Report
Banlist slow loading query on recent MYSQL versions
Views:
7,067
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
Bug Report
Banlist slow loading query on recent MYSQL versions
Views:
7,067
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
Bug Report
Banlist slow loading query on recent MYSQL versions
Views:
7,067
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
Bug Report
Banlist slow loading query on recent MYSQL versions
Views:
7,067
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
Bug Report
Banlist slow loading query on recent MYSQL versions
Views:
7,067
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[ANY] Player Analytics
Views:
179,305
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
[HELP] Dedicated Server Optimization
Views:
6,871
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
Solved
[TF2]Weird Watch Dog server crash
Views:
5,550
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
User Control Panel
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
Server Discussion
Source Servers (SRCDS)
HL1 Servers (HLDS)
AMX Mod X
News
Bug Reports
General
Off-Topic
Plugins
Suggestions / Requests
Approved Plugins
New Plugin Submissions
Unapproved/Old Plugins
Translation Request
High-Traffic Plugins
GunGame
UAIO (Ultimate All-In-One Plugin)
xREDIRECT
CSDM
AMX Super
RuneMod
Zombie Plague Mod
SuperHero Mod
News
Tech Support
Scripting Help
Off-Topic / General Chat
Heroes
Suggestions / Requests
Approved Heroes
New Submissions
Unapproved/Old Heroes
Module Heroes
SuperHero Mod Stats - By 123
(OLD) Bug Reports
Scripting
Scripting Help
Code Snippets/Tutorials
Module Coding
Donor Access
SourceMod
News
General
Plugins
Plugins
Unapproved Plugins
Plugin/Gameplay Ideas and Requests
High-Traffic Plugins
SourceMod Anti-Cheat
Zombie:Reloaded
SourceBans / SourceBans++
VSH / Freak Fortress
Store
SM_Hosties
HLstatsX:CE
Scripting
Extensions
Snippets and Tutorials
Donor Access
Metamod: Source
Metamod:Source Plugins
Metamod:Source Questions
Coding MM:S Plugins & SM Extensions
Hosted Stuff
Asherkin's Plugins
TFDodgeball
TF2Items
SteamTools
Bail's Plugins
CSDM
CS:S DM
Off-Topic & Trash
Off-Topic
Trash
All times are GMT -4. The time now is
07:22
.
DMCA
-
Archive
-
Top
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode