<?


   // Include messages file & Connect to sql server & inizialize configuration variables

  include "./includes/messages.inc.php";

  include "./includes/config.inc.php";

  include "header.php";



  //--



  getSessionVars();

  $auction_id = $sessionVars["CURRENT_ITEM"];





if ( empty($user_id) )

  $user_id = $id;





if (!empty($user))

{

  $sql="SELECT id FROM users WHERE nick=\"".AddSlashes($user)."\"";

  $res=mysql_query ($sql);

  $arr=mysql_fetch_array ($res);

  $TPL_user_id=$arr[id];

}

if (!empty($user_id))

{

  $TPL_user_id=$user_id;

}



  $sql="SELECT * FROM users WHERE id='".AddSlashes($TPL_user_id)."'";



  $res=mysql_query($sql);

  if ($res)

  {

    if ($arr=mysql_fetch_array($res))

    {

      $TPL_num_feedbacks    =$arr[rate_num];

      $TPL_user_value      =$arr[nick];

      if ($arr[rate_num])

      {

        $rate_ratio=round($arr[rate_sum]/$arr[rate_num]);

      }

      else

      {

        $rate_ratio=0;

      }

      $TPL_rate_ratio_value  ="<IMG src=\"./images/estrella_".$rate_ratio.".gif\">";

      $reg_date  = $arr[reg_date];

      $year      = substr($reg_date,0,4);

      $month     = substr($reg_date,5,2);

      $date      = substr($reg_date,8,2);

      

      //$TPL_ADC_value = ArrangeDateMesCompleto($date,$month,$year,'','');

      $TPL_ADC_value = $date.".".$month.".".$year;

    }

    else

    {

      $TPL_err=1;

      $TPL_errmsg="Dieser User existiert nicht in unserer Datenbank!";

    }

  }

  else

  {

    $TPL_err=1;

    $TPL_errmsg="Datenbankabfrage gescheitert!";

  }









  include "./templates/template_profile_php.html";

  include "./footer.php";







?>

<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0">
							<TR>
								<TD WIDTH="13">[img]images/dummy.gif[/img]</TD>
							  <TD WIDTH="395">[img]images/dummy.gif[/img]
</TD>
								<TD WIDTH="19">[img]images/dummy.gif[/img]</TD>
							</TR>
							<TR>
								<TD>[img]images/dummy.gif[/img]</TD>
								<TD VALIGN="top">[img]images/dummy.gif[/img]
[img]images/headliner.gif[/img]</TD>
								<TD>[img]images/dummy.gif[/img]</TD>
							</TR>
							<TR>
								<TD>[img]images/dummy.gif[/img]</TD>
							  <TD VALIGN="top">[img]images/dummy.gif[/img]

								<CENTER>
								   <TABLE WIDTH="400" BGCOLOR="#FFFFFF" BORDER=0 CELLPADDING="0" CELLSPACING="0">

  <TR>

    <TD>

Benutzerprofil:

      </p>
      <CENTER>
      <TABLE WIDTH="400" BORDER="0" CELLSPACING="1" CELLPADDING="1" BGCOLOR="#D3B0D3">

      <TR>

        <TD bgcolor="#D3B0D3">

          <TABLE WIDTH="394" height="160" BORDER="0" align="center" CELLPADDING="2" CELLSPACING="1" BGCOLOR="#D3B0D3">

            <TR BGCOLOR="#D3B0D3">
              <TD COLSPAN="2" class="Stil2"><? echo $usr_font.$TPL_user_value; ?> <? print $std_font.$MSG_502; ?> <? print $TPL_num_feedbacks ?>          
            </TR>
            <TR BGCOLOR="#FFFFFF">

              <TD COLSPAN="2"><span class="Stil1">Bewertungstatus: <? print $TPL_rate_ratio_value  ?>

              </span></TR>



            <TR BGCOLOR="#EFEFEF">

              <TD COLSPAN="2">

                <TABLE WIDTH="388" border="0" align="center" CELLPADDING="0" CELLSPACING="0">

                  <TR>

                    <TD WIDTH="50%">

                    </TD>



                    <TD WIDTH="50%" ALIGN="right">

                      <? print $std_font; ?>

                      <? print $MSG_208 ?>

                    </TD>

                  </TR>

                </TABLE>

              </TD>

            </TR>



            <TR BGCOLOR="#EFEFEF" VALIGN=top>

              <TD width="50%" WIDHT="40%">

                <? print $std_font.$MSG_209 ?>

              </TD>



              <TD WIDTH="50%">

                

                <? print $std_font.$TPL_ADC_value ?>

                


              </TD>

            </TR>



            <TR BGCOLOR="#EFEFEF" VALIGN=top>

              <TD WIDHT="40%">

                <? print $std_font.$MSG_210 ?>

              </TD>



              <TD WIDTH="50%">

                <? print $std_font; ?>

                <? print $TPL_user_value ?>

                


              </TD>

            </TR>



            <TR  BGCOLOR="#EFEFEF"VALIGN=top>
              <TD VALIGN="top" WIDHT="40%">neuesfeld ---&gt; </TD>
              <TD>
		
 <? print $std_font; ?>

                <? print $TPL_email ?></A>



			</TD>
            <TR  BGCOLOR="#EFEFEF"VALIGN=top>
              <TD VALIGN="top" WIDHT="40%"></TD>
              <TD></TD>
            <TR  BGCOLOR="#EFEFEF"VALIGN=top>

              <TD VALIGN="top" WIDHT="40%">

                <? print $std_font.$MSG_212 ?>

              </TD>



              <TD WIDTH="50%">

                <? print $std_font; ?>

                <A HREF="all_auctions.php?SESSION_ID=<? print urlencode($sessionIDU); ?>&user_id=<? print $TPL_user_id?>">

                <? print $MSG_213 ?></A>                  

               </TD>

             <TR>

           </TABLE>

         </TD>

       </TR>

     </TABLE>

     </CENTER>

    </TD>

  </TR>

</TABLE>
								</CENTER></TD>
								<TD>[img]images/dummy.gif[/img]</TD>
							</TR>
						</TABLE>