Beiträge von blackbox100

<?php
/*Überprüfen den Login namen und passworts*/
$verbindung = mysql_connect("localhost", "blackbox", "123956") or die ("Fehler im System konnte nicht connecten");
mysql_select_db("test") or die ("Datenbank nicht gefunden"); 


function login_pruefen($name, $pass)  
{  
   $query = "SELECT   
                `id`   
              FROM   
                `b_admin`   
              WHERE   
                `name` = '" . mysql_real_escape_string($name) . "'   
               AND   
                `password` = '" . md5($pass) . "'";  

   $result = mysql_query($query)  
      or die("MySQL-Error: " . mysql_error());  


   if (mysql_num_rows($result))  
   {   
      $login = mysql_fetch_assoc($result);  
      return $login[`id`];  
   }   
   else   
   {  
     return false;  
   }  
}


/*EInloggen*/
function einloggen($user)
{
$session = session_id();
$sql = mysql_query("UPDATE ´b_admin´ SET ´session´ = ´$session´ WHERE ´id´ = ´$user´ ");
echo "Du wurdest Eingeloggt";


}
/*Ausloggen*/
function ausloggen()
{
$session = session_id();
$sql = mysql_query("UPDATE ´b_admin´ SET ´session´ = NULL WHERE ´session´ = ´$session´ ");


}
/*Login prüfen*/
function eingeloggt() {
$session = session_id();
$query = 'SELECT `id` FROM b_admin WHERE `id` = 1';
$result = mysql_query($query);
return mysql_num_rows($result) or die ("Mysql_ERROR: " . mysql_error());
}


?>

<?php
/*Überprüfen den Login namen und passworts*/
function login_pruefen($name, $pass)
{
if ($sql = mysql_query("SELECT 'id' FROM 'b_admin' WHERE 'name' = '$name' AND 'password' = MD5{'$pass'}"))
{
$login = mysql_fetch_assoc($sql);
return $login['id'];
} else {
return false;
}






}


 /*Einloggen*/
function einloggen($user)
{
$session = session_id();
$sql = mysql_query("UPDATE 'b_admin' SET 'session' = '$session' WHERE 'id' = '$user' ");


}
/*Ausloggen*/
function ausloggen()
{
$session = session_id();
$sql = mysql_query("UPDATE 'b_admin' SET 'session' = NULL WHERE 'session' = '$session' ");


}
 /*Login prüfen*/
function eingeloggt() {
$session = session_id();
$sql = mysql_query("SELECT 'id' FROM 'b_admin' WHERE 'session' = '$session'");


return (mysql_num_rows($sql)== 1);


}
mysql_error()
?>

<?PHP
class sys{
  function includeContent(){
    global $currentpage;
    $currentpage->getContent();
  }


  function includeHeader(){
    global $dbpraefix,$currentpage;
    echo "<title>".$currentpage->title."</title>
          <meta http-equiv=\"Content-Type\" content=\"text/html; 
          charset=iso-8859-1\" />";
    $res = mysql_query("SELECT name, content
                        FROM ".$dbpraefix."meta_global
                        UNION SELECT name, content
                        FROM ".$dbpraefix."meta_local
                        WHERE page = '".$currentpage->id."'");
    while($row = mysql_fetch_row($res)){
      echo "<meta name=\"".$row[0]."\" content=\"".$row[1]."\" />";
    }
  }



  
 function displayBreadcrump($separator,$class,$idpraefix){
    global $currentpage;
    $i = 1;
    $breadcrump = $currentpage->getBreadcrump();
    while($i <= count($breadcrump)){
      echo "<a href=\"".$breadcrump[$i-1][0].".htm\" class=\"".$class."\" 
            id=\"".$idpraefix.$i."\">".$breadcrump[$i-1][1]."</a>";
      if($i < count($breadcrump)){
        echo $separator;
      }
      $i++;
    }
  }

 
  function displayGlobalMenu($globalstart,$globalend, $elementstart,$elementend,
                       $class){
    global $dbpraefix;
    $res = mysql_query("SELECT value FROM ".$dbpraefix."settings 
                        WHERE property = 'globalmenuid'");
    if($row = mysql_fetch_row($res)){
      menu::display($row[0], $globalstart,$globalend, $elementstart,$elementend,
                    $class);
    }
  }


  function displayLocalMenu($globalstart,$globalend, $elementstart,$elementend,
                            $class){
    global $currentpage;
    if($currentpage->menu > -1){
      Menu::display($currentpage->menu, $globalstart,$globalend, $elementstart,
                    $elementend,$class);
    }
  }

  }
?>