<?
require_once ("../login.inc.php"); 
if ($DEBUG==1) echo "---".$debugcounter++."---";
require_once ("../inc.functions.php");
mysql_select_db('hirnbranduser',$cs);
mysql_select_db('hirnbranduser',$c);
$stmt="select name, ip, privacy from daten where ip='$REMOTE_ADDR' order by idx";
if (!$erg=mysql_query($stmt, $cs)) echo mysql_error().$stmt;
$userdata=mysql_fetch_array($erg);
#vardump($userdata);
include("loginsonstiges.inc");
function getmicrotime(){ 
    list($usec, $sec) = explode(" ",microtime()); 
    return $usec; 
}
#var_dump(get_defined_vars());
if ($ja || trim($erklaerung)<>"" and str_replace("http://", "",$erklaerung)==$erklaerung ){ // speichern
	if ($userdata["privacy"]>0) $user="privat";
	else $user=$userdata["name"];
	
	$stmt="replace INTO sonstiges.wortdersekunde (wort,zeit,erklaerung,datum,data,user) 
	VALUES ('$wort','".time()."', '$erklaerung',NOW(),'".addslashes(serialize($_SERVER))."','$user')";
	if (!mysql_db_query($db, $stmt)) echo mysql_error();
}

$seed=time()+preg_replace('/\./','',getmicrotime());


mt_srand($seed);

$desc_list = array(
"10"=>array("a","e","i","o"),
"11"=>array("a" 	,"e"		, "i"		,"o", "u"),
"22"=>array("a"		,"e"		, "i"		,"o", "u", "y", " ", " ", " ", " ", " ", " "),
"83"=>array("~x88"	,"~x89"		,"r"		,"t","z","p","s","d","f","g","h","j","k","l","x","c","v","b","n","m"),//in der mitte
"84"=>array("a"		,"e"		,"i"		, "o", "u","a", "e", "i", "o", "u","y","~xA8 ~x11","~xA9 ~x11","~xAA ~x11","~xAB ~x11","~xAC ~x11","~xAD ~x11","~xAE ~x11","~xAF ~x11","~xB0 ~x11","~xB1 ~x11","~xB2 ~x11","~xB3 ~x11","~xB4 ~x11","~xB5 ~x11","~xB6 ~x11","~xB7 ~x11","~xB8 ~x11","~xB9 ~x11","~xBA ~x11","~xBB ~x11"),//am anfang
"85"=>array(" ~x88"	,"~x8A ~x22","~x8B ~x22","~x8C ~x22","~x8D ~x22","~x8E ~x22","~x8F ~x22","~x90 ~x22","~x91 ~x22","~x92 ~x22","~x94 ~x22","~x95 ~x22","~x96 ~x22","~x97 ~x22","~x99 ~x22","~x9A ~x22","~x9B ~x22"),//ende der silbe
"86"=>array(" ~xE8"	,"~xEA ~x22","~xEB ~x22","~xEC ~x22","~xED ~x22","~xEF ~x22","~xF0 ~x22","~xF1 ~x22","~xF2 ~x22","~xF3 ~x22","~xF4 ~x22","~xF5 ~x22","~xF6 ~x22","~xF7 ~x22","~xF9 ~x22","~xFA ~x22","~xFB ~x22" ),//ende des wortes

"88"=>array("qu ~x10"),
"89"=>array("w"),
"8A"=>array("rst","rs","rsch","r","rg","rb","rp","rd","rt","rf","r","rg","rx","rl","rm","rn","rr","rs"),
"8B"=>array("tt","tz","tsch"),
"8C"=>array("z","zz"),
"8D"=>array("pp","pt","pf","p"),
"8E"=>array("sp","st","sg","sch","s"),
"8F"=>array("dd","d"),
"90"=>array("ff","f"),
"91"=>array("g","gg","gs"),
"92"=>array("h"),
"93"=>array(" "),
"94"=>array("k","kf","kt"),
"95"=>array("l","ll","lb","lp","ld","lt","lf","lg","lk","lm","ln","ls"),
"96"=>array("x","xt"),
"97"=>array("c","ch"),
"98"=>array(" "),
"99"=>array("b","bb","bt","bf"),
"9A"=>array("n","nn","nd","nt","nf","ng","nk","nx","ns","nz"),
"9B"=>array("m","mm","mp","mt","mf","mg","ms"),


"C8"=>array("qu ~x11"),
"C9"=>array("w"),
"CA"=>array("r"),
"CB"=>array("t","tsch"),
"CC"=>array("z"),
"CD"=>array("pf","p","ps"),
"CE"=>array("sp","st","sk","sch","s"),
"CF"=>array("d"),
"D0"=>array("f","fl","fr"),
"D1"=>array("g"),
"D2"=>array("h"),
"D3"=>array("j"),
"D4"=>array("k"),
"D5"=>array("l"),
"D6"=>array("x"),
"D7"=>array("ch"),
"D8"=>array("v"),
"D9"=>array("b","bl","bs"),
"DA"=>array("n"),
"DB"=>array("m"),

"E8"=>array("qu~x10","q"),
"EA"=>array("rst","rs","rsch","r","rg","rb","rp","rd","rt","rf","r","rg","rx","rl","rm","rn","rr","rs"),
"EB"=>array("tt","tz","tsch"),
"EC"=>array("z","zz","tz"),
"ED"=>array("pp","pt","pf","p"),
"EE"=>array("sp","st","sg","sch","s"),
"EF"=>array("dd","d"),
"F0"=>array("ff","fk ~x11","f"),
"F1"=>array("g","gg","gs",gf),
"F2"=>array("h"),
"F3"=>array("j ~x11"),
"F4"=>array("k","kf","kt"),
"F5"=>array("l","ll","lb","lp","ld","lt","lf","lg","lk","lm","ln","ls"),
"F6"=>array("x","xt"),
"F7"=>array("ck","ch"),
"F9"=>array("b","bb","bt","bf"),
"FA"=>array("n","nn","nd","nt","nf","ng","nk","nx","ns","nz"),
"FB"=>array("m","mm","mp","mt","mf","mg","ms")

);


