function writemail($mail){ #if (!validate_email($mail)) return "NO$mail"."SPAM"; $splitmail1=substr($mail,0,strlen($mail)-5)."'+'".substr($mail,-5); $mail="REMOVE".str_replace("@", "-AT-", $mail)."ME"; $splitmail=substr($mail,0,strlen($mail)-5)."'+'".substr($mail,-5); $str=''; return $str; } function validate_email ($email) { $e=explode(",", $email); foreach($e as $v){ #return (ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+'.'@'.'[-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.'.'[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$',$address)); if (!preg_match("/^[-_.[:alnum:]]+@((([[:alnum:]]|[[:alnum:]][[:alnum:]-]*[[:alnum:]])\.)+(ad|" ."ae|aero|af|ag|ai|al|am|an|ao|aq|ar|arpa|as|at|au|aw|az|ba|bb|bd|be|bf|bg|bh|bi|biz|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cc|cd|cf|cg|ch|ci|ck|cl|cm|cn|co|com|coop|cr|cs|cu|cv|cx|cy|cz|de|dj|dk|dm|do|dz|ec|edu|ee|eg|eh|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|gd|ge|gf|gh|gi|gl|gm|gn|gov|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|hr|ht|hu|id|ie|il|in|info|int|io|iq|ir|is|it|jm|jo|jp|ke|kg|kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|ma|mc|md|mg|mh|mil|mk|ml|mm|mn|mo|mp|mq|mr|ms|mt|mu|museum|mv|mw|mx|my|mz|na|name|nc|ne|net|nf|ng|ni|nl|no|np|nr|nt|nu|nz|om|org|pa|pe|pf|pg|ph|pk|pl|pm|pn|pr|pro|ps|pt|pw|py|qa|re|ro|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|su|sv|sy|sz|tc|td|tf|tg|th|tj|tk|tm|tn|to|tp|tr|tt|tv|tw|tz|ua|ug|uk|um|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|ye|yt|yu|za|zm" ."|zw)|(([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5])\.){3}([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|" .".[2][5][0-5]))$/i",$v)) return FALSE; } return TRUE; } $name=urldecode($name); $standard= ' font-family:Arial; font-size:10pt; font-weight:bold; color:#aa2222;'; include ("login.inc"); ?>
|
$stmt="show tables";
if (!$erg=mysql_db_query($db, $stmt)) echo mysql_error()." $stmt"; while ($row=mysql_fetch_array($erg)) if ($row[0]!="namen" and $row[0]!="namen2"){ $stmt="select ip from ".$row[0]; if (!$erg1=mysql_db_query($db, $stmt)) echo mysql_error()." $stmt"; while ($row2=mysql_fetch_assoc($erg1)){ #if(!preg_match("/\d+\.\d+\.\d+\.\d+/",$row2[ip]) and $row2[ip]) $namen[$row2[ip]]++; } } arsort($namen); foreach($namen as $name=>$c) if ($c>20){ echo" "; if(!preg_match("/\d+\.\d+\.\d+\.\d+/",$name) and $name) echo ""; echo $name; @$h=gethostbyaddr($name); if(!preg_match("/\d+\.\d+\.\d+\.\d+/",$name) and $name) echo ""; else if($h!=$name) echo ' ('.$h.')'; echo ": $c Wörter"; $stmt="select * from hirnbranduser.daten where name ='$name'"; if (!$erg=mysql_db_query($db, $stmt)) echo mysql_error()." $stmt"; while ($row=mysql_fetch_array($erg)) if ($row["mail"] and $row["mail"] !="NOSPAM"){ echo ", ".writemail($row["mail"]).""; } } ?> |