<?
$controle = $HTTP_POST_VARS['controle'];
$senha = $HTTP_POST_VARS['senha'];
$senha1 = $HTTP_POST_VARS['senha1'];
$titulo = $HTTP_POST_VARS['titulo'];
$email = $HTTP_POST_VARS['email'];
$display = $HTTP_POST_VARS['display'];
$cidade = $HTTP_POST_VARS['cidade'];
$estado = $HTTP_POST_VARS['estado'];
$pais = $HTTP_POST_VARS['pais'];
$sexo = $HTTP_POST_VARS['sexo'];
$dianas = $HTTP_POST_VARS['dianas'];
$mesnas = $HTTP_POST_VARS['mesnas'];
$anonas = $HTTP_POST_VARS['anonas'];
$pagina = $HTTP_POST_VARS['pagina'];
$obs = $HTTP_POST_VARS['obs'];
$bgcol = $HTTP_POST_VARS['bgcol'];
$textcol = $HTTP_POST_VARS['textcol'];
$linkcol = $HTTP_POST_VARS['linkcol'];
$textsize = $HTTP_POST_VARS['textsize'];
if($textsize>10 || $textsize<1){
	$textsize=10;
}
$navcol = $HTTP_POST_VARS['navcol'];
$guestmail = $HTTP_POST_VARS['guestmail'];

