Archive for September, 2009

total mysql rows

Turns out our Mysql server at work is a little bigger than I thought: Databases 75 Tables    1,549 Rows      1,018,085,348 However over the last couple of months, we’ve only averaged 130 queries/second Hacked up PHP to gather stats: class MysqlCounter {     public function __construct($host, $username, $password)     {   [...]

Posted by Matthew on September 9th, 2009

Filed under mysql, php, programming | No Comments »

No One Likes a Tattletale

DesuToys

Posted by Matthew on September 5th, 2009

Filed under random | 1 Comment »

WoW Combat Log Splitter

Something quick I whipped up last night, after noticing that after my log file was > 4GB the WorldOfLogs parser will no longer do real time logging. Edit: Turns out that the WoW client itself stopped logging, even though the log file was a little over expected limit (4,334,806,196 bytes) Note: The code is just [...]

Posted by Matthew on September 4th, 2009

Filed under games, programming, python | 2 Comments »

hacked

Yep, I was hacked 5 days ago. Seems I’ve been part of some DOS attack (I forgot to record the IPs of who, and it was only ~60GB of traffic). From what I can tell, it exploited an (old, now patched) hole in PHPMyAdmin that let you write PHP files with what ever content you [...]

Posted by Matthew on September 1st, 2009

Filed under Uncategorized | 3 Comments »