wit scherm na registratie

<?
include_once "myconnect.php";
include_once "left_cats.php";
function main()
{
/////////////getting length of user name and password
$len=mysql_fetch_array(mysql_query("select username_len,pwd_len,agreement from sbauctions_config"));
$username_len=$len["username_len"];
$pwd_len=$len["pwd_len"];
if(count($_REQUEST)>11)
{
$fname=$_REQUEST["fname"];
$lname=$_REQUEST["lname"];
$c_name=$_REQUEST["company_name"];
$add1=$_REQUEST["add1"];
$add2=$_REQUEST["add2"];
$city=$_REQUEST["city"];
$state=$_REQUEST["state"];
$zip=$_REQUEST["zip_code"];
$country=$_REQUEST["country"];
$home_phone=$_REQUEST["home_phone"];
$work_phone=$_REQUEST["work_phone"];
$email=$_REQUEST["email_addr"];
}
else
{
$fname="";
$lname="";
$c_name="";
$add1="";
$add2="";
$city="";
$state="";
$zip="";
$country=0;
$home_phone="";
$work_phone="";
$email="";
}
?>

<SCRIPT language=javascript>
<!--
function emailCheck (emailStr) {
var emailPat=/^(.+)@(.+)$/
var specialChars="\\(\\)<>@,;:\\\\\\\"\\.\\[\\]"
var validChars="\[^\\s" + specialChars + "\]"
var quotedUser="(\"[^\"]*\")"
var ipDomainPat=/^\[(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})\]$/
var atom=validChars + '+'
var word="(" + atom + "|" + quotedUser + ")"
var userPat=new RegExp("^" + word + "(\\." + word + ")*$")
var domainPat=new RegExp("^" + atom + "(\\." + atom +")*$")
var matchArray=emailStr.match(emailPat)
if (matchArray==null) {
    alert("Email adres is onjuist (controlleer @ en .)")
    return false
}
var user=matchArray[1]
var domain=matchArray[2]
if (user.match(userPat)==null) {
    alert("Onjuiste gebruikersnaAM.")
    return false
}
var IPArray=domain.match(ipDomainPat)
if (IPArray!=null) {
    // this is an IP address
      for (var i=1;i<=4;i++) {
        if (IPArray[i]>255) {
            alert("Fout op de pagina, neem contact op met de administrator! [email protected].")
        return false
        }
    }
    return true
}
var domainArray=domain.match(domainPat)
if (domainArray==null) {
    alert("Fout op de pagina, neem contact op met de administrator! [email protected].")
    return false
}
var atomPat=new RegExp(atom,"g")
var domArr=domain.match(atomPat)
var len=domArr.length
if (domArr[domArr.length-1].length<2 ||
    domArr[domArr.length-1].length>3) {
   alert("Fout op de pagina, neem contact op met de administrator! [email protected].")
   return false
}
if (len<2) {
   var errStr="Fout op de pagina, neem contact op met de administrator! [email protected]."
   alert(errStr)
   return false
}
return true;
}



  function formValidate(form) {
    
        if (form.username.value == "") {
       alert('U dient een gebruikersnaam op te geven.');
       form.username.focus();
       return false;
       }
       if (form.username.value.length< <? echo $username_len?>) {
       alert('Uw gebruikersnaam moet minstens$ <? echo $username_len;?> karakters lang zijn.');
       form.username.focus();
       return false;
       }
        if((form.username.value.match(/[^a-zA-Z0-9_]/)))
        {
            alert("Uw gebruikersnaam mag alleen bestaan uit alfabetische letters");
            form.username.focus();
            return(false);
        }
      
        if(!form.email_addr.value.match(/[a-zA-Z\.\@\d\_]/)) {
           alert('Foutieve E-Mail adres.');
             form.email_addr.focus();
          return false;
           }
        if (!emailCheck (form.email_addr.value) )
        {
            form.email_addr.focus();
            return (false);
        }
        if(form.email_addr.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven e-mail adres (bijv. &  < >)");
            form.email_addr.focus();
            return(false);
        }

       if(form.fname.value == "" ){
       alert('U dient een voornaam op te geven.');
        form.fname.focus();
          return false;
           }
        if(form.fname.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven voornaam (bijv. &  < >)");
            form.fname.focus();
            return(false);
        }

        if(form.lname.value == "" )
        {
          alert('U dient een achternaam op te geven.');
            form.lname.focus();
        return false;
        }
        if(form.lname.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven voornaam (bijv. &  < >)");
            form.lname.focus();
            return(false);
        }
        if(form.company_name.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karaqkters uit uw opgegeven bedrijfsnaam (bijv. &  < >)");
            form.company_name.focus();
            return(false);
        }
        
        if(form.add1.value == "" && form.add2.value == "")
        {
        alert('Address is required.');
        form.add1.focus();
        return false;
        }
        if(form.add1.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven adres (bijv. &  < >)");
            form.add1.focus();
            return(false);
        }
        if(form.add2.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven adres (bijv. &  < >)");
            form.add2.focus();
            return(false);
        }
        if(form.city.value == "")
        {
        alert('U dient een plaats op te geven');
            form.city.focus();
        return false;
        }
        if(form.city.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven plaats (bijv. &  < >)");
            form.city.focus();
            return(false);
        }

         if(form.state.value== "" )
         {
           alert('U dient een provincie op te geven.');
            form.state.focus();
           return false;
           }
        if(form.state.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven profincie (bijv. &  < >)");
            form.state.focus();
            return(false);
        }
        
        if(form.zip_code.value == "")
        {
           alert('U dient een postcode op te geven.');
            form.zip_code.focus();
           return false;
        }
        if(form.zip_code.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven postcode (bijv. &  < >)");
            form.zip_code.focus();
            return(false);
        }

        if(form.country.selectedIndex == 0)
        {
          alert('U dient een land te selecteren.');
            form.country.focus();
        return false;
        }
        
        if(form.home_phone.value == "")
        {
           alert('U dient een telefoonnummer op te geven.');
            form.home_phone.focus();
           return false;
        }
        if(form.home_phone.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven telefoonnummer (bijv. &  < >)");
            form.home_phone.focus();
            return(false);
        }
        if(form.work_phone.value.match(/[&<>]+/))
        {
            alert("Haal de foutieve karakters uit uw opgegeven telefoonnummer (bijv. &  < >)");
            form.work_phone.focus();
            return(false);
        }
        
    if (form.pwd.value == "") {
       alert('U dient een wachtwoord op te geven.');
            form.pwd.focus();
       return false;
       }
    if (form.pwd.value.length<<? echo $pwd_len;?>) {
       alert('Uw wachtwoord dient minstens <? echo $pwd_len;?> karakters lang te zijn.');
            form.pwd.focus();
       return false;
       }        
    if (form.pwd.value != form.pwd2.value)
    {
        alert('De opgegeven wachtwoorden verschillen van elkaar.');
        form.pwd2.value="";
        form.pwd.focus();
        form.pwd.select();
        return false;
    }

      
    return true;
  }
