Archive for June, 2008

Sameks model agency

Wednesday, June 18th, 2008

My bestm8 Sameks company also provides model girls for variety of events - from simple ones to avantgarde shows.

The technology I used for creation of website was the flash book I developed about 3 years ago. And with a little Kostas help with design and Sameks aesthetic eye this is what was born.

I believe you won’t be disappointed with checking out the site which will be timely updated by new models.

php system script for maintaining mysql databases and tables

Thursday, June 12th, 2008

This is one of the php system scripts I wrote and would like to share. It can be extended but it already does its basic stuff - mysql maintenance with email notification.

Use it in cron and have a peace with tables, indexes and keys :)

< ?php
// which databases to maintain
$databases  = "provider wp subversion mysql";
 
$returnval = maintain_mysql($databases);
@mail("root","mysql database maintainer", $returnval);
 
/**
* mysql table maintainer - optimizes and rebuilds indexes on mysql tables
*
* @author benjamin.povirk@***** 3.1.07
* @return string
* @param databases to maintain
*/
function maintain_mysql ($databases) {
 
$database = explode(" ", $databases);
foreach ($database as $db) {
$returnval .= "maintenance on all tables in ".$db." started\r\n";
// Connecting, selecting database
$link = mysql_connect('localhost', 'YOUR_USER_HERE', 'YOUR_PASSWORD_HERE') or die('Could not connect: ' . mysql_error());
 
mysql_select_db($db) or die('Could not select database '.$db);
 
//repair and optimize all tables in current database
$query = "SHOW TABLES";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
 
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  foreach ($line as $col_value) {
    $lock = mysql_query("LOCK TABLE ".$col_value." WRITE") or die('Query failed: ' . mysql_error());
    $optimize = mysql_query("OPTIMIZE TABLE ".$col_value) or die('Query failed: ' . mysql_error());
    $repair = mysql_query("REPAIR TABLE ".$col_value." QUICK") or die('Query failed: ' . mysql_error());
    $unlock = mysql_query("UNLOCK TABLES") or die('Query failed: ' . mysql_error());
  }
}
mysql_free_result($result);
mysql_free_result($repair);
mysql_free_result($optimize);
 
// Closing connection
mysql_close($link);
$returnval .= "maintenance on all tables in ".$db." finished successfuly\r\n\r\n";
}
 
return $returnval;
}
 
?>

efc2008

Wednesday, June 11th, 2008

I’m in favor of Portugal footbal team!

latest Flash eye candy - download free 3D cube in Flash

Wednesday, June 4th, 2008

Lately I’ve been kinda Flashing ( as Flash engineering that is ). Got some idea to do 3D and make my math teachers proud :)
Anže was quite impressed by rotating 3D cube with images on it’s faces, he also helped me with the ideas. I believe he’ll manage to build a wordpress plugin for users that want to express their photos in a fancy way :)

Well, It’s another thing I did in Adobe’s Flash and is here for you to use it. It’s fully customizable.
Check out the 3D CUBE MEDIA GALLERY v3.0 if you are interested in it.


Oh yes, I use and recomend Firefox 2

AJAXed with AWP