function change($in){
	$in=" ".$in;
	global $desc_list;
	while($pos = strpos ($in, "~x")){
		#echo "pos=
		$x=substr($in,$pos+2,2);
		$out.=substr($in,0,$pos);
		$in=substr($in,$pos+4);
		if (sizeof($desc_list[$x])<2) $rval=0;
		else $rval=intval(mt_rand( 0,sizeof($desc_list[$x])-1));
		$out.=change($desc_list[$x][$rval]);
	}
	return substr($out.$in,1);
}
$p="";
$i=0;
$anzahl_silben=intval(mt_rand( 2,3));
for ($i=0;$i<$anzahl_silben;$i++){
	$cur="84";
	if (sizeof($desc_list[$cur])==1) $rval=0;
	else $rval=intval(mt_rand( 0,sizeof($desc_list[$cur])-1));
	$description= change($desc_list[$cur][$rval]);
	$p=$p.$description;
	$cur="85";
	if (sizeof($desc_list[$cur])==1) $rval=0;
	else $rval=intval(mt_rand( 0,sizeof($desc_list[$cur])-1));
	$description= change($desc_list[$cur][$rval]);
	$p=$p.$description;
}

   $p=str_replace(" ","",$p);
   if (rand(1,2)==2){
   	$konsonants="qwrtzpsdfghjklxcvbnm";
	$p=$konsonants[rand(1,strlen($konsonants))].$p;
   }
   if ($orig) $p=$orig;
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
	<title>Wort der Sekunde</title>
<link rel="STYLESHEET" type="text/css" href="style-v2.php">
<style>
	input{
		width:120px;
		height:22px;
		font-family:verdana;
		font-weight:bold
	}
</style>
</head>

