phpBB.de

Code: Alles auswählen

       $cookie_session_id_key = 'phpbb3_XXX_sid'; // Your indivudal code
       $cookie_session_key = 'phpbb3_XXX_k'; // Your individual code

Code: Alles auswählen

<?php $userid = 0;
       $cookie_session_id_key = 'phpbb3_XXX_sid'; // Your indivudal code
       $cookie_session_key = 'phpbb3_XXX_k'; // Your individual code

       if(!empty($_COOKIE[$cookie_session_id_key]))
       {
        $result = mysql_query("SELECT session_user_id FROM phpbb_sessions WHERE session_id='".mysql_real_escape_string($_COOKIE[$cookie_session_id_key])."'");
   
        if(mysql_num_rows($result) == 1)
        {
    $userid = mysql_result($result, 0);o

    if($userid > 1)
    {
     $login = 1;

     $user = mysql_fetch_assoc(mysql_query("SELECT username FROM phpbb_users WHERE user_id=".(int)$userid));
     $nickname = $user["username"];
   
     mysql_query("UPDATE phpbb_sessions SET session_time = ".time()." WHERE session_id = '".mysql_real_escape_string($_COOKIE[$cookie_session_id_key])."'");
    }
        }
        else
        {
         $result = mysql_query("SELECT key_id, user_id FROM phpbb_sessions_keys");

         while($ds = mysql_fetch_object($result))
         {
          if($ds->key_id == md5($_COOKIE[$cookie_session_key]))
          {
      $login = 1;

      $ip = $_SERVER["REMOTE_ADDR"];
      $browser = addslashes($_SERVER["HTTP_USER_AGENT"]);

           mysql_query("INSERT INTO phpbb_sessions SET session_id = '".mysql_real_escape_string($_COOKIE[$cookie_session_id_key])."', session_user_id = '$ds->user_id', session_last_visit = ".time().", session_start = ".time().", session_time = ".time().", session_ip = '$ip', session_browser = '$browser', session_autologin = '1'");
      mysql_query("UPDATE phpbb_sessions SET last_ip = '$ip', last_login = ".time()." WHERE key_id = '".mysql_real_escape_string(md5($_COOKIE[$cookie_session_key]))."'");
   
      $user = mysql_fetch_assoc(mysql_query("SELECT username FROM phpbb_users WHERE user_id = '$ds->user_id'"));
      $nickname = $user["username"];
          }
         }   
        }
       }
	   ?>
	   
	   <?php if($login == 1)
       { ?>
        <?php echo "Hello ".$nickname;
       }
       else
       { ?>
    <form action="/community/ucp.php?mode=login" method="post"> // Individual path
       <input type="hidden" name="autologin" value="1" />
       <input type="hidden" name="login" value="Login" />
       <input type="hidden" name="site" value="<?php echo htmlentities($_SERVER["PHP_SELF"]."?".$_SERVER["QUERY_STRING"]); ?>" /> // Redirect
            <input type="text" name="username" value="Benutzername" />
       <input type="password" name="password" />
       <input type="image" src="..." />
          </form>

     <a href="/community/ucp.php?mode=register">[Registrierung]</a> // Individual path
    <?php   } ?>

Code: Alles auswählen

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/sp01_57/html/login.php on line 9 Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/www/sp01_57/html/login.php on line 27

Code: Alles auswählen

<?php $userid = 0;
       $cookie_session_id_key = 'phpbb3_36i51_sid'; // Your indivudal code
       $cookie_session_key = 'phpbb3_36i51_k'; // Your individual code

Code: Alles auswählen

$datenbank=mysql_connect("localhost","Benutzername","Passwort") or die ("Keine Verbindung zu mysql");
mysql_select_db('Tabelle',$datenbank) or die ("Konnte Datenbank nicht auswählen");