Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/jovianskye/jovianskye.com/textpattern/lib/txplib_db.php on line 14

Warning: Cannot modify header information - headers already sent by (output started at /home/jovianskye/jovianskye.com/textpattern/lib/txplib_db.php:14) in /home/jovianskye/jovianskye.com/textpattern/lib/txplib_misc.php on line 1240

Warning: Cannot modify header information - headers already sent by (output started at /home/jovianskye/jovianskye.com/textpattern/lib/txplib_db.php:14) in /home/jovianskye/jovianskye.com/textpattern/publish/rss.php on line 125

Warning: Cannot modify header information - headers already sent by (output started at /home/jovianskye/jovianskye.com/textpattern/lib/txplib_db.php:14) in /home/jovianskye/jovianskye.com/textpattern/publish/rss.php on line 133

Warning: Cannot modify header information - headers already sent by (output started at /home/jovianskye/jovianskye.com/textpattern/lib/txplib_db.php:14) in /home/jovianskye/jovianskye.com/textpattern/publish/rss.php on line 194

Warning: Cannot modify header information - headers already sent by (output started at /home/jovianskye/jovianskye.com/textpattern/lib/txplib_db.php:14) in /home/jovianskye/jovianskye.com/textpattern/publish/rss.php on line 195
the Jovian Skye http://www.jovianskye.com/ jsTimeMachine - Web Based "Time Machine" Interface <p>Ok it’s very beta, but well it sort of works ;-) – no really, it does</p> <p><a href="http://www.jovianskye.com/jsTimeMachineTable/jstimemachine.html"><img src="/images/8.jpg" title="jsTimeMachine" alt="jsTimeMachine" /></a></p> <p>So the story goes, Kris one of my workmates is working on an (web based) application were he needed to show 2D data over time & being such a Mac <del>Fan Boy</del> Enthusiast that he is, he thought why not have some sort of 3 dimensional transition of the data off into infinity ???</p> <p>And the rest as they say is history. I’ve made a nice pretty background, got some sort of preview going & tidied up the interface a bit & posted it here (cause Kris has no blog, not that i look after mine all that well :<del>P)</p> <p>We’d only consider this a 0.5b release (yeah very beta). Kris has yet to work on the scaling of the contents of the panels, so if the content of the panels as they zoom towards you are % based they are fine (except text), but if it’s an image in there (as you’ll see in the demo) then no scaling occurs :</del>(</p> <p>Demo One – <a href="http://www.jovianskye.com/jsTimeMachineTable/jstimemachine.html">jsTimeMachineTable [Table based]</a></p> <p>Demo Two – <a href="http://www.jovianskye.com/jsTimeMachinePix/jstimemachine.html">jsTimeMachinePix [Picture Gallery]</a></p> <p>Downloads: </p> <ul> <li><a href="http://www.jovianskye.com/jsTimeMachineTable.zip">jsTimeMachineTable.zip</a> (92KB)</li> <li><a href="http://www.jovianskye.com/jsTimeMachinePix.zip">jsTimeMachinePix.zip</a> (800KB)</li> </ul> http://www.jovianskye.com/archive/jstimemachine-web-based-time-machine-interface Seriously Kewl Eye Candy <p>So do you really want to know what your sites code really looks like? Well some cleaver dickie Aharef has made something to show you what your (X)HTML code actually looks like.</p> http://www.jovianskye.com/archive/seriously-kewl-eye-candy Hacking Sphider to Weigh the Heading Tags <p>These are the instructions on how to add heading weightings (the h1 to h6 tags found in web pages, just like Google does) to the <a href="http://www.cs.ioc.ee/~ando/sphider/">Sphider Search Engine</a> .</p> http://www.jovianskye.com/archive/hacking-sphider-to-weigh-the-heading-tags MySQL Log Rotation with PHP <p>If you want to rotate your MySQL log files (i.e. you have enabled the ”—log-bin” option in the command line or used MySQL Administrator to enable Binary Log Files) via PHP, here a little script to enable you to do it.</p> <p>Using the PEAR DB libraries, here’s how you would do it:</p> <code><br /> //---- this is the time of the last log file that will be kept<br /> $purgeTime['hour'] = 23;<br /> $purgeTime['minute'] = 59;<br /> $purgeTime['second'] = 50;<br /> </code> <code><br /> //---- date adjustment for the purging of the log files, <br /> //---- in this case it is set to 2 because I want to keep<br /> //---- 24 hours worth & my purge will take place after<br /> //---- midnight<br /> $purgeDateAdjustment['days'] = 2;<br /> $purgeDateAdjustment['months'] = 0;<br /> $purgeDateAdjustment['years'] = 0;<br /> </code> <code><br /> //---- includes PEAR DB classes<br /> require_once("DB.php");<br /> //---- includes the DB parameters<br /> require_once("config/admin_db-prams.php"); <br /> </code> <code><br /> if (DB::isError($db)) { die($db->getMessage());<br /> }<br /> </code> <code><br /> $purgeEvent = date("Y-m-d H:i:s",mktime($purgeTime['hour'], $purgeTime['minute'], $purgeTime['second'], date("m")-$purgeDateAdjustment['months'], date("d")-$purgeDateAdjustment['days'], date("Y")-$purgeDateAdjustment['years']));<br /> </code> <code><br /> $queryPurge = "PURGE BINARY LOGS before '$purgeEvent'";<br /> </code> <code><br /> $result = $db->query($queryPurge);<br /> </code> <code><br /> echo $queryPurge . "<br />\n";<br /> </code> <code><br /> //---- fetch a resultset of all the binary logs, this part is <br /> //---- not necessary but show you what you have done<br /> $queryShowMaster = 'SHOW MASTER LOGS';<br /> </code> <code><br /> $result = $db->query($queryShowMaster);<br /> </code> <code><br /> if (DB::isError($result)) { die(showErrorPage($result->getMessage()));<br /> }<br /> </code> <code><br /> $numrows = $result->numRows();<br /> $counter = 1;<br /> </code> <code><br /> for ($i = 0; $i < $numrows; $i++){ $row = $result->fetchRow(DB_FETCHMODE_ASSOC, $i); if ($counter == 1) { $oldest_kept_log = $row['Log_name']; } $counter++;<br /> }<br /> </code> <code><br /> $reportMessage = "The MySQL binary logs have been rotated. The oldest log is '$oldest_kept_log'";<br /> </code> <p>See also:<br /> <a href="http://www.jovianskye.com/archive/mysql-database-checks-with-php">MySQL Database Checks with PHP</a></p> http://www.jovianskye.com/archive/mysql-log-rotation-with-php MySQL Database Checks with PHP <p>I’m just in the middle of upgrading our web servers at the place I work & I was wanting to run an automated check of the MySQL database. I looked around the web for some good scripts, but nothing out there was what I wanted, so I tuned to the good old MySQL site & had a nosey around.</p> http://www.jovianskye.com/archive/mysql-database-checks-with-php