// -->
</SCRIPT>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
  
  <tr>
    <td valign="top">&nbsp;</td>
  </tr>
  <tr>
    <td valign="top"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#0099FF">
        <tr>
          <td height="25" bgcolor="#FFFFFF"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>&nbsp;<strong><img src="images/side_bullet.gif" width="13" height="14" align="absmiddle"></strong>
            <font color="#006699">Registreren</font></b></font></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><FORM name=register onsubmit=return(formValidate(this));
                  method=post action="insertmember.php">
              <TABLE width=100% border=0 align="center" cellPadding=1  cellSpacing=1 class="onepxtable">
                <TR>
                  <TD width="50%" height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Gebruikersnaam
                    </B></font></TD>
                  <TD align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                  <TD> <INPUT style="FONT-FAMILY: courier, monospace"
                        maxLength=20 size=15 name=username >
                    <font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"  ><br>
                    <font face="Arial, Helvetica, sans-serif">moet minstens
                    <? echo $username_len;?> </font><font size="1" face="Verdana, Arial, Helvetica, sans-serif" ><font size="1" face="Verdana, Arial, Helvetica, sans-serif"  ><font face="Arial, Helvetica, sans-serif">
                    karakters lang zijn</font></font></font> </font></TD>
                </TR>
                <TR>
                  <TD height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>E-mail
                    adres</B></font></TD>
                  <TD align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                  <TD><INPUT style="FONT-FAMILY: courier, monospace"
                        maxLength=99 size=25 name=email_addr value="<? echo $email;?>"> <font size="1" face="Verdana, Arial, Helvetica, sans-serif"><br>
                    </font></TD>
                </TR>
                <TBODY>
                  <TR>
                    <TD height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Voor en Achternaam</B></font></TD>
                    <TD align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                    <TD valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td width="49%"><input style="FONT-FAMILY: courier, monospace"
                        maxlength=120 size=20 name=fname value="<? echo $fname;?>"></td>
                          <td width="51%"><input
                        name=lname style="FONT-FAMILY: courier, monospace" size="20" value="<? echo $lname;?>">
                          </td>
                        </tr>
                        <tr>
                          <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Voornaam</font></td>
                          <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Achternaam</font></td>
                        </tr>
                      </table>
                      
                    </TD>
                  </TR>
                  <TR>
                    <TD width="44%" height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Bedrijf<br>
                      <font color="#003366" size="1"> </font> </B></font></TD>
                    <TD width="2%" align=left valign="top">&nbsp;</TD>
                    <TD><INPUT style="FONT-FAMILY: courier, monospace"
                        maxLength=120 size=25 name=company_name value="<? echo $c_name;?>"></TD>
                  </TR>
                  <TR>
                    <TD width="44%" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Adres<br>
                      </B></font></TD>
                    <TD width="2%" align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                    <TD><INPUT style="FONT-FAMILY: courier, monospace"
                        maxLength=120 size=35 name=add1 value="<? echo $add1;?>"> <br> <INPUT style="FONT-FAMILY: courier, monospace"
                        maxLength=120 size=35 name=add2 value="<? echo $add2;?>"></TD>
                  </TR>
                  <TR>
                    <TD width="44%" height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Plaats en Provincie<br>
                      </B></font></TD>
                    <TD width="2%" align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                    <TD><INPUT style="FONT-FAMILY: courier, monospace"
                        maxLength=120 size=20 name=city value="<? echo $city;?>">
                      ,
                      <input
                        name=state style="FONT-FAMILY: courier, monospace" size="20" value="<? echo $state;?>"></TD>
                  </TR>
                  <TR>
                    <TD width="44%" height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Postcode<br>
                      </B></font></TD>
                    <TD width="2%" align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                    <TD><INPUT style="FONT-FAMILY: courier, monospace"
                        maxLength=11 size=15 name=zip_code value="<? echo $zip;?>"></TD>
                  </TR>
                  <TR>
                    <TD width="44%" height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Land<br>
                      </B></font></TD>
                    <TD width="2%" align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                    <TD>
                    <SELECT name=country>
                        <OPTION value=0
                          <? if($country==0) {echo " selected ";}?>>Select a Value
                        <?
                          $country1=mysql_query("select * from sbauctions_country");
                          while($rst= mysql_fetch_array($country1))
                          {
                          ?>
                        <OPTION value=<? echo $rst["id"];?> <? if($rst["id"]==$country) {echo " selected ";}?>><? echo $rst["country"];?></OPTION>
                        <?
                               } // wend
                               ?>
                      </SELECT> </TD>
                  </TR>
                  <TR>
                    <TD width="44%" height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Telefoon Nummer Huis<br>
                      </B></font></TD>
                    <TD width="2%" align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                    <TD><INPUT style="FONT-FAMILY: courier, monospace"
                        maxLength=20 size=15 name=home_phone value="<? echo $home_phone;?>">
                      <font size="1" face="Verdana, Arial, Helvetica, sans-serif"><br>
                      <font face="Arial, Helvetica, sans-serif">(voorbeeld: 012-3456789)
                      </font></font></TD>
                  </TR>
                  <TR>
                    <TD height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Telefoon Nummer Werk<br>
                      </B></font></TD>
                    <TD align=left valign="top">&nbsp;</TD>
                    <TD><INPUT style="FONT-FAMILY: courier, monospace"
                        maxLength=20 size=15 name=work_phone value="<? echo $work_phone;?>">
                      <font size="1" face="Verdana, Arial, Helvetica, sans-serif"><br>
                      <font face="Arial, Helvetica, sans-serif">(voorbeeld: 012-3456789)
                      </font></font></TD>
                  </TR>
                  <TR>
                    <TD height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><b>Wachtwoord<br>
                      </b></font></TD>
                    <TD align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                    <TD><INPUT type=password style="FONT-FAMILY: courier, monospace"
                        maxLength=20 size=15 name=pwd>
                      <font size="1" face="Verdana, Arial, Helvetica, sans-serif"  ><br>
                      <font face="Arial, Helvetica, sans-serif">moet minstens
                      <? echo $pwd_len;?> karakters lang zijn.</font></font></TD>
                  </TR>
                  <TR>
                    <TD height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><B>Bevestig Wachtwoord<br>
                      </B></font></TD>
                    <TD align=left valign="top"><FONT color=red
                        size=1>*</FONT></TD>
                    <TD><INPUT type=password style="FONT-FAMILY: courier, monospace"
                        maxLength=20 size=15 name=pwd2>
                      <font size="1" face="Verdana, Arial, Helvetica, sans-serif"  ><br>
                      <font face="Arial, Helvetica, sans-serif">moet minstens
                      <? echo $pwd_len;?> karakters lang zijn.</font></font></TD>
                  </TR>
                  <TR>
                    <TD height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif"><b>Voorwaarden</b></font></TD>
                    <TD align=left valign="top">&nbsp;</TD>
                    <TD><font size="1" face="Arial, Helvetica, sans-serif">Registreren bij ons betekent dat u akkoord gaat met de voorwaarden, u kunt de voorwaarden <a onClick="return openpopup('static_pages/terms.htm');"  class="sidelink"  href="">hier</a> vinden</font></TD>
                  </TR>
                  <TR>
                    <TD width="44%" height="25" align=left valign="top" bgcolor="#f4f4f4"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font></TD>
                    <TD width="2%" align=left valign="top">&nbsp;</TD>
                    <TD><INPUT type=submit value=Submit name=submit>
                      &nbsp;</TD>
                  </TR>
                </TBODY>
              </TABLE>
            </form></td>
        </tr>
      </table>
      <p>&nbsp;</p></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<?
}// end main
include "template.php";
?>

