the database is currently offline! please try again later."; exit;} if(!$user) { Header("HTTP/1.0 401 Unauthorized"); Header("WWW-Authenticate: Basic realm=\"homestories\""); echo "
we need your password, please!
"; exit; } $dblink = mysql_pconnect($host,$login,$pwd); # echo "dblink: $dblink
"; $sql = "SELECT password FROM home_users WHERE username = '$user'"; $result = mysql($database,$sql); # echo "result: '$result'
"; $test = mysql_numrows($result); if ($test){$passwd_out = mysql_result($result,0,"password");} else { echo "
Your identity is unknown. user not found. Sorry!"; exit; } if ($passwd_out == $passwd_in) { $login_date = date( "Y-m-d h:i:s" ); ########### errors seit letztem login checken, falls > 10 block-meldung ############### # $query = "SELECT errors FROM futurelab_users WHERE username = '$user'"; # $result_errors = mysql($database,$query); # $test = mysql_numrows($result); # if ($test){$errors = mysql_result($result_errors,0,"errors");} # if ($errors > 10) { # echo "
this account has been blocked (too many login failures).
# please contact the website-management!
"; # exit; # } ########### email abfragen ################# # $query = "SELECT email FROM futurelab_users WHERE username = '$user'"; # $result_email = mysql($database,$query); # $test = mysql_numrows($result); # if ($test){$email = mysql_result($result_email,0,"email");} ########### last login abfragen ############ $query = "SELECT last_login FROM home_users WHERE username = '$user'"; $result_last_login = mysql($database,$query); $test = mysql_numrows($result); if ($test){$last_login = mysql_result($result_last_login,0,"last_login");} ########### neues last_login-datum eintragen ############## $query = "UPDATE home_users SET last_login='$login_date' WHERE username='$user'"; $status = mysql_query($query,$dblink); # error-test $meldung = mysql_error($dblink); echo "error: $meldung"; # echo "
update-status: $status
"; # echo "database: $database
"; # echo "dblink: $dblink
"; ########### eingetragenes neues last_login abfragen ############# $query = "SELECT last_login FROM home_users WHERE username = '$PHP_AUTH_USER'"; $result_current_login = mysql($database,$query); $test = mysql_numrows($result_current_login); if ($test){$current_login = mysql_result($result_current_login,0,"last_login");} ########### alles ok, error-pointer auf null ################ # $query = "UPDATE futurelab_users SET errors=0 WHERE username='$user'"; # $status = mysql_query($query,$dblink); # error-test $meldung = mysql_error($dblink); echo "error: $meldung"; # echo "

Hallo $user.

"; # echo "your email: $email
"; # echo "last login: $last_login
"; # echo "errors since last login: $errors
"; # echo "current login date:$current_login"; } ?>
@homestories

@homestories

"; echo "\nneuer eintrag

"; ########### db parameter definieren ############## $fields = "date, titel, text, bild, username"; $fields_amt = 5; $show_fiels_amt = $fields_amt; $search_db = "home_diary"; ########### db query definieren ############## $query = "SELECT $fields FROM $search_db ORDER BY date DESC"; #echo "
$query

"; $result = mysql($database,$query); $meldung = mysql_error($dblink); if ($meldung) {echo "error: $meldung";} $result_amt = mysql_numrows($result); echo "anzahl story-einträge: $result_amt

"; echo "\n"; echo "\nalle Einträge zeigen
"; if ($result_amt){$bytes_up = mysql_result($result,0,0);} else {echo "
sorry, nichts gefunden. haben die etwa geschlampt beim eintragen?.

"; exit;} ############### table mit gefundenen eintraegen schreiben ############### include "../layouts/fonttag.php3"; echo "\n"; if ($result_amt > 50) $result_amt = 50; for ($rows = 0; $rows < $result_amt; $rows++) { echo "
"; echo "\n"; echo "
\n"; for ($columns = 0; $columns < $fields_amt; $columns++) { $data[$columns] = mysql_result($result,$rows,$columns); if ($columns == 0) { $jahr = substr($data[$columns],0,4); $monat= substr($data[$columns],5,2); $tag = substr($data[$columns],8,2); $tagname = date("l", mktime(0,0,0,$tag,$monat,$jahr)); echo "\n\n\n"; echo "\n"; } if ($columns == 2) { $text = $data[$columns]; $text = str_replace("\\", "", $text); if (! strstr($text, "<")) { $text = str_replace("\n", "
", $text); } echo ""; echo "\n"; } if ($columns == 3 && $data[$columns]) { if (file_exists ("diary_images/$data[$columns]")) { $size = GetImageSize("diary_images/$data[$columns]"); $width = $size[0]; $height = $size[1]; include "../layouts/fonttag.php3"; echo""; echo "\n"; } if ($columns == 4) { echo "
\n"; include "../layouts/fonttag.php3"; echo "$tag.$monat.$jahr"; echo "\n"; } if ($columns == 1) { $title = $data[$columns]; $title = str_replace("\\", "", $title); include "../layouts/fonttag.php3"; echo "

$title

"; echo "\n"; echo "
"; include "../layouts/fonttag.php3"; echo "\n"; echo ""; echo "
$text"; echo "\n"; echo "

 

** das bild dazu **"; echo "\n"; echo ""; echo "\n"; } else { echo " [bild nach server-umzug nicht gefunden..]"; } echo "
\n"; include "../layouts/fonttag.php3"; echo "eintrag geschrieben von:
\n$data[$columns]"; echo "\n"; echo "
"; echo "

\n"; } } echo "\n
\n"; echo "
\n"; } exit; include "../layouts/header.php3"; include "../layouts/bodytag.php3"; include "../layouts/fonttag.php3"; echo "
temp. out of order
"; echo "\n"; ?>