<body leftmargin="0" bgcolor="#d7c39a" rightmargin="40" topmargin="0" marginheight="0" marginwidth="40">
<div style="width:400px; text-align:center"><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://www.hirnbrand.de/index.php3" target="_top"><img src="../pics/brain/brain-art.gif" width="60" height="60" alt="" border="0"></a>
<br><br><br><a href="http://wortdersekunde.z11.de/" target="_top">Die Seite ist umgezogen<br>Das neue Wort Der Sekunde findet ihr hier:<br>http://wortdersekunde.z11.de</a>
<br><br><br><br><br><br><br><font style="color: maroon;font-size:20px;font-family:verdana"><?
    echo ucfirst($p);
?></font><br>
<br><!--
<form action="wortdersekunde_abstimmung.php">
<input type="hidden" name="wort" value="<?
    echo ucfirst($p);
?>"><!--
<input type="submit" name="ja" value="gutes Wort">&nbsp;&nbsp;<input type="submit" name="nein" value="unaussprechbar">
<br><br><!--
falls jemand wei&szlig;, was dieses Wort bedeutet,<br>
 bitte hier die 
Erkl&auml;rung:<br>
<textarea cols="44" rows="4" name="erklaerung"></textarea>
</form>--></div>
<? 
$i=1;
$upperlimit=20;
$step=20;
$color1="menu";
$color2="body";
if (!$seite) $seite=0;
ob_start();
if ($ansehen){
	$stmt="select distinct wort, erklaerung 
	from  wortdersekunde 
	order by zeit DESC 
	";
} else {
	if (!$glossar) {
		$glossar=1;
		$seite=1;
	}	
	$stmt="select distinct wort, erklaerung from  wortdersekunde 
	where erklaerung <>'' 
	order by zeit DESC 
	";
}
if (!$erg=mysql_db_query($db, $stmt)) echo $stmt;
while($w=mysql_fetch_array($erg)) {
	if ($i>($seite-1)*$step and $i<($seite+1)*$step) {
		echo '<div class="'.((++$countrows%2==1)?$color1:$color2).'">';
		if ($w["erklaerung"]<>"") echo '<font style="color: maroon;font-family:verdana">'.$w["wort"]."</font><br>".$w["erklaerung"]."<br>";
		else  echo '<a href="'.$PHP_SELF.'?orig='.$w["wort"].'"><font style="color: maroon;font-family:verdana">'.$w["wort"]."</a></font><br>";
		echo "</div>";
	}
	$i++;
}
$upperlimit=1+mysql_num_rows($erg)/$step;
	
$content=ob_get_clean();
?>
<br>
<a href="<? echo $PHP_SELF; ?>?ansehen=1&seite=<? echo $seite+1; ?>"><?
if ($ansehen) echo weiter; else echo "wortliste ansehen"; ?></a><br>
<?
for ($i=1; $i<=$upperlimit; $i++){
 echo '<a href="'.$PHP_SELF.'?ansehen='.$ansehen.'&seite='.($i).'&glossar='.$glossar.'">';
 if ($i==$seite) echo "<b>";
 echo $i;
 if ($i==$seite) echo "</b>";
 echo '</a> &nbsp;';
}
?>
<br>
<a href="<? echo $PHP_SELF; ?>?glossar=1&seite=<? echo $seite+1; ?>"><?
if ($glossar) echo weiter; else echo "glossar"; ?></a><br>
<br><div style="width:500px"><?
echo $content;
?>
<br><br>
Eine Spielerei von <a href="http://www.eclabs.de" target="_blank">eastcoast laboratories</a>
<br><br><a href="http://eclabs.de" target="_blank" _base_target="_blank"><img src="http://spacetrace.org/pics/eclabslogo.gif" alt="Eastcoast Laboratories: php, perl, linux-administration" title="Eastcoast Laboratories: php, perl, linux-administration" _base_target="_blank" border="0"></a><br><br></div>
</body>
</html>