<?
include_once "left_cats.php";
include_once "myconnect.php";
            if (!get_magic_quotes_gpc()) {
            $username=str_replace('$', '\$',addslashes($_REQUEST["username"]));
            $fname=str_replace('$', '\$',addslashes($_REQUEST["fname"]));
            $lname=str_replace('$', '\$',addslashes($_REQUEST["lname"]));
            $c_name=str_replace('$', '\$',addslashes($_REQUEST["company_name"]));
            $add1=str_replace('$', '\$',addslashes($_REQUEST["add1"]));
            $add2=str_replace('$', '\$',addslashes($_REQUEST["add2"]));
            $city=str_replace('$', '\$',addslashes($_REQUEST["city"]));
            $state=str_replace('$', '\$',addslashes($_REQUEST["state"]));
            $zip=str_replace('$', '\$',addslashes($_REQUEST["zip_code"]));
            $country=str_replace('$', '\$',addslashes($_REQUEST["country"]));
            $home_phone=str_replace('$', '\$',addslashes($_REQUEST["home_phone"]));
            $work_phone=str_replace('$', '\$',addslashes($_REQUEST["work_phone"]));
            $email=str_replace('$', '\$',addslashes($_REQUEST["email_addr"]));
            $pwd=str_replace('$', '\$',addslashes($_REQUEST["pwd"]));
            }
            else
            {
            $username=str_replace('$', '\$',$_REQUEST["username"]);
            $fname=str_replace('$', '\$',$_REQUEST["fname"]);
            $lname=str_replace('$', '\$',$_REQUEST["lname"]);
            $c_name=str_replace('$', '\$',$_REQUEST["company_name"]);
            $add1=str_replace('$', '\$',$_REQUEST["add1"]);
            $add2=str_replace('$', '\$',$_REQUEST["add2"]);
            $city=str_replace('$', '\$',$_REQUEST["city"]);
            $state=str_replace('$', '\$',$_REQUEST["state"]);
            $zip=str_replace('$', '\$',$_REQUEST["zip_code"]);
            $country=str_replace('$', '\$',$_REQUEST["country"]);
            $home_phone=str_replace('$', '\$',$_REQUEST["home_phone"]);
            $work_phone=str_replace('$', '\$',$_REQUEST["work_phone"]);
            $email=str_replace('$', '\$',$_REQUEST["email_addr"]);
            $pwd=str_replace('$', '\$',$_REQUEST["pwd"]);
            }

