#!/usr/local/bin/php

<?php

set_time_limit(0);

mysql_connect("localhost", "user", "passwort");
mysql_select_db("test");

/*
mysql_query("CREATE TABLE nachrichten
                                     (id INT not null AUTO_INCREMENT,
                                      datum DATE not null,
                                      zeit TIME not null,
                                      ueberschrift VARCHAR (255) not null,
                                      text BLOB not null,
                                      rubrik VARCHAR (16) not null,
                                      PRIMARY KEY (id)
                                     )
            ");
*/


function texturizer($min, $max)
{
 GLOBAL $texte;
 $j = rand($min, $max);
 for ($i; $i < $j; $i++)
 {
  $string .= $texte[rand(0, sizeof($texte)-1)]." ";
 }
 return trim($string);
}

mysql_query("DELETE from nachrichten");

$texte = array("auf", "gegen", "und", "Politiker", "Wissenschaftler", "Atomgegner", "SPD", "CDU", "hat", "haben", "wollen", "ist", "seit", "nicht",
               "auch", "bei", "Wahlen", "Gelder", "waschen", "sinnfrei", "aber", "Ueberfall", "Rede", "Linux", "Microsoft", "Desktop", "PHP",
               "rulez", "Gtk", "Wiedervereinigung");

$rubriken = array("Politik", "Wirtschaft", "Multimedia");

$i = -90;
while ($datum <> date("Y-m-d"))
{
 $datum = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") + $i, date("Y")));
 $k = rand(12, 30);
 $j = 0;
 for ($j; $j < $k; $j++)
 {
  $zeit = date("H:i:s", mktime(rand(0, 60), rand(0, 60), rand(0, 24), date("m"), date("d") + $i, date("Y")));
  $ueberschrift = ucfirst(texturizer(4, 8));
  $text = ucfirst(texturizer(90, 340));
  $rubrik = $rubriken[rand(0, sizeof($rubriken)-1)];
  mysql_query("INSERT into nachrichten (datum, zeit, ueberschrift, text, rubrik) VALUES ('$datum', '$zeit', '$ueberschrift', '$text', '$rubrik')");
 }
 $i++;
}

?>