if($controle=="instalar"){
	if($senha==$senha1){
		$senha=md5($senha);
		if($email!=NULL && $display!=NULL && $cidade!=NULL && $estado!=NULL && $pais!=NULL && $bgcol!=NULL && $textcol!=NULL && $linkcol!=NULL && $textsize!=NULL && $navcol!=NULL && $guestmail!=NULL)
		{
include "classe.php";

$objeto = new conexaobd();
$objeto->conectar();

$objeto2 = new consulta();
$objeto2->query2("create table flashflog(titulo varchar(100), data varchar(20), tipo int(3) not null, comentario blob, primary key(data)););");

$objeto2->query2("create table guestlog(data timestamp, datapost timestamp, nome varchar(100) not null, link varchar(255) not null, comentario blob not null)");

$objeto2->query2("create table linklog(alias varchar(100), endereco varchar(255));");

$objeto2->query2("create table pessoalog(titulo varchar(100), senha varchar(32) not null,email varchar(100) not null, display int(1) not null, cidade varchar(100) not null, estado varchar(2) not null, pais varchar(100) not null, sexo int(1), dianas int(2), mesnas int(2) not null, anonas int(4), pagina varchar(255), obs blob, bgcol varchar(6) not null, textcol varchar(6) not null, linkcol varchar(6) not null, textsize int(2) not null, navcol int(2) not null, guestmail int(1) not null);");

$objeto2->query2("create table acessolog(id int(20) not null, primary key(id));");

$objeto2->query2("insert into pessoalog (titulo, senha, email, display, cidade, estado, pais, sexo, dianas, mesnas, anonas, obs, bgcol, textcol, linkcol, textsize, navcol, guestmail) values ('$titulo', '$senha', '$email' , $display, '$cidade', '$estado', '$pais', $sexo, $dianas, $mesnas, $anonas, '$obs', '$bgcol', '$textcol', '$linkcol', $textsize, $navcol, $guestmail);");
echo "<BR>Agora apague este arquivo.";
		}else{
			echo "Algum campo Obrigat�rio vazio";
		}
	}else{
		echo "Senha Inv�lida";
	}
}else{
?>
<HTML>
<HEAD>
<TITLE>
Instalando o Flashflog
</TITLE>
</HEAD>
<BODY>
<FORM METHOD=POST ACTION="instal.php">
<INPUT TYPE="hidden" NAME="controle" value="instalar">
<TABLE>
<TR>
	<TD>Titulo:</TD>
	<TD><INPUT TYPE="text" NAME="titulo"></TD>
</TR>
<TR>
	<TD>* Senha:</TD>
	<TD><INPUT TYPE="password" NAME="senha"></TD>
</TR>
<TR>
	<TD>* Repita a senha:</TD>
	<TD><INPUT TYPE="password" NAME="senha1"></TD>
</TR>
<TR>
	<TD>* Email:</TD>
	<TD><INPUT TYPE="text" NAME="email"></TD>
</TR>
<TR>
	<TD>* Deseja Mostrar o Email:</TD>
	<TD>Sim: <INPUT TYPE="radio" NAME="display" value=1>&nbsp;&nbsp;&nbsp;N�o: <INPUT TYPE="radio" NAME="display" value=0 CHECKED></TD>
</TR>
<TR>
	<TD>* Cidade:</TD>
	<TD><INPUT TYPE="text" NAME="cidade"></TD>
</TR>
<TR>
	<TD>* Estado:</TD>
	<TD>
	<select name="estado">
		<option value="AC">AC</option>
		<option value="AL">AL</option>
		<option value="AM">AM</option>
		<option value="AP">AP</option>
		<option value="BA">BA</option>
		<option value="CE">CE</option>
		<option value="DF">DF</option>
		<option value="ES">ES</option>
		<option value="GO">GO</option>
		<option value="MA">MA</option>
		<option value="MG">MG</option>
		<option value="MS">MS</option>
		<option value="MT">MT</option>
		<option value="PA">PA</option>
		<option value="PB">PB</option>
		<option value="PE">PE</option>
		<option value="PI">PI</option>
		<option value="PR">PR</option>
		<option value="RJ">RJ</option>
		<option value="RN">RN</option>
		<option value="RO">RO</option>
		<option value="RR">RR</option>
		<option value="RS">RS</option>
		<option value="SC">SC</option>
		<option value="SE">SE</option>
		<option value="SP">SP</option>
		<option value="TO">TO</option>
		</select>
	</TD>
</TR>
<TR>
	<TD>* Pais:</TD>
	<TD><INPUT TYPE="text" NAME="pais" value=Brasil></TD>
</TR>
<TR>
	<TD>Sexo:</TD>
	<TD>Mas: <INPUT TYPE="radio" NAME="sexo" value=1>&nbsp;&nbsp;&nbsp;Fem: <INPUT TYPE="radio" NAME="sexo" value=0></TD>
</TR>
<TR>
	<tr> 
      <td>Data do Nascimento:</td>
      <td><SELECT NAME="dianas">
			<OPTION> </OPTION>
			<OPTION SELECTED VALUE="01">01</OPTION>
			<OPTION value="02">02</OPTION>
			<OPTION value="03">03</OPTION>
			<OPTION value="04">04</OPTION>
			<OPTION value="05">05</OPTION>
			<OPTION value="06">06</OPTION>
			<OPTION value="07">07</OPTION>
			<OPTION value="08">08</OPTION>
			<OPTION value="09">09</OPTION>
			<OPTION value="10">10</OPTION>
			<OPTION value="11">11</OPTION>
			<OPTION value="12">12</OPTION>
			<OPTION value="13">13</OPTION>
			<OPTION value="14">14</OPTION>
			<OPTION value="15">15</OPTION>
			<OPTION value="16">16</OPTION>
			<OPTION value="17">17</OPTION>
			<OPTION value="18">18</OPTION>
			<OPTION value="19">19</OPTION>
			<OPTION value="20">20</OPTION>
			<OPTION value="21">21</OPTION>
			<OPTION value="22">22</OPTION>
			<OPTION value="23">23</OPTION>
			<OPTION value="24">24</OPTION>
			<OPTION value="25">25</OPTION>
			<OPTION value="26">26</OPTION>
			<OPTION value="27">27</OPTION>
			<OPTION value="28">28</OPTION>
			<OPTION value="29">29</OPTION>
			<OPTION value="30">30</OPTION>
			<OPTION value="31">31</OPTION>
			</SELECT>
			<SELECT NAME="mesnas">
			<OPTION> </OPTION>
			<OPTION VALUE="1">01</OPTION>
			<OPTION value="2">02</OPTION>
			<OPTION value="3">03</OPTION>
			<OPTION value="4">04</OPTION>
			<OPTION value="5">05</OPTION>
			<OPTION value="6">06</OPTION>
			<OPTION value="7">07</OPTION>
			<OPTION value="8">08</OPTION>
			<OPTION value="9">09</OPTION>
			<OPTION value="10">10</OPTION>
			<OPTION value="11">11</OPTION>
			<OPTION value="12">12</OPTION>
			</SELECT>
			<input type="text" name="anonas" size=4 MAXLENGHT=4>
	  </td>
    </tr>
<TR>
	<TD>Sobre Voc�:</TD>
	<TD><TEXTAREA NAME="obs" ROWS="" COLS=""></TEXTAREA></TD>
</TR>
<TR>
	<TD>* Cor de Fundo #:</TD>
	<TD><INPUT TYPE="text" NAME="bgcol" value="FFFFFF"></TD>
</TR>
<TR>
	<TD>* Cor do Texto #:</TD>
	<TD><INPUT TYPE="text" NAME="textcol" value="000000"></TD>
</TR>
<TR>
	<TD>* Cor do Link #:</TD>
	<TD><INPUT TYPE="text" NAME="linkcol" value="0000FF"></TD>
</TR>
<TR>
	<TD>* Tamanho da Fonte do T�tulo: (max 10)</TD>
	<TD><INPUT TYPE="text" NAME="textsize" value="2" size=2 MAXLENGHT=2></TD>
</TR>
<TR>
	<TD>* Barra de Navega��o:</TD>
	<TD><SELECT NAME="navcol">
	<OPTION VALUE=1>Cinza</OPTION>
	<OPTION VALUE=0>Seguir o esquema do fotolog</OPTION>
	</SELECT></TD>
</TR>
<TR>
	<TD>* Email quando comentar:</TD>
	<TD>Sim: <INPUT TYPE="radio" NAME="guestmail" value=1>&nbsp;&nbsp;&nbsp;N�o: <INPUT TYPE="radio" NAME="guestmail" value=0 CHECKED></TD>
</TR>
	<TD><INPUT TYPE="submit" value="Enviar"></TD>
	<TD><INPUT TYPE="reset" value="Limpar"></TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
<? 
}
?>