<?
mysql_connect("localhost", "user", "pasw")or die('<pre>Nekaa.</p>');
mysql_select_db("datubaze")or die('<pre>Nekaa.</p>');
function draw_login(){
      echo '
       <form method="post" action="/forums/index.php?act=Login&CODE=01">
          <p>
              Logins<br />
              <input name="UserName" type="text" /><br />
              Parole<br />
              <input name="PassWord" type="password" /><br />
              <input name="CookieDate" value="1" type="checkbox" /> Atcerēties mani<br />
              <input value="Ienākt" type="submit" /> <a href="/forums/index.php?act=Reg&CODE=00">Reģistrēties</a>
          </p>
      </form>
      ';
}
if(!empty($_COOKIE['member_id']) && is_numeric($_COOKIE['member_id']) && !empty($_COOKIE['pass_hash'])){
      $sql = sprintf("SELECT m.id, m.members_display_name, m.email, m.member_login_key, m.joined, e.avatar_location FROM `ibf_members` m, `ibf_member_extra` e WHERE m.id=%d AND m.member_login_key='%s' AND e.id=m.id LIMIT 1", (int)$_COOKIE['member_id'], mysql_real_escape_string($_COOKIE['pass_hash']));
      $res = mysql_query($sql);
      if(mysql_num_rows($res)>0){
          $row = mysql_fetch_object($res);
          $avatar = $row->avatar_location;
          if(file_exists("forums/uploads/".$avatar)){$avatar = "forums/uploads/".$avatar;};
          printf('
          <p style="text-align:center;">
             Čau, %s.%s
          </p>
          <ul>

                
    <right><img src="http://bildites.lv/images/s98a4uy2px7ql5v5bzh3.png" alt="Labot" />
</a>
<a href="/forums/index.php?act=UserCP&CODE=00">Labot Profilu</a><br>

              <img src="http://bildites.lv/images/so7sdvje1ht5ojt0zg.png" alt="Vestules" />
</a><a href="/forums/index.php?act=Msg&CODE=01">Vēstules</a><br>

              <img src="http://bildites.lv/images/ynvbnut2lw2qq1lz2bap.png" alt="Meklet" />
              <a href="/f/index.php?act=Search&f=0">Meklēt</a><br>
           <img src="http://bildites.lv/images/figc2dkf4il5edbge77e.png" alt="Iziet" />
</a><a href="/forums/index.php?act=Login&CODE=03&k=%s">Iziet</a><br></right>
          </ul>
          ', $row->members_display_name, !empty($row->avatar_location) ? '<br/><center><img src="'.$avatar.'"" width="150" style="margin-top: 0px; border: 1px solid #0b9a04;"></center><br/>' : '', md5($row->email.'&'.$row->member_login_key.'&'.$row->joined));
      }else{
          draw_login();
      }
}else{
      draw_login();
}
?>