$sql=mysql_query("select username from sbauctions_members where (username='$username' or email='$email')");
$rst=mysql_fetch_array($sql);

if($rst)
{
function main()
{

if (!get_magic_quotes_gpc())
{
    $username=str_replace('$', '\$',addslashes($_REQUEST["username"]));
    $email=str_replace('$', '\$',addslashes($_REQUEST["email_addr"]));
}
else
{
    $username=str_replace('$', '\$',$_REQUEST["username"]);
    $email=str_replace('$', '\$',$_REQUEST["email_addr"]);
}
$sql=mysql_query("select username,email from sbauctions_members where (username='$username' or email='$email')");
$rst=mysql_fetch_array($sql);
$msg1="";
$username=$_REQUEST["username"];
$fname=$_REQUEST["fname"];
$lname=$_REQUEST["lname"];
$c_name=$_REQUEST["company_name"];
$add1=$_REQUEST["add1"];
$add2=$_REQUEST["add2"];
$city=$_REQUEST["city"];
$state=$_REQUEST["state"];
$zip=$_REQUEST["zip_code"];
$country=$_REQUEST["country"];
$home_phone=$_REQUEST["home_phone"];
$work_phone=$_REQUEST["work_phone"];
$email=$_REQUEST["email_addr"];

if($rst["email"]==$_REQUEST["email_addr"])
{
$msg1=" er bestaat al een gebruiker met de door u gekozen email adres: <b>$email</b>.";
}
else
{
$msg1=" er bestaat al een gebruiker met de door u gekozen gebruikersnaam: <b>$username</b>.";
}            

?>
<div align="center">
<br><br><br><br>
<table width="400" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">Sorry,
          <? echo $msg1;?></font></div></td>
  </tr><tr><form action="signup.php" method="post">
    <td> <div align="center">
            <input type="hidden" name="fname" value="<? echo $fname;?>">
            <input type="hidden" name="lname" value="<? echo $lname;?>">
            <input type="hidden" name="company_name" value="<? echo $c_name;?>">
            <input type="hidden" name="add1" value="<? echo $add1;?>">
            <input type="hidden" name="add2" value="<? echo $add2;?>">
            <input type="hidden" name="city" value="<? echo $city;?>">
            <input type="hidden" name="state" value="<? echo $state;?>">
            <input type="hidden" name="zip_code" value="<? echo $zip;?>">
            <input type="hidden" name="country" value="<? echo $country;?>">
            <input type="hidden" name="home_phone" value="<? echo $home_phone;?>">
            <input type="hidden" name="work_phone" value="<? echo $work_phone;?>">
            <input type="hidden" name="email_addr" value="<? echo $email;?>">
            <input name="Submit" type="submit" value="Back" >
      </div></td>
  </form></tr>

  <tr>
    <td> </td>
  </tr>
</table>
</div>
<?
}
include_once "template.php";
}
else
{


mysql_query("INSERT INTO sbauctions_members (c_name,add1,add2,city,state,zip,country,home_phone,work_phone,email,username,pwd,fname,lname,logo_url,store_title,store_desc)
VALUES('$c_name','$add1','$add2','$city','$state','$zip','$country','$home_phone','$work_phone','$email','$username','$pwd','$fname','$lname','','','')");


              
/////////////getting null char
    $null_char=mysql_fetch_array(mysql_query("select null_char from sbauctions_config"));
/////////////getting Site Root
    $site_root=mysql_fetch_array(mysql_query("select site_root from sbauctions_config"));
/////////////////getting bonus amount
    $bonus=mysql_fetch_array(mysql_query("select bonus from sbauctions_config"));
//Gets member info
$sql = "SELECT max(id) FROM sbauctions_members" ;
$rs_query=mysql_query($sql);
$rs=mysql_fetch_array($rs_query);
$uid=$rs[0];
if($bonus["bonus"]>0)
{
mysql_query("insert into sbauctions_transactions (uid,amount,description,date_submitted) values
($uid,".$bonus["bonus"].",'Registratie Bonus','".date("Ymdhis".time())."')");
}
//SENDING MAIL TO MEMBER////////////////////////

$rs0=mysql_fetch_array(mysql_query("select * from sbauctions_members where id=" . $uid));
$login_url=$site_root[0]."/signinform.php";

//Reads email to be sebt
$sql = "SELECT * FROM sbauctions_mails where id=1" ;
$rs_query=mysql_query($sql);

if ( $rs=mysql_fetch_array($rs_query)  )
  {
             $from =$rs["fromid"];
             $to = $rs0["email"];
             $subject =$rs["subject"];
             $header="Van:" . $from . "\r\n" ."Contact:". $from  ;

      $body=str_replace("<fname>",$rs0["fname"],str_replace("<lname>",$rs0["lname"],str_replace("<email>",$rs0["email"],str_replace("<username>",$rs0["username"],str_replace("<password>",$rs0["pwd"],str_replace("<loginurl>",$login_url,$rs["mail"])))))) ;
    
     $body=str_replace("<productname>",$null_char[0],str_replace("<producturl>",$null_char[0],str_replace("<noofbids>",$null_char[0],str_replace("<currentbid>",$null_char[0],str_replace("<bidder_username>",$null_char[0],str_replace("<expired_date>",$null_char[0],$body))))));
      
     $body=str_replace("<message_text>",$null_char[0],str_replace("<message_title>",$null_char[0],str_replace("<sender_username>",$null_char[0],str_replace("<message_time>",$null_char[0],str_replace("<message_date>",$null_char[0],$body)))));
    
     //echo "<pre>$body</pre>";
    
     mail($to,$subject,$body,$header);
  }

//////////////////////////////////////////////////////////

//echo "Locatie:"."signinform.php?msg=".urlencode("U bent succesvol geregistreerd") ;
header("Locatie:"."signinform.php?msg=".urlencode("U bent succesvol geregistreerd"));
die();
}
?>