Skip to content

Instantly share code, notes, and snippets.

View james4k's full-sized avatar

Jamie james4k

31 followers · 12 following
View GitHub Profile
@james4k
james4k / gist:d3cb47ebb351eedd9559
Created June 6, 2014 19:09
linear regression on free to play category
appid | name | slope | r2 | avg
--------+--------------------------------------------+-----------------------+----------------------+--------
570 | Dota 2 | 0.46417252751648 | 0.980674018724042 | 519212
243870 | Tom Clancy's Ghost Recon Phantoms - NA | 0.0361542504321968 | 0.584950355888128 | 8628
236390 | War Thunder | 0.015647118837447 | 0.762477082379145 | 10863
230410 | Warframe | 0.0133635748592547 | 0.5327343725272 | 14372
208090 | Loadout | 0.00699989612393898 | 0.126726817543656 | 13612
222900 | Dead Island: Epidemic | 0.00668958698072217 | 0.932481282896558 | 1319
226320 | Marvel Heroes 2015 | 0.00319402248165466 | 0.400751298686258 | 4987
202090 | Magicka: Wizard Wars
@james4k
james4k / gist:4dcb8341de0965c42664
Created June 6, 2014 19:09
linear regression on early access category
appid | name | slope | r2 | avg
--------+---------------------------+-----------------------+----------------------+-------
221100 | DayZ | 0.0234480534248668 | 0.592159361502954 | 23093
222900 | Dead Island: Epidemic | 0.00668958698072217 | 0.932481282896558 | 1319
202090 | Magicka: Wizard Wars | 0.00312326077259766 | 0.399801533074936 | 1861
220200 | Kerbal Space Program | 0.00203382991389009 | 0.278723065688733 | 4107
251570 | 7 Days to Die | 0.00144547042729681 | 0.179946968554476 | 2365
233450 | Prison Architect | 0.00126280749260566 | 0.438898324878937 | 1913
244210 | Assetto Corsa | 0.00105558890829412 | 0.624335595876603 | 599
232450 | SolForge | 0.000713353800480538 | 0.286761710492122 | 985
@james4k
james4k / gist:0a187e714d0bfa1e87b1
Created June 6, 2014 19:26
peak concurrent players of free to play category, 2014 only
appid | name | peak | avgmonthlypeak
--------+--------------------------------------------+--------+----------------
570 | Dota 2 | 843024 | 753590
440 | Team Fortress 2 | 83502 | 80079
245550 | Free to Play | 37675 | 9645
208090 | Loadout | 29424 | 10696
230410 | Warframe | 26848 | 20720
236390 | War Thunder | 26228 | 16367
243870 | Tom Clancy's Ghost Recon Phantoms - NA | 21679 | 7252
238960 | Path of Exile | 19489 | 12019
@james4k
james4k / gist:5493407fb2bb48d92eff
Created June 6, 2014 19:28
peak concurrent players of action category, 2014
appid | name | peak | avgmonthlypeak
--------+-------------------------------------------------------------+--------+----------------
570 | Dota 2 | 843024 | 753590
730 | Counter-Strike: Global Offensive | 170137 | 139730
440 | Team Fortress 2 | 83502 | 80079
236430 | DARK SOULS™ II | 79528 | 40627
63380 | Sniper Elite V2 | 70123 | 12747
550 | Left 4 Dead 2 | 61325 | 25272
218620 | PAYDAY 2 | 55122 | 29751
49520 | Borderlands 2 | 47105 | 21735
@james4k
james4k / gist:81e35a355fcd3eb21db5
Created June 6, 2014 19:31
peak concurrent players of action category
appid | name | peak | avgmonthlypeak
--------+-------------------------------------------------------------+--------+----------------
570 | Dota 2 | 843024 | 445037
730 | Counter-Strike: Global Offensive | 170137 | 67985
550 | Left 4 Dead 2 | 161590 | 26382
49520 | Borderlands 2 | 123596 | 32038
440 | Team Fortress 2 | 117917 | 80091
105600 | Terraria | 97392 | 18524
211820 | Starbound | 88355 | 26514
236430 | DARK SOULS™ II | 79528 | 40627
@james4k
james4k / 2014_playerhours.sql
Last active August 29, 2015 14:16
2014 player hours, rough data
select left(g.name, 30) as name, (sum(sum) * 1.0 / sum(samples) * count(*) * 24.0)::bigint as hours
from game_players_daily gpd, games g
where gpd.appid = g.appid and date_part('year', time) = 2014
group by g.appid
order by hours desc
limit 100;
@james4k
james4k / gist:e92d4559990a0a5eefd7
Created March 19, 2015 17:25
int tmp16 = vertices->length; HX_STACK_VAR(tmp16,"tmp16");
HX_STACK_LINE(445)
Float tmp17 = (Float(tmp16) / Float((int)2)); HX_STACK_VAR(tmp17,"tmp17");
HX_STACK_LINE(445)
int tmp18 = ::Std_obj::_int(tmp17); HX_STACK_VAR(tmp18,"tmp18");
@james4k
james4k / gist:49431c4daa6a303516e0
Created July 11, 2015 00:20
diff --git a/tools/CommandLineTools.hx b/tools/CommandLineTools.hx
index 8c36f02..4512cfc 100644
--- a/tools/CommandLineTools.hx
+++ b/tools/CommandLineTools.hx
@@ -489,13 +489,17 @@ class CommandLineTools {
if (project.targetHandlers.exists (Std.string (project.target))) {
LogHelper.info ("", LogHelper.accentColor + "Using target platform: " + Std.string (project.target).to-
+
var handler = project.targetHandlers.get (Std.string (project.target));
@james4k
james4k / .diff
Created August 21, 2015 01:29
diff --git a/openfl/display/Bitmap.hx b/openfl/display/Bitmap.hx
index 94a4b32..a481bd3 100644
--- a/openfl/display/Bitmap.hx
+++ b/openfl/display/Bitmap.hx
@@ -187,8 +187,23 @@ class Bitmap extends DisplayObject {
@:noCompletion @:dox(hide) public override function __renderGL (renderSession:RenderSession):Void {-
+
+ if (scrollRect != null) {
@james4k
james4k / CairoSurface.hx
Last active September 20, 2015 20:25
package lime.graphics.cairo;
@:cppFileCode("
void lime_cairo_surface_destroy (double surface);
void lime_cairo_surface_flush (double surface);
")
abstract CairoSurface(Dynamic) from